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, 25, sábado, 21h30 - Piano a 4 Mãos - "Música e Cinema" -Mauro Dilema e Patrizia Giliberti Imprimir e-mail
patrizia_mauro_2_-_09.pngDia 25, às 21h30 – Recital de Piano a 4 Mãos - "Música e Cinema"

Mauro Dilema e Patrizia Giliberti 




VER PROGRAMA E CURRÍCULOS:


Programa 

Nino Rota & Federico Fellini
- Huit et demi- Amarcord
- Le cheik blanc
- I vitelloni
- La Strada 

Luis Bacalov
O carteiro

John Williams
Them from Schindler's List 

Holliwood's Music
-Flower Duet (Leo Delibes)
-I loves you porgy (G. Gershwin)
-Summertime (G. Gershwin) 

Mozart from "Amadeus"
- Lacrimosa dies illa
- Rex tremandae
- Dies irae 

Carlos Gardel
- Por uma cabeza 

Astor Piazzolla
- Libertango 

Homenagem a Ennio Morricone
- Gabriel's Theme
- Nuovo Cinema Paradiso
- Il pianista sull' oceano 

Nicola Piovani
- La vita é bella 

Patrizia Giliberti. Nasceu em Matera, Itália. Nesta mesma cidade, no Conservatório de Música, concluiu o Curso Superior de Piano com dezanove valores. A sua actividade como concertista desenvolveu-se quer a solo quer integrando outras formações, em várias cidades italianas. Dado o seu grande interesse pela música antiga, formou-se posteriormente, também em cravo, tendo, com este instrumento, participado em vários concertos com a Orquestra de Câmara de Matera. No ano de 1996/1997 foi convidada para leccionar piano no Conservatório de Música da Horta (Açores) e, no ano lectivo seguinte, na escola ‘Community Music Centre’ de San Francisco (USA) onde leccionou as disciplinas de dicção italiana, acompanhamento de canto e piano. Foi acompanhadora de cantores de ópera e professora de dicção italiana na San Francisco Lyric Opera (USA), em 1997 e, em 1998, na European Chamber Opera de Londres, sob a direcção artística de Monserrat Caballé. No ano 1999 participou num Curso Internacional de música como acompanhadora de cantores sob a orientação do Maestro Josef Protschka, na Grécia. Em Portugal, participou em cursos de aperfeiçoamento com Sequeira Costa (Gulbenkian) e A. Ciccolini (Coimbra), Gustav Leonhardt (Évora). Desde 1989 que se apresenta em recitais por toda Europa. Participou em Portugal, como solista e em formações de Câmara, com a Associação Eborae Musica de Évora (Ciclo de Concertos” Música nos Claustros”), o Teatro Garcia de Resende de Évora (Cendrev), o Instituto Italiano de Cultura, a Embaixada de Itália em Portugal, a Universidade de Évora, a Universidade do Algarve, a Câmara de Mafra, a Câmara de Fronteira (Festival Manuel Cardoso), a Câmara de Setúbal (Festival Luísa Todi) e a Fundação Casa de Bragança de Vila Viçosa entre outros. Actualmente é docente de piano no Conservatório Regional de Música “Eborae Musica”. Em 2008 requere a sua admissão a Doutoramento Europeio na Universidade de Évora, no ramo de Música e Musicologia, requerendo de ser orientada pelo Professor Doutor Benoît Gibson. Frequenta o segundo ano da Escola de aperfeiçoamento na “Scuola Musicale di Milano” na classe da Professora Emília Fadini, cuja preciosa orientação para o desenvolvimento da tese na parte interpretativa lhe é muito válida. A sua tese é centrada em três Manuscritos do compositor Domenico Scarlatti, ligados à sua vida musical portuguesa. O seu trabalho pretende produzir uma edição crítica actualizada, virada para o aspecto interpretativo das noventa e cinco sonatas contidas nos manuscritos.  

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 pianisticas. Ganhou, com a idade de 16 anos, o prémio “Aluno do ano” no Conservatório de Música de Matera. Aos 18 anos tocou como solista com a orquestra do Conservatório de Música de Matera, concerto esse que teve, quer por parte do publico, quer por parte da critica urna optima aceitação. No ano 1998 ganhou urna Bolsa de estudo no “Teatro alla Scala” de Milão corno pianista acompanhador e no ano 1999 foi o primeiro classificado na competição por 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 solo, quer integrado em diversas formações; tocou em temporadas como a “Festa da Música” da Academia de Fiesole ,  o “Festival de Ravello” , o “Crae” de Évora,    para a “Universidade de Évora” , a “Universidade do Algarve”, a “Eborae Musica” de Évora, o  “Instituto Italiano de Cultura” em Portugal, no “Festival Frei Manuel Cardoso”,  e na RTP2 canal nacional do Portugal. “...Mauro Dilema,que, num programa de grande responsabilidade, se relevou um exímio concertista de muitíssimo bom talento...num discurso pianistico de um virtuosismo de altíssima qualidade, vibrante, espetacular, numa interpretação cheia de fascinantes acrobacias e ousadias técnicas...” (Diario do Alentejo). Tem collaborado com o cantor Ricardo Visus em varias Masterclass em Espanha. Gravou, com o contrabaixista Carlos Menezes, o CD “Pianoencontrabaixo” distribuido pela FNAC Portugal. Estreiou  em Portugal o Concerto em mi minor de F. Liszt “Malediction” para piano e orquestra de cordas. Gravou recentemente um CD para piano com musicas de Roberto Perez, promovido pelo Ministerio da Cultura. Ganhou em 2005 o Concurso Nacional em Italia para o ensino AFAM (Alta Formazione Artistica e Musicale), ficando em 3º lugar. Actualmente é Professor de Piano no Istituto Superiore di Studi Musicali “G. Donizetti” em Bergamo. Deu aulas ao longo de dois anos no Istituto Superiore di Studi Musicali “G. Verdi” Ravenna (Italia). Collabora a oito anos com a Universidade de Évora como Professor de Piano Secundário. Foi professor assistente na Escola Superior de música do Instituto Politécnico de Castelo Branco. 
 
[ Voltar ]
Destaques
Próximos Eventos
Maio 2024 Junho 2024
Se Te Qu Qu Se Sá Do
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
Notícias RSS
Newletter




64496794 Visitas

112 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 < '1715925871' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1715925871' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '86240ca81847dbc8ded1762b09d5c338'
6
UPDATE jos_session SET `time`='1715926771',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='86240ca81847dbc8ded1762b09d5c338'
7
SELECT *
 FROM jos_menu
 WHERE id = 1
8
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 = 398 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 07:19' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 07:19' )
 AND a.access <= 0
9
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '398'
10
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
11
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'
12
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
13
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
14
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
15
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
16
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
17
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
18
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
19
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
20
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
21
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-05-17 07:19:32') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 07:19:32')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
22
SELECT *
 FROM jos_content
 WHERE id = '1332'
23
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
24
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
25
SELECT *
 FROM jos_content
 WHERE id = '1333'
26
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
27
SELECT *
 FROM jos_content
 WHERE id = '1334'
28
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1334
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
29
SELECT * FROM jos_jcalpro_config
30
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
31
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
32
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
33
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
34
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
35
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
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
  	cat_id, level
  FROM
  	jos_jcalpro_categories
41
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
42
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
43
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
44
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
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 name FROM jos_jcalpro_themes WHERE published= '1'
50
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') <= 20240501 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240501 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240501 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
51
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') <= 20240501) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
52
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') <= 20240502 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240502 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240502 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
53
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') <= 20240502) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20240503 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240503 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240503 ) ) 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') <= 20240503) 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') <= 20240504 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240504 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240504 ) ) 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') <= 20240504) 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') <= 20240505 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240505 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240505 ) ) 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') <= 20240505) 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') <= 20240506 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240506 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240506 ) ) 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') <= 20240506) 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') <= 20240507 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240507 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240507 ) ) 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') <= 20240507) 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') <= 20240508 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240508 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240508 ) ) 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') <= 20240508) 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') <= 20240509 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240509 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240509 ) ) 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') <= 20240509) 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') <= 20240510 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240510 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240510 ) ) 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') <= 20240510) 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') <= 20240511 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240511 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240511 ) ) 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') <= 20240511) 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') <= 20240512 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240512 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240512 ) ) 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') <= 20240512) 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') <= 20240513 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240513 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240513 ) ) 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') <= 20240513) 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') <= 20240514 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240514 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240514 ) ) 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') <= 20240514) 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') <= 20240515 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240515 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240515 ) ) 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') <= 20240515) 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') <= 20240516 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240516 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240516 ) ) 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') <= 20240516) 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') <= 20240517 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240517 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240517 ) ) 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') <= 20240517) 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') <= 20240518 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240518 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240518 ) ) 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') <= 20240518) 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') <= 20240519 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240519 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240519 ) ) 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') <= 20240519) 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') <= 20240520 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240520 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240520 ) ) 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') <= 20240520) 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') <= 20240521 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240521 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240521 ) ) 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') <= 20240521) 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') <= 20240522 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240522 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240522 ) ) 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') <= 20240522) 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') <= 20240523 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240523 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240523 ) ) 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') <= 20240523) 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') <= 20240524 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240524 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240524 ) ) 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') <= 20240524) 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') <= 20240525 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240525 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240525 ) ) 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') <= 20240525) 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') <= 20240526 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240526 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240526 ) ) 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') <= 20240526) 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') <= 20240527 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240527 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240527 ) ) 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') <= 20240527) 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') <= 20240528 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240528 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240528 ) ) 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') <= 20240528) 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') <= 20240529 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240529 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240529 ) ) 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') <= 20240529) 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') <= 20240530 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240530 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240530 ) ) 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') <= 20240530) 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') <= 20240531 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240531 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240531 ) ) 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') <= 20240531) 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 sum(hits) AS count FROM jos_stats_agents WHERE type='1'