Notice (8): unserialize(): Error at offset 155257 of 155637 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) 1750060948
$cachetime = (int) 1750060957
$data = 'a:3:{i:0;b:0;s:4:"name";a:352:{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:"bc2474f46bea8fe05da50ca155a677af";s:12:""montbeugny"";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"70a4a1faf343973daaf7a89bac3df075";s:27:"`Departement`.`nom_soundex`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";s:32:"e6b58a6fd2dddaf18714b7433a8c7703";s:20:"`Departement`.`view`";s:32:"b74474e63c80be3416038fc312c4ea9c";s:28:"`Departement`.`presentation`";s:32:"aa3e4e25ef57c9a2187d8b8f38d66317";s:24:"`Departement`.`tourisme`";s:32:"58a859cc9ae1c3a16eba65ee4ba041d1";s:20:"`Departement`.`img1`";s:32:"8d1bfdd6c45677e3b05204c9cd512952";s:20:"`Departement`.`img2`";s:32:"f237f95c23798028c944020938923a2f";s:20:"`Departement`.`img3`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"e7c32d144dfbfdcc3f58ae21827b8236";s:14:"`Departement2`";s:32:"67aacecb01204237dc496f70dd03bb8b";s:19:"`Departement2`.`id`";s:32:"c155e72f9df7db89bc84822821bf7f36";s:3:""3"";s:32:"5fb28f43f5f7f1fa8e6bcc1a19f144a4";s:3:""4"";s:32:"d480a5a3a2e97b40d54cd2691b9407b9";s:3:""5"";s:32:"11f7978e0fa4709fe1d651df3a967a24";s:3:""6"";s:32:"6249cce00f875f824d54b02f91d40ff0";s:3:""1"";s:32:"b254890fcd6984580e2aaf29a7c11794";s:3:""2"";s:32:"45ebcaf5524257cd5f889bc677fa7e8e";s:18:"`Agregat__nbeEtab`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";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:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"ffa9506a4511a7b9f744574dbdb4863b";s:5:"" - "";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";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:"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:"aae25e7317a2c0ff61ddebac827b053f";s:4:""30"";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"d096a0e47d35cc9ce5790cbbc44662c2";s:14:"`Departement3`";s:32:"0ec37699516eae0626bc53868916aa75";s:19:"`Departement3`.`id`";s:32:"ca639aa7397edb23ae76abc30e7d92a9";s:23:"`EtablissementKeyword2`";s:32:"fa37476c14e8bdb8e6403cd8dd4a24c1";s:42:"`EtablissementKeyword2`.`etablissement_id`";s:32:"2fe35282e812004170a32d85be0bf39b";s:10:"`Keyword2`";s:32:"783b4f7a045247c9e0b0f4b51cb73512";s:15:"`Keyword2`.`id`";s:32:"ea0e3653b3104978eb6a8c20321867ec";s:36:"`EtablissementKeyword2`.`keyword_id`";s:32:"2c5e9f52d960e90ec5f07551ed2997d9";s:21:"`Departement3`.`code`";s:32:"f0390fa2e07b4a53538ebc42c3a44987";s:15:"`Keyword`.`lib`";s:32:"002849c2354331d18dc50d9a58fb23c1";s:16:"`Keyword`.`desc`";s:32:"b2f06ded35217196d1e2063a349f01c1";s:16:"`Keyword`.`view`";s:32:"65fdef50318c78482920242502f98c10";s:19:"`Keyword`.`created`";s:32:"53ba12bfcc4a17ec6c1d401917cf8c91";s:6:"`view`";s:32:"dfbba30d1f72467a860b279eae73a5d7";s:9:"`nb_view`";s:32:"1d7e457219fc27e7fa343049f6f7f966";s:17:"`Pub`.`region_id`";s:32:"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:"7f8c991d0ca90d5c51e21568ba9aab71";s:6:""meze"";s:32:"097742fd62f89173f16da07e9cc56201";s:4:""35"";s:32:"3f058fdf2ada727774b91084fc1233a5";s:11:""montbizot"";s:32:"2fe12fdbe194938603c631944bc06fb7";s:16:""montblainville"";s:32:"ebe5fed36ca172d34a35784b24ada58d";s:11:""montblanc"";s:32:"ae3ae2ce64e27159610b3780f058e4d2";s:13:""montboillon"";s:32:"2ad5838b230fd3758e2f3764a68df530";s:14:""montboissier"";s:32:"6fd50731dbd1bbb70e42b3cc82d547b8";s:10:""montbolo"";s:32:"c0261d4c6193017b6264620c1fcc2d6a";s:22:""montbonnot-st-martin"";s:32:"c2049c345ffe950709e6992cb0e4c31d";s:13:""montboucher"";s:32:"c3781b431d40dd813136b9ec49804902";s:24:""montboucher-sur-jabron"";s:32:"de729f8151ca255a942f1d0626357c7c";s:12:""montboudif"";s:32:"1cf5402c49c35e2200f008c4fbb3941c";s:12:""montbouton"";s:32:"e9519125d75e318329321c6c445a9999";s:10:""montbouy"";s:32:"391445fd1ac767c4657cbf5d7ed285d1";s:11:""montboyer"";s:32:"6954b57f580473db058730de80d8646f";s:11:""montbozon"";s:32:"3223d718a872c09c0a4e3894574e589b";s:17:""bort-les-orgues"";s:32:"cce1cc10a574f13a093a92350396d473";s:4:""19"";s:32:"c1e55ff0a4bef99a7fb56fc1f0c45f02";s:11:""montbrand"";s:32:"e3e11bc85bf083c4880bcebad8e8887e";s:10:""taintrux"";s:32:"5b2f330d6cad4adcaff0785a2c6b85a3";s:4:""89"";s:32:"056040823279f58b845947675ca59ac8";s:10:""montbras"";s:32:"ea3cf6f1aa37dccd6bc63076fcedd068";s:10:""montbray"";s:32:"5fbc4c26bd3c86f0850094288943b070";s:15:""azay-sur-cher"";s:32:"8f4f7252001b87bb9ebc001ec6ba70a6";s:4:""38"";s:32:"02e82bde1617182d7713fa627f83f236";s:9:""montbre"";s:32:"726269bc2b6db7b22b0a762193679825";s:13:""montbrehain"";s:32:"eced493862e16101028e296e4f7a7a64";s:18:""chatel-de-neuvre"";s:32:"8761d560a0b2d217d7cd3525f9e7c64b";s:12:""montbrison"";s:32:"e081a6825802820ea778b528b018d59a";s:20:""montbrison-sur-lez"";s:32:"ebee42eb8db7dc02498b00f3ae745ebe";s:10:""montbron"";s:32:"e06859a8c5fdc30d3ace698b22d316db";s:11:""montbronn"";s:32:"baae300ee34d04d5bf23974b23f101e4";s:4:""36"";s:32:"a60552e6684a6feaa10bac5e36dde626";s:13:""montbrun-46"";s:32:"8bcd53fba2e03cfa7a9ffab625f35afe";s:9:""betheny"";s:32:"eec795b73f6f85849975d87bce013a02";s:4:""52"";s:32:"045093c80eb73c5746a047a6d70ae941";s:13:""montbrun-48"";s:32:"21e1d09f555c03ac0b8faad5571ebcc2";s:24:""montbrun-des-corbieres"";s:32:"5d6af47966734a1ae35329299b1a362d";s:20:""montbrun-lauragais"";s:32:"afaef027cdff0025e150ac058b4d3786";s:20:""montbrun-les-bains"";s:32:"96310bd093055f8aa74353b5c3fd41da";s:16:""montcabrier-46"";s:32:"f0351943043b5fc7f41b0f8b85e7a531";s:16:""montcabrier-81"";s:32:"5ee52c1df02350fac9d7041d5b52ee12";s:4:""40"";s:32:"3bb123ab258c46aa5ba4b09f45f85f9b";s:20:""marcilly-le-chatel"";s:32:"7142166d1e9021c22af48d53bc32d9e5";s:4:""43"";s:32:"cc5bde3abaa177d24c17025c69a94f25";s:4:""24"";s:32:"4254898de66515339f3aa1bd4fb11983";s:11:""montcarra"";s:32:"c29a7a3a645b036a6efdbb1c1991d799";s:12:""montcavrel"";s:32:"8ee0feb68ce98f77c7c50bb3b89e0401";s:18:""puy-ste-reparade"";s:32:"5a340de1227abddfbcbf93f153a8440f";s:4:""13"";s:32:"f2e4712537822fe4a11416a0f7378b80";s:23:""montceau-et-echarnant"";s:32:"ba12bc78d439f7bc5687a8422dcb61e6";s:13:""puget-ville"";s:32:"fdb204524e6231c6606712ff78ff4f79";s:4:""84"";s:32:"2862d2cb13699f8eeb9af4c7f0fa54ce";s:20:""montceau-les-mines"";s:32:"61ebd7442a9eedcfe831899f527f00b9";s:11:""montceaux"";s:32:"52dd00a1bacf1ad92664a042fb3e866d";s:20:""montceaux-l-etoile"";s:32:"5c94450e8099ceec1b9ef20d659674a3";s:21:""montceaux-les-meaux"";s:32:"faa43c520a7b644de2d822bcdce883d0";s:23:""montceaux-les-provins"";s:32:"6c97d179100c73ddbac264962f3f3f65";s:22:""montceaux-les-vaudes"";s:32:"08a399645e77661931074120bde2fc92";s:17:""montceaux-ragny"";s:32:"4b502513be2314aa9379036322ff268d";s:12:""montcel-63"";s:32:"0a4586eba42825aca7dc7a74bf03cf45";s:12:""montcel-73"";s:32:"771a62bb862108704d22645add0decb7";s:11:""montcenis"";s:32:"d7ea8e11dc7f0aff3128846e1bd8ed39";s:9:""montcet"";s:32:"4b14e7e5abb791c88723e04a2e3fbc93";s:9:""montcey"";s:32:"97d4d3d391746b85f876eed05866a862";s:13:""montchaboud"";s:32:"a676c19e7ed0061decb4d98ccf0eb0ad";s:10:""montchal"";s:32:"6378270ad57f7bf77219420927f05594";s:13:""montchalons"";s:32:"efe8363f902a7724120c7d5b00c27601";s:14:""montchamp-14"";s:32:"9d61ed1f2dd8590324a0f4f91e8a0ed2";s:14:""montchamp-15"";s:32:"e59890d9bfa5905425897d621f5edca3";s:23:""montereau-fault-yonne"";s:32:"fabcf25abfd5f87138769bbc7a1c4666";s:4:""78"";s:32:"3a0566c1922c8d2da7fc92de36487fd7";s:18:""moigny-sur-ecole"";s:32:"e078105b5e08579c42dd62507e8db36b";s:4:""92"";s:32:"b98fa8ae5fb4f96af50288600b6c5a12";s:12:""montchanin"";s:32:"6692327d30eb15e756dc4b99507eb765";s:13:""montcharvot"";s:32:"73ba8296002195d01e7a94de2491728f";s:11:""beauchamp"";s:32:"f12710d241036f3828e5e1df59acb87a";s:4:""96"";s:32:"7e97a47a8e162e08a44435fe9558cba2";s:12:""montchaton"";s:32:"06921dec4044e411610b3f3dd6330a26";s:16:""montchauvet-14"";s:32:"27b435bc0e6461afd41fbb909099cab1";s:16:""montchauvet-78"";s:32:"d040e34268c8cbf5294afb2f60cae50c";s:13:""montcheutin"";s:32:"c9ab5cc2e95c5641d1a70254679e0223";s:13:""montchevrel"";s:32:"213e21b7f7fec98251de9414fcaae4ab";s:13:""monflanquin"";s:32:"7d8332c40ede7afa36d4eea6315bdc9a";s:4:""48"";s:32:"201cdce86db51a4afaee6fc1e69dd68a";s:14:""montchevrier"";s:32:"4c21c7615963f385999b5ca480d95a44";s:13:""montclar-04"";s:32:"e581f982665aacad8b477392f75faa67";s:13:""montclar-11"";s:32:"cf1bc6995e10b54c701b21b96d1923d4";s:7:""trait"";s:32:"0c814091063da1002aeaafcae22b575b";s:4:""77"";s:32:"39c96e51b876352563e900687264d2dc";s:13:""montclar-12"";s:32:"7fba278df5e405b47ffb87433a2039a7";s:4:""33"";s:32:"5109cf58681e4b2954ef9757965ee8e3";s:9:""cublize"";s:32:"be7175f45c182640c54295ffb5040c51";s:4:""70"";s:32:"e52cb0b4497375d5def21036eb3d9f95";s:23:""montclar-de-comminges"";s:32:"0da42498c1482e2c1230658b4a47278d";s:20:""montclar-lauragais"";s:32:"36c81dc5fca5bcd2a5f62dc037c71da0";s:21:""miramont-de-guyenne"";s:32:"a7f5b5cdd756c0f8ec80f5294066a79c";s:23:""montclar-sur-gervanne"";s:32:"8d0d2f553e8f856bbd08ce0912a6dcda";s:11:""montclard"";s:32:"343a668099c25a99f1422b18de084f07";s:11:""montclera"";s:32:"24e946fe71d06bf83619ff396e4caab4";s:13:""montclus-05"";s:32:"4ab9f831d449abf17ebe8828f353ab8b";s:13:""montclus-30"";s:32:"2bf833a65f5ffb6750dd8e04c6b01fee";s:24:""montcombroux-les-mines"";s:32:"aa897ec9ef27772af2732d2ca8e37c4d";s:10:""montcony"";s:32:"182122f3e588093efffab12e72e0916c";s:12:""montcorbon"";s:32:"d7cd89660e55438e84d054d7b3e4e6a9";s:15:""montcornet-02"";s:32:"1f2f9e9657eef1ccb1e662a97556e579";s:15:""montcornet-08"";s:32:"9730da3453690506be89cc6896bc2e29";s:12:""rousset-05"";s:32:"2f6b43f86261db41ba9e4e1369dd2b95";s:23:""montcourt-fromonville"";s:32:"f5da473684c85aa91ab04fb0264cde56";s:17:""cernoy-en-berry"";s:32:"13d2692796a894010e322f7ce65ae7eb";s:4:""46"";s:32:"1fc4f490c6db9caa2a24ffdb44c1d485";s:11:""cornimont"";s:32:"7e0bdf2c0ea24b1b2e653d7ff5d958d4";s:13:""montcresson"";s:32:"8d15c79adf8b64fb5bae267a52d9c2af";s:10:""montcuit"";s:32:"a9ed3627d5edd6f16874a9297965f21f";s:9:""montcuq"";s:32:"17608fa6a76fed21a2e4ad2e0e60b365";s:10:""dorat-87"";s:32:"25cdca52a35f09964121c4b572df2ddd";s:4:""88"";s:32:"3cd408d01a8492af7aed7d9aef05fb1e";s:11:""montcusel"";s:32:"a41ddc2521cc8f61181c9c93ed233121";s:19:""montcy-notre-dame"";s:32:"5250055c865ae22af48a3233b451d2b7";s:13:""montdardier"";s:32:"f20f0f4dd25e8fa31a0078c2cc0933bc";s:13:""montdauphin"";s:32:"1c7ae62ab8ce20f1830cefab208cea88";s:15:""montdidier-57"";s:32:"14ad8151e7ebf40c3c16fb8cbf585d43";s:15:""montdidier-80"";s:32:"3930822234fec19d8480412d0e3f64fb";s:19:""nieul-les-saintes"";s:32:"e07bdee90230801ec1a68d59997f13d8";s:10:""montdore"";s:32:"4e5f079d1229fcc0eb42e670937d39e6";s:13:""montdoumerc"";s:32:"5bd42ba81d0c841b6a1f018f5e9e12b6";s:12:""montdragon"";s:32:"8ec499e301211e61bb5f42f5d51d1dfc";s:7:""monte"";s:32:"81304ae139a6abb7f5fa536831451716";s:10:""monteaux"";s:32:"7c646156c28d182e669be785364ebb50";s:12:""montebourg"";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:"f97ad29fee43c13b3e6dde15263e509f";s:10:""rontalon"";s:32:"52bfebe8878d26574cc189ea32e96bbd";s:14:""montecheroux"";s:32:"98f54e89805497eaf4f168133a89d472";s:13:""montegrosso"";s:32:"b86074b6e5449780e24be4c53510c02f";s:13:""montegut-32"";s:32:"2582903966b9bcb063b59099918072ba";s:13:""montegut-40"";s:32:"2c2e15fbc6263d9e01c24cf9921238d6";s:13:""montegut-65"";s:32:"23f0dfe08cbef3032b694444aa82dc91";s:16:""montegut-arros"";s:32:"7ba39d5c74e86d512b07ce4f892c5678";s:18:""montegut-bourjac"";s:32:"9421e75b9d45adb4ec8d23056fbcd9c8";s:23:""montegut-en-couserans"";s:32:"9a4187f1710e4beef73fe415946a1eb5";s:21:""montegut-plantaurel"";s:32:"03101f85507db9a753e1f9b4e0264717";s:26:""monteignet-sur-l-andelot"";s:32:"abebc2648136c261e767816d24fd787e";s:7:""audes"";s:32:"13a1943803a2a969d65e6533eb7fa3d2";s:12:""monteil-15"";s:32:"faabbf2b544b57658fa2d93b1bcd73b0";s:16:""clere-les-pins"";s:32:"03dba6381d095d147a849056d6849d9b";s:12:""monteil-43"";s:32:"0fbed1046e214ec47dd1c4518d202c77";s:11:""monteille"";s:32:"d282d3c85a8087a8ce5ad9d06a8024a8";s:13:""monteils-12"";s:32:"d647b1fdb9dde3aaadd935be41d36a9f";s:21:""st-genest-d-ambiere"";s:32:"bca378769cc071b2dfd627a0ef0e2f0d";s:4:""87"";s:32:"0446775571980b6e696307798ad83d3e";s:13:""glatigny-57"";s:32:"99ac0e71a40555b4f9bd78c12ecffe15";s:4:""58"";}s:6:"fields";a:682:{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:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"b60bf98feba4fbf5d2fcbb19b2a14657";a:13:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:24:"`Departement`.`tourisme`";i:10;s:20:"`Departement`.`img1`";i:11;s:20:"`Departement`.`img2`";i:12;s:20:"`Departement`.`img3`";}s:32:"bc013b7883512024414e377d97f654f5";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"a65ff2a25464afb8aa962a5b856ba406";a:6:{i:0;s:14:"`Agregat`.`id`";i:1;s:16:"`Agregat`.`slug`";i:2;s:14:"`Ville`.`slug`";i:3;s:15:"`Agregat`.`lib`";i:4;s:19:"`Agregat`.`libRech`";i:5;s:15:"`Agregat`.`img`";}s:32:"61ae4de0b32204c3b056d6e2623132a2";a:2:{i:0;s:14:"`Agregat`.`id`";i:1;s:46:"(COUNT(`Agregat`.`id`)) AS  `Agregat__nbeEtab`";}s:32:"c2b5dea3860db439a0511fae9f642b65";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"43c9acc8f59b62fbb81f5390601a71a9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"5c140a07ae46fabdb878785de258e7e6";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b96b26649a296574f2bb3814f30f58c7";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4167*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:"831ae94deebfcb65f114246d9c84d96c";a:3:{i:0;s:20:"`Departement`.`code`";i:1;s:20:"`Departement`.`slug`";i:2;s:49:"(CONCAT(code, " - ", nom)) AS  `Departement__lib`";}s:32:"6ebd007b29cf065d538dcc3a7c4187b9";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:37:"(CONCAT(code)) AS  `Departement__lib`";}s:32:"403c6e660a82fa69b87a696f1c113a11";a:1:{i:0;s:37:"Keyword.lib, Keyword.slug, Keyword.id";}s:32:"eb6fb1782adfc6d8a8864d3f32dab591";a:1:{i:0;s:20:"`Etablissement`.`id`";}s:32:"dd08a8531e9f680ecbf27f45e43f296f";a:3:{i:0;s:27:"`EtablissementKeyword`.`id`";i:1;s:41:"`EtablissementKeyword`.`etablissement_id`";i:2;s:35:"`EtablissementKeyword`.`keyword_id`";}s:32:"c6852640fcf038dc2e7ee42c8b6c4097";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"eeab83cba95d4a0d201dbcb17f0e8d55";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"1b2c074bd5e2d269d177aa66ef6ab159";a:1:{i:0;s:24:"`Ville`.`departement_id`";}s:32:"ea0e1579f0e6d3ac7f276247b53988e6";a:1:{i:0;s:25:"`Departement`.`region_id`";}s:32:"4dd95e1358f85bc94929cadff5efdd4c";a:7:{i:0;s:10:"`Pub`.`id`";i:1;s:13:"`Pub`.`title`";i:2;s:12:"`Pub`.`link`";i:3;s:11:"`Pub`.`img`";i:4;s:14:"`Pub`.`height`";i:5;s:12:"`Pub`.`view`";i:6;s:16:"`Pub`.`view_max`";}s:32:"41b596e56307663cfacf0e01899407b1";a:2:{i:0;s:16:"`Lien`.`libLien`";i:1;s:16:"`Lien`.`urlLien`";}s:32:"13d5dafacfe124c0fdbe732171b58c09";a:2:{i:0;s:20:"`Departement`.`code`";i:1;s:49:"(CONCAT(code, " - ", nom)) AS  `Departement__lib`";}s:32:"3634202bab22e2a50f7fa23214f6b71d";a:14:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:24:"`Departement`.`tourisme`";i:10;s:20:"`Departement`.`img1`";i:11;s:20:"`Departement`.`img2`";i:12;s:20:"`Departement`.`img3`";i:13;s:49:"(CONCAT(code, " - ", nom)) AS  `Departement__lib`";}s:32:"974557f62d9b7f91cae30550b7055d4a";a:2:{i:0;s:14:"`Ville`.`slug`";i:1;s:13:"`Ville`.`nom`";}s:32:"82d10fc6e09b811b7dcf6bf89a807e6e";a:3:{i:0;s:353:"Etablissement.id, Etablissement.equipements, Etablissement.modified, Ville.nom, Etablissement.partner, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug, Etablissement.img, Etablissement.pets, Agregat.slug, Agregat.lib, Agregat.imgCat, Agregat.lib2, Agregat.libRech, GROUP_CONCAT(Keyword2.lib SEPARATOR ", ") AS motscles";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"aec2a629c478fa98aa85f470a7372bdc";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"4f4e56fa1b375ff739b6552ad033989f";a:6:{i:0;s:14:"`Keyword`.`id`";i:1;s:15:"`Keyword`.`lib`";i:2;s:16:"`Keyword`.`desc`";i:3;s:16:"`Keyword`.`view`";i:4;s:16:"`Keyword`.`slug`";i:5;s:19:"`Keyword`.`created`";}s:32:"68d6b8f992de5d53d2bad0ff4095c49a";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"480640a02a190501e52f1904aa07bec0";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:25:"`Departement`.`region_id`";}s:32:"9b6b899043e0181290a8dbf7d5f83864";a:3:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`slug`";}s:32:"eb6fd2c106f938179da639d0a5eb64fc";a:3:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";}s:32:"b047804c9444963c13dc0342a3d84cc1";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((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0ce919db187371d390971e127e261dbd";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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((44.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4- 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:"26b854aececdcc92884bb15e85b005db";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"ed57d035b8e8eacdf0945f37e7861a5e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be034db6013027b88303fadf17e91965";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((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"5468cc726119c88c6c3a6f2d1658cce4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:191:"(((acos(sin((48.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8371c39bf3a3c0e75a1cb4207d1e3887";a:15:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";i:14;s:46:"(COUNT(`Agregat`.`id`)) AS  `Agregat__nbeEtab`";}s:32:"0018f45d6fd9bb181e4e3003051d0c25";a:2:{i:0;s:22:"Ville.*, Departement.*";i:1;s:18:"`Departement`.`id`";}s:32:"1e155a7d44c4c6f78ed44ade8f64e39a";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"b881d9cf52f1ed127b799039315af368";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.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:"85885d0f8b1cd60643cc59c90a3999e7";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((49.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.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:"65bbf8ca237a08c9467aa2ca459cb111";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((49.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"90d28ec602ba0ee245f1be78179be7cb";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1c78671e3418c3e5085c9916543ad289";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"07eb1108cb4b25e55b057efe52603f7b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cb3a706c7227567e4f52d1b348d3bf48";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*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:"8236ce8d50be584e832691bc5e736319";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*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:"353132b7deeed7697f7ee6a529930058";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"70c0db0040cbe0475867f97e8051943c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2310e358f924e91e88138088e71f43df";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e6dbfe2365ff13fd6c9992a35ecf4b4b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b4dfa49e63d3ebffb62c778ce7c6bd85";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((42.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.4833*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:"07ee4f889d72368783342acb8cd66bbd";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*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:"9481a3c7ba74387ff1a104f3d6d4d60e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((45.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*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:"508203a98ad52d46047a173e427d385b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4df136a790a1c9daf68d1bc11329ea1f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9d8c74138a06fb3407f52d2c76c7e5f";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.65*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:"c57b63770c6491e8f8bdea74f375bce9";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.65*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:"8caf6752bb315b5913615fcf52ff6760";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;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:"f92f15b9fa261c5ba879805e2bc706d3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*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:"e4f80dbf189d15fe4a9457cdcaa6f4ca";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2a909ed58449d843b0011d64b6227a68";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"48e6967a1f64333e85c3250526ed06e7";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*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:"3b659464e0540e3088c74c0562f5dd70";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*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:"dcec238c71c4ed979001a201d9e83c08";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4667*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:"1a725bb437a882007edd77ee396b9e3b";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((48.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"498b1310828308e1c548e7c42371a44b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((48.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.45- 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:"76715b17ea553a8a629b9e65781948f0";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;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.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"49512493dce6b875a5301201f3067e65";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"03033a35bf63cccce24d094706cacf3e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ff00a31e8cc1f7c5147e78cae5f2d9bd";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((45.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ac99a39fb0b34b1050761049ce135d29";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3333*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:"8972737ba1da9bb34ef14a67c1e27ed9";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3333*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:"94ab60756c0093cae70461d0020cb850";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4667*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:"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:"857c8583e0226030d8e43d21fd7499f3";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d8bca5c7a9ecd9d65e603da28166f346";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bf283890049b2acc3e3703ac119a959f";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e8a3f202fba2e2624b486adb750f8d62";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((45.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"90962e911e29f032bdbfeae9bf24bbee";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.2967*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2967*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.37639- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"11eb0f5f97271c81133c2783dde928ee";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.2967*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2967*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.37639- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cf9fb41fb400f89d57c1e8504093950b";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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.966667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"35345f64c4c8e7a237fc8005d9e9a05c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.966667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"431f27650999be2c25912f8aee867c27";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((45.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ead5ef7befa184d7b932410a12dbe4fd";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:189:"(((acos(sin((45.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"08d875e4e0ae1bb677a7b2a063de64e2";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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"87079a2bd460743d6b9656ce02deaa62";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c0d2a31d727e8a9ffc6fb14cbb5f575b";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c3f2a33192410591e6bfdf6b07492fff";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.11667- 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:"bf66566476692e6c8ec67abb5ee8fbb2";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"ed56860086fe60d7756dee0632c11757";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"53422efc46a473e3db102d1067a5792d";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c559bd66201fae22e2edea7fa2764aef";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ec8515fc222b98d2496d57268ee6776e";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*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:"faee8ffd97c25bc212d428757c75f43c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*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:"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:"8eb5519b5be7d4f7b849d8882264f215";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.975*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.975*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.391667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b1e410ee43f01865ec78af16b8e9111f";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.975*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.975*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.391667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cd864d2d32e6c90cf981193e88028312";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(((2.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7d0322d54b05506fe47343dc4c5a78dd";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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(((2.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a2dfb395a81553fd8e2ec71ed0f3c64c";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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"112d02195448c439cc3d3623eaf5b96d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f62f1e8319e6c1ef6f2206421528267d";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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*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:"94a5631670a4191d7be81cf7128d729b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*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:"3cbd9fc1837e118be478a06296d2ad3c";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.9356*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9356*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.01695- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9aca6ddd0b15da4d31436544b8f213a5";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9356*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9356*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.01695- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"600471183a79997e1d22d67b97813845";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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2b698bb954d5dd156bdbdbcc905d2d92";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0756b865fe952b4cbac4ff6fb4b85692";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.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"84ba2aec44fa783e70a3db67d57d6ce8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4969bead242bb468776bf1ec605e4f49";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.9442*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9442*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.38389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"888dc924ccb88785ffdc8f53b1b6d2a3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9442*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9442*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.38389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"efc60816bcde02db1127c905c3dabb78";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7406fffc3c25dc822fd03f72d35a755";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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f7949f62477d324c7188a7a92db2af37";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6073f423a545da4f06bee5a4aeb03bad";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"351819ad2d01c312419d03aa4a2fe1e4";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"413b583912d0d4e93dc51f02c37a057c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:191:"(((acos(sin((48.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.25*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:"2adb138c8b91e235d830cc2b90b999ae";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:191:"(((acos(sin((48.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.25*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:"67969a6966b3d0589acf51dff5c4ed0b";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"518e69115e99fa4b6916b272492e6253";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2333*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:"6bf45c32e48031a6284d35c57336199b";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.6992*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6992*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.23945- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"74d636cda2ec1de660e6d62a4da2d5da";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6992*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6992*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.23945- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a17acdee22c1e5aea40a91071452b9ed";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5b260d29f1ce65e13f96df9d4775b00b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((43.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3d74cea02b679ca290481ab6b973140";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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a1361517d4d08e0d2404804070ec01b4";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"954dbe2d28a2dd03b7b64ebcb5a4c575";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d9a1710e70368fbc1cf4ff56634ec690";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eeb884c290732e1f3ab05bb293699022";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.5281*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5281*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.69389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cbd02d0c243ff8d4670365f0d6ce6c3f";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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c0cf734e3379d3d9046c9e1f52414cef";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2852bcf04f905c422f9189c768176cd8";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2624bf507aeedd9d18ed7f6419ed99b9";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dd4a48015e951a2070453550a67f1b46";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5befaf6a4a42374a20315ce8fbdad931";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((44.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5df138142f734caa8e255b1091a5a2d8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"885d0af8361cd8ec1bbdea29ff92282c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((47.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*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:"a8788ccec10d98234c17669705764561";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:192:"(((acos(sin((47.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*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:"8b0f11eb628525ed2aa0242e11d1daa4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2df9fc9889d49f185c285e727727b7a0";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9f6b2b1ed29ac40e6f2df5ec3a7eb141";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*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:"f8925f99ea23d67199cf7d96ab12694d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bb5890654c0162de6a561b3751eb8c02";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*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:"66a386db556ba4c25ca477645a1ca6ea";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*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:"9f3f63c73509be7800f4f8bf2429efa0";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((46.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b772107b06528f6252f3a639eb1454cd";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((46.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"91ba4118d80244fc83aa54573f31d352";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0e95159909c2e25f577f26e2c0db37da";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bec341ce53f9cc196b40dd7733a7b831";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((45.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c115d01cd735183ca6e8f959c6f56eb6";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.9745*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9745*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.32278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"597075217290f4593b1e3a9bb4fb501b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9745*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9745*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.32278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a92669e0ccb71233f752cefa1f460084";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.4417*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4417*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d8b9f7660a5265c1a5fa6f8027af3023";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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5*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:"539651471f02273e480302ff82065f2d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5*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:"270edf8f6cea248750908e609984c01b";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.3489*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3489*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.215- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3b65070ad15ef3d912d4ddbcd548d19c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3489*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3489*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.215- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"951fcf5c52f8f91c15aaf419333e641e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6667*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:"42d1d38fd1b7101d9bea9a5299b1ba62";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a29f132fa8e4499dd62d9cd6aeb5356f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((44.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5*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:"eac841ebd737f1bc8a498230dbc63b56";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2f947547cb17b720fafa1871e93a0ea8";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((49.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"35f48d657f36c9be56cfd2ea3a790d86";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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8333*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:"4577187124b6f00f5e586e79b4556b60";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8333*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:"6de0cb94f3f7ebf37df129bd9115c746";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((44.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d46ce15f4d4a10751347723b6ccad21c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((43.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2*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:"02400ab2d7b61e72f2005e270a658903";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.53333- 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:"9d4e1b7d3a1f9a1fede1c13245f18646";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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d3b6930b70048d2c5a29e6d75083c9a4";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"43b8871abba47d32fc74b1d2afe23bb2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1833*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:"76c88cfcc7d7cfcea6ea2cf25c05814c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((44.5417*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5417*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.07417- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c0da14a663913d26c375812e9a32229a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((43.627*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.627*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.73- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be939fec4a27f6b192794c5f5e2c451b";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6285b2cbd82a87048634ed7e788594d8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.6- 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:"f9ea89aa86d6feabfe8e112774d720fa";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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6b95474c63bff53d76b93389bcb62f94";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a633f83214f2c97b1ae8a4ec0e3b0a5c";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"23f3636983f383e78f24fda6d60ed994";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"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:"37d940c58c463b52013d61f6c23defb2";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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"785a478384bf65bcf3ca56d9d90f1648";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c6d04366dce17ea4be6610a44d4ff504";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.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1361fd17888c4594935111aa79caf73e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3799a94c9885b4ecb6df563ae86ba919";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8856b924d9945dc9403de89ace680b0d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((43.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5e27edf5c1ba4cea689722a57f9a0d58";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.5083*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5083*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0d1d65f2faad2c9a7f0b49a2f6fa4ed7";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5083*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5083*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"04d53f7a4e464468f9b9861e474a1826";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5b21846d59b9185a7ba93e50d59821d0";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"de6db7649e0578f19df719738c1ab7ce";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:197:"(((acos(sin((45.695*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.695*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03723- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3be31e758202ac61e41498403ed98336";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:197:"(((acos(sin((45.695*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.695*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03723- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ff62ba90bb1a20c71781461032a0f5db";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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"573e9087ef35daa3c70da3980e1621c2";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b98078a6e25ed26bd9efe99b1c824942";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(((2.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"bbe2b14531783ff397e82d7958ae13c3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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(((2.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6018440b22c3f3dd051e53ea28c612f9";a:2:{i:0;s:370:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.75*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:"3e9ecf5dddc3091ffd287f56b0907929";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:192:"(((acos(sin((43.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.75*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:"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:"7e8d846c83d2577b0bd2a688943e63b2";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d660ae13ab8d0d3a841c5ff576ba0687";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dfb68f308484ef911cceaec58dd6cef7";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*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:"750d008a578af5dbdb39f8cd960ee53d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*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:"a0111c54c72e99f6c1db2056ab6481d1";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.35*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:"60b44e009c585c0e0ef0cfd7bb29cf01";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((45.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.35*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:"68786ef7d95fa08699e31a34a1367d69";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"820992a104cfd44896a21d2c7e2f39f3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fd1ffc15182c5b9ee6179fc060caae35";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.6309*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6309*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.872222- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"66e2b4973132d2ebbf034ba3c7d8a92d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6309*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6309*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.872222- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c6d65832b1c4b99555967d0f8714944d";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(((6.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"eea91362685ac4be902eb67da9c20a3e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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(((6.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cd144e14950d693e6b360c2cd55d30f2";a:2:{i:0;s:370:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"73b35056c68d35aa5dca240b24586adb";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:192:"(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"410db2b0b1e1e4517b60e62e2ba0e83c";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(((6.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"236efe1fe92718a4dd6449dee32e16c6";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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(((6.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9ee4b1d3d6908a447bc08ffd72415942";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.3583*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3583*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1b3769eda97fbfe54cbeb45e44a80887";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3583*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3583*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c54ffcbd886f8cd25629f716de25a700";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((42.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"acd0b94ec9c3db95a958b52cf8a6be3f";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((42.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"64a9e5e606ca6f6155cb89ab5278b164";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c50cbad4fb20904f4eb5e2b6a61c1e2a";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4667*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:"12cecdae0184775f2a3fdd712b68f9f7";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"8d9fb0d2b1389045687bab3e9f3277f3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cf476d7aea3faede6e4a0a9b52534ea4";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"12e451127b3c9888534956757296e502";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"50c59626e980f3fbbc9d5b8cd30d9fd2";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1b1192947324936d2e9dc6168eba55a8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3783172de550092e624bfd925fb1574f";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7833*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:"9dcf85e2a92d06c97e906b9d65a25bcb";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7833*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:"5755b30487925440fbaecb31f7364c26";a:2:{i:0;s:376:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.475*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.475*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:"a6ffaddcb9e08f8d5dbd0fe9c1acf229";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:198:"(((acos(sin((45.475*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.475*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:"90be7f39dc751ee87476c07d3936b0a3";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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f02f7aa4711db807b17e1fee70fd0bf6";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"033b12f7fa020e90089d946546726d6e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b46a6496393575a5931e48c38c29dd15";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((50.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f03de8f7395f9fe055727a7c97e4afe4";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5a3f74a1df1ad50ac3835b393b35c21e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e51b2cbb683e46e283b9b3b35773a832";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*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:"0f8c9648889cbb1e6c39a957c827edac";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*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:"6e235fd3cd455a62ecc80e9997d09a30";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0667*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:"a117b8c2fe3f152f457e7428d06afd6e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((43.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2ee5000c01d24bafccdd7c542971e683";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8bdaae8b84e45d7d92bb5989560ee58a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6667*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:"fc739b4cb5ef3f892b18a823c7335d84";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(((4.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6ececb5488e3def402a8a3e5aa866464";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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(((4.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ed67e9db103012bb8059de1a67c31185";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((46.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1*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:"602bf2bbf104b791e5242a1b0e0daaa7";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((46.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b54c540cdbafcd16ec07a7049da0106f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc7ed18ebade77fc49ce19a52e2d7b3b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*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:"1781c30d9871f97190a4951b256acc30";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"646b0efb5c0374efd404113eaf6eb5b3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"84a6df69d908c68e7661b9eca63e5912";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b6b56ca6746e93b938c1e9673e547986";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9457e3a677c8a5469c54598f22c36d50";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"44d32240559dd19cc002314e51743f38";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((46.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8b01953fb409d082bc0ccf9e19b37fb1";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f685ad7ccb21409b41fa8ac9e3467ec8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((47.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fb932941165df75204635908e4401d28";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((46.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"71875304114440c635170154d5d6a962";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d617bbcb4449afb0b5d2d2c6fe4a80f9";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c9929024a78c82fcca62303594dd5fb3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((46.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2*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:"700c74d38d34fb8e8b8d1819e3618e88";a:2:{i:0;s:375:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c703f0618b6f2bfc8e450cffb79b52c2";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:197:"(((acos(sin((47.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6833*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:"52e0bc9a0b2c1304b61e2435b86f325f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((47.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ff219593e5495378ed626957822ce724";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*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:"f3095da77ed1b3eaa00c35af544dbc11";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*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:"7d41b2bd29439f1eb7b5d7d35d7ecc00";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0da6d311f278746e3a3d7f798d7f5d80";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9333*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:"a3c390b60ca53c04e585ca6502df16ca";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.7429*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7429*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7b0fe568ab0fe8217b2355c622257d17";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.7429*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7429*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ba39b71c500d9e451a72a7a80aec1cad";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4667*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:"a367c0e839c2711c70f63990b30e49ea";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4667*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:"edf151ca4e90208a8e9aa74c7ae1e459";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*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:"7636a91cd532e1396d0e8f9a184afb04";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*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:"4f7b4f2c9a439d2b34577c93f6ccefc7";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0d87b87518d0f76afecd0306cf7cf733";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0b4f6ad488cf18b5ce95096c1739bb28";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a403b030541d9014b9cc943425b8d2a9";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"08c856a44113322fe1018f57952f412e";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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"30cbecf66024d643f79872e554d70cf4";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d56af208fe859af3bdefb517f099cffb";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"aca7a766c33b3743b9a205d15836e6f3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"9ca679bd604b74b6b7826ddbfd21a4bd";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(((-1.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d86b15988b19a973d49c8dfba051515c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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(((-1.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"30b7971554c99806d3a116444fc9e379";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d115fa3fb607608742073ac2e527f6c3";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((43.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c79c32d88c59c84d5141d78cb4e7319a";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"cab6f1e7412f1ad4f1e267992e9bce1e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"373eefa3894175619b182add38e4ea06";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.4833*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:"5b1befd93dd6b1f6b2d930cda6da1927";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.4833*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:"90a520db14cfd769432c2e018ee28063";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((45.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a4dbecb603051c9a6dfc3458547908d5";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0f9005a9c1d770e903a668a36f9b3ba1";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((44.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2bf80b783d1b41465149bbe1c25654f4";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3d2f8e01951253f85b6d30edb9676b7a";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*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:"88a057ee78ad07ee40fa2f1a2f772bac";a:2:{i:0;s:369:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e7f12834b48b9c7d1454ebb4fec795ef";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:191:"(((acos(sin((46.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9421ef88e996c750a1743dcbf835557";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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"9ccc4ec8ac5967a2b106998ce6b26eaf";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0b0f6a07c3efb1f9c64d0313fbe2d394";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d112d65123a76d009fba8448616a4d64";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"11bbb34612116e1f88d3f3ea056bfe37";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.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"7ab055f27ca7ff588329e2fee5feb194";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"372593d3032e2ea3d780cf89320f4ec0";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.916667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as dist'
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) 1750018948,
	'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

