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

Vie Communale

PRATIQUE

Article test

Soustitre de l'article test

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer finibus sit amet arcu quis pulvinar. Vivamus porttitor scelerisque augue non pulvinar. Sed fringilla metus ut tellus malesuada, et sagittis eros mattis. Mauris rhoncus velit non arcu accumsan hendrerit. Curabitur quis lectus risus. Praesent semper accumsan lorem, interdum lobortis augue dignissim ac. Phasellus malesuada diam neque, ut rhoncus libero rhoncus at. Vestibulum non scelerisque tortor. Duis ultrices scelerisque ipsum, at mattis leo. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus vel diam nec urna aliquam elementum sit amet fringilla massa. Vivamus sollicitudin pharetra tortor, ut lobortis nisi aliquet non. Proin tempus odio nec tortor tempus, et facilisis sem placerat. Nullam in magna nisl. Aliquam mi justo, fermentum nec egestas in, semper id lectus.

Suspendisse potenti. Nam sagittis urna vitae elementum interdum. Aenean vitae turpis sed neque suscipit eleifend. Donec convallis enim a mauris condimentum, vel efficitur enim dictum. Fusce ut leo non enim volutpat commodo. Suspendisse semper, sem sed viverra tincidunt, neque lacus feugiat justo, a egestas erat nisi id mauris. Aliquam erat volutpat. Morbi gravida augue eu purus cursus maximus. Nulla blandit at lorem sit amet sollicitudin. Duis efficitur turpis et elit luctus ultrices. Aenean ut quam vitae purus consectetur ultrices. Duis convallis arcu a tellus finibus, et consectetur mi luctus.

Pellentesque gravida fringilla dolor, vel egestas enim pretium ut. Etiam at finibus justo. Nunc eget condimentum dolor. Proin molestie condimentum tortor, eu egestas ligula tempor rhoncus. Cras a lacus scelerisque, feugiat velit in, imperdiet sapien. Cras ac efficitur tellus, sed mollis eros. Vestibulum at urna ante. Vivamus eleifend neque id dui placerat, at consequat magna venenatis.

Morbi quis tempus justo. Mauris ultrices justo at varius vestibulum. Phasellus lobortis nisl nec facilisis faucibus. Fusce luctus dictum hendrerit. Vivamus fringilla aliquam leo. Vivamus eleifend dignissim pretium. Donec tellus ligula, mattis pulvinar arcu ac, commodo varius diam. Etiam et libero lobortis, sodales leo quis, eleifend nulla.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam vulputate tincidunt sapien, nec iaculis urna dictum in. Cras vel purus eu ex tristique blandit eget in ante. Donec vitae elit eget mi feugiat vehicula. In ut justo est. Aenean faucibus venenatis neque, a egestas mi. In metus mauris, interdum et augue ac, commodo viverra elit.

Village Fleuri 3

LA LETTRE D'INFORMATIONS

