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	Programação Horários 2016/2017 - Conservatório Regional de Évora - Eborae Música Horários 2016/2017 VER AQUI!           Ler mais...   Horários 2016/2017 - Conservatório Regional de Évora - Eborae Música   23 Julho 21h30 Quinteto de Cordas XVII CICLO DE CONCERTOS “MÚSICA NOS CLAUSTROS”  A Música e a animação do património   A Associação Eborae Mvsica está a promover o XVII Ciclo de Concertos “Música nos Claustros”, entre 1 e 23 de Julho. Participam grupos e solistas nacionais e internacionais. A polifonia, o canto solista e a execução instrumental percorrem os vários períodos musicais.  O programa integra os seguintes recitais e concertos: Dia 1 de Julho, às 21h30, Orquestra do Conservatório Regional de Évora-Eborae Mvsica, sob a direção de Luis Rufo e tendo como solistas alunos de piano violino, violoncelo e contrabaixo e dia 2 Coro Polifónico “Eborae Mvsica”, direção de Eduardo Martins e com a pianista acompanhadora Ana Filipa Luz; dia 17 pelas 18h30 Coro Viva Voz sob a direção de Eduardo Martins e dia 23 pelas 21h30 Quinteto de Cordas. Os três primeiros concertos decorreram com sucesso e foram do agrado do público.  No dia 23 de Julho pelas 21h30, o programa é: Mozart, Wolfgang Amadeus (1756-1791)- Divertimento in F major, K.138/125c (1772)- I. Allegro; II. Andante; III. Presto e Inverno em Buenos Aires - Astor Piazzolla; Oblivion - Astor Piazzolla; Primavera Porteña - Astor Piazzolla; Melodia em Lá menor - Astor Piazzolla; Adios Noniño - Astor Piazzolla. O Quinteto de Cordas é constituído por: Luis Rufo – Violino -Natural de Évora. É Licenciado em Violino pela Escola Superior de Música de Lisboa com Gareguine Arouthounian. Estudou no Mestrado em Violino na Universidade de Évora, na Classe de Valentim Stefanov. Frequentou Masterclasses com Ifrah Neaman, Stephen Bull, Massimo Mazzeo, Bertrand Bordeaux e Robert Houlihan. Tem colaborado com várias orquestras portuguesas, como a Orquestra Gulbenkhian, Orquestra Filarmonia das Beiras, Orquestra de Câmara de Cascais e Oeiras, Orquestra Clássica do Algarve, etc, tendo trabalhado com os maestros Lawrence Foster, Michael Zlim, James Tuggle, Vasco de Azevedo, Miguel Ivo-Cruz, Nikolay Lalov, Horst Zell, Christhoper Bochmann, Miguel Graça Moura, Rodolf Barshai, Muhai Tang, entre tantos outros. foi Concertino da Orquestra da EPMEV, em Portugal e Espanha, Moçambique e nos Pirinéus.  Susana Nogueira – Violino -Natural de Lisboa. É Licenciada em Violino pela Escola Superior de Música de Lisboa na Classe de Khatchatour Amirkhanian. Estudou no Mestrado em Violino na Universidade de Évora, na Classe do Prof. Valentim Stefanov, e estudou violino baroco com Iskrena Yordanova. Frequentou  Masterclasses com Gerardo Ribeiro,  Lavard Skou-Larsen, Stephen Bull, Ifrah Neaman, Jaap Schroeder, Massimo Mazzeo, Christopher Bochmann,  Georges Hadjinikos, Jean-Sébastian Beraut, Robert Houlihan e Bertrand Bordeaux. Foi concertino da Orquestra Sinfónica Juvenil e estagiou na Orquestra Erasmus em França, e na Orquestra de Câmara de Cascais e Oeiras. Apresenta-se regularmente em agrupamentos de câmara, particularmente quarteto e quinteto de cordas e colabora com várias orquestras, tendo actuado por todo o País e em Espanha, França, Bélgica, Alemanha, Itália, Bulgária e Grécia. Bruno Correia – Viola d’Arco -Natural de Mirandela. É Licenciado em Viola d' Arco pelo Departamento de Artes da Universidade de Évora onde estudou com Valentin Stefanov e João Lucena e Vale. Estudou no Mestrado em Viola ‘Arco na Universidade de Évora na Classe de Viola d’Arco de Paul Wakabayashi e encontra-se a concluir o Mestrado em Ensino na Escola Superior de Artes Aplicadas de Castelo Branco. Frequentou Masterclasses com Max Rabinovitsj, Paul Wakabayashi, Ryszard Woycicki, Chao Bin, Massimo Mazzeo e Paulo Gaio Lima. Trabalhou com Danuta Grossmanova, Ernst Schelle, Max Rabinovitjs, Roberto Perez, Carlos Riazuelo, Christopher Bochmann, Nuno Dario e Pedro Neves. Integrou diversas orquestras entre as quais, Orquestra APROARTE como chefe de naipe, Orquestra de Câmara de Coimbra, Orquestra da Universidade de Évora, entre outras, onde trabalhou com interpretes prestigiados tais como, Misha maisky, Boris Beresovsky e Bruno Pasquier. Apresenta-se regularmente em agrupamentos de câmara. Samuel Santos – Violoncelo - Natural de Évora. É Licenciado em Violoncelo pela Escola Superior de Artes Aplicadas de Castelo Branco, estudou com Miguel Ivo Cruz, Marília Peixoto, Clélia Vidal, Miguel Rocha e Catherine Strynckx. Estudou no Mestrado da Universidade de Évora na classe de Violoncelo de Paulo Gaio Lima. Foi distinguido com o Prémio Jovens Músicos 2003, em Música de Câmara, em Nível Superior. Frequentou classes de aperfeiçoamento com Márcio Carneiro, Paulo Gaio Lima, Jian Wang, António Menezes, Xavier Gagnepain e Anner Bylsma, entre outros. Colabora com a Orquestra Gulbenkian, Orquestra Filarmonía das Beiras, Orquestra Metropolitana de Lisboa, Orquestra Sinfonietta de Lisboa, Orquestra do Algarve, Orquestra “Divino Sospiro” e agrupamentos de câmara, em concertos por todo o País e no estrangeiro, nomeadamente em Espanha, Moçambique, Alemanha e Brasil. Hugo Monteiro – Contrabaixo -Licenciado em Contrabaixo pelo Departamento de Artes da Universidade de Évora com Iouri Axenov.Frequentou Masterclasses com Rinat Imbraguimov, Rainer Zepperitz e Fernando Flores. Trabalhou com Elisabeth Perry, Max Rabinovitsj, João Panta Nunes, Miguel Pereira, Alexandre Samardjiev e Duncan Fox, entre outros. Integrou diversas orquestras entre as quais Orquestra APROARTE, International Orchestra of Luxembourg, ERASMUS String Orchestra, Orquestra do Algarve e Orquestra Filarmonia das Beiras, tendo trabalhado com os maestros Oliver Diaz Suarez, Christopher Bochmann, Gerard Doherty, Álvaro Cassuto e Richard Hortien, onde acompanhou solistas como António Rosado, Alex Klein, Stefan Dohr, Nina Schumann e Bruno Pasquier. Colabora frequentemente em diversas formações por todo o país.  Estas atividades são organizadas pela Associação Musical “Eborae Mvsica” com apoios por parte do Ministério da Educação, Câmara Municipal de Évora e dos órgãos de Comunicação Social.   Outubro, 2 a 4 - Jornadas Escola de Música da Sé de Évora. Folheto XVIII Jornadas Internacionais “Escola de Música da Sé de Évora” - Direção Artística de Pedro Teixeira 2 a 4 de Outubro – Convento dos Remédios - Évora  Conferencista: Paulo Estudante  Maestros: Peter Phillips, Armando Possante, Pedro Teixeira Concertos: 3 de Outubro - 19h00 - Concerto na Sé de Évora. “Capella de Ministrers”, direção: Carles Magraner 4 de Outubro - 17,00h - Concerto Final na Sé de Évora (traje apropriado); Coro Polifónico “Eborae Mvsica”, direção de Eduardo Martins. Coro dos Participantes, direção de Peter Phillips, Armando Possante, Pedro Teixeira. Encerramento oficial das Jornadas e distribuição de Certificados de Participação 2 Outubro  8,30h - Abertura do Secretariado; 9,00h - Sessão de Abertura; 9,30h - Pausa para Café; 9,45h - Conferência pelo Professor Paulo Estudante sobre a utilização das charamelas na Sé de Évora e Igrejas Portuguesas; 10,45h - Atelier conjunto; 12,30h - Almoço; 14,00h - Visita guiada pelo Dr. Jorge Raposo ao Museu de Arte Sacra (antigo Colégio dos Moços da Sé de Évora) e obras dos Arquivos da Sé de Évora; 15,30h - 18h30 - Atelier conjunto; 20,00h - Jantar Convívio (facultativo) 3 Outubro 9,00h - Ateliers (Os participantes, divididos em grupos, trabalharão Obras de Filipe de Magalhães, sob a direção dos vários Maestros); 12,15h - Almoço; 13,45h / 14,45h - Conversa com os Maestros; 14h45h - Pausa para café; 15,00h / 18h00 - Atelier Conjunto. 19h00 - Concerto na Sé de Évora. “Capella de Ministrers”, direção: Carles Magraner 4 Outubro 9,00h - Ateliers; 12,30h - Almoço; 14,00h / 16,00h - Ensaios (Sé de Évora) 17,00h - Concerto Final na Sé de Évora (traje apropriado); Coro Polifónico “Eborae Mvsica”, direção de Eduardo Martins; Coro dos Participantes, direção de Peter Phillips, Armando Possante, Pedro Teixeira Encerramento oficial das Jornadas e distribuição de Certificados de Participação   Outubro, 2 a 4 - Jornadas Escola de Música da Sé de Évora. Folheto XVIII Jornadas Internacionais “Escola de Música da Sé de Évora” Direção Artística de Pedro Teixeira   2 a 4 de Outubro – Convento dos Remédios - Évora   Conferencista: Paulo Estudante   Maestros: Peter Phillips, Armando Possante, Pedro Teixeira   Concertos: 3 de Outubro - 19h00 - Concerto na Sé de Évora. “Capella de Ministrers”, direção: Carles Magraner; 4 de Outubro - 17,00h - Concerto Final na Sé de Évora (traje apropriado); Coro Polifónico “Eborae Mvsica”, direção de Eduardo Martins. Coro dos Participantes, direção de Peter Phillips, Armando Possante, Pedro Teixeira. Encerramento oficial das Jornadas e distribuição de Certificados de Participação 2 Outubro   8,30h - Abertura do Secretariado 9,00h - Sessão de Abertura 9,30h - Pausa para Café 9,45h - Conferência pelo Professor Paulo Estudante sobre a utilização das charamelas na Sé de Évora e Igrejas Portuguesas 10,45h - Atelier conjunto 12,30h - Almoço 14,00h - Visita guiada pelo Dr. Jorge Raposo ao Museu de Arte Sacra (antigo Colégio dos Moços da Sé de Évora) e obras dos Arquivos da Sé de Évora 15,30h - 18h30 - Atelier conjunto 20,00h - Jantar Convívio (facultativo) 3 Outubro 9,00h - Ateliers (Os participantes, divididos em grupos, trabalharão Obras de Filipe de Magalhães, sob a direção dos vários Maestros) 12,15h - Almoço 13,45h / 14,45h - Conversa com os Maestros 14h45h - Pausa para café 15,00h / 18h00 - Atelier Conjunto 19h00 - Concerto na Sé de Évora. “Capella de Ministrers”; Direção: Carles Magraner 4 Outubro 9,00h - Ateliers 12,30h - Almoço 14,00h / 16,00h - Ensaios (Sé de Évora) 17,00h - Concerto Final na Sé de Évora (traje apropriado); Coro Polifónico “Eborae Mvsica”, direção de Eduardo Martins Coro dos Participantes, direção de Peter Phillips, Armando Possante, Pedro Teixeira Encerramento oficial das Jornadas e distribuição de Certificados   de Participação   Outubro, 2 a 4 - Jornadas Escola de Música da Sé de Évora. Folheto   Mais... Outubro, 2 a 4 - Jornadas Escola de Música da Sé de Évora. Folheto [ 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 Outubro 2024 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 31 Notícias RSS Newletter Name Email 74074713 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 = 5 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1729010514' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1729010514' )
 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 = 5