Vétérinaires

Animaux Admis > Vétérinaires > Vétérinaires Séméac

MADAME CHARLOTTE BIGOT, Séméac

69 AVENUE FRANCOIS MITTERRAND
Séméac (65600), france

• ⭐⭐⭐⭐⭐

0 avis

ajouter un avis

Vétérinaire dans la ville de Séméac, l'établissement MADAME CHARLOTTE BIGOT ne nous a pas encore indiqué si il accepte ou non les chiens.

Tarifs

Non renseignés

Nous Joindre

Coordonnées non disponibles

Vétérinaires à proximité

MADAME VALERIE HOURS

Séméac (0.00 Km)

MONSIEUR FRANCOIS GONNEAU

Tarbes (2.70 Km)

MONSIEUR STEPHANE PEYSSON

Laloubère (5.49 Km)

CLINIQUE DE L ORANGERIE

Bordères-sur-l'Échez (6.55 Km)

CLINIQ VETERINAIRE DE L AMI FIDELE

Juillan (8.91 Km)

MONSIEUR THIERRY LOUGE

Ibos (9.32 Km)

SCP DE VETERINAIRES HELENE SAUTTER

Tournay (12.15 Km)

Plan

Photos

Poser votre question ❓

je suis le gérant de l'établissement

MADAME CHARLOTTE BIGOT, vétérinaire à Séméac

---

En savoir plus sur l'établissement

---

Avis MADAME CHARLOTTE BIGOT Séméac

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

MADAME CHARLOTTE BIGOT 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 Séméac.

Les Grottes de Bétharram (29.22 Km)

Lestelle-Bétharram

Lac de Bassillon (29.26 Km)

Bassillon-Vauzé

Syndicat mixte du tourisme des cantons de LEMBEYE et de GARLIN (29.79 Km)

Lembeye

La Saligue (29.94 Km)

Baudreix

Office de Tourisme Communautaire du Pays de Nay (31.27 Km)

Nay

Lac de Corbère-Abères (31.37 Km)

Corbère-Abères

Office de Tourisme du Pays de Morlaàs (33.63 Km)

Morlaàs

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.