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
14 Maio, 21h30 - Concerto pelo Quarteto da Universidade de Calgary (Canadá) - NÃO PERCA! Imprimir e-mail
14 Maio, 21h30 - Concerto pelo Quarteto da Universidade de Calgary (Canadá)
Local- Convento dos Remédios, Évoracalgaryquartet.jpg























UNIVERSITY CALGARY STRING QUARTET

Edmond Agopian e Adriana Lebedovich – violinos
Dean O’Brien – viola
Beth Root Sandvoss – violoncelo

VER PROGRAMA E CURRÍCULOS:
PROGRAMA:

 
1ª Parte:
Mozart – Quarteto em Ré Maior, K 155
Mendelssohn – Quarteto op.44 nº 1  
Intervalo 
2ª Parte:
Vamos festejar (Klezmer/música hebraica)
Dançando com o Rabi
Rapsódia Ucraniana
Fantasia Arménia
Romances Húngaros
O velho cigano (Húngria/cigana)
Rapsódia Romena
Música para uma festa romena
Há muito que deixei o meu país (Húngria)
Não mais mulheres grisalhas para mim (Húngria/cigana) 

Nota – Todos os temas apresentados na segunda parte são de origem hebaica, cigana e da Europa de Leste cujos arranjos originais para quarteto de cordas são da autoria de Edmond Agopian  

Edmond Agopian e Adriana Lebedovich – violinos
Dean O’Brien – viola
Beth Root Sandvoss – violoncelo

O UNIVERSITY CALGARY STRING QUARTET, originalmente formado em 1994 como quarteto residente da Universidade de Calgary com Edmond Agopian, Amanda Forsyth, Olga Kotova e Christopher Sandvoss, o quarteto exibiu-se em diversas salas de concerto do Canadá tendo tido várias transmissões radiofónicas a nível regional e nacional através da CBC Radio. O seu cd do quinteto para piano de Brahms com o conhecido pianista canadiano Anton Kuerti recebeu críticas entusiastas.Como quarteto residente da Universidade de Calgary, apresenta regularmente com os alunos finalistas da universidade, trabalhos comissionados e premiados do curso de composição.Durante os próximos três anos o quarteto apresentará o ciclo completo dos Quartetos de Cordas de Beethoven pela primeira vez em Calgary. Juntamente com o repertório clássico fazem parte dos seus concertos, como ponte entre as tradições folk e clássica, a música Klezmer e folk da Europa de Leste com arranjos para quarteto de cordas compostos por Edmond Agopian.O University Calgary String Quartet é financiado pelo prémio John Lee Roberts Distinguished Professorship in Fine Arts. 

EDMOND AGOPIAN (1º violino) 
Edmond Agopian foi nomeado Director Musical da Calgary Youth Orchestra do Mount Royal College em 2002. Na Universidade de Calgary detém a cátedra de John Roberts Distinguished Professorshio in Fine Arts. Em 2005 foi premiado com a “Alberta Centennial Medal” em reconhecimento pelo grande mérito alcançado e serviços prestados à população da província de Alberta. Edmond Agopian é licenciado pela Universidade de Toronto em Teoria e História da Música, Master in Violin-Performance pela Juilliard School e com o Honours Diploma em Direcção de Orquestra pela Academia Internacional de Música de Lugano.As orquestras que tem dirigido incluem a Calgary Philharmonic Orchestra, a National Arts Centre Orchestra, a Orchestra London, a Hamilton Philharmonic e a orquestra do Festival del Mondo Antico em Itália.Sob a sua direcção, a University of Calgary Orchestra realizou o seu primeiro CD com grandes aplausos do crítico musical de Calgary, Bob Clark. A sua performance em violino foi considerada pelo Toronto Star como “a triumph, both of technique and integration”.E.Agopian transferiu-se para Calgary em 1991 para ocupar o cargo de professor de violino e maestro da Orquestra da Universidade de Calgary e dos Artistas Residentes no Mount Royal College Conservatory. Durante treze anos foi director de orquestra da Kensington Sinfonia, a orquestra profissional de cordas de Calgary.Desde o início da sua actividade em 1996, Edmond Agopian tem sido o responsável pela programação do Morningside Music Bridge no Mount Royal College Conservatory. É primeiro violino do Calgary String Quartet e fundador e Director Artístico do Festival dos Contrastes de Música de Câmara. O seu método de violino “The No Time Practice Technique Companion” faz parte da lista de best sellers da SHAR Music Company. 

