Notice (8): unserialize(): Error at offset 81880 of 81909 bytes [CORE/Cake/Cache/Engine/FileEngine.php, line 194]
Code Context
                $data = str_replace('\\\\\\\\', '\\', $data);
            }
            $data = unserialize((string)$data);
$key = 'myapp_cake_core_method_cache'
$time = (int) 1758098849
$cachetime = (int) 1758098859
$data = 'a:3:{i:0;b:0;s:4:"name";a:208:{s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";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:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";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:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";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:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";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:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";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:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";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:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"ffa9506a4511a7b9f744574dbdb4863b";s:5:"" - "";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:"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:"a82fe8f431f55ca3e5c6eeb1425d6fa5";s:16:"`Keyword`.`slug`";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"cc7a4a34d97ffbb85978393c1dc3d808";s:27:"`EtablissementKeyword`.`id`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"61eedb5524a37da074a515d3499b0fc1";s:16:"`Pub`.`ville_id`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";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:"9da1d158b7b3f5102350b7a469c676c4";s:16:"`Pub`.`national`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";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:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";s:32:"70a4a1faf343973daaf7a89bac3df075";s:27:"`Departement`.`nom_soundex`";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:"80394ea42cc6092bc2561cabcb740ec8";s:4:""54"";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";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:"2c5e9f52d960e90ec5f07551ed2997d9";s:21:"`Departement3`.`code`";s:32:"f0390fa2e07b4a53538ebc42c3a44987";s:15:"`Keyword`.`lib`";s:32:"002849c2354331d18dc50d9a58fb23c1";s:16:"`Keyword`.`desc`";s:32:"b2f06ded35217196d1e2063a349f01c1";s:16:"`Keyword`.`view`";s:32:"65fdef50318c78482920242502f98c10";s:19:"`Keyword`.`created`";s:32:"53ba12bfcc4a17ec6c1d401917cf8c91";s:6:"`view`";s:32:"dfbba30d1f72467a860b279eae73a5d7";s:9:"`nb_view`";s:32:"1d7e457219fc27e7fa343049f6f7f966";s:17:"`Pub`.`region_id`";s:32:"3d76684e59adcfb2f749d3850de858b5";s:8:""lugrin"";s:32:"e7c32d144dfbfdcc3f58ae21827b8236";s:14:"`Departement2`";s:32:"67aacecb01204237dc496f70dd03bb8b";s:19:"`Departement2`.`id`";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:"ca63792778e7aa577dc891758f6e9aab";s:4:""14"";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:"a5f99862c1d6ce49282e8b7cf63000d3";s:16:""arsac-en-velay"";s:32:"38910b5f5001b084555a03a28492bd94";s:4:""44"";s:32:"c5d34d422bdd2a29fe6a265a5d22fc99";s:14:""montmorillon"";s:32:"bca378769cc071b2dfd627a0ef0e2f0d";s:4:""87"";s:32:"38d14e7cb9815e8d6686effb032edc61";s:9:""salviac"";s:32:"b2cab17def5059198cb6e7ab58307282";s:23:""sausseuzemare-en-caux"";s:32:"7969ed293f44a9755d62b3a8b5635dcb";s:8:""hyeres"";s:32:"1bbd025fee9215ee8763f26b649c89d6";s:17:""st-pere-en-retz"";s:32:"364a65429ae8a2789c1039c541f2a20d";s:5:""972"";s:32:"286b81f44f14f8fcd93c35510545bf19";s:21:"`Departement2`.`code`";}s:6:"fields";a:215:{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:"414d959c5f8a76ac7b9bf40e70030f1b";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((44.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0c11feaa59ca08e022ac8420d7b3c11d";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((44.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.48333- 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:"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:"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:"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:"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:"974557f62d9b7f91cae30550b7055d4a";a:2:{i:0;s:14:"`Ville`.`slug`";i:1;s:13:"`Ville`.`nom`";}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:"aec2a629c478fa98aa85f470a7372bdc";a:1:{i:0;s:19:"COUNT(*) AS `count`";}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:"480640a02a190501e52f1904aa07bec0";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:25:"`Departement`.`region_id`";}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:"bad934152a3893ce697d571df8c49714";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((48.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e8fe9502629515bdf944f70346a5b0b6";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((48.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f0d62901f76b5abe7816ad11f20cd1b3";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}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:"b60bf98feba4fbf5d2fcbb19b2a14657";a:13:{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`";}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:"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:"15f5b560853d36b571c331578762ebe8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((46.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c54ffcbd886f8cd25629f716de25a700";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((42.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"acd0b94ec9c3db95a958b52cf8a6be3f";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((42.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"925d6815b3c2a1993e1c26eb80921f77";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((43.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1e99327dda71af8e7b79fecedb8ceae4";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((43.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"df4df5f9856e0260894272a9985ee166";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((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a056cbb3a87821f76be5f5fabf08eb12";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((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bebfdb350f42efdf3a0f3fe08adba202";a:2:{i:0;s:378:"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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*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:"1c605e47679818a31af6a7fd6b99237f";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:200:"(((acos(sin((49.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*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:"d645287614729f3e05ba2d6106f95d03";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((45.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9bdafee0747562f2b1b4220478692c60";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((45.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"90062cea99d34a63c278bf370c3451fa";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((45.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9e9c918ce629043794ca43aaf9f5c7b9";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((45.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"70a6441404d32a09a4e1f8b19072ab74";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((47.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a64d159e17ddf9fbbcbc892fa195e586";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((47.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9f1a1f55a1976ebb18787886521e8b5a";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((43.9664*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9664*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.79584- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"cd5e769338a4b175e7d6de496bbbff3a";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((43.9664*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9664*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.79584- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1e636f8b1dda6a9095a1ee6ad79d9297";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((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7f10636fec2b6189e2ece21af9b613d9";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((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a8f4c246f996baedd68b49b50139d4d8";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((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"777340fa38edc00b586fcd5117d2536a";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((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ad2d4adf5c566634ec16d3fc106f136d";a:2:{i:0;s:379:"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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.216667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ec9f6224827e5a06aa17e26faf82181b";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:201:"(((acos(sin((43.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.216667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ad1e347a30bc374542314294f89ce64b";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b34fb61eb3e1265f07c347d6cbc8a56f";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"add5cc7a034191632220cb6f865de045";a:2:{i:0;s:378:"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.7955*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7955*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.14778- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"606c53ad7a71814e5a65900d2bf16b65";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:200:"(((acos(sin((44.7955*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7955*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.14778- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e76545568ad0546039b8758c8454497d";a:2:{i:0;s:376:"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.3818*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3818*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.5052- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"57905a0785027756e332bfe068d150cc";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:198:"(((acos(sin((45.3818*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3818*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.5052- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ad0ae1a1808eb8f0dd588e9cdd589fae";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((43.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"18e69feebf1e75112d12dd3cb7a35a66";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((43.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2de016adda7b300ad90a8d33cba65325";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((46.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e16fb996639e418a2ccdb6c6724df130";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((46.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9159377895436cc6a2d2bb4ae0299a91";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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b686499a849f707dd567ee2695555bca";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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a17acdee22c1e5aea40a91071452b9ed";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((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5b260d29f1ce65e13f96df9d4775b00b";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((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c8651d11754a9ec3cbb653b85e9ac64a";a:2:{i:0;s:368:"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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d97fd912acc5505d4843d2ed3f9a1f4e";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:190:"(((acos(sin((49.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c85803e7a4a94b198a88b0f58850fa36";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((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2cf2c2c5582cf582f0981308dd206cd7";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((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"66f42c3f73853c7a481340dd1f0a8ca2";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((44.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0103df41ac439ce707a2e1f9a9f37bee";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((44.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c91dde1a9114303e7b64a4480f2e563f";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((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"602e67382f816fbca957e205397ef16f";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((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5b6422546aa3394d8a37824444df5ed6";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ae4f58342811557700c908592a7995ae";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9c7f729caf5b32383845195c5e21c732";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((49.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8dbb177a6ed520cea06b7c4182ed95b3";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((49.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a69e1f7d6cdc763dd41612a24a2e87b0";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((43.4339*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4339*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.73611- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e613a503e77eb7c50118462f884e1559";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((43.4339*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4339*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.73611- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6cbfeba9c7b635365fe28aa23dc9e4ce";a:2:{i:0;s:368:"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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"fbb83c81de6b2cb05d0c94d8e3062414";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:190:"(((acos(sin((49.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e69766d8921bc56bf8cddb3c8925e761";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((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c358f539aec370d2333c9e86458000f9";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((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"44764aa1cdb790f6cca61bcbfda98f1c";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((44.937*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.937*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.60889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5ca188f12e1574ee6d82d47f95b36b5d";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((44.937*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.937*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.60889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9e06d3764f7ce47e26e55032dc882b7b";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((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f74af5250101de424296b7bbbad3e551";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((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e574cf8798345b40781881c0269a4e2e";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"340cfc982766299c7b6ff410304be952";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"da55128643db7b3286f2d4452c844a52";a:2:{i:0;s:378:"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.6589*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6589*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.16355- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4371e171badc240c0a38932f80fe4881";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:200:"(((acos(sin((44.6589*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6589*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.16355- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2586d2c2f0b18823d3bfd7616652a4ab";a:2:{i:0;s:372:"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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0025392ec74a7518734c6569ce35279b";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:194:"(((acos(sin((43.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*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:"0ee82f3f7524f49867514e2f6f311dc9";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"19cd765d45ffe0a77469673579c6617e";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"91ba4118d80244fc83aa54573f31d352";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0e95159909c2e25f577f26e2c0db37da";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b2d145b2a2718fc90a9b2c3230337531";a:2:{i:0;s:372:"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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"311f4a85ef1210b2da77e064b3e753cc";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:194:"(((acos(sin((44.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"98171ea51b24875ecd6e377f2d378788";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((50.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"01f4a029cefbdf0784744d908e48798a";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((50.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"84b1da920b269072aabecbf38155626b";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((45.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8feaf9b43c6247381a4efa58852c3a12";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((45.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cb18bdeb964b34ec54df52d56fac873c";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((44.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"63c934dc1222f062ef758eb049955a8c";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((44.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c6217f011d3ef89b170d83c9b9747f23";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((45.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f24ae51b8de80e94ef3a9f6cf468c417";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((45.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a7ae1a84c9417d3bb856d5301154b3c8";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((44.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"924bb7b5d7f04f66a1ba39024e7f43ae";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((44.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26b854aececdcc92884bb15e85b005db";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"da426236068e6e47f5a58b9c9e89f2f4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"69343e099fd8d06e3e89fed899b02ff2";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((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.95- 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:"c9fa0a93a64bf7542ce29644ef572252";a:2:{i:0;s:372:"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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6eb7973852cdb26f16e45ac72a531c7c";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:194:"(((acos(sin((44.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4ec970045d73cf0526dec585a6b50a66";a:2:{i:0;s:378:"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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"01b47cbbb41c7c7068eb375eb45fccc8";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:200:"(((acos(sin((43.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8167*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:"0d76b3dc1c7ff41b9581cbf8fac9aecc";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((43.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ae873d0b6301fbb88b9a33fa9364d012";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((43.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3576bf998673c7e77bf676e06e548c32";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((48.86*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.86*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.34445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5531d13c243fb3d5c0ab5b70b7782db1";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((48.86*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.86*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.34445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"951f196fd4103f65b20daa321639819d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d8470784ad6e362dc5ad4dd61c697921";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((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"90d28ec602ba0ee245f1be78179be7cb";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((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1c78671e3418c3e5085c9916543ad289";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((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a841713b86dd82c2be9d2b70ee5a96b4";a:2:{i:0;s:378:"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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0b4512fca7bdbf7b09446411ab6fd584";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:200:"(((acos(sin((48.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"020661b5a4d2fb7d0c77343e315bf1ce";a:2:{i:0;s:372:"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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"aca93aca2f62df099a89e2533a9c7749";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:194:"(((acos(sin((47.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ed098a58e8dd79e4396294c7f8dfb6b9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8e45f199a56b18ca5a838d1e6e1856db";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((49.6659*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6659*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.342778- 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:"5c3f366d6da35ef99ca32c8af0c74224";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((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9107a6f2c7afdc97984276f889f8bf26";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((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"524e90e944c59197d6a94d22ba9d59a3";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((44.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.816667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"035bd095fa736e0ad83e3f638c127e8a";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((44.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.816667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"69593095b1284bb7160dc52b65cecf0e";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((43.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e415cd13ea95eaf9cc82d23853e51bd9";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((43.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8ed64d020fd95712b2f07e164a5932a9";a:2:{i:0;s:376:"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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.079- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a7889b6db20f52c7b98d65798c5252b3";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:198:"(((acos(sin((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.079- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"89f99232bf8e82c84d512b373ebbe69e";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((46.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ef6466999327bfd429747bffed7fe476";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((46.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8833*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:"0ab0184c9b62a7b48e26c57a7a365f3f";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((44.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4fda3b8a6bf1a3193ead82f8afe65868";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((44.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6167*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:"82f1ee2e4fb492b46aef298525c0541e";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((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f05dc24f8ba7bda90ca6aab255b63734";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((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5be7dc27bfcbfee59d2d2cfbb1e58334";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((43.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ff67c97ee96174ef136273cc4b6df43c";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((43.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"59447dfae6cf13c85a02b9395f4e99be";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c965d71a03cc873f82407d5ba11ab7ea";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ce81fd93bd9a60d99de5c507f42222ff";a:2:{i:0;s:370:"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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6a1aaf0ceb23559e9b1ab38bc1735536";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:192:"(((acos(sin((43.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.65*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:"888125fde83d05dd928e885caa535afe";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((47.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"db4d2cb265726b68e0c67b602cd3cd52";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((47.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"49c65937e5af676906cf35d5d2c0962a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ae32567345170659c0294e4b7a72ba49";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((45.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.575- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3dbaeb2837d07560ee9e8a88a6e78d07";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((45.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.575- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cc021d06b2ec748d096914d6d5fadf74";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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8b5d2013cdca809ed49581e4134b20d1";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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"060e1524d11975c4336a1356a'
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]
Code Context
            setcookie(
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1758056849,
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)
$name = 'CakeCookie[autologin]'
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

