Notice (1024): Element Not Found: Elements/menumap.ctp [CORE/Cake/View/View.php, line 420]
Notice (1024): Element Not Found: Elements/logosAd.ctp [CORE/Cake/View/View.php, line 420]

Les tarifs

Communes Tarifs annuels *
Jusqu'à 500 hab 100 €
De 501 à 1 000 hab 150 €
De 1 001 à 3500 hab 200 €
Plus de 3500 hab 300 €
Pour les EPCI 800 €
Pour les Syndicats 400 €

* Coût de maintenance et d'hébergement du site

Notice (1024): Element Not Found: Elements/menuarticles.ctp [CORE/Cake/View/View.php, line 420]
(default) 76 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Site`.`id`, `Site`.`name`, `Site`.`initiales`, `Site`.`logo`, `Site`.`logo-title`, `Site`.`image`, `Site`.`url`, `Site`.`slogan`, `Site`.`texte`, `Site`.`description`, `Site`.`keywords` FROM `icp`.`sites` AS `Site` WHERE 1 = 1 LIMIT 1110
2SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified`, `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id`, `Service`.`id`, `Service`.`initiales`, `Service`.`name`, `Service`.`slug`, `Service`.`slogan`, `Service`.`texte`, `Service`.`logo`, `Service`.`image`, `Service`.`couleur`, `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`articles` AS `Article` LEFT JOIN `icp`.`departements` AS `Departement` ON (`Article`.`departement_id` = `Departement`.`id`) LEFT JOIN `icp`.`services` AS `Service` ON (`Article`.`service_id` = `Service`.`id`) LEFT JOIN `icp`.`styles` AS `Style` ON (`Article`.`style_id` = `Style`.`id`) WHERE `departement_id` IS NULL AND `service_id` IS NULL221
3SELECT `Service`.`id`, `Service`.`initiales`, `Service`.`name`, `Service`.`slug`, `Service`.`slogan`, `Service`.`texte`, `Service`.`logo`, `Service`.`image`, `Service`.`couleur` FROM `icp`.`services` AS `Service` WHERE 1 = 1440
4SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`departement_id` IS NULL AND `Article`.`service_id` IN (2, 3, 4, 1) ORDER BY `position` ASC 10101
5SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id`, `DepartementsService`.`id`, `DepartementsService`.`departement_id`, `DepartementsService`.`service_id`, `DepartementsService`.`texte` FROM `icp`.`departements` AS `Departement` JOIN `icp`.`departements_services` AS `DepartementsService` ON (`DepartementsService`.`service_id` IN (2, 3, 4, 1) AND `DepartementsService`.`departement_id` = `Departement`.`id`) 15150
6SELECT `Service`.`id`, `Service`.`initiales`, `Service`.`name`, `Service`.`slug`, `Service`.`slogan`, `Service`.`texte`, `Service`.`logo`, `Service`.`image`, `Service`.`couleur` FROM `icp`.`services` AS `Service` WHERE 1 = 1440
7SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`departement_id` IS NULL AND `Article`.`service_id` IN (2, 3, 4, 1) ORDER BY `position` ASC 10101
8SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id`, `DepartementsService`.`id`, `DepartementsService`.`departement_id`, `DepartementsService`.`service_id`, `DepartementsService`.`texte` FROM `icp`.`departements` AS `Departement` JOIN `icp`.`departements_services` AS `DepartementsService` ON (`DepartementsService`.`service_id` IN (2, 3, 4, 1) AND `DepartementsService`.`departement_id` = `Departement`.`id`) 15150
9SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
10SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
11SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 2 AND `Article`.`departement_id` = 2000
12SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 1 LIMIT 1110
13SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (1) 220
14SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 2 AND `Article`.`departement_id` = 3000
15SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 1 LIMIT 1110
16SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (1) 220
17SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 2 AND `Article`.`departement_id` = 4000
18SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
19SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
20SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 2 AND `Article`.`departement_id` = 1000
21SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 1 LIMIT 1110
22SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (1) 220
23SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 3 AND `Article`.`departement_id` = 3110
24SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
25SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
26SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 3 AND `Article`.`departement_id` = 2000
27SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 1 LIMIT 1110
28SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (1) 220
29SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 3 AND `Article`.`departement_id` = 4110
30SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
31SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
32SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 3 AND `Article`.`departement_id` = 1000
33SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
34SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
35SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 4 AND `Article`.`departement_id` = 1000
36SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
37SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
38SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 4 AND `Article`.`departement_id` = 2000
39SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 1 LIMIT 1110
40SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (1) 220
41SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 4 AND `Article`.`departement_id` = 3000
42SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 1 LIMIT 1110
43SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (1) 220
44SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 4 AND `Article`.`departement_id` = 4000
45SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
46SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
47SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 1 AND `Article`.`departement_id` = 2000
48SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 1 LIMIT 1110
49SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (1) 220
50SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 1 AND `Article`.`departement_id` = 3000
51SELECT `Correspondant`.`id`, `Correspondant`.`nom`, `Correspondant`.`prenom`, `Correspondant`.`tel`, `Correspondant`.`email`, `Correspondant`.`photo`, `Correspondant`.`coordonnee_id`, `Coordonnee`.`id`, `Coordonnee`.`title`, `Coordonnee`.`comp_title`, `Coordonnee`.`voie`, `Coordonnee`.`comp_voie`, `Coordonnee`.`cp`, `Coordonnee`.`ville`, `Coordonnee`.`tel`, `Coordonnee`.`fax`, `Coordonnee`.`lat`, `Coordonnee`.`long` FROM `icp`.`correspondants` AS `Correspondant` LEFT JOIN `icp`.`coordonnees` AS `Coordonnee` ON (`Correspondant`.`coordonnee_id` = `Coordonnee`.`id`) WHERE `Correspondant`.`id` = 2 LIMIT 1110
52SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id` FROM `icp`.`departements` AS `Departement` WHERE `Departement`.`correspondant_id` = (2) 220
53SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`service_id` = 1 AND `Article`.`departement_id` = 1000
54SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
55SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
56SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
57SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
58SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
59SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
60SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
61SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
62SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
63SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
64SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
65SELECT `Style`.`id`, `Style`.`name`, `Style`.`fx`, `Style`.`speed`, `Style`.`width` FROM `icp`.`styles` AS `Style` WHERE `Style`.`id` = 8 LIMIT 1110
66SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `departement_id` IS NULL AND `service_id` IS NULL220
67SELECT `Service`.`id`, `Service`.`initiales`, `Service`.`name`, `Service`.`slug`, `Service`.`slogan`, `Service`.`texte`, `Service`.`logo`, `Service`.`image`, `Service`.`couleur` FROM `icp`.`services` AS `Service` WHERE 1 = 1440
68SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`departement_id` IS NULL AND `Article`.`service_id` IN (2, 3, 4, 1) ORDER BY `position` ASC 10101
69SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id`, `DepartementsService`.`id`, `DepartementsService`.`departement_id`, `DepartementsService`.`service_id`, `DepartementsService`.`texte` FROM `icp`.`departements` AS `Departement` JOIN `icp`.`departements_services` AS `DepartementsService` ON (`DepartementsService`.`service_id` IN (2, 3, 4, 1) AND `DepartementsService`.`departement_id` = `Departement`.`id`) 15150
70SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`slug` = 'pi-tarifs' LIMIT 1110
71SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`id` = 21 LIMIT 1110
72SELECT `Service`.`id`, `Service`.`initiales`, `Service`.`name`, `Service`.`slug`, `Service`.`slogan`, `Service`.`texte`, `Service`.`logo`, `Service`.`image`, `Service`.`couleur` FROM `icp`.`services` AS `Service` WHERE `Service`.`id` = 2 LIMIT 1110
73SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`departement_id` IS NULL AND `Article`.`service_id` = (2) ORDER BY `position` ASC 330
74SELECT `Departement`.`id`, `Departement`.`numero`, `Departement`.`name`, `Departement`.`couleur`, `Departement`.`slug`, `Departement`.`logo`, `Departement`.`amf`, `Departement`.`correspondant_id`, `DepartementsService`.`id`, `DepartementsService`.`departement_id`, `DepartementsService`.`service_id`, `DepartementsService`.`texte` FROM `icp`.`departements` AS `Departement` JOIN `icp`.`departements_services` AS `DepartementsService` ON (`DepartementsService`.`service_id` = 2 AND `DepartementsService`.`departement_id` = `Departement`.`id`) 440
75SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`departement_id` IS NULL AND `Article`.`service_id` = 2 AND NOT (`Article`.`position` = 0) ORDER BY `position` ASC331
76SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`slug`, `Article`.`contenu`, `Article`.`image`, `Article`.`departement_id`, `Article`.`service_id`, `Article`.`position`, `Article`.`glyphicon`, `Article`.`style_id`, `Article`.`created`, `Article`.`modified` FROM `icp`.`articles` AS `Article` WHERE `Article`.`departement_id` = 0 AND `Article`.`service_id` = 0000