Notice (8): unserialize(): Error at offset 180083 of 180213 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) 1750061197
$cachetime = (int) 1750061207
$data = 'a:3:{i:0;b:0;s:4:"name";a:301:{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:"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:"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:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";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:"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:"bea6b2845643a88405bd7681a112ff97";s:17:""bogny-sur-meuse"";s:32:"b48eb543cf607a0bd515156375ac6d03";s:3:""8"";s:32:"e7c32d144dfbfdcc3f58ae21827b8236";s:14:"`Departement2`";s:32:"67aacecb01204237dc496f70dd03bb8b";s:19:"`Departement2`.`id`";s:32:"d096a0e47d35cc9ce5790cbbc44662c2";s:14:"`Departement3`";s:32:"0ec37699516eae0626bc53868916aa75";s:19:"`Departement3`.`id`";s:32:"ca639aa7397edb23ae76abc30e7d92a9";s:23:"`EtablissementKeyword2`";s:32:"fa37476c14e8bdb8e6403cd8dd4a24c1";s:42:"`EtablissementKeyword2`.`etablissement_id`";s:32:"2fe35282e812004170a32d85be0bf39b";s:10:"`Keyword2`";s:32:"783b4f7a045247c9e0b0f4b51cb73512";s:15:"`Keyword2`.`id`";s:32:"ea0e3653b3104978eb6a8c20321867ec";s:36:"`EtablissementKeyword2`.`keyword_id`";s:32:"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:"aae25e7317a2c0ff61ddebac827b053f";s:4:""30"";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"2c5e9f52d960e90ec5f07551ed2997d9";s:21:"`Departement3`.`code`";s:32:"1d7e457219fc27e7fa343049f6f7f966";s:17:"`Pub`.`region_id`";s:32:"167bbbccc66597a3e0bee5ee6c3eb216";s:4:""11"";s:32:"14822249d41256a6baa7df3ad9a272b1";s:17:""montel-de-gelat"";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:"11550b7f392c5e1952284e1be39fdf99";s:12:""monteleger"";s:32:"52c7609c1d4d756ec792404c1c01f0d2";s:11:""montelier"";s:32:"3f239c1f414b85fb08460a35aa342256";s:12:""montelimar"";s:32:"03aae95f37aaffb069429c9e27af1bef";s:12:""montellier"";s:32:"0ee30eae7a36c42c791b060ea87071a1";s:12:""montels-09"";s:32:"9e6c6c3948ae1d1ad788052c50cbac6d";s:12:""montels-34"";s:32:"37d95b7e8e51599a486d7abd8c9d5a35";s:12:""montels-81"";s:32:"858a0f6b0741dbb5f16eb8012457046d";s:13:""montemboeuf"";s:32:"c12831747619179852c781903c3e3969";s:11:""montenach"";s:32:"1b675eec2ae045db9ccc663680da7050";s:10:""montenay"";s:32:"564626b72349fc8526958dd728d4b651";s:11:""montendre"";s:32:"ceee52a8ece434d314576e81fe4a7a41";s:11:""montendry"";s:32:"f12e5665d63fba593874284f22ca707d";s:12:""loon-plage"";s:32:"e8ade83b3133886783b73dbe2958bd22";s:4:""60"";s:32:"a4897fc6b910cf636bba61f1db5732b2";s:15:""montenescourt"";s:32:"a61394f89efa7855b9be35e9d4273194";s:22:""morieres-les-avignon"";s:32:"f9f5f147f05d82ada7e773fb4b3a613b";s:4:""85"";s:32:"45b954403f8d4de1dbf040f498b1b5f9";s:22:""chateauneuf-le-rouge"";s:32:"5a340de1227abddfbcbf93f153a8440f";s:4:""13"";s:32:"c3dcac139b8de3e7b44ba9e10912c256";s:11:""fouillade"";s:32:"52a8c6ab4f69e402f37349a5fb5b2a73";s:4:""12"";s:32:"056f92326f4a6d96fc50948ada7d4ee3";s:11:""montenois"";s:32:"b738af28547bce3dc365d862989d42c1";s:15:""berre-l-etang"";s:32:"1e803891ebf1ff246fa9f1ef38fc3e86";s:13:""montenoison"";s:32:"f3946d8aba6bd0abcf9f7dca2900bb5a";s:10:""montenoy"";s:32:"d22a0d8663939fda9fe09203c06472d0";s:13:""montepilloy"";s:32:"ee9617e8ffad5cf22f244d4d7c8c79fb";s:12:""monteplain"";s:32:"ec17b9c766f27aa6dddc162536d68d4d";s:12:""montepreux"";s:32:"bd8226beb29dfeccf5253b3dbb2ac286";s:13:""monterblanc"";s:32:"bb4777cc50057449a7d822f75c502889";s:11:""montereau"";s:32:"0d5cf3261721ae60f2faa219687b288f";s:23:""montereau-sur-le-jard"";s:32:"557fc96f736e7bd05971bff0552d3b8b";s:11:""monterfil"";s:32:"342f2f526e352d3ba721f123d99f4226";s:13:""monterolier"";s:32:"8ea969e1bef02ec1ac8d599a3300515d";s:12:""monterrein"";s:32:"3dd1a6f05bdfbc8d6fdcbf2a97ae7ce8";s:13:""montertelot"";s:32:"5e2fae9785a192cb1a488c0bd32b1d79";s:11:""montescot"";s:32:"cc5bde3abaa177d24c17025c69a94f25";s:4:""24"";s:32:"b9ddbc9d9e60acfab10708fd10288f77";s:18:""clarafond-arcine"";s:32:"f6eebbe2a731a124a4cd5bb3849ad21a";s:4:""75"";s:32:"49830cf77a78c06cdf15ccaacfdd6635";s:5:"`lat`";s:32:"1b739327d082af5af492288a2bc8cb64";s:5:"`lng`";s:32:"472551d38e1f8bbc78d7dfd28106166f";s:10:"`modified`";s:32:"e17d7b5a65ad1ae7ada6b153517881ef";s:36:"`lepetitbz331`.`etablissements`.`id`";s:32:"a725d74c276fec6288875a0e15107339";s:11:""montespan"";s:32:"0d82507fbf8b9a165275c288d7108d92";s:16:""montesquieu-34"";s:32:"f8ea0cf0dffc1f27ba8cc394324fbd38";s:16:""montesquieu-47"";s:32:"d4daf272a853225424f358ab76934a57";s:16:""montesquieu-82"";s:32:"ed2286e28036af463d5b965c7eda714c";s:21:""montesquieu-avantes"";s:32:"6698feb4c3443a895702318dba6d3152";s:25:""montesquieu-des-alberes"";s:32:"5138f6d523232f19446dec01399204a7";s:22:""montesquieu-guittaut"";s:32:"02cda734ebec501c21648b87d3b4767d";s:23:""montesquieu-lauragais"";s:32:"7cfd1f838d80d318dd85f061680b2c46";s:23:""montesquieu-volvestre"";s:32:"7b27a7ab4a5c99da6b323ed58e58891f";s:13:""montesquiou"";s:32:"786cb80b34ad91f355db827e5ec803f4";s:12:""montessaux"";s:32:"dc3105c3be518992cd1c8ae56bdf15fd";s:11:""montesson"";s:32:"940b7c212c18ef6323ce319a8fbbd225";s:21:""montestruc-sur-gers"";s:32:"17eda4ec1ed364b7c83b6f04c50a7bf1";s:19:""vitry-le-francois"";s:32:"eec795b73f6f85849975d87bce013a02";s:4:""52"";s:32:"d63cd7e7d4696c707c7f20963f111aca";s:22:""romorantin-lanthenay"";s:32:"bdd2cab4714f4907b3fc8a0ff2f6f7cd";s:4:""42"";s:32:"f246503320e054d1f5d29eb7bef9856b";s:11:""rouquette"";s:32:"99d913104e9260a590fa5519eafa8402";s:11:""herbignac"";s:32:"23b80b839585ad4545664371948eb48a";s:4:""45"";s:32:"6ec8d6fd51004ca0534985bc1526aec4";s:14:""beaucaire-30"";s:32:"15d6b97cf557c9ef82700914e59762c0";s:4:""31"";s:32:"f907ca62e76d797580210fe590fe9980";s:12:""sallanches"";s:32:"3a3b6f739be1c30f80168429661ad4ae";s:17:""forges-la-foret"";s:32:"baae300ee34d04d5bf23974b23f101e4";s:4:""36"";s:32:"d79b860885890e5b17f1e6794575d11c";s:18:""montet-et-bouxal"";s:32:"cb6150374804739c9414848a44671c20";s:10:""monteton"";s:32:"4a5c6fc64a598c48fbb4b0e1d0afc639";s:9:""monteux"";s:32:"7588e1a55aeb38ea81edadab445637d4";s:12:""montevrain"";s:32:"6e2f831c9d2c0c3627fd387a794a2425";s:8:""velaux"";s:32:"3034a1a3699f57d57375a81266d5c1d3";s:9:""meteren"";s:32:"6205963bbb8a920e369cf1516108e53a";s:12:""monteynard"";s:32:"a2a97eb4fbf484bd6f15a5acd1e4b5ff";s:10:""montezic"";s:32:"566097623ac41ff3c574b0bad17cdb68";s:11:""montfa-09"";s:32:"dcce2fb7f9954438e6e42265eab525d0";s:11:""montfa-81"";s:32:"176d977cd63c30702bebdd7fde3c4cf4";s:12:""montfalcon"";s:32:"ec61c7811e60187655fc8d03f2b969a5";s:14:""montfarville"";s:32:"1a35d235caad0841ff2e9befc6abfa55";s:15:""montfaucon-02"";s:32:"780942efc46be4c10e4d80a01364030f";s:15:""montfaucon-25"";s:32:"5882f2dcae26c649fb765c50f19a6416";s:15:""villegailhenc"";s:32:"1ad4e88d1745f69969d66c26add0065d";s:15:""montfaucon-30"";s:32:"7fba278df5e405b47ffb87433a2039a7";s:4:""33"";s:32:"f95549b04942231e89ce325c8ba364c1";s:22:""montfaucon-d-argonne"";s:32:"81c9752166b754b11518e232695d6a17";s:21:""montfaucon-en-velay"";s:32:"b14e6efbef1aded60c8baae927c9294a";s:21:""montfaucon-montigne"";s:32:"4b528d30bf4dfdf038409d8414508757";s:13:""montfermeil"";s:32:"585a4bc8a5b35bf891424e2a451e30f4";s:13:""montfermier"";s:32:"1fda12398ea73b1aef60c93b04543390";s:11:""montfermy"";s:32:"92b06cc94e214e7ebfe2d578bfe3df03";s:21:""villiers-le-morhier"";s:32:"56b320906729c8781b0c213ad3c0feff";s:13:""montferrand"";s:32:"da1469b73d0cafe81550dad1275d2061";s:25:""montferrand-du-perigord"";s:32:"7ce7300f8706b0c0c5fa479fceaa087b";s:21:""montferrand-la-fare"";s:32:"b7c63ba688befc3261a187c03cc5cbba";s:24:""montferrand-le-chateau"";s:32:"63e3a5e323df4ca4411b9c6fe65f9b59";s:15:""montferrat-83"";s:32:"461fc1fb114b13a06cdeebb110d31e02";s:12:""montferrer"";s:32:"ed35c380baf10474548b461d5df8fea9";s:23:""chateauneuf-sur-isere"";s:32:"85ed4586b3a874961dffea950e023db7";s:4:""27"";s:32:"6b1082b3f1adde5f2e8539fedce3f318";s:6:""alex"";}s:6:"fields";a:501:{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:"87846ef2798548f5d7c3094264100fa7";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.116667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8de2d34488c042e39cfe8280ee43818d";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*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:"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:"73f294965346eadef37cf03a3b62061a";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((48.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7756f9a324db068c4bd33b5dbb37ae6c";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((48.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f0d62901f76b5abe7816ad11f20cd1b3";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"275c69221f7d69c4c16083d506c3dd3d";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9fdd6959286c45af35ee0afd226a59c0";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"13d5dafacfe124c0fdbe732171b58c09";a:2:{i:0;s:20:"`Departement`.`code`";i:1;s:49:"(CONCAT(code, " - ", nom)) AS  `Departement__lib`";}s:32:"3634202bab22e2a50f7fa23214f6b71d";a:14:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:24:"`Departement`.`tourisme`";i:10;s:20:"`Departement`.`img1`";i:11;s:20:"`Departement`.`img2`";i:12;s:20:"`Departement`.`img3`";i:13;s:49:"(CONCAT(code, " - ", nom)) AS  `Departement__lib`";}s:32:"26b854aececdcc92884bb15e85b005db";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"c2b5dea3860db439a0511fae9f642b65";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"10c957bcf684968c33daf18dee02feec";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.8508*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8508*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.76778- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"25aa478ad87ac1d257a087d8fc3aa50b";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((49.8508*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8508*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.76778- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d6030f7a5bec8bfe753bc4db340ccf32";a:3:{i:0;s:272:"Etablissement.id, Ville.nom, Etablissement.adress, Etablissement.rs, Etablissement.partner, Etablissement.img, Etablissement.cp_ville, Etablissement.pets, Etablissement.slug,Agregat.id,EtablissementKeyword.*, GROUP_CONCAT(Keyword.lib SEPARATOR ", ") AS motscles, Keyword.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"82d10fc6e09b811b7dcf6bf89a807e6e";a:3:{i:0;s:353:"Etablissement.id, Etablissement.equipements, Etablissement.modified, Ville.nom, Etablissement.partner, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug, Etablissement.img, Etablissement.pets, Agregat.slug, Agregat.lib, Agregat.imgCat, Agregat.lib2, Agregat.libRech, GROUP_CONCAT(Keyword2.lib SEPARATOR ", ") AS motscles";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"4f4e56fa1b375ff739b6552ad033989f";a:6:{i:0;s:14:"`Keyword`.`id`";i:1;s:15:"`Keyword`.`lib`";i:2;s:16:"`Keyword`.`desc`";i:3;s:16:"`Keyword`.`view`";i:4;s:16:"`Keyword`.`slug`";i:5;s:19:"`Keyword`.`created`";}s:32:"68d6b8f992de5d53d2bad0ff4095c49a";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"9b6b899043e0181290a8dbf7d5f83864";a:3:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`slug`";}s:32:"eb6fd2c106f938179da639d0a5eb64fc";a:3:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";}s:32:"3f120fb3357f33a52d568356956703a4";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0333*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:"8d20444f2be39af735164d865631192f";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0333*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:"3971bd5022d0af76aba85db686d2d8af";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((50.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"344da64e6db8d6e6b7f462cbd6a0c7ba";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((50.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"11c72ac684a9195829daaa1b0b009606";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((45.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0744a72a390eff2b419db347600212aa";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((45.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0333*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:"3dbee35d684d0ec83efbcbc38e328600";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"83a4d997ba862539fee3f74a38a3b66e";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.25*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:"974557f62d9b7f91cae30550b7055d4a";a:2:{i:0;s:14:"`Ville`.`slug`";i:1;s:13:"`Ville`.`nom`";}s:32:"aec2a629c478fa98aa85f470a7372bdc";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"480640a02a190501e52f1904aa07bec0";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:25:"`Departement`.`region_id`";}s:32:"f355c94fcd8aeb9e6345fde762b67c23";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*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:"113adb874ca91fb4319a6b14d99eb713";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*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:"e73094dfcebd27ce6db0e479fbeca10b";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((49.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.216667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"058ec7523c182671982aca784616f359";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((49.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*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:"ef1951b0b3151eefd9158ec8252ffe79";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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"832c11b6888886ba2b40a5f360e29f7d";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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*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:"e461b26e5fef67605c39b49fe80d2211";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a9ed5442ca4d7598e148b0d85a200ea7";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0502d60d88eead9e6e8aefcddb34543e";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"60f4b914cbbed2d251de9b603365d573";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6467c5df0fe51814ced64339c98c18ce";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((43.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9*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:"a0948182318647faf9176d760cc0815a";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((43.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9*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:"b7c4c6456c763bad3914fdd6e4c21447";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*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:"b0d7bafaccc493e216bf2e30d3e3d50d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*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:"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:"897771dcd10aabb58b3038529b273a7f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.58333- 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:"adf78efd7cf0f88f325c223406b1a217";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7994f03c90ae2b07e8e459777759fef2";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2f58cb77d3cd3f104ce81c1ad7e27835";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0018f45d6fd9bb181e4e3003051d0c25";a:2:{i:0;s:22:"Ville.*, Departement.*";i:1;s:18:"`Departement`.`id`";}s:32:"1e155a7d44c4c6f78ed44ade8f64e39a";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"bf4738e443b4368363ba8b28fa88196f";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"606ca47c65aaead5ea589e66b9782cf1";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((45.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b8f283fb3c30037e178d8acae5f26eb";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(((5.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"27292117eeff18222413d950c721da05";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eeb9e9174a965f06b772a1a73ea91ee4";a:2:{i:0;s:367:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b8f1bc1edd56afc26ce50c258138323d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:189:"(((acos(sin((49.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fb78e0ee85aa8ccdb18ad74f8e98ffe3";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8f7cc2cde9ddf9e6d7af24243bbbc816";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((47.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3b205e2c272f23cc97b8f122d62e1db";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"076a61a59bd2124b8d182045405e08b1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((43*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43*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:"591bb9dfe712de6f91c3ce6aabbe57f4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e4ab68da0f4b8bc15386729b35b6637f";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((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"dd3abde1f10657ba4e50e85b4242bed7";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((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*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:"ba20fc8c4dc3065f659d07a028051378";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9667*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:"7a1cbdf586af2c75b0e4c78d2d7fc77e";a:2:{i:0;s:369:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e377ab685ae22d4181521f1350a1c476";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:191:"(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"29f47716f9037691744ba4b4fcbbf8b4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((45.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d0744957dd917efbee1b6ef6d2157d1a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2aa5a8270b231d1aa59cfbc133833b1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c4ea80bd96aab3fdc35124f2fb27492e";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(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c90c4babe69f8633165d0b86cc1bea18";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(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"248a837504b97378cf011824f93681c3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((45.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"41214c7fd6aad347275f2d6fc3b72baf";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"22449d84d3f7f593c0d3b14144864eea";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((50.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"470664320c0120d5ad216e637418d684";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((50.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"00d58de9128d35f645d8c30f3edf4e1d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((50.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.61667- 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:"774aeaf6443d1ebdb26d2480316d3534";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"942bb0ded5929087ea003a54108fb3d8";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3d572e5adcd00b5c44a249d3ff7c9bcd";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.8453*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8453*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.909722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9b5c90385a241a6624dac878ff90aebe";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((44.8453*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8453*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.909722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"20b807d3621948e02a098d4676e3f8f8";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.1117*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1117*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.56251- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"81a6e9d089855cc794204e75ce74b75b";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.1117*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1117*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.56251- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e09ca4de2af792a1a5cb6774763f17c";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.0934*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0934*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.83945- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3e8c7ad253d3706ae27eea360f5e6065";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.0934*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0934*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.83945- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"60b19cc242e75e2bc2c4296605cfbb6f";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.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";i:1;s:12:"`Ville`.`id`";}s:32:"99d994b4966bccaa3f7f21a7bc5736c9";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((44.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:"de1d536b2eea2889f9865149995bdf62";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((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1cbd8c5f67608e584cef6961928ca1d8";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((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"59b9b75bae74424cc9efacd1bc375456";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.4287*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4287*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.715- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9bc137690091d297dcce50b1f716a2fa";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.4287*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4287*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.715- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ecb95679829dbb1e48e5b63d08021d02";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((45.3583*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3583*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.05833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1034b37db7eba34a36949f9e3049da6b";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((45.3583*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3583*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.05833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c004fff265a5d9cc7fbd9c7d81e76d8a";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ad73ccc9890077c9280b123420ea17f6";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"497c6bd29922c52eda7362149843f497";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.666667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"69e84f41ad1def737f0bee1c2b3059d9";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*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:"4534d68178d46333cd8e983bb5859bf6";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.897*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.897*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.644722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"09266741b897ff99bb5193e570c31ef4";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.897*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.897*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.644722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"36b757efe17de1b66e107481719790c7";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(((2.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7f4c49c0069ebe037a3dfabbd47c1fc6";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(((2.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5d19530dd93e963e03d9d37f7ab8090b";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"972338d905ead1a9cc18c92476a80df1";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"811f708b6dadf23a7d50afea81cbc14a";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*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:"b6dae22cbe9bd85ff0831938484d1cde";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*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:"6f21bace54f2409c081f718e901bd10e";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2833*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:"f5c843a92819b5c6aaaee3b1b1ce8f86";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((49.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2833*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:"560e81b90acd718cc11c4718d1e9dec6";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"18c7449b584db192a57a9fad80ab338d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((45.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1f5689aaa67a793f4d1a36fad848fe64";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"835895871f97d63ee39035a36c12a127";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"65cf58e75555143c29793b33c7fdedc8";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2ee928beb4f3cf2ec7f04db5b94cfa45";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1cae0b495485d16064fa693f7fea1c9d";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.3917*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3917*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"be86a701404fb09840fb0a2974e40971";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((44.3917*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3917*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"29e49ab4753b0d8989cd34eae2990c43";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(((5.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"537ff3fa7d3e10a6a054278e982af21e";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(((5.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"102c795a208d8cef16b780ce73f837e2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.9417*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9417*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.90473- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a458aaa026d7cd0653bacda3c28a4405";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.9417*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9417*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.90473- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5a50b0fa53bc5ef2c8dce947127644e8";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0960fc357b45ba6852745bfa199f316e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a5f868be708631a21e8177c8db709047";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b43ca5855494ec03c505d98162215a7e";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"648e91c04f11c69362d207fdec418c3e";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"dbe34ac4f15e59bf42e162fd2b92e778";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"220c0292c688410e4c87e5ab7fd3605a";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((49.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4d426373b8c66533e8e8938d9b502b8a";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((49.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"718dfd2334cb6685f229b0523f449631";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2333*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:"2ee52d4bfc3197bb055be22f68b7f9f9";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:196:"(((acos(sin((44.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2333*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:"dd280b7960d689f2262fbd08e4805962";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2833*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:"fe68c831fd92abebc5c9f6779a93b688";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2833*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:"bb79fb482bd45df9fd748e062250a63f";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"19b08bad498d08c8da078d30e6bf755c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((49.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8833*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:"355c1b0b13f5d80e2b56973967ee8c69";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"79f02d1e8a3d0c5c3feac3049cd41f34";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0167*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:"fe02f250a953eec26454bb596ed6ba82";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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.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";i:1;s:12:"`Ville`.`id`";}s:32:"524847ebefff77d5fce602bac31bb0a3";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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.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:"5f5a8239e7b9f0d9ca770af801574751";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e3e6578bda1b9848e87e8475c7ee0add";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc2122cd3c3a079ab557b3fcf7d0f863";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((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"034543b974ec66b8dd530b5a761a9f0b";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((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"93dac98bef1479fb87d7db517e0a104a";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((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d6f41eac104666cc97e5238a13db3236";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((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7fdc5b2f7d099f4bb68ba2a74d2138a7";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7252672b8675f7547ddebfa1e7068709";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"715d9abea64efdaa4aad141c347b44eb";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6aabe8f9ab1cd135828bc96975525bc8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((43.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3d05b48369f802f43c5e8fe1f35290a3";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.3748*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3748*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.20028- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"816f9132ce32e5c5db9c70b9c4b77d91";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.3748*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3748*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.20028- 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:"70bb3dfb515ed5582cf308dc984d0131";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((44.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"17e4c5ddef1882b42b9eecb2ec2334c3";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((44.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"df788d6c2df6fdfdb1f324d920c1b81b";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1667*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:"db48224a8c4d6720c9e95fa1e034da7e";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1667*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:"879cea76a42b71dede99f68f4f22431a";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((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6b74ccd78fd7153980ee98d2edc8937e";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((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7e314b2ba8868074b9679ffd37b7946f";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9dd8f38a6fc66eb61fd23d6f5e201f39";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a33caf2fc0d513ae7e2978f1506ada44";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((47.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.66667- 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:"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:"74cd9a1825af12dd2738e8c0eded0ffd";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.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:"8e6c4a478eb7711d63ae5e191958529c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2167*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:"1f5f27da4557846ebbc757b2b242e44c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((48.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9421c42d982d6fd44f178dc57a47bad8";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.5131*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5131*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.93278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c003de22191146d52ad77ca736d23257";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.5131*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5131*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.93278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2566424326068446dc3ee972df961c55";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((49.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2167*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:"2de016adda7b300ad90a8d33cba65325";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e16fb996639e418a2ccdb6c6724df130";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((46.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"df883aa855b1ee88231b8e90aff90ea1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:191:"(((acos(sin((47.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2d7ed006be02838cfd29c201dd110c31";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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*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:"1c0769b6ab3d8562540fddf5034db84c";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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*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:"297c39dfd6d699fd42e2dff3967a3652";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7167*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:"5d7571dc0905ae28e2c710fa3860b43b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f4604542a242550afe3738434069a0e8";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*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:"3b4c697885d443684727c1cdddf953db";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*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:"122624c3a8cf5d279a9ba84f2dc31bcb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((47.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.85*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:"ed46c7ae1470aa36bc137c98089bcfe9";a:2:{i:0;s:367:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((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";i:1;s:12:"`Ville`.`id`";}s:32:"931fb1de543ce7476eaf43c19c4cd26a";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:189:"(((acos(sin((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:"66a05b6315b93e58a00d05fcf018e2ca";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e52ddacfbd7990a96603f17ca2cf6b7d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0667*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:"95d39e8cac3f6a1768e9f35e19214f9d";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((49.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1be53e23eefd805a373b42f82e7e29ab";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((49.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.75*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:"9159377895436cc6a2d2bb4ae0299a91";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b686499a849f707dd567ee2695555bca";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((45.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8726b13ae068297fdb31ed601adf3fd9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6333*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:"06d32f395b304e0985b02d094aeeca92";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:197:"(((acos(sin((47.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8833*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:"062e406aec449217afa20335f1b52986";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"451086c481d102a8eb7356b23d1f7666";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"076b59213f1873b210735dbd3b26b8ec";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((47.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8833*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:"49e954e8c6886f956fa49945666c440d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((42.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f722e59e68d5882078715896d2bbb925";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"caa15ab5e51091457cee68a3c8c77169";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*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:"9232ce48db65ccea3b6df2a01b351423";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6833*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:"53a4a7dcfe7e5c0920902909b36bd6b0";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6833*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:"95ade636ef2d997835aa28bd1b55f981";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a6ef7b05f4d9a425279572101a121e5f";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*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:"e44967d84fad86d80b3c1e2b90d16e1b";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3bbe44d46553e656834ca0eb4c5eb2ff";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"41ec38c4060dcb865e66a44f6ed61841";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"56a122f03c3329013b613cc11383b07c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((45.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"65b5cca6dc5e6211051890304d43819b";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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"957bf815b22f2b7a215de460a82e9644";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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8fa2d1ce0f32fd67cf9fe78a0ea71677";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"18341b57f762aaea79bb1ce77928db00";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((49.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"11372ad60f590bd4e3e0af16603f8267";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"64b589899ba055c72edc258598d1afc3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((44.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e62b2620e520f4fbf3a0234156cc4a8f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.0642*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0642*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.89389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"25d36e86f2ed0358633e2697f37d45e1";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((46.0642*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0642*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.89389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f06a0348200c9a0cce35e2790eadfcc2";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f3070a2e3dd00ef6a1dadd8152f558fc";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a2bc598eef9b3563a4a5f3bf70f16db5";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((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"cc9714c0895a91a7b511f1d7ef46d1cf";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((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b3c658aa5fa326711cadc136fc5fd673";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*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:"4d07a09ef1460753ae786c9fa242a8fd";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*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:"ee95a896ee8abff8919d7e54e1e4406d";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7ebfa476888b2a63714febe928c11b95";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"98bceff10ed25333e940d08c6067a00f";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"58291fc82f69b5c5777c8d9178d68c19";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"28e12ddd375d6cb3c45a03d9fa55bc81";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0b6b8c0aa5bd56389a987bd376baf083";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7f97bb50342063c4ff5b7804a0524420";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ac0a7bbb0d814b05be4bb3d1ceeb550a";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ba6d6368d887ca8ebcb3b2d0cc0bdab2";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b97c29b23afd33d84756d785b7d1a005";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3cea9c02c99a28d5f908c3635d061e7a";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6dbcec7c28dd3deedc00eec83e55a0ab";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*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:"41723fe1e9381693217fe7a711849af5";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"96f9544847d2fb097015a82349f37aa0";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((43.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e8f9f0ac2d895c82a3a0c4861c3aa785";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"61699fb83b0b8694ab78188129f1512c";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ed4e42b9ec315c2657b4cd2e13ea1b7f";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((49.2745*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2745*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.21028- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"beada1e02b916c42df5ea42b2ecd3cac";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((49.2745*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2745*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.21028- 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:"b9337410d54b54fd2a3ce874c7f8cd9e";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0d564276b9d49c8fccf728c6597b1e8d";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"06e725bddb4e6c50bffb4fab63c15af4";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((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"def86c964fd39032346314cf4b76bdb7";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((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"39a85712a6cf849bfa4f2ff0f60f240f";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6e7b51fedfde6866c34c9f3cf00904a5";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"332046f905323fc76fc6a7838894a409";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1a8080d71363dd628490d267090bfc87";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ec3c6d3115ac42fb9703caa51a478f79";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((46.1706*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1706*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.855- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"83953724f2dfba9cf54c8b1d45fcdef8";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((46.1706*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1706*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.855- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"217f35cec2cde052d8d8c700c72e7f08";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((43.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0833*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:"ec2af81f6720f3e45859dea71dc8b3f8";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((49.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5f4eb275bf25d176db37201c36199a30";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((49.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8a557f87a042a05c20cfa444c6ea20fe";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0cb45ff1f8e95f4dab341d0012176d3a";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"adf2554ab802275b6074bef5db9e10a7";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"732c88878eeffd888fb1fd37f72d779f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((44.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5c8af72bcdbcd322ab0b517634a801dc";a:2:{i:0;s:367:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3d283e9453b675b8f8f53b04ebae55c8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:189:"(((acos(sin((49*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e85a17187b267ffbcf31af7fb0b9453b";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(((1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bfc316b69e4696033edb0e4a8007ab0e";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((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1c5ff333ff792d9531b16d53a9a551a2";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((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f1c7a7eb8dfad30820b3b9640ce09195";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0167*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:"c46d02a4a7058232e58571f2bdaf1ee0";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((42.5173*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.5173*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.88167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bd7a729f4baabfec6dfaf92f409d2a9a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((43.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"137655254fd20d74d7b4c63504508913";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5bdfe8332c52ddd2106755cab47c116e";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f67a85caedadc47afa7a61b35a36e2a8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*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:"0531ca6e042728fc2f896846eaf16c84";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.883333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"acb6d9e48d9aaacdb1c8b15be16f8241";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.883333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e368fe47a0c75133048c9a65d30e07ac";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fa073520c8dccfefb97c3fe9cb00734d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*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:"00dcc814aecf25e63617309dbc392d0f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((47.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.75*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:"788731ac95a5cff7de7efa555296f746";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e8278bb48c79ff30b3bc4c25f98f8f7c";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3833*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:"de268317963d3a7b751b829110cf691b";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.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"078b4404e2d1832f4c70bb13f0df6654";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((43.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c9093311aef394691de0eebb6c817e51";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2123b21e2f5b31b6c12e1a40dc7675ae";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fdd0f706dca02822c7dcdce8fd54b21f";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"17075d2c60392f9befb91c24ddeae070";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cb18bdeb964b34ec54df52d56fac873c";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"63c934dc1222f062ef758eb049955a8c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((44.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"753631d9616139b0b6a2e60542113ab6";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1b28aeabe2371e81ddbec9fb407a2a7a";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((48.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"03542605f6e6cfd0bb353109faf25b5f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.3589*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3589*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.74361- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"98cc4cc6486deb8f15337040f9eba17e";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((47.3589*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3589*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.74361- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7f764abb31f1000c2fb55324747b037b";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.8653*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8653*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.66056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b16cba20de87323b0c0b5a46cd2010db";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.8653*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8653*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.66056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1e0f36289c17aa96de810675f697007";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.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"969602bf40b2426140f3f556584e9e83";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.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"00b7b3ef11a020c63d9874e38a7a21fb";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((42.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ba3a4a83300fb9eec560fe506815a1c7";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((42.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3bde9281a774189301ee79d54803a1a";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.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";i:1;s:12:"`Ville`.`id`";}s:32:"6684e89920a1a43ebf8b1c82af8e7158";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.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:"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:"7a2ba7ced985940faaed5b0b748c0743";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((46.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"dd86046fb8b4a3f28439583d2c0407fe";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((46.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"941a89e0c17e533f6cd67397b5820757";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((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*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:"c31406630b82c301c1d9222137c43da1";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((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*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:"ca88e5650db9f3a37716e352f0a8524c";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(((1.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b27ace65c0f74eb03114fbcd2bc18b72";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((44.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f07fd62dc6e928f4b8746c921a32073a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4c9f95be684cbbf2fda9b579c44f4367";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:196:"(((acos(sin((47.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e30212a8af5cf5c60ee79d28785841ed";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0421b594705b138014a09b80a283670e";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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0126840742903b694f7c25436089dab7";a:2:{i:0;s:372:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0f5fa0e4e648eee1cc496ffee6b411dd";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:194:"(((acos(sin((43.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"28bd06cb2b1bc609f171fb604a3a896b";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3b9be4a83a81234e65ab93d5294da747";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c8595ce156cb26e0828fb7dd8fdedaaa";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"040fec3dd98c7f1464a092d20dc8f157";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"040bb066e88773822e7783fc2cdca989";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"07cc79f293320c2d6d6839aa51b98dc8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9120e0bdd3fce1670f45033d5af15ad";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*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:"1a9ba499080b54655293d5e9a5771525";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*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:"ad520dd33d693a749cd7503d048d0f17";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((49.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d2db4adf61f0ab3e66b370713f1755b7";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((49.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26b09c767130d13b0cc86331cdd4ed9f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;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:"8cc7c0bfc59cb560fb9bbf80a7d6e628";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.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:"fdd80bb52ef92a8781f9872afcd885da";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"313f061fdd1a83553994ca533f3940d7";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5ce8b3239aa290fede3aef6a8c7deb23";a:2:{i:0;s:372:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.341667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"05036449c53f21862e1375632a609f10";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:194:"(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.341667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"867c17e92465fe7bb560bd8e7ccf6047";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((47.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*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:"d77a92d32f9ab7768fa13fd91e4e27a8";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*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:"89cc158c9750c41e3044917cfdfbc382";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((50.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"53a979072a2df0c3f93d1aef1ea9b378";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((50.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a4ae14299f28b363c683b5893c23a24b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0801b6445f208299a7eae83260686c6f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6167*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:"b4337a658df1120721eb1bf0245ec75b";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"303838d87b26f44de4848de72ab8e99e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((46.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b4381b79030db2ae2ddbc723337dafe5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((44.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*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:"7404a6ca2ddaf4a6f204a1e4a8673765";a:2:{i:0;s:364:"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*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7c5885074b0b2ff39ca9c4671e449b4c";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:186:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"37674aa2fae057045e61df67eb3df69b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8667*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:"f7d2f3c9717545b3db52091d5222da89";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e150ab50dd78156f3c6608fd55fb86ee";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"faa2eccdc288831afaa3063395f37c49";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((50.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7333*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:"fe407bd4c7dedd1f46d428d5f2535e55";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((50.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7333*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:"2494d7cb572621c082035181cb95aa79";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((44.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"17b594e1e9f28a221ace8a815b37830f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3d7aaa63cf1f4f98bed08c94185b3695";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.0994*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0994*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.28361- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"88b220dac7b8ccbcf2748fb3bd733c43";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1171f1f5714c3c8987e66b654366f932";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((42.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e8cdafcb65bcc6990b09b06cda3a1ec2";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((42.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26d70b7000602953027612e56be76902";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.25*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:"73049e739329c41d0eb340c3a96d4430";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"bd1f3315e00a27207cfef34f869e3824";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dca8703203da1bfd1e375cc98ef5107b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*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:"1ce5515fc47981fceb1d7704199c816b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"526267575f3af78ee56fff11a5a1ff58";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ab0275c516988d42aede5a5ecda3705e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*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:"6fcfc4b71d5bea8ef11aede68d66b57b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"578c09f104888030fb8714ea6c310573";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2667*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:"b872240bb80d8fe18f1423dd9baf7f6a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cec83dd8e61bc9175d92d004aa56d8c7";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"cf11527becde8cecbd0244e656fe2625";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2e4046db54aedd8bb1c479aeee8d22be";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"981843bb0594755dc4e3813613e77432";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ddd3b01fe8e8583565f6e0f18486e57a";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9333*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:"af8eb9db1f78330033ec0195b99c421c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((44.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9333*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:"6bf626fa7bdcc1d84d09247d5fe22f34";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"161808aa722b78c8f72e4d1c22817e3d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6b64b631b7fa19a6a34534a937ad3609";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"deb4f9c896acb9d9572134ec15f9a3c1";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2cc4e247ad4389d8bca94e798ec211aa";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"136673ed3f87dc149b532e6c898e7478";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"64000263d0afddff61a1cf10e00ddab4";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.05*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:"d3d87917acf381a6c52643a08c4a422f";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((45.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.05*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:"f94cf8454562549b543765ce626d02b9";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(((2.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e614805a960b5dab32a33987f81b4772";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(((2.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9e06d3764f7ce47e26e55032dc882b7b";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f74af5250101de424296b7bbbad3e551";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9d73351bbfacbd34ba6a144768c63fbf";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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"73836ddcf379ff0fdd48e83e110ffe56";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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5496125db5ba37b879df5df16bcde7ed";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((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9998e0027bdeeceddd6a96569eb5b65b";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((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9f19a3e265f11411d5c09a6a453b678f";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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a9e1f8f648ddffa622169f4abec967dc";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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.35*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:"7c1363cf98fa61cca5cbc8594312e6ba";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b15f1ca51843c8a09e5c2b5fa607c936";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.083'
unserialize - [internal], line ??
FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828
DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1174
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 76
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 112

Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/animauxadmis/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]
Code Context
            setcookie(
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1750019197,
	'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

Locations de vacances

Animaux Admis > Locations de vacances > Locations de vacances Cambo-les-Bains

LARRENDUCHE, Cambo-les-Bains

Cambo-les-Bains (64250), france

• ⭐⭐⭐⭐⭐

0 avis

ajouter un avis

Location de vacances dans la ville de Cambo-les-Bains, l'établissement LARRENDUCHE accepte les chiens.

Tarifs

Non renseignés

Nous Joindre

Coordonnées non disponibles

Animaux Acceptés

Locations de vacances à proximité

Location CAMBIER AR

Cambo-les-Bains (0.00 Km)

Location Lagunekin

Halsou (1.35 Km)

Madame Denise Pecastaings

Larressore (2.69 Km)

Azcona

Jatxou (3.27 Km)

BIDEGAIN

Ustaritz (5.48 Km)

Monsieur Pierre LEGAGNOA

Espelette (5.49 Km)

FAGACHURIA

Itxassou (5.56 Km)

Plan

Photos

Poser votre question ❓

je suis le gérant de l'établissement

LARRENDUCHE, location de vacances à Cambo-les-Bains

• Congélateur
• Chauffage
• Four Micro-onde
• Télévision

---

En savoir plus sur l'établissement

Langues parlées

---

Avis LARRENDUCHE Cambo-les-Bains

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

Qualité / prix

Propreté

Chien / chat

Avis Clients

Pseudo :

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

Antispam - Combien font 7x4 (en chiffres) :

Avis sur l'établissement :

---

Questions des intéressés

LARRENDUCHE répond à vos questions

Question :

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

---

À proximité de votre hébergement de vacances

Quelques activités, lieux touristiques ou d'intérêts dans le secteur de Cambo-les-Bains.

La colline de la Bergerie (0.00 Km)

Cambo-les-Bains

Makhila Ainciart Bergara (2.69 Km)

Larressore

Forêt d'Ustaritz (5.48 Km)

Ustaritz

Office de Tourisme Pays Basque - Bureau d'Accueil Touristique d'Espelette (5.49 Km)

Espelette

Peñas d'Itsusi (5.56 Km)

Itxassou

Les landes de Hasparren (8.29 Km)

Hasparren

Office de Tourisme Pays Basque - Bureau d'Accueil Touristique d'Ainhoa (10.97 Km)

Ainhoa

Animaux Admis, l'annuaire qui a du chien

Flexible

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

Mise à jour constante

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

Présence sur Google

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