Associação Musical de Évora
Historial
Escola de Música da Sé de Évora
Coro Polifónico
Formação
Programação
Arquivo
Conservatório Regional de Évora
Historial
Educação/Ensino
Cursos
Projeto Educativo
Regulamento Interno
Informações
Horários
Professores
Programação
Notas Musicais
Arquivo
2 a 5 Out. 2008 - Évora - XI Jornadas Internacionais-Escola Música Sé Évora-VER IMAGENS Imprimir e-mail
2 a 5 Outubro de 2008 - XI Jornadas Internacionais "Escola de Música da Sé de Évora                                                                           
cataz_06-09-08-jpg.jpg

VER IMAGENS DOS CONCERTOS

CONCERTOS:

2 Outubro, 21,30h
Concerto na Sé           
“Voces Caelestes”               
Direcção: Sérgio Fontão

3 Outubro, 19,00h
Concerto na Sé            
“Officium – grupo 
vocal"           
Direcção de Pedro Teixeira

4 Outubro, 21,30h
Concerto na Sé             
“A Sei Voci"

5 Outubro, 17,00h
– Concerto Final na Sé (participação do Coro Polifónico “Eborae Mvsica” Direcção de Pedro Teixeira)
e Coro dos Participantes.

OBJECTIVOS:

- Divulgar o espólio da escola de Música da Sé de Évora (sécs. XVI e XVII), (Frei Manuel Cardoso, Duarte Lobo, Diogo Dias Melgaz, Estêvão Lopes Morago, etc…);

- Dar a conhecer formas de abordagem diferentes deste reportório;

- Aprofundar técnicas vocais de interpretação;

- Criar um espaço de intercâmbio de saberes, vivências e culturas;

- Criar um espaço de abertura à participação da Comunidade;

- Estudar e interpretar a obra de Duarte Lobo “Missa Veni Domine”.  

Destinatários: Directores de Coros, Membros de Coros, Profissionais e Amadores de Canto, Professores de Educação Musical, Outros.

Profissionais envolvidos: João Pedro d’Alvarenga, Peter Phillips, Owen Rees, Armando Possante e Pedro Teixeira

Programa:

2 OUT 
9,00 h - Abertura do Secretariado
9,30 h - Sessão de Abertura
10,00 h – Pausa para Café
10,15 h – Conferência pelo Doutor Owen Rees- “Aires Fernandez: um mistério para resolver”
11,15 h – Conferência pelo Doutor João Pedro d’Alvarenga – “António Carreira: as múltiplas chaves de um enigma persistente”
12,15 h – Atelier conjunto
13,15 h – Almoço
14,30 h – Visita guiada pelo Dr. Jorge Raposo à Sé e seus Arquivos
15,30 h – Audições para o Atelier “Aprofundamento da Interpretação”
16,00h – 18,00h – Atelier conjunto
18,15h – 20,00h - Atelier “Aprofundamento da Interpretação”
21,30h – Concerto na Sé de Évora              
“Voces Caelestes”               
Direcção: Sérgio Fontão

3 OUT 

9,00 h - Ateliers
               (Os participantes, divididos em grupos, trabalharão partes da Missa  
               “Veni Domine”, de Duarte Lobo, sob a direcção dos vários Maestros)
12,45 h – Almoço
14,15 – 16,00 h – Ateliers
16,00h – Pausa para café
16,15h - Conversa com os Maestros          
17.15h – 18,30h - Atelier “Aprofundamento da Interpretação”
19,00h – Concerto na Sé de Évora              
“Officium – grupo vocal”               
Direcção de Pedro Teixeira
20,30h – Jantar Convívio (facultativo)

4 OUT

9,00h – Ateliers
12,30h – Almoço
14,15h – 16,45h – Ateliers
18,00h – 20,00h - Atelier “Aprofundamento da Interpretação”
21,30h – Concerto na Sé de Évora              
“A Sei Voci” 

5 OUT 

9,30h – 12,30h – Ateliers
12,30h – Almoço
14,30h- 16,00h – Ensaios (Sé de Évora)
17,00h – Concerto Final na Sé de Évora               
            (participação do Coro Polifónico “Eborae Mvsica”, direcção  
             de Pedro Teixeira)               
             Encerramento oficial das Jornadas e distribuição de Certificados de
             Participação

CONTACTO:

Associação Musical de Évora - Eborae Mvsica

Convento dos Remédios, Av. S. Sebastião
Apartado 2126, 7001 - 901 Évora Portugal 
Este endereço de e-mail está protegido contra spam bots, pelo que o JavaScript terá de estar activado para que possa visualizar o endereço de email
Telef: (+351) 266 746 750
Fax: (+351) 266 701 359

Ficha de Inscrição

FICHA DE INSCRIÇÃO:

Apelido__________________________ Nome______________________

Morada___________________________ E-mail_____________________

Duração da experiência de Canto________________________________

Naipe_______________________________________________________

Leitura de partituras - Sim ou Não___ Formação Musical Sim ou Não____

Taxa de Inscrição: Participante activo 90€; Atelier "Aprofundamento de Interpretação" + 20€ (a participação neste atelier depende da audição no 1.º dia).

Ouvinte 50€; Almoço incluido; Após 31 de Julho e até 15 de Setembro acréscimo de 15€.

Pagamento com cheque n.º_____________________sobre__________

à ordem de  Eborae Musica na importância de____________________,

em anexo, ou transferência para a conta n.º 029700036507230 Caixa Geral de Depósitos, (NIB 003502970003650723076) - IBAN: PT 50003502970003650723076 - BIC/SWIFT: CGDIPTPL 

Profissionais envolvidos:

João Pedro d’Alvarenga nasceu em Lisboa em 1961. Estudos de música no Instituto Gregoriano de Lisboa, 1979-84. Licenciado em Ciências Musicais pela Universidade Nova de Lisboa, 1988. Doutorado em Música e Musicologia pela Universidade de Évora, 2006.Responsável pela Área de Música, depois Centro de Estudos Musicológicos da Biblioteca Nacional de Lisboa, 1991-97. Comissário da Capital Europeia da Cultura '94 para a instalação do Museu da Música em Lisboa, 1993-94.Bolseiro da JNICT e do INIC, 1988-91. Prémio de investigação do Conselho Português da Música, 1993.Co-fundador e membro da Direcção da Associação Portuguesa de Ciências Musicais, 1992-98. Editor da Revista Portuguesa de Musicologia, 1996-98.Autor de edições críticas de música, de livros e de diversos artigos e textos sobre músicos e música em Portugal, instituições, repertórios vocais sacros e de tecla e respectivas fontes, abrangendo os períodos da Idade Média ao início do século XIX.Membro integrado do Centro de História da Arte da Universidade de Évora, 2000-07. Colaborou também, em 2005-06, com a Área de Música Antiga da Escola Superior de Música e das Artes do Espectáculo do Porto.

Peter Phillips dirige os “The Tallis Scholars” e desde sempre dedicou o seu trabalho à Música Sacra da Renascença. Após estudos feitos com David Wulstan e Denis Arnold ganhou experiência de direcção de pequenos grupos vocais juntando em 1973 vozes dos Coros de Capela de Oxford e Cambridge criando “The Tallis Scholars”. Famoso pelas suas gravações premiadas contam-se, entre os autores interpretados, compositores da Escola de Música da Sé de Évora, nomeadamente, Frei Manuel Cardoso. Para além da sua actividade com os “Tallis Scholars”, Peter Phillips colabora desde há muito com a revista Spectator quer como musicólogo, quer como crítico. Também continua a colaborar com formações internacionais: em 1997 esteve em Tóquio como júri de um festival coral e tem trabalhado igualmente em Itália e nos Estados Unidos. É director do Okham International Summer School.

Owen Rees é académico e executante. O seu trabalho como académico tem dado consistência ao seu trabalho como executante. É “Fellow” (membro da direcção) em Música e Organista no Queen's College, de Oxford, dirigindo o “Chapel Choir”, nos repertórios musicais do século XVI ao século XX. Através das suas actividades como director de “A Capella Portuguesa” e do “Cambridge Taverner Choir”, trouxe para as salas de concerto e estúdios de gravação reportórios de música magnífica da Renascença de Portugal e Espanha, incluindo trabalhos desconhecidos ou pouco conhecidos. As suas interpretações destes reportórios foram referidas como “raros exemplos de combinação entre academismo e musicalidade resultando em actuações impressionantes e imediatamente atractivas para o ouvinte”, e foi descrito como “uma das vozes mais enérgicas e persuasivas” neste campo.

Armando Possante iniciou a sua formação musical com 6 anos no Instituto Gregoriano de Lisboa, onde estudou até 1990. Ingressou nesse ano na Escola Superior de Música de Lisboa, onde concluiu o Bacharelato em Direcção Coral, como aluno dos Profs. Christopher Bochmann e Roberto Perez, a Licenciatura em Canto Gregoriano, na classe da Prof. Maria Helena Pires de Matos e, com a classificação máxima, a Licenciatura em Canto na classe do professor Luís Madureira. Foi-lhe atribuida uma bolsa pelo Instituto Politécnico de Lisboa  na condição de melhor aluno desta instituição.  Orientou workshops de música coral no Festival 500 (Canadá), no congresso da Association of British Choral Directors (Inglaterra) e nas Jornadas Internacionais “Escola de Música da Sé de Évora”. Frequentou cursos de Direcção Coral com Bernard Tétu e Heribert Breuer e os cursos da Associação Internacional de Canto Gregoriano em Cremona (Itália) com Nino Albarosa e Johannes Göschl. Participou em masterclasses com os grupos The King’s Singers e Hilliard Ensemble. É director do Grupo Vocal Olisipo. 

Pedro Teixeira nasceu em Lisboa. É licenciado em Direcção Coral pela Escola Superior de Música de Lisboa, onde trabalhou com o Maestro Vasco Pearce de Azevedo. Iniciou os seus estudos musicais na Academia de Amadores de Música em 1981, completando os cursos de Formação Musical, e Análise e Técnicas de Composição com o professor Eurico Carrapatoso. Ingressa na Faculdade de Direito de Lisboa em 1990, mas acaba por optar definitivamente pela música em 1995. Interessara-se entretanto pela prática e direcção de música coral, nomeadamente no Coro da Universidade de Lisboa onde se iniciou na direcção, primeiro como ensaiador de naipe e, posteriormente, como assistente do maestro José Robert.Trabalhou com António Lourenço e Paulo Lourenço no I e II Cursos de Direcção Coral na cidade de Setúbal (Coral Luísa Todi) e com José Robert no XVII e XVIII Cursos Intensivos de Direcção Coral em Torres Novas. Trabalhou com o maestro José Robert durante os quatro anos do Curso de Direcção Coral na Academia de Amadores de Música. Estudou canto na Escola de Música do Conservatório Nacional. Dirigiu no ano 2000 em Košice (Eslováquia) um workshop dedicado à música renascentista da Sé de Évora, a convite do Coro Collegium Technicum.Leccionou Coro na Escola Profissional de Música de Évora, assim como Educação Vocal na Academia de Música de Évora. Foi preparador vocal do Coro de Câmara Ars Nova, dirigido por Francisco d’Orey e é assistente de direcção de José Robert no Coro da Universidade de Lisboa e no Coro de Câmara da Universidade de Lisboa. No Coro Ricercare trabalhou com Paulo Lourenço como maestro adjunto, passando a maestro titular em 2002. É elemento do Coro Gregoriano de Lisboa, no qual é solista.Dirige, desde Março de 1997, o Coro Polifónico Eboræ Musica, em Évora, e, desde Setembro de 2000, o Grupo Coral de Queluz. No mesmo ano funda o Officium – grupo vocal, dedicado à interpretação de polifonia portuguesa dos sécs. XVI/XVII, do qual é director artístico. Recebe em 2002 o prémio “The most promising conductor of Tonen 2002” na Holanda.
 
[ Voltar ]
Destaques
Próximos Eventos
Abril 2024 Maio 2024
Se Te Qu Qu Se Sá Do
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30
Notícias RSS
Newletter




62691303 Visitas

115 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 17 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1713561374' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713561374' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
6
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'com'
 AND type = 2
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
11
SELECT *
 FROM jos_menu
 WHERE id = 17
12
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 214 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 22:31' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 22:31' )
 AND a.access <= 0
13
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '214'
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
16
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
17
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
18
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 17 )
 ORDER BY ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
20
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
21
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
22
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
23
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
24
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
25
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
26
SELECT a.id
 FROM jos_content AS a
 INNER JOIN jos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access  <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 22:31:15') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 22:31:15')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
27
SELECT *
 FROM jos_content
 WHERE id = '1332'
28
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1332
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
29
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
30
SELECT *
 FROM jos_content
 WHERE id = '1333'
31
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1333
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
SELECT *
 FROM jos_content
 WHERE id = '1334'
33
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1334
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
34
SELECT * FROM jos_jcalpro_config
35
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
36
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
37
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
38
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
39
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
40
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
41
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
42
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
43
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
44
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
45
SELECT
  	cat_id, level
  FROM
  	jos_jcalpro_categories
46
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
47
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
48
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
49
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
50
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
51
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
52
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
53
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
54
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
55
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240401 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240401 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240401 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
56
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240401) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
57
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240402 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240402 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240402 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
58
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240402) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
59
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240403 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240403 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240403 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
60
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240403) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
61
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240404 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240404 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240404 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
62
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240404) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
63
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240405 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240405 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240405 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
64
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240405) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
65
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240406 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240406 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240406 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
66
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240406) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
67
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240407 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240407 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240407 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
68
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240407) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
69
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240408 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240408 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240408 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
70
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240408) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
71
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240409 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240409 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240409 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
72
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240409) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
73
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240410 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240410 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240410 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
74
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240410) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
75
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240411 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240411 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240411 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
76
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240411) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
77
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240412 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240412 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240412 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
78
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240412) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
79
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240413 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240413 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240413 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
80
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240413) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
81
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240414 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240414 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240414 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
82
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240414) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
83
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240415 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240415 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240415 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
84
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240415) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
85
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240416 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240416 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240416 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
86
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240416) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
87
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240417 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240417 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240417 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
88
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240417) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
89
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240418 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240418 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240418 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
90
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240418) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
91
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240419 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240419 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240419 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
92
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240419) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
93
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240420 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240420 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240420 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240420) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
95
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240421 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240421 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240421 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
96
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240421) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
97
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240422 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240422 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240422 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
98
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240422) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
99
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240423 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240423 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240423 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
100
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240423) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
101
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240424 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240424 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240424 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
102
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240424) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
103
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240425 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240425 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240425 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
104
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240425) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
105
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240426 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240426 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240426 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240426) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
107
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240427 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240427 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240427 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240427) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
109
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240428 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240428 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240428 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240428) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
111
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240429 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240429 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240429 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
112
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240429) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
113
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240430 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240430 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240430 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
114
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20240430) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
115
SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'