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
4 a 7 OUT- X Jornadas Internacionais “Escola de Música da Sé de Évora” - ACTIVIDADES E CONCERTOS Imprimir e-mail

  evento_2_-_cartazreduzido.png










ACTIVIDADES NO CONVENTO DOS REMÉDIOS
CONCERTOS NA SÉ DE ÉVORA

Sinopse:
Este ano comemoramos o 10º Aniversário das Jornadas Internacionais “Escola de Música da Sé de Évora”. Dez anos dedicados à investigação, interpretação, valorização e divulgação da obra dos Mestres Polifonistas da Escola de Música da Sé de Évora, séculos XVI e XVII. (...)

VER PROGRAMAÇÂO DE CONCERTOS E ACTIVIDADES:


(...)Voltamos a referir a importância que o Cónego Dr. José Augusto Alegria teve não só na investigação deste espólio musical mas, também, no importante e decisivo apoio que deu à realização das Jornadas, desde a primeira hora. Os objectivos principais destas assentam na divulgação do espólio da Escola de Música da Sé de Évora (sécs. XVI e XVII), em dar a conhecer formas de abordagem diferentes deste reportório, aprofundar técnicas vocais e de interpretação, criar um espaço de intercâmbio de saberes e vivências culturais e aprofundar o conhecimento da obra dos polifonistas eborenses. Este ano o trabalho será desenvolvido sobre a obra “Requiem” de Frei Manuel Cardoso. Os Ateliers são dirigidos pelos Maestros: Peter Phillips, Owen Rees, Armando Possante e Pedro Teixeira. Rui Vieira Nery e Owen Rees proferirão Conferências.  
evento_2.1-grupo_introitus.jpg


 














                   GRUPO VOCAL INTROITUS

4 OUTUBRO
CONVENTO DOS REMÉDIOS
9.30H – SESSÃO DE ABERTURA
10,45  e 16,00H – ATELIERS 
 

SÉ DE ÉVORA
21.30H – CONCERTO PELO GRUPO VOCAL INTROITUS, Direcção de Fernando Gomes
 

Programa: I parte: Escola de Évora - Canto Gregoriano: Ecce Dominus Noster, Asperges me e Lumen ad Revelationem; E. Lopes Morago: Lumen ad Revelationem; Francisco Martins: Adiuvanos Deus, Seniores Populi e Velum Templi; Diogo Dias Melgaz: Memento Homo, Requiem e Rex Tremendae Majestatis; Frei Manuel Cardoso: Manum Suam / O Vos Omnes, Lux Aeterna e Panis Angelicus; Manuel Mendes: Alleluia; Francisco Velez: Alleluia do 2º tom. II parte: Influentes Escolas Contemporâneas - Pero de Gamboa: O Crux ave e Hodie Maria: D. Pedro de Cristo: Tristis est anima meã e O Magnum Misterium e Tomas Luis de Vitoria: Domine, non sum dignus, Una hora, Ave Maria e Ave Maris Stella.

O Ensemble Vocal Introitus integra elementos solistas provenientes de vários agrupamentos vocais, destacando-se o Coro Gulbenkian e o Coro Gregoriano de Lisboa. Os membros fundadores deste agrupamento conheceram-se no início da sua formação musical, trabalhando juntos desde então e obtendo, por isso, uma elevada fusão tímbrica. Percorre todo o repertório para vozes masculinas, desde o Canto Gregoriano até aos nossos dias, com especial ênfase na música antiga.

Fernando Marques Gomes é licenciado em Canto na Escola Superior de Música de Lisboa e o Curso Geral de Flauta Transversal do Conservatório Nacional. É membro do Coro da Fundação Calouste Gulbenkian e do Coral Vértice e tem vindo a especializar-se na música vocal e instrumental dos períodos Medieval e Renascentista. 

evento_2.2-coro_cmara_u._lisboa.jpg




















           CORO DE CÂMARA DA UNIVERSIDADE DE LISBOA


5 OUTUBRO
CONVENTO DOS REMÉDIOS
9.00H – 18.30H – ATELIERS 
 

SÉ DE ÉVORA
19.00H – CONCERTO PELO CORO DE CÂMARA DA UNIVERSIDADE DE LISBOA, Direcção de José Robert
 