12
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-15 17:56' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 17:56' )
 AND ( a.sectionid=1 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
13
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.deletable,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-15 17:56' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 17:56' )
 AND ( a.sectionid=1 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.created DESC
LIMIT 10
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
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'
16
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
17
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 = 5 )
 ORDER BY ordering
18
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
20
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
21
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
22
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
23
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
24
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
25
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-15 17:56:55') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 17:56:55')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
26
SELECT *
 FROM jos_content
 WHERE id = '1332'
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 = 1332
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
28
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
29
SELECT *
 FROM jos_content
 WHERE id = '1333'
30
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
31
SELECT *
 FROM jos_content
 WHERE id = '1334'
32
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
33
SELECT * FROM jos_jcalpro_config
34
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
35
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
36
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
37
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
38
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
39
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
40
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
41
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
42
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
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 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
44
SELECT
  	cat_id, level
  FROM
  	jos_jcalpro_categories
45
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
46
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
47
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
48
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
49
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
50
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
51
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
52
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
53
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
54
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
55
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
56
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
57
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
58
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
59
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
60
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
61
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
62
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
63
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
64
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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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
78
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
79
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
80
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
81
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
82
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
83
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
84
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
85
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
86
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
87
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
88
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
89
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
90
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
91
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
92
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
93
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
94
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
95
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
96
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
97
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
98
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
99
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
100
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
101
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
102
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
103
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
104
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
105
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
106
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
107
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
108
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
109
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
110
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
111
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
112
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
113
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
114
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
115
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
116
SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'