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, 11, 21h30-Recital de Canto, Piano e Poesia, Claustros do Convento dos Remédios, Évora Imprimir e-mail

Recital de Canto, Piano e Poesia, 11 de julho, às 21h30, Claustros do Convento dos Remédios, Évora, por José Corvelo (barítono), Carla Seixas (piano) e Leonor Seixas (Atriz)
XXI Ciclo de Concertos "Música e outras Artes nos Claustros". 

Programa: FREITAS BRANCO – Contrastes,Aquela Moça; GIORDANO - Caro Mio Ben; P. MARTINI - Plaisir D’ Amour; CHOPIN - Valsa op. 70 n. 2; FAURÉ - Les Berceaux, Après un rêve; MOZART - Deh vieni alla finestra, Der Vogelfänger bin ich ja ; SCHUBERT - Improviso op. 90 n. 3; BART HOWARD - Fly me to the moon ; COLE PORTER - Begin the Beguine; E. DE CURTIS - Torna Sorriento; DI CAPULA - O Sole Mio; Poemas de Eugénio de Andrade, Rui Belo, Eduardo Bettencourt Pinto, Fernando Pessoa, Nuno Júdice.
poesia_e_canto_20_-_cpia.jpg

 

 

A Associação Eborae Mvsica realiza, em Julho, o XXI 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 continua no dia 11 de julho, às 21h30 com o Recital de Canto, Piano e Poesia por José Corvelo (barítono), Carla Seixas (piano) e Leonor Seixas (Atriz).
Chamamos a atenção para o seguinte: a reserva de bilhetes deve ser realizada com antecedência através do e-mail : 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 ; se houver lugares remanescentes o bilhete poderá ser adquirido antes do espetáculo; é obrigatório o uso de máscara.



José Corvelo - Natural dos Açores. É licenciado pela Escola Superior de Música e das Artes do Espectáculo onde integrou a classe do Professor José de Oliveira Lopes. Foi-lhe atribuído o prémio Eng. António de Almeida pela Fundação com o mesmo nome, que distingue os melhores alunos finalistas das Universidades Portuenses. Obteve o grau de Mestre, pela Universidade de Aveiro. Participou em “masterclasses” com Oliveira Lopes, Fernanda Correia, Rudolf Knoll, Lamara Chkónia, Liliana Bizineche, Enza Ferrari, Francisco Lázaro, Ambra Vespasiani, Ettore Nova. Aperfeiçoou-se no domínio da ópera, em Portugal, com Jorge Vaz de Carvalho e, em Madrid, com Daniel Muñoz. Integrou o Atelier de Ópera da Orquestra Metropolitana de Lisboa. Foi solista nas principais obras coral-sinfónicas. Tem participado em diversas estreias mundiais de várias óperas, nomeadamente “A Floresta” de E. Carrapatoso, numa co-produção Teatro Nacional de São Carlos/Teatro São Luiz e “Banksters” de Nuno Corte-Real, numa produção do TNSC.

Gravou em DVD, para a Casa da Música, com a Orquestra Nacional do Porto, a obra: “O lobo Diogo e o mosquito Valentim” de E. Carrapatoso. Participou, como actor/cantor, no filme de Michael Sturminger "The Casanova Variations". Foi dirigido por vários prestigiados Maestros. Em 2015 foi agraciado com a Insígnia Autonómica de Mérito Profissional, pela Região Autónoma dos Açores.

Carla Seixas - Nasceu em Luanda, Angola. Iniciou os estudos de piano, na Escola de Música do Conservatório Nacional, com Noémia de Brederode e Olga Prats, prosseguindo-os com Sequeira Costa e Tania Achot. Em 1977, diplomou-se com a classificação máxima, tendo depois frequentado a classe de Piano de Sequeira Costa, na Universidade de Kansas, na qualidade de bolseira da Fundação Calouste Gulbenkian. Participou em masterclasses de Leon Fleischer, Gary Graffman, Josef Palaniceck e Helena Costa.

Como bolseira da Secretaria de Estado da Cultura, estudou durante quatro anos em Paris, sob a orientação de Jean Fassina. A sua actividade musical reparte-se por repertório solístico e música de câmara, com que se tem apresentado em recitais nas principais salas de concertos do país.Tocou ainda nos Festivais Internacionais de Sintra, Estoril, Figueira da Foz, Leiria e Algarve. A solo, por diversas vezes actuou com a Orquestra Sinfónica Juvenil. Além de Portugal Continental e Ilhas (Açores, Madeira), actuou igualmente noutros palcos europeus - Paris, Alemanha Holanda, Dinamarca -, bem como em internacionais, como Macau, Bahamas, Zimbabwe, Angola, Moçambique, Guiné-Bissau, Cabo-Verde, Índia, Colômbia e Austrália. Com a soprano Lia Altavilla gravou a Integral para Canto e Piano de Francisco de Lacerda, “Saudades da Terra”, para a etiqueta Fine Arts.

