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
2 a 5 Out. 2008 - Évora - XI Jornadas Internacionais-Escola Música Sé Évora-VER IMAGENS Imprimir e-mail
2 a 5 Outubro de 2008 - XI Jornadas Internacionais "Escola de Música da Sé de Évora                                                                           
cataz_06-09-08-jpg.jpg

VER IMAGENS DOS CONCERTOS

CONCERTOS:

2 Outubro, 21,30h
Concerto na Sé
           
“Voces Caelestes”
               
Direcção: Sérgio Fontão

3 Outubro, 19,00h
Concerto na Sé
            
“Officium – grupo 
vocal"
           
Direcção de Pedro Teixeira

4 Outubro, 21,30h
Concerto na Sé
             
“A Sei Voci"

5 Outubro, 17,00h
– Concerto Final na Sé
(participação do Coro Polifónico “Eborae Mvsica” Direcção de Pedro Teixeira)
e Coro dos Participantes.


OBJECTIVOS:


- Divulgar o espólio da escola de Música da Sé de Évora (sécs. XVI e XVII), (Frei Manuel Cardoso, Duarte Lobo, Diogo Dias Melgaz, Estêvão Lopes Morago, etc…);


- Dar a conhecer formas de abordagem diferentes deste reportório;

- Aprofundar técnicas vocais de interpretação;

- Criar um espaço de intercâmbio de saberes, vivências e culturas;


- Criar um espaço de abertura à participação da Comunidade;

- Estudar e interpretar a obra de Duarte Lobo “Missa Veni Domine”.
  

Destinatários: Directores de Coros, Membros de Coros, Profissionais e Amadores de Canto, Professores de Educação Musical, Outros.

Profissionais envolvidos: João Pedro d’Alvarenga, Peter Phillips, Owen Rees, Armando Possante e Pedro Teixeira

Programa:

2 OUT 
9,00 h - Abertura do Secretariado
9,30 h - Sessão de Abertura
10,00 h – Pausa para Café
10,15 h – Conferência pelo Doutor Owen Rees- “Aires Fernandez: um mistério para resolver”
11,15 h – Conferência pelo Doutor João Pedro d’Alvarenga – “António Carreira: as múltiplas chaves de um enigma persistente”
12,15 h – Atelier conjunto
13,15 h – Almoço
14,30 h – Visita guiada pelo Dr. Jorge Raposo à Sé e seus Arquivos
15,30 h – Audições para o Atelier “Aprofundamento da Interpretação”
16,00h – 18,00h – Atelier conjunto
18,15h – 20,00h - Atelier “Aprofundamento da Interpretação”
21,30h – Concerto na Sé de Évora              
“Voces Caelestes”
               
Direcção: Sérgio Fontão

3 OUT 

9,00 h - Ateliers
               (Os participantes, divididos em grupos, trabalharão partes da Missa  
               “Veni Domine”, de Duarte Lobo, sob a 
direcção dos vários Maestros)
12,45 h – Almoço
14,15 – 16,00 h – Ateliers
16,00h – Pausa para café
16,15h - Conversa com os Maestros          
17.15h – 18,30h - Atelier “Aprofundamento da Interpretação”
19,00h – Concerto na Sé de Évora              
“Officium – grupo vocal”
               
Direcção de Pedro Teixeira
20,30h – Jantar Convívio (facultativo)

4 OUT

9,00h – Ateliers
12,30h – Almoço
14,15h – 16,45h – Ateliers
18,00h – 20,00h - Atelier “Aprofundamento da Interpretação”
21,30h – Concerto na Sé de Évora              
“A Sei Voci
 

5 OUT 

9,30h – 12,30h – Ateliers
12,30h – Almoço
14,30h- 16,00h – Ensaios (Sé de Évora)
17,00h – Concerto Final na Sé de Évora               
           
(participação do Coro Polifónico “Eborae Mvsica”, direcção  
             de 
Pedro Teixeira)               
             
Encerramento oficial das Jornadas e distribuição de Certificados 
de
             Participação

CONTACTO:

Associação Musical de Évora - Eborae Mvsica

Convento dos Remédios, Av. S. Sebastião
Apartado 2126, 7001 - 901 Évora Portugal 
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
Telef: (+351) 266 746 750
Fax:
(+351) 266 701 359

Ficha de Inscrição

FICHA DE INSCRIÇÃO:

Apelido__________________________ Nome______________________

Morada___________________________ E-mail_____________________

Duração da experiência de Canto________________________________

Naipe_______________________________________________________

Leitura de partituras - Sim ou Não___ Formação Musical Sim ou Não____

Taxa de Inscrição: Participante activo 90€; Atelier "Aprofundamento de Interpretação" + 20€ (a participação neste atelier depende da audição no 1.º dia).

Ouvinte 50€; Almoço incluido; Após 31 de Julho e até 15 de Setembro acréscimo de 15€.

Pagamento com cheque n.º_____________________sobre__________

à ordem de  Eborae Musica na importância de____________________,

