Início Calendário Destaques Localização Downloads Links Contactos English
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   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.                        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.             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.                             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.                          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        [ Voltar ]	Destaques Prémio de Composição 2ª Escola de Évora - 2021 Masterclass de Guitarra - Alterado para 26, 27 e 28 de Março Nova Página da Eborae Mvsica Próximos Eventos Setembro 2021 Se Te Qu Qu Se Sá Do 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Notícias RSS Newletter Name Email 64610630 Visitas
Concepção e Alojamento: VGSoftware

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 < '1716080781' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1716080781' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'f05c8c5c2c2a6ff4e1619335ea6a9cc3'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'f05c8c5c2c2a6ff4e1619335ea6a9cc3','1716081681','','0','1' )
7
SELECT *
 FROM jos_menu
 WHERE id = 1
8
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 <= '2024-05-19 02:21' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-19 02:21' )
 AND a.access <= 0
9
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '161'
10
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
11
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
12
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'
13
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
14
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
15
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
16
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
17
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
18
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
19
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
20
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
21
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
22
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-05-19 02:21:22') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-19 02:21:22')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
23
SELECT *
 FROM jos_content
 WHERE id = '1332'
24
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
25
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
26
SELECT *
 FROM jos_content
 WHERE id = '1333'
27
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1333
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
28
SELECT *
 FROM jos_content
 WHERE id = '1334'
29
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
30
SELECT * FROM jos_jcalpro_config
31
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
32
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
33
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
34
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
35
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
36
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
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
  	cat_id, level
  FROM
  	jos_jcalpro_categories
42
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
43
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
44
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
45
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
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 name FROM jos_jcalpro_themes WHERE published= '1'
51
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') <= 20210901 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210901 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210901 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
52
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') <= 20210901) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
53
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') <= 20210902 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210902 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210902 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
54
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') <= 20210902) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20210903 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210903 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210903 ) ) 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') <= 20210903) 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') <= 20210904 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210904 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210904 ) ) 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') <= 20210904) 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') <= 20210905 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210905 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210905 ) ) 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') <= 20210905) 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') <= 20210906 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210906 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210906 ) ) 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') <= 20210906) 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') <= 20210907 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210907 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210907 ) ) 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') <= 20210907) 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') <= 20210908 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210908 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210908 ) ) 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') <= 20210908) 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') <= 20210909 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210909 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210909 ) ) 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') <= 20210909) 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') <= 20210910 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210910 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210910 ) ) 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') <= 20210910) 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') <= 20210911 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210911 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210911 ) ) 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') <= 20210911) 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') <= 20210912 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210912 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210912 ) ) 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') <= 20210912) 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') <= 20210913 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210913 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210913 ) ) 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') <= 20210913) 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') <= 20210914 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210914 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210914 ) ) 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') <= 20210914) 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') <= 20210915 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210915 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210915 ) ) 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') <= 20210915) 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') <= 20210916 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210916 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210916 ) ) 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') <= 20210916) 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') <= 20210917 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210917 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210917 ) ) 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') <= 20210917) 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') <= 20210918 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210918 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210918 ) ) 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') <= 20210918) 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') <= 20210919 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210919 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210919 ) ) 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') <= 20210919) 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') <= 20210920 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210920 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210920 ) ) 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') <= 20210920) 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') <= 20210921 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210921 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210921 ) ) 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') <= 20210921) 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') <= 20210922 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210922 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210922 ) ) 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') <= 20210922) 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') <= 20210923 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210923 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210923 ) ) 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') <= 20210923) 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') <= 20210924 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210924 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210924 ) ) 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') <= 20210924) 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') <= 20210925 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210925 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210925 ) ) 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') <= 20210925) 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') <= 20210926 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210926 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210926 ) ) 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') <= 20210926) 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') <= 20210927 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210927 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210927 ) ) 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') <= 20210927) 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') <= 20210928 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210928 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210928 ) ) 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') <= 20210928) 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') <= 20210929 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210929 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210929 ) ) 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') <= 20210929) 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') <= 20210930 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210930 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210930 ) ) 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') <= 20210930) 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 sum(hits) AS count FROM jos_stats_agents WHERE type='1'