/app/Controller/AppController.php (line 1064)
array(
	'id' => '13',
	'display' => 'left',
	'name' => 'modCategorie',
	'title' => 'Vie Communale',
	'name-display' => 'oui',
	'contenu' => 'Categorie',
	'actif' => 'oui',
	'type' => null,
	'option_type' => null,
	'mode' => null,
	'option_mode' => null,
	'couleur' => '',
	'font-couleur' => '',
	'couleur-rvb' => array(),
	'font-couleur-rvb' => array(),
	'mode-couleur' => '',
	'relief' => '',
	'largeur' => ''
)
L'équipe municipale - Ma Commune

Vie Communale

PRATIQUE

Village Fleuri 3

LA LETTRE D'INFORMATIONS

(default) 252 queries took 260 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 7 LIMIT 1111
2SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (7) 001
3SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 14001
4SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 8 LIMIT 1111
5SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (8) 001
6SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 13001
7SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 12 LIMIT 1111
8SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (12) 001
9SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 15001
10SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 16001
11SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 17001
12SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 19001
13SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 20001
14SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 21000
15SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 22 LIMIT 1111
16SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (22) 001
17SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 23001
18SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 25 LIMIT 1111
19SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (25) 001
20SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 24001
21SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 32 LIMIT 1111
22SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (32) 001
23SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 22001
24SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 25000
25SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 54 LIMIT 1111
26SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (54) 001
27SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 27001
28SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 57 LIMIT 1111
29SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (57) 001
30SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 28001
31SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 29001
32SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 56 LIMIT 1111
33SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (56) 001
34SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 30001
35SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 35001
36SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 36001
37SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 37001
38SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 55 LIMIT 1111
39SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (55) 001
40SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 38001
41SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 33001
42SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 39001
43SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 37 LIMIT 1111
44SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (37) 001
45SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 40001
46SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 38 LIMIT 1111
47SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (38) 001
48SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 41001
49SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 39 LIMIT 1111
50SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (39) 001
51SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 42001
52SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 43001
53SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 44001
54SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 50 LIMIT 1111
55SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (50) 001
56SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 45001
57SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 51 LIMIT 1111
58SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (51) 001
59SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 46001
60SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 47001
61SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 50001
62SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 51001
63SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 52111
64SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 54001
65SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 55001
66SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 56001
67SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 48001
68SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 44 LIMIT 1111
69SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (44) 001
70SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 49001
71SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 45 LIMIT 1111
72SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (45) 001
73SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 57001
74SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 32001
75SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 46 LIMIT 1111
76SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (46) 001
77SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 34001
78SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 47 LIMIT 1111
79SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (47) 001
80SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 58001
81SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 59001
82SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 60111
83SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 48 LIMIT 1001
84SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 4 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
85SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 5 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC551
86SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 6 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC111
87SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 8 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
88SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 9 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
89SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 10 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
90SELECT `Commune`.`id`, `Commune`.`name`, `Commune`.`url`, `Commune`.`logo`, `Commune`.`presentation`, `Commune`.`insee`, `Commune`.`arrondissement_id`, `Commune`.`canton_id`, `Commune`.`population`, `Commune`.`habitant`, `Commune`.`superficie`, `Commune`.`altitude`, `Commune`.`latitude`, `Commune`.`longitude`, `Commune`.`comcom_id`, `Commune`.`associee`, `Commune`.`diaporama_id`, `Commune`.`site_id`, `Diaporama`.`id`, `Diaporama`.`site_id`, `Diaporama`.`user_id`, `Diaporama`.`name`, `Diaporama`.`display`, `Diaporama`.`width`, `Diaporama`.`height`, `Diaporama`.`model`, `Diaporama`.`album`, `Coordonnee`.`id`, `Coordonnee`.`name`, `Coordonnee`.`adresse`, `Coordonnee`.`cp`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`title-email`, `Coordonnee`.`email`, `Coordonnee`.`site_id`, `Coordonnee`.`commune_id` FROM `mairie85`.`communes` AS `Commune` LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Commune`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`coordonnees` AS `Coordonnee` ON (`Coordonnee`.`commune_id` = `Commune`.`id`) WHERE `Commune`.`site_id` = 382 AND `Commune`.`associee` = 'oui'001
91SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 11 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
92SELECT `Elu`.`id`, `Elu`.`name`, `Elu`.`url` FROM `mairie85`.`elus` AS `Elu` LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Elu`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Elu`.`site_id` = 382 AND `Elu`.`rubriques_site_id` = 12331
93SELECT `Personnel`.`id`, `Personnel`.`firstname`, `Personnel`.`lastname`, `Personnel`.`photo`, `Personnel`.`profession`, `Personnel`.`naissance`, `Personnel`.`texte`, `Personnel`.`email`, `Personnel`.`position`, `Personnel`.`fonction_id`, `Personnel`.`liste`, `Personnel`.`elus_id`, `Personnel`.`commune_id`, `Personnel`.`site_id` FROM `mairie85`.`personnels` AS `Personnel` WHERE `Personnel`.`elus_id` IN (3821, 3822, 3823) ORDER BY `position` ASC, `fonction_id` ASC 551
94SELECT `ElusFonction`.`id`, `ElusFonction`.`elus_id`, `ElusFonction`.`fonction_id` FROM `mairie85`.`elus_fonctions` AS `ElusFonction` WHERE `ElusFonction`.`elus_id` IN (3821, 3822, 3823) 15151
95SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` LEFT JOIN `mairie85`.`documents` AS `Document` ON (`Comptesrendu`.`document_id` = `Document`.`id`) WHERE `Comptesrendu`.`site_id` = 382 AND `Comptesrendu`.`rubriques_site_id` = 14 LIMIT 5111
96SELECT `Commission`.`id`, `Commission`.`name`, `Commission`.`url` FROM `mairie85`.`commissions` AS `Commission` LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Commission`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Commission`.`site_id` = 382 AND `Commission`.`rubriques_site_id` = 13661
97SELECT `CommissionsPersonnel`.`id`, `CommissionsPersonnel`.`type`, `CommissionsPersonnel`.`position`, `CommissionsPersonnel`.`personnel_id`, `CommissionsPersonnel`.`commission_id` FROM `mairie85`.`commissions_personnels` AS `CommissionsPersonnel` WHERE `CommissionsPersonnel`.`commission_id` IN (1505, 1504, 1503, 1502, 1501, 1651) ORDER BY `CommissionsPersonnel`.`position` ASC 551
98SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`document_id` FROM `mairie85`.`deliberations` AS `Deliberation` LEFT JOIN `mairie85`.`documents` AS `Document` ON (`Deliberation`.`document_id` = `Document`.`id`) WHERE `Deliberation`.`site_id` = 382 AND `Deliberation`.`rubriques_site_id` = 15 LIMIT 5001
99SELECT `Bulletin`.`id`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`document_id` FROM `mairie85`.`bulletins` AS `Bulletin` LEFT JOIN `mairie85`.`documents` AS `Document` ON (`Bulletin`.`document_id` = `Document`.`id`) WHERE `Bulletin`.`site_id` = 382 AND `Bulletin`.`rubriques_site_id` = 16 LIMIT 1111
100SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 17 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
101SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 19 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
102SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 20 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
103SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 21 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
104SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 23 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
105SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 24 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
106SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 22 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
107SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 25 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
108SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 27 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
109SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 28 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
110SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 29 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
111SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 30 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC111
112SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 35 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
113SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 36 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
114SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 37 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
115SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 38 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
116SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 33 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
117SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 39 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
118SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 40 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC111
119SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 41 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
120SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 42 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
121SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 43 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
122SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 44 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
123SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 45 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
124SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 46 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
125SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 47 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
126SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 50 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
127SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 51 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
128SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 52 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
129SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 54 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
130SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 55 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
131SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 56 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
132SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 48 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
133SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 49 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
134SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 57 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
135SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 32 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
136SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 34 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
137SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 58 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-21') AND (`Article`.`end_online` >= '2020-09-21')))) ORDER BY `Article`.`position` ASC001
138SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 59 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
139SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 60 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC111
140SELECT `Social`.`id`, `Social`.`name`, `Social`.`url`, `Social`.`url-option-1`, `Social`.`url-option-2`, `Social`.`image` FROM `mairie85`.`socials` AS `Social` WHERE 1 = 1441
141SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 5 LIMIT 1111
142SELECT `Outil`.`id`, `Outil`.`name`, `Outil`.`site_id`, `Outil`.`module_id`, `Outil`.`type`, `Outil`.`lien`, `Outil`.`icon`, `Outil`.`couleur` FROM `mairie85`.`outils` AS `Outil` WHERE `Outil`.`site_id` = 382 AND `Outil`.`module_id` = 5001
143SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 10 LIMIT 1111
144SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 11 LIMIT 1111
145SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 13 LIMIT 1111
146SELECT `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `Categorie`.`parent_id`, `Categorie`.`lft`, `Categorie`.`rght`, `Categorie`.`modifiable`, `Categorie`.`offline`, `Categorie`.`logo`, `Categorie`.`resume`, `Categorie`.`texte`, `Categorie`.`site_id`, `Categorie`.`position`, `Categorie`.`couleur`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`modifiable`, `Parent`.`offline`, `Parent`.`logo`, `Parent`.`resume`, `Parent`.`texte`, `Parent`.`site_id`, `Parent`.`position`, `Parent`.`couleur`, `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`categories` AS `Categorie` LEFT JOIN `mairie85`.`categories` AS `Parent` ON (`Categorie`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`annuaires` AS `Annuaire` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) WHERE `Categorie`.`site_id` = 382 AND `Categorie`.`parent_id` IS NULL AND `Categorie`.`offline` = 'non' ORDER BY `Categorie`.`position` ASC, `Categorie`.`name` ASC881
147SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`logo`, `Children`.`offline`, `Children`.`couleur`, `Children`.`parent_id` FROM `mairie85`.`categories` AS `Children` WHERE `offline` = 'non' AND `Children`.`parent_id` IN (23, 27, 1570, 2018, 28, 29, 30, 22) ORDER BY `position` ASC, `name` ASC 10101
148SELECT `children`.`id`, `children`.`name`, `children`.`url`, `children`.`logo`, `children`.`offline`, `children`.`couleur`, `children`.`parent_id` FROM `mairie85`.`categories` AS `children` WHERE `children`.`parent_id` IN (23, 27, 1570, 2018, 28, 29, 30, 22) ORDER BY `position` ASC, `name` ASC 14141
149SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo`, `Article`.`categorie_id` FROM `mairie85`.`articles` AS `Article` WHERE ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) AND `Article`.`categorie_id` IN (23, 27, 1570, 2018, 28, 29, 30, 22) ORDER BY `position` ASC, `name` ASC 001
150SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 23001
151SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1839001
152SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1839 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
153SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 27001
154SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1838001
155SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1838 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
156SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1834001
157SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1834 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
158SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1882001
159SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1882 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
160SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1570001
161SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1572001
162SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1572 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
163SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1574001
164SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1574 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
165SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 2018001
166SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 28001
167SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1793001
168SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1793 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
169SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1568001
170SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1568 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
171SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 29001
172SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 30001
173SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1567001
174SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1567 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
175SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 22001
176SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1827001
177SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 1827 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC, `Article`.`name` DESC001
178SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 14 LIMIT 1111
179SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 18 LIMIT 1111
180SELECT `Comcom`.`id`, `Comcom`.`name`, `Comcom`.`adresse`, `Comcom`.`cp`, `Comcom`.`ville`, `Comcom`.`tel`, `Comcom`.`fax`, `Comcom`.`mail`, `Comcom`.`url`, `Comcom`.`logo`, `Comcom`.`logo-w` FROM `mairie85`.`comcoms` AS `Comcom` WHERE `Comcom`.`id` = 1 LIMIT 1111
181SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 19 LIMIT 1111
182SELECT `Label`.`id`, `Label`.`name`, `Label`.`type`, `Label`.`icon`, `Label`.`position`, `Label`.`module_id`, `Label`.`site_id` FROM `mairie85`.`labels` AS `Label` WHERE `Label`.`site_id` = 382 AND `Label`.`module_id` = 19 ORDER BY `Label`.`position` ASC, `Label`.`name` ASC111
183SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE ((`Rubrique`.`url` = 'l-equipe-municipale') OR (`RubriquesSite`.`url` = 'l-equipe-municipale')) AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
184SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (6) 001
185SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 12001
186SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `Rubrique`.`id` = 19 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
187SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (19) 441
188SELECT `Elu`.`id`, `Elu`.`name`, `Elu`.`url`, `Elu`.`rubriques_site_id`, `Elu`.`site_id`, `RubriquesSite`.`rubrique_id` FROM `mairie85`.`elus` AS `Elu` LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Elu`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Elu`.`site_id` = 382 AND `Elu`.`rubriques_site_id` = 12 ORDER BY `Elu`.`id` ASC331
189SELECT `Personnel`.`id`, `Personnel`.`firstname`, `Personnel`.`lastname`, `Personnel`.`photo`, `Personnel`.`profession`, `Personnel`.`naissance`, `Personnel`.`texte`, `Personnel`.`email`, `Personnel`.`position`, `Personnel`.`fonction_id`, `Personnel`.`liste`, `Personnel`.`elus_id`, `Personnel`.`commune_id`, `Personnel`.`site_id` FROM `mairie85`.`personnels` AS `Personnel` WHERE `Personnel`.`elus_id` IN (3821, 3822, 3823) ORDER BY `position` ASC, `fonction_id` ASC 551
190SELECT `ElusFonction`.`id`, `ElusFonction`.`elus_id`, `ElusFonction`.`fonction_id` FROM `mairie85`.`elus_fonctions` AS `ElusFonction` WHERE `ElusFonction`.`elus_id` IN (3821, 3822, 3823) 15151
191SELECT `Personnel`.`id`, `Personnel`.`firstname`, `Personnel`.`lastname`, `Personnel`.`photo`, `Personnel`.`profession`, `Personnel`.`naissance`, `Personnel`.`texte`, `Personnel`.`email`, `Personnel`.`position`, `Personnel`.`fonction_id`, `Personnel`.`liste`, `Personnel`.`elus_id`, `Personnel`.`commune_id`, `Personnel`.`site_id`, `Elu`.`id`, `Elu`.`name`, `Elu`.`url`, `Elu`.`rubriques_site_id`, `Elu`.`site_id`, `Fonction`.`id`, `Fonction`.`name` FROM `mairie85`.`personnels` AS `Personnel` LEFT JOIN `mairie85`.`elus` AS `Elu` ON (`Personnel`.`elus_id` = `Elu`.`id`) LEFT JOIN `mairie85`.`fonctions` AS `Fonction` ON (`Personnel`.`fonction_id` = `Fonction`.`id`) WHERE `Personnel`.`site_id` = 382 AND `Personnel`.`elus_id` = 3821 ORDER BY `Personnel`.`position` ASC, `Personnel`.`fonction_id` ASC, `Personnel`.`firstname` ASC111
192SELECT `CommissionsPersonnel`.`id`, `CommissionsPersonnel`.`type`, `CommissionsPersonnel`.`position`, `CommissionsPersonnel`.`personnel_id`, `CommissionsPersonnel`.`commission_id` FROM `mairie85`.`commissions_personnels` AS `CommissionsPersonnel` WHERE `CommissionsPersonnel`.`personnel_id` = (2781) 111
193SELECT `Personnel`.`id`, `Personnel`.`firstname`, `Personnel`.`lastname`, `Personnel`.`photo`, `Personnel`.`profession`, `Personnel`.`naissance`, `Personnel`.`texte`, `Personnel`.`email`, `Personnel`.`position`, `Personnel`.`fonction_id`, `Personnel`.`liste`, `Personnel`.`elus_id`, `Personnel`.`commune_id`, `Personnel`.`site_id`, `Elu`.`id`, `Elu`.`name`, `Elu`.`url`, `Elu`.`rubriques_site_id`, `Elu`.`site_id`, `Fonction`.`id`, `Fonction`.`name` FROM `mairie85`.`personnels` AS `Personnel` LEFT JOIN `mairie85`.`elus` AS `Elu` ON (`Personnel`.`elus_id` = `Elu`.`id`) LEFT JOIN `mairie85`.`fonctions` AS `Fonction` ON (`Personnel`.`fonction_id` = `Fonction`.`id`) WHERE `Personnel`.`site_id` = 382 AND `Personnel`.`elus_id` = 3822 ORDER BY `Personnel`.`position` ASC, `Personnel`.`fonction_id` ASC, `Personnel`.`firstname` ASC221
194SELECT `CommissionsPersonnel`.`id`, `CommissionsPersonnel`.`type`, `CommissionsPersonnel`.`position`, `CommissionsPersonnel`.`personnel_id`, `CommissionsPersonnel`.`commission_id` FROM `mairie85`.`commissions_personnels` AS `CommissionsPersonnel` WHERE `CommissionsPersonnel`.`personnel_id` IN (3001, 2917) 111
195SELECT `Personnel`.`id`, `Personnel`.`firstname`, `Personnel`.`lastname`, `Personnel`.`photo`, `Personnel`.`profession`, `Personnel`.`naissance`, `Personnel`.`texte`, `Personnel`.`email`, `Personnel`.`position`, `Personnel`.`fonction_id`, `Personnel`.`liste`, `Personnel`.`elus_id`, `Personnel`.`commune_id`, `Personnel`.`site_id`, `Elu`.`id`, `Elu`.`name`, `Elu`.`url`, `Elu`.`rubriques_site_id`, `Elu`.`site_id`, `Fonction`.`id`, `Fonction`.`name` FROM `mairie85`.`personnels` AS `Personnel` LEFT JOIN `mairie85`.`elus` AS `Elu` ON (`Personnel`.`elus_id` = `Elu`.`id`) LEFT JOIN `mairie85`.`fonctions` AS `Fonction` ON (`Personnel`.`fonction_id` = `Fonction`.`id`) WHERE `Personnel`.`site_id` = 382 AND `Personnel`.`elus_id` = 3823 ORDER BY `Personnel`.`position` ASC, `Personnel`.`fonction_id` ASC, `Personnel`.`firstname` ASC221
196SELECT `CommissionsPersonnel`.`id`, `CommissionsPersonnel`.`type`, `CommissionsPersonnel`.`position`, `CommissionsPersonnel`.`personnel_id`, `CommissionsPersonnel`.`commission_id` FROM `mairie85`.`commissions_personnels` AS `CommissionsPersonnel` WHERE `CommissionsPersonnel`.`personnel_id` IN (2916, 2779) 331
197SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `Rubrique`.`id` = 19 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
198SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (19) 441
199SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `Rubrique`.`id` = 5 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
200SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (5) 12121