Programa: 
I parte- Estêvão de Brito: Lamentationes Jeremiae Prophetae, Feria 5 in coena Domini, Feria 6 in Parasceva e Sabbato in Parasceva; Duarte Lobo: Magnificat Octavi Toni. II parte - Filipe de Magalhães: Missa de Beata Virgine Maria.

O Coro de Câmara da
Universidade de Lisboa foi fundado em Maio de 1997 pelo director artístico do Coro da Universidade de Lisboa, Maestro José Robert. Composto por dezasseis cantores, interpreta obras portuguesas e estrangeiras do período compreendido entre a Renascença e os nossos dias, sendo responsável por várias primeiras apresentações nacionais e mesmo mundiais.

José Robert iniciou desde muito cedo a actividade musical que incidiu no estudo e prática da música coral, pois, simultaneamente com os seus estudos musicais, fez parte activa e regular de vários agrupamentos corais, infantis e juvenis, com especial incidência na polifonia. Foi co-fundador do Coro da Fundação Gulbenkian, dirige o Choral Phidellius e, desde 1974, como adjunto de Fernando Lopes Graça, e a partir de 1988 como titular, o Coro da Academia de Amadores de Música de Lisboa. Desde Março de 1997 dirige o Coro de Câmara da Universidade de Lisboa.
 

evento_2.3-hilliard_ensemble.jpg




















                           THE HILLIARD ENSEMBLE

6 OUTUBRO
CONVENTO DOS REMÉDIOS
9.00H –12,30H – ATELIERS
14,00h CONFERÊNCIA pelo Doutor Owen Rees
15,00h – Ateliers
17,00h – CONFERÊNCIA PELO DOUTOR RUI VIEIRA NERY
 

SÉ DE ÉVORA
21,30h – CONCERTO POR “THE HILLIARD ENSEMBLE”
 

(Adquira o seu lugar a partir de dia 2 de Outubro, terça-feira, no Convento dos Remédios, Évora, telef: 266 746 750; No dia 6, a partir das 20h00, na Galeria Teoartis, Rua 5 de Outubro, próximo da Sé Catedral)

The Hilliard Ensemble - David James contra tenor; Rogers Covey-Crump – tenor; Steven Harrold – tenor e Gordon Jones barítono. “The Hilliard Ensemble é um dos melhores grupos vocais de câmara e provavelmente sem rival na sua formidável reputação em ambos os campos da música antiga e da música contemporânea. O seu estilo característico e elevada competência técnica musical atraem o ouvinte tanto para o reportório renascentista como para composições escritas para o grupo por compositores contemporâneos. A agenda de apresentações do grupo é muito intensa e variada, atingindo algumas centenas de Concertos por ano na Europa, Japão, EUAe Canadá. A fama do grupo como intérprete de música antiga data dos anos 80 e as séries de gravações de elevado sucesso, para a EMI.

Prorgrama: Melgas: Salve Regina; Dufay, Kyrie & Gloria; Melgas, Adjuva nos; St Martial, Oi Dex!; De Brito, Inter vestibulum; Melgas, Ecce ascendimus; Dufay, Credo; Morago, O bone Jesu; Melgas, In monte Oliveti, Dufay, Sanctus & Benedictus; Melgas, Memento homo; St Martial, Victimae Paschali; Martins, Plange, Martins, Ditos de Cristo e Dufay, Agnus.


evento_2.4--eb.mus.jpg


















                         CORO POLIFÓNICO EBORAE MVSICA

7 OUTUBRO
CONVENTO DOS REMÉDIOS
9.30H – 12.30H – ATELIERS 

SÉ DE ÉVORA17.00H – CONCERTO FINAL PELO CORO DOS PARTICIPANTES, dirigidos por Peter Phillips, Owen Rees e Armando Possante; Participação do CORO POLIFÓNICO EBORAE MVSICA, Direcção de Pedro Teixeira 

Sinopse: O coro dos participantes, cerca de 50 vozes, interpreta o “Requiem” de Frei Manuel Cardoso, obra preparada sob a orientação dos Maestros Owen Rees, Peter Phillips e Armando Possante.

Programa do Coro Polifónico Eborae Mvsica
: Frei Manuel Cardoso, Aquam, quam ego dabo, Domine, tu mihi lavas pedes? e Ecce mulier chananea; Duarte Lobo, Asperges me e Pater peccavi e Filipe de Magalhães, Sanctus (Missa Beata Virgine Maria).

O Coro Polifónico Eborae Mvsica
que assinala o seu vigésimo aniversário, interpreta peças da
Escola de Música da Sé de Évora, objectivo a que se propôs desde a sua constituição.

Pedro Teixeira é licenciado em Direcção Coral pela Escola Superior de Música de Lisboa, onde trabalhou com o Maestro Vasco Pearce de Azevedo. Dirige, desde Março de 1997, o Coro Polifónico Eboræ Musica, em Évora, e, desde Setembro de 2000, o Grupo Coral de Queluz. No mesmo ano funda o Officium – grupo vocal, dedicado à interpretação de polifonia portuguesa dos sécs. XVI/XVII, do qual é director artístico. Recebe em 2002 o prémio “The most promising conductor of Tonen 2002” na Holanda.

ORGANIZAÇÃO: EBORAE MVSICA
APOIO:
IARTES/MC, CME, CABIDO DA SÉ, UE, FEA, RTE
INFORMAÇÕES:
266 747 750
EMAIL:
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
WEB
WWW.EBORAE-MUSICA.ORG     
 
Destaques
Próximos Eventos
Junho 2021 Julho 2021
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




33261886 Visitas

115 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 1 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1624360732' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1624360732' ) 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 = 1
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 = 161 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-06-22 12:33' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-22 12:33' ) AND a.access <= 0
13 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '161'
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 = 1 ) 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 <= '2021-06-22 12:33:53') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-06-22 12:33:53') 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') <= 20210601 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210601 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210601 ) ) 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') <= 20210601) 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') <= 20210602 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210602 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210602 ) ) 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') <= 20210602) 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') <= 20210603 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210603 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210603 ) ) 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') <= 20210603) 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') <= 20210604 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210604 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210604 ) ) 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') <= 20210604) 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') <= 20210605 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210605 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210605 ) ) 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') <= 20210605) 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') <= 20210606 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210606 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210606 ) ) 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') <= 20210606) 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') <= 20210607 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210607 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210607 ) ) 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') <= 20210607) 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') <= 20210608 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210608 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210608 ) ) 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') <= 20210608) 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') <= 20210609 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210609 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210609 ) ) 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') <= 20210609) 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') <= 20210610 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210610 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210610 ) ) 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') <= 20210610) 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') <= 20210611 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210611 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210611 ) ) 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') <= 20210611) 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') <= 20210612 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210612 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210612 ) ) 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') <= 20210612) 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') <= 20210613 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210613 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210613 ) ) 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') <= 20210613) 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') <= 20210614 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210614 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210614 ) ) 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') <= 20210614) 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') <= 20210615 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210615 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210615 ) ) 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') <= 20210615) 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') <= 20210616 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210616 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210616 ) ) 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') <= 20210616) 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') <= 20210617 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210617 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210617 ) ) 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') <= 20210617) 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') <= 20210618 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210618 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210618 ) ) 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') <= 20210618) 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') <= 20210619 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210619 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210619 ) ) 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') <= 20210619) 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') <= 20210620 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210620 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210620 ) ) 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') <= 20210620) 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') <= 20210621 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210621 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210621 ) ) 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') <= 20210621) 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') <= 20210622 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210622 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210622 ) ) 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') <= 20210622) 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') <= 20210623 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210623 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210623 ) ) 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') <= 20210623) 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') <= 20210624 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210624 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210624 ) ) 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') <= 20210624) 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') <= 20210625 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210625 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210625 ) ) 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') <= 20210625) 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') <= 20210626 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210626 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210626 ) ) 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') <= 20210626) 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') <= 20210627 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210627 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210627 ) ) 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') <= 20210627) 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') <= 20210628 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210628 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210628 ) ) 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') <= 20210628) 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') <= 20210629 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210629 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210629 ) ) 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') <= 20210629) 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') <= 20210630 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210630 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210630 ) ) 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') <= 20210630) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
115 SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'