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
Arquivo



Existem entradas arquivadas para 11 2020


Concerto por Trio de Clarinete, Violino e Piano antecipado dia 22/11 para as 11h00 Imprimir e-mail

Concerto por Trio de Clarinete, Violino e Piano antecipado dia 22/11 para as 11h00 - XVI Ciclo de Concertos "Música no Inverno"

 Programa: Resiliencias - María José Arenas-Martín (2018) ;  Returning  – Pedro Faria Gomes (2010);- Aleppo - Luís Tinoco (2019); - Fulgor - Jesús Torres (2017).

concerto_clarinete_20.jpgA Associação Eborae Mvsica realiza, em articulação com a Câmara Municipal de Évora, em Novembro e Dezembro, o XVI Ciclo de Concertos "Música no Inverno”, uma atividade destinada a enriquecer a oferta cultural da cidade nos meses de inverno. Pretende, ainda, apresentar obras dos secs XX e XXI. 
No dia 22 de novembro às 11h00 haverá um concerto por Trio de Clarinete (Rui Travasso), Violino (Rodrigo Gomes) e Piano (Irene Renart).

Rodrigo Gomes - Nascido em Lisboa,  iniciou os seu estudos musicais na escola profissional de música de Viana do Castelo na classe do professor Serguey Arutiunian. Após terminar a licenciatura na  ESML, é admitido no conservatório de Roterdão na classe da professora Olga Martinova, onde obtém o Mestrado em Performance.    Vencedor do prémio jovens músicos em musica de câmara e membro fundador dos quartetos Vianna da Motta e Quarteto Blanc, Rodrigo Gomes tem-se apresentado em festivais de música por toda a Europa e Ásia.

Rui Travasso- Natural de Évora, é licenciado pela Escola Superior de Música de Lisboa em Clarinete, Pós-graduado em performance clássica pela Zuid- Nederlandse Hogeschool voor Muziek (Holanda) e Mestre em ensino da música pelo Instituto Piaget de Almada. Lecionou no Conservatório Regional de Évora- Eborae Mvsica, Conservatório Regional de Palmela, Academia de Música de Óbidos e Conservatório Regional do Algarve. Atualmente é solista A da Orquestra Clássica do Sul e professor no Conservatório de Música de Loulé- Francisco Rosado.Rui Travasso é artista Yamaha e D´Addario Reserve Player.

Irene Renart  - Nascida em Valência, apresentou-se pela primeira vez ao público aos doze anos, no festival de Saintonge, França. Após finalizar a licenciatura no conservatório de Valência, é admitida no conservatório de Roterdão, onde obtém o mestrado em performance musical na classe do professor Aquiles Delle Vigne. Tendo recebido conselhos de pianistas como Josep Maria Colon, Jean Bernard Pommier e Yuri Ananiev, entre outros, Irene tem-se apresentado como solista e em música de camara em festivais por toda a Europa.

Este ciclo prossegue com os seguintes Concertos:  no dia 27 às 21h30 - Orquestra de Câmara de Cascais e Oeiras, com direção de Nikolay Lalov ; no dia 28 às 18h00 (ou 11h00, de acordo com decisão do Primeiro Ministro) Concerto por KVAR Ensemble ;  no mês de Dezembro : Dia 5 – às 18h00 (ou 11horas) Recital de Guitarra por Eurico Pereira; Dia 6 – às 18h00 ou 11 h00) - Recital de Flauta , Oboé e Clarinete ; Dia 13 às 18h00 ou 11h00-  Concerto de Natal com o Coro Polifónico “Eborae Mvsica”, dirigido pelo Maestro Eduardo Martins

É necessário reserva prévia de bilhetes através de Este endereço de e-mail está protegido contra spam bots, pelo que o JavaScript terá de estar activado para que possa visualizar o endereço de email .É obrigatório o uso de máscara.

Ler mais...
 
Concerto por “Os Músicos do Tejo”, dia 21/11, antecipado para as 11h00 Imprimir e-mail

Concerto por “Os Músicos do Tejo”, dia 21/11,  antecipado para as 11h00 - XVI Ciclo de Concertos "Música no Inverno"

