Notice (8): unserialize(): Error at offset 139315 of 151215 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) 1762843011
$cachetime = (int) 1762843020
$data = 'a:3:{i:0;b:0;s:4:"name";a:376:{s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";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:"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:"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:"d88c945e9fb176ffc35aa4919f0272f8";s:4:""37"";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"e7c32d144dfbfdcc3f58ae21827b8236";s:14:"`Departement2`";s:32:"67aacecb01204237dc496f70dd03bb8b";s:19:"`Departement2`.`id`";s:32:"286b81f44f14f8fcd93c35510545bf19";s:21:"`Departement2`.`code`";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:"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:"3c3fdb23b55f12b95d324f0a1b60baf2";s:12:""st-etienne"";s:32:"7142166d1e9021c22af48d53bc32d9e5";s:4:""43"";s:32:"ff12387e84a1ed3409d5eb85685f4e8c";s:5:""974"";s:32:"4cf5885e3b2f87363c61ddbea1af078e";s:9:""issirac"";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:"63aaa4deeb1e87bc50820ca379ccada8";s:11:""vincennes"";s:32:"500b44668388400d9e819aec0bbc4398";s:22:""pontailler-sur-saone"";s:32:"1a3f2bcde88d4e437423c4ebca22dad0";s:16:""vergt-de-biron"";s:32:"79e3a6cda0617e8818b5571ace1a1c92";s:8:""beffes"";s:32:"ebfeb5677a2422a6ec4713638a443288";s:12:""marigny-03"";s:32:"83b124ee5eee987da3daa909880a7591";s:20:""st-germain-du-bois"";s:32:"78c90fb488b08426a7fb31fbe21083b5";s:12:""malzeville"";s:32:"eeed54be9320f7f7564285facf130a30";s:9:""mirande"";s:32:"3860a9079daf05c1dddb1a98962b798c";s:11:""sombernon"";s:32:"81d991b6893ef5ff3f56d5e11f7c4d77";s:11:""courpiere"";s:32:"c998f57c55a8914e440ea85b6681d6a7";s:13:""forcalquier"";s:32:"1b58ebd6c5864b15be100fe8ab97df20";s:10:""grolejac"";s:32:"758d8a5918184594e4049de421d3c9b8";s:14:""cormontreuil"";s:32:"5fa76f484331af228a8d20e273748106";s:12:""buzancy-08"";s:32:"b97f0742eaeae205067c3433726c94b3";s:21:""chatillon-sur-loire"";s:32:"f0c64affdd48071e38f645b23d7a3b08";s:25:""st-nizier-sous-charlieu"";s:32:"bb4f5604980978db33633b6bc24f8757";s:11:""maubec-84"";s:32:"985cad1d2a09d3d2a3aa0a5428a35c13";s:11:""rignac-46"";s:32:"b70599f60de47c57f33ef85b6094b3dc";s:9:""chenove"";s:32:"7f529c3405148ad45516d3c6b86a79f9";s:19:""althen-des-paluds"";s:32:"886423740953224daaec7a51af3b02be";s:26:""longpre-les-corps-saints"";s:32:"83e65744b199ecc06b97ee6333341449";s:8:""pinsac"";s:32:"460b81a41e5f4f67b0115c03aa121e18";s:7:""cudos"";s:32:"bbe8808493100ee1f3d31558176acd21";s:12:""saussignac"";s:32:"964f10fb3084bad64e9676e5d848e7ba";s:7:""poulx"";s:32:"fe8c600af18b51a119d969cda63665ec";s:7:""agnac"";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:"2550dd3024a2666f5337036fe5e1ca3e";s:16:""st-cyr-sur-mer"";s:32:"fdb204524e6231c6606712ff78ff4f79";s:4:""84"";s:32:"427d1c82d239efa5e07f405ee81d7a83";s:10:""marmande"";s:32:"ff8371aa13cac58380203d86ccfb828c";s:22:""serres-et-montguyard"";s:32:"2d959bb5eb5c2da33fa86a8bdc8a4028";s:10:""renaison"";s:32:"2806d64956bc94e715e1d5ef2e22b801";s:10:""pompogne"";s:32:"a8f106ac75b822c2e9b110b655971def";s:7:""gorze"";s:32:"b20f8c8907ca67122d227a84624b83b5";s:24:""leves-et-thoumeyragues"";s:32:"73ce9da22d249b150f9a4791e197bc94";s:10:""lespugue"";s:32:"b1f3a1dbf31c50c535ee3d90876b6d47";s:14:""fontaines-71"";s:32:"7ef983ce35d8c7b936cadaac0a3ee3ea";s:8:""paunat"";s:32:"2ca218cf3b1315f74dc790810c04f8ff";s:18:""villes-sur-auzon"";s:32:"4151bb6789ac822fb0cf8291637cca66";s:19:""louppy-sur-loison"";s:32:"da1469b73d0cafe81550dad1275d2061";s:25:""montferrand-du-perigord"";s:32:"5db4f6901a1d77519c3411f89d9c5639";s:18:""nuits-st-georges"";s:32:"3a3d58757e64cf49b9cb05db1cd0b572";s:15:""bar-sur-seine"";s:32:"30753b48a6759f6d787ca3f6bd0754a1";s:12:""naussannes"";s:32:"aa141f10c5c4a9a1fae4b80a5a3a413d";s:11:""peguilhan"";s:32:"7ba0689641733921a3c9d15581529200";s:19:""fare-les-oliviers"";s:32:"a29b93b7e741affefb7403c79ac10c40";s:9:""diou-03"";s:32:"1d9e132ce15974fe94683aa0071cfeb8";s:7:""aubas"";s:32:"bd236692329a7ae06d485719ccd5a5af";s:18:""aulnay-sous-bois"";s:32:"63edbfde51be5ed004122640faffa115";s:10:""belleray"";s:32:"6a49989f617b2f76ca658baab16a0670";s:8:""pezuls"";s:32:"5a8c238e0a60d7acebe7eb9c393f1e1d";s:7:""duras"";s:32:"6f0b57235aae8459328550f0b06f17d2";s:10:""chambles"";s:32:"7869ff86b5a40ca705cd1659a8d32884";s:19:""pouilly-en-auxois"";s:32:"a915aa55931c72bbc68ae2b2eb7a464d";s:18:""lachapelle-auzac"";s:32:"b4f9d32caa1a92cb626aa21a46b360fd";s:13:""estancarbon"";s:32:"79d287993460c839167eb9bb9d448790";s:12:""labatut-40"";s:32:"46285367973c1d568ab8b875167aaaf5";s:4:""41"";s:32:"686848599cf439f80393394ef056f762";s:10:""graulhet"";s:32:"4f9cd7d551ea5f6145781cf46d186558";s:4:""82"";s:32:"859c82098f993dcbcb78a7c2e9985800";s:19:""st-bon-tarentaise"";s:32:"a1ac42450bd1111d8370fb8428a1ad1c";s:4:""74"";s:32:"065b532204955f36b23cb50ca4138922";s:14:""mazet-st-voy"";s:32:"f9fca61f0549759aaec1b243f4f0bb42";s:12:""francheval"";s:32:"609d2fd9a440e715d7f740b740e56c83";s:9:""doulcon"";s:32:"663d79ca8b5b680dd59c231f54a0dcea";s:13:""longlaville"";s:32:"138b52710a52582054a4004504aaefa3";s:9:""durance"";s:32:"5fa9a8a5ecd74df6933caa7df906e8be";s:17:""lancon-provence"";s:32:"14f045e811a5c0a3035938972109e8d1";s:18:""ouroux-sur-saone"";s:32:"c17ef622158fa59e053f001f3a032486";s:8:""dornes"";s:32:"b37b8663017d7bed1af96fabe8173d38";s:7:""dijon"";s:32:"651ac193e65e801cf6361e57251d509d";s:15:""bois-colombes"";s:32:"70975384de7ade27876f66302414fd89";s:20:""argent-sur-sauldre"";s:32:"92adf2b3d949756e20ae1ecee082fe70";s:18:""champs-sur-yonne"";s:32:"959ed1d5c2b8d0730cc893f72927236d";s:15:""vollore-ville"";s:32:"92fa53994c317829fd995bd547f544f4";s:7:""gagny"";s:32:"d5ff92b8a6a9e36e2544d93e2d97f2b9";s:7:""gorcy"";s:32:"b738af28547bce3dc365d862989d42c1";s:15:""berre-l-etang"";s:32:"4bd13506a52fcf07976a7ca2b7a639ce";s:19:""salles-sur-verdon"";s:32:"24bc40806e8ac81c904d4eaf9d6f7cfa";s:21:""belves-de-castillon"";s:32:"c71544f1e90901fbf05e8b3d7664f97a";s:10:""claviers"";s:32:"8bf6a40ed60410ac43c281af5b774b0c";s:9:""doudrac"";s:32:"19813f47f581549f809bbe63f631de7f";s:12:""courbevoie"";s:32:"f9241a3f7c04a14abc347a5888b162cf";s:11:""langon-33"";s:32:"8c42d25f2ac638149e92b84c68a1cd25";s:22:""argentiere-la-bessee"";s:32:"f83a1a588b764e0e6430e75275e56493";s:10:""cales-46"";s:32:"a70fd85f44ef3adaaf4b11bd7d1a930c";s:19:""vigneux-sur-seine"";s:32:"475dea8c9e4bca1080038de0a4b45d5a";s:10:""envermeu"";s:32:"972c3ff8a857ea57307302ca53f9d324";s:10:""billy-03"";s:32:"c2982036b49e4806afcdd78b66cffa61";s:4:""83"";s:32:"a4bd7da6aa3994b44d64fcfd438ac2d8";s:11:""villerest"";s:32:"f30fafa39b55fc9fa077242929ac7fdc";s:13:""molieres-24"";s:32:"f07ecb05c9502f5be0c843ec290a759a";s:9:""fleurie"";s:32:"10ac0397f4c1994e1bddd067f10f9343";s:12:""courthezon"";s:32:"a80f611d88d9e1f2101e617cecea78f8";s:20:""venarey-les-laumes"";s:32:"ebd1b88a22c4243a52080fc45da72a60";s:8:""raincy"";s:32:"24890b4f39ae823cf149e4553284225c";s:19:""mayet-de-montagne"";s:32:"823e057842e3a22eb77021b594c10b61";s:9:""nemours"";s:32:"2cebe0fb0a2c5f2f49f89b39672fb0a3";s:8:""carlux"";s:32:"ec292d72d14bea587f549b49e68a6b6b";s:11:""lavaudieu"";s:32:"582306d1d42f7b35e476d481c65d9e2c";s:7:""boutx"";s:32:"bc04db93c1e76491a0150fde87b4e127";s:9:""firminy"";s:32:"39912510f7ff2a33d81a5549ae248227";s:11:""nadaillac"";s:32:"1f07e09417f4b3c4a6fd97a7e79114ad";s:18:""izaut-de-l-hotel"";s:32:"1edfc990fa02fb80143d7970beaea8de";s:8:""mornas"";s:32:"832be802bcefc3190802451f7fbf2136";s:11:""lourmarin"";s:32:"e2bb9d4c5947a1923afe7fd33d420efa";s:8:""renwez"";s:32:"414ec3f6171abe286067466b8bd9b8e6";s:12:""acheres-78"";s:32:"18035ec0faf1fefbcbf3244d8265fc3b";s:19:""sauvetat-du-dropt"";s:32:"b08b075603c6b33d6293d3bd484ddbc3";s:7:""orgon"";s:32:"36d4e57b1e420d1ee6a8e48ae7ecd56c";s:11:""vermenton"";s:32:"1b9d8aa597fcf8792c6610818b7de13b";s:11:""lougratte"";s:32:"aa9d8a2633667025c1e2b7bc9d261cee";s:7:""miers"";s:32:"46e0a8cb75cfd82e157a037097a5465b";s:11:""abbeville"";s:32:"77310d3c1e1969573931b48622fd14ba";s:10:""st-satur"";s:32:"eac2e47603915c02a52cc88d4ff2109f";s:18:""mazieres-naresse"";s:32:"b45f93b2a7d4d7bbf766e2447ffa5eec";s:19:""blangy-sur-bresle"";s:32:"84a7862b1ff6d66b35c8c4f2e89ac14f";s:22:""boulogne-billancourt"";s:32:"ad958b794cd34c80de0c64ad6f93dbde";s:16:""mas-de-londres"";s:32:"32d2f35e64508bef6ec8d638d72940e3";s:12:""charavines"";s:32:"350df01e677bc5e8dd3bc68af78b589e";s:4:""39"";s:32:"dc22fe3c1ec55a2edb2086efd4271ad8";s:4:""57"";s:32:"b0f717130e9a1666f51033857056dd68";s:12:""st-avertin"";s:32:"8f4f7252001b87bb9ebc001ec6ba70a6";s:4:""38"";s:32:"03c00f4c28ceefd035166341558699b5";s:7:""berck"";s:32:"2e8aeb6e9e452fb91071364b9ca932d1";s:9:""salbris"";s:32:"c56d6db3c4b7dc82cd351cd8d868f51b";s:18:""nonsard-lamarche"";s:32:"89c4327e3f31819c633bf3808446196a";s:8:""rimons"";s:32:"d26d9ec6965aa63cae0f77c077830cd6";s:10:""montbard"";s:32:"9bb6b737ca39dcd12b311d04f0463cfc";s:11:""prudhomat"";s:32:"348e74d13c4c05f5f09d7802dbd272a9";s:10:""nanterre"";s:32:"0140cd117f169b058e27929d95f53422";s:9:""varages"";s:32:"14ad8151e7ebf40c3c16fb8cbf585d43";s:15:""montdidier-80"";s:32:"11037ab85bc47bae945f546da31dc0cf";s:9:""viarmes"";s:32:"3a161e3398b4f95450f2501913df367f";s:12:""belleau-54"";s:32:"7731f0e297f1362372b28d463e2da395";s:21:""friville-escarbotin"";s:32:"eba79deae6f5f5bc4221a76741b7f291";s:21:""montagnac-montpezat"";s:32:"9d55d1c904dd98f6f152ab7fe6908403";s:12:""ste-savine"";s:32:"9c402285b2b5927c7910cf1ee05b362f";s:12:""lacoste-84"";s:32:"9280bc01c178c9071961099094ced9d0";s:7:""mazan"";s:32:"24f1e875d1a8b73886eadfe12252ce4c";s:10:""puiseaux"";s:32:"4b4041970a6b1e5143935a78e39624ff";s:11:""boisse-24"";s:32:"efab4df9b8f3e43f26429449f74f9fd5";s:23:""courson-les-carrieres"";s:32:"7317bedefff4e21afc013b54d79b8863";s:10:""malvezie"";s:32:"e2d43202548e37ac97541a70f5a873af";s:9:""thionne"";s:32:"01b1f88d852c1eab2146540107201997";s:9:""etretat"";s:32:"4da46d883a08a418007f6ed9a354c08e";s:20:""maizieres-les-metz"";s:32:"b85354a81bf0cbe405d9ed93fd59cf16";s:8:""dieuze"";s:32:"bc2474f46bea8fe05da50ca155a677af";s:12:""montbeugny"";s:32:"24c75885709cfdcf8572cb164e6e8399";s:8:""callas"";s:32:"aa0227d30c4be59d25adbe2b0021e964";s:7:""barie"";s:32:"e8efcdf44d7d7b21e7a957d63bee7bd0";s:12:""beaupuy-47"";s:32:"7ec2e25b38d0ff85048494aa141db966";s:12:""creysse-46"";s:32:"aa769831ee499151db33ed5e59d36bd2";s:12:""talaudiere"";s:32:"3b250af33f1f4f1b9edc90d4136a3768";s:8:""vedene"";s:32:"6b211f5c8a00ba4137eaec57969a292c";s:16:""menil-lepinois"";s:32:"4b528d30bf4dfdf038409d8414508757";s:13:""montfermeil"";s:32:"6fcd24fd4e1059173482fa484d30617d";s:25:""eyzies-de-tayac-sireuil"";s:32:"cc97d7527faf988825e3dfbc781d9ad6";s:9:""aigueze"";s:32:"e028caecbfe8313cefe41f7c03faee27";s:9:""collias"";s:32:"8080d732f643332ff507f8e51f013a29";s:9:""miramas"";s:32:"e259649a8c267c6426a6074c82c11cdd";s:10:""renneval"";s:32:"7b19146d7a666e13eacee32f0f6ea03f";s:14:""livry-gargan"";s:32:"9489a9ebe070aadcafed18e754fd3625";s:21:""ruynes-en-margeride"";s:32:"1b71cb263e9af8b7db903b7d442cb23a";s:12:""pardaillan"";s:32:"91a46b5a2f621eb48d8c9796986778d7";s:15:""beauchamps-80"";s:32:"db7942bb7c644fbb61b73e0296733fa8";s:18:""plessis-robinson"";s:32:"c42a7bf2e25918d4cec81d7183d1705b";s:10:""bagnolet"";s:32:"ae464d2fe54328c181fcc0e88255834b";s:11:""mouzon-08"";s:32:"9f7076f85a75aee40ce84e5fcb228599";s:10:""beauvais"";s:32:"e671b583c45063c35766091e5caa615e";s:10:""tremolat"";s:32:"9b7d36aa9e024e9ec7c44077811b7b9a";s:18:""dammarie-les-lys"";}s:6:"fields";a:358:{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:"b693d78dcd360b0b141bc28405e2b0a8";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((-61.5066*pi()/180)) * sin((Ville.lat*pi()/180))+cos((-61.5066*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((16.2669- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6925df3c6a3a9e3eb47bb844b7ecdd7e";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((-61.5066*pi()/180)) * sin((Ville.lat*pi()/180))+cos((-61.5066*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((16.2669- 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:"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:"f0d62901f76b5abe7816ad11f20cd1b3";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"3137f9841110277cdfcc4f6a219bb771";a:3:{i:0;s:261:"Etablissement.id, 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:"1e61cc2b3d60e6f27130b253c35f2c0c";a:3:{i:0;s:27:"`EtablissementKeyword`.`id`";i:1;s:41:"`EtablissementKeyword`.`etablissement_id`";i:2;s:35:"`EtablissementKeyword`.`keyword_id`";}s:32:"52f583f69756f117339c9fc858039ade";a:3:{i:0;s:111:"Etablissement.id, Ville.nom, Ville.population, Ville.nom, Etablissement.cp_ville, Etablissement.slug,Agregat.id";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`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:"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:"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:"f4a9ecfbe65d4e311b083b343b7e4eba";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7dd55c782fc0846faf4e9204c8259c90";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((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"80ba18f2438e3f1f5c9e961efa226ef8";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.091- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5c1c6c4b173d3e4c4e74d9b446fc9846";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.091- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"635d836a019bdc013bfe5110f1818ae4";a:2:{i:0;s:381:"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((-0.579948*pi()/180)) * sin((Ville.lat*pi()/180))+cos((-0.579948*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((45.0534- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a629665eab3cb88ce5e47ce9449a0c75";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:203:"(((acos(sin((-0.579948*pi()/180)) * sin((Ville.lat*pi()/180))+cos((-0.579948*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((45.0534- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e9648c8b283b06899e04ee426a0df340";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"23a28e8d42d0dfedf4004562d7629f87";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.01667- 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:"20a12604bf9d53a92574895b6b273fd3";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((51.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((51.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"955423f4b15e14827bc7b426a1e7aae0";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((51.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((51.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cd4dd260ec2ad0c3f260293432345bb2";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a14eea5dbed04066af1bba9867f6673c";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"172095fa551674bad6559915f7698300";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"506a3dfd63753f11549ae40ca3c5221f";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.73333- 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:"d2c562f7add78cd41e99e09b770fd395";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.48333- 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:"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:"8ce4b212814637a07665ad582c791c3a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2b7d6285dfb50d915e285e1df121cbfa";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((47.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"89e097e8f48adacbb6c0f54747d1013d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.841667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e66a5e541f56dabadd97698098ce5c00";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((47.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0e82248fdfd2f1c7c9eac24a4d8baec9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((46.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5a26e45280b6fbf21a315d1b9cc2c1cb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((46.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"97b90d3aed6157e29a6a627f7bc7cf82";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"781b67296005692dc7b6de23d0c72851";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((43.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"48f194a7a16374b409ff73b745443f0d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((47.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1518570ba8aca661a032cf5157f8d579";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((45.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f7a4c01932b2ad3cd7b8fe0b3ac90d1d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9667*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:"a11825345f9298418ee4c023afd05b0c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((44.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b84d27acf09063787695c976c254ca7b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"87a398b21236c98b45f79df278453eae";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1d43fffdd41801dea6b907605f80ea50";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"499b180ed69a27a00ea3bd8000d3b1d3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((46.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cc4caafbd1af345ad150842b2aa01dd5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8d6b90afe8ac32235b825863575c48ae";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.8064*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8064*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.69556- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c89f21d75b482e35b364f539fa6e7c74";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((47.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a39b65b7aeef528b998a9ebb73f09906";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:186:"(((acos(sin((44*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"02b1207687fd2d059623cf6fd64a9b1d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((50.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"97a177709cf2b569396bccb3ec7918ed";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d73a94a9914fb95b0f11c07e583a378e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:201:"(((acos(sin((44.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3833*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:"73d52e4baec542821458e00330cbbc34";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8167*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:"dce5876e38e81c35bdf52dbd9d3deef2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0cb7427e5aa76f7e775676e2ebfbedd8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"060d2490631399a7374cf23856bf3d42";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*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:"67b45f21fd40681a37d9b40376378667";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*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:"48cf46647d99ee72a3994a4cb0aa6fce";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"fbc81abe90e078eaa4ee437c5f36c359";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2886d5340fbd2b60d20a8c21b46f38a5";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*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:"ff647e8549a82e37103981843ce0ed90";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*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:"e95a8b28a89acf3c35ecec05ce1e8678";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:"e8dfa4887c70f8b59ccd5552316f3338";a:1:{i:0;s:8:"`Post`.*";}s:32:"5487fda9911791f9f760d04cf4a96f54";a:3:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";}s:32:"1768885bd7dbab739b1c10fe00672843";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:49:"(CONCAT(code, " - ", nom)) AS  `Departement__lib`";}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:"5d90497a44ca5874776e9d8863c3195e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e8d9193df7d44d861854e9660992e9e8";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((43.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fde4f3f0222a6afa5ad8d3ef5142dfae";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*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:"94f336e940f37cb14b17575c0bf1ba9b";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*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:"35b3522bd09bcabf99a34635de917670";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.933333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7d91f7ad4e4d1a9a73796975a03f557b";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.933333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5bd80ac93b22619252f796643fcc8248";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*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:"792b45eb4401355ee229cd09bf66b37f";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*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:"bee39916dc96aa146982feb373436765";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8b74d78751f75c338d71d5fcbd2fb0f9";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fee416d7b61554563693cc5f970d2c59";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b97672f9914a5fdbc537890a281b4010";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"addd51a43c0ba8e92521b27c4f5d30a3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((44.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5e87191255d33670d99268a84b114ed1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.6739*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6739*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.453056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"33f2e89bd6fc6a959c83ce1f0d1b2cb7";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((46.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c88ba8f835dd0a921576ebafd7f46377";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((44.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e339e7607d8ad18b3d5aadae3e1d755f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((49.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"94ef837ef3673f054baa4f82865c171c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.7931*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7931*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.174722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"72a4026178e81383af48b3473452f26f";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"13304ed4fffd58011e54b291d6920270";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bdb3127d29d840dcc081c56639554f1b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((43.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.666667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b0c4edd0fa79745d576e803143215cd5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((46.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bb5f3e32706e794c344234592c3dda41";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((44.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9*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:"bf9f37a3fa88fb3997a8612c6e5655a5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d29d7d2ffc6764be760d0cabfcfb1b13";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((49.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6de6f7baf714f90de71dfe3cb5d0825d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*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:"e443b6c0777890c622776332737432e3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e24a37f5df8cab3cf79acb671bc472e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c61e37666fd2400f27ae1e14767dcbf6";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"06134a3708b4ab92b7faf3567dbc9f7c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3ac2631de44e94dd8958628cfa675573";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a227cd9a5310f9e3ebd87ff7040efe65";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"febcc4bae52975781d223c0594f3fb1a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"35ff4c4d530f04fe273bf877c2b9573f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8a555130e3267408f464b7ed6e77a042";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((49.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b2d52f4dd58d140b2d845689dcb18087";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*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:"edb46e9347693435d17a6caf578f1beb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"72c9c6e79ccc023a46b7a3c135aefafb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b860447c2b4ebe2d3f04f4ab06f311be";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f557fb40bb9b479ce095aae294251071";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9333*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:"2f831e7b35cb699c0dde23e0061902aa";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((43.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*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:"f578539302a80dfffd5fa49a0c87d9b6";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.8548*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8548*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.33361- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"17df8c46ccdff262b07cfac235fe3c59";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.8548*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8548*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.33361- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1a8a90b24e31b119ef8653df95559fc9";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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*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:"e574e80975a484866d0edcbc61bd578d";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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*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:"e21e4951cec42addef16a5ce45bd09af";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8d4cbc2757f96d67779d16564790bbdd";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"21b63c2c80051987cb7e6d6b6dbe7d7e";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((47.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1f794297655b632a8dbea137f7ef99ad";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((47.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d181f5a268f987adf17267b86a73df49";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"82fedf02fa9e988745b25eb070e83666";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3f49e154470877f620c7a3315c268d06";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:201:"(((acos(sin((43.5503*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5503*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.985278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"63175461d57028a4922557ef8533320c";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:201:"(((acos(sin((43.5503*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5503*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.985278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"692b9f82c13366c5cfe3b58c80f737a6";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0846e05cc0717869ba9759bf0ee8e889";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"00c5455bf7d8dc2c518a3650a8f6da59";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((43.3583*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3583*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.775- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3a4308aafa89d58af42c9b304c2d81f1";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((43.3583*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3583*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.775- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e68e518a30b7839d9bd21e1457e62af8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f32afd3f458a60262acdbdababad1284";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((43.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"110b236c46660f0dee6b858fef076906";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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1*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:"5d19a886d047157a5c79a43101de86b5";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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1*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:"8667130692c08816cd4f988161803221";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0248c780750d04f1a34704281be9e4d8";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d5c3244772d4ed164613171b73fa83eb";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.6029*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6029*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.77024- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1e7aacf4aabb0346d616d7ea15277243";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.6029*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6029*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.77024- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"01bde8945d273f3ae7eab15a5f80e4b9";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a309b1940cb1a2efba89cf79795e9a91";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"00cab270fe75c2d2012109166653fd56";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1333*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:"2d53b192d9f72091b01a33686f050717";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1333*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:"44dd1fd314b740422093e37a9579d972";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((47.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c39cabe208fcfe6ac5e222d2ee9d3a8f";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((47.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3799a94c9885b4ecb6df563ae86ba919";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8856b924d9945dc9403de89ace680b0d";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9a22d6efe951e3169bd6f511d051646e";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((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c4ac25ad206cddfcc147606b2d2b8bd4";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((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2310d6cd6990e79eca39dbe5463f1f38";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((49.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4df44aae53617069e633b482a25de159";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((49.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1b0ab9f2554dd3f5859fd410d86d36e0";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;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:"1d5e2a6486db82efef49d301195a93cd";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.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:"9bc6ef8092dcbdee64e273dbb33b1e61";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((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"dae947554663422493c09e6b537e00fa";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((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f225f155e4c82f26f8d339944be30d46";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ef2d8ba31b41831e2ddc3e15aa9d4067";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6ebd9798f755dea2e9201beab68ccd29";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2dd3dd8226bfee0ca17da2ae15f04608";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7ebd6557bb83efa13e7ff1eaabff5422";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"728f5e5d851e24e0ac18f5b810e115f3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5333*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:"6a5e638c9620bd31e9114db3143ff8aa";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"42d143b3f84e6a6c2dd782af6a85fae1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cb0548ec37313eed80082cddc0759341";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((46.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c2da43070d1f505667dee87f41d2da31";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((46.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4f85f17a4180d661ee2c46206c63c59e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"227a0767ccaf7cc975a7801989836fa9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d4acfb2ade3b06dec9e62d75a91dce80";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((47.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7683202977d4609ef0b0f49f9e231736";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.7373*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7373*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.60111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"383928a41e196ec612c3c188ea418230";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"efa4b3ce88a886cbadaa9ded1fbc73b9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"25aacf7a6e282bf2967f0c30024261c4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.5348*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5348*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.68473- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d4650f74fcc113a4206e17e6f334043c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fa93629d7fa5aab5cb5461597ad41d09";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1b506b5a85ea9422b28745445ec21dc3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:201:"(((acos(sin((44.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"277b49e553504e61d009b6e65418bc13";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"afd6000cc972d856e94bba62097e930b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"62ab6eb390eaa4ae75985ee60ff9ffa8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.8973*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8973*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25222- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"783fae3e9b2cec04ee676ce5fee7e369";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"336cca2ab48b433f2d107839eb5d23bc";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*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:"4432e5dbca6fb7811b1af13ecb5b94bd";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"44a4ee7611401663dbaac5ef685786d5";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(((2.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6ecf2a4c75cfa2a93c4b8dc085c87374";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((49.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9*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:"11a1378838a2c4a8b744f3e15f6ca188";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4ff562740c01c6a8aa7bce3543ac340c";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1167*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:"85e6d6a45915d16c316e85d9f0631cd7";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"350f2786e195166c5619a4542f7e4b53";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"facd4bb6a588f3af3e897bd17363305f";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7350f70d0db0ec9d50f65fd5920e02dd";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"dddced18824f0d06a32e581cfa21c497";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4e17d134b0c012d5b0c3888a79069f0a";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((45.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"221e748c186c001ca8ccbc79b89fe5a5";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((45.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- 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:"b3434d2ba81841319bc7089e8bbefb59";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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4fc7d43644902f0c110d22de1b982f7a";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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"88af2da0d95374c8d5b55be2d88ac659";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"829912ac5e0f32e629db1cc5700542d3";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2661d1db93d5cbaeec5910347bb91607";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.9934*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9934*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3097272f5b07fe75fb0dc923333edbd3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"938ff538ed3622ec5cb396479429f4bb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((46.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"36055ab4666540797a28be162b698dcf";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3f4af94f5e11b69ce6913a5fe6b448c8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6c8c55a92fbdd0b47408b5e0abf4606b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((48.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2b608b7b03d879ef2b548d6273df854e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d16651ea1bda4c045d373862e12579d2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"77470d6e7d176300d197f8c23988e391";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"48192fa2e35611d49a33324fe143ee9c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"18fd85e5ffb195e5fec0b8478c084c50";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((42.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b5357008837e484d6199152e8d5a77b0";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*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:"90362c12eeda0b2992490ec8fa527f11";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.0389*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0389*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.39778- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b893c02e533b7bb154a03357d26403b0";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((43.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0b827672306c2b166892dd74ad108db7";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;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.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1c71938d487b6a772f3cf4faf377051a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"114e3679034d536ccd8fe64c50e4b06d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((49.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"16030203e78ca04a184d41bfa03208a7";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"76e009e3f4f9e47dffb36dcb80f51bf5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*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:"3f8c5390dde0ec7a72aa8eebe970c47e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"83a26f6fbc755894faa707a1fd14571e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7584b86c8ca9b3346819ad1580168f8b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5833*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:"c5ebda0b18dbed6cea1012b41122c87f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:191:"(((acos(sin((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bea3d504cb5ace46b3a31d219dd32d02";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((50.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8468069508a793a57c6d43c026540378";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"48ecc59a0147aabac70a71d07189efd6";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f0546e28eef204df013692d252e459b2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"183a6a9da200d20d67617897ad6f09de";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a00e97bdf1f54356f939a92d983f4edb";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.14167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d9996b5becdaed92c514b9e7f2af2ac0";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.14167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"982192a99e4ea6da878d6bf7a232a26a";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"76d1092384b3d9e06946177fd81e634b";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6ab19ab65f1d9cfc2eace67d3b4aec22";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((47.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ee62bac7ea799387cd0d1be09a73cb94";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((47.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"21cecfe103ca04db827e55deb3583bc1";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"33303d2ae74ca26bb8ce5e0dc141015d";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6ccb5d6cd35e6ddfaa4b00ab29660b88";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((43.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4a6f5f4e27f161dc65c2973a23735e72";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ac215c7a023625c45830ddf9fe38de21";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8f69be2143766501c730cc810525cc89";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a1d7035722e5572a92915c968a62783c";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dd16527d533dc4d7370389478db89970";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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.266667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9f6a6a229d8169994602551f25dcd4ea";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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.266667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"869305674901c6d305afe16a3969c767";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((46.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.95*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:"8a9c65bc0b7d89039ab5433b42cb7ab7";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((46.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.95*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:"103a0d5ab1002416979ac7fdcee57955";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3333*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:"31dd7c35e6796e0711ac4cd665a514dc";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3333*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:"c3087318694952e01782b20b7cd79a91";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eb57d417525da9478055c8e23101a0e9";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7d8284a5ee7cb560ff30ef1b35760a64";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c8ec7d23d769f322e6082a8bf0305a7a";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"271f2a6e299a7d87236ed39101d07b9b";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.9687*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9687*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.52445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5cd48d91c1329a5d3b5dbd97731e0bf5";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.9687*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9687*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.52445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2c543133d1a0e92b19fee8ff406d4a4";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.1053*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1053*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.54111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2d12eefea7969ae2928907fcb1dcd35b";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.1053*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1053*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.54111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a2a63d620d4106921f3d779d19a553c2";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"06e84ef77771240c59b8616ce2696beb";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"89b2c5c64c722196298cf69dbde810a7";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"81f313160a2dceea3a5c40cda175a9ba";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bcec26a1a25e1205171a09285155b0a8";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.5409*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5409*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.91306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"62e5d2eebce0082da627587063bd1670";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.5409*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5409*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.91306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7e7f4c0f344ea140b415eb40be37d6c4";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6ec7f16a4c277a45d56f72eca3e70829";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.23333- 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:"c904f16ea2a48caf9972eb0e56c70a22";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((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"142d295e8f2408f73270ccd85a8b2def";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((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c4eaec7474693634591c9d695cdfc4e6";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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"94819ff4c3b68d9d2d9fa65a5b7ac274";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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"10dde39b9cd253fc73b5d4320e8ba31d";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4f9e727e025db290d7183257366674c1";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"513fc7adaa8b8990303c064e980ccb7a";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*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:"09d5233cb592edaef9b7f3521f009779";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*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:"8087c16fc5d1d24640dd0b778bd2db83";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((47.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3505e02d9cdadf105f4044ad5fbd2d10";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((47.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"46cdd2798911433cafa7719171e07318";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"fb706d52242bded51c89ed2b3b0a6bb0";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"45829213d3da3b30e3557db53be3221a";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"206483c2f70c8ffaf3e1219dffb3148f";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bf24109da40b20eff7e8ae39d4fc50eb";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"cf86ae0502f9b5fac3d3905afd07620f";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d631437cafe8662ce9fe69d67d4072d2";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"84413db1e820b8e601c905a9d1dd0d3d";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*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:"94175fdca817625360f675eff3b37135";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((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.566667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1ccf06daf2881c4ad70543789103ff9c";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((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.566667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5389db03618882945d04b39c243e18c8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((50.4084*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.4084*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.59278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bf3a1988c7b4d2fe0dac761a7ea911ac";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.4259*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4259*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"27da511f11ddfda24c1a4d969974287e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.9312*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9312*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.76251- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e90adf1f38b0332fb2b8a03c18c36a0a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"079e42db6bda55ca5a292f2d193eeded";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aec92e9e51301154b13e7b153412f857";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((44.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ead2948b8d90f936f4e5a871166605a5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((48.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"54dd7ec9ca6a10a9db3347ac3867358c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"50eba9702053582c5e6c3f389bc3c529";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((49.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3498145258645ebffab6fd7b161a0d66";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"500cfc0d76315921c554158be1907423";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"05f783ce356e9b0bd37ebd639b660ed9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((50.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.55- Ville.lnf095f0ace8c9754f4c514aa62fd71c2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.7792*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7792*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.09556- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"19be27924c1e348799267f1d5490fdf9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((48.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"71089208fb17b3f48db0c05d6cf3bb26";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a6030581239c7a3be1512a5eede242dc";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3dc08b1a2f3148de40f081a0ba8fb5ae";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((48.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"24cf13de7bed766423b8db1468728909";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7167*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:"d7e3724b0c41975f9b8e6be5c4c59633";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((47.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f1ac34a83a389d7d4129513ffb62afb3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((43*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5da3d91abda073fd97548d51e9b78c39";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(((3.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"85e13a714f9dc9f6a99acc35058deefb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ec56a52b0b508bd51ec9a5344b11b0a5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"85fac48436ed06672966ca00cabb0335";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"43c9acc8f59b62fbb81f5390601a71a9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e9b2055575aff17689c8a4ad41d70e8a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e796da9a8fac51299dfab5269a5416f9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:201:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.116667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bd47d75ea2af53286eedf0e7143b69d7";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8bc9fc2ce6d538445161d93f8fc7fb85";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"41c495ff3d79115e2b2d0fa5eae64073";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((44.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a5edc12e3379c5a8dee013ffc56b6730";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c20e6c7a5c2b51fc36324ef65b5d27bc";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.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"15e78beab78fece49a663f5ffe0ee7f5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"720821a30f2ef7394ef8aad21a788821";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"36a3416586baae7b1ab40a630a689b73";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((48.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5b201f97c2f40f000c011f284d1d6439";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.9356*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9356*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.01695- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0049a545202a6134bac4baad045c0f4f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((44.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"802608c12a67090197194af558a211c6";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;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.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"182fdb00054ef9664d1992851fe48fa5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7be8035ec6739ebbe3ae9c8c9bc8053c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc0cef8e0327c34a0ca02ee7e8e53de8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2380e6f66505071e9244148a33adb16e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:197:"(((acos(sin((45.002*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.002*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.22334- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"23eca5564f4d150672d05ee691bf9f5c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.283333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d86eb3c09b6e8a3382abee24a6c339d6";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((50.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9bae2199f087c1456c7afe44d1a3429";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((50.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.15*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:"87f28058354dc6a90c4c09a63cd1cf19";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((46.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0beb9773c3943b3d7ef8ca0e5ba0c9af";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;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.566667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"324ae888b4e1fef5f7324c682e4e54a4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d9efec80b64868b80a2091792dce9bec";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}}}
(0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eedc4b88cf094689a044a1208a49e8c6";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.5153*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5153*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.63445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}}}'
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
PaginatorComponent::paginate() - CORE/Cake/Controller/Component/PaginatorComponent.php, line 212
Controller::paginate() - CORE/Cake/Controller/Controller.php, line 1107
VillesController::index() - APP/Controller/VillesController.php, line 20
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) 1762801010,
	'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

Vacances à Sembadel (43) avec son chien, où réserver et que faire ?

Animaux Admis

Vous avez choisi Sembadel, quel type d'hébergement recherchez-vous ?

camping

Sembadel : 1 établissement

hôtel

Sembadel : 1 établissement

Séjour avec votre chien à Sembadel ? Voici des adresses utiles pour lui

Sembadel, ce qu'il faut savoir

Lieux d'intérêts à Sembadel (tourisme, parcs,...)

Chapelle Notre-Dame de la Forêt à Sembadel Gare

43160 Sembadel Sembadel-gare

Parc

0 avis

... mise à jour 2024

détails

Vacances avec un chien
Haute-Loire (43)

Inscription de votre établissement

Villes à proximité

ConnanglesLa Chaise-DieuAllègrePaulhaguetCraponne-sur-Arzon