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
Julho - XII Ciclo de Concertos “Música nos Claustros” . A NÃO PERDER! Imprimir e-mail
XII Ciclo de Concertos “Música nos Claustros” Convento dos Remédios -Évora
musica_claustros_11.jpg

O Ciclo de Concertos “Música nos Claustros” realiza-se nos meses de Julho e Setembro, e tem como objectivo promover eventos musicais que possam contribuir para qualificar a oferta cultural a nível do Turismo Cultural e estabelecer uma programação que dê relevo temporal à Música Antiga, à Ópera e à Opereta e aos vários Períodos da criação musical. Pretende aprofundar a relação entre o património construído, neste caso o 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 da região do Alentejo e do país.

Dia 30, 21h30 – Canto e Piano – Cátia Moreso (mezzo-soprano) – 1º Prémio do Concurso “Prémio José Augusto Alegria-2010), Leonel Pinheiro (tenor) e Ana Monteiro (piano)
 

Dia 31, 21h30 – Clarinete e Piano – Ana Maria Santos (clarinete) - (1º Prémio III Escalão do Concurso “Prémio José Augusto Alegria-2010) e Diana Botelho Vieira (piano)

VER PROGRAMAÇÃO DETALHADA:


 Dia 2, 21h30 – Violino e Piano – Lina Uinskyte (violino) e Mauro Dilema (piano) 
Programa: Edvard Grieg (1843-1907): Sonata Op. 45 nº. 3 - Allegro molto e appassionato; Allegretto espressivo alla romanza e Allegro animato; Franz Schubert (1797 - 1828): Fantasia Op. 159 in  Do Maggiore; Camille Saint-Saëns (1835-1921): Sonata Op. 75 nº. 1 - Allegro agitato – Adágio e Allegretto moderato - Allegro molto. 
Lina Uinskyte nasceu em Vilnius (Lituânia), licenciou-se na Alta Escola de Arte "M.K. Ciurlionis" sob a orientação de I. Armonaite. Em 1996 obteve uma bolsa de estudo no “Istituto Musicale Internazionale Santa Cecilia" de Portogruaro (Itália) onde concluiu os estudos com Pavel Vernikov. Determinante para a formação violinistica e para o desenvolvimento do som foi o encontro na "Muraltengut" de Zurique com o violinista e maestro dos "Virtuosos de Moscovo", Vladimir Spivakov. Lina Uinskyte ganhou varios concursos entre os quais "Gesualdo da Venosa" di Potenza, "Città di Brindisi", "Guido Rizzo" di Roma, entre outros. Deu aulas de violino no “Istituto Musicale V. Bellini" de Catania. Actualmente é docente de violino no Conservatorio de Musica “G.Verdi” de Como. Toca um violino cópia do “Cannone” de Guarneri del Gesù, construído em 1800 por Gabriel Lembock. 
Mauro Dilema, de nacionalidade italiana, concluiu o curso superior de piano com a idade de vinte anos tendo obtido a classificação máxima e a distinção no Conservatório de Música de Matera. Classificou-se desde pequeno nas competições nacionais, internacionais e execuções pianísticas. No ano 1998 obteve uma Bolsa de estudo no “Teatro alla Scala” de Milão corno pianista acompanhador e no ano 1999 foi o primeiro classificado na competição para pianista solo e de câmara na Orquestra do Teatro de Volterra. A sua atividade como concertista levou-o a várias cidades italianas e estrangeiras quer a solo, quer integrado em diversas formações. Colabora há oito anos com a Universidade de Évora como Professor de Piano leccionando também no no Istituto Superiore di Studi Musicali “G. Donizetti” em Bergamo 

Dia 3, 21h30 – Concerto pelo “Coro Polifónico Eborae Mvsica”, direcção Pedro Teixeira 
Programa – Tema: A Noite. Madrigais e Música contemporânea de Lopes Graça e Eurico Carrapatoso. 

Dia 9, 21h30 – Canto e Piano – Valérie Vervoort (soprano) e Jill Lawson (piano) 
Programa: Chopin: Nocturnes e Claire de lune de Debussy; Debussy: Nuit d’étoiles, Beau soir, Pierrot; Fauré: Après un rêve, Clair de lune, nocturne; Hahn: L’heure exquise, Nocturne, Dans la nuit, l'Enamourée e La nuit; Massenet: Nuit d’Espagne, Madrigal; Poulenc: Le sommeil e Lune d’avril; Saint-Saëns: Rêverie; Lekeu: Nocturne; Jongen: Après un rêve  
Valérie Vervoort-Lawson, soprano, terminou os estudos de Canto no Conservatório Real d’Anvers instituição onde iniciou a sua aprendizagem na classe de Lucienne Van Deyck. Em Junho de 2003 diplomou-se na classe de Guy de Mey. Paralelamente estudou com Stephanie Friede e no Brooklyn Conservatory College, na classe Trish McCaffrey. Tem realizado recitais como solista e participado em várias óperas, em vários países.  
Jill Lawson, pianista, de nacionalidade luso-americana, nasceu no México em 1974. Iniciou os estudos de piano com a professora Heidi Hendrickx na Academia de Música de Antuérpia tendo continuado no Conservatório Real de Antuérpia, onde teve aulas sob a direcção de Levente Kende. Em 2004, no Peabody Institute em Baltimore, obteve o Mestrado de Música. Fez vários cursos de aperfeiçoamento com Maria Tipo, Sequeira Costa, Vladimir Viardo, Dimitri Bashkirov e Maria João Pires. 

Dia 10, 21h30 – Recital de Violino e Piano por Bruno Monteiro e João Paulo Santos 
Programa: George F. Händel (1685-1759): Sonata para Violino e Piano em Fá Maior HWV 370 – Adagio, Allegro, Largo e Allegro; Edward Grieg (1843-1907): Sonata nº3 para Violino e Piano em Dó menor Op.45 - Allegro molto ed appassionato, Andante expressivo alla Romanza e Allegro molto; Ernest Bloch (1880-1956): Suite Baal Shem para Violino e Piano - Vidui (Contrition), Nigum (Improvisation) e Simchat torah (Rejoicing); Pyotr I. Tchaikovsky (1820-1869): Souvenir d’un Lieu Cher para Violino e Piano Op.42 – Meditation, Scherzo e Melodie; Maurice Ravel (1875-1937): Tzigane, Rapsodie de Concert.  
Bruno Monteiro nasceu no Porto, foi aluno de Carlos Fontes, em cuja classe concluiu os seus estudos em Portugal com 20 valores. Paralelamente recebeu a orientação de Gerardo Ribeiro, com quem trabalhou particularmente em Chicago, nos Estados Unidos da América, como bolseiro da Fundação Gulbenkian e da Fundação Luso-Americana para o Desenvolvimento. Licenciado em Música (Violin Performance) pela Manhattan School of Music de Nova Iorque com as mais elevadas classificações, como bolseiro da Fundação Gulbenkian e do Centro Nacional de Cultura.Tocou como solista com numerosas orquestras, das quais se destacam a Orquestra Filarmonia das Beiras, Orquestra do Norte, Orquestra Sinfónica de Palma de Maiorca, Orquestra Clássica da Madeira, Orquestra Sinfónica Portuguesa e a English Chamber Orchestra. 
João Paulo Santos concluiu o curso superior de Piano no Conservatório Nacional de Lisboa na classe de Adriano Jordão. Trabalhou ainda com Helena Costa, Joana Silva, Constança Capdeville, Lola Aragón e Elizabeth Grümmer. Na qualidade de bolseiro da Fundação Calouste Gulbenkian aperfeiçoou-se em Paris (1979/84). Depois de ter ocupado o cargo de Maestro Assistente do Coro do Teatro Nacional de São Carlos (1984) foi nomeado Maestro Titular (1990/2004). Actualmente é Director de Estudos Musicais e Director Musical de Cena do mesmo Teatro. Na qualidade de pianista apresenta-se a solo, em grupos de câmara, acompanhando cantores, e em duo com a violoncelista Irene Lima desde 1985. Foi galardoado com o Prémio «Acarte 2000» pela direcção musical de The English Cat. 

Dia 23, 21h30 – Ópera e Musicais – Abel Chaves (piano), Madalena Paiva Boléo (mezzo-soprano), Sofia de Castro (soprano), Diogo Oliveira (barítono) e Paulo Carrilho (tenor). 
Programa: I Parte – Ópera: "Non ti fidar o misera" (Don Giovanni) – Mozart; "Dunque Io Son" (Il Barbiere di Siviglia) – Rossini; “Una donna a quindici anni (Così fan tutte) – Mozart; “Un’ aura amorosa” (Così fan tutte) – Mozart; “Habanera" (Carmen) – Bizet; “Je dis que rien ne m’epouvante (Carmen) – Bizet; "Adina, credimi" (Elixir do Amor) – Donizetti; “Bella siccome un angelo” (Don Pasquale) Donizetti;  “Dôme épais le jasmin” (Lakmé) – Delibes; "I got Plenty o’nuttin" (Porgy and Bess) - G. Gershwin e “Bella figlia dell'amore" (Rigoletto) – Verdi. ll Parte – Musicais: "Circle of Life" (Lion King) - Elton John; "Relativity Rag" (Einstein’s Dreams) - Joshua Rosenblum; "l feel pretty" (West Side Story) - Leonard Bernstein; “No one knows who I am” (Jeckyll and Hyde) - Frank Wildhorn; "Dangerous Game" (Jeckyll and Hyde) - Frank Wildhorn; "I Wanna Be a Producer" (The Producers) - Mel Brooks; "Sun and Moon" (Miss Saigon) - M. Schonberg; "So in love" (Kiss Me, Kate) - Cole Porter; "lmpossible Dream" (Man of La Mancha) - Mitch Leigh; "Lilly’s Eyes" (Secret Garden) - Lucy Simon; "OId Devil Moon” (Finian's Rainbow) - Burton Lane e "One day more" (Les Misèrables) - M. Schonberg 
Abel Chaves nasceu em Ponta Delgada (Açores) onde começou a aprender música com o seu pai, prosseguindo os estudos na Academia de Amadores de Música, e mais tarde no Conservatório Nacional de Música de Lisboa. É pianista e apresenta-se regularmente, desde 2001, em eventos e recitais de Canto e Piano. É também carrilhanista do Palácio Nacional de Mafra, instrumento em que obteve especialização durante três anos na Bélgica com a classificação de "Grande Distinção", com a idade de 17 anos. No Conservatório Nacional de Música, estudou órgão na classe do professor Simões da Hora, em 1994 terminou o Curso de Piano com os professores Anna Tomasik e Luís Pinto, na Escola Profissional de Música de Almada (EPMA). 
Madalena Paiva Boléo nasceu em Lisboa em 1974. Fez o Curso de Canto no Conservatório Nacional e a Licenciatura em Canto na Escola Superior de Música de Lisboa. Interpretou vários papéis de ópera em vários teatros do país incluindo o Teatro Nacional de São Carlos, Culturgest, Teatro da Trindade, São Luiz, Coliseu do Porto ou o Teatro Municipal de Almada. Foi também solista em várias obras sacras como o Stabat Mater de Pergolesi e Stabat Mater de Boccherini, entre outros. Colabora frequentemente com o Sintra Estúdio de Ópera. Trabalhou ainda nos musicais «Os Grandes Mestres do Musical Americano» e «O Último Tango de Fermat» no Teatro da Trindade. 
Sofia de Castro é natural de Lisboa e é licenciada em Engenharia Informática. Iniciou os seus estudos de Canto em 1992 na classe do Profº José Manuel Araújo na Juventude Musical Portuguesa. Terminou em 2004 o curso de canto da Escola de Música do Conservatório Nacional na classe do mesmo professor. Da sua formação mais relevante fazem ainda parte masterclasses e cursos de técnica e interpretação vocal com vários professores. Cantou em ciclos de concertos como “Música nos Claustros” e “Musicando”, da organização de Eborae Musica e “Encontros com a Música Clássica”, da organização da Junta de Freguesia de Loures. Em 2003 iniciou a actividade de produtora de espectáculos e em 2009 a de professora de canto e técnica vocal, actividades que mantém até aos dias de hoje, em paralelo com a actividade de cantora. 
Diogo Oliveira naceu em em Lisboa. É Licenciado em Engenharia da Linguagem e do Conhecimento pelas Faculdades de Ciências e de Letras da Universidade de Lisboa. Frequentou o curso de Canto da Escola de Música do Conservatório Nacional na classe de José Carlos Xavier. Participou em Cursos de aperfeiçoamento com Sarah Walker, Rudolph Knoll, Low Siew-Tuan (2003 – 2005) e Ernesto Palácio (2009. Em 2005 foi vencedor do primeiro prémio do Concurso Nacional de Canto Luísa Todi. Desempenhou recentemente o papel de Fallito em L’opera Séria (Florian Gassman) com a New European Opera em França no festival “Printemps des Arts” sob a direcção de Raphael Pichon, Accionista (Banksters de Nuno Corte-Real) no TNSC sob a direcção de Lawrence Renes e Doido Rei Clown (A Morte do Palhaço) de José Mário Branco e João Brites) sob a direcção de Jorge Salgueiro. 
Paulo Carrilho nasceu em Lisboa. É licenciado em Meteorologia, Oceanografia e Geofísica na Faculdade de Ciências da Universidade de Lisboa. Concluiu o 8º grau de formação musical na Academia de Música Eborense, onde frequentou também o 6º ano de piano e 3º ano de flauta transversal. Iniciou os estudos de Canto com a Prof. Maria Repas Gonçalves, tendo terminado o curso complementar de Canto, sob a sua orientação. Foi também aluno de canto da Prof. Sandra Medeiros. De momento estuda canto com a Prof. Liliana Bizineche no Mestrado de Música na Universidade de Évora.Colabora frequentemente com o Sintra Estúdio de Ópera. Em Maio e Junho de 2011 integrou o elenco com o personagem Ladrão Dono do Circo em “A Morte do Palhaço”, uma criação do Teatro O Bando, com texto de Raul Brandão, encenação de João Brites e música de José Mário Branco, co-produzido com o Teatro Nacional de S. João, em cena no Mosteiro S. Bento da Vitória no Porto e no Lx Factory em Lisboa.  

Dia 30, 21h30 – Canto e Piano – Cátia Moreso (mezzo-soprano) – 1º Prémio do Concurso “Prémio José Augusto Alegria-2010), Leonel Pinheiro (tenor) e Ana Monteiro (piano) 
Programa: Wagner – Wesendonck Lieder: Im treibhauss e Träume; Schumann – Belzasar; Poulenc – La Courte Paille: La Reine de Coeur e Les Anges Musiciens; Poulenc – alligrammes: L’Espionne e Voyage; Britten – Cabaret Songs: Johnny; Bizet – Carmen: Seguidille; Saint-Saens – Samson et Dalila: Mon coeur s’ouvre à ta voix; Massenet – Werther: Air des Lettres; Leoncavallo – I Pagliacci – Recitar - Vesti la Giubba e Donizetti – La Favorita – O mio Fernando. 
Cátia Moreso iniciou os seus estudos musicias no Conservatório de Música D. Dinis, em Odivelas, onde estudou com Margarida Marecos. Em 2002, ingressou à Escola de Música do Conservatório Nacional de Lisboa onde estudou com Larissa Savchenko e Filomena Amaro. Prosseguiu os seus estudos com Isabel Biú. Fez diversas masterclasses, entre outros, com Elisabete Matos, Graham Johnson, Sarah Walker, Dame Kiri Te Kanawa e Malcolm Martineau. Foi vencedora do 1º Prémio no II Concurso de Canto da Fundação Rotária Portuguesa, Prémio Bocage no Concurso de Canto Luisa Todi e do 1º Prémio no Concurso de Canto José Augusto Alegria. Licenciada em Canto com distinção pela Guildhall School of Music and Drama e com o mestrado no Opera Course da mesma escola, Cátia estuda na classe de Susan Waters. É bolseira da Fundação Calouste Gulbenkian e privadamente suportada por Maria Armanda Mateus. Planos futuros incluem National Opera Studio, Missa No. 3 (Grande) em Fá menor de Bruckner (Gulbenkian), Folk Songs de Berio em Londres. 
Leonel Pinheiro é natural de Braga onde iniciou os seus estudos musicais no Conservatório de Música Calouste Gulbenkian. Completou a Licenciatura em Ensino da Música, vertente Canto, na Universidade de Aveiro na classe de António Salgado. É Pós-Graduado em Concert Singing pela Royal Scottish Academy of Music & Drama na classe de Peter Alexander Wilson e recentemente concluiu o Mestrado em Performance, Estudos de Ópera (Opera Course) na classe de Susan McCulloch obtendo a classificação máxima. Leonel Pinheiro foi galardoado com o Patrick Libby Prize for Acting e foi-lhe atribuido o grau de Guildhall Artist Fellowship para o ano 2010/11. Actualmente é professor de Canto na City University of London e Coach de aprendizagem de repertório na Guildhall School of Music & Drama. Compromissos futuros incluem, entre outros, cover de Cavaradossi na ópera Tosca de Puccini para a Grange Park Opera. Actualmente trabalha com Susan McCulloch e Dennis O'Neill 
Ana Monteiro nasceu em Lisboa em 1983 e iniciou os seus estudos musicais no Conservatório de Música D. Dinis. Frequentou masterclasses de piano com Helena Sá e Costa, Pedro Burmester, Vladimir Viardo, Paul Badura-Skoda, Velislava Palatchorova, Luís Moura Castro, Boris Berman, Naum Grubert, Leslie Howard e Julius Drake. Concluiu em 2005 o Bacharelato em Piano para Música de Câmara e Acompanhamento na Academia Nacional Superior de Orquestra sob a orientação da Professora Savka Konjikusic.Em 2008 recebeu da Fundação Eng. António de Almeida o “Prémio Eng. António de Almeida” como melhor aluna finalista de Licenciatura Instrumento/Piano da ESMAE. Concluiu em 2010 o curso de Mestrado em Música / Piano Interpretação com o Pianista António Rosado na Universidade de Évora. Actualmente, encontra-se a estudar na Guildhall School of Music and Drama (Londres) no curso de Mestrado em Piano Acompanhamento e Musica de Câmara. Como docente exerce funções na Escola de Música do Conservatório Nacional de Lisboa e no Conservatório de Música de Sintra.  

Dia 31, 21h30 – Clarinete e Piano – Ana Maria Santos (clarinete) - (1º Prémio III Escalão do Concurso “Prémio José Augusto Alegria-2010) e Diana Botelho Vieira (piano) 
Programa: C. Widor – Introduction et Rondo, para clarinete e piano; F. Donatoni – Clair (1º peça) para clarinete solo; F. Poulenc – Sonata para clarinete e piano; C. Debussy – Primeira Rapsódia para clarinete e piano e J. Brahms – 2.ª Sonata para clarinete e piano 
Ana Maria Santos nasceu em Lisboa e licenciou-se com o professor Etienne Lamaison na Academia Nacional Superior de Orquestra. Em 2008 concluiu a pós-graduação em clarinete baixo, na classe do professor Harry Sparnaay, na Escola Superior de Música da Catalunha (Barcelona). No mesmo ano foi admitida na classe do professor Michel Arrignon na Escuela Superior de Música Reina Sofia (Madrid), sendo bolseira da Fundação Calouste Gulbenkian e da Fundación Carolina. Em 2010 ganhou o Primeiro Prémio no Concurso Internacional de Clarinete “Prémio José Augusto Alegria”. Em 2011 vai participar no Encuentro y Academia de Música de Santander e na Lucerne Festival Academy, que tem a direcção musical do maestro Pierre Boulez. 
Diana Botelho Vieira nasceu na ilha de São Miguel, Açores, em 1984. Iniciou os estudos musicais na Academia de Música da Ribeira Grande e aos 10 ingressou no Conservatório Regional de Ponta Delgada onde se graduou como aluna de Irina Semeonova em 2003. Nesse mesmo ano muda-se para Lisboa onde estudou com Alexei Eremine na Academia Nacional Superior de Orquestra. Tem o Mestrado em Piano Performance, pela Chicago College of Performing Arts, onde estudou com Ludmila Lazar. É membro fundador do Quarteto Botelho Vieira. Em Chicago, tem-se dedicado intensamente ao ensino, fazendo parte neste momento do corpo docente da Christopher Laughlin School of Music, da DePaul University Community Music Division, e da People’s Music School. Foi seleccionada para, em Junho de 2011, participar no Summer Institute for Contemporary Performance Practice, um festival de música contemporânea prestigiado, em Boston.
 
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




59754135 Visitas

116 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 = 1 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1709517237' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1709517237' ) 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 = 1
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 = 616 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-04 02:08' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-04 02:08' ) AND a.access <= 0
13 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '616'
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 = 1 ) 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-03-04 02:08:58') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-04 02:08:58') 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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
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') <= 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
116 SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'