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
Cursos


Iniciação Musical Pré-Escolar

Iniciação Musical:

Tem como objectivos despertar o interesse e a curiosidade pelos fenómenos do som e da música, promover o desenvolvimento musical da criança e contribuir para a integração da formação musical e artística na sua educação.

 

Iniciação ao Instrumento:

Tem como objectivos promover o desenvolvimento da memória, a capacidade de concentração, a agilidade de raciocínio e a coordenação motora, cultivar a disciplina de trabalho aliada ao rigor técnico, fomentando o apuramento do sentido estético e potenciar as capacidades individuais da criança, valorização pessoal e auto-estima.

Curso de Iniciação

Destina-se aos alunos que frequentam o 1º Ciclo do Ensino Básico, do 1º ao 4º ano de escolaridade.

Constituído por 3 Disciplinas: Formação Musical Preparatória - Formação Instrumental Preparatória - Classe de Conjunto Preparatória

 

Objectivos:

§ Desenvolver capacidades fundamentais para o crescimento da criança: desenvolvimento da memória, capacidade de concentração, agilidade de raciocínio e coordenação motora.

§ Promover a aquisição dos conceitos básicos da Música como suporte para o prosseguimento dos estudos musicais.

§ Cultivar a disciplina de trabalho aliada ao rigor técnico, fomentando o apuramento do sentido estético.

§ Potenciar as capacidades individuais da criança, valorização pessoal e auto-estima.

§ Contribuir para o desenvolvimento global e harmonioso da criança.

§ Fomentar a interacção social, cooperação e respeito pelo próximo.

Cursos Básicos e Secundários

Destinam-se aos alunos que frequentam os 2º, 3º Ciclos do Ensino Básico e Secundário, e outros interessados. Têm como principal finalidade promover a compreensão dos conceitos da música nos diferentes aspectos técnicos e científicos, desenvolver atitudes analíticas e criativas perante a audição musical e adquirir o domínio de um instrumento. Podem ser frequentados num dos seguintes regimes:

 

   I) Articulado – Dirigido a alunos que frequentem do 5º ao 9º ano de escolaridade, de acordo com a legislação em vigor, em articulação com a escola de ensino regular. Ensino Gratuito!


   II) Supletivo – Dirigido a qualquer aluno que queira frequentar a escola de música e obter certificações a nível oficial.

 

       Os alunos do Conservatório Regional de Évora - Eboræ Mvsica que frequentam o regime oficial – supletivo ou articulado – obtêm, no término dos respectivos Cursos, o diploma correspondente ao 12º ano do Ensino Vocacional da Música, estando habilitados ao ingresso no Ensino Superior (Universidade de Évora, Universidade Nova de Lisboa e Universidade de Aveiro), e Ensino Politécnico (Escolas Superiores de Música de Lisboa, Porto e Castelo Branco, e Escolas Superiores de Educação).

Destaques
Próximos Eventos
Outubro 2029 Novembro 2029 Dezembro 2029
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
Notícias RSS
Newletter




76608088 Visitas

142 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 = 36 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1731939139' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1731939139' )
 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 = 36
12
SELECT *
 FROM jos_menu
 WHERE id = '36'
13
SELECT *
 FROM jos_fabrik_tables
 WHERE id = '2'
14
SELECT *
 FROM jos_fabrik_forms
 WHERE id = '2'
15
SELECT *
 FROM jos_fabrik_connections
 WHERE id = '1'
16
SELECT * FROM jos_fabrik_joins WHERE table_id = '2' ORDER BY id
17
SELECT jos_fabrik_formgroup.group_id AS group_id FROM jos_fabrik_formgroup
		WHERE jos_fabrik_formgroup.form_id = '2' ORDER BY ordering
18
SELECT *
 FROM jos_fabrik_groups
 WHERE id = '2'
19
SELECT id FROM  jos_fabrik_elements   
		WHERE group_id = '2'  AND jos_fabrik_elements.state = '1'  AND show_in_table_summary = '1' ORDER BY ordering
20
SELECT jos_fabrik_elements.*, 
 concat( action , ' = "' ,  code , '"') as js
 FROM jos_fabrik_elements
 left join jos_fabrik_jsactions on
 jos_fabrik_elements.id
 = jos_fabrik_jsactions.element_id
 WHERE jos_fabrik_elements.id = '6'
21
SELECT id FROM jos_fabrik_validations WHERE element_id = '6'
22
SELECT jos_fabrik_elements.*, 
 concat( action , ' = "' ,  code , '"') as js
 FROM jos_fabrik_elements
 left join jos_fabrik_jsactions on
 jos_fabrik_elements.id
 = jos_fabrik_jsactions.element_id
 WHERE jos_fabrik_elements.id = '7'
23
SELECT id FROM jos_fabrik_validations WHERE element_id = '7'
24
SELECT *
 FROM jos_fabrik_forms
 WHERE id = '2'
25
SELECT jos_fabrik_formgroup.group_id AS group_id FROM jos_fabrik_formgroup
		WHERE jos_fabrik_formgroup.form_id = '2' ORDER BY ordering
26
SELECT *
 FROM jos_fabrik_groups
 WHERE id = '2'
27
SELECT id FROM  jos_fabrik_elements   
		WHERE group_id = '2'  AND jos_fabrik_elements.state = '1' ORDER BY ordering