Hôtels

Animaux Admis > Hôtels > Hôtels Die

Hôtel des Alpes, Die

87 rue Camille Buffardel
Die (26150), france

• ⭐⭐⭐⭐⭐

0 avis

ajouter un avis

Hôtel dans la ville de Die, l'établissement Hôtel des Alpes ne nous a pas encore indiqué si il accepte ou non les chiens.

Tarifs

Non renseignés

Nous Joindre

+33 4 75 22 15 83

Hôtels à proximité

Hôtel-Restaurant l'Escale de Die

Die (0.00 Km)

Hôtel-Restaurant le Touron

Chamaloc (5.71 Km)

Hôtel-Restaurant le Relais du Seillon

Montmaur-en-Diois (7.53 Km)

Hôtel-Restaurant Auberge de l'Eau Vive

Pontaix (7.90 Km)

Hôtel-Restaurant Le Bistroquet

Châtillon-en-Diois (10.84 Km)

Hôtel-Restaurant l'Aubergerie

Barnave (11.12 Km)

Hôtel-Restaurant le Mont Barral

Treschenu-Creyers (14.85 Km)

Plan

Photos

Poser votre question ❓

je suis le gérant de l'établissement

Hôtel des Alpes, hôtel à Die

---

En savoir plus sur l'établissement

