$key = 'myapp_cake_core_method_cache'
$time = (int) 1750062925
$cachetime = (int) 1750062935
$data = 'a:3:{i:0;b:0;s:4:"name";a:608:{s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"ffa9506a4511a7b9f744574dbdb4863b";s:5:"" - "";s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"70a4a1faf343973daaf7a89bac3df075";s:27:"`Departement`.`nom_soundex`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";s:32:"e6b58a6fd2dddaf18714b7433a8c7703";s:20:"`Departement`.`view`";s:32:"b74474e63c80be3416038fc312c4ea9c";s:28:"`Departement`.`presentation`";s:32:"aa3e4e25ef57c9a2187d8b8f38d66317";s:24:"`Departement`.`tourisme`";s:32:"58a859cc9ae1c3a16eba65ee4ba041d1";s:20:"`Departement`.`img1`";s:32:"8d1bfdd6c45677e3b05204c9cd512952";s:20:"`Departement`.`img2`";s:32:"f237f95c23798028c944020938923a2f";s:20:"`Departement`.`img3`";s:32:"f5807bd4b1e800229c1cfd99f42893f8";s:13:"`Region`.`id`";s:32:"5767ad9b0f3bcc5a12a47df58a8ab96d";s:14:"`Region`.`nom`";s:32:"976fd89e2c4c73a0e8f3638485c299c7";s:9:"`regions`";s:32:"e03a777181ec5a87bd0b60a2076b7467";s:8:"`Region`";s:32:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"b3a132b3002f0a095c207367d2386438";s:13:"`Ville`.`dep`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"c5697e1e5c979d7ac16a2058fe255e21";s:13:"`Ville`.`nom`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"c1f9b57df40a583acfdf261e4793fe99";s:20:"`Ville`.`population`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"b4707c5ae31d038ddd76310d59aceb1c";s:13:"`Ville`.`lng`";s:32:"f340c52a13f3cf8684f61cdbc6725f3f";s:13:"`Ville`.`lat`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"a618f1af022f58b10bcfe25ce6ae987a";s:19:""landes-le-gaulois"";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"bdd2cab4714f4907b3fc8a0ff2f6f7cd";s:4:""42"";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"e7c32d144dfbfdcc3f58ae21827b8236";s:14:"`Departement2`";s:32:"67aacecb01204237dc496f70dd03bb8b";s:19:"`Departement2`.`id`";s:32:"e98390f31e03ac9e907ae30feeeb76a0";s:22:"`EtablissementKeyword`";s:32:"f05318129420810d2df6af6f21777fb9";s:41:"`EtablissementKeyword`.`etablissement_id`";s:32:"08bee90596866040d3863d3b099b92dd";s:24:"`etablissement_keywords`";s:32:"6c66eb299f72f8ea6373806e1792c9db";s:9:"`Keyword`";s:32:"bcbd8f2dbc9172e3a3142affb2892e5f";s:14:"`Keyword`.`id`";s:32:"093651e381ef81925313bc1034b19f99";s:35:"`EtablissementKeyword`.`keyword_id`";s:32:"a88baf43cd357230f8c9342b8d8c1fce";s:10:"`keywords`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";s:32:"cc7a4a34d97ffbb85978393c1dc3d808";s:27:"`EtablissementKeyword`.`id`";s:32:"d096a0e47d35cc9ce5790cbbc44662c2";s:14:"`Departement3`";s:32:"0ec37699516eae0626bc53868916aa75";s:19:"`Departement3`.`id`";s:32:"ca639aa7397edb23ae76abc30e7d92a9";s:23:"`EtablissementKeyword2`";s:32:"fa37476c14e8bdb8e6403cd8dd4a24c1";s:42:"`EtablissementKeyword2`.`etablissement_id`";s:32:"2fe35282e812004170a32d85be0bf39b";s:10:"`Keyword2`";s:32:"783b4f7a045247c9e0b0f4b51cb73512";s:15:"`Keyword2`.`id`";s:32:"ea0e3653b3104978eb6a8c20321867ec";s:36:"`EtablissementKeyword2`.`keyword_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"f0390fa2e07b4a53538ebc42c3a44987";s:15:"`Keyword`.`lib`";s:32:"002849c2354331d18dc50d9a58fb23c1";s:16:"`Keyword`.`desc`";s:32:"b2f06ded35217196d1e2063a349f01c1";s:16:"`Keyword`.`view`";s:32:"a82fe8f431f55ca3e5c6eeb1425d6fa5";s:16:"`Keyword`.`slug`";s:32:"65fdef50318c78482920242502f98c10";s:19:"`Keyword`.`created`";s:32:"53ba12bfcc4a17ec6c1d401917cf8c91";s:6:"`view`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"dfbba30d1f72467a860b279eae73a5d7";s:9:"`nb_view`";s:32:"8ecaaa87ac95fb6026267ddc489d4e00";s:10:"`Pub`.`id`";s:32:"03bcab00ea59985094d3823102128dc9";s:13:"`Pub`.`title`";s:32:"19ae68421a7af6fd53280292661686a5";s:12:"`Pub`.`link`";s:32:"9a9117f5211facf70dbcba9197db0119";s:11:"`Pub`.`img`";s:32:"a0ec82037a4d9290d4b4962c6dd972ca";s:14:"`Pub`.`height`";s:32:"c584a2fb465c8e8da20fba3f63f5f9f5";s:12:"`Pub`.`view`";s:32:"40c6caef6b63d5cc208b1f45871b776a";s:16:"`Pub`.`view_max`";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"9da1d158b7b3f5102350b7a469c676c4";s:16:"`Pub`.`national`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";s:32:"66e5e328d5dbee33a55262a8db6553d9";s:16:"`Lien`.`libLien`";s:32:"79fb2ff64077823f3178baa92162ca36";s:16:"`Lien`.`urlLien`";s:32:"977a8c4228e74376ddde512c9805207e";s:7:"`liens`";s:32:"cc4f9d77d61d874d2e27e080d8c2317c";s:14:"`Lien`.`idCat`";s:32:"1907ab5ae3897aa37d301b06478333c7";s:6:"`Lien`";s:32:"ad0fbfd477684cc1bacb27971591dcfa";s:9:"`libLien`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"7de0eb817f98e54fb4e1545b78d80fe1";s:25:"`Etablissement`.`user_id`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"60b99a41e18de7d4f2356593a1c2cc3d";s:18:"`Comment`.`pseudo`";s:32:"d1fcf017825e414e48d0f305631b4799";s:19:"`Comment`.`contenu`";s:32:"bc377e3ee747a291022e3d709a322d04";s:16:"`Comment`.`note`";s:32:"e6b8ac227bd20feed342e5ed0866d680";s:10:"`comments`";s:32:"91239733a2f8a455459509f5d6a17048";s:19:"`Comment`.`etab_id`";s:32:"d29a826a93311c19e41cb1fc2007f993";s:20:"`Comment`.`validate`";s:32:"c87b6288c09482f582fd3874f1e9f7a8";s:9:"`Comment`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"ea27639167a1a02263b54353d6e97da2";s:12:"`Question`.*";s:32:"8af7f1408ebbdd1538dd8cc70790e7eb";s:11:"`questions`";s:32:"be5b47378b57374e35a1086740556cda";s:29:"`Question`.`etablissement_id`";s:32:"111287abadb6722a60a40e1d9c5cc797";s:10:"`Question`";s:32:"bdec4df5fb0fd0c66bc39f7d8bc9368c";s:20:"`Comment`.`noteprop`";s:32:"4ee734bb4a3bf9ac3e4f469578ad9cdd";s:21:"`Comment`.`notechien`";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"61eedb5524a37da074a515d3499b0fc1";s:16:"`Pub`.`ville_id`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"99ffdaf643cff6f5362893cd9db53d3d";s:11:""gambsheim"";s:32:"6990313ef629cac8806776a41e5e81fd";s:4:""68"";s:32:"94cfa97afd479a2e95a9a938db561743";s:12:""gourdon-46"";s:32:"3725365c00eaa85fad851e085a15c14a";s:4:""47"";s:32:"95ec9f9f8d73e6fed2c7b82adc34ab07";s:10:""croix-59"";s:32:"e8ade83b3133886783b73dbe2958bd22";s:4:""60"";s:32:"69e9e0846e10b962ec09bef673d11362";s:7:""etrat"";s:32:"7142166d1e9021c22af48d53bc32d9e5";s:4:""43"";s:32:"134093dad0749316ae2aa18418142399";s:9:""alencon"";s:32:"d6c45eaaed67620bdf39e09fc229e9ec";s:4:""62"";s:32:"6518d6596d40ec6b19b9f594aa6a8698";s:20:""st-brevin-les-pins"";s:32:"23b80b839585ad4545664371948eb48a";s:4:""45"";s:32:"258cc04da71951496adeae612321847b";s:10:""montagne"";s:32:"e6a8c8ace46a41131d681e53a0849e33";s:5:""101"";s:32:"980ab7794ac960a0d7dfc162e42f0350";s:26:""st-etienne-de-puycorbier"";s:32:"c155e72f9df7db89bc84822821bf7f36";s:3:""3"";s:32:"5fb28f43f5f7f1fa8e6bcc1a19f144a4";s:3:""4"";s:32:"d480a5a3a2e97b40d54cd2691b9407b9";s:3:""5"";s:32:"11f7978e0fa4709fe1d651df3a967a24";s:3:""6"";s:32:"6249cce00f875f824d54b02f91d40ff0";s:3:""1"";s:32:"b254890fcd6984580e2aaf29a7c11794";s:3:""2"";s:32:"45ebcaf5524257cd5f889bc677fa7e8e";s:18:"`Agregat__nbeEtab`";s:32:"7ae44a416b3e5222ef3cb45d5e37a85d";s:11:""chalus-87"";s:32:"25cdca52a35f09964121c4b572df2ddd";s:4:""88"";s:32:"98510334d2f261052486325e7f83db21";s:11:""tonquedec"";s:32:"47ff6962f1b7e7bd8323a3cd4655ebbb";s:4:""23"";s:32:"dc1ad7c0e235ba60871dc360f114beed";s:8:""marboz"";s:32:"30477304ef591fa8f58b7ae6b579c3b6";s:16:""amorots-succos"";s:32:"536752ea892f8bcc379795e80ead2ffb";s:4:""65"";s:32:"81e78706bc85ad1d33e00c5a68a22579";s:11:""montsales"";s:32:"e0ea880a6e61ac4555843a6f330957ee";s:12:""montsalier"";s:32:"93bc36e3b511b49a694df03311107b72";s:19:""st-jean-de-serres"";s:32:"facb9d8f0944252eaab4fc2c163bfc5f";s:11:""montsalvy"";s:32:"53ddcca45c2e35ca32fb4ff7f3c8cf9e";s:11:""montsapey"";s:32:"981f98a3fda729dac0d9022924c66e22";s:19:""st-jeoire-prieure"";s:32:"18eb77c77cc41752c48f9dc418b8a55d";s:13:""montsaugeon"";s:32:"dd284d1be32c47475a187a659b1c1948";s:12:""st-just-01"";s:32:"d869b6a7685a7ed0189e44a7c7d78a0a";s:12:""montsaunes"";s:32:"8cbb4add8497f1a9b572fd5df56eae37";s:12:""salleboeuf"";s:32:"a982bbb042538731dfd4791b2b615ac9";s:4:""34"";s:32:"613b71bcff6a824f3f7f624c83346e85";s:9:""montsec"";s:32:"3ba791ea0ba340c942e59b37a4db1273";s:12:""montsecret"";s:32:"63714ebf9979ccc3711c747e5e1c2a43";s:12:""st-loup-41"";s:32:"bcaf712e2eb2daa47381ac30062a044e";s:11:""montsegur"";s:32:"b1ac004ffb55142930dd0f33699536c1";s:22:""st-marcel-les-sauzet"";s:32:"970b8d75eb63c3ef7ee9f0cb4d110a5d";s:22:""montsegur-sur-lauzon"";s:32:"1987a445ed92974d48ef3b64f4e31ce7";s:13:""montselgues"";s:32:"a4635fbd50921565428c1c2dc3566b2f";s:20:""st-martial-le-mont"";s:32:"35a47c47f35ff89f586a51f6f94c5125";s:11:""montseret"";s:32:"2581e28e807f481b6958c6d8523c66e7";s:11:""montserie"";s:32:"84a4dd7b7327a42244c9b665310b0209";s:12:""bernecourt"";s:32:"b8c23c567675f31caa4346bf2477bad3";s:4:""55"";s:32:"d280740626b2584acbfc2913bde1a573";s:9:""campuac"";s:32:"52a8c6ab4f69e402f37349a5fb5b2a73";s:4:""12"";s:32:"0eba3ff942ab872699179d7feeaeb7b0";s:20:""montrond-les-bains"";s:32:"332b362fd2e8e1454a7ca120dd11f7f4";s:13:""ayguesvives"";s:32:"8789547c05bfa02798ab3128eea30e2d";s:4:""32"";s:32:"896182e4270627f42a6907c3d7253662";s:10:""lusignan"";s:32:"bca378769cc071b2dfd627a0ef0e2f0d";s:4:""87"";s:32:"29d7fad58cca16d72cdaaa9fe848ef2a";s:22:""bohain-en-vermandois"";s:32:"2c4e7e142a9ddaac6be7a91550235126";s:16:""vals-les-bains"";s:32:"1f37ebad5b019bb170abb6697584f64d";s:3:""7"";s:32:"5d963ae17eb6fc9ad6e2b2222d9b2454";s:13:""commequiers"";s:32:"8b494f47bcbfd630030ff7131b5a3f2d";s:4:""86"";s:32:"c3a36192a49c72a7b59b3c880bd7f695";s:8:""abries"";s:32:"5159664cd3819af9d9cfba4c89bf9404";s:17:""aigues-vives-30"";s:32:"15d6b97cf557c9ef82700914e59762c0";s:4:""31"";s:32:"b87c626766454fa6b0815bf6a1645d1a";s:17:""plan-de-la-tour"";s:32:"fdb204524e6231c6606712ff78ff4f79";s:4:""84"";s:32:"ad0148043bbe796000225875bf80a04f";s:26:""villefranche-de-rouergue"";s:32:"b06c6ac9123936defa46ab924b68f30f";s:7:""blois"";s:32:"4afcf3286738a22fa8e62800376ab783";s:9:""montrem"";s:32:"4c9f5a825e49a6ba84646a996b6447f9";s:4:""25"";s:32:"7aab42198a249fc7c5d8889bc7463737";s:13:""eaux-bonnes"";s:32:"31cd08afc3645da4f3a58319847f2f51";s:22:""nogent-sur-vernisson"";s:32:"13d2692796a894010e322f7ce65ae7eb";s:4:""46"";s:32:"c3997d349d2e2e5c7aa1110a5fe258f5";s:10:""lanmerin"";s:32:"ca4e5facc456fca8954d7525bcf86585";s:7:""ceton"";s:32:"e8efcdf44d7d7b21e7a957d63bee7bd0";s:12:""beaupuy-47"";s:32:"7d8332c40ede7afa36d4eea6315bdc9a";s:4:""48"";s:32:"45847c05fa1029cf20d9b401b0d97692";s:14:""montseveroux"";s:32:"d0a1ab86544960e218d7c1ea4562e033";s:12:""montsoreau"";s:32:"636791896632d91ddd9a3299f40d45eb";s:10:""montsoue"";s:32:"7691dde12ea80faab76003c990e8593e";s:24:""st-romain-sous-gourdon"";s:32:"b49f403002bc4e5fb38e1d045cb98d90";s:11:""montsoult"";s:32:"831827adeb1300b76a9f858f81659ac5";s:15:""st-sauveur-80"";s:32:"01f1db3d15b847bb6706cb47dd74968d";s:13:""montsurvent"";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"2c5e9f52d960e90ec5f07551ed2997d9";s:21:"`Departement3`.`code`";s:32:"1d7e457219fc27e7fa343049f6f7f966";s:17:"`Pub`.`region_id`";s:32:"122012d8a798c19f89f981dd65600970";s:22:""montureux-les-baulay"";s:32:"c2c1011af7ffb891fdd7dd5388893f60";s:22:""st-vincent-de-barres"";s:32:"88cca952db5ce648c0029edcce24b06e";s:9:""zetting"";s:32:"99ac0e71a40555b4f9bd78c12ecffe15";s:4:""58"";s:32:"7b754c1aa216f6577fbe7eb473cbfe78";s:12:""montusclat"";s:32:"e577cc88c5918c0e84f2d04f0468d846";s:16:""taillebourg-17"";s:32:"b399299a7f8e4ff32bdb9d8695424523";s:13:""montussaint"";s:32:"3e34f647a56d4aebf6eede71a9f7ade0";s:10:""haguenau"";s:32:"fe0e34c937d45930250ec69952a1d0e7";s:11:""montussan"";s:32:"d20601681a2cddfebbda9709ce7e03c8";s:18:""montval-sur-loir"";s:32:"9865fb0a28d17e0566dbeb6d2b50f90a";s:23:""thiaville-sur-meurthe"";s:32:"de00eb59bfaf43c02e0f22cb600ceb10";s:11:""montvalen"";s:32:"5d0b78c7d70fd952d89f2ea96bac4fed";s:12:""moineville"";s:32:"96d98a64c324621fe977b5f843d89bc0";s:11:""ensisheim"";s:32:"1df51dd1653034a991bccb998695011b";s:4:""69"";s:32:"3f639947003152cac84b5d5073e27ccb";s:12:""saussay-28"";s:32:"13108ecd230ac992c904d2febc925703";s:4:""29"";s:32:"31c002499054a1a83510f3b27c3554c9";s:13:""pommiers-42"";s:32:"5fa76f484331af228a8d20e273748106";s:12:""buzancy-08"";s:32:"b48eb543cf607a0bd515156375ac6d03";s:3:""8"";s:32:"6272d9b9c122e404375f3ba47a84c864";s:6:""cote"";s:32:"b72f647a069067159e54870c48a9dde9";s:4:""71"";s:32:"8111a3641f2f8274bbc4da8161f4903a";s:23:""touffreville-la-cable"";s:32:"b507d10e9f543604ae93201c923e5af6";s:20:""conflans-sur-seine"";s:32:"eec795b73f6f85849975d87bce013a02";s:4:""52"";s:32:"22fc08638ab4a16be4418c723bfcdeec";s:9:""ceillac"";s:32:"43c45b015ec1ef55238aacc704fb45ff";s:9:""beaugas"";s:32:"f45c57c8d13d8885bfe53373e84b8e2e";s:14:""lignieres-18"";s:32:"9d410b12215ce4f7fdc71e4e3019753f";s:4:""18"";s:32:"d7fc012d9411b236eff26613283d1112";s:13:""montvalezan"";s:32:"1e8aa058c7c6d1b15c5093b2227ef152";s:7:""ambax"";s:32:"e535e5978620132af7d8303634391abf";s:6:""boen"";s:32:"37632c4ec356a2e424e99990769875e4";s:7:""objat"";s:32:"cce1cc10a574f13a093a92350396d473";s:4:""19"";s:32:"20b2544a2dbfd864f782faa687eb61c6";s:10:""douzains"";s:32:"88ed01e3f7983c42f390dafde5ff1c09";s:20:""neuville-de-poitou"";s:32:"1aaeaf60fcdcaf353722d59041396c64";s:4:""94"";s:32:"286b81f44f14f8fcd93c35510545bf19";s:21:"`Departement2`.`code`";s:32:"5e9248944d534ce76e33e03f3ada7e5a";s:15:""vaudesincourt"";s:32:"b30474f305f6466b5a507e02daa3cf59";s:12:""montvendre"";s:32:"7b930261967d24746ee49c01b01e1384";s:12:""montverdun"";s:32:"2d68e5961bf8572ca5d32538b2e921ea";s:13:""montvernier"";s:32:"1160494e4ace5fa42b3f1980fd96daae";s:10:""montvert"";s:32:"43e2cdd3271be3b0e23caa9b3a8e989c";s:10:""montvicq"";s:32:"58023f84062b7163c5fc28bd1e35aa07";s:12:""montviette"";s:32:"413b94fbbfd9f4ea5c24ee54b8642666";s:11:""montville"";s:32:"7e65da889619e098fb6a127a829436ca";s:16:""lac-d-issarles"";s:32:"5a5735e4ddc921e39e0bb859e982cfe1";s:11:""montviron"";s:32:"2e26042f26aaf16a7e45e812fe7d6a4a";s:8:""lalaye"";s:32:"43316b911170a2a49987386f7ac43901";s:17:""lamaziere-haute"";s:32:"266571b8fba4c97685f30a698d9be48c";s:9:""monviel"";s:32:"32ec373b72e62d2e7e33a585a47adff7";s:12:""laneuvelle"";s:32:"92adf2b3d949756e20ae1ecee082fe70";s:18:""champs-sur-yonne"";s:32:"b6554ae489225685bf271d1d2ff0eb20";s:4:""90"";s:32:"51c6450e85a24bf00403eec434e7f1cd";s:7:""pinon"";s:32:"d1ce87452269d16d9197036f1689fc68";s:9:""blagnac"";s:32:"10d44501b46c27819d280d838c0b7fe7";s:12:""remiremont"";s:32:"5b2f330d6cad4adcaff0785a2c6b85a3";s:4:""89"";s:32:"6d326c3062ac00efd48d9ca0f5b7e0bf";s:8:""chatre"";s:32:"d88c945e9fb176ffc35aa4919f0272f8";s:4:""37"";s:32:"76b14039e6a89f8095a9a4d8ddb9ffe0";s:20:""conde-sur-l-escaut"";s:32:"c895308d26a5c59025cf665d3d7b7e3a";s:11:""auterrive"";s:32:"29abf7420fb314445e206b460b09d643";s:9:""allegre"";s:32:"38910b5f5001b084555a03a28492bd94";s:4:""44"";s:32:"b3b5e9d2d02dad945487efad4eb6a90c";s:9:""aubagne"";s:32:"5a340de1227abddfbcbf93f153a8440f";s:4:""13"";s:32:"50349384510d99c31ef46de2be2ead77";s:11:""peyreleau"";s:32:"03e845cd5424758f65e4a28184865d7e";s:7:""autun"";s:32:"c35017f5f2976d3684e598f1e816367a";s:4:""72"";s:32:"3d795a1d95d044f6fb12a5f4a3c4fa67";s:6:""ahuy"";s:32:"8d26efc353156c4964f21eb7453a8e08";s:4:""22"";s:32:"aedf68a5cd14b830f1b9247b07f5eeb5";s:14:""chauffailles"";s:32:"285d3574c46281b125006671c6a09c00";s:12:""mooslargue"";s:32:"2a573c048ec13f6d82256658b0af813b";s:15:""laparrouquial"";s:32:"44c8701423d1436b8ed238ab2d46f896";s:10:""moraches"";s:32:"1043f2b77cca133c36ef13e1e2859590";s:11:""lauresses"";s:32:"159ad959ca2ecedcfe114e91e1bd9432";s:9:""moragne"";s:32:"68c5d3ebd1328af45cf3860ca6c2acd5";s:13:""morainville"";s:32:"9892e3dbce2d098811de7a8389824e07";s:22:""morainville-jouveaux"";s:32:"9e06f4983d2311a2bb2f0074e58bf941";s:17:""lelin-lapujolle"";s:32:"16795f086b83337ba436cd1192ec4b04";s:16:""morainvilliers"";s:32:"8f09bafac3b19782d307a15eb236e820";s:9:""morance"";s:32:"4a39ae41fcc363aa90fe130f9b0cd813";s:10:""morancez"";s:32:"1cc243db8148aa5a32a0296cbc9bb3b6";s:12:""morancourt"";s:32:"b50466fcaa2a911d48f8de256aab54ed";s:8:""morand"";s:32:"548aba37b1605ba4b3af034a8345d2b1";s:13:""morangis-51"";s:32:"ddf8f8361ca27f45599e4b999998ebd3";s:9:""lempaut"";s:32:"9342a9d30c585bbffbb675d855646979";s:13:""morangis-91"";s:32:"7647dc19ab05ef64cb1990aba2d46092";s:11:""morangles"";s:32:"90379d6a9bbeec0657e5d6c9f0f55225";s:7:""leran"";s:32:"7199213cf092693521da10bcb576dfd2";s:10:""morannes"";s:32:"1f58f666efe083103e5826eab57f1689";s:12:""moranville"";s:32:"a93ba8554933353e23d8f5c781e0fb9d";s:7:""moras"";s:32:"31a7a3ebbeb3de08b6060ee88aaa912d";s:19:""moras-en-valloire"";s:32:"ab50b676962873060dc0a94c180d0d0a";s:9:""toutens"";s:32:"563220448d863ee151ca5b6a96591c3e";s:11:""morbecque"";s:32:"6401f23643a300ffbe4e3e4729da00a9";s:21:""lescure-d-albigeois"";s:32:"31d3165347d2d86493113a40e1665b3c";s:8:""arlanc"";s:32:"abed2f95e3e5b2885ff6f578794a26d8";s:4:""64"";s:32:"9659494d794167092cc385334ff3fefc";s:10:""aurillac"";s:32:"d1582db820a0fcfeecedba5685e3da9d";s:4:""15"";s:32:"b56af77e1b871120d0556dee4584b2a2";s:8:""tavaux"";s:32:"5ee52c1df02350fac9d7041d5b52ee12";s:4:""40"";s:32:"f5c289fa5467783fae9b3aa09f7fe942";s:10:""dourbies"";s:32:"2646511e139fc339c13397b6b8081290";s:12:""bouligneux"";s:32:"4d1696234b3cbf45b748e09f5c9b64be";s:6:""aire"";s:32:"1ccfd1d44b56bd9f42e987e12bdfb9bf";s:8:""jaulny"";s:32:"cb62700668af8053be623bca622b01c9";s:11:""astaffort"";s:32:"5254c29b22f92904be686e2e32963e0a";s:13:""bussiere-45"";s:32:"4aff490dd54c16691284d0d3327e4221";s:12:""matzenheim"";s:32:"5a8c9fa9b57e1644deec5edfe6bcd094";s:11:""chassenon"";s:32:"b8ac2f30f4341d6ca9249c0606009ff5";s:4:""16"";s:32:"d37deb7b5e37b96c922b56086aa4e508";s:8:""loches"";s:32:"8f4f7252001b87bb9ebc001ec6ba70a6";s:4:""38"";s:32:"4bafd4ea63ecb4cb3ad4e102c49c3352";s:10:""souillac"";s:32:"233d2a9967658564344a5fcce0c5dd94";s:9:""neronde"";s:32:"18e829c75c1ec1ad6bfca1dcf1ae1925";s:9:""vaux-86"";s:32:"c6231b5e922fd308f59f3bbf61cf365c";s:15:""villetelle-34"";s:32:"097742fd62f89173f16da07e9cc56201";s:4:""35"";s:32:"0e941117675b41d1e14a75064a7087f4";s:9:""morcenx"";s:32:"0c41493003e21cc77d50361bba4003f9";s:18:""arpajon-sur-cere"";s:32:"e02f1c57f1f4f79bcd7f94d157d76328";s:6:""nant"";s:32:"49830cf77a78c06cdf15ccaacfdd6635";s:5:"`lat`";s:32:"1b739327d082af5af492288a2bc8cb64";s:5:"`lng`";s:32:"472551d38e1f8bbc78d7dfd28106166f";s:10:"`modified`";s:32:"e17d7b5a65ad1ae7ada6b153517881ef";s:36:"`lepetitbz331`.`etablissements`.`id`";s:32:"6c52d57d57d46746fa18cf527b9beff3";s:10:""morchain"";s:32:"60c1b0a7e9322d6b60f1d94fc72dc728";s:10:""morchies"";s:32:"e2d00002314214f5d3375c20463d33ef";s:13:""morcourt-02"";s:32:"1035d35d9a80f4e79922ad9194d5a11f";s:13:""morcourt-80"";s:32:"4cd40290403f6e2f7c8b4fe00b2980bb";s:24:""lesquielles-st-germain"";s:32:"a00d0a439ae624ed47e32210f30c218d";s:11:""mordelles"";s:32:"379299a08818ea2105d8f1bf6db403c1";s:8:""moreac"";s:32:"c461009877a8a2aee1173b31c58bd3b0";s:7:""lesse"";s:32:"a817dd0a2df3dd69ea346c67fb1b882d";s:7:""moree"";s:32:"2eb01f86709cae47e8d53714a800dcfd";s:11:""moreilles"";s:32:"8b327effa528b154336d0d37952b1cd2";s:8:""levare"";s:32:"f63bf20bfada402fdc089a83d08266ef";s:13:""morelmaison"";s:32:"1cfb925cb9dcbcf251fe14a5cc599a45";s:11:""morembert"";s:32:"bcfc06d19fb5b9ad0bc685cd781072a7";s:5:""ley"";s:32:"f874c4f2d27c92fbfff0628b215b4b63";s:10:""morestel"";s:32:"a315219725f5512de7f49d3389fc6d1a";s:8:"`Post`.*";s:32:"cfacfed443d6f30e67edf9bbcb06ce30";s:7:"`posts`";s:32:"c0a33fa0f04ac4682dcdc4b25167b3a8";s:6:"`Post`";s:32:"d20e7bceeb0135a07432718f0d5096d7";s:9:"`created`";s:32:"ebe8d174d5e5cbcba0298d4c8036d38f";s:17:""moret-sur-loing"";s:32:"285831ebfebab89514cbe8b7997454a4";s:20:""moretel-de-mailles"";s:32:"7fda098b87a155b57b69a240300fa457";s:5:""lez"";s:32:"2a07a0a14b4e0c7d457cf7c2252c8ee5";s:9:""morette"";s:32:"4cea60fdac2405634c52ad074de1dbb8";s:6:""liac"";s:32:"542a36960498c722592cd6b208119756";s:9:""moreuil"";s:32:"64906e1ecfaaa441b31de7a3e12fc70f";s:9:""libaros"";s:32:"330e80ac05a867dc609c6434e6feb972";s:7:""morey"";s:32:"8f3f91504fab08537d08e1006321ce23";s:11:""bermeries"";s:32:"732d9b5fb938b298e44d4b1fe309ddfa";s:19:""villiers-sur-orge"";s:32:"e078105b5e08579c42dd62507e8db36b";s:4:""92"";s:32:"71fd73973413d9783b74e6a15f7548cb";s:22:""chemille-sur-indrois"";s:32:"e5886139bb1116ad2a7f0cd5723306cb";s:8:""belley"";s:32:"b3b6c405e1991f371e9b192bf9b47798";s:12:""bollezeele"";s:32:"6d98560e255e5d249f22ccd0a6614b1d";s:11:""landunvez"";s:32:"aae25e7317a2c0ff61ddebac827b053f";s:4:""30"";s:32:"b75059a4c10fab8d1faf2f8f95e67973";s:20:""mont-pres-chambord"";s:32:"a67647feed32a14706ba995cf99ada90";s:13:""drocourt-78"";s:32:"7d5ba110e1322d57ed023c424b1e1caa";s:4:""79"";s:32:"1e24aecba07d64fa7be238d0e1cb990e";s:15:""saulnieres-28"";s:32:"ea562de48203383e1da68267f2619cc2";s:11:""candresse"";s:32:"46285367973c1d568ab8b875167aaaf5";s:4:""41"";s:32:"fdf1c240db90de21e025ec54396584f1";s:23:""colleville-montgomery"";s:32:"ca63792778e7aa577dc891758f6e9aab";s:4:""14"";s:32:"a337a156875cc6709a1615d821201375";s:10:""hunspach"";s:32:"a7e643d8a1bab2e555b70c98242602e6";s:12:""calmont-12"";s:32:"eea2b662b76320a36f920225f93769a0";s:10:""pruniers"";s:32:"32da81584315e48fd513a5693d0abd79";s:20:""lavoûte-sur-loire"";s:32:"ddd79fff4f794b7aceb9b8581f2f04a2";s:16:""morey-st-denis"";s:32:"f07ecb05c9502f5be0c843ec290a759a";s:9:""fleurie"";s:32:"be7175f45c182640c54295ffb5040c51";s:4:""70"";s:32:"f06f339210070010a05cef4033cb4465";s:7:""bouee"";s:32:"944c32b012eaec4c9cd9eb03ae841cff";s:10:""lucciana"";s:32:"f90eea21e7f924152ce55baeaa8d2acf";s:4:""21"";s:32:"1122058092afd0a7cb74ff8861bb95f6";s:12:""bellignies"";s:32:"9b6e5fe892cdaa0c14eb362998a43b0a";s:7:""morez"";s:32:"aa07904df96d5a8fdbd9fe4e4a30b3f7";s:13:""morfontaine"";s:32:"d55a61225d0ed9b062c11c3228557fc1";s:9:""lieurac"";s:32:"ffd570adfb4dae8e6d80dad3356a9bbc";s:13:""morgemoulin"";s:32:"23e33b5aa724b36d4ec774c911cd26b2";s:21:""morgny-en-thierache"";s:32:"1ac567adfa21b6bc46e80e54f3950d6e";s:11:""lindebeuf"";s:32:"2a83dd85931b134222515621205aac78";s:9:""linghem"";s:32:"0da5f904adf1bddf7ec6d3d8e4c3558b";s:21:""morgny-la-pommeraye"";s:32:"21a673bd3d70ebcf035cb8da88e60e82";s:10:""morhange"";s:32:"8a4d8224264641e96b33dee5ced86f50";s:14:""linguizzetta"";s:32:"f1a397c43704f746300552efaae68ff6";s:8:""moriat"";s:32:"051c434bfb7f06215038af97c4b0eab2";s:10:""morienne"";s:32:"bb7bac7fe5531d6232abb004336bfa71";s:9:""lisores"";s:32:"6fd631930d01565115d067568d10bf59";s:11:""morienval"";s:32:"25f6bf7a8746b1c053ae21c36b00f4db";s:18:""longny-au-perche"";s:32:"a61394f89efa7855b9be35e9d4273194";s:22:""morieres-les-avignon"";s:32:"8c8fd535a9e0e71aea1c1c2e15b72840";s:8:""loreur"";s:32:"44ad872ca2dd7684568f6a369f733a36";s:21:""st-mandrier-sur-mer"";s:32:"7e1159f3571683c55ef77dbd2d39a04c";s:10:""lorey-54"";s:32:"225e9a30099cfcdec2c3a77b39460cc6";s:9:""morigny"";s:32:"460dc967542f4dd949b78cbb316901cb";s:8:""jeurre"";s:32:"f7d910db5ddb66bd37d6cdf7ebe0e42a";s:11:""amneville"";s:32:"305438046cd1bdb629a30d2da21cfa28";s:18:""beauvoir-sur-mer"";s:32:"987bd22c9a0a1e51d85df28f9b49ae27";s:15:""montivilliers"";s:32:"0c814091063da1002aeaafcae22b575b";s:4:""77"";s:32:"61faeff9540d339679f344dc7a828b1a";s:7:""anzin"";s:32:"2395767b7ae5904527ba9b20a38e48ea";s:17:""chateau-renault"";s:32:"2db1355f39914da2b31482b459591ec0";s:6:""metz"";s:32:"5d5e3356787121553665432987d5453f";s:9:""cambiac"";s:32:"6f009d70a97d9e14ef6e70b01b6a0da8";s:11:""luneville"";s:32:"e316956210822624fc1e40a738cba075";s:23:""chateauneuf-sur-loire"";s:32:"0c857587dfc57d4b5bf3a80bea75dbd1";s:8:""jussey"";s:32:"ea72013134efd7cfefdfa36322620f28";s:9:""grenade"";s:32:"da80188403a4e99b20b4ca5a3b933de5";s:21:""monistrol-sur-loire"";s:32:"374aae51dd33322d362ac5edbbdbc345";s:19:""neuilly-sur-marne"";s:32:"9b87cbfc2ae4cc3ed0dc30e44fb4de1d";s:7:""tulle"";s:32:"a14cc3cac927e6f6cbb09c7e2eb89cb8";s:9:""limeray"";s:32:"41ab53af3e71b496a44070977af093e0";s:8:""aubord"";s:32:"7d431543127e88bdc525b1874e215a6c";s:10:""morillon"";s:32:"1aeeb05bea150b795deea93114708050";s:16:""colle-sur-loup"";s:32:"d36d03e9bb2a4e2e5d55ac1f6c79ea4c";s:7:""fitou"";s:32:"167bbbccc66597a3e0bee5ee6c3eb216";s:4:""11"";s:32:"de84c4685542e19427fb94247361a3fc";s:9:""cuisles"";s:32:"7b772b3957189a2faf8d9a188216d5b2";s:11:""holtzheim"";s:32:"5526788f63c9b5e9dc22e52c4c9269be";s:10:""loubedat"";s:32:"cf099575d87251198d98fe816c8fcbf0";s:11:""moringhem"";s:32:"b2ab7a9ea697f5601a21e52895820f47";s:10:""lournand"";s:32:"c8b7b4c0142b845c7510ea87e166d759";s:16:""morionvilliers"";s:32:"95308d4dc744d4f42f4251bbd8f9aadf";s:6:""loze"";s:32:"47186f1382f628bd97b760f90a589471";s:9:""morisel"";s:32:"8a5c6d13eded646020d1c63d7513f652";s:11:""lozinghem"";s:32:"5e6a2eb0f4dedf133fcea1f781f1fca2";s:11:""moriville"";s:32:"769a24c486bec55936a23ab5161bb1b8";s:12:""moriviller"";s:32:"bae8fd404d5c17d2d6c535cf1767a2b7";s:10:""magny-70"";s:32:"011f15ef029b476c7411d3e99a7efb66";s:13:""morizecourt"";s:32:"156f97aa39092d2dd6a07372e90d3200";s:9:""morizes"";s:32:"06a754273939f1e8f749f04eb4ea7902";s:9:""morlaas"";s:32:"cf2722a5022c925a6a25634e500f3e2f";s:8:""morlac"";s:32:"a06262baf698ae640a71d50d987f0dc5";s:8:""magrie"";s:32:"5ac007e628a87f5b23570091ea3b2436";s:13:""morlancourt"";s:32:"45f12be0ef693dacb6df9d403fc699cb";s:12:""maillezais"";s:32:"f93eb797190132a946150aeb93cf415d";s:10:""morlanne"";s:32:"ebdf2c663c8d53a74589976cf637233b";s:12:""maisnil-62"";s:32:"aca4692093747d77e2ab9e97848fe26e";s:9:""draveil"";s:32:"ab745748c84ff4cdc999592806f546fa";s:9:""auradou"";s:32:"a9ef024d1e765f1b7f049aad671be35f";s:9:""benquet"";s:32:"237c08700f5ae43e9aaea0bfa4367163";s:7:""nangy"";s:32:"f6eebbe2a731a124a4cd5bb3849ad21a";s:4:""75"";s:32:"580ad335ffb0cb2104ce427f03c2477c";s:15:""benouville-14"";s:32:"e1e9762172ae7e5cb3fc72a95604aa9e";s:11:""branne-33"";s:32:"680a64a1889d71638ab69c4df24d648a";s:5:""pia"";s:32:"f47b005a37f014816c39065cdca3bb00";s:4:""67"";s:32:"9f3318724422eb7022a0c877fb76908f";s:12:""belleserre"";s:32:"4f9cd7d551ea5f6145781cf46d186558";s:4:""82"";s:32:"811f4f37830e328e88a0410b556c87d5";s:11:""montfleur"";s:32:"eb339525207be4238e7f4cccf33d1921";s:8:""morlet"";s:32:"65dc2b25404752bcfb375b80f550d2e9";s:19:""villers-cotterets"";s:32:"baae300ee34d04d5bf23974b23f101e4";s:4:""36"";s:32:"6e91129f0758185974ef94fdd52bc060";s:13:""ste-pazanne"";s:32:"7f68db8c83b95f099c395c6f376e6274";s:8:""boulou"";s:32:"f0ce234c0e563fd1964b8a563c25785c";s:15:""carsac-aillac"";s:32:"1a8283db54efc174eaa1b2a4036d80c4";s:7:""arsac"";s:32:"1ac784771f7d37321a70522a81a196b1";s:10:""fanjeaux"";s:32:"96e383d5796b1c69691245b6d53d032a";s:18:""marnay-sur-marne"";s:32:"6e11f612c92a276a2ef74e3839222b11";s:4:""53"";s:32:"72923410ba71382cfc72ba427aa5e864";s:22:""auberives-sur-vareze"";s:32:"350df01e677bc5e8dd3bc68af78b589e";s:4:""39"";s:32:"2f4c1ffae1dd526af35e2d17808b3b43";s:9:""alzonne"";s:32:"41689711528727361b99bfba3a7716ae";s:9:""tournes"";s:32:"f2e42280bf30057f8c5d8b1620d39f31";s:8:""morley"";s:32:"49dda51ee3e8311c3e837f5f5b57aacb";s:17:""morlhon-le-haut"";s:32:"45261f466c0f653105a9ac02b0a4dc97";s:13:""morlincourt"";s:32:"e84793861be7e65828bd69233bc8b9c6";s:6:""male"";s:32:"ce4535e5f2c396bbdd171ec8b17e9089";s:11:""mormaison"";s:32:"e3fd8bdeb251bbf0c2f9d36cd92ab9fe";s:11:""malmaison"";s:32:"8b4b47eb50c05e3f6d3c1ec1094b98be";s:9:""mormant"";s:32:"cc86257bdf71303084d28e64ffeba031";s:23:""mormant-sur-vernisson"";s:32:"09bd3809f41968ab73aef62bd65ca408";s:18:""marigny-marmande"";s:32:"9d610831c82dc7eab6336c8e54a0ddac";s:8:""mormes"";s:32:"7543c908885203d5c631c06433830433";s:18:""ste-anne-d-auray"";s:32:"dc22fe3c1ec55a2edb2086efd4271ad8";s:4:""57"";s:32:"e628027599a75829a54661255795df2f";s:11:""mormoiron"";s:32:"5c4ea87a71bac6e3eaebfa11645aa82b";s:11:""montbarla"";s:32:"a309a07c17a6d5664b2f846034a3a11b";s:8:""mornac"";s:32:"89d89bd7fd5dee153d3e100e10cae47b";s:19:""mornac-sur-seudre"";s:32:"b903d0f659e498342d72bf507305a77e";s:18:""mornand-en-forez"";s:32:"8d170d9cac6556b202771639fb18b006";s:9:""mornans"";s:32:"50a211466a72b2e97d8349807c8dd9f6";s:13:""panissieres"";s:32:"c8021fb9e00d794195804a11a1e6cfe6";s:13:""barjouville"";s:32:"4f53889db5ad7c8b7be3ef2dab602cd8";s:18:""champs-sur-marne"";s:32:"fabcf25abfd5f87138769bbc7a1c4666";s:4:""78"";s:32:"111ccaad244884abd526dc97ccda047c";s:13:""morville-50"";s:32:"30e0fbe2dedd7496d6607455959eba37";s:4:""51"";s:32:"09c9ba8f5ce7b44d67ca1ecd532e0286";s:21:""contamines-montjoie"";s:32:"6326cdffa4a208aefbf3281e4f09feab";s:17:""rosny-sur-seine"";s:32:"dcdbd0ae5af8f81f17b9c86f5e5464d2";s:22:""bouzonville-aux-bois"";s:32:"8ae9771ee4e55b40326a44cd7ef2a71f";s:12:""gravelotte"";s:32:"7a7d5e9d9b705ed1cfdbeca923becfa6";s:15:""grandville-08"";s:32:"24918c6af9084b583e9f7ced0aec62b1";s:9:""langres"";s:32:"ebb4fb49f05565c6a30bca2c910cdc01";s:9:""beyssac"";s:32:"705e199d5ba46d7cf47842ccd9e31517";s:15:""renneville-31"";s:32:"cc8bc6e05e63967b8be314f6d17bb806";s:21:""san-martino-di-lota"";s:32:"2ee5ec7ce0879e8da05cee93cf667a4f";s:16:""thiron-gardais"";s:32:"527b8103f6a443fa9c761cdb9a4886bf";s:17:""alby-sur-cheran"";s:32:"fee0c05d9da9e44e922061e310bc590c";s:8:""anould"";s:32:"8bcd53fba2e03cfa7a9ffab625f35afe";s:9:""betheny"";s:32:"981acaa10838313fc89f56ecaf29aa87";s:9:""roubaix"";s:32:"7a5fd38795275de137ecea4832446b22";s:12:""montrejeau"";s:32:"2aea0d8400790a774faf4f1cc0f60255";s:11:""quimperle"";s:32:"12469a1cf7047a0af2f3fd011c969aa1";s:9:""blauvac"";s:32:"f9f5f147f05d82ada7e773fb4b3a613b";s:4:""85"";s:32:"bfd5aa6cc373c91276118760f779ec88";s:17:""bonny-sur-loire"";s:32:"af365cdf59d114dbde0b1e5eb921fe4c";s:10:""vaujours"";s:32:"10edac96321191a2cdae37cc4f5ff117";s:8:""coubon"";s:32:"b2bb4ed9fdee09b2b37df20bc559cb32";s:7:""nance"";s:32:"2f057925f2909b3c2a61aab86987e002";s:8:""mornay"";s:32:"ef5ea3c112c922f760e1a9d7dc0fd7f1";s:13:""oberroedern"";s:32:"67e82932a7ba08adec2e526fed9a3376";s:14:""mornay-berry"";s:32:"7d6a7d2aac2891c01a064ac37c1783f1";s:19:""mornay-sur-allier"";s:32:"789f843f810c0e8c7a3341561a98542f";s:15:""morne-a-l-eau"";s:32:"6e61955e1e14d11579d1dcefc9bdb581";s:12:""morne-vert"";s:32:"7e9a3b4cbda75c3f60b956c1c9338f33";s:9:""moroges"";s:32:"b0b68b97403699d9d4aae58399cf3677";s:10:""morogues"";s:32:"d5cf4fdc152596ee96090321843a3787";s:12:""morosaglia"";s:32:"8e14674b06ea6996eaf2995e77687b7b";s:11:""pothieres"";s:32:"26007417bf8588dace4cb1387c872b1f";s:7:""morre"";s:32:"d5f84bf3ded3d8ff85dbcc246ae3879d";s:12:""remaudiere"";s:32:"b18bc85877741d2a42fc32ab59968323";s:9:""morsain"";s:32:"f7b185ece88dd2b355f55606ec88660e";s:9:""saivres"";s:32:"7da896cf2afe03baf3cabaab77cd993f";s:10:""morsains"";s:32:"6414df3998069523190306c193d13d68";s:12:""morsalines"";}s:6:"fields";a:854:{s:32:"13d5dafacfe124c0fdbe732171b58c09";a:2:{i:0;s:20:"`Departement`.`code`";i:1;s:49:"(CONCAT(code, " - ", nom)) AS `Departement__lib`";}s:32:"3634202bab22e2a50f7fa23214f6b71d";a:14:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:24:"`Departement`.`tourisme`";i:10;s:20:"`Departement`.`img1`";i:11;s:20:"`Departement`.`img2`";i:12;s:20:"`Departement`.`img3`";i:13;s:49:"(CONCAT(code, " - ", nom)) AS `Departement__lib`";}s:32:"26b854aececdcc92884bb15e85b005db";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"c2b5dea3860db439a0511fae9f642b65";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"526ffafc6733fa0a4902117b997326fb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((47.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d4540bbbc13625b0d369fa49495a04c3";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:195:"(((acos(sin((47.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d6030f7a5bec8bfe753bc4db340ccf32";a:3:{i:0;s:272:"Etablissement.id, Ville.nom, Etablissement.adress, Etablissement.rs, Etablissement.partner, Etablissement.img, Etablissement.cp_ville, Etablissement.pets, Etablissement.slug,Agregat.id,EtablissementKeyword.*, GROUP_CONCAT(Keyword.lib SEPARATOR ", ") AS motscles, Keyword.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"eb6fb1782adfc6d8a8864d3f32dab591";a:1:{i:0;s:20:"`Etablissement`.`id`";}s:32:"dd08a8531e9f680ecbf27f45e43f296f";a:3:{i:0;s:27:"`EtablissementKeyword`.`id`";i:1;s:41:"`EtablissementKeyword`.`etablissement_id`";i:2;s:35:"`EtablissementKeyword`.`keyword_id`";}s:32:"c6852640fcf038dc2e7ee42c8b6c4097";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"82d10fc6e09b811b7dcf6bf89a807e6e";a:3:{i:0;s:353:"Etablissement.id, Etablissement.equipements, Etablissement.modified, Ville.nom, Etablissement.partner, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug, Etablissement.img, Etablissement.pets, Agregat.slug, Agregat.lib, Agregat.imgCat, Agregat.lib2, Agregat.libRech, GROUP_CONCAT(Keyword2.lib SEPARATOR ", ") AS motscles";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"4f4e56fa1b375ff739b6552ad033989f";a:6:{i:0;s:14:"`Keyword`.`id`";i:1;s:15:"`Keyword`.`lib`";i:2;s:16:"`Keyword`.`desc`";i:3;s:16:"`Keyword`.`view`";i:4;s:16:"`Keyword`.`slug`";i:5;s:19:"`Keyword`.`created`";}s:32:"68d6b8f992de5d53d2bad0ff4095c49a";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"9b6b899043e0181290a8dbf7d5f83864";a:3:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`slug`";}s:32:"eb6fd2c106f938179da639d0a5eb64fc";a:3:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";}s:32:"4dd95e1358f85bc94929cadff5efdd4c";a:7:{i:0;s:10:"`Pub`.`id`";i:1;s:13:"`Pub`.`title`";i:2;s:12:"`Pub`.`link`";i:3;s:11:"`Pub`.`img`";i:4;s:14:"`Pub`.`height`";i:5;s:12:"`Pub`.`view`";i:6;s:16:"`Pub`.`view_max`";}s:32:"41b596e56307663cfacf0e01899407b1";a:2:{i:0;s:16:"`Lien`.`libLien`";i:1;s:16:"`Lien`.`urlLien`";}s:32:"8ee4e381878886a74715e50c607da897";a:60:{i:0;s:20:"`Etablissement`.`id`";i:1;s:23:"`Etablissement`.`siren`";i:2;s:20:"`Etablissement`.`rs`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:21:"`Etablissement`.`img`";i:5;s:21:"`Etablissement`.`pdf`";i:6;s:21:"`Etablissement`.`lng`";i:7;s:21:"`Etablissement`.`lat`";i:8;s:22:"`Etablissement`.`desc`";i:9;s:28:"`Etablissement`.`historique`";i:10;s:26:"`Etablissement`.`chambres`";i:11;s:30:"`Etablissement`.`restauration`";i:12;s:27:"`Etablissement`.`situation`";i:13;s:25:"`Etablissement`.`parking`";i:14;s:30:"`Etablissement`.`animauxadmis`";i:15;s:29:"`Etablissement`.`equipements`";i:16;s:25:"`Etablissement`.`langues`";i:17;s:24:"`Etablissement`.`tarifs`";i:18;s:28:"`Etablissement`.`supplement`";i:19;s:26:"`Etablissement`.`capacite`";i:20;s:26:"`Etablissement`.`categ_id`";i:21;s:24:"`Etablissement`.`adress`";i:22;s:25:"`Etablissement`.`adress2`";i:23;s:26:"`Etablissement`.`cp_ville`";i:24;s:20:"`Etablissement`.`cp`";i:25;s:26:"`Etablissement`.`ville_id`";i:26;s:21:"`Etablissement`.`tel`";i:27;s:27:"`Etablissement`.`telecopie`";i:28;s:23:"`Etablissement`.`email`";i:29;s:26:"`Etablissement`.`site_web`";i:30;s:25:"`Etablissement`.`partner`";i:31;s:27:"`Etablissement`.`full_desc`";i:32;s:21:"`Etablissement`.`fin`";i:33;s:22:"`Etablissement`.`view`";i:34;s:32:"`Etablissement`.`departement_id`";i:35;s:28:"`Etablissement`.`agregat_id`";i:36;s:22:"`Etablissement`.`pets`";i:37;s:26:"`Etablissement`.`horaires`";i:38;s:27:"`Etablissement`.`date_call`";i:39;s:32:"`Etablissement`.`recall_creneau`";i:40;s:28:"`Etablissement`.`convention`";i:41;s:33:"`Etablissement`.`convention_text`";i:42;s:33:"`Etablissement`.`convention_date`";i:43;s:29:"`Etablissement`.`financement`";i:44;s:34:"`Etablissement`.`financement_text`";i:45;s:34:"`Etablissement`.`financement_date`";i:46;s:27:"`Etablissement`.`direction`";i:47;s:32:"`Etablissement`.`direction_name`";i:48;s:33:"`Etablissement`.`direction_email`";i:49;s:32:"`Etablissement`.`direction_move`";i:50;s:32:"`Etablissement`.`direction_text`";i:51;s:32:"`Etablissement`.`direction_date`";i:52;s:32:"`Etablissement`.`recall_travaux`";i:53;s:32:"`Etablissement`.`recall_maladie`";i:54;s:30:"`Etablissement`.`recall_autre`";i:55;s:29:"`Etablissement`.`recall_date`";i:56;s:29:"`Etablissement`.`observation`";i:57;s:25:"`Etablissement`.`user_id`";i:58;s:26:"`Etablissement`.`modified`";i:59;s:25:"`Etablissement`.`created`";}s:32:"45aa8e323441f4a058f9507aa58c1170";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"5ef5376c23915b319c95a55e27b463e2";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"4e1a697404c869a9c03323a32603f511";a:3:{i:0;s:18:"`Comment`.`pseudo`";i:1;s:19:"`Comment`.`contenu`";i:2;s:16:"`Comment`.`note`";}s:32:"1cbe811be4bff73e7bbcc2dcfcc35e3c";a:1:{i:0;s:12:"`Question`.*";}s:32:"6322747d71d2e67fa56eb794b4a20519";a:2:{i:0;s:27:"ROUND(AVG(note)) as moyenne";i:1;s:21:"COUNT(*) as countNote";}s:32:"6c20e359124192a0c10f2b0c233a566a";a:2:{i:0;s:31:"ROUND(AVG(noteprop)) as moyenne";i:1;s:21:"COUNT(*) as countNote";}s:32:"9a6ee3dbbff9f4abcff6821e49e118a3";a:2:{i:0;s:32:"ROUND(AVG(notechien)) as moyenne";i:1;s:21:"COUNT(*) as countNote";}s:32:"8535a5c4969afd4eddfc4c8f9f64dbb6";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.425- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"192e21812b7edebf3315daa9aa4f77b7";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((43.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.425- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"831ae94deebfcb65f114246d9c84d96c";a:3:{i:0;s:20:"`Departement`.`code`";i:1;s:20:"`Departement`.`slug`";i:2;s:49:"(CONCAT(code, " - ", nom)) AS `Departement__lib`";}s:32:"6ebd007b29cf065d538dcc3a7c4187b9";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:37:"(CONCAT(code)) AS `Departement__lib`";}s:32:"403c6e660a82fa69b87a696f1c113a11";a:1:{i:0;s:37:"Keyword.lib, Keyword.slug, Keyword.id";}s:32:"f0d62901f76b5abe7816ad11f20cd1b3";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"eeab83cba95d4a0d201dbcb17f0e8d55";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"1b2c074bd5e2d269d177aa66ef6ab159";a:1:{i:0;s:24:"`Ville`.`departement_id`";}s:32:"ea0e1579f0e6d3ac7f276247b53988e6";a:1:{i:0;s:25:"`Departement`.`region_id`";}s:32:"a19d4800c9f2238632a000e2bbcbaf4b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((48.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a274b87f40c7238a33b6ce3879cd65a6";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:193:"(((acos(sin((48.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f003898a19527b234b40f1efff6e7269";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((48.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c77576aa7816342685391e259cb43f78";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((48.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4a217b2f5f874d86afa1709bc26a05f0";a:2:{i:0;s:367:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"357d5ff71e1ee8120bdf485204d1e496";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:189:"(((acos(sin((45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d8f12a0c33453862fad0e9ca9407316e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f36781e664b88e7a57aa671e99af2fd2";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:199:"(((acos(sin((44.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"750c6ac32de4f4bdb4fd3df1259c9da1";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((50.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5840b6f55ff4049051a90fd8edde9bec";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((50.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"528d0343d4b427a849a6727b7da3cee0";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ffdae9564025818447b1431e746c860b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((45.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1f5689aaa67a793f4d1a36fad848fe64";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"835895871f97d63ee39035a36c12a127";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bb28f004b551b22084c2eb4de9c75df0";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"85f2a1adeac1a16387ee1b535e09c06b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((47.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9d6e9d4aaec0d70f54c9f63be79fe8cf";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((50.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7daefc156df59759336e70ee74682037";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:196:"(((acos(sin((50.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"67ddf23300f5c2c8d50ca80084815ab2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8fc05fa3c7a6b48840b570dbf582f74c";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:199:"(((acos(sin((45.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8cca1e6186275ed4156bae91f9f41ece";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6087fb7d2c72c29e37a4e9e171615e0e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((49.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"73e7d0f5f27984cce7990cbb0411d922";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f0770b0d81f421e8b0b3b922cb7527d";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:200:"(((acos(sin((48.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cdb24ca79d29f57b9e917bac7f042dfb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"58774f2d894671fc2914b1dd35409ce6";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:196:"(((acos(sin((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c0e4839abec06df91285e23591ada508";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:202:"(((acos(sin((-0.577206*pi()/180)) * sin((Ville.lat*pi()/180))+cos((-0.577206*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((45.375- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"00df6b2113c2c37e3b13a46fd4ac7871";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:202:"(((acos(sin((-0.577206*pi()/180)) * sin((Ville.lat*pi()/180))+cos((-0.577206*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((45.375- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"bc013b7883512024414e377d97f654f5";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"a65ff2a25464afb8aa962a5b856ba406";a:6:{i:0;s:14:"`Agregat`.`id`";i:1;s:16:"`Agregat`.`slug`";i:2;s:14:"`Ville`.`slug`";i:3;s:15:"`Agregat`.`lib`";i:4;s:19:"`Agregat`.`libRech`";i:5;s:15:"`Agregat`.`img`";}s:32:"61ae4de0b32204c3b056d6e2623132a2";a:2:{i:0;s:14:"`Agregat`.`id`";i:1;s:46:"(COUNT(`Agregat`.`id`)) AS `Agregat__nbeEtab`";}s:32:"9845f7c8905acb48c1a4a156a5303cce";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((45.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.333333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8371c39bf3a3c0e75a1cb4207d1e3887";a:15:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";i:14;s:46:"(COUNT(`Agregat`.`id`)) AS `Agregat__nbeEtab`";}s:32:"0018f45d6fd9bb181e4e3003051d0c25";a:2:{i:0;s:22:"Ville.*, Departement.*";i:1;s:18:"`Departement`.`id`";}s:32:"1e155a7d44c4c6f78ed44ade8f64e39a";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"aaecd180c36f64cabe9c66e02e5b432c";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2247e2a10bfb4474de8e90bfa405a88b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d5638781010ac5cb06aa3ccfb4af2e51";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((45.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"216d827793891ce61c4325bf2071665e";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:196:"(((acos(sin((45.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2e04d6ec4fd41829867caee0eba0e97a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a23592f6161a1fe5777794d1796f1a59";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:196:"(((acos(sin((48.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b3da0ea01ce574bccfe64e98459aca3";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"269e400993b158d2137e6c4379fec0ec";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1c07a9fa7369777146902a1e9157cbdf";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"93e31def5db3941bf509841fdcc71b8c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e7d64c4a74c7a8b49b987b87769a9a12";a:2:{i:0;s:369:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"24cc078c0a8a41faf0fa257d16bd5a98";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:191:"(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.5'
unserialize - [internal], line ??
FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828
DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1174
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 76
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 112
Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/animauxadmis/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 174
[main] - APP/webroot/index.php, line 112