The Council of European Municipalities and Regions (CEMR) represents the interests of European local authorities and their associations in more than 40 countries. It promotes citizenship and exchange between elected representatives.
 


Calendar
  • 30 Oct from 30.10
    to 31.10

    Bologna OLA-CEMR Symposium: "Simplification of local administration in Europe – ...

  •   Date to be determined

    Brussels Focus Group on State Aid (tbc)

  •   Date to be determined

    Brussels Thematic Network on public procurement and concessions (tbc)

X
L'Europe
locale et régionale
CEMR in figures
 
  • 57 member associations
  • 150 000 local governments
  • 40 countries
  • 60 years of practice

Simplification of local administration in Europe: levels and dimensions
Développez vos ventes : conseil marketing Organisation - Audit, conseil, coaching, formation référencement sur Google de site Internet - Audit, conseil, coaching, formation Référencement naturel sur Google, SEO
array(8) { ["plugin"]=> NULL ["controller"]=> string(9) "htmlzones" ["action"]=> string(4) "home" ["named"]=> array(0) { } ["pass"]=> array(0) { } ["language"]=> string(2) "en" ["isAjax"]=> bool(false) ["models"]=> array(37) { ["Htmlzone"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(8) "Htmlzone" } ["Pay"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(3) "Pay" } ["Actualite"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "Actualite" } ["Papier"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(6) "Papier" } ["Activite"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(8) "Activite" } ["User"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(4) "User" } ["I18nModel"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Article"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(7) "Article" } ["Langue"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(6) "Langue" } ["Piecesjointe"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(12) "Piecesjointe" } ["Partenaire"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(10) "Partenaire" } ["Publicite"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "Publicite" } ["Calendrier"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(10) "Calendrier" } ["Permission"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(10) "Permission" } ["Aro"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(3) "Aro" } ["Aco"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(3) "Aco" } ["Equipe"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(6) "Equipe" } ["Menu"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(4) "Menu" } ["Titre"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Slug"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Page"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(7) "Article" } ["ArticlesMenu"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(8) "AppModel" } ["Meta"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(4) "Meta" } ["Image"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(5) "Image" } ["Title"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Description"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Nom"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Texte"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Calendrierevent"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(15) "Calendrierevent" } ["Place"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(5) "Place" } ["Document"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Lien"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Ville"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Adresse"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(9) "I18nModel" } ["Activites"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(8) "Activite" } ["ActivitesCalendrierevent"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(8) "AppModel" } ["Domaine"]=> array(2) { ["plugin"]=> NULL ["className"]=> string(7) "Domaine" } } }
(default) 32 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Menu`.`id`, `Menu`.`article_id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`titre`, `Menu`.`filename`, `Menu`.`alt`, `Menu`.`controller`, `Menu`.`view`, `Menu`.`template`, `Menu`.`params`, `Menu`.`slug`, `Menu`.`published`, `Menu`.`link`, `Menu`.`linktochildren`, `Menu`.`equipe_id`, `Menu`.`created`, `Menu`.`modified`, (`I18n__Titre`.`content`) AS `Menu__i18n_Titre`, (`I18n__Slug`.`content`) AS `Menu__i18n_Slug`, `Article`.`id`, `Article`.`meta_id`, `Article`.`titre`, `Article`.`texte`, `Article`.`resume`, `Article`.`texte_galerie`, `Article`.`published`, `Article`.`commentaire`, `Article`.`miniword`, `Article`.`created`, `Article`.`modified`, `Equipe`.`id`, `Equipe`.`nom`, `Equipe`.`prenom`, `Equipe`.`titre`, `Equipe`.`description`, `Equipe`.`bio`, `Equipe`.`photo`, `Equipe`.`pay_id`, `Equipe`.`email`, `Equipe`.`skype`, `Equipe`.`tel_1`, `Equipe`.`tel_2`, `Equipe`.`resp_comm`, `Equipe`.`attach_press`, `Equipe`.`ordre`, `Equipe`.`updated`, `Equipe`.`created` FROM `ccre3`.`menus` AS `Menu` INNER JOIN `ccre3`.`i18n` AS `I18n__Titre` ON (`Menu`.`id` = `I18n__Titre`.`foreign_key` AND `I18n__Titre`.`model` = 'Menu' AND `I18n__Titre`.`field` = 'titre' AND `I18n__Titre`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Slug` ON (`Menu`.`id` = `I18n__Slug`.`foreign_key` AND `I18n__Slug`.`model` = 'Menu' AND `I18n__Slug`.`field` = 'slug' AND `I18n__Slug`.`locale` = 'eng') LEFT JOIN `ccre3`.`articles` AS `Article` ON (`Menu`.`article_id` = `Article`.`id`) LEFT JOIN `ccre3`.`equipes` AS `Equipe` ON (`Menu`.`equipe_id` = `Equipe`.`id`) WHERE `controller` = 'htmlzones' AND `view` = 'home' LIMIT 1110
2SELECT `Titre`.`id`, `Titre`.`locale`, `Titre`.`model`, `Titre`.`foreign_key`, `Titre`.`field`, `Titre`.`content` FROM `ccre3`.`i18n` AS `Titre` WHERE `model` = 'Menu' AND `field` = 'titre' AND `Titre`.`foreign_key` = (2) 220
3SELECT `Slug`.`id`, `Slug`.`locale`, `Slug`.`model`, `Slug`.`foreign_key`, `Slug`.`field`, `Slug`.`content` FROM `ccre3`.`i18n` AS `Slug` WHERE `model` = 'Menu' AND `field` = 'slug' AND `Slug`.`foreign_key` = (2) 220
4SELECT `Page`.`id`, `Page`.`meta_id`, `Page`.`titre`, `Page`.`texte`, `Page`.`resume`, `Page`.`texte_galerie`, `Page`.`published`, `Page`.`commentaire`, `Page`.`miniword`, `Page`.`created`, `Page`.`modified`, `ArticlesMenu`.`id`, `ArticlesMenu`.`article_id`, `ArticlesMenu`.`menu_id`, `ArticlesMenu`.`ordre` FROM `ccre3`.`articles` AS `Page` JOIN `ccre3`.`articles_menus` AS `ArticlesMenu` ON (`ArticlesMenu`.`menu_id` = 2 AND `ArticlesMenu`.`article_id` = `Page`.`id`) 000
5SELECT `Meta`.`id`, `Meta`.`slug`, `Meta`.`title`, `Meta`.`description`, `Meta`.`robots`, (`I18n__Slug`.`content`) AS `Meta__i18n_Slug`, (`I18n__Title`.`content`) AS `Meta__i18n_Title`, (`I18n__Description`.`content`) AS `Meta__i18n_Description`, `Article`.`id`, `Article`.`meta_id`, `Article`.`titre`, `Article`.`texte`, `Article`.`resume`, `Article`.`texte_galerie`, `Article`.`published`, `Article`.`commentaire`, `Article`.`miniword`, `Article`.`created`, `Article`.`modified`, `Image`.`id`, `Image`.`article_id`, `Image`.`meta_id`, `Image`.`type`, `Image`.`filename`, `Image`.`titre`, `Image`.`texte`, `Image`.`ordre`, `Image`.`published`, `Image`.`created`, `Image`.`modified` FROM `ccre3`.`metas` AS `Meta` INNER JOIN `ccre3`.`i18n` AS `I18n__Slug` ON (`Meta`.`id` = `I18n__Slug`.`foreign_key` AND `I18n__Slug`.`model` = 'Meta' AND `I18n__Slug`.`field` = 'slug' AND `I18n__Slug`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Title` ON (`Meta`.`id` = `I18n__Title`.`foreign_key` AND `I18n__Title`.`model` = 'Meta' AND `I18n__Title`.`field` = 'title' AND `I18n__Title`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Description` ON (`Meta`.`id` = `I18n__Description`.`foreign_key` AND `I18n__Description`.`model` = 'Meta' AND `I18n__Description`.`field` = 'description' AND `I18n__Description`.`locale` = 'eng') LEFT JOIN `ccre3`.`articles` AS `Article` ON (`Article`.`meta_id` = `Meta`.`id`) LEFT JOIN `ccre3`.`images` AS `Image` ON (`Image`.`meta_id` = `Meta`.`id`) WHERE `Meta`.`id` = 3 LIMIT 1110
6SELECT `Slug`.`id`, `Slug`.`locale`, `Slug`.`model`, `Slug`.`foreign_key`, `Slug`.`field`, `Slug`.`content` FROM `ccre3`.`i18n` AS `Slug` WHERE `model` = 'Meta' AND `field` = 'slug' AND `Slug`.`foreign_key` = (3) 220
7SELECT `Title`.`id`, `Title`.`locale`, `Title`.`model`, `Title`.`foreign_key`, `Title`.`field`, `Title`.`content` FROM `ccre3`.`i18n` AS `Title` WHERE `model` = 'Meta' AND `field` = 'title' AND `Title`.`foreign_key` = (3) 220
8SELECT `Description`.`id`, `Description`.`locale`, `Description`.`model`, `Description`.`foreign_key`, `Description`.`field`, `Description`.`content` FROM `ccre3`.`i18n` AS `Description` WHERE `model` = 'Meta' AND `field` = 'description' AND `Description`.`foreign_key` = (3) 220
9SELECT `Menu`.`lft`, `Menu`.`rght` FROM `ccre3`.`menus` AS `Menu` WHERE `Menu`.`id` = 2 LIMIT 1110
10SELECT `Menu`.`id`, `Menu`.`article_id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`titre`, `Menu`.`filename`, `Menu`.`alt`, `Menu`.`controller`, `Menu`.`view`, `Menu`.`template`, `Menu`.`params`, `Menu`.`slug`, `Menu`.`published`, `Menu`.`link`, `Menu`.`linktochildren`, `Menu`.`equipe_id`, `Menu`.`created`, `Menu`.`modified`, (`I18n__Titre`.`content`) AS `Menu__i18n_Titre`, (`I18n__Slug`.`content`) AS `Menu__i18n_Slug` FROM `ccre3`.`menus` AS `Menu` INNER JOIN `ccre3`.`i18n` AS `I18n__Titre` ON (`Menu`.`id` = `I18n__Titre`.`foreign_key` AND `I18n__Titre`.`model` = 'Menu' AND `I18n__Titre`.`field` = 'titre' AND `I18n__Titre`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Slug` ON (`Menu`.`id` = `I18n__Slug`.`foreign_key` AND `I18n__Slug`.`model` = 'Menu' AND `I18n__Slug`.`field` = 'slug' AND `I18n__Slug`.`locale` = 'eng') WHERE 1 = 1 AND `Menu`.`lft` <= 9 AND `Menu`.`rght` >= 58 ORDER BY `Menu`.`lft` asc110
11SELECT `Menu`.`id`, `Menu`.`article_id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`titre`, `Menu`.`filename`, `Menu`.`alt`, `Menu`.`controller`, `Menu`.`view`, `Menu`.`template`, `Menu`.`params`, `Menu`.`slug`, `Menu`.`published`, `Menu`.`link`, `Menu`.`linktochildren`, `Menu`.`equipe_id`, `Menu`.`created`, `Menu`.`modified`, (`I18n__Titre`.`content`) AS `Menu__i18n_Titre`, (`I18n__Slug`.`content`) AS `Menu__i18n_Slug` FROM `ccre3`.`menus` AS `Menu` INNER JOIN `ccre3`.`i18n` AS `I18n__Titre` ON (`Menu`.`id` = `I18n__Titre`.`foreign_key` AND `I18n__Titre`.`model` = 'Menu' AND `I18n__Titre`.`field` = 'titre' AND `I18n__Titre`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Slug` ON (`Menu`.`id` = `I18n__Slug`.`foreign_key` AND `I18n__Slug`.`model` = 'Menu' AND `I18n__Slug`.`field` = 'slug' AND `I18n__Slug`.`locale` = 'eng') WHERE `Menu`.`id` = 2 LIMIT 1110
12SELECT `Htmlzone`.`id`, `Htmlzone`.`order`, `Htmlzone`.`nom`, `Htmlzone`.`titre`, `Htmlzone`.`texte`, `Htmlzone`.`resume`, `Htmlzone`.`filename`, `Htmlzone`.`created`, `Htmlzone`.`updated`, (`I18n__Nom`.`content`) AS `Htmlzone__i18n_Nom`, (`I18n__Titre`.`content`) AS `Htmlzone__i18n_Titre`, (`I18n__Texte`.`content`) AS `Htmlzone__i18n_Texte` FROM `ccre3`.`htmlzones` AS `Htmlzone` INNER JOIN `ccre3`.`i18n` AS `I18n__Nom` ON (`Htmlzone`.`id` = `I18n__Nom`.`foreign_key` AND `I18n__Nom`.`model` = 'Htmlzone' AND `I18n__Nom`.`field` = 'nom' AND `I18n__Nom`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Titre` ON (`Htmlzone`.`id` = `I18n__Titre`.`foreign_key` AND `I18n__Titre`.`model` = 'Htmlzone' AND `I18n__Titre`.`field` = 'titre' AND `I18n__Titre`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Texte` ON (`Htmlzone`.`id` = `I18n__Texte`.`foreign_key` AND `I18n__Texte`.`model` = 'Htmlzone' AND `I18n__Texte`.`field` = 'texte' AND `I18n__Texte`.`locale` = 'eng') WHERE `Htmlzone`.`id` = 1 LIMIT 1110
13SELECT `Nom`.`id`, `Nom`.`locale`, `Nom`.`model`, `Nom`.`foreign_key`, `Nom`.`field`, `Nom`.`content` FROM `ccre3`.`i18n` AS `Nom` WHERE `model` = 'Htmlzone' AND `field` = 'nom' AND `Nom`.`foreign_key` = (1) 220
14SELECT `Titre`.`id`, `Titre`.`locale`, `Titre`.`model`, `Titre`.`foreign_key`, `Titre`.`field`, `Titre`.`content` FROM `ccre3`.`i18n` AS `Titre` WHERE `model` = 'Htmlzone' AND `field` = 'titre' AND `Titre`.`foreign_key` = (1) 220
15SELECT `Texte`.`id`, `Texte`.`locale`, `Texte`.`model`, `Texte`.`foreign_key`, `Texte`.`field`, `Texte`.`content` FROM `ccre3`.`i18n` AS `Texte` WHERE `model` = 'Htmlzone' AND `field` = 'texte' AND `Texte`.`foreign_key` = (1) 220
16SELECT `Actualite`.`id`, `Actualite`.`activite_id`, `Actualite`.`filename`, `Actualite`.`debut`, (`I18n__titre`.`content`) AS `Actualite__i18n_titre`, (`I18n__titre_long`.`content`) AS `Actualite__i18n_titre_long` FROM `ccre3`.`actualites` AS `Actualite` INNER JOIN `ccre3`.`i18n` AS `I18n__titre` ON (`Actualite`.`id` = `I18n__titre`.`foreign_key` AND `I18n__titre`.`model` = 'Actualite' AND `I18n__titre`.`field` = 'titre' AND `I18n__titre`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__titre_long` ON (`Actualite`.`id` = `I18n__titre_long`.`foreign_key` AND `I18n__titre_long`.`model` = 'Actualite' AND `I18n__titre_long`.`field` = 'titre_long' AND `I18n__titre_long`.`locale` = 'eng') WHERE `Actualite`.`type` IN (0, 3) AND `Actualite`.`published` = '1' ORDER BY `Actualite`.`debut` DESC, `Actualite`.`created` DESC LIMIT 3330
17SELECT `Actualite`.`id`, `Actualite`.`tmpid`, `Actualite`.`titre`, `Actualite`.`titre_long`, `Actualite`.`texte`, `Actualite`.`filename`, `Actualite`.`contexte`, `Actualite`.`debut`, `Actualite`.`fin`, `Actualite`.`activite_id`, `Actualite`.`type`, `Actualite`.`published`, `Actualite`.`updated`, `Actualite`.`created`, (YEAR(`Actualite`.`debut`)) AS `Actualite__myYear`, (`I18n__Titre`.`content`) AS `Actualite__i18n_Titre`, (`I18n__Titrelong`.`content`) AS `Actualite__i18n_Titrelong`, (`I18n__Texte`.`content`) AS `Actualite__i18n_Texte`, (`I18n__Contexte`.`content`) AS `Actualite__i18n_Contexte` FROM `ccre3`.`actualites` AS `Actualite` INNER JOIN `ccre3`.`i18n` AS `I18n__Titre` ON (`Actualite`.`id` = `I18n__Titre`.`foreign_key` AND `I18n__Titre`.`model` = 'Actualite' AND `I18n__Titre`.`field` = 'titre' AND `I18n__Titre`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Titrelong` ON (`Actualite`.`id` = `I18n__Titrelong`.`foreign_key` AND `I18n__Titrelong`.`model` = 'Actualite' AND `I18n__Titrelong`.`field` = 'titre_long' AND `I18n__Titrelong`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Texte` ON (`Actualite`.`id` = `I18n__Texte`.`foreign_key` AND `I18n__Texte`.`model` = 'Actualite' AND `I18n__Texte`.`field` = 'texte' AND `I18n__Texte`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Contexte` ON (`Actualite`.`id` = `I18n__Contexte`.`foreign_key` AND `I18n__Contexte`.`model` = 'Actualite' AND `I18n__Contexte`.`field` = 'contexte' AND `I18n__Contexte`.`locale` = 'eng') WHERE `Actualite`.`type` = 1 AND `Actualite`.`published` = '1' ORDER BY `Actualite`.`debut` DESC, `Actualite`.`created` DESC LIMIT 3330
18SELECT `Publicite`.`id`, `Publicite`.`filename`, `Publicite`.`texte`, `Publicite`.`url`, `Publicite`.`model`, `Publicite`.`foreign_key`, `Publicite`.`langue_id`, `Publicite`.`ordre`, `Publicite`.`created`, `Publicite`.`updated` FROM `ccre3`.`publicites` AS `Publicite` JOIN `ccre3`.`langues` AS `Langue` ON (`Langue`.`abreviation` = 'en' AND `Langue`.`id` = `Publicite`.`langue_id`) WHERE `Publicite`.`model` = 'Home' AND `Publicite`.`foreign_key` = 0110
19SELECT `Calendrierevent`.`id`, `Calendrierevent`.`debut`, `Calendrierevent`.`fin`, `Calendrierevent`.`titre`, `Calendrierevent`.`texte`, `Calendrierevent`.`prive`, `Calendrierevent`.`journeecomplete`, `Calendrierevent`.`adresse`, `Calendrierevent`.`gmap`, `Calendrierevent`.`photo`, `Calendrierevent`.`document`, `Calendrierevent`.`lien`, `Calendrierevent`.`page_dediee`, `Calendrierevent`.`ville`, `Calendrierevent`.`descritpion`, `Calendrierevent`.`activite_id`, `Calendrierevent`.`calendrier_id`, `Calendrierevent`.`mois`, `Calendrierevent`.`is_ccre_event`, `Calendrierevent`.`is_to_be_confirmed`, `Calendrierevent`.`is_on_invitation`, `Calendrierevent`.`is_ccre_coorganization`, `Calendrierevent`.`place_id`, `Calendrierevent`.`updated`, `Calendrierevent`.`created`, (`I18n__Titre`.`content`) AS `Calendrierevent__i18n_Titre`, (`I18n__Texte`.`content`) AS `Calendrierevent__i18n_Texte`, (`I18n__Description`.`content`) AS `Calendrierevent__i18n_Description`, (`I18n__Document`.`content`) AS `Calendrierevent__i18n_Document`, (`I18n__Lien`.`content`) AS `Calendrierevent__i18n_Lien`, (`I18n__Ville`.`content`) AS `Calendrierevent__i18n_Ville`, (`I18n__Adresse`.`content`) AS `Calendrierevent__i18n_Adresse`, `Activite`.`id`, `Activite`.`nom`, `Activite`.`texte`, `Activite`.`domaine_id`, `Activite`.`projet`, `Activite`.`miniword`, `Activite`.`published`, `Activite`.`ordre`, `Activite`.`updated`, `Activite`.`created`, `Calendrier`.`id`, `Calendrier`.`nom`, `Calendrier`.`prive`, `Calendrier`.`updated`, `Calendrier`.`created`, `Place`.`id`, `Place`.`nom`, `Place`.`adresse`, `Place`.`gmap` FROM `ccre3`.`calendrierevents` AS `Calendrierevent` INNER JOIN `ccre3`.`i18n` AS `I18n__Titre` ON (`Calendrierevent`.`id` = `I18n__Titre`.`foreign_key` AND `I18n__Titre`.`model` = 'Calendrierevent' AND `I18n__Titre`.`field` = 'titre' AND `I18n__Titre`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Texte` ON (`Calendrierevent`.`id` = `I18n__Texte`.`foreign_key` AND `I18n__Texte`.`model` = 'Calendrierevent' AND `I18n__Texte`.`field` = 'texte' AND `I18n__Texte`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Description` ON (`Calendrierevent`.`id` = `I18n__Description`.`foreign_key` AND `I18n__Description`.`model` = 'Calendrierevent' AND `I18n__Description`.`field` = 'description' AND `I18n__Description`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Document` ON (`Calendrierevent`.`id` = `I18n__Document`.`foreign_key` AND `I18n__Document`.`model` = 'Calendrierevent' AND `I18n__Document`.`field` = 'document' AND `I18n__Document`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Lien` ON (`Calendrierevent`.`id` = `I18n__Lien`.`foreign_key` AND `I18n__Lien`.`model` = 'Calendrierevent' AND `I18n__Lien`.`field` = 'lien' AND `I18n__Lien`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Ville` ON (`Calendrierevent`.`id` = `I18n__Ville`.`foreign_key` AND `I18n__Ville`.`model` = 'Calendrierevent' AND `I18n__Ville`.`field` = 'ville' AND `I18n__Ville`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Adresse` ON (`Calendrierevent`.`id` = `I18n__Adresse`.`foreign_key` AND `I18n__Adresse`.`model` = 'Calendrierevent' AND `I18n__Adresse`.`field` = 'adresse' AND `I18n__Adresse`.`locale` = 'eng') LEFT JOIN `ccre3`.`activites` AS `Activite` ON (`Calendrierevent`.`activite_id` = `Activite`.`id`) LEFT JOIN `ccre3`.`calendriers` AS `Calendrier` ON (`Calendrierevent`.`calendrier_id` = `Calendrier`.`id`) LEFT JOIN `ccre3`.`places` AS `Place` ON (`Calendrierevent`.`place_id` = `Place`.`id`) WHERE `Calendrierevent`.`debut` >= '2014-10-25 00:00:00' AND `Calendrierevent`.`prive` = '0' AND `Calendrier`.`prive` = '0' ORDER BY `Calendrierevent`.`debut` ASC, `Calendrierevent`.`id` ASC LIMIT 3330
20SELECT `Titre`.`id`, `Titre`.`locale`, `Titre`.`model`, `Titre`.`foreign_key`, `Titre`.`field`, `Titre`.`content` FROM `ccre3`.`i18n` AS `Titre` WHERE `model` = 'Calendrierevent' AND `field` = 'titre' AND `Titre`.`foreign_key` IN (219, 167, 168) 660
21SELECT `Texte`.`id`, `Texte`.`locale`, `Texte`.`model`, `Texte`.`foreign_key`, `Texte`.`field`, `Texte`.`content` FROM `ccre3`.`i18n` AS `Texte` WHERE `model` = 'Calendrierevent' AND `field` = 'texte' AND `Texte`.`foreign_key` IN (219, 167, 168) 660
22SELECT `Description`.`id`, `Description`.`locale`, `Description`.`model`, `Description`.`foreign_key`, `Description`.`field`, `Description`.`content` FROM `ccre3`.`i18n` AS `Description` WHERE `model` = 'Calendrierevent' AND `field` = 'description' AND `Description`.`foreign_key` IN (219, 167, 168) 660
23SELECT `Document`.`id`, `Document`.`locale`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`field`, `Document`.`content` FROM `ccre3`.`i18n` AS `Document` WHERE `model` = 'Calendrierevent' AND `field` = 'document' AND `Document`.`foreign_key` IN (219, 167, 168) 660
24SELECT `Lien`.`id`, `Lien`.`locale`, `Lien`.`model`, `Lien`.`foreign_key`, `Lien`.`field`, `Lien`.`content` FROM `ccre3`.`i18n` AS `Lien` WHERE `model` = 'Calendrierevent' AND `field` = 'lien' AND `Lien`.`foreign_key` IN (219, 167, 168) 660
25SELECT `Ville`.`id`, `Ville`.`locale`, `Ville`.`model`, `Ville`.`foreign_key`, `Ville`.`field`, `Ville`.`content` FROM `ccre3`.`i18n` AS `Ville` WHERE `model` = 'Calendrierevent' AND `field` = 'ville' AND `Ville`.`foreign_key` IN (219, 167, 168) 660
26SELECT `Adresse`.`id`, `Adresse`.`locale`, `Adresse`.`model`, `Adresse`.`foreign_key`, `Adresse`.`field`, `Adresse`.`content` FROM `ccre3`.`i18n` AS `Adresse` WHERE `model` = 'Calendrierevent' AND `field` = 'adresse' AND `Adresse`.`foreign_key` IN (219, 167, 168) 660
27SELECT `Activites`.`id`, `Activites`.`nom`, `Activites`.`texte`, `Activites`.`domaine_id`, `Activites`.`projet`, `Activites`.`miniword`, `Activites`.`published`, `Activites`.`ordre`, `Activites`.`updated`, `Activites`.`created`, `ActivitesCalendrierevent`.`id`, `ActivitesCalendrierevent`.`activite_id`, `ActivitesCalendrierevent`.`calendrierevent_id` FROM `ccre3`.`activites` AS `Activites` JOIN `ccre3`.`activites_calendrierevents` AS `ActivitesCalendrierevent` ON (`ActivitesCalendrierevent`.`calendrierevent_id` IN (219, 167, 168) AND `ActivitesCalendrierevent`.`activite_id` = `Activites`.`id`) 110
28SELECT `Domaine`.`id`, (`I18n__nom`.`content`) AS `Domaine__i18n_nom` FROM `ccre3`.`domaines` AS `Domaine` INNER JOIN `ccre3`.`i18n` AS `I18n__nom` ON (`Domaine`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Domaine' AND `I18n__nom`.`field` = 'nom' AND `I18n__nom`.`locale` = 'eng') WHERE 1 = 1660
29SELECT `Activite`.`id`, (`I18n__nom`.`content`) AS `Activite__i18n_nom` FROM `ccre3`.`activites` AS `Activite` INNER JOIN `ccre3`.`i18n` AS `I18n__nom` ON (`Activite`.`id` = `I18n__nom`.`foreign_key` AND `I18n__nom`.`model` = 'Activite' AND `I18n__nom`.`field` = 'nom' AND `I18n__nom`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `Activite`.`domaine_id` ASC, `Activite`.`ordre` ASC31310
30SELECT `Activite`.`id`, `Activite`.`nom`, `Activite`.`texte`, `Activite`.`domaine_id`, `Activite`.`projet`, `Activite`.`miniword`, `Activite`.`published`, `Activite`.`ordre`, `Activite`.`updated`, `Activite`.`created`, (`I18n__Nom`.`content`) AS `Activite__i18n_Nom`, (`I18n__Texte`.`content`) AS `Activite__i18n_Texte`, (`I18n__Miniword`.`content`) AS `Activite__i18n_Miniword` FROM `ccre3`.`activites` AS `Activite` INNER JOIN `ccre3`.`i18n` AS `I18n__Nom` ON (`Activite`.`id` = `I18n__Nom`.`foreign_key` AND `I18n__Nom`.`model` = 'Activite' AND `I18n__Nom`.`field` = 'nom' AND `I18n__Nom`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Texte` ON (`Activite`.`id` = `I18n__Texte`.`foreign_key` AND `I18n__Texte`.`model` = 'Activite' AND `I18n__Texte`.`field` = 'texte' AND `I18n__Texte`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Miniword` ON (`Activite`.`id` = `I18n__Miniword`.`foreign_key` AND `I18n__Miniword`.`model` = 'Activite' AND `I18n__Miniword`.`field` = 'miniword' AND `I18n__Miniword`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `Activite`.`domaine_id` ASC, `Activite`.`ordre` ASC, `Activite__i18n_Nom` ASC31310
31SELECT `Activite`.`id`, `Activite`.`domaine_id` FROM `ccre3`.`activites` AS `Activite` WHERE 1 = 1 ORDER BY `Activite`.`id` ASC31310
32SELECT `Partenaire`.`id`, `Partenaire`.`filename`, `Partenaire`.`texte`, `Partenaire`.`url`, `Partenaire`.`created`, `Partenaire`.`updated`, (`I18n__Texte`.`content`) AS `Partenaire__i18n_Texte`, (`I18n__Url`.`content`) AS `Partenaire__i18n_Url` FROM `ccre3`.`partenaires` AS `Partenaire` INNER JOIN `ccre3`.`i18n` AS `I18n__Texte` ON (`Partenaire`.`id` = `I18n__Texte`.`foreign_key` AND `I18n__Texte`.`model` = 'Partenaire' AND `I18n__Texte`.`field` = 'texte' AND `I18n__Texte`.`locale` = 'eng') INNER JOIN `ccre3`.`i18n` AS `I18n__Url` ON (`Partenaire`.`id` = `I18n__Url`.`foreign_key` AND `I18n__Url`.`model` = 'Partenaire' AND `I18n__Url`.`field` = 'url' AND `I18n__Url`.`locale` = 'eng') WHERE 1 = 1110