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
Abril 9, 21h30 - Concerto de Páscoa pelo Coro P Eborae Mvsica, na Igreja Espírito Santo Imprimir e-mail

Concerto de Páscoa pelo Coro Polifónico “Eborae Mvsica”
9 de Abril de 2016, 21h30, Igreja do Espirito Santo

cartaz_concerto_pscoa_2016.jpg









































A Associação Eborae Musica promove no dia 09 de Abril de 2016 o Concerto de Páscoa pelo Coro Polifónico Eborae Musica com os solistas Sandra Medeiros (Soprano), António Menezes (Contratenor), Paulo Fernandes (Tenor) e Eduardo Martins (Baixo), e pelo organista Rafael Reis, sob a direção do Maestro Eduardo Martins. O Concerto realiza-se na Igreja do Espírito Santo, em Évora, às 21h30.

Programa: Polifonia da Sé de Évora - De Profundis (Estevão Lopes-Morago), Ecce Mullier Cananeia (Manuel Cardoso), Versa est in luctum (Estevão Lopes-Morago), Ecce Justus (Estevão de Brito), In Jejunio et fletu (Diogo Dias Melgaz); Exomologhiste to Kyrio (Ortodoxa grega), Stabat Mater – n.º I e II (Rheinberger), The Choraliste (Mendelssohn), Ave Verum (Elgar), Missa op.86 em RéM – Kyrie e Sanctus (Dvorák).




Coro Polifónico Eborae Musica - Dirigido atualmente por Eduardo Martins fez em Setembro de 1987 a sua primeira apresentação pública, integrada no acontecimento cultural “Os Povos e as Artes”. O Coro Polifónico tem realizado diversas atuações ao longo da sua existência, interpretando não só polifonia da Escola de Música da Sé de Évora (sécs. XVI e XVII), como também outras obras de diferentes épocas. Destacam-se nas suas atuações a participação nas Jornadas Internacionais “Escola de Música da Sé de Évora”, acontecimento que a Associação Eborae Musica organiza, anualmente no mês de Outubro. Nas deslocações internacionais destaca-se a participação na Europália 91 na Bélgica e a participação no 10º Concurso Internacional de Música Sacra de Preveza, Grécia onde ficou classificado em 3.º lugar, obtendo a medalha de bronze.

 

Maestro Eduardo Martins – Foi aluno do Conservatório de Música de Aveiro Calouste Gulbenkian em piano, tendo concluído o respetivo curso já no Conservatório de Música de Coimbra. Licenciado em Direção Coral e Formação Musical na Escola Superior de Música de Lisboa, encontra-se neste momento a frequentar o mestrado em Direção Coral com os maestros Paulo Lourenço e Alberto Roque, sendo maestro assistente do Coro de Câmara da mesma escola (ESML). Foi Diretor Artístico do Grupo Coral Laudamus – Ovar (1999-2011) e Coro de Letras da Universidade de Coimbra (2004-2006). Atualmente dirige o Grupo Coral ViVaVoz – Oeiras, Coro Tejo e Coro Sacro da ESML – Lisboa, Coro da Universidade de Lisboa e o Coro Polifónico Eborae Musica (desde 2013).

Sandra Medeiros - Licenciada em Canto pela Escola Superior de Música de Lisboa tendo integrado a classe da professora Joana Silva. Como bolseira da Fundação Calouste Gulbenkian e Centro Nacional de Cultura prosseguiu estudos de pós-graduação em canto na Royal Academy of Music (RAM) em Londres, onde se graduou com “Distinção”, obteve o Dip. RAM e o prémio Amanda von Lob memorial Prize. Frequentou cursos de aperfeiçoamento com personalidades do meio musical erudito tais como Ileana Cotrubas, Teresa Berganza, Marimi del Pozo, Gundula Janowitz, Jill Feldman, entre outras. Foi premiada em concursos nacionais e internacionais de canto dos quais se destaca o 2º Prémio no V Concurso Internacional de Canto Bidu Sayão no Brasil. Gravou para a as rádios Portuguesa, Búlgara e Inglesa e para as televisões Portuguesa, Espanhola e Brasileira. Editou os trabalhos discográficos Tons de azul (DRAC-1998) com o grupoAzul e 18th Century Portuguese Love Songs (Hyperion Records-2012) com L’Aventura London, tendo este último recebido excelente crítica nacional (jornal Público, 5 estrelas e entre os 10 melhores Cds de música clássica de 2012) e internacional (RevistaDiapason, 5 estrelas; Early Music Today, 5 estrelas e escolha de editor).

