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

Vie Communale

PRATIQUE

A LA UNE

Nouveautés 2016

Découvrez les nouvelles  fonctionnalités et les  améliorations mises en place sur vos sites internet.

Population : 1315 Montignéens.
Superficie : 18.05 km²
Altitude : De 47 m à 117 m
Arrondissement : Segré
Canton : Le Lion-d'Angers
Communauté des communes : C. A. Angers Loire Métropole

Météo

Dimanche 20 Septembre
25° / 25° 7km/h 53%
25° 7km/h

Communes déléguées

Village Fleuri 3

LA LETTRE D'INFORMATIONS

(default) 346 queries took 335 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 54001
2SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 55001
3SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 56001
4SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 48001
5SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 44 LIMIT 1111
6SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (44) 001
7SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 49001
8SELECT `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
9SELECT `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
10SELECT `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
11SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 32001
12SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 46 LIMIT 1111
13SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (46) 001
14SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 34001
15SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`id` = 47 LIMIT 1111
16SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (47) 001
17SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 58001
18SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 59001
19SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`rubriques_site_id` = 60111
20SELECT `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
21SELECT `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
22SELECT `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
23SELECT `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
24SELECT `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
25SELECT `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
26SELECT `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
27SELECT `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
28SELECT `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
29SELECT `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
30SELECT `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
31SELECT `ElusFonction`.`id`, `ElusFonction`.`elus_id`, `ElusFonction`.`fonction_id` FROM `mairie85`.`elus_fonctions` AS `ElusFonction` WHERE `ElusFonction`.`elus_id` IN (3821, 3822, 3823) 15151
32SELECT `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
33SELECT `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
34SELECT `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
35SELECT `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
36SELECT `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
37SELECT `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
38SELECT `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
39SELECT `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
40SELECT `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
41SELECT `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
42SELECT `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` ASC001
43SELECT `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
44SELECT `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
45SELECT `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
46SELECT `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
47SELECT `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
48SELECT `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
49SELECT `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
50SELECT `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
51SELECT `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
52SELECT `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
53SELECT `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
54SELECT `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
55SELECT `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
56SELECT `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
57SELECT `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
58SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`rubriques_site_id` = 43 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC001
59SELECT `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
60SELECT `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
61SELECT `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
62SELECT `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
63SELECT `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
64SELECT `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
65SELECT `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
66SELECT `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
67SELECT `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
68SELECT `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
69SELECT `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
70SELECT `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
71SELECT `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
72SELECT `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
73SELECT `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
74SELECT `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
75SELECT `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
76SELECT `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
77SELECT `Social`.`id`, `Social`.`name`, `Social`.`url`, `Social`.`url-option-1`, `Social`.`url-option-2`, `Social`.`image` FROM `mairie85`.`socials` AS `Social` WHERE 1 = 1441
78SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 1 LIMIT 1111
79SELECT `Evenement`.`id`, `Evenement`.`name`, `Evenement`.`texte`, `Evenement`.`lieu`, `Evenement`.`organisateur`, `Evenement`.`datedebut`, `Evenement`.`datefin`, `Evenement`.`heuredebut`, `Evenement`.`heurefin`, `Evenement`.`categorie`, `Evenement`.`article_id`, `Evenement`.`commune_id`, `Evenement`.`site_id` FROM `mairie85`.`evenements` AS `Evenement` WHERE `Evenement`.`site_id` = 382 AND `Evenement`.`datedebut` BETWEEN '2020-09-20' AND '2020-12-31' ORDER BY `Evenement`.`datedebut` ASC LIMIT 5001
80SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 2 LIMIT 1111
81SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 3 LIMIT 1111
82SELECT `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` = 3881
83SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 4 LIMIT 1111
84SELECT `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`.`site_id` = 382 AND `Article`.`new` = 'oui' 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` ASC551
85SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`rubrique_id` = 4 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
86SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (4) 221
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`.`rubrique_id` = 4 AND `RubriquesSite`.`site_id` = 382 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` = (4) 221
89SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`rubrique_id` = 43 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
90SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (43) 111
91SELECT `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`.`rubrique_id` = 35 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
92SELECT `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` = (35) 661
93SELECT `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`.`rubrique_id` = 4 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
94SELECT `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` = (4) 221
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`.`rubrique_id` = 4 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
96SELECT `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` = (4) 221
97SELECT `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
98SELECT `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
99SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 7 LIMIT 1111
100SELECT `Diaporama`.`id`, `Diaporama`.`site_id`, `Diaporama`.`user_id`, `Diaporama`.`name`, `Diaporama`.`display`, `Diaporama`.`width`, `Diaporama`.`height`, `Diaporama`.`model`, `Diaporama`.`album`, `Article`.`id`, `Article`.`name`, `Article`.`url`, `Site`.`id`, `Carousel`.`id`, `Carousel`.`step`, `Carousel`.`view`, `Carousel`.`timer`, `Carousel`.`speed`, `Carousel`.`fx1`, `Carousel`.`fx2`, `Carousel`.`fx3`, `Carousel`.`fx4`, `Carousel`.`fx5`, `Carousel`.`dir-in`, `Carousel`.`dir-out`, `Carousel`.`x-slice`, `Carousel`.`y-slice`, `Carousel`.`mode`, `Carousel`.`stripes`, `Carousel`.`orientation`, `Carousel`.`ratio`, `Carousel`.`diaporama_id`, `Carousel`.`site_id` FROM `mairie85`.`diaporamas` AS `Diaporama` LEFT JOIN `mairie85`.`articles` AS `Article` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`sites` AS `Site` ON (`Site`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`carousels` AS `Carousel` ON (`Carousel`.`diaporama_id` = `Diaporama`.`id`) WHERE `Diaporama`.`site_id` = 382 AND `Diaporama`.`album` = 'oui' AND `Diaporama`.`model` = 'Article'331
101SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`diaporama_id` IN (694, 692, 693) ORDER BY `id` ASC 881
102SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12429 LIMIT 1111
103SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12429) 111
104SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12429) 001
105SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12429) 001
106SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12429) 001
107SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12430 LIMIT 1111
108SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12430) 110
109SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12430) 001
110SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12430) 001
111SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12430) 001
112SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12422 LIMIT 1111
113SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12422) 110
114SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12422) 001
115SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12422) 001
116SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12422) 001
117SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12423 LIMIT 1111
118SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12423) 110
119SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12423) 001
120SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12423) 001
121SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12423) 000
122SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12424 LIMIT 1111
123SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12424) 111
124SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12424) 001
125SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12424) 001
126SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12424) 001
127SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12426 LIMIT 1111
128SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12426) 110
129SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12426) 001
130SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12426) 001
131SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12426) 001
132SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12427 LIMIT 1111
133SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12427) 110
134SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12427) 001
135SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12427) 001
136SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12427) 001
137SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`documents` AS `Document` WHERE `Document`.`id` = 12428 LIMIT 1111
138SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie85`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (12428) 110
139SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id` FROM `mairie85`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (12428) 001
140SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie85`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (12428) 001
141SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie85`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (12428) 001
142SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 9 LIMIT 1111
143SELECT `Bulletin`.`id`, `Bulletin`.`numero`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`created`, `Bulletin`.`modified`, `Bulletin`.`document_id`, `Bulletin`.`rubriques_site_id`, `Bulletin`.`site_id`, `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie85`.`bulletins` AS `Bulletin` LEFT JOIN `mairie85`.`documents` AS `Document` ON (`Bulletin`.`document_id` = `Document`.`id`) WHERE `Bulletin`.`site_id` = 382 ORDER BY `Bulletin`.`parution` DESC, `Bulletin`.`numero` DESC LIMIT 1111
144SELECT `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` = 9 AND `RubriquesSite`.`site_id` = 382 LIMIT 1111
145SELECT `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` = (9) 001
146SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 10 LIMIT 1110
147SELECT `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
148SELECT `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
149SELECT `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
150SELECT `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
151SELECT `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
152SELECT `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
153SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 23001
154SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1839001
155SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 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
156SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 27001
157SELECT `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
158SELECT `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
159SELECT `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
160SELECT `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
161SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1882001
162SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 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
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` = 1570001
164SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1572001
165SELECT `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
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` = 1574001
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` = 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
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` = 2018001
169SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 28001
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` = 1793001
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` = 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
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` = 1568001
173SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 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
174SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 29001
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` = 30001
176SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id` FROM `mairie85`.`annuaires` AS `Annuaire` WHERE `Annuaire`.`site_id` = 382 AND `Annuaire`.`categorie_id` = 1567001
177SELECT `Article`.`id`, `Article`.`name`, `Article`.`url` FROM `mairie85`.`articles` AS `Article` LEFT JOIN `mairie85`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie85`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie85`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 382 AND `Article`.`categorie_id` = 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
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` = 22001
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` = 1827001
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` = 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
181SELECT `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
182SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 15 LIMIT 1111
183SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo`, `Article`.`resume`, `Article`.`modified`, `Article`.`rubriques_site_id`, `Article`.`categorie_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`.`site_id` = 382 AND `Article`.`new` = 'focus' AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC LIMIT 1111
184SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 16 LIMIT 1111
185SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo`, `Article`.`resume`, `Article`.`modified`, `Article`.`rubriques_site_id`, `Article`.`categorie_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`.`site_id` = 382 AND `Article`.`new` = 'decouvrir' AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <= curdate()) AND (`Article`.`end_online` >= curdate())))) ORDER BY `Article`.`position` ASC LIMIT 1001
186SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 17 LIMIT 1111
187SELECT `Logo`.`id`, `Logo`.`name`, `Logo`.`img`, `Logo`.`link`, `Logo`.`position`, `Logo`.`module_id`, `Logo`.`site_id` FROM `mairie85`.`logos` AS `Logo` WHERE `Logo`.`site_id` = 382 AND `Logo`.`module_id` = 17 ORDER BY `Logo`.`position` ASC111
188SELECT `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
189SELECT `Comcom`.`id`, `Comcom`.`name`, `Comcom`.`adresse`, `Comcom`.`cp`, `Comcom`.`ville`, `Comcom`.`tel`, `Comcom`.`fax`, `Comcom`.`mail`, `Comcom`.`url`, `Comcom`.`logo`, `Comcom`.`logo-w` FROM `mairie85`.`comcoms` AS `Comcom` WHERE `Comcom`.`id` = 1 LIMIT 1111
190SELECT `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
191SELECT `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
192SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie85`.`modules` AS `Module` WHERE `Module`.`id` = 22 LIMIT 1111
193SELECT `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' AND `Commune`.`id` != 382001
194SELECT `Arrondissement`.`id`, `Arrondissement`.`name` FROM `mairie85`.`arrondissements` AS `Arrondissement` WHERE `Arrondissement`.`id` = 4 LIMIT 1111
195SELECT `Canton`.`id`, `Canton`.`name` FROM `mairie85`.`cantons` AS `Canton` WHERE `Canton`.`id` = 16 LIMIT 1110
196SELECT `Comcom`.`id`, `Comcom`.`name`, `Comcom`.`adresse`, `Comcom`.`cp`, `Comcom`.`ville`, `Comcom`.`tel`, `Comcom`.`fax`, `Comcom`.`mail`, `Comcom`.`url`, `Comcom`.`logo`, `Comcom`.`logo-w` FROM `mairie85`.`comcoms` AS `Comcom` WHERE `Comcom`.`id` = 1 LIMIT 1111
197SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie85`.`rubriques` AS `Rubrique` LEFT JOIN `mairie85`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie85`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 382 AND `Rubrique`.`fonction` = 'localisation' LIMIT 1111
198SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie85`.`rubriques` AS `Children` WHERE `Children`.`parent_id` = (3) 001
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 `RubriquesSite`.`site_id` = 382 AND `RubriquesSite`.`rubrique_id` = 2 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` = (2) 551