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
Programação
Conservatório Regional de Évora “Eborae Mvsica” - Inscrições Ano Letivo 2020/2021 Imprimir e-mail

Conservatório Regional de Évora “Eborae Mvsica”
Inscrições Ano Letivo 2020/2021
3_cartaz_inscries_-_iniciaes.jpg

Ler mais...
 
Conservatório Regional de Évora “Eborae Mvsica” - Inscrições Ano Letivo 2020/2021 Imprimir e-mail

Conservatório Regional de Évora “Eborae Mvsica”
Inscrições Ano Letivo 2020/2021
Boletim de Candidatura 
AQUI
2_cartaz_inscries_-_geral-1.jpg

Ler mais...
 
Conservatório Regional de Évora “Eborae Mvsica”- Inscrições Ano Letivo 2020/2021 Imprimir e-mail

Conservatório Regional de Évora “Eborae Mvsica”
Inscrições Ano Letivo 2020/2021
Boletim de Candidatura 
AQUI
1_cartaz_inscries_-_curso_bsico.jpg

Ler mais...
 
COMUNICADO cancelamento das atividades extra aulas, como Audições e Concertos até ao dia 13 de abri Imprimir e-mail

COMUNICADO

simbolo-10-nl.jpg

 

  

A Direção da Eborae Musica - Conservatório e Associação decidiu cancelar as atividades extra aulas, como Audições e Concertos até ao dia 13 de abril como prevenção do COVID-19.

 
CREV - AUDIÇÕES FINAL ANO LETIVO 2018/2019 COM GRANDE SUCESSO Imprimir e-mail

CREV - AUDIÇÕES FINAL ANO LETIVO 2018/2019 COM GRANDE SUCESSO
aud_1.jpg

O Conservatório Regional de Évora/Associação Musical “Eborae Mvsica” está a promover as Audições de Final do Ano Letivo 2018/2019, de 30 de maio a 13 de junho, no Convento dos Remédios, e na Igreja do Espírito Santo, em Évora.

Calendarização das 

aud_2.jpg

 

 

aud_3.jpgaud_4.jpg

Audições: 30 de maio às 18h30  – Guitarra , 19h00 -Violoncelo; 3 de junho 18h00 –Guitarra ; 19h00 – Percussão; 4 junho – 18h15 – Trompete, 19h15- Clarinete e Trompa;  dia 5 junho – 17h00 –Flauta Transversal e Trombone , 18h00 – Oboé e Saxofone; 19h00 – Canto; 6 de junho – 18h00 e 19h00 – Violino; 7 junho – 19h00 – Viola d’Arco e Violino; 11 junho – 18h00 – Contrabaixo e Piano, 19h00 Piano; dia 13 junho 17h30 - Órgão (Igreja do Espírito Santo).


As Audições Gerais de Final do Ano Letivo 2018/2019 realizaram-se no dia 1 de junho no seguinte horário: 11h00 – Cursos de Iniciação Musical e Iniciação Oficial (Nesta Audição serão apresentados os coros dos alunos de 3, 4 e 5 anos e o das Iniciações oficiais, Orquestra Orff, Orquestra de Arcos e alguns alunos de piano e outros instrumentos); 15h00 – Turmas de Ensino Articulado (Nesta Audição serão apresentados os Coros de várias turmas do Ensino Articulado e alguns alunos em instrumentos); 16h00 - Turmas de Ensino Articulado (Nesta Audição serão apresentados os Coros de várias turmas do Ensino Articulado e alguns alunos em instrumentos); 17h30 – Cursos Básico, Secundário e Livre (Nesta Audição serão apresentados a Orquestra Clássica, Coros, Ensemble de Guitarras, Orquestra de Sopros e alunos em instrumentos individuais).
As Audições que já se realizaram tiveram grande sucesso. 
Convidam-se todos a assistir às restantes apresentações públicas dos alunos abertas ao público em geral.

Ler mais...
 
CREV - AUDIÇÕES FINAL ANO LETIVO 2018/2019 COM GRANDE SUCESSO Imprimir e-mail

CREV - AUDIÇÕES FINAL ANO LETIVO 2018/2019 COM GRANDE SUCESSO
aud_1.jpg

O Conservatório Regional de Évora/Associação Musical “Eborae Mvsica” está a promover as Audições de Final do Ano Letivo 2018/2019, de 30 de maio a 13 de junho, no Convento dos Remédios, e na Igreja do Espírito Santo, em Évora.

Calendarização das Audições: 30 de maio às 18h30  – Guitarra , 19h00 -Violoncelo; 3 de junho 18h00 –Guitarra ; 19h00 – Percussão; 4 junho – 18h15 – Trompete, 19h15- Clarinete e Trompa;  dia 5 junho – 17h00 –Flauta Transversal e Trombone , 18h00 – Oboé e Saxofone; 19h00 – Canto; 6 de junho – 18h00 e 19h00 – Violino; 7 junho – 19h00 – Viola d’Arco e Violino; 11 junho – 18h00 – Contrabaixo e Piano, 19h00 Piano; dia 13 junho 17h30 - Órgão (Igreja do Espírito Santo).


