Início Calendário Destaques Localização Downloads Links Contactos English
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	Hoje. domingo, 8 de Julho, às 21h30, no T. G. Resende - Ópera “Don Giovanni”, de W. A. Mozart Pela Orquestra do Norte e pela Companhia “Operafactory”. VERSÃO ENCENADA DA ÓPERA “DON GIOVANNI” DE MOZART     Inf-telef: 266 746 750 - Reserva de lugares-Teatro Garcia de Resende-Évora. telef: 266 703 112 E-mail Este endereço de e-mail está protegido contra spam bots, pelo que o JavaScript terá de estar activado para que possa visualizar o endereço de email    Orquestra do Norte  Mais de 60 intérpretes em palco, entre músicos e cantores, vão apresentar, dia 8 de Julho, domingo, às 21h30, no Teatro Garcia de Resende, em Évora, uma versão encenada com orquestra da grande ópera “Don Giovanni” de Mozart, no primeiro fim de semana do VIII Ciclo de Concertos “Música nos Claustros”. A Orquestra do Norte estará à frente de um grande elenco que conta com alguns dos nomes cimeiros da nova geração de cantores portugueses. O elenco é composto por: Don Giovanni - Manuel Pedro Nunes (barítono), Leporello - Diogo Oliveira (barítono), Masetto - Tomás Vaz da Silva (barítono), Comendador - Nuno Villalonga (barítono), Don Ottavio - Fernando Guimarães (tenor), Donna Anna - Ana Madalena Moreira (soprano), Donna Elvira – Maria de Félix (soprano), Zerlina - Margarida Marecos (soprano) e Paule Grimaldi (cravista). Encenação de Gonçalo Portela, Direcção de Orquestra de Ferreira Lobo e Direcção Artística de Manuel Pedro Nunes e Ferreira Lobo.             Manuel Pedro Nunes                          José Ferreira Lobo A Orquestra do Norte concretiza, desde 1992, o projecto de descentralização da cultura musical, apresentado pela Associação Norte Cultural, vencedora do primeiro concurso nacional para a criação de orquestras regionais, instituído pelo Estado Português, nesse mesmo ano. Iniciadora de um trabalho verdadeiramente pioneiro e inédito, esta orquestra tem vindo a afirmar-se no panorama da música erudita, realizando os seus concertos de norte a sul de Portugal e também noutros países, como é o caso de Espanha e de França. A Orquestra do Norte integra profissionais de reconhecido mérito e tem, habitualmente, a colaboração de prestigiados Maestros, Solistas e Coros nacionais e estrangeiros, que permitem a interpretação de um reportório variado, que inclui concertos sinfónicos, didáctico-pedagógicos, ópera, música de bailado e música de câmara. O Maestro Titular e Director Musical é, desde a sua fundação, José Ferreira Lobo.José Ferreira Lobo iniciou a sua actividade profissional em 1979 como Maestro Director da Camerata do Porto, orquestra de câmara que fundou com Madalena Sá e Costa.Em 1992, funda a Associação Norte Cultural, sendo o seu projecto, o vencedor do primeiro Concurso para criação de Orquestras Regionais, instituído pelo estado português. Neste contexto, cria a Orquestra do Norte, de que é o seu Maestro Titular e Director Artístico. Colaborou com artistas consagrados internacionalmente, entre outros, Krisztof Penderecki, José Carreras, Júlia Hamari, Regis Pasquier e Katia Ricciarelli. Dirigiu óperas e realizou concertos em inúmeros países.É regularmente convidado a integrar mesas de júri de prestigiados Concursos Internacionais. Dirigiu estreias mundiais de compositores franceses, portugueses, suíços e turcos. Possui um amplo repertório que abrange o clássico e o romântico, passando por trabalhos contemporâneos e trinta títulos de ópera.  Manuel Pedro Nunes nasceu no Barreiro e iniciou os seus estudos na Academia de Amadores de Música, com a professora Albertina Xavier. Concluiu o Curso Superior de Canto com a classificação máxima. Prosseguiu os seus estudos no Mozarteum, em Salzburgo, com o professor Rudolf Knoll. Foi bolseiro do Ministério da Cultura e da Fundação Luso Americana. É licenciado pela Escola Superior de Música de Lisboa, para concluir a nova licenciatura, de novo com a classificação máxima. Tem feito recitais para a RDP, Fundação Gulbenkian, várias Autarquias, Universidade de Aveiro e Instituto Franco-Português, entre outros. Tem actuado como solista nas Missas de Schubert, na Missa em Dó Menor de Mozart e em "A Criação" de Haydn. Em Ópera, estreou-se no Teatro da Trindade como Conde Almaviva em "As Bodas de Fígaro" de Mozart. O seu repertório integra as principais obras de “Lied”, concerto e papéis operáticos para a sua voz de barítono lírico. Os seus projectos futuros incluem a gravação de um disco e a ampliação do seu reportório operático, com estudo de papéis wagnerianos e straussianos. Nesta soberba ópera, contam-se as sucessivas aventuras e desventuras de Don Giovanni, até à sua condenação aos Infernos, numa trama brilhantemente tecida por Lorenzo da Ponte e pela música de Mozart, em que um conjunto de personagens magnificamente caracterizadas vão desfilando até ao drama final. A produção é exclusivamente portuguesa e a organização é da Associação eborae Mvsica. Sinopse: versão encenada com orquestra da grande ópera “Don Giovanni” de Mozart. Nesta soberba ópera, contam-se as sucessivas aventuras e desventuras de Don Giovanni, até à sua condenação aos Infernos, numa trama brilhantemente tecida por Lorenzo da Ponte e pela música de Mozart, em que um conjunto de personagens magnificamente caracterizadas vão desfilando até ao drama final. A produção é exclusivamente portuguesa e conta com alguns dos nomes cimeiros da nova geração de cantores portugueses.  Elenco: Don Giovanni - Manuel Pedro Nunes (barítono), Leporello - Diogo Oliveira (barítono), Masetto - Tomás Vaz da Silva (barítono), Comendador - Nuno Villalonga (barítono), Don Ottavio - Fernando Guimarães (tenor), Donna Anna - Ana Madalena Moreira (soprano), Donna Elvira – Maria de Félix (soprano), Zerlina - Margarida Marecos (soprano) e Paule Grimaldi (cravista). Encenação de Gonçalo Portela.     Encenação: Gonçalo Portela Orquestra do Norte: Maestro: Ferreira Lobo Direcção Artística, Manuel Pedro Nunes // Ferreira Lobo                       Manuel Pedro Nunes                          José Ferreira Lobo A Orquestra do Norte concretiza, desde 1992, o projecto de descentralização da cultura musical, apresentado pela Associação Norte Cultural, vencedora do primeiro concurso nacional para a criação de orquestras regionais, instituído pelo Estado Português, nesse mesmo ano. Iniciadora de um trabalho verdadeiramente pioneiro e inédito, esta orquestra tem vindo a afirmar-se no panorama da música erudita, realizando os seus concertos de norte a sul de Portugal e também noutros países, como é o caso de Espanha e de França. A Orquestra do Norte integra profissionais de reconhecido mérito e tem, habitualmente, a colaboração de prestigiados Maestros, Solistas e Coros nacionais e estrangeiros, que permitem a interpretação de um reportório variado, que inclui concertos sinfónicos, didáctico-pedagógicos, ópera, música de bailado e música de câmara. O Maestro Titular e Director Musical é, desde a sua fundação, José Ferreira Lobo.José Ferreira Lobo iniciou a sua actividade profissional em 1979 como Maestro Director da Camerata do Porto, orquestra de câmara que fundou com Madalena Sá e Costa.Em 1992, funda a Associação Norte Cultural, sendo o seu projecto, o vencedor do primeiro Concurso para criação de Orquestras Regionais, instituído pelo estado português. Neste contexto, cria a Orquestra do Norte, de que é o seu Maestro Titular e Director Artístico. Colaborou com artistas consagrados internacionalmente, entre outros, Krisztof Penderecki, José Carreras, Júlia Hamari, Regis Pasquier e Katia Ricciarelli. Dirigiu óperas e realizou concertos em inúmeros países.É regularmente convidado a integrar mesas de júri de prestigiados Concursos Internacionais. Dirigiu estreias mundiais de compositores franceses, portugueses, suíços e turcos. Possui um amplo repertório que abrange o clássico e o romântico, passando por trabalhos contemporâneos e trinta títulos de ópera.  Manuel Pedro Nunes nasceu no Barreiro e iniciou os seus estudos na Academia de Amadores de Música, com a professora Albertina Xavier. Concluiu o Curso Superior de Canto com a classificação máxima. Prosseguiu os seus estudos no Mozarteum, em Salzburgo, com o professor Rudolf Knoll. Foi bolseiro do Ministério da Cultura e da Fundação Luso Americana. É licenciado pela Escola Superior de Música de Lisboa, para concluir a nova licenciatura, de novo com a classificação máxima. Tem feito recitais para a RDP, Fundação Gulbenkian, várias Autarquias, Universidade de Aveiro e Instituto Franco-Português, entre outros. Tem actuado como solista nas Missas de Schubert, na Missa em Dó Menor de Mozart e em "A Criação" de Haydn. Em Ópera, estreou-se no Teatro da Trindade como Conde Almaviva em "As Bodas de Fígaro" de Mozart. O seu repertório integra as principais obras de “Lied”, concerto e papéis operáticos para a sua voz de barítono lírico. Os seus projectos futuros incluem a gravação de um disco e a ampliação do seu reportório operático, com estudo de papéis wagnerianos e straussianos.   [ Voltar ]	Destaques Prémio de Composição 2ª Escola de Évora - 2021 Masterclass de Guitarra - Alterado para 26, 27 e 28 de Março Nova Página da Eborae Mvsica Próximos Eventos Janeiro 2019 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 Name Email 62701071 Visitas
Concepção e Alojamento: VGSoftware

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 = 17 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1713574988' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713574988' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
6
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 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 = 17
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 = 94 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 02:18' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 02:18' )
 AND a.access <= 0