28
SELECT jos_fabrik_elements.*, 
 concat( action , ' = "' ,  code , '"') as js
 FROM jos_fabrik_elements
 left join jos_fabrik_jsactions on
 jos_fabrik_elements.id
 = jos_fabrik_jsactions.element_id
 WHERE jos_fabrik_elements.id = '5'
29
SELECT id FROM jos_fabrik_validations WHERE element_id = '5'
30
SELECT jos_fabrik_elements.*, 
 concat( action , ' = "' ,  code , '"') as js
 FROM jos_fabrik_elements
 left join jos_fabrik_jsactions on
 jos_fabrik_elements.id
 = jos_fabrik_jsactions.element_id
 WHERE jos_fabrik_elements.id = '6'
31
SELECT id FROM jos_fabrik_validations WHERE element_id = '6'
32
SELECT jos_fabrik_elements.*, 
 concat( action , ' = "' ,  code , '"') as js
 FROM jos_fabrik_elements
 left join jos_fabrik_jsactions on
 jos_fabrik_elements.id
 = jos_fabrik_jsactions.element_id
 WHERE jos_fabrik_elements.id = '7'
33
SELECT id FROM jos_fabrik_validations WHERE element_id = '7'
34
SELECT *
 FROM jos_fabrik_connections
 WHERE id = '1'
35
UPDATE jos_fabrik_tables
 SET hits = ( hits + 1 )
 WHERE id = '2'
36
SELECT *, t.label AS tablelabel FROM jos_fabrik_elements AS el LEFT JOIN jos_fabrik_formgroup AS fg 
				ON fg.group_id = el.group_id 
				LEFT JOIN jos_fabrik_forms AS f 
				ON f.id = fg.form_id 
				LEFT JOIN jos_fabrik_tables AS t 
				ON t.form_id = f.id WHERE  elementtype_id = '12' AND join_db_name = 'cursos' AND join_conn_id = '1'
37
SELECT *
 FROM jos_fabrik_tables
 WHERE id = '2'
38
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
39
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
40
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
41
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
42
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'
43
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
44
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 = 36 )
 ORDER BY ordering
45
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
46
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
47
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
48
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
49
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
50
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
51
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
52
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-11-18 14:27:20') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-18 14:27:20')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
53
SELECT *
 FROM jos_content
 WHERE id = '1332'
54
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
55
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
56
SELECT *
 FROM jos_content
 WHERE id = '1333'
57
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
58
SELECT *
 FROM jos_content
 WHERE id = '1334'
59
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
60
SELECT * FROM jos_jcalpro_config
61
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
62
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
63
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
64
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
65
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
66
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
67
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
68
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
69
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
70
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
71
SELECT
  	cat_id, level
  FROM
  	jos_jcalpro_categories
72
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
73
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
74
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
75
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
76
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
77
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
78
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
79
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
80
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
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') <= 20291101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291101 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291101 ) ) 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') <= 20291101) 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') <= 20291102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291102 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291102 ) ) 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') <= 20291102) 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') <= 20291103 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291103 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291103 ) ) 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') <= 20291103) 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') <= 20291104 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291104 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291104 ) ) 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') <= 20291104) 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') <= 20291105 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291105 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291105 ) ) 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') <= 20291105) 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') <= 20291106 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291106 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291106 ) ) 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') <= 20291106) 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') <= 20291107 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291107 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291107 ) ) 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') <= 20291107) 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') <= 20291108 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291108 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291108 ) ) 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') <= 20291108) 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') <= 20291109 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291109 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291109 ) ) 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') <= 20291109) 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') <= 20291110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291110 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291110 ) ) 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') <= 20291110) 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') <= 20291111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291111 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291111 ) ) 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') <= 20291111) 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') <= 20291112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291112 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291112 ) ) 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') <= 20291112) 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') <= 20291113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291113 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291113 ) ) 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') <= 20291113) 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') <= 20291114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291114 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291114 ) ) 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') <= 20291114) 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') <= 20291115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291115 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291115 ) ) 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') <= 20291115) 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') <= 20291116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291116 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291116 ) ) 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') <= 20291116) 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') <= 20291117 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291117 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291117 ) ) 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') <= 20291117) 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') <= 20291118 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291118 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291118 ) ) 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') <= 20291118) 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 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') <= 20291119 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291119 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291119 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
118
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') <= 20291119) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
119
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') <= 20291120 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291120 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291120 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
120
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') <= 20291120) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
121
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') <= 20291121 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291121 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291121 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
122
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') <= 20291121) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
123
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') <= 20291122 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291122 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291122 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
124
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') <= 20291122) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
125
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') <= 20291123 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291123 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291123 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
126
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') <= 20291123) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
127
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') <= 20291124 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291124 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291124 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
128
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') <= 20291124) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
129
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') <= 20291125 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291125 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291125 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
130
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') <= 20291125) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
131
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') <= 20291126 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291126 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291126 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
132
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') <= 20291126) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
133
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') <= 20291127 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291127 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291127 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
134
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') <= 20291127) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
135
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') <= 20291128 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291128 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291128 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
136
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') <= 20291128) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
137
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') <= 20291129 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291129 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291129 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
138
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') <= 20291129) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
139
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') <= 20291130 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20291130 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20291130 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
140
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') <= 20291130) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
141
SELECT sum(hits) AS count FROM jos_stats_agents WHERE type='1'
142
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering