Notice (8): Undefined offset: 5 [APP/Controller/AppController.php, line 704]
Notice (8): Undefined offset: 5 [APP/Controller/AppController.php, line 705]
Notice (8): Undefined offset: 5 [APP/Controller/AppController.php, line 705]
CakePHP: the rapid development php framework: Errors

Fatal Error

Error: Cannot access empty property
File: /home/mairie72/www/app/Controller/AppController.php
Line: 705

Notice: If you want to customize this error message, create app/View/Errors/fatal_error.ctp

(default) 227 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (5274) 000
2SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (5274) 000
3SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4779 LIMIT 1110
4SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4779) 110
5SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4779) 000
6SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4779) 000
7SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4779) 000
8SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4528 LIMIT 1110
9SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4528) 110
10SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4528) 000
11SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4528) 000
12SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4528) 000
13SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4778 LIMIT 1110
14SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4778) 110
15SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4778) 000
16SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4778) 000
17SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4778) 000
18SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4780 LIMIT 1110
19SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4780) 110
20SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4780) 000
21SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4780) 000
22SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4780) 000
23SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4781 LIMIT 1110
24SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4781) 110
25SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4781) 000
26SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4781) 000
27SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4781) 000
28SELECT `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`url`, `Rubrique`.`parent_id`, `Rubrique`.`lft`, `Rubrique`.`rght`, `Rubrique`.`contenu`, `Rubrique`.`contenuorder`, `Rubrique`.`fonction`, `Rubrique`.`fonctiontitle`, `Parent`.`id`, `Parent`.`name`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`contenu`, `Parent`.`contenuorder`, `Parent`.`fonction`, `Parent`.`fonctiontitle`, `RubriquesSite`.`id`, `RubriquesSite`.`rubrique_id`, `RubriquesSite`.`site_id`, `RubriquesSite`.`personnel_id`, `RubriquesSite`.`name`, `RubriquesSite`.`url`, `RubriquesSite`.`resume`, `RubriquesSite`.`texte`, `RubriquesSite`.`logo`, `RubriquesSite`.`couleur`, `RubriquesSite`.`fonction`, `RubriquesSite`.`offline` FROM `mairie72`.`rubriques` AS `Rubrique` LEFT JOIN `mairie72`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 316 AND `RubriquesSite`.`offline` = 'non' ORDER BY `Rubrique`.`lft` ASC14141
29SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie72`.`rubriques` AS `Children` WHERE `Children`.`parent_id` IN (2, 3, 4, 11, 9, 5, 6, 8, 7, 10, 15, 13, 14, 16) 12120
30SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1142000
31SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1143000
32SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1150000
33SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1148000
34SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1145000
35SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1147000
36SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1146000
37SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1154000
38SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1152000
39SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1153000
40SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1155000
41SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1142 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC110
42SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1143 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
43SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1150 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC330
44SELECT `Bulletin`.`id`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`document_id` FROM `mairie72`.`bulletins` AS `Bulletin` LEFT JOIN `mairie72`.`documents` AS `Document` ON (`Bulletin`.`document_id` = `Document`.`id`) WHERE `Bulletin`.`site_id` = 316 AND `Bulletin`.`rubriques_site_id` = 1148 LIMIT 1110
45SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4529 LIMIT 1110
46SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4529) 000
47SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4529) 110
48SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4529) 000
49SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4529) 000
50SELECT `Elu`.`id`, `Elu`.`name`, `Elu`.`url` FROM `mairie72`.`elus` AS `Elu` LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Elu`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Elu`.`site_id` = 316 AND `Elu`.`rubriques_site_id` = 1145330
51SELECT `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`.`site_id` FROM `mairie72`.`personnels` AS `Personnel` WHERE `Personnel`.`elus_id` IN (3783, 3784, 3785) ORDER BY `position` ASC, `fonction_id` ASC 15150
52SELECT `ElusFonction`.`id`, `ElusFonction`.`elus_id`, `ElusFonction`.`fonction_id` FROM `mairie72`.`elus_fonctions` AS `ElusFonction` WHERE `ElusFonction`.`elus_id` IN (3783, 3784, 3785) 15150
53SELECT `Commission`.`id`, `Commission`.`name`, `Commission`.`url` FROM `mairie72`.`commissions` AS `Commission` LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Commission`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Commission`.`site_id` = 316 AND `Commission`.`rubriques_site_id` = 114712120
54SELECT `CommissionsPersonnel`.`id`, `CommissionsPersonnel`.`type`, `CommissionsPersonnel`.`position`, `CommissionsPersonnel`.`personnel_id`, `CommissionsPersonnel`.`commission_id` FROM `mairie72`.`commissions_personnels` AS `CommissionsPersonnel` WHERE `CommissionsPersonnel`.`commission_id` IN (438, 445, 446, 447, 448, 449, 450, 451, 452, 453, 455, 456) ORDER BY `CommissionsPersonnel`.`position` ASC 49491
55SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` LEFT JOIN `mairie72`.`documents` AS `Document` ON (`Comptesrendu`.`document_id` = `Document`.`id`) WHERE `Comptesrendu`.`site_id` = 316 AND `Comptesrendu`.`rubriques_site_id` = 1146 LIMIT 5550
56SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4825 LIMIT 1110
57SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4825) 000
58SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4825) 000
59SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4825) 000
60SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4825) 110
61SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4764 LIMIT 1110
62SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4764) 000
63SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4764) 000
64SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4764) 000
65SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4764) 110
66SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 5073 LIMIT 1110
67SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (5073) 000
68SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (5073) 000
69SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (5073) 000
70SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (5073) 110
71SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 6075 LIMIT 1110
72SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (6075) 000
73SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (6075) 000
74SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (6075) 000
75SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (6075) 110
76SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4826 LIMIT 1110
77SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4826) 000
78SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4826) 000
79SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4826) 000
80SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4826) 110
81SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1154 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
82SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1152 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
83SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1153 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC110
84SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1155 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
85SELECT `Social`.`id`, `Social`.`name`, `Social`.`url`, `Social`.`url-option-1`, `Social`.`url-option-2`, `Social`.`image` FROM `mairie72`.`socials` AS `Social` WHERE 1 = 1440
86SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie72`.`modules` AS `Module` WHERE `Module`.`id` = 1 LIMIT 1110
87SELECT `Evenement`.`id`, `Evenement`.`name`, `Evenement`.`texte`, `Evenement`.`lieu`, `Evenement`.`organisateur`, `Evenement`.`datedebut`, `Evenement`.`datefin`, `Evenement`.`heuredebut`, `Evenement`.`heurefin`, `Evenement`.`article_id`, `Evenement`.`site_id` FROM `mairie72`.`evenements` AS `Evenement` WHERE `Evenement`.`site_id` = 316 AND `Evenement`.`datedebut` BETWEEN '2017-04-24' AND '2017-12-31' ORDER BY `Evenement`.`datedebut` ASC LIMIT 5551
88SELECT `Module`.`id`, `Module`.`name`, `Module`.`title`, `Module`.`contenu`, `Module`.`actif`, `Module`.`type`, `Module`.`mode` FROM `mairie72`.`modules` AS `Module` WHERE `Module`.`id` = 2 LIMIT 1110
89SELECT `Domaine`.`id`, `Domaine`.`name`, `Domaine`.`n_departement`, `Domaine`.`departement`, `Domaine`.`logo-dept`, `Domaine`.`n_region`, `Domaine`.`region`, `Domaine`.`logo-region`, `Domaine`.`actif`, `Domaine`.`email` FROM `mairie72`.`domaines` AS `Domaine` WHERE 1 = 1 LIMIT 1111
90SELECT `Domaine`.`id`, `Domaine`.`name`, `Domaine`.`n_departement`, `Domaine`.`departement`, `Domaine`.`logo-dept`, `Domaine`.`n_region`, `Domaine`.`region`, `Domaine`.`logo-region`, `Domaine`.`actif`, `Domaine`.`email` FROM `mairie72`.`domaines` AS `Domaine` WHERE `Domaine`.`id` = 72 LIMIT 1110
91SELECT `Site`.`id`, `Site`.`name`, `Site`.`url`, `Site`.`sd`, `Site`.`ext`, `Site`.`logo`, `Site`.`logo2`, `Site`.`slogan`, `Site`.`title`, `Site`.`presentation`, `Site`.`meteo`, `Site`.`created`, `Site`.`actif`, `Site`.`commune_id`, `Site`.`diaporama_id`, `Site`.`style_id`, `Site`.`ap_id`, `Commune`.`id`, `Commune`.`name`, `Commune`.`insee`, `Commune`.`arrondissement_id`, `Commune`.`canton_id`, `Commune`.`population`, `Commune`.`habitant`, `Commune`.`superficie`, `Commune`.`altitude`, `Commune`.`latitude`, `Commune`.`longitude`, `Commune`.`comcom_id`, `Style`.`id`, `Style`.`title-site`, `Style`.`title-module`, `Style`.`title-modele`, `Style`.`title-display`, `Style`.`slogan-display`, `Style`.`logo-display`, `Style`.`cartouche-display`, `Style`.`cartouche-position`, `Style`.`menu-display`, `Style`.`bulletin-display`, `Style`.`navigation`, `Style`.`navigation-background`, `Style`.`navigation-font`, `Style`.`font-couleur`, `Style`.`background-couleur`, `Style`.`background-overlay`, `Style`.`background-img`, `Style`.`page-couleur`, `Style`.`home-couleur`, `Style`.`contact-couleur`, `Style`.`left-couleur`, `Style`.`center-couleur`, `Style`.`right-couleur`, `Style`.`footer-couleur`, `Style`.`agenda-couleur`, `Style`.`actualite-couleur`, `Style`.`localisation-couleur`, `Style`.`album-couleur`, `Style`.`annuaire-couleur`, `Style`.`couleur`, `Style`.`template`, `Coordonnee`.`id`, `Coordonnee`.`name`, `Coordonnee`.`adresse`, `Coordonnee`.`cp`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`title-email`, `Coordonnee`.`email`, `Coordonnee`.`site_id`, `Referencement`.`id`, `Referencement`.`description`, `Referencement`.`keywords`, `Referencement`.`actif`, `Referencement`.`site_id` FROM `mairie72`.`sites` AS `Site` LEFT JOIN `mairie72`.`communes` AS `Commune` ON (`Site`.`commune_id` = `Commune`.`id`) LEFT JOIN `mairie72`.`styles` AS `Style` ON (`Site`.`style_id` = `Style`.`id`) LEFT JOIN `mairie72`.`coordonnees` AS `Coordonnee` ON (`Coordonnee`.`site_id` = `Site`.`id`) LEFT JOIN `mairie72`.`referencements` AS `Referencement` ON (`Referencement`.`site_id` = `Site`.`id`) WHERE `Site`.`url` = 'stremydesmonts' LIMIT 1111
92SELECT `Horaire`.`id`, `Horaire`.`am`, `Horaire`.`pm`, `Horaire`.`day`, `Horaire`.`site_id` FROM `mairie72`.`horaires` AS `Horaire` WHERE `Horaire`.`site_id` = (316) ORDER BY FIELD(`Horaire`.`day`, "Lundi", "Mardi", "Mercredi","Jeudi","Vendredi","Samedi") ASC, `Horaire`.`day` ASC 660
93SELECT `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 `mairie72`.`rubriques_sites` AS `RubriquesSite` WHERE `RubriquesSite`.`site_id` = (316) 15151
94SELECT `ModulesSite`.`id`, `ModulesSite`.`site_id`, `ModulesSite`.`module_id`, `ModulesSite`.`actif`, `ModulesSite`.`name`, `ModulesSite`.`name-display`, `ModulesSite`.`display`, `ModulesSite`.`position`, `ModulesSite`.`sites`, `ModulesSite`.`rubriques`, `ModulesSite`.`categories`, `ModulesSite`.`articles`, `ModulesSite`.`elus`, `ModulesSite`.`commissions`, `ModulesSite`.`evenements`, `ModulesSite`.`contacts`, `ModulesSite`.`diaporamas`, `ModulesSite`.`albumPhotos`, `ModulesSite`.`annuaires`, `ModulesSite`.`largeur`, `ModulesSite`.`option_type`, `ModulesSite`.`couleur`, `ModulesSite`.`font-couleur`, `ModulesSite`.`mode-couleur`, `ModulesSite`.`relief`, `ModulesSite`.`option_mode` FROM `mairie72`.`modules_sites` AS `ModulesSite` WHERE `ModulesSite`.`site_id` = (316) ORDER BY `display` ASC, `position` ASC 991
95SELECT `SitesSocial`.`id`, `SitesSocial`.`socials_id`, `SitesSocial`.`texte`, `SitesSocial`.`site_id` FROM `mairie72`.`sites_socials` AS `SitesSocial` WHERE `SitesSocial`.`site_id` = (316) ORDER BY `id` ASC 000
96SELECT `Dialogue`.`id`, `Dialogue`.`display`, `Dialogue`.`modal`, `Dialogue`.`site_id` FROM `mairie72`.`dialogues` AS `Dialogue` WHERE `Dialogue`.`site_id` = (316) 110
97SELECT `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` FROM `mairie72`.`categories` AS `Categorie` WHERE `Categorie`.`site_id` = (316) 16160
98SELECT `Paiement`.`id`, `Paiement`.`objet`, `Paiement`.`numcli`, `Paiement`.`rolrec`, `Paiement`.`roldeb`, `Paiement`.`saisie`, `Paiement`.`type`, `Paiement`.`site_id`, `Paiement`.`actif` FROM `mairie72`.`paiements` AS `Paiement` WHERE `Paiement`.`site_id` = (316) 000
99SELECT `Site`.`id`, `Site`.`name`, `Site`.`url`, `Site`.`sd`, `Site`.`ext`, `Site`.`logo`, `Site`.`logo2`, `Site`.`slogan`, `Site`.`title`, `Site`.`presentation`, `Site`.`meteo`, `Site`.`created`, `Site`.`actif`, `Site`.`commune_id`, `Site`.`diaporama_id`, `Site`.`style_id`, `Site`.`ap_id`, `Commune`.`id`, `Commune`.`name`, `Commune`.`insee`, `Commune`.`arrondissement_id`, `Commune`.`canton_id`, `Commune`.`population`, `Commune`.`habitant`, `Commune`.`superficie`, `Commune`.`altitude`, `Commune`.`latitude`, `Commune`.`longitude`, `Commune`.`comcom_id`, `Style`.`id`, `Style`.`title-site`, `Style`.`title-module`, `Style`.`title-modele`, `Style`.`title-display`, `Style`.`slogan-display`, `Style`.`logo-display`, `Style`.`cartouche-display`, `Style`.`cartouche-position`, `Style`.`menu-display`, `Style`.`bulletin-display`, `Style`.`navigation`, `Style`.`navigation-background`, `Style`.`navigation-font`, `Style`.`font-couleur`, `Style`.`background-couleur`, `Style`.`background-overlay`, `Style`.`background-img`, `Style`.`page-couleur`, `Style`.`home-couleur`, `Style`.`contact-couleur`, `Style`.`left-couleur`, `Style`.`center-couleur`, `Style`.`right-couleur`, `Style`.`footer-couleur`, `Style`.`agenda-couleur`, `Style`.`actualite-couleur`, `Style`.`localisation-couleur`, `Style`.`album-couleur`, `Style`.`annuaire-couleur`, `Style`.`couleur`, `Style`.`template`, `Coordonnee`.`id`, `Coordonnee`.`name`, `Coordonnee`.`adresse`, `Coordonnee`.`cp`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`title-email`, `Coordonnee`.`email`, `Coordonnee`.`site_id`, `Referencement`.`id`, `Referencement`.`description`, `Referencement`.`keywords`, `Referencement`.`actif`, `Referencement`.`site_id` FROM `mairie72`.`sites` AS `Site` LEFT JOIN `mairie72`.`communes` AS `Commune` ON (`Site`.`commune_id` = `Commune`.`id`) LEFT JOIN `mairie72`.`styles` AS `Style` ON (`Site`.`style_id` = `Style`.`id`) LEFT JOIN `mairie72`.`coordonnees` AS `Coordonnee` ON (`Coordonnee`.`site_id` = `Site`.`id`) LEFT JOIN `mairie72`.`referencements` AS `Referencement` ON (`Referencement`.`site_id` = `Site`.`id`) WHERE `Site`.`id` = 316 LIMIT 1111
100SELECT `Horaire`.`id`, `Horaire`.`am`, `Horaire`.`pm`, `Horaire`.`day`, `Horaire`.`site_id` FROM `mairie72`.`horaires` AS `Horaire` WHERE `Horaire`.`site_id` = (316) ORDER BY FIELD(`Horaire`.`day`, "Lundi", "Mardi", "Mercredi","Jeudi","Vendredi","Samedi") ASC, `Horaire`.`day` ASC 660
101SELECT `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 `mairie72`.`rubriques_sites` AS `RubriquesSite` WHERE `RubriquesSite`.`site_id` = (316) 15151
102SELECT `ModulesSite`.`id`, `ModulesSite`.`site_id`, `ModulesSite`.`module_id`, `ModulesSite`.`actif`, `ModulesSite`.`name`, `ModulesSite`.`name-display`, `ModulesSite`.`display`, `ModulesSite`.`position`, `ModulesSite`.`sites`, `ModulesSite`.`rubriques`, `ModulesSite`.`categories`, `ModulesSite`.`articles`, `ModulesSite`.`elus`, `ModulesSite`.`commissions`, `ModulesSite`.`evenements`, `ModulesSite`.`contacts`, `ModulesSite`.`diaporamas`, `ModulesSite`.`albumPhotos`, `ModulesSite`.`annuaires`, `ModulesSite`.`largeur`, `ModulesSite`.`option_type`, `ModulesSite`.`couleur`, `ModulesSite`.`font-couleur`, `ModulesSite`.`mode-couleur`, `ModulesSite`.`relief`, `ModulesSite`.`option_mode` FROM `mairie72`.`modules_sites` AS `ModulesSite` WHERE `ModulesSite`.`site_id` = (316) ORDER BY `display` ASC, `position` ASC 990
103SELECT `SitesSocial`.`id`, `SitesSocial`.`socials_id`, `SitesSocial`.`texte`, `SitesSocial`.`site_id` FROM `mairie72`.`sites_socials` AS `SitesSocial` WHERE `SitesSocial`.`site_id` = (316) ORDER BY `id` ASC 000
104SELECT `Dialogue`.`id`, `Dialogue`.`display`, `Dialogue`.`modal`, `Dialogue`.`site_id` FROM `mairie72`.`dialogues` AS `Dialogue` WHERE `Dialogue`.`site_id` = (316) 110
105SELECT `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` FROM `mairie72`.`categories` AS `Categorie` WHERE `Categorie`.`site_id` = (316) 16160
106SELECT `Paiement`.`id`, `Paiement`.`objet`, `Paiement`.`numcli`, `Paiement`.`rolrec`, `Paiement`.`roldeb`, `Paiement`.`saisie`, `Paiement`.`type`, `Paiement`.`site_id`, `Paiement`.`actif` FROM `mairie72`.`paiements` AS `Paiement` WHERE `Paiement`.`site_id` = (316) 000
107SELECT `Commune`.`id`, `Commune`.`name`, `Commune`.`insee`, `Commune`.`arrondissement_id`, `Commune`.`canton_id`, `Commune`.`population`, `Commune`.`habitant`, `Commune`.`superficie`, `Commune`.`altitude`, `Commune`.`latitude`, `Commune`.`longitude`, `Commune`.`comcom_id` FROM `mairie72`.`communes` AS `Commune` WHERE `Commune`.`id` = 316 LIMIT 1110
108SELECT `Font`.`id`, `Font`.`name`, `Font`.`type`, `Font`.`h1`, `Font`.`h2`, `Font`.`h3` FROM `mairie72`.`fonts` AS `Font` WHERE `Font`.`id` = 31 LIMIT 1110
109SELECT `Font`.`id`, `Font`.`name`, `Font`.`type`, `Font`.`h1`, `Font`.`h2`, `Font`.`h3` FROM `mairie72`.`fonts` AS `Font` WHERE `Font`.`id` = 31 LIMIT 1110
110SELECT `Font`.`id`, `Font`.`name`, `Font`.`type`, `Font`.`h1`, `Font`.`h2`, `Font`.`h3` FROM `mairie72`.`fonts` AS `Font` WHERE `Font`.`id` = 1 LIMIT 1110
111SELECT `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 `mairie72`.`diaporamas` AS `Diaporama` LEFT JOIN `mairie72`.`articles` AS `Article` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`sites` AS `Site` ON (`Site`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`carousels` AS `Carousel` ON (`Carousel`.`diaporama_id` = `Diaporama`.`id`) WHERE `Diaporama`.`id` = 316 LIMIT 1110
112SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`diaporama_id` = (316) ORDER BY RAND() ASC 660
113SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4779 LIMIT 1110
114SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4779) 110
115SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4779) 000
116SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4779) 000
117SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4779) 000
118SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4528 LIMIT 1110
119SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4528) 110
120SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4528) 000
121SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4528) 000
122SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4528) 000
123SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4780 LIMIT 1110
124SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4780) 110
125SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4780) 000
126SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4780) 000
127SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4780) 000
128SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4778 LIMIT 1110
129SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4778) 110
130SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4778) 000
131SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4778) 000
132SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4778) 000
133SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4781 LIMIT 1110
134SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4781) 110
135SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4781) 000
136SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4781) 000
137SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4781) 000
138SELECT `Document`.`id`, `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`site_id`, `Document`.`user_id`, `Document`.`created`, `Document`.`modified` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 5274 LIMIT 1110
139SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (5274) 110
140SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (5274) 000
141SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (5274) 000
142SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (5274) 000
143SELECT `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 `mairie72`.`rubriques` AS `Rubrique` LEFT JOIN `mairie72`.`rubriques` AS `Parent` ON (`Rubrique`.`parent_id` = `Parent`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`RubriquesSite`.`rubrique_id` = `Rubrique`.`id`) WHERE `RubriquesSite`.`site_id` = 316 AND `RubriquesSite`.`offline` = 'non' ORDER BY `Rubrique`.`lft` ASC14141
144SELECT `Children`.`id`, `Children`.`name`, `Children`.`url`, `Children`.`parent_id`, `Children`.`lft`, `Children`.`rght`, `Children`.`contenu`, `Children`.`contenuorder`, `Children`.`fonction`, `Children`.`fonctiontitle` FROM `mairie72`.`rubriques` AS `Children` WHERE `Children`.`parent_id` IN (2, 3, 4, 11, 9, 5, 6, 8, 7, 10, 15, 13, 14, 16) 12120
145SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1142000
146SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1143000
147SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1150000
148SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1148000
149SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1145000
150SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1147000
151SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1146000
152SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1154000
153SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1152000
154SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1153000
155SELECT `Annuaire`.`id`, `Annuaire`.`name`, `Annuaire`.`url`, `Annuaire`.`texte`, `Annuaire`.`logo`, `Annuaire`.`rubriques_site_id`, `Annuaire`.`categorie_id`, `Annuaire`.`site_id`, `Categorie`.`id`, `Categorie`.`name`, `Categorie`.`url`, `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 `mairie72`.`annuaires` AS `Annuaire` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Annuaire`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Annuaire`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Annuaire`.`site_id` = 316 AND `Annuaire`.`rubriques_site_id` = 1155000
156SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1142 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC110
157SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1143 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
158SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1150 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC331
159SELECT `Bulletin`.`id`, `Bulletin`.`name`, `Bulletin`.`logo`, `Bulletin`.`parution`, `Bulletin`.`document_id` FROM `mairie72`.`bulletins` AS `Bulletin` LEFT JOIN `mairie72`.`documents` AS `Document` ON (`Bulletin`.`document_id` = `Document`.`id`) WHERE `Bulletin`.`site_id` = 316 AND `Bulletin`.`rubriques_site_id` = 1148 LIMIT 1110
160SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4529 LIMIT 1110
161SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4529) 000
162SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4529) 110
163SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4529) 000
164SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4529) 000
165SELECT `Elu`.`id`, `Elu`.`name`, `Elu`.`url` FROM `mairie72`.`elus` AS `Elu` LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Elu`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Elu`.`site_id` = 316 AND `Elu`.`rubriques_site_id` = 1145330
166SELECT `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`.`site_id` FROM `mairie72`.`personnels` AS `Personnel` WHERE `Personnel`.`elus_id` IN (3783, 3784, 3785) ORDER BY `position` ASC, `fonction_id` ASC 15150
167SELECT `ElusFonction`.`id`, `ElusFonction`.`elus_id`, `ElusFonction`.`fonction_id` FROM `mairie72`.`elus_fonctions` AS `ElusFonction` WHERE `ElusFonction`.`elus_id` IN (3783, 3784, 3785) 15150
168SELECT `Commission`.`id`, `Commission`.`name`, `Commission`.`url` FROM `mairie72`.`commissions` AS `Commission` LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Commission`.`rubriques_site_id` = `RubriquesSite`.`id`) WHERE `Commission`.`site_id` = 316 AND `Commission`.`rubriques_site_id` = 114712120
169SELECT `CommissionsPersonnel`.`id`, `CommissionsPersonnel`.`type`, `CommissionsPersonnel`.`position`, `CommissionsPersonnel`.`personnel_id`, `CommissionsPersonnel`.`commission_id` FROM `mairie72`.`commissions_personnels` AS `CommissionsPersonnel` WHERE `CommissionsPersonnel`.`commission_id` IN (438, 445, 446, 447, 448, 449, 450, 451, 452, 453, 455, 456) ORDER BY `CommissionsPersonnel`.`position` ASC 49491
170SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` LEFT JOIN `mairie72`.`documents` AS `Document` ON (`Comptesrendu`.`document_id` = `Document`.`id`) WHERE `Comptesrendu`.`site_id` = 316 AND `Comptesrendu`.`rubriques_site_id` = 1146 LIMIT 5550
171SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4825 LIMIT 1110
172SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4825) 000
173SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4825) 000
174SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4825) 000
175SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4825) 110
176SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4764 LIMIT 1110
177SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4764) 000
178SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4764) 000
179SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4764) 000
180SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4764) 110
181SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 5073 LIMIT 1110
182SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (5073) 000
183SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (5073) 000
184SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (5073) 000
185SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (5073) 110
186SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 6075 LIMIT 1110
187SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (6075) 000
188SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (6075) 000
189SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (6075) 000
190SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (6075) 110
191SELECT `Document`.`name`, `Document`.`title`, `Document`.`url`, `Document`.`type`, `Document`.`id` FROM `mairie72`.`documents` AS `Document` WHERE `Document`.`id` = 4826 LIMIT 1110
192SELECT `DiaporamasDocument`.`id`, `DiaporamasDocument`.`diaporama_id`, `DiaporamasDocument`.`document_id` FROM `mairie72`.`diaporamas_documents` AS `DiaporamasDocument` WHERE `DiaporamasDocument`.`document_id` = (4826) 000
193SELECT `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 `mairie72`.`bulletins` AS `Bulletin` WHERE `Bulletin`.`document_id` = (4826) 000
194SELECT `Deliberation`.`id`, `Deliberation`.`name`, `Deliberation`.`conseil`, `Deliberation`.`created`, `Deliberation`.`document_id`, `Deliberation`.`rubriques_site_id`, `Deliberation`.`site_id` FROM `mairie72`.`deliberations` AS `Deliberation` WHERE `Deliberation`.`document_id` = (4826) 000
195SELECT `Comptesrendu`.`id`, `Comptesrendu`.`name`, `Comptesrendu`.`conseil`, `Comptesrendu`.`document_id`, `Comptesrendu`.`created`, `Comptesrendu`.`rubriques_site_id`, `Comptesrendu`.`site_id` FROM `mairie72`.`comptesrendus` AS `Comptesrendu` WHERE `Comptesrendu`.`document_id` = (4826) 110
196SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1154 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
197SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1152 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
198SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1153 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC110
199SELECT `Article`.`id`, `Article`.`name`, `Article`.`url`, `Article`.`logo` FROM `mairie72`.`articles` AS `Article` LEFT JOIN `mairie72`.`categories` AS `Categorie` ON (`Article`.`categorie_id` = `Categorie`.`id`) LEFT JOIN `mairie72`.`diaporamas` AS `Diaporama` ON (`Article`.`diaporama_id` = `Diaporama`.`id`) LEFT JOIN `mairie72`.`rubriques_sites` AS `RubriquesSite` ON (`Article`.`rubriques_site_id` = `RubriquesSite`.`id`) LEFT JOIN `mairie72`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`site_id` = 316 AND `Article`.`rubriques_site_id` = 1155 AND ((`Article`.`online` = 'oui') OR (((`Article`.`online` = 'période') AND (`Article`.`start_online` <=curdate()) AND (`Article`.`end_online` >=curdate())))) ORDER BY `Article`.`position` ASC000
200SELECT `Social`.`id`, `Social`.`name`, `Social`.`url`, `Social`.`url-option-1`, `Social`.`url-option-2`, `Social`.`image` FROM `mairie72`.`socials` AS `Social` WHERE 1 = 1440