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	2 a 5 de Out - XI Jornadas Internacionais - Concertos na Sé de Évora. A VER! 2 a 5 Outubro de 2008 - XI Jornadas Internacionais "Escola de Música da Sé de Évora      Dia 2 - Grupo Voces Caelestes Dia 3-  Officium - Grupo Vocal     Dia 4 - Grupo - A Sei Voci Dia 5 - Coro Polifónico Eborae Mvsica e Coro dos Participantes Nota: Os bilhetes para o Concerto do Grupo A Sei Voci devem ser adquiridos na Associação Eborae Mvsica, Convento dos Remédios, Évora. Telef: 266 746 750  VER IMAGENS DOS CONCERTOS VER PROGRAMAS E CURRÍCULOS: Dia 2 de Outubro, às 21,30h, Sé de Évora – Grupo “Voces Caelestes”, direcção: Sérgio Fontão. Programa: Duarte Lobo (circa 1565-1646), Audivi vocem de cælo; Filipe de Magalhães (circa 1571-1652), Commissa mea pavesco; Frei Manuel Cardoso (1566-1650), Lamentatio Feria V in Cœna Domini: Lectio II; Frei Manuel Cardoso, Missa pro defunctis - Introitus: Requiem æternam, Kyrie, Graduale: Requiem æternam, Offertorium: Domine, Jesu Christe, Sanctus-Benedictus, Agnus Dei, Communio: Lux æterna e Responsorium: Libera me  Dia 3 de Outubro, 19,00h, Sé de Évora - “Officium – grupo vocal”, direcção de Pedro Teixeira. Programa: Missa Paradisi Portas de Frei Manuel Cardoso – Kyrie, Gloria, Credo, Sanctus e Agnus Dei; Asperges me, a 4 de Manuel Mendes (1547-1605); Quem vidistis, pastores? de Duarte Lobo; O magnum mysterium, de Duarte Lobo; Pater peccavi , de Duarte Lobo; Magnificat octavi toni de Estêvão Lopes-Morago (c.1575- 1630) e O Rex Gloriæ de Estêvão de Brito (1575-1641)  Dia 4 de Outubro; às 21,30h, Sé de Évora – Grupo “A Sei Voci” Programa: “Promenade en Renaissance” - Messe "D'un aultre amer" - Josquin Desprez (français 1440-1521); Motet "Vutum tuum deprecabuntur" - Josquin Desprez; Trois pièces écrites pour Anne de Bretagne :"Quis dabit oculis nostris" - Jean Mouton (français, vers 1460-1522); "Fière atropos" - Pierre Moulon (français, vers 1480/1490 - vers1550); "Transit Anna timor" - Alexander Agricola (franco-flamand, vers 1445-1506); Motet "Versa est in luctum" - Estevao Lopes Morago (português, vers 1575 – vers 1630); Messe à 5 voix "Quarti Toni" - Manuel Cardoso (português, vers 1566-1650) e (bis) Motet "Crux fidelis" - Juan IV de Portugal (1604-1656)  Dia 5 de Outubro, às 17,00h, Sé de Évora. Concerto Final Programa: (participação do Coro Polifónico “Eborae Mvsica”, direcção de Pedro Teixeira). O Coro dos Participantes interpreta a Missa “Veni Domine”, de Duarte Lobo, sob a direcção dos vários Maestros: Peter Phillips, Owen Rees e Armando Possante Voces Caelestes é um grupo vocal de constituição variável, de acordo com as exigências das obras a interpretar. Esta característica, aliada à vasta experiência dos cantores que o integram - que se estende da música medieval à criação musical contemporânea -, permite às Voces Caelestes abordar um extenso repertório.Assim, desde a sua estreia, em Setembro de 1997, o grupo tem interpretado obras de Machaut, Ciconia, Lantins, Dufay, Josquin, Lasso, Victoria, Gesualdo, Allegri, Buxtehude, Bach, Händel, Vivaldi, Scarlatti, Haydn, Brahms, Adam, Franck, Grieg, Stanford, Lloyd Webber e Lopes-Graça, entre outros. Paralelamente, tem feito incursões esporádicas nos domínios da ópera e de outros espectáculos multidisciplinares, tendo participado nas produções de Platée (Rameau), Szenen aus Goethes Faust (Schumann), Die Zauberflöte, Le Nozze di Figaro (Mozart), La Fille du Régiment (Donizetti), A Midsummer Night’s Dream (Mendelssohn) e Peter Pan (Bernstein) encenadas por Tito Celestino da Costa. A par do seu empenhamento na divulgação da música antiga portuguesa - traduzido, até agora, na apresentação de obras de Estêvão Lopes Morago, Diogo Dias Melgaz, Francisco Martins, António Teixeira, Carlos Seixas, Francisco António de Almeida, João Rodrigues Esteves e Pedro António Avondano -, as Voces Caelestes têm dedicado especial atenção à música contemporânea. Neste âmbito, estrearam em Portugal as Street Songs, de Steve Martland, e apresentaram em estreia mundial obras de Alain Bioteau (Vat 69), Pedro Amaral (Os Jogadores de Xadrez) e Pedro Carneiro (… ni mots, ni signes…). Este vasto repertório tem sido apresentado em diversos auditórios de Lisboa (Centro Cultural de Belém, Culturgest, Fundação Calouste Gulbenkian, Teatro Municipal de S. Luiz, Jardim Botânico e Palácio Nacional da Ajuda, Sé Patriarcal, Basílica dos Mártires, Igreja de S. Nicolau, Igreja de S. Roque, Igreja de S. Vicente de Fora e Convento do Beato), bem como noutras localidades (Cascais, Caxias, Coimbra, Évora, Fátima, Mértola, Óbidos, Porto, Santarém, Santiago do Cacém, Setúbal), no âmbito de algumas das mais prestigiadas manifestações musicais (Festival de Música Sacra do Baixo Alentejo, Festival Internacional de Música de Coimbra, Comemorações dos 250 Anos do Nascimento da Cantora Luísa Todi, Música em S. Roque, Festival Internacional de Órgão de Lisboa, Festival Rota dos Monumentos). Em Agosto de 2006, as Voces Caelestes fizeram a sua estreia internacional, participando, com grande sucesso, no prestigiado Festival Internacional de Música Antiga de Daroca (Espanha). O grupo participou na gravação do CD de música sacra Alleluia, da soprano Teresa Cardoso de Menezes, e gravou para a RTP excertos do Te Deum de Frei José Marques e Silva. As Voces Caelestes têm-se apresentado a cappella e em colaboração com instrumentistas como a cravista Ana Mafalda Castro, a harpista Stéphanie Manzo, a pianista Ana Telles, a contrabaixista Marta Vicente, os organistas António Duarte, Rui Paiva, Sérgio Silva e João Vaz, os violoncelistas Paulo Gaio Lima e Miguel Ivo Cruz e os percussionistas Abel Cardoso, Pedro Carneiro e Jean-François Lézé, e formações instrumentais como a Camerata Academica Salzburg, a Orquestra Metropolitana de Lisboa, a orquestra barroca Capela Real, a Orquestra de Câmara Portuguesa e os Segréis de Lisboa, sob a direcção dos maestros Pedro Amaral, Stephen Barlow, Martyn Brabbins, Pedro Carneiro, Harry Christophers, Laurence Cummings, Christian Curnyn, Sérgio Fontão, Alexander Frey, Manuel Ivo Cruz, Manuel Morais, Elio Orciuolo, Jean-Bernard Pommier, João Paulo Santos, Peter Schreier e Michael Zilm. Direcção: Sérgio Fontão Sopranos: Ana Rodrigues, Graziela Lé, Marisa Figueira, Rosa Caldeira, Sandra Lourenço, Susana Duarte Altos: Catarina Saraiva, Joana Nascimento, Mafalda Borges Coelho, Manon Marques, Michelle Rollin, Patrícia Mendes Tenores: Jaime Bacharel, João Branco, João Moreira Baixos: José Bruto da Costa, Manuel Rebelo, Mário Almeida  Sérgio Fontão iniciou os estudos musicais aos cinco anos de idade, sob a orientação de seu pai. Posteriormente, frequentou a Escola de Música e Bailado de Linda-a-Velha e a Escola de Música do Conservatório Nacional, onde estudou Piano com Dinorah Cruz, Harpa com Fausto Dias, Percussão com Joaquim Galvão e Canto com Filomena Amaro, Liliana Bizineche, Joana de Quinhones-Levy e António Wagner Diniz. Paralelamente, concluiu a Licenciatura em Comunicação Social na Faculdade de Ciências Sociais e Humanas da Universidade Nova de Lisboa e o Curso de Gestão das Artes no Centro de Formação do Centro Cultural de Belém. Frequentou cursos de aperfeiçoamento em Canto com Jill Feldman, Marius van Altena, Max von Egmond, Peter Harvey e Tom Krause; em Música Antiga com Richard Gwilt, Ketil Haugsand, Peter Holtslag, Jonathan Manson, Owen Rees e Rainer Zipperling; em Direcção Coral com Luc Guilloré, Tõnu Kaljuste, David Lawrence, Julian Wilkins, Simon Halsey, André Thomas, Frieder Bernius, Peter Broadbent, Colin Durrant e Jo McNally; e em Direcção de Orquestra com Robert Houlihan. Integra o corpo docente dos Cursos de Direcção Coral e Técnica Vocal promovidos pelo INATEL.Como membro ou director de diversas formações vocais e instrumentais, realizou concertos em Portugal, Espanha, França, Bélgica, Holanda, Reino Unido, Áustria, Itália, Malta, Brasil, Argentina, Uruguai, México, EUA, Canadá, Índia, Japão e China. Participou, também, em espectáculos de ópera e teatro e efectuou gravações para cinema, rádio, televisão e em disco, para as etiquetas Aria Music, Dinemec Classics, EMI Classics, Fnac Music, Milan, Movieplay Classics, Numérica, Philips, PortugalSom, Sole mio, Virgin Classics e Virgin Veritas.Entre os diversos agrupamentos com os quais tem colaborado, contam-se o Coro Gulbenkian, Coro de Câmara de Lisboa, Vozes Alfonsinas, Smoking Voices, Ensemble Barroco do Chiado, Ensemble Orphée et Coetera, Concertus Antiquus, Coro Dom Luís I, Cantus Firmus, Syntagma Musicum, Camerata Vocal de Lisboa e Coro do Teatro Nacional de São Carlos. Actualmente, além do grupo vocal Voces Caelestes, dirige os coros Polyphonia Schola Cantorum, Coral In Vita Musica, Coro do Grupo Desportivo e Cultural do Banco de Portugal, Coral Encontro e Coral Vértice (grupo vocal masculino fundado em 1974 por cantores do Coro Gulbenkian).Paralelamente ao seu trabalho como intérprete, tem desenvolvido actividade nas áreas do jornalismo, da comunicação institucional, da edição de música impressa e da gestão de projectos e instituições culturais.  O Grupo Vocal Officium foi fundado em Outubro de 2000 pelo seu orientador Pedro Teixeira; o grupo vocal Officium é um projecto que pretende dar primazia à interpretação de obras polifónicas de compositores portugueses dos sécs. XVI – XVII, dado o vastíssimo património existente – muito dele ainda por descobrir – ao nível da produção musical da época. Apresenta-se regularmente em Concerto no país e no estrangeiro. A cada vez maior exigência que assiste à linha orientadora do seu trabalho, aliada à valência prestada pelos cantores profissionais que o integram, tem feito com que o Officium se tenha destacado no panorama musical português – e não só – como grupo idóneo e qualificado para a interpretação da música renascentista e até contemporânea.  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.  O Ensemble Vocal “A Sei Voci” constituiu-se em 1977, com o objectivo da redescoberta de composições não publicadas até então, dos períodos da Renascença e Barroco, que interpreta com espírito da época embora dando aos seus concertos uma dimensão visual, aumentando o poder emocional da Música.A interpretação dos músicos é baseada na investigação mais recente levada a cabo em colaboração com vários musicólogos. Cada produção nove envolve muito trabalho de pesquisa, envolvendo a reconstrução dos manuscritos originais, investigação da interpretação, Concertos, Master Classes, apresentações e gravações Embora mostrem grande respeito na sua interpretação pelo trabalho e reportório, também são capazes de se libertar das regras estabelecidas e do seu peso para encontrar um forma de cantar que é profundamente sensual.“A Sei Voci” é variável na sua dimensão, com um grupo de base de seis cantores a que se juntam outros cantores e instrumentistas de acordo com o Programa. Em 1991, o Ensemble foi reestruturado em torno de um dos seus fundadores, Bernard Fabre-Garrus. Em poucos anos atingiu uma excelente reputação internacional no reportório polifónico; em 1994 foi votado como “Ensemble Vocal do Ano” no “French Victories” da Música Clássica. “A Sei Voci” dão cerca de sessenta concertos anaualmente, em França e no estrangeiro, participando nos eventos mais prestigiados. As suas gravações para a Editora Audivis/Astrée (Josquin Desprez, Allegri, Bencini, Janequin, Jommelli) receberam muitos prémios e críticas favoráveis. O Ensemble também está atenta à criação musical no presente e inspirou e estreou obras de Thierry Escaich, Michel Decoust, Guy Reibel, Michel Levinas e Laurent Cuniot, que passaram a integrar o seu reportório. “A Sei Voci” ´é subsidiado pela comunidade Sarthe, pelo Município de Sarthe, pelo Governo Regional do Loire e pelo Ministério da Cultura.   [ 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 Dezembro 2019 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 63117846 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 = 17 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1714067540' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1714067540' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
6
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 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 = 285 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 19:07' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 19:07' )
 AND a.access <= 0