ADRIANA LEBEDOVICH (2º violino)
Adriana Lebedovich iniciou o estudo do violiono con a idade de três anos e actualmente encontra-se no terceiro ano do Bachelor of Music da Universidade de Calgary onde finaliza o Major em Performance. Desenvolveu os seus estudos de violino com Katherine Grigoriu, Elaine Henchell, Theresa e Jeff Plotnick e actualmente com Edmond Agopian.Em Abril de 2006 vence o University of Calgary Competition e executou o primeiro movimento do Concerto para Violino e Orquestra de Tchaikovski com a Calgary Philharmonic Orchestra. Desde a sua estreia que tem feito  substituições regulares com esta orquestra. Por mais de dez anos entrou nos concursos da Calgary Kiwanis Music Festival onde venceu numerosas medalhas e bolsas de estudo entre as quais o programa da Académie Musicale Internationale “Barbara Krauer” em Vaison-la-Roumaine, França, pela primeira vez no verão de 2006. Adriana tem participado e tocado em numerosas master classes dadas por James Ehnes, Jasper Wood, Catherine Manoukian, Corey Cervosek e o Lafayette String Quartet.Adriana gosta muito de dançar e tocar música folk ucraniana e com o Korinnya Ukrainian Folk Ensemble toca e faz orquestrações para colaborações regulares com estes músicos em eventos culturais. Além da sua actividade musical, Adriana interessa-se por línguas estrangeiras falando fluentemente francês e alemão e aprendendo espanhol actualmente. 
 
DEAN O’BRIEN (viola) 
Dean O’Brien completou o Doctorate of Musical Arts Degree na Universidaade do Texas em Austin em Maio de 2000. Do mesmo modo detém os títulos de Bachelor of Music and Master of Music da Eastman School of Music em Rochester, Nova Iorque com estudos adicionais no Peabody Conservatory, no Banff Centre e na Universidade da Califórnia em Santa Barbara. Dean O’Brien foi docente de viola e violino na Medicine Hat College onde igualmente dirigiu a Medicine Hat Junior String Orchestra e a Medice Hat College Academy Orchestra. Como instrumentista foi primeira viola na Montreal Chamber Orchestra, na Victoria Texas Symphony Orchestra, Mid-Texas Symphony, na Orchestra of Saint David’s e na Santa Barbara Symphony Chamber Orchestra para além de ter colaborado com as orquestras de Austin, San Antonio, Albany, Nova Iorque, Santa Barbara, New Texas e nos Victoria Bach Festivals. Dos seus principais professores podem-se destacar Roger Myers, Heidi Castleman, James Dunham e Heiichiro Ohyama. Dean O’Brien é actualmente docente de violino e viola no Mount Royal College Conservatory e primeiro viola  da Red Deer Symphony Orchestra e Director Artístico da Calgary Pro Musica Society. 

BETH ROOT SANDVOSS (violoncelo) 
Beth Root Sandvoss nasceu em Madison, Wisconsin onde, nos primeiros anos de estudo do instrumento teve como professora Margaret Christy. Beth R. Sandvoss prosseguiu os seus estudos de violoncelo em Cleveland e São Francisco com os violoncelistas Parry Karp, alan Harris e Irene Sharp. Beth foi membro da Hong Kong Philharmonic Orchestra, da San Jose Symphony, da Madison Symphony, do Victoria String Quartet e da Calgary Philharmonic Orchestra. A sua actividade de instrumentista espalhou-se ao longo da América do Norte bem como pelo longínquo Oriente e os seus concertos foram gravados pela WERN Madison Radio, RTHK de Hong Kong e a CBC Radio. Beth R. Sandvoss tem uma grande activida de no âmbito da música de câmara no Canadá como membro fundador da aclamada Land’s End Chamber Ensemble e do University of Calgary String Quartet. Paralelamente com a sua actividade de instrumentista, Beth Sandvoss é uma pedagoga muito dedicada colaborando com vários professores nos métodos de instrumento sendo muito conhecida pela qualidade das suas Cello Clinics. Os seus alunos têm ganho numerosos concursos no Canadá e são convidados regularmente para participarem em festivais a nível mundial. Como docente é membro do Mount Royal College Conservatory e na Universidade de Calgary e professora em vários cursos de Verão contemporaneamente com a sua actividade de concertista no Canadá e EUA. Beth Sandvoss toca num instrumento construído pelo seu marido Christopher Sandvoss.
 
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




61298010 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 < '1711644806' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1711644806' ) 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 = 243 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 17:08' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 17:08' ) AND a.access <= 0
13 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '243'
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-28 17:08:27') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 17:08:27') 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'