As Audições Gerais de Final do Ano Letivo 2018/2019 realizaram-se no dia 1 de junho no seguinte horário: 11h00 – Cursos de Iniciação Musical e Iniciação Oficial (Nesta Audição serão apresentados os coros dos alunos de 3, 4 e 5 anos e o das Iniciações oficiais, Orquestra Orff, Orquestra de Arcos e alguns alunos de piano e outros instrumentos); 15h00 – Turmas de Ensino Articulado (Nesta Audição serão apresentados os Coros de várias turmas do Ensino Articulado e alguns alunos em instrumentos); 16h00 - Turmas de Ensino Articulado (Nesta Audição serão apresentados os Coros de várias turmas do Ensino Articulado e alguns alunos em instrumentos); 17h30 – Cursos Básico, Secundário e Livre (Nesta Audição serão apresentados a Orquestra Clássica, Coros, Ensemble de Guitarras, Orquestra de Sopros e alunos em instrumentos individuais).
As Audições que já se realizaram tiveram grande sucesso. 
Convidam-se todos a assistir às restantes apresentações públicas dos alunos abertas ao público em geral.

Estes eventos são organizados pelo Conservatório Regional de Évora/Associação Musical “Eborae Mvsica” (estrutura financiada pelo Ministério da Educação) e conta com os apoios da Câmara Municipal de Évora, Arquidiocese de Évora, Seminário de Évora,  “Diário do Sul”, Rádio Diana, Antena 2, jornal “A Defesa” e “Registo”.

 
<< Início < Anterior | 1 2 3 | Seguinte > Final >>

Resultados 1 - 10 de 23
Destaques
Próximos Eventos
Setembro 2018 Outubro 2018 Novembro 2018
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




61277711 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 = 22 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1711619108' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1711619108' ) 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 = 22
12 SELECT COUNT(a.id) FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_sections AS s ON a.sectionid = s.id LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 10:00' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 10:00' ) AND ( a.sectionid=5 ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0
13 SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.deletable, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_sections AS s ON a.sectionid = s.id LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 10:00' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 10:00' ) AND ( a.sectionid=5 ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0 ORDER BY a.created DESC LIMIT 10
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 = 22 ) 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 10:00:09') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 10:00:09') 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') <= 20181001 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181001 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181001 ) ) 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') <= 20181001) 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') <= 20181002 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181002 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181002 ) ) 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') <= 20181002) 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') <= 20181003 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181003 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181003 ) ) 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') <= 20181003) 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') <= 20181004 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181004 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181004 ) ) 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') <= 20181004) 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') <= 20181005 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181005 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181005 ) ) 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') <= 20181005) 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') <= 20181006 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181006 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181006 ) ) 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') <= 20181006) 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') <= 20181007 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181007 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181007 ) ) 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') <= 20181007) 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') <= 20181008 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181008 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181008 ) ) 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') <= 20181008) 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') <= 20181009 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181009 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181009 ) ) 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') <= 20181009) 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') <= 20181010 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181010 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181010 ) ) 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') <= 20181010) 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') <= 20181011 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181011 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181011 ) ) 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') <= 20181011) 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') <= 20181012 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181012 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181012 ) ) 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') <= 20181012) 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') <= 20181013 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181013 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181013 ) ) 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') <= 20181013) 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') <= 20181014 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181014 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181014 ) ) 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') <= 20181014) 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') <= 20181015 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181015 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181015 ) ) 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') <= 20181015) 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') <= 20181016 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181016 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181016 ) ) 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') <= 20181016) 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') <= 20181017 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181017 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181017 ) ) 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') <= 20181017) 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') <= 20181018 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181018 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181018 ) ) 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') <= 20181018) 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') <= 20181019 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181019 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181019 ) ) 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') <= 20181019) 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') <= 20181020 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181020 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181020 ) ) 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') <= 20181020) 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') <= 20181021 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181021 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181021 ) ) 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') <= 20181021) 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') <= 20181022 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181022 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181022 ) ) 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') <= 20181022) 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') <= 20181023 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181023 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181023 ) ) 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') <= 20181023) 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') <= 20181024 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181024 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181024 ) ) 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') <= 20181024) 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') <= 20181025 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181025 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181025 ) ) 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') <= 20181025) 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') <= 20181026 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181026 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181026 ) ) 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') <= 20181026) 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') <= 20181027 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181027 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181027 ) ) 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') <= 20181027) 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') <= 20181028 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181028 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181028 ) ) 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') <= 20181028) 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') <= 20181029 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181029 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181029 ) ) 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') <= 20181029) 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') <= 20181030 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181030 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181030 ) ) 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') <= 20181030) 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') <= 20181031 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181031 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181031 ) ) 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') <= 20181031) 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'