13
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '285'
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 = 17 )
 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-04-25 19:07:22') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 19:07:22')
 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') <= 20191201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191201 ) ) 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') <= 20191201) 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') <= 20191202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191202 ) ) 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') <= 20191202) 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') <= 20191203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191203 ) ) 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') <= 20191203) 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') <= 20191204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191204 ) ) 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') <= 20191204) 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') <= 20191205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191205 ) ) 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') <= 20191205) 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') <= 20191206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191206 ) ) 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') <= 20191206) 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') <= 20191207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191207 ) ) 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') <= 20191207) 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') <= 20191208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191208 ) ) 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') <= 20191208) 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') <= 20191209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191209 ) ) 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') <= 20191209) 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') <= 20191210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191210 ) ) 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') <= 20191210) 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') <= 20191211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191211 ) ) 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') <= 20191211) 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') <= 20191212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191212 ) ) 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') <= 20191212) 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') <= 20191213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191213 ) ) 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') <= 20191213) 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') <= 20191214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191214 ) ) 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') <= 20191214) 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') <= 20191215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191215 ) ) 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') <= 20191215) 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') <= 20191216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191216 ) ) 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') <= 20191216) 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') <= 20191217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191217 ) ) 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') <= 20191217) 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') <= 20191218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191218 ) ) 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') <= 20191218) 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') <= 20191219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191219 ) ) 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') <= 20191219) 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') <= 20191220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191220 ) ) 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') <= 20191220) 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') <= 20191221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191221 ) ) 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') <= 20191221) 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') <= 20191222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191222 ) ) 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') <= 20191222) 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') <= 20191223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191223 ) ) 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') <= 20191223) 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') <= 20191224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191224 ) ) 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') <= 20191224) 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') <= 20191225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191225 ) ) 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') <= 20191225) 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') <= 20191226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191226 ) ) 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') <= 20191226) 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') <= 20191227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191227 ) ) 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') <= 20191227) 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') <= 20191228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191228 ) ) 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') <= 20191228) 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') <= 20191229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191229 ) ) 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') <= 20191229) 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') <= 20191230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191230 ) ) 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') <= 20191230) 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') <= 20191231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20191231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20191231 ) ) 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') <= 20191231) 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'