em anexo, ou transferência para a conta n.º 029700036507230 Caixa Geral de Depósitos, (NIB 003502970003650723076) - IBAN: PT 50003502970003650723076 - BIC/SWIFT: CGDIPTPL 

Profissionais envolvidos:

João Pedro d’Alvarenga nasceu em Lisboa em 1961. Estudos de música no Instituto Gregoriano de Lisboa, 1979-84. Licenciado em Ciências Musicais pela Universidade Nova de Lisboa, 1988. Doutorado em Música e Musicologia pela Universidade de Évora, 2006.Responsável pela Área de Música, depois Centro de Estudos Musicológicos da Biblioteca Nacional de Lisboa, 1991-97. Comissário da Capital Europeia da Cultura '94 para a instalação do Museu da Música em Lisboa, 1993-94.Bolseiro da JNICT e do INIC, 1988-91. Prémio de investigação do Conselho Português da Música, 1993.Co-fundador e membro da Direcção da Associação Portuguesa de Ciências Musicais, 1992-98. Editor da Revista Portuguesa de Musicologia, 1996-98.Autor de edições críticas de música, de livros e de diversos artigos e textos sobre músicos e música em Portugal, instituições, repertórios vocais sacros e de tecla e respectivas fontes, abrangendo os períodos da Idade Média ao início do século XIX.Membro integrado do Centro de História da Arte da Universidade de Évora, 2000-07. Colaborou também, em 2005-06, com a Área de Música Antiga da Escola Superior de Música e das Artes do Espectáculo do Porto.

Peter Phillips dirige os “The Tallis Scholars” e desde sempre dedicou o seu trabalho à Música Sacra da Renascença. Após estudos feitos com David Wulstan e Denis Arnold ganhou experiência de direcção de pequenos grupos vocais juntando em 1973 vozes dos Coros de Capela de Oxford e Cambridge criando “The Tallis Scholars”. Famoso pelas suas gravações premiadas contam-se, entre os autores interpretados, compositores da Escola de Música da Sé de Évora, nomeadamente, Frei Manuel Cardoso. Para além da sua actividade com os “Tallis Scholars”, Peter Phillips colabora desde há muito com a revista Spectator quer como musicólogo, quer como crítico. Também continua a colaborar com formações internacionais: em 1997 esteve em Tóquio como júri de um festival coral e tem trabalhado igualmente em Itália e nos Estados Unidos. É director do Okham International Summer School.

Owen Rees é académico e executante. O seu trabalho como académico tem dado consistência ao seu trabalho como executante. É “Fellow” (membro da direcção) em Música e Organista no Queen's College, de Oxford, dirigindo o “Chapel Choir”, nos repertórios musicais do século XVI ao século XX. Através das suas actividades como director de “A Capella Portuguesa” e do “Cambridge Taverner Choir”, trouxe para as salas de concerto e estúdios de gravação reportórios de música magnífica da Renascença de Portugal e Espanha, incluindo trabalhos desconhecidos ou pouco conhecidos. As suas interpretações destes reportórios foram referidas como “raros exemplos de combinação entre academismo e musicalidade resultando em actuações impressionantes e imediatamente atractivas para o ouvinte”, e foi descrito como “uma das vozes mais enérgicas e persuasivas” neste campo.

Armando Possante iniciou a sua formação musical com 6 anos no Instituto Gregoriano de Lisboa, onde estudou até 1990. Ingressou nesse ano na Escola Superior de Música de Lisboa, onde concluiu o Bacharelato em Direcção Coral, como aluno dos Profs. Christopher Bochmann e Roberto Perez, a Licenciatura em Canto Gregoriano, na classe da Prof. Maria Helena Pires de Matos e, com a classificação máxima, a Licenciatura em Canto na classe do professor Luís Madureira. Foi-lhe atribuida uma bolsa pelo Instituto Politécnico de Lisboa  na condição de melhor aluno desta instituição.  Orientou workshops de música coral no Festival 500 (Canadá), no congresso da Association of British Choral Directors (Inglaterra) e nas Jornadas Internacionais “Escola de Música da Sé de Évora”. Frequentou cursos de Direcção Coral com Bernard Tétu e Heribert Breuer e os cursos da Associação Internacional de Canto Gregoriano em Cremona (Itália) com Nino Albarosa e Johannes Göschl. Participou em masterclasses com os grupos The King’s Singers e Hilliard Ensemble. É director do Grupo Vocal Olisipo. 