13
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '94'
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
16
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'
17
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
18
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 = 17 )
 ORDER BY ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
20
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
21
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
22
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
23
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
24
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
25
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
26
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-04-20 02:18:09') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 02:18:09')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
27
SELECT *
 FROM jos_content
 WHERE id = '1332'
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 = 1332
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
29
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
30
SELECT *
 FROM jos_content
 WHERE id = '1333'
31
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
32
SELECT *
 FROM jos_content
 WHERE id = '1334'
33
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
34
SELECT * FROM jos_jcalpro_config
35
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
36
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
37
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
38
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
39
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
40
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
41
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
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 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
43
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
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 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
45
SELECT
  	cat_id, level
  FROM
  	jos_jcalpro_categories
46
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
47
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
48
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
49
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
50
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
51
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
52
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
53
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
54
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
55
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') <= 20190101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190101 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190101 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
56
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') <= 20190101) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
57
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') <= 20190102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190102 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190102 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
58
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') <= 20190102) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
59
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') <= 20190103 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190103 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190103 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
60
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') <= 20190103) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
61
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') <= 20190104 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190104 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190104 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
62
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') <= 20190104) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
63
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') <= 20190105 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190105 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190105 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
64
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') <= 20190105) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
65
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') <= 20190106 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190106 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190106 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
66
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') <= 20190106) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
67
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') <= 20190107 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190107 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190107 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
68
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') <= 20190107) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
69
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') <= 20190108 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190108 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190108 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
70
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') <= 20190108) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
71
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') <= 20190109 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190109 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190109 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
72
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') <= 20190109) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
73
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') <= 20190110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190110 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190110 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
74
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') <= 20190110) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
75
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') <= 20190111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190111 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190111 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
76
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') <= 20190111) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
77
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') <= 20190112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190112 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190112 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
78
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') <= 20190112) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
79
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') <= 20190113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190113 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190113 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
80
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') <= 20190113) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
81
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') <= 20190114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190114 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190114 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
82
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') <= 20190114) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
83
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') <= 20190115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190115 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190115 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
84
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') <= 20190115) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
85
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') <= 20190116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190116 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190116 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
86
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') <= 20190116) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
87
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') <= 20190117 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190117 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190117 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
88
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') <= 20190117) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
89
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') <= 20190118 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190118 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190118 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
90
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') <= 20190118) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
91
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') <= 20190119 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190119 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190119 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
92
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') <= 20190119) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
93
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') <= 20190120 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190120 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190120 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94
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') <= 20190120) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
95
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') <= 20190121 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190121 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190121 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
96
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') <= 20190121) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
97
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') <= 20190122 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190122 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190122 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
98
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') <= 20190122) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
99
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') <= 20190123 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190123 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190123 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
100
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') <= 20190123) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
101
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') <= 20190124 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190124 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190124 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
102
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') <= 20190124) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
103
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') <= 20190125 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190125 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190125 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
104
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') <= 20190125) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
105
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') <= 20190126 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190126 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190126 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106
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') <= 20190126) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
107
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') <= 20190127 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190127 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190127 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108
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') <= 20190127) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
109
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') <= 20190128 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190128 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190128 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110
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') <= 20190128) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
111
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') <= 20190129 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190129 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190129 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
112
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') <= 20190129) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
113
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') <= 20190130 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190130 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190130 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
114
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') <= 20190130) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
115
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') <= 20190131 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190131 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190131 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
116
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') <= 20190131) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
117
SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'