(default) 255 queries took 258 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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
2SELECT `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
3SELECT `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
4SELECT `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
5SELECT `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
6SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 9001
7SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 10001
8SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 3001
9SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 11001
10SELECT `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
11SELECT `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
12SELECT `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
13SELECT `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
14SELECT `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
15SELECT `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
16SELECT `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
17SELECT `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
18SELECT `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
19SELECT `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
20SELECT `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
21SELECT `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
22SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 16001
23SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 17001
24SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 19001
25SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 20001
26SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 21001
27SELECT `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
28SELECT `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
29SELECT `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
30SELECT `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
31SELECT `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
32SELECT `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
33SELECT `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
34SELECT `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
35SELECT `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
36SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 25001
37SELECT `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
38SELECT `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
39SELECT `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
40SELECT `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
41SELECT `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
42SELECT `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
43SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 29001
44SELECT `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
45SELECT `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
46SELECT `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
47SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 35001
48SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 36001
49SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 37001
50SELECT `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
51SELECT `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
52SELECT `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
53SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 33001
54SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 39001
55SELECT `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
56SELECT `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
57SELECT `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
58SELECT `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
59SELECT `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
60SELECT `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
61SELECT `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
62SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (39) 001
63SELECT `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
64SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 43001
65SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 44001
66SELECT `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
67SELECT `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
68SELECT `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
69SELECT `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
70SELECT `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
71SELECT `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
72SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 47001
73SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 50001
74SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 51001
75SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 52111
76SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 54001
77SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 55001
78SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 56001
79SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 48001
80SELECT `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
81SELECT `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
82SELECT `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
83SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 45 LIMIT 1111
84SELECT `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
85SELECT `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
86SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 32001
87SELECT `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
88SELECT `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
89SELECT `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
90SELECT `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
91SELECT `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
92SELECT `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
93SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 59001
94SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 60111
95SELECT `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
96SELECT `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
97SELECT `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
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` = 6 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC111
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` = 8 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC001
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` = 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
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` = 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
102SELECT `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
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` = 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
104SELECT `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
105SELECT `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
106SELECT `ElusFonction`.`id`, `ElusFonction`.`elus_id`, `ElusFonction`.`fonction_id` FROM `mairie85`.`elus_fonctions` AS `ElusFonction` WHERE `ElusFonction`.`elus_id` IN (3821, 3822, 3823) 15151
107SELECT `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
108SELECT `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
109SELECT `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
110SELECT `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
111SELECT `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
112SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 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
113SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 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
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` = 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
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` = 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
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` = 23 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC001
117SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 24 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC002
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` = 22 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 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
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` = 27 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 28 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 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
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` = 30 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC111
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` = 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
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` = 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
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` = 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
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` = 38 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 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
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` = 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
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` = 40 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC111
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` = 41 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 42 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC001
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` = 43 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC002
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` = 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
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` = 45 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 46 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 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
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` = 49 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 57 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC001
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` = 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
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` = 34 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) 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` = 58 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= '2020-09-20') AND (`Article`.`end_online` >= '2020-09-20')))) ORDER BY `Article`.`position` ASC001
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` = 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
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` = 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
152SELECT `Social`.`id`, `Social`.`name`, `Social`.`url`, `Social`.`url-option-1`, `Social`.`url-option-2`, `Social`.`image` FROM `mairie85`.`socials` AS `Social` WHERE 1 = 1441
153SELECT `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
154SELECT `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
155SELECT `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
156SELECT `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
157SELECT `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
158SELECT `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
159SELECT `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
160SELECT `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
161SELECT `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
162SELECT `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
163SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1839001
164SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 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
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` = 27001
166SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1838001
167SELECT `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
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` = 1834001
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` = 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
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` = 1882001
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` = 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
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` = 1570001
173SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1572001
174SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 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
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` = 1574001
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` = 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
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` = 2018001
178SELECT `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
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` = 1793001
180SELECT `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
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` = 1568001
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` = 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
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` = 29001
184SELECT `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
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` = 1567001
186SELECT `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
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` = 22001
188SELECT `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
189SELECT `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
190SELECT `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
191SELECT `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
192SELECT `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 1112
193SELECT `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
194SELECT `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
195SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo`, `Article`.`slogan`, `Article`.`resume`, `Article`.`texte`, `Article`.`video`, `Article`.`created`, `Article`.`modified`, `Article`.`start_online`, `Article`.`end_online`, `Article`.`online`, `Article`.`new`, `Article`.`datenew`, `Article`.`position`, `Article`.`diaporama_id`, `Article`.`rubriques_site_id`, `Article`.`categorie_id`, `Article`.`site_id`, `Article`.`user_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `Categorie`.`couleur`, `Categorie`.`parent_id`, `Diaporama`.`id`, `Diaporama`.`name`, `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`, `User`.`id`, `User`.`username`, `User`.`group_id`, `User`.`site_id` 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`.`url` = 'article-test' AND `Article`.`site_id` = 382 LIMIT 1111
196SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `Rubrique`.`id` = 15 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
197SELECT `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` = (15) 001
198SELECT COUNT(*) AS `count` 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`.`rubriques_site_id` = 19 AND `Article`.`site_id` = 382111
199SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `Rubrique`.`id` = 5 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
200SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (5) 12121