Pedro Teixeira nasceu em Lisboa. É licenciado em Direcção Coral pela Escola Superior de Música de Lisboa, onde trabalhou com o Maestro Vasco Pearce de Azevedo. Iniciou os seus estudos musicais na Academia de Amadores de Música em 1981, completando os cursos de Formação Musical, e Análise e Técnicas de Composição com o professor Eurico Carrapatoso. Ingressa na Faculdade de Direito de Lisboa em 1990, mas acaba por optar definitivamente pela música em 1995. Interessara-se entretanto pela prática e direcção de música coral, nomeadamente no Coro da Universidade de Lisboa onde se iniciou na direcção, primeiro como ensaiador de naipe e, posteriormente, como assistente do maestro José Robert.Trabalhou com António Lourenço e Paulo Lourenço no I e II Cursos de Direcção Coral na cidade de Setúbal (Coral Luísa Todi) e com José Robert no XVII e XVIII Cursos Intensivos de Direcção Coral em Torres Novas. Trabalhou com o maestro José Robert durante os quatro anos do Curso de Direcção Coral na Academia de Amadores de Música. Estudou canto na Escola de Música do Conservatório Nacional. Dirigiu no ano 2000 em Košice (Eslováquia) um workshop dedicado à música renascentista da Sé de Évora, a convite do Coro Collegium Technicum.Leccionou Coro na Escola Profissional de Música de Évora, assim como Educação Vocal na Academia de Música de Évora. Foi preparador vocal do Coro de Câmara Ars Nova, dirigido por Francisco d’Orey e é assistente de direcção de José Robert no Coro da Universidade de Lisboa e no Coro de Câmara da Universidade de Lisboa. No Coro Ricercare trabalhou com Paulo Lourenço como maestro adjunto, passando a maestro titular em 2002. É elemento do Coro Gregoriano de Lisboa, no qual é solista.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.
 
Destaques
Próximos Eventos
Outubro 2024 Novembro 2024
Se Te Qu Qu Se Do
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
Notícias RSS
Newletter




73678255 Visitas

117 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 17 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1728523217' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1728523217' ) AND guest = 1 AND userid = 0 )
5 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 0
6 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 0
7 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 1
8 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 1
9 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'com' AND type = 2
10 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'com' AND type = 2
11 SELECT * FROM jos_menu WHERE id = 17
12 SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access, s.id AS sec_id, cc.id as cat_id FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content' LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.id = 214 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-10 02:35' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-10 02:35' ) AND a.access <= 0
13 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '214'
14 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
15 SELECT params FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
16 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
17 SELECT m.id FROM jos_modules AS m WHERE m.module = 'mod_rssfeed' AND m.published = 1
18 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 17 ) ORDER BY ordering
19 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
20 SELECT m.* FROM jos_menu AS m WHERE menutype = 'associacao' AND published = 1 AND access <= 0 ORDER BY parent, ordering
21 SELECT m.* FROM jos_menu AS m WHERE menutype = 'conservatorio' AND published = 1 AND access <= 0 ORDER BY parent, ordering
22 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
23 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=4'
24 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=5'
25 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
26 SELECT a.id FROM jos_content AS a INNER JOIN jos_categories AS b ON b.id = a.catid WHERE a.state = 1 AND a.access <= 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-10 02:35:18') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-10 02:35:18') 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') <= 20241001 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241001 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241001 ) ) 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') <= 20241001) 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') <= 20241002 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241002 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241002 ) ) 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') <= 20241002) 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') <= 20241003 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241003 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241003 ) ) 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') <= 20241003) 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') <= 20241004 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241004 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241004 ) ) 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') <= 20241004) 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') <= 20241005 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241005 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241005 ) ) 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') <= 20241005) 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') <= 20241006 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241006 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241006 ) ) 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') <= 20241006) 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') <= 20241007 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241007 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241007 ) ) 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') <= 20241007) 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') <= 20241008 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241008 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241008 ) ) 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') <= 20241008) 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') <= 20241009 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241009 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241009 ) ) 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') <= 20241009) 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') <= 20241010 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241010 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241010 ) ) 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') <= 20241010) 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') <= 20241011 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241011 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241011 ) ) 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') <= 20241011) 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') <= 20241012 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241012 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241012 ) ) 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') <= 20241012) 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') <= 20241013 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241013 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241013 ) ) 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') <= 20241013) 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') <= 20241014 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241014 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241014 ) ) 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') <= 20241014) 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') <= 20241015 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241015 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241015 ) ) 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') <= 20241015) 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') <= 20241016 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241016 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241016 ) ) 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') <= 20241016) 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') <= 20241017 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241017 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241017 ) ) 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') <= 20241017) 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') <= 20241018 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241018 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241018 ) ) 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') <= 20241018) 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') <= 20241019 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241019 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241019 ) ) 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') <= 20241019) 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') <= 20241020 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241020 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241020 ) ) 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') <= 20241020) 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') <= 20241021 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241021 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241021 ) ) 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') <= 20241021) 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') <= 20241022 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241022 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241022 ) ) 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') <= 20241022) 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') <= 20241023 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241023 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241023 ) ) 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') <= 20241023) 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') <= 20241024 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241024 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241024 ) ) 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') <= 20241024) 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') <= 20241025 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241025 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241025 ) ) 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') <= 20241025) 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') <= 20241026 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241026 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241026 ) ) 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') <= 20241026) 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') <= 20241027 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241027 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241027 ) ) 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') <= 20241027) 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') <= 20241028 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241028 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241028 ) ) 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') <= 20241028) 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') <= 20241029 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241029 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241029 ) ) 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') <= 20241029) 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') <= 20241030 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241030 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241030 ) ) 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') <= 20241030) 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') <= 20241031 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241031 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241031 ) ) 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') <= 20241031) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
117 SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'