Paralelamente à sua atividade artística, tem vindo a desenvolver atividade pedagógica. É regularmente convidada para realizar workshops sobre técnica e saúde vocal (Évora, Santarém), masterclasses de canto (S. Miguel/Açores e Badajoz) e ser membro de júri de concursos de canto em Portugal. Presentemente integra o corpo docente da Escola do Conservatório Regional de Évora - Eborae Musica, como professora das classes de canto e coro.

António Lourenço Menezes - Natural de Minde é neste momento finalista da licenciatura em Direção Coral e Formação Musical na Escola Superior de Música de Lisboa, frequentando ainda o primeiro ano do curso de canto na Escola de Música do Conservatório Nacional. Entre Setembro e Dezembro de 2014 esteve em Regime Erasmus no Zoltán Kodály Pedagogical Institute em Kecskemét (Hungria). É maestro do A Cappella Ensemble e do Grupo Coral Vozes do Castelo. Foi membro do Coro de Câmara da ESML e Charales Chorus, e atualmente é coralista do Coro Ricercare e Coro Sacro da ESML, colaborando na Direção Artística deste último desde Novembro de 2015.

Paulo Fernandes - Natural de Évora, começou os seus estudos musicais oficiais em Coimbra no curso de canto do Conservatório dessa cidade tendo feito audição final já em Évora com a Professora Natasa Pinto no Conservatório Regional Eborae Musica. Foi aluno das Professoras Sandra Medeiros, Joana Godinho e Joana Nascimento e participou em classes da Professora Joana Silva e Professor António Salgado e em várias jornadas da escola de música da Sé de Évora onde foi dirigido pelos Maestros Pedro Teixeira, Armando Possante, Paulo Lourenço, entre outros. Foi membro do Orfeon Académico de Coimbra e é tenor no Coro Polifónico “Eborae Musica” sendo regido pelo Maestro Eduardo Martins. Participou ainda em projetos de música popular e moderna como autor, cantor ou instrumentista. É licenciado em engenharia electrotécnica e de computadores pela Faculdade de Ciências da Universidade de Coimbra e funcionário da Câmara Municipal de Évora, sendo a música a sua verdadeira vocação e paixão.

Rafael Reis - Concluiu o curso complementar de órgão na Academia de Música Eborense, onde estudou órgão com João Paulo Janeiro. É licenciado em música pela Universidade de Évora área específica de órgão onde estudou com João Vaz. Estuda no mestrado em órgão na Universidade de Évora. Participou no XXI Cursos Internacionais de Música da Casa de Mateus, no Curso de Música Antiga, com Jacques Ogg – Cravo e música de Câmara. Frequentou vários cursos Internacionais de música antiga dirigidos por Andrea Marcon, e Willem Jansen. É diplomado pela “Accademia Internazionale di Musica per Organo S. Martino” de Bologna, no curso de literatura Organística Italiana onde estudou com Luigi Ferdinando Tagliavini.Actualmente é Organista na Sé de Évora e na igreja de S. Francisco em Évora e é professor de Órgão no Conservatório Regional de Évora-Eborae Mvsica.

 

Este concerto é organizado pela Associação Eborae Musica, estrutura financiada pelo Ministério da Educação. Apoios: Câmara Municipal de Évora, Arquidiocese de Évora, Diário do Sul, Rádio Diana, Antena2, A Defesa, Registo.

 
[ 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




63155307 Visitas

114 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 < '1714111731' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1714111731' )
 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 = 974 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 07:23' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 07:23' )
 AND a.access <= 0
13
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '974'
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
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'
16
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
17
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
18
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
20
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
21
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
22
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
23
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
24
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
25
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-26 07:23:52') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 07:23:52')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
26
SELECT *
 FROM jos_content
 WHERE id = '1332'
27
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
28
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
29
SELECT *
 FROM jos_content
 WHERE id = '1333'
30
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
31
SELECT *
 FROM jos_content
 WHERE id = '1334'
32
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
33
SELECT * FROM jos_jcalpro_config
34
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
35
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
36
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
37
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
38
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
39
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
40
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
41
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
42
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
43
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
44
SELECT
  	cat_id, level
  FROM
  	jos_jcalpro_categories
45
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
46
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
47
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
48
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
49
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
50
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
51
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
52
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
53
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
54
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
55
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
56
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
57
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
58
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
59
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
60
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
61
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
62
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
63
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
64
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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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
78
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
79
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
80
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
81
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
82
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
83
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
84
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
85
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
86
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
87
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
88
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
89
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
90
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
91
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
92
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
93
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
94
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
95
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
96
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
97
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
98
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
99
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
100
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
101
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
102
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
103
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
104
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
105
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
106
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
107
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
108
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
109
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
110
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
111
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
112
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
113
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
114
SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'