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 2022 Novembro 2022 Dezembro 2022
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




64565051 Visitas

138 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 < '1716019016' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1716019016' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = 'b7f3214e094c7ab6e7f0b06686981a1b'
6
UPDATE jos_session SET `time`='1716019916',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='b7f3214e094c7ab6e7f0b06686981a1b'
7
SELECT *
 FROM jos_menu
 WHERE id = 36
8
SELECT *
 FROM jos_menu
 WHERE id = '36'
9
SELECT *
 FROM jos_fabrik_tables
 WHERE id = '2'
10
SELECT *
 FROM jos_fabrik_forms
 WHERE id = '2'
11
SELECT *
 FROM jos_fabrik_connections
 WHERE id = '1'
12
SELECT * FROM jos_fabrik_joins WHERE table_id = '2' ORDER BY id
13
SELECT jos_fabrik_formgroup.group_id AS group_id FROM jos_fabrik_formgroup
		WHERE jos_fabrik_formgroup.form_id = '2' ORDER BY ordering
14
SELECT *
 FROM jos_fabrik_groups
 WHERE id = '2'
15
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
16
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'
17
SELECT id FROM jos_fabrik_validations WHERE element_id = '6'
18
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'
19
SELECT id FROM jos_fabrik_validations WHERE element_id = '7'
20
SELECT *
 FROM jos_fabrik_forms
 WHERE id = '2'
21
SELECT jos_fabrik_formgroup.group_id AS group_id FROM jos_fabrik_formgroup
		WHERE jos_fabrik_formgroup.form_id = '2' ORDER BY ordering
22
SELECT *
 FROM jos_fabrik_groups
 WHERE id = '2'
23
SELECT id FROM  jos_fabrik_elements   
		WHERE group_id = '2'  AND jos_fabrik_elements.state = '1' ORDER BY ordering
24
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'
25
SELECT id FROM jos_fabrik_validations WHERE element_id = '5'
26
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'
27
SELECT id FROM jos_fabrik_validations WHERE element_id = '6'
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 = '7'
29
SELECT id FROM jos_fabrik_validations WHERE element_id = '7'
30
SELECT *
 FROM jos_fabrik_connections
 WHERE id = '1'
31
UPDATE jos_fabrik_tables
 SET hits = ( hits + 1 )
 WHERE id = '2'
32
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'
33
SELECT *
 FROM jos_fabrik_tables
 WHERE id = '2'
34
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
35
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
36
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
37
select name from jos_core_acl_aro_groups where group_id >= '24' AND group_id < 28
38
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'
39
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
40
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
41
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
42
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'associacao'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
43
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'conservatorio'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
44
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
45
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
47
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
48
SELECT a.id
 FROM jos_content AS a
 INNER JOIN jos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access  <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-18 09:11:57') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 09:11:57')
 AND catid='5' 
 ORDER BY a.created asc LIMIT 5
49
SELECT *
 FROM jos_content
 WHERE id = '1332'
50
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
51
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
52
SELECT *
 FROM jos_content
 WHERE id = '1333'
53
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
54
SELECT *
 FROM jos_content
 WHERE id = '1334'
55
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
56
SELECT * FROM jos_jcalpro_config
57
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
58
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
59
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
60
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
61
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
62
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
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
  	cat_id, level
  FROM
  	jos_jcalpro_categories
68
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
69
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
70
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
71
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
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 name FROM jos_jcalpro_themes WHERE published= '1'
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') <= 20221101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221101 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221101 ) ) 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') <= 20221101) 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') <= 20221102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221102 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221102 ) ) 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') <= 20221102) 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') <= 20221103 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221103 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221103 ) ) 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') <= 20221103) 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') <= 20221104 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221104 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221104 ) ) 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') <= 20221104) 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') <= 20221105 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221105 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221105 ) ) 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') <= 20221105) 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') <= 20221106 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221106 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221106 ) ) 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') <= 20221106) 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') <= 20221107 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221107 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221107 ) ) 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') <= 20221107) 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') <= 20221108 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221108 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221108 ) ) 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') <= 20221108) 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') <= 20221109 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221109 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221109 ) ) 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') <= 20221109) 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') <= 20221110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221110 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221110 ) ) 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') <= 20221110) 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') <= 20221111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221111 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221111 ) ) 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') <= 20221111) 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') <= 20221112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221112 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221112 ) ) 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') <= 20221112) 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') <= 20221113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221113 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221113 ) ) 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') <= 20221113) 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') <= 20221114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221114 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221114 ) ) 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') <= 20221114) 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') <= 20221115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221115 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221115 ) ) 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') <= 20221115) 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') <= 20221116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221116 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221116 ) ) 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') <= 20221116) 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') <= 20221117 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221117 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221117 ) ) 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') <= 20221117) 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') <= 20221118 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221118 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221118 ) ) 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') <= 20221118) 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') <= 20221119 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221119 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221119 ) ) 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') <= 20221119) 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') <= 20221120 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221120 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221120 ) ) 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') <= 20221120) 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') <= 20221121 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221121 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221121 ) ) 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') <= 20221121) 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') <= 20221122 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221122 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221122 ) ) 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') <= 20221122) 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') <= 20221123 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221123 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221123 ) ) 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') <= 20221123) 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') <= 20221124 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221124 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221124 ) ) 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') <= 20221124) 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') <= 20221125 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221125 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221125 ) ) 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') <= 20221125) 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') <= 20221126 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221126 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221126 ) ) 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') <= 20221126) 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') <= 20221127 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221127 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221127 ) ) 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') <= 20221127) 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') <= 20221128 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221128 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221128 ) ) 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') <= 20221128) 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') <= 20221129 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221129 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221129 ) ) 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') <= 20221129) 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') <= 20221130 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20221130 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20221130 ) ) 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') <= 20221130) 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 sum(hits) AS count FROM jos_stats_agents WHERE type='1'
138
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering