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
Professores

Dados Pessoais

Sandra Medeiros - Canto e Coros do Conservatório

3_105_67_sandra-medeiros-11.jpg

Nasceu em S. Miguel, Açores. É 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 CNC 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 em Portugal, Áustria, Espanha e Inglaterra com personalidades do meio musical erudito tais como Ileana Cotrubas, Teresa Berganza, Gundula Janowitz, Rudolf Knoll, Marimi del Pozo, Jill Feldmann, entre outras.


Foi premiada em concursos nacionais, no seu país, e nos concursos Isabel Jay Singing Prize e Elena Gerhard Lieder Prize em Londres. Foi finalista nos concursos Wigmore Award (Londres), XVII Concours International de Chant de Marmande (França) e no 2º Mediterrâneo International Opera Competition (Bari/Itália-2009). Obteve ainda, o 2º Prémio no V Concurso Internacional de Canto Bidu Sayão no Brasil.


Gravou para as rádios Portuguesa (RDP-Antena 2), Búlgara e Inglesa (BBC3), e para as televisões Portuguesa (RTP, RTP-Açores), Espanhola (TVE) e Brasileira. Editou os trabalhos discográficos Tons de Azul (DRAC-1998) com o grupo Azul e 18th Century Portuguese Love Songs (Hyperion Records-2012) com L’Avventura London.


A sua atividade como solista distribui-se pela música antiga, oratório, lied, melodie, canção do séc.XX/XXI e ópera; havendo já atuado sob a direção de ilustres maestros tais como Michel Corboz, Sir Charles Mackerras, Laurence Cummings, Alberto Lysy, Lawrence Foster, Marc Minkowski entre muitos outros. Também atuou com as mais destacadas orquestras portuguesas e com as orquestras Barroca da RAM, Camerata Lysy de Gstaad e Sinfonia Varsóvia.


Tem participado nos principais festivais de música do seu país bem como em festivais internacionais de Música em Macau, Espanha, Bulgária e Inglaterra. Atuou ainda na Expo 98 (Lisboa) e Expo An Meer 2000 (Alemanha).


A música contemporânea portuguesa tem tido um papel de destaque na sua carreira tendo estreado várias obras de compositores como João Madureira, Carlos Marecos, Carlos Caíres, Emanuel Frazão (gravação em CD de 3 canções sobre poemas de Armando Cortes-Rodrigues para integrar catálogo de homenagem ao poeta Açoriano, com o pianista Francisco Sassetti), Nuno Côrte Real, Sérgio Azevedo, Luís Cardoso (Ismena em Antigona – Óperas Curtas, Teatro S. Luiz), Fernando Lobo (Eurídice em Orfeu – Óperas Curtas, Teatro S. Luiz), Pedro Amaral (Salomé em O Sonho – Grande Auditório da Culturgest), Hugo Ribeiro (Sylvia Plath em Os mortos viajam de metro – Teatro S. Luiz), Rogério Medeiros, entre outros.


No domínio da ópera os seus papéis incluem, entre outros, Barbarina (Nozze di Fígaro), Princese (L’énfant et les sortiléges), Gémea Siamesa (Corvo Branco, Philip Glass), Dragonfly (A raposinha matreira), Frasquita (Carmen), Serpina (La serva padrona), Carlota (As Damas Trocadas, Marcos Portugal), D. Anna (D. Giovanni), Cardella em Lo Frate Nnamorato de Pergolesi (no CCB com os Musicos do Tejos), Tirsi na Serenata L’Angelica de Sousa Carvalho.


No estrangeiro Sandra Medeiros atuou em Espanha, Luxemburgo, Alemanha, Inglaterra, Bulgária, Brasil e Uruguai.


Paralelamente à sua atividade artística, tem vindo a desenvolver atividade pedagógica tendo lecionado nas escolas de Música de Santarém, do Choral Phydelliús (Torres Novas) e da Juventude Musical Portuguesa. Presentemente integra o corpo docente da Escola do Conservatório Regional de Évora – Eborae Musica, como professora das classes de canto e coro.


É regularmente convidada para realizar workshops sobre técnica e saúde vocal, masterclasses de canto e ser membro de júri de concursos de canto em Portugal.

www.sandramedeiros-soprano.com

[ Voltar ]

Destaques
Próximos Eventos
Novembro 2021 Dezembro 2021 Janeiro 2022
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




61277435 Visitas

142 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 = 35 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1711618741' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1711618741' ) 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 = 35
12 SELECT * FROM jos_menu WHERE id = '35'
13 SELECT * FROM jos_fabrik_forms WHERE id = '1'
14 SELECT * FROM jos_fabrik_tables WHERE id = '1'
15 SELECT * FROM jos_fabrik_connections WHERE id = '1'
16 SELECT * FROM jos_fabrik_joins WHERE table_id = '1' ORDER BY id
17 SELECT jos_fabrik_formgroup.group_id AS group_id FROM jos_fabrik_formgroup WHERE jos_fabrik_formgroup.form_id = '1' ORDER BY ordering
18 SELECT * FROM jos_fabrik_groups WHERE id = '1'
19 SELECT id FROM jos_fabrik_elements WHERE group_id = '1' AND jos_fabrik_elements.state = '1' ORDER BY ordering
20 SELECT jos_fabrik_elements.*, concat( action , ' = "' , code , '"') as js FROM jos_fabrik_elements left join jos_fabrik_jsactions on jos_fabrik_elements.id = jos_fabrik_jsactions.element_id WHERE jos_fabrik_elements.id = '1'
21 SELECT id FROM jos_fabrik_validations WHERE element_id = '1'
22 SELECT jos_fabrik_elements.*, concat( action , ' = "' , code , '"') as js FROM jos_fabrik_elements left join jos_fabrik_jsactions on jos_fabrik_elements.id = jos_fabrik_jsactions.element_id WHERE jos_fabrik_elements.id = '2'
23 SELECT id FROM jos_fabrik_validations WHERE element_id = '2'
24 SELECT jos_fabrik_elements.*, concat( action , ' = "' , code , '"') as js FROM jos_fabrik_elements left join jos_fabrik_jsactions on jos_fabrik_elements.id = jos_fabrik_jsactions.element_id WHERE jos_fabrik_elements.id = '3'
25 SELECT id FROM jos_fabrik_validations WHERE element_id = '3'
26 SELECT jos_fabrik_elements.*, concat( action , ' = "' , code , '"') as js FROM jos_fabrik_elements left join jos_fabrik_jsactions on jos_fabrik_elements.id = jos_fabrik_jsactions.element_id WHERE jos_fabrik_elements.id = '4'
27 SELECT id FROM jos_fabrik_validations WHERE element_id = '4'
28 SELECT form_id FROM jos_fabrik_formgroup WHERE group_id = '1'
29 SELECT * FROM jos_fabrik_tables WHERE form_id = '1'
30 SELECT form_id FROM jos_fabrik_formgroup WHERE group_id = '1'
31 SELECT * FROM jos_fabrik_tables WHERE form_id = '1'
32 SELECT form_id FROM jos_fabrik_formgroup WHERE group_id = '1'
33 SELECT * FROM jos_fabrik_tables WHERE form_id = '1'
34 SELECT form_id FROM jos_fabrik_formgroup WHERE group_id = '1'
35 SELECT * FROM jos_fabrik_tables WHERE form_id = '1'
36 SELECT * FROM jos_fabrik_tables WHERE id = '1'
37 select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
38 SELECT * FROM jos_fabrik_jsactions WHERE element_id IN (1,2,3,4)
39 SELECT id, attribs FROM jos_fabrik_validation_rules
40 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'
41 SELECT m.id FROM jos_modules AS m WHERE m.module = 'mod_rssfeed' AND m.published = 1
42 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 = 35 ) ORDER BY ordering
43 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
44 SELECT m.* FROM jos_menu AS m WHERE menutype = 'associacao' AND published = 1 AND access <= 0 ORDER BY parent, ordering
45 SELECT m.* FROM jos_menu AS m WHERE menutype = 'conservatorio' AND published = 1 AND access <= 0 ORDER BY parent, ordering
46 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
47 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=4'
48 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=5'
49 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
50 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-28 09:54:02') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 09:54:02') AND catid='5' ORDER BY a.created asc LIMIT 5
51 SELECT * FROM jos_content WHERE id = '1332'
52 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
53 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
54 SELECT * FROM jos_content WHERE id = '1333'
55 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
56 SELECT * FROM jos_content WHERE id = '1334'
57 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
58 SELECT * FROM jos_jcalpro_config
59 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
60 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
61 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
62 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
63 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
64 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
65 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
66 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
67 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
68 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
69 SELECT cat_id, level FROM jos_jcalpro_categories
70 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
71 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
72 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
73 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
74 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
75 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
76 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
77 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
78 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
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') <= 20211201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211201 ) ) 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') <= 20211201) 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') <= 20211202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211202 ) ) 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') <= 20211202) 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') <= 20211203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211203 ) ) 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') <= 20211203) 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') <= 20211204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211204 ) ) 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') <= 20211204) 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') <= 20211205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211205 ) ) 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') <= 20211205) 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') <= 20211206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211206 ) ) 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') <= 20211206) 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') <= 20211207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211207 ) ) 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') <= 20211207) 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') <= 20211208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211208 ) ) 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') <= 20211208) 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') <= 20211209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211209 ) ) 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') <= 20211209) 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') <= 20211210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211210 ) ) 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') <= 20211210) 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') <= 20211211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211211 ) ) 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') <= 20211211) 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') <= 20211212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211212 ) ) 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') <= 20211212) 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') <= 20211213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211213 ) ) 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') <= 20211213) 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') <= 20211214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211214 ) ) 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') <= 20211214) 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') <= 20211215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211215 ) ) 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') <= 20211215) 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') <= 20211216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211216 ) ) 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') <= 20211216) 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') <= 20211217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211217 ) ) 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') <= 20211217) 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') <= 20211218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211218 ) ) 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') <= 20211218) 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') <= 20211219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211219 ) ) 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') <= 20211219) 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 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') <= 20211220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211220 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
118 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') <= 20211220) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
119 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') <= 20211221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211221 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
120 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') <= 20211221) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
121 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') <= 20211222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211222 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
122 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') <= 20211222) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
123 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') <= 20211223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211223 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
124 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') <= 20211223) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
125 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') <= 20211224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211224 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
126 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') <= 20211224) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
127 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') <= 20211225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211225 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
128 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') <= 20211225) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
129 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') <= 20211226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211226 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
130 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') <= 20211226) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
131 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') <= 20211227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211227 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
132 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') <= 20211227) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
133 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') <= 20211228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211228 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
134 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') <= 20211228) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
135 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') <= 20211229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211229 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
136 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') <= 20211229) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
137 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') <= 20211230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211230 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
138 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') <= 20211230) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
139 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') <= 20211231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20211231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20211231 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
140 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') <= 20211231) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
141 SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'
142 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering