/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' => ''
)
Loisirs - Ma Commune

Vie Communale

PRATIQUE

description loisirs
Village Fleuri 3

LA LETTRE D'INFORMATIONS

(default) 245 queries took 251 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 5001
2SELECT `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` = 52 LIMIT 1111
3SELECT `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` = (52) 001
4SELECT `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` = 6001
5SELECT `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` = 53 LIMIT 1111
6SELECT `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` = (53) 001
7SELECT `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` = 8001
8SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 9001
9SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 10001
10SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 3001
11SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 11001
12SELECT `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` = 6 LIMIT 1111
13SELECT `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
14SELECT `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
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` = 7 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` = (7) 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` = 14001
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` = 8 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` = (8) 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` = 13001
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` = 12 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` = (12) 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` = 15001
24SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 16001
25SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 17000
26SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 19000
27SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 20000
28SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 21001
29SELECT `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
30SELECT `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
31SELECT `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
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` = 25 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` = (25) 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` = 24001
35SELECT `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
36SELECT `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
37SELECT `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
38SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 25001
39SELECT `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
40SELECT `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
41SELECT `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
42SELECT `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
43SELECT `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
44SELECT `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
45SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 29001
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` = 56 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` = (56) 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` = 30001
49SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 35001
50SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 36000
51SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 37000
52SELECT `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
53SELECT `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
54SELECT `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
55SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 33001
56SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 39001
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` = 37 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` = (37) 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` = 40001
60SELECT `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
61SELECT `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
62SELECT `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
63SELECT `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
64SELECT `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) 002
65SELECT `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
66SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 43001
67SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 44001
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` = 50 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` = (50) 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` = 45001
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` = 51 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` = (51) 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` = 46001
74SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 47001
75SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 50001
76SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 51001
77SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 52111
78SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 54001
79SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 55001
80SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 56001
81SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 48000
82SELECT `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
83SELECT `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
84SELECT `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
85SELECT `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
86SELECT `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
87SELECT `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
88SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 32001
89SELECT `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
90SELECT `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
91SELECT `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
92SELECT `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
93SELECT `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
94SELECT `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
95SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 59001
96SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 60111
97SELECT `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
98SELECT `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
99SELECT `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
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` = 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
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` = 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
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` = 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
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` = 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
104SELECT `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
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` = 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
106SELECT `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
107SELECT `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
108SELECT `ElusFonction`.`id`, `ElusFonction`.`elus_id`, `ElusFonction`.`fonction_id` FROM `mairie85`.`elus_fonctions` AS `ElusFonction` WHERE `ElusFonction`.`elus_id` IN (3821, 3822, 3823) 15151
109SELECT `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
110SELECT `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
111SELECT `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
112SELECT `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
113SELECT `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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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` ASC003
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` = 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
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` = 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
140SELECT `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
141SELECT `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
142SELECT `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
143SELECT `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
144SELECT `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
145SELECT `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
146SELECT `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
147SELECT `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
148SELECT `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
149SELECT `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
150SELECT `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
151SELECT `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
152SELECT `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
153SELECT `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
154SELECT `Social`.`id`, `Social`.`name`, `Social`.`url`, `Social`.`url-option-1`, `Social`.`url-option-2`, `Social`.`image` FROM `mairie85`.`socials` AS `Social` WHERE 1 = 1441
155SELECT `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
156SELECT `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
157SELECT `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
158SELECT `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
159SELECT `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
160SELECT `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
161SELECT `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
162SELECT `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
163SELECT `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
164SELECT `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
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` = 1839001
166SELECT `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
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` = 27001
168SELECT `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
169SELECT `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
170SELECT `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
171SELECT `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
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` = 1882001
173SELECT `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
174SELECT `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
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` = 1572001
176SELECT `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
177SELECT `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
178SELECT `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
179SELECT `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
180SELECT `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
181SELECT `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
182SELECT `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
183SELECT `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
184SELECT `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
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`.`categorie_id` = 29001
186SELECT `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
187SELECT `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
188SELECT `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
189SELECT `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
190SELECT `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
191SELECT `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
192SELECT `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
193SELECT `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
194SELECT `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
195SELECT `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
196SELECT `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
197SELECT `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`.`url` = 'loisirs' LIMIT 1111
198SELECT `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` = (1793) ORDER BY `position` ASC, `name` ASC 001
199SELECT `children`.`id`, `children`.`name`, `children`.`url`, `children`.`logo`, `children`.`offline`, `children`.`couleur`, `children`.`parent_id` FROM `mairie85`.`categories` AS `children` WHERE `children`.`parent_id` = (1793) ORDER BY `position` ASC, `name` ASC 001
200SELECT `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` = (1793) ORDER BY `position` ASC, `name` ASC 001