Leonor Seixas - Leonor adora cinema, televisão, teatro, ama o que faz! Nascida em Portugal, é uma viajante do mundo. Hollywood e Lisboa são a sua base, e trabalha tanto nestes dois lugares, como pelo mundo….Começou por ser bailarina, começando aos 3 anos, e frequentou a privilegiada escola do Conservatório Nacional de Dança de Lisboa.

Depois passou para teatro, continuando pelos palcos, mas numa área um pouco diferente, na Escola Profissional de Teatro de Cascais. Ainda uma teenager continuou os seus estudos saindo da Europa e indo para Nova Iorque estudar no prestigiado The Lee Strasberg Theater Institute. Enquanto na cidade fez participações em filmes e peças de teatro até ser escolhida para protagonizar em Portugal uma novela e, também, um filme.

Tem trabalhado em variadíssimas séries, peças de teatro, filmes, novelas, recitais de poesia, locuções e anúncios. Teve nomeações em festivais importantes, como Globos de Ouro, SPA Awards, Sophia Awards, Cinema Bloggers Awards tendo ganho o prémio de melhor actriz no Le Havre Festival e no Valencia Film Festival.

Os próximos concertos do Ciclo são : dia 18 – duo Almaclara por Luiza Nancu e Beatriz González, violoncelos ; dia 31 -“Spaguetti Fusion” direção e contrabaixo - Ercole de Conca, Sandra Medrios - soprano, Diana Tzonkova - violino, Luis Cascão – Percussão, Carlos Garcia-teclados.

A Organização é da Associação Eborae Musica entidade financiada pelo Ministério da Cultura- DGArtes, com Co-Produção da Câmara Municipal de Évora, e apoio de: Diário do Sul, A Defesa, Antena 2 e Rádio Diana e Registo.

 
Destaques
Próximos Eventos
Março 2024 Abril 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 31
Notícias RSS
Newletter




60728426 Visitas

117 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 < '1710815744' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1710815744' ) AND guest = 1 AND userid = 0 )
5 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 0
6 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' 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 = 1292 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-19 02:50' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-19 02:50' ) AND a.access <= 0
13 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '1292'
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-03-19 02:50:45') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-19 02:50:45') 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') <= 20240301 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240301 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240301 ) ) 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') <= 20240301) 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') <= 20240302 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240302 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240302 ) ) 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') <= 20240302) 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') <= 20240303 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240303 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240303 ) ) 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') <= 20240303) 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') <= 20240304 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240304 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240304 ) ) 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') <= 20240304) 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') <= 20240305 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240305 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240305 ) ) 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') <= 20240305) 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') <= 20240306 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240306 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240306 ) ) 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') <= 20240306) 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') <= 20240307 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240307 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240307 ) ) 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') <= 20240307) 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') <= 20240308 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240308 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240308 ) ) 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') <= 20240308) 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') <= 20240309 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240309 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240309 ) ) 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') <= 20240309) 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') <= 20240310 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240310 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240310 ) ) 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') <= 20240310) 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') <= 20240311 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240311 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240311 ) ) 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') <= 20240311) 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') <= 20240312 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240312 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240312 ) ) 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') <= 20240312) 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') <= 20240313 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240313 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240313 ) ) 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') <= 20240313) 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') <= 20240314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240314 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240314 ) ) 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') <= 20240314) 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') <= 20240315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240315 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240315 ) ) 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') <= 20240315) 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') <= 20240316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240316 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240316 ) ) 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') <= 20240316) 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') <= 20240317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240317 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240317 ) ) 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') <= 20240317) 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') <= 20240318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240318 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240318 ) ) 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') <= 20240318) 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') <= 20240319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240319 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240319 ) ) 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') <= 20240319) 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') <= 20240320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240320 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240320 ) ) 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') <= 20240320) 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') <= 20240321 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240321 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240321 ) ) 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') <= 20240321) 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') <= 20240322 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240322 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240322 ) ) 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') <= 20240322) 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') <= 20240323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240323 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240323 ) ) 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') <= 20240323) 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') <= 20240324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240324 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240324 ) ) 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') <= 20240324) 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') <= 20240325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240325 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240325 ) ) 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') <= 20240325) 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') <= 20240326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240326 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240326 ) ) 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') <= 20240326) 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') <= 20240327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240327 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240327 ) ) 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') <= 20240327) 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') <= 20240328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240328 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240328 ) ) 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') <= 20240328) 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') <= 20240329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240329 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240329 ) ) 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') <= 20240329) 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') <= 20240330 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240330 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240330 ) ) 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') <= 20240330) 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 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') <= 20240331 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240331 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240331 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
116 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') <= 20240331) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
117 SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'