Accueil Nos liens Nous contacter L'UFF Présentation de l'UFF Pourquoi adhérer Fédérations régionales Toutes les fédérations Carte des fédérations Liste des Présidents Evènements Concours nat. 2010 Dates et lieux Accueil Infos diverses Répertoire de concours 2010 Identification Nom d'utilisateur Mot de passe Se souvenir de moi Mot de passe oublié ? Pas encore de compte ? Enregistrez-vous Derniers articles STAGE DE DIRECTION 2011 PRINTEMPS MUSICAL DE CAEN 2012 ECHO TECHNIQUE 2012 CONCOURS NATIONAL 2010 Concours de composition CAMPA Accueil Accueil ECHO TECHNIQUE 2012 19-11-2009 L'écho technique 2012 est maintenant disponible sur le site de l'UFF.   PRINTEMPS MUSICAL DE CAEN 2012 26-04-2010 Vous pouvez télécharger le dossier d'engagement pour le concours et le festival national de l'UFF à Caen, en cliquant sur le lien PDF ci dessous : dossier d'engagement Caen 2012     [ Retour ]
	Union des fanfares de France

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM uffcms_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM uffcms_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM uffcms_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 43 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM uffcms_session
 WHERE (
 ( time < '1327730961' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1327730961' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT COUNT(*)
 FROM uffcms_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
7
UPDATE uffcms_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
8
SELECT COUNT(*)
 FROM uffcms_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
9
UPDATE uffcms_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
10
SELECT COUNT(*)
 FROM uffcms_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
11
UPDATE uffcms_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
12
SELECT *
 FROM uffcms_menu
 WHERE id = 43
13
SELECT COUNT(a.id)
 FROM uffcms_content AS a
 INNER JOIN uffcms_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN uffcms_categories AS cc ON cc.id = a.catid
 INNER JOIN uffcms_sections AS s ON s.id = a.sectionid
 LEFT JOIN uffcms_users AS u ON u.id = a.created_by
 LEFT JOIN uffcms_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 01:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 01:24' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
14
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM uffcms_content AS a
 INNER JOIN uffcms_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN uffcms_categories AS cc ON cc.id = a.catid
 INNER JOIN uffcms_sections AS s ON s.id = a.sectionid
 LEFT JOIN uffcms_users AS u ON u.id = a.created_by
 LEFT JOIN uffcms_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 01:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 01:24' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.ordering
LIMIT 9
15
SELECT folder, element, published, params
 FROM uffcms_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
16
SELECT a.*
 FROM uffcms_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 id, title, module, position, content, showtitle, params
 FROM uffcms_modules AS m
 INNER JOIN uffcms_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 = 43 )
 ORDER BY ordering
18
SELECT m.*
 FROM uffcms_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
19
SELECT COUNT( id )
 FROM uffcms_menu 
 WHERE type = 'content_item_link'
 AND published = 1
20
SELECT id
 FROM uffcms_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1'
21
SELECT id
 FROM uffcms_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=3'
22
SELECT id
 FROM uffcms_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=2'
23
SELECT id
 FROM uffcms_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=27'
24
SELECT m.*
 FROM uffcms_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
25
SELECT id
 FROM uffcms_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=58'
26
SELECT a.id, a.title, a.sectionid, a.catid
 FROM uffcms_content AS a
 LEFT JOIN uffcms_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN uffcms_categories AS cc ON cc.id = a.catid
 INNER JOIN uffcms_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 01:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 01:24' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
27
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM uffcms_content AS i
 LEFT JOIN uffcms_sections AS s ON i.sectionid = s.id
 LEFT JOIN uffcms_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN uffcms_categories AS c ON i.catid = c.id
 LEFT JOIN uffcms_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 = 61
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
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 uffcms_content AS i
 LEFT JOIN uffcms_sections AS s ON i.sectionid = s.id
 LEFT JOIN uffcms_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN uffcms_categories AS c ON i.catid = c.id
 LEFT JOIN uffcms_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 = 55
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
29
SELECT id 
 FROM uffcms_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
30
SELECT id 
 FROM uffcms_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
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 uffcms_content AS i
 LEFT JOIN uffcms_sections AS s ON i.sectionid = s.id
 LEFT JOIN uffcms_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN uffcms_categories AS c ON i.catid = c.id
 LEFT JOIN uffcms_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 = 59
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM uffcms_content AS i
 LEFT JOIN uffcms_sections AS s ON i.sectionid = s.id
 LEFT JOIN uffcms_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN uffcms_categories AS c ON i.catid = c.id
 LEFT JOIN uffcms_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 = 27
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
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 uffcms_content AS i
 LEFT JOIN uffcms_sections AS s ON i.sectionid = s.id
 LEFT JOIN uffcms_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN uffcms_categories AS c ON i.catid = c.id
 LEFT JOIN uffcms_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 = 53
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
34
SELECT id, name, link, parent, type, menutype, access
 FROM uffcms_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering