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
Jul 14, 21h30 - Ópera “Orfeo ed Eurídice”. A NÃO PERDER! Imprimir e-mail

XIX Ciclo de Concertos "Música e outras Artes nos Claustros"

Prossegue com Ópera “Orfeo ed Euridice”
opera_18.jpg
















































A Associação Eborae Mvsica realiza, em Julho, o XIX Ciclo de Concertos "Música e outras Artes nos Claustros uma atividade marcada pela originalidade dado que o seu objetivo é articular a música com diferentes formas de expressão artística, com qualidade artística e relevância cultural.

O Ciclo iniciou-se dia 1 de julho, 16h30 com : Conferência/Colóquio pela Professora Ana Telles “A Música e as outras Artes”; 18h00: Concerto por “Seven Dixie”; 18h30: Inauguração da Exposição de Fotografia e Som “Claustrofonia”, de António Carrapato com Sonoplastia de João Bacelar. Esta Exposição sobre o tema do ciclo, onde são apresentadas vinte fotografias de vários claustros de Évora, tendo cada  uma o ambiente sonoro em que foi feita, pode ser visitada das 9h00 às 12h30 e das 14h00 às 18h00, de segunda a sexta e das 21h30 às 23h00 nos dias de espetáculos.

No dia 6 de julho às 21h30 teve lugar um Concerto pela Orquestra de Câmara de Cascais e Oeiras e no dia 7 de julho às 21h30 um espetáculo  “Bonecos e Campaniça” por  Manuel Dias (Trulé) e Tozé Bexiga. 

O ciclo prossegue dia 14 de julho às 21h30 com a  Ópera “Orfeo ed Eurídice” com a participação do Coro  “Eborae Mvsica”, solistas e instrumentistas da Universidade de Évora”, onde o Coro Polifónico integra o elenco da ópera “Orfeo ed Euridice”, uma das óperas mais aclamadas do compositor alemão Christoph Gluck, em que o coro desempenha um papel importante, com os solistas Marta Marques – mezzo soprano (Orfeo), Marília Zangrandi - soprano (Eurídice) e Inês Pinto -  soprano (Amore), pianista Eduardo Proença, encenação de Joana Leonardo. Direção Eduardo Martins. Coreografia: Joana Leonardo com interpretação de Ana Militão, Bruna Nogueira, Filipa Palhetinha, Inês Lopes e Joana Leonardo.




Marta Marques, 
Mezzo- soprano
Natural do Porto, concluiu a sua licenciatura em Canto Teatral no Conservatório Superior de Música de Gaia nas classes de Fernanda Correia e Sílvia Mateus. Continuou o seu aperfeiçoamento vocal em Itália na associação Florence Opera, a cargo de Patrizia Morandini. Frequenta atualmente o Mestrado em Ensino de Música, vertente Canto, da Universidade de Évora, na classe da professora Liliana Bizineche. Frequentou ainda várias masterclasses e apresentou-se em várias galas de Ópera eventos e espetáculos em Portugal, Itália e Espanha. É coralista profissional tendo já feito parte do Coro do Teatro Nacional de São Carlos, Coro Casa da Música, Coro da Orquestra do Norte e Coro Divino Sospiro.
Marília Zangrandi, Soprano
Soprano brasileira, graduada pela Universidade Federal do Rio de Janeiro, atualmente frequenta o mestrado em performance na Universidade de Évora, Portugal. Em 2016, interpretou a personagem de La Musique na obra Les Plaisirs de Versailles de Charpentie, encenado no Maison de France. Foi premiada como Melhor Intérprete de Canção de Carlos Gomes, em Campinas, no concurso em homenagem ao compositor. Interpretou vários personagens em óperas e participou em várias Masterclasses em Portugal, Brasil, Itália e outros países. Integrou diversos grupos corais, como o Brasil Ensemble, sob a regência de Maria José Chevitaresse, Cia. Bachiana Brasileira, sob a direção de Ricardo Rocha e o Coro Sinfônico da OSB, no qual já esteve sob a direção de Julio Moretzsohn, Isaac Karabtschevsky, Roberto Minczuk e Lorin Maazel.

Inês Pinto, Soprano
Natural do Porto, Inês Pinto concluiu a sua licenciatura de Canto Lírico na Universidade de Évora na classe da Mezzo-soprano, Liliana Bizineche. Trabalhou em várias Masterclasses e aulas privadas com vários professores de Canto. Já foi dirigida por vários Maestros.  É membro de vários Ensembles e Coros. A solo desempenhou vários papéis em várias Óperas. Participou em 2015 no 12º Curso Internacional de Música Antiga ESMAE/ESML realizado no Convento de Mafra e em Agosto do mesmo ano, no XXXVII Festival Internacional de Música Antiga de Daroca, Espanha. Atualmente frequenta o 2º ano de Mestrado em Ensino da Música na Universidade de Évora, vertente Canto Lírico.

Eduardo Proença, Pianista
Eduardo Proença iniciou os seus estudos musicais com professores particulares, e estudou, entre 2005 e 2016, no Instituto Gregoriano de Lisboa, onde concluiu o Curso Secundário de Música e o Curso Secundário de Canto Gregoriano, tendo terminado piano com 19 valores, e obtido o 1º Prémio no Concurso de Piano do IGL (Nível V) em 2014. Frequentou, durante ano e meio, a licenciatura em Composição na ESML. Trabalhou, enquanto pianista acompanhador, para a Associação Musical Lisboa Cantat e para a Universidade de Trás-os-Montes e Alto Douro. Estuda atualmente Piano na Universidade de Évora, integrando a classe da professora Ana Telles. 

Eduardo Martins, Direção Musical
 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. Tem participado em projetos e workshops com figuras de destaque. É licenciado em Direção Coral e Formação Musical, pela Escola Superior de Música em Lisboa (ESML) e Mestre em Direção Coral, vertente Ensino da Música pela Escola Superior de Música de Lisboa (ESML) tendo trabalhado com os professores Paulo Lourenço, Vasco Azevedo e Alberto Roque. Dirigiu vários coros entre os quais o Coral de Letras da Universidade de Coimbra e o Grupo Coral Laudamus – Ovar, e o Coro Sacro e Coro de Câmara da ESML. Atualmente dirige o Coro Polifónico Eborae Musica – Évora, o Grupo Coral ViVaVoz – Oeiras, Coro da Universidade de Lisboa e pontualmente o Coro Tejo – Lisboa. 

Coro Polifónico “Eborae Mvsica”
Em Setembro de 1987, fez a primeira apresentação pública. O Coro Polifónico tem realizado diversas atuações ao longo da sua existência, interpretando não só a polifonia da Escola de Música da Sé de Évora (sécs. XVI e XVII), como também outras obras de diferentes épocas. Gravou o seu primeiro CD, sob a direção do Maestro Francisco d’ Orey, em Novembro de 1996. Gravou, ainda, para a colectânea “Os Melhores Coros da Região” e para o programa “Acontece”, da RTP 2; gravou e produziu em 2005 um novo CD para a etiqueta Numérica, e em 2007 e 2008 gravou para a Antena 2, Concertos Abertos e com a Ronda dos quatro caminhos o CD Solitânia. Realizou várias atuações no País e no estrangeiro sendo de destacar a participação no  22º Festival de Coros de Preveza e 10º Concurso Internacional de Música Sacra de Preveza, Grécia (2004) tendo ficado classificado em 3º lugar obtendo a medalha de bronze. Participou em vários Concertos com Orquestras como a Metropolitana de Lisboa , Orquestra do Norte e Sinfonietta de Lisboa. Em 2012 participou na Ópera “o que diz sim” de Bertold Brecht e Kurt Weill, produzida pela Associação EM. O Coro Polifónico foi dirigido até Outubro de 1991, por Adelino Santos; de 91 e até 97, pelo Maestro Francisco d’Orey, de 97 e até Maio de 2013 pelo Maestro Pedro Teixeira. Desde essa data e até hoje é dirigido pelo Maestro Eduardo Martins.

Joana Leonardo, Encenadora e Coreógrafa
Joana Ferreira Leonardo é Bailarina desde 2010, com formação em diversas escolas em Portugal em dança contemporânea e danças urbanas, e a licenciar-se em Teatro desde 2015, tendo já trabalhado como intérprete em criações de Ana Támen, Paulo Alves Pereira e Alexandre Pieroni Calado.  Desde 2011, bailarina e coreógrafa do grupo NDance, participantes regulares em intercâmbios e competições nacionais e internacionais. Entre 2012 e 2015 vice-presidente da Associação Desportiva, Cultural e Social Qualquer Um Dança, sediada em Évora. Coreógrafa e intérprete de várias peças; Criadora e intérprete da performance "Quem Sou Eu, Sendo o Outro?» em colaboração com o artista plástico Vasco Araújo (Évora, 2017).

O Ciclo continua dia 21 de julho às 21h30 – “Poesia e Guitarra” por Rui Nuno e Eurico Pereira, com poemas de Federico Garcia Lorca; Dia 22 de julho às 21h30 – Espetáculo de Dança com Música pela Companhia “Sentidos Ilimitados” (bailarinos e instrumentistas) e dia 29 de julho às 21h30 – Recital de Canto e Piano por Valérie Vervoort e Jill Lawson com obras de W. A. Mozart.

A Organização é da Associação Eborae Musica entidade financiada pelo Ministério da Cultura- DGArtes em conjunto com as alunas de mestrado em Canto e Teatro da Universidade de Évora, Câmara Municipal de Évora, Projeto “Artes à Rua”, Diário do Sul, A Defesa, Registo e Rádio Diana. Este Ciclo tem o apoio do Programa ALENTEJO 2020.

 
Destaques
Próximos Eventos
Maio 2024 Junho 2024 Julho 2024
Se Te Qu Qu Se 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




75272484 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 < '1730418935' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1730418935' ) 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 = 1133 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-01 00:10' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-01 00:10' ) AND a.access <= 0
13 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '1133'
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-11-01 00:10:36') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-01 00:10:36') 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') <= 20240601 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240601 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240601 ) ) 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') <= 20240601) 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') <= 20240602 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240602 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240602 ) ) 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') <= 20240602) 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') <= 20240603 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240603 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240603 ) ) 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') <= 20240603) 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') <= 20240604 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240604 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240604 ) ) 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') <= 20240604) 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') <= 20240605 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240605 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240605 ) ) 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') <= 20240605) 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') <= 20240606 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240606 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240606 ) ) 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') <= 20240606) 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') <= 20240607 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240607 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240607 ) ) 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') <= 20240607) 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') <= 20240608 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240608 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240608 ) ) 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') <= 20240608) 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') <= 20240609 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240609 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240609 ) ) 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') <= 20240609) 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') <= 20240610 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240610 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240610 ) ) 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') <= 20240610) 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') <= 20240611 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240611 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240611 ) ) 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') <= 20240611) 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') <= 20240612 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240612 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240612 ) ) 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') <= 20240612) 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') <= 20240613 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240613 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240613 ) ) 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') <= 20240613) 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') <= 20240614 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240614 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240614 ) ) 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') <= 20240614) 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') <= 20240615 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240615 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240615 ) ) 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') <= 20240615) 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') <= 20240616 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240616 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240616 ) ) 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') <= 20240616) 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') <= 20240617 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240617 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240617 ) ) 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') <= 20240617) 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') <= 20240618 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240618 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240618 ) ) 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') <= 20240618) 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') <= 20240619 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240619 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240619 ) ) 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') <= 20240619) 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') <= 20240620 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240620 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240620 ) ) 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') <= 20240620) 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') <= 20240621 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240621 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240621 ) ) 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') <= 20240621) 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') <= 20240622 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240622 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240622 ) ) 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') <= 20240622) 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') <= 20240623 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240623 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240623 ) ) 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') <= 20240623) 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') <= 20240624 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240624 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240624 ) ) 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') <= 20240624) 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') <= 20240625 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240625 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240625 ) ) 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') <= 20240625) 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') <= 20240626 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240626 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240626 ) ) 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') <= 20240626) 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') <= 20240627 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240627 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240627 ) ) 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') <= 20240627) 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') <= 20240628 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240628 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240628 ) ) 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') <= 20240628) 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') <= 20240629 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240629 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240629 ) ) 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') <= 20240629) 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') <= 20240630 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240630 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240630 ) ) 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') <= 20240630) 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'