Programa: Georg Friedrich Händel (1685-1759)  - Concerto grosso em Lá menor op. 6 Nº 4 , Larghetto affetuoso – Allegro - Largo e piano – Allegro;G.P. Telemann (1681-1767) - Overture-Suite"LesNations",TWV55:B5 ,Ouverture - Menuet I alternativement,. Menuet II - Les Turcs - Les Suisses - Les Moscovites - Les Portugais - Les Boiteux - Les Coureurs; W. Byrd (1543-1623)- La Volta;  J. Dowland (1563-1626)/Anónimo , The Earle of Essex Galiard/Can Shee ; Francisco António de Almeida (c.1702-1755?)- Sinfonia (excertos) em Fá maior, Stacatto - Andante e piano sempre; J.-P. Rameau (1683-1764) - Suite da ópera Naïs (excertos): Premier Tambourin, Deuxième Tambourin, Premier Tambourin, Deuxième Tambourin, Premier Rigaudon, Deuxième Rigaudon ; Georg Philipp Telemann - Suite "La Changeante" TWV 55:g2 (excertos), III. Les Scaramouches V. La Plaisanterie VI. Hornpipe VII. Avec Douceur. 
os_musicos_do_tejo_20.jpg























A Associação Eborae Mvsica realiza, em articulação com a Câmara Municipal de Évora, em Novembro e Dezembro, o XVI Ciclo de Concertos "Música no Inverno”, uma atividade destinada a enriquecer a oferta cultural da cidade nos meses de inverno
. Pretende, ainda, apresentar obras dos secs XX e XXI. 
No dia 21 de novembro às 11h00 haverá um concerto: “Uma viagem pelo Barroco Instrumental Europeu” por “Os Músicos do Tejo” – direção de Marta Araújo e Marcos Magalhães, com Direcção Musical e Cravo - Marcos Magalhães Cravo - Marta Araújo; Oboé e flauta de bisel – Pedro Castro; Violinos - Álvaro Pinto e Nuno Mendes; Viola - Paul Wakabayashi; Violoncelo -  Ana Raquel Pinheiro; Contrabaixo - Pedro Wallenstein. 
Os Músicos do Tejo- Projeto musical no campo da música antiga fundado e dirigido por Marcos Magalhães e Marta Araújo.“Os Músicos do Tejo” tiveram a sua primeira apresentação em Setúbal em Dezembro de 2005 e na sua curta existência como grupo especializado em música antiga já desenvolveram uma parceria com o CCB que os levou produzir três óperas, editaram dois discos, apresentaram-se em inúmeros concertos em Portugal e no estrangeiro e foram objeto de diversos apoios institucionais .As duas óperas “La Spinalba” de F. A. de Almeida e “Lo Frate Nanmorato” de G.B. Pergolesi CCB, estrearam em Maio de 2011, a ópera “Le Carnaval et la Folie” de A.C. Destouches e em Janeiro de 2013, a serenata “Il Trionfo d’ Amore” de F.A. Almeida, ambas com excelente acolhimento por parte do público e da crítica especializada. Em Novembro de 2012 foi editado pela Naxos a sua gravação da ópera La Spinalba de F. A. de Almeida. O CD para a editora Naxos, “Il Trionfo d'Amore”, de F.A. Almeida, tem tido um excelente acolhimento por parte da crítica O agrupamento Os Músicos do Tejo apresenta-se em várias formações que vão desde a Música de Câmara até à Música Orquestral e Coral. Os Músicos do Tejo são apoiados pela Câmara Municipal de Lisboa e Biblioteca Nacional de Portugal. 
Este ciclo prossegue com os seguintes Concertos:  no dia 22 , às 11h00– Trio de Clarinete, Violino e Piano ; no dia 27 às 21h30 - Orquestra de Câmara de Cascais e Oeiras, com direção de Nikolay Lalov ; no dia 28 às 18h00 (ou 11h00, de acordo com decisão do Primeiro Ministro) Concerto por KVAR Ensemble ;  no mês de Dezembro : Dia 5 – às 18h00 (ou 11horas) Recital de Guitarra por Eurico Pereira; Dia 6 – às 18h00 ou 11 h00) - Recital de Flauta , Oboé e Clarinete ; Dia 13 às 18h00 ou 11h00-  Concerto de Natal com o Coro Polifónico “Eborae Mvsica”, dirigido pelo Maestro Eduardo Martins. 
É necessário reserva prévia de bilhetes através de Este endereço de e-mail está protegido contra spam bots, pelo que o JavaScript terá de estar activado para que possa visualizar o endereço de email .É obrigatório o uso de máscara

Ler mais...
 
Novembro, 14, 18h00, Recital de Piano por Artur Pizarro Imprimir e-mail

Nov, 14, 18h00, Recital de Piano por Artur Pizarro - XVI Ciclo de Concertos "Música no Inverno"

Programa:  Villa-Lobos. Homage à Chopin - 1) Nocturne , 2) Ballade ; Ravel.-  Gaspard de la nuit - 1) Ondine, 2) Le gibet , 3) Scarbo ; Britten. Night piece ; Prokofiev. Sonata no.6 em lá maior, Op. 82 - 1) Allegro moderato, 2) Allegretto, 3) Tempo di valzer lentíssimo, 4) Vivace.
artur_pizarro.jpg































A Associação Eborae Mvsica realiza, em articulação com a Câmara Municipal de Évora, em Novembro e Dezembro, o XVI Ciclo de Concertos "Música no Inverno”, uma atividade destinada a enriquecer a oferta cultural da cidade nos meses de inverno
. Pretende, ainda, apresentar obras dos secs XX e XXI.
Artur Pizarro - apresentou-se em público pela primeira vez aos três anos de idade e no ano seguinte apresentou-se na RTP ao lado do Professor Campos Coelho (aluno de Vianna da Motta, Isidor Phillip e Ricardo Viñes) no programa Histórias da Música de Victorino d'Almeida. Os seus primeiros passos ao piano foram acompanhados pela sua avó materna, a pianista Berta da Nóbrega e pelo Professor Campos Coelho. Mais tarde, entre 1974 e 1990 Artur Pizarro estudou em Portugal e nos EUA com Sequeira Costa (também aluno de Vianna da Motta e também de Mark Hambourg, Marguerite Long, Jacques Février e Edwin Fischer). Durante um ano frequentou também a classe de Aldo Ciccolini no Conservatório Nacional Superior de Paris e recebeu aulas de Bruno Rigutto. Esta linhagem deu a Artur Pizarro um raro conhecimento da escola francesa e da alemã diretamente da Idade d'Ouro do pianismo do século XX. Artur Pizarro detém três primeiros prémios de concursos internacionais, nomeadamente o Concurso Vianna da Motta em 1987, o Greater Palm Beach Invitational Piano Competition de 1989 (onde seis primeiros prémios de  concursos internacionais são convidados a competir) e o Leeds International Piano Competition de 1990 que verdadeiramente lançou a sua grande carreira internacional. Atua regularmente em recitais a solo, em duo de piano com Rinaldo Zhok e em concertos de musica de câmara. Apresenta-se também com as mais prestigiadas orquestras por todo o mundo dirigido pelos mais conhecidos maestros. Tem uma extensa discografia (perto de 50 cd's) e as suas gravações constam nos catálogos das mais conhecidas editoras. 

Em reconhecimento da relevância da sua carreira, foi galardoado na sua terra natal com o Prémio Bordalo, o Premio SPA, a Medalha de Mérito Cultural da Cidade de Funchal e a Medalha de Mérito Cultural de Portugal. Em 2014 foi-lhe atribuído o Prémio Albéniz pelo Festival Albéniz em Camprodon, Espanha, reconhecendo o seu trabalho pela divulgação da Suite Iberia através da sua gravação e inúmeras atuações em palco. Atualmente leciona no seu estúdio em Oeiras onde dá aulas particulares e desempenha o cargo de Professor Adjunto Convidado na ESML. Frequentemente, Artur Pizarro oferece masterclasses em vários locais internacionais.

Este ciclo prossegue com os seguintes Concertos:  no dia 21 às 18h00 comUma Viagem pelo Barroso Instrumental Europeu” por “Os Músicos do TejoDireção Musical e Cravo – Marcos Magalhães;  no dia 22 , às 18h00– Trio de Clarinete, Violino e Piano por - Rui Travasso, Rodrigo Gomes e Irene Renart; no dia 27 às 21h30 - Orquestra de Câmara de Cascais e Oeiras, com direção de Nikolay Lalov ; no dia 28 às 18h00 Concerto por KVAR Ensemble (Duarte Martins, Madalena Neto, Sara Liano, Nuno Cardoso);  no mês de Dezembro sempre às 18h00: Dia 5  Recital de Guitarra por Eurico Pereira; Dia 6 – Recital de Flauta , Oboé e Clarinete  por Mariana Moreira, Maria Susete Afonso e Mário Vinagre; Dia 13  Concerto de Natal com o Coro Polifónico “Eborae Mvsica”, dirigido pelo Maestro Eduardo Martins que irá apresentar em estreia a obra de João NascimentoMissa -Nossa Senhora dos Remédios”
É necessário reserva prévia de bilhetes através de Este endereço de e-mail está protegido contra spam bots, pelo que o JavaScript terá de estar activado para que possa visualizar o endereço de email .É obrigatório o uso de máscara.

Ler mais...
 
Novembro 7, 18h00, KVAR Ensemble - XVI Ciclo de Concertos "Música no Inverno" Imprimir e-mail

Novembro 7, 18h00, KVAR Ensemble - XVI Ciclo de Concertos "Música no Inverno"
Programa: Ludwig van Beethoven (1770-1827) | Quarteto em Dó maior, WoO 36, n.º 3 (1785) – I-I Allegro vivace II Adagio com espressione, III Rondo: Allegro ; Rogério Medeiros (1979-) | Pórtico* (2019) (obra dedicada ao KVAR Ensemble); Eurico Carrapatoso (1962-) | O Espelho da Alma, op. 56 (2009) : I Eterno, II Pírrico, III Sedoso, IV Careto; V Saudoso, VI Pícaro, VII Materno. 
kvar_ensemble.png

































































Associação Eborae Mvsica realiza, em articulação com a Câmara Municipal de Évora, em Novembro e Dezembro, o XVI Ciclo de Concertos "Música no Inverno”, uma atividade destinada a enriquecer a oferta cultural da cidade nos meses de inverno.
Este Ciclo visa promover eventos musicais que possam contribuir para qualificar a oferta cultural a nível do Turismo Cultural. Pretende aprofundar a relação entre o património construído, neste caso a Igreja do Convento dos Remédios, em Évora, e a adequação de uma oferta musical regular à fruição pelo público e à participação de grupos musicais regionais, nacionais e estrangeiros. Pretende, ainda, apresentar obras dos sécs XX e XXI. 
O ciclo inicia-se dia 7 de novembro às 18h00 com o KVAR Ensemble (Piano – Duarte Martins, Viola- Madalena Neto, Violino-Sara Lino, Violoncelo – Nuno Cardoso).

O Kvar Ensemble é um agrupamento de música de câmara criado em 2019, em Lisboa. A palavra kvar — “quatro” em esperanto, a língua franca planeada para facilitar a comunicação a nível universal, num curioso paralelismo com a Música — representa a formação-base de quarteto com piano deste ensemble versátil, dinâmico e inovador. Fazemos música de câmara de diversos períodos históricos e em diversas formações: duetos, trios, quartetos, quintetos. Temos vários músicos convidados que colaboram connosco regularmente e compositores associados ao nosso projeto, escrevendo novas obras que nos fazem pensar sobre o mundo musical contemporâneo.  

Este ciclo prossegue com os seguintes Concertos:  No dia 14 de novembro, às  18h00 - Recital de Piano por Artur Pizarro; no dia 21 às 18h00 comUma Viagem pelo Barroso Instrumental Europeu” por “Os Músicos do TejoDireção Musical e Cravo – Marcos Magalhães, Cravo- Marta Araújo, Oboé e Flauta de Bisel – Pedro Castro, Violinos- Álvaro Pinto e Nuno Mendes, Viola – Paul Wakabayashi, Contrabaixo – Pedro Wallenstein; no dia 22 , às 18h00– Trio de Clarinete, Violino e Piano por Clarinete - Rui Travasso, Violino – Rodrigo Gomes, Piano – Irene Renart; no dia 27 às 21h30 - Orquestra de Câmara de Cascais e Oeiras, com direção de Nikolay Lalov ;  no mês de Dezembro sempre às 18h00: Dia 5  Recital de Guitarra por Eurico Pereira; Dia 6 – Recital de Flauta , Oboé e Clarinete  com Flauta – Mariana Moreira, Oboé- Maria Susete Afonso e Clarinete – Mário Vinagre; Dia 13  Concerto de Natal com o Coro Polifónico “Eborae Mvsica”, dirigido pelo Maestro Eduardo Martins que irá apresentar em estreia a obra de João NascimentoMissa -Nossa Senhora dos Remédios”

É necessário reserva prévia de bilhetes através de Este endereço de e-mail está protegido contra spam bots, pelo que o JavaScript terá de estar activado para que possa visualizar o endereço de email .É obrigatório o uso de máscara.

Ler mais...
 
<< Início < Anterior | 1 2 | Seguinte > Final >>

Resultados 11 - 14 de 14
Destaques
Próximos Eventos
Março 2024 Abril 2024
Se Te Qu Qu Se Do
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
Notícias RSS
Newletter




61280515 Visitas

118 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 37 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1711622890' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1711622890' ) 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 = 37
12 SELECT a.id FROM jos_content as a WHERE a.state = -1
13 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 YEAR( a.created ) = '2020' AND MONTH( a.created ) = '11' AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0
14 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 YEAR( a.created ) = '2020' AND MONTH( a.created ) = '11' 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, 10
15 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
16 SELECT params FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
17 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'
18 SELECT m.id FROM jos_modules AS m WHERE m.module = 'mod_rssfeed' AND m.published = 1
19 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 = 37 ) ORDER BY ordering
20 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
21 SELECT m.* FROM jos_menu AS m WHERE menutype = 'associacao' AND published = 1 AND access <= 0 ORDER BY parent, ordering
22 SELECT m.* FROM jos_menu AS m WHERE menutype = 'conservatorio' AND published = 1 AND access <= 0 ORDER BY parent, ordering
23 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
24 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=4'
25 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=5'
26 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
27 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-03-28 11:03:11') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 11:03:11') AND catid='5' ORDER BY a.created asc LIMIT 5
28 SELECT * FROM jos_content WHERE id = '1332'
29 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 1332 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
30 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
31 SELECT * FROM jos_content WHERE id = '1333'
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 = 1333 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
33 SELECT * FROM jos_content WHERE id = '1334'
34 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
35 SELECT * FROM jos_jcalpro_config
36 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
37 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
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 lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
45 SELECT g1.group_id, g1.name, COUNT(g2.name) AS level FROM jos_core_acl_aro_groups AS g1 INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt WHERE g1.lft BETWEEN 15 AND 18 GROUP BY g1.name ORDER BY g1.lft
46 SELECT cat_id, level FROM jos_jcalpro_categories
47 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
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 4 AND 11 GROUP BY g1.name ORDER BY g1.lft
49 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
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 14 AND 19 GROUP BY g1.name ORDER BY g1.lft
51 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
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 4 AND 11 GROUP BY g1.name ORDER BY g1.lft
53 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
54 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
55 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
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') <= 20240301 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240301 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240301 ) ) 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') <= 20240301) 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') <= 20240302 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240302 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240302 ) ) 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') <= 20240302) 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') <= 20240303 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240303 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240303 ) ) 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') <= 20240303) 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') <= 20240304 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240304 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240304 ) ) 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') <= 20240304) 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') <= 20240305 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240305 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240305 ) ) 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') <= 20240305) 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') <= 20240306 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240306 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240306 ) ) 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') <= 20240306) 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') <= 20240307 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240307 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240307 ) ) 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') <= 20240307) 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') <= 20240308 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240308 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240308 ) ) 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') <= 20240308) 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') <= 20240309 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240309 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240309 ) ) 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') <= 20240309) 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') <= 20240310 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240310 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240310 ) ) 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') <= 20240310) 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') <= 20240311 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240311 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240311 ) ) 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') <= 20240311) 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') <= 20240312 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240312 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240312 ) ) 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') <= 20240312) 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') <= 20240313 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240313 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240313 ) ) 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') <= 20240313) 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') <= 20240314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240314 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240314 ) ) 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') <= 20240314) 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') <= 20240315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240315 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240315 ) ) 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') <= 20240315) 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') <= 20240316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240316 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240316 ) ) 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') <= 20240316) 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') <= 20240317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240317 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240317 ) ) 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') <= 20240317) 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') <= 20240318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240318 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240318 ) ) 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') <= 20240318) 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') <= 20240319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240319 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240319 ) ) 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') <= 20240319) 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') <= 20240320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240320 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240320 ) ) 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') <= 20240320) 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') <= 20240321 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240321 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240321 ) ) 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') <= 20240321) 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') <= 20240322 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240322 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240322 ) ) 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') <= 20240322) 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') <= 20240323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240323 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240323 ) ) 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') <= 20240323) 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') <= 20240324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240324 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240324 ) ) 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') <= 20240324) 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') <= 20240325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240325 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240325 ) ) 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') <= 20240325) 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') <= 20240326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240326 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240326 ) ) 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') <= 20240326) 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') <= 20240327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240327 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240327 ) ) 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') <= 20240327) 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') <= 20240328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240328 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240328 ) ) 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') <= 20240328) 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') <= 20240329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240329 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240329 ) ) 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') <= 20240329) 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') <= 20240330 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240330 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240330 ) ) 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') <= 20240330) 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 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') <= 20240331 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240331 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240331 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
117 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') <= 20240331) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
118 SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'