Langues parlées

---

Avis Hôtel des Alpes Die

Actuellement 0 avis. Vous avez apprécié cet établissement ? Laissez-lui un avis !

Qualité / prix

Propreté

Chien / chat

Avis Clients

Pseudo :

Notes que vous souhaitez attribuer : Qualité / prix ★ ★★ ★★★ ★★★★ ★★★★★ Propreté ★ ★★ ★★★ ★★★★ ★★★★★ Note chien / chat ★ ★★ ★★★ ★★★★ ★★★★★

Antispam - Combien font 7x4 (en chiffres) :

Avis sur l'établissement :

---

Questions des intéressés

Hôtel des Alpes répond à vos questions

Question :

Si besoin, vous pouvez développer votre question (faculatif)

---

À proximité de votre hébergement de vacances

Quelques activités, lieux touristiques ou d'intérêts dans le secteur de Die.

Montagne du Glandasse (0.00 Km)

Die

Temple de Pontaix (7.90 Km)

Pontaix

Gorges des Gats (10.84 Km)

Châtillon-en-Diois

Visite de chenil avec Kiska (14.82 Km)

Vassieux-en-Vercors

Vallon de Combeau (14.85 Km)

Treschenu-Creyers

Claps de Luc et Saut de la Drôme (16.48 Km)

Luc-en-Diois

Réserve naturelle régionale de la Grotte des Sadoux (17.49 Km)

Pradelle

Animaux Admis, l'annuaire qui a du chien

Flexible

Site optimisé pour être consultable sur tous supports : téléphone, ordinateur, tablette.

Mise à jour constante

À la demande du professionnel et après confirmation, la fiche est mise à jour.

Présence sur Google

Avec une fiche bien présentée vous augmentez votre chance de présence sur Google.