Notice (8)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) 1750068445
$cachetime = (int) 1750068455
$data = 'a:3:{i:0;b:0;s:4:"name";a:399:{s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"7de0eb817f98e54fb4e1545b78d80fe1";s:25:"`Etablissement`.`user_id`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"b3a132b3002f0a095c207367d2386438";s:13:"`Ville`.`dep`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"c5697e1e5c979d7ac16a2058fe255e21";s:13:"`Ville`.`nom`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"c1f9b57df40a583acfdf261e4793fe99";s:20:"`Ville`.`population`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"b4707c5ae31d038ddd76310d59aceb1c";s:13:"`Ville`.`lng`";s:32:"f340c52a13f3cf8684f61cdbc6725f3f";s:13:"`Ville`.`lat`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"60b99a41e18de7d4f2356593a1c2cc3d";s:18:"`Comment`.`pseudo`";s:32:"d1fcf017825e414e48d0f305631b4799";s:19:"`Comment`.`contenu`";s:32:"bc377e3ee747a291022e3d709a322d04";s:16:"`Comment`.`note`";s:32:"e6b8ac227bd20feed342e5ed0866d680";s:10:"`comments`";s:32:"91239733a2f8a455459509f5d6a17048";s:19:"`Comment`.`etab_id`";s:32:"d29a826a93311c19e41cb1fc2007f993";s:20:"`Comment`.`validate`";s:32:"c87b6288c09482f582fd3874f1e9f7a8";s:9:"`Comment`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"ea27639167a1a02263b54353d6e97da2";s:12:"`Question`.*";s:32:"8af7f1408ebbdd1538dd8cc70790e7eb";s:11:"`questions`";s:32:"be5b47378b57374e35a1086740556cda";s:29:"`Question`.`etablissement_id`";s:32:"111287abadb6722a60a40e1d9c5cc797";s:10:"`Question`";s:32:"bdec4df5fb0fd0c66bc39f7d8bc9368c";s:20:"`Comment`.`noteprop`";s:32:"4ee734bb4a3bf9ac3e4f469578ad9cdd";s:21:"`Comment`.`notechien`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"ffa9506a4511a7b9f744574dbdb4863b";s:5:"" - "";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"e98390f31e03ac9e907ae30feeeb76a0";s:22:"`EtablissementKeyword`";s:32:"f05318129420810d2df6af6f21777fb9";s:41:"`EtablissementKeyword`.`etablissement_id`";s:32:"08bee90596866040d3863d3b099b92dd";s:24:"`etablissement_keywords`";s:32:"6c66eb299f72f8ea6373806e1792c9db";s:9:"`Keyword`";s:32:"bcbd8f2dbc9172e3a3142affb2892e5f";s:14:"`Keyword`.`id`";s:32:"093651e381ef81925313bc1034b19f99";s:35:"`EtablissementKeyword`.`keyword_id`";s:32:"a88baf43cd357230f8c9342b8d8c1fce";s:10:"`keywords`";s:32:"a82fe8f431f55ca3e5c6eeb1425d6fa5";s:16:"`Keyword`.`slug`";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"cc7a4a34d97ffbb85978393c1dc3d808";s:27:"`EtablissementKeyword`.`id`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"61eedb5524a37da074a515d3499b0fc1";s:16:"`Pub`.`ville_id`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";s:32:"8ecaaa87ac95fb6026267ddc489d4e00";s:10:"`Pub`.`id`";s:32:"03bcab00ea59985094d3823102128dc9";s:13:"`Pub`.`title`";s:32:"19ae68421a7af6fd53280292661686a5";s:12:"`Pub`.`link`";s:32:"9a9117f5211facf70dbcba9197db0119";s:11:"`Pub`.`img`";s:32:"a0ec82037a4d9290d4b4962c6dd972ca";s:14:"`Pub`.`height`";s:32:"c584a2fb465c8e8da20fba3f63f5f9f5";s:12:"`Pub`.`view`";s:32:"40c6caef6b63d5cc208b1f45871b776a";s:16:"`Pub`.`view_max`";s:32:"9da1d158b7b3f5102350b7a469c676c4";s:16:"`Pub`.`national`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";s:32:"66e5e328d5dbee33a55262a8db6553d9";s:16:"`Lien`.`libLien`";s:32:"79fb2ff64077823f3178baa92162ca36";s:16:"`Lien`.`urlLien`";s:32:"977a8c4228e74376ddde512c9805207e";s:7:"`liens`";s:32:"cc4f9d77d61d874d2e27e080d8c2317c";s:14:"`Lien`.`idCat`";s:32:"1907ab5ae3897aa37d301b06478333c7";s:6:"`Lien`";s:32:"ad0fbfd477684cc1bacb27971591dcfa";s:9:"`libLien`";s:32:"beb1843f0027b751797ce20d53480156";s:10:""oresmaux"";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:"0977997639e405e6fc40722b4308e75c";s:14:""île-de-sein"";s:32:"47c5bc00073e989e4f12462579f966a5";s:7:""organ"";s:32:"037a9aa38d9a03a983da493e0e8b316b";s:25:""orgeans-blanchefontaine"";s:32:"7fda17a8b77e321fae12bfbadf98eec2";s:11:""bayecourt"";s:32:"019038f70ab3682b2426bbeb1f69568b";s:11:""orgedeuil"";s:32:"d80d3a36d7ac2c726f06e11e2d4436cf";s:20:""chatillon-les-sons"";s:32:"58c3b387b7cf36acbf931dd21d9a67f1";s:8:""orgeix"";s:32:"59949c47bda045948291eeb56fcb458d";s:9:""orgelet"";s:32:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";s:32:"70a4a1faf343973daaf7a89bac3df075";s:27:"`Departement`.`nom_soundex`";s:32:"e6b58a6fd2dddaf18714b7433a8c7703";s:20:"`Departement`.`view`";s:32:"b74474e63c80be3416038fc312c4ea9c";s:28:"`Departement`.`presentation`";s:32:"aa3e4e25ef57c9a2187d8b8f38d66317";s:24:"`Departement`.`tourisme`";s:32:"58a859cc9ae1c3a16eba65ee4ba041d1";s:20:"`Departement`.`img1`";s:32:"8d1bfdd6c45677e3b05204c9cd512952";s:20:"`Departement`.`img2`";s:32:"f237f95c23798028c944020938923a2f";s:20:"`Departement`.`img3`";s:32:"1f010ff9cf85363d260121d8f983de30";s:15:""st-sulpice-63"";s:32:"10795384b0ecb59340e297193bb79eee";s:12:""orgeres-35"";s:32:"8333667126d8d83150b96653e22071c6";s:16:""st-valerien-85"";s:32:"cb489d4d5fd722969efa5e57c8f901e2";s:12:""orgeres-61"";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:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"a315219725f5512de7f49d3389fc6d1a";s:8:"`Post`.*";s:32:"cfacfed443d6f30e67edf9bbcb06ce30";s:7:"`posts`";s:32:"c0a33fa0f04ac4682dcdc4b25167b3a8";s:6:"`Post`";s:32:"d20e7bceeb0135a07432718f0d5096d7";s:9:"`created`";s:32:"f333271de2d9158051047b7c7178429d";s:19:""orgeres-en-beauce"";s:32:"addb94f77806c06fbdcc32a7ec78aa6a";s:19:""meigne-le-vicomte"";s:32:"cc5bde3abaa177d24c17025c69a94f25";s:4:""24"";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:"d25e7cdb8a10ae8dbc6da712803e225a";s:10:""ableiges"";s:32:"f12710d241036f3828e5e1df59acb87a";s:4:""96"";s:32:"a151f1ddbb020c752f0f1eeeac40041e";s:13:""alboussiere"";s:32:"1f37ebad5b019bb170abb6697584f64d";s:3:""7"";s:32:"4ccde7420656159383d99f5c5affba7a";s:8:""gieres"";s:32:"350df01e677bc5e8dd3bc68af78b589e";s:4:""39"";s:32:"598661d3b036188ff6ef5d152818562f";s:6:""vias"";s:32:"097742fd62f89173f16da07e9cc56201";s:4:""35"";s:32:"073bf0a7938f0ff9cea63a47cf858cea";s:12:""orgeval-02"";s:32:"550927bba98e1906fc09631fe30b40d8";s:12:""orgeval-78"";s:32:"aeb12b14e510f38834502cbb1ae486a6";s:9:""orgibet"";s:32:"e42dfef655d50d9446a2ee29b9e7ddaf";s:11:""orglandes"";s:32:"d91d5b2483fd67dc0b4db209d0283203";s:15:""orgnac-l-aven"";s:32:"664d4e5dd3e84fafef62f8315eae55db";s:7:""puits"";s:32:"d8a54c4ef8618c220e17597627db63fd";s:19:""orgnac-sur-vezere"";s:32:"2a2f520a0b7d4024f95799ec306d6c35";s:8:""rouget"";s:32:"b08b075603c6b33d6293d3bd484ddbc3";s:7:""orgon"";s:32:"de52989621238b5497de5b90b498197f";s:11:""renescure"";s:32:"e28d80131382a902b40b74a5e90db4f2";s:9:""orgueil"";s:32:"e96a0c20657f767583b7ab0f1e2bf9f3";s:10:""oricourt"";s:32:"c9ac8b5e2cd373f2588617afb6e6ceca";s:29:""st-germain-de-clairefeuille"";s:32:"003876aff02888b036a3635ff63ff1f5";s:9:""orignac"";s:32:"684d83cfc72e92484ad614e633929eec";s:11:""origne-33"";s:32:"22d72cdff8e119a02454b1ee4b6f439f";s:11:""labastide"";s:32:"162748a123093d28ac843439ab26c22a";s:11:""origne-53"";s:32:"4da46c776b58ab07d2209027e2feb3a5";s:12:""orignolles"";s:32:"bbb804dbfe6138efc19003d076365995";s:15:""lavercantiere"";s:32:"4f0680701bc754ee7ef061ef90791989";s:8:""origny"";s:32:"b44c88211daa82da5e3ad378e767700d";s:12:""letricourt"";s:32:"0745f6b293a65223664626232d4d413c";s:21:""origny-en-thierache"";s:32:"9f17e4b7ea3c866e1a42ad61ce80595e";s:17:""origny-le-butin"";s:32:"9b207ae8493b1bd29de32be20f58d46e";s:16:""origny-le-roux"";s:32:"ab3d817e94188fb854d4cdc4eb85c604";s:15:""origny-le-sec"";s:32:"fd802a699e1705b02404d8b37824d6d1";s:20:""origny-ste-benoite"";s:32:"5bd42ba81d0c841b6a1f018f5e9e12b6";s:12:""montdragon"";s:32:"502fa0b0189e9298367e2a6eec963ffd";s:6:""orin"";s:32:"38b9cab03c4ddc10fc93f13666389386";s:10:""orincles"";s:32:"8809dd4cb1bf24e50f07b16d6204a698";s:24:""morvillers-st-saturnin"";s:32:"9b708a2325bc54bed5e12a5f16e4b0cc";s:11:""oriocourt"";s:32:"e75b3d4429490426835d0d24eff2932a";s:17:""oriol-en-royans"";s:32:"92fc41323f8d47e6a8d3775085222964";s:9:""cabidos"";s:32:"0fe871c7cc44875c70df11cfaae96589";s:10:""oriolles"";s:32:"ddbf9fb623a29f429539a86ce6ea7cd2";s:7:""orion"";s:32:"fcb86fa6a6f64518a0f6fb97dcd3dfbd";s:14:""baraqueville"";s:32:"52a8c6ab4f69e402f37349a5fb5b2a73";s:4:""12"";s:32:"4fd6b618bbe6d57f3574259093c8848c";s:14:""mesnil-aubry"";s:32:"422cbb72d084fba80eacb2c16ab43a53";s:9:""bias-40"";s:32:"46285367973c1d568ab8b875167aaaf5";s:4:""41"";s:32:"5031ad69316a2cd3c47b86a274534d1f";s:11:""orival-76"";s:32:"34f4771b1c3fe0834b10966c88b755b4";s:9:""orleans"";s:32:"7add14066a70eca721d562e2e478d530";s:12:""cardonnois"";s:32:"fd3ecce697206c45a3af91bf0e1fadf5";s:8:""orleat"";s:32:"bfa531d17b93fcac6000bdd3a2470345";s:12:""malvalette"";s:32:"38910b5f5001b084555a03a28492bd94";s:4:""44"";s:32:"8c8e4edf72e69f8da29e766dd65766e8";s:8:""orleix"";s:32:"249ef382bc949999e62561ba7a7e4aa9";s:12:""mareuil-24"";s:32:"4c9f5a825e49a6ba84646a996b6447f9";s:4:""25"";s:32:"0bd4a3e2a40318e73534b2e71ab4dc4c";s:8:""orliac"";s:32:"4e3bce6228878e322e9efea5ac7ffa13";s:15:""orliac-de-bar"";s:32:"5da8f6249181cea0ecfd0956714d64cb";s:11:""orliaguet"";s:32:"4b49dd21dff2f7256b7eff15976f876d";s:10:""orlienas"";s:32:"d7118d079c805829df1b166d96f4610a";s:9:""orlu-09"";s:32:"60ca35d785f88461293c5016241ffae0";s:9:""orlu-28"";s:32:"9c647c3eb22595e4e8436c1b638ef7d3";s:6:""orly"";s:32:"67e97141b825b08a8d4ca695977b20c8";s:15:""orly-aerogare"";s:32:"756c68e2d0302d3bf13484d4f8dac68e";s:16:""orly-sur-morin"";s:32:"286b81f44f14f8fcd93c35510545bf19";s:21:"`Departement2`.`code`";s:32:"173b6631916609913bb5f9b18a8c11d7";s:10:""ormancey"";s:32:"bd919f1be159e717bed79264f26a656b";s:10:""ormenans"";s:32:"60ed94cee39564a37b445906c9c0aa88";s:12:""pacaudiere"";s:32:"7142166d1e9021c22af48d53bc32d9e5";s:4:""43"";s:32:"6ff9b106a564fc0077e1e19f7a984073";s:4:""59"";s:32:"145e217a67656942adea8857cf844295";s:23:""vignoux-sur-barangeon"";s:32:"9d410b12215ce4f7fdc71e4e3019753f";s:4:""18"";s:32:"5f859e0c2129391557c85e2ce130ce67";s:14:""ormersviller"";s:32:"a1ac42450bd1111d8370fb8428a1ad1c";s:4:""74"";s:32:"5194e40933494b8dbad266103c8deaa2";s:26:""st-sulpice-des-landes-35"";s:32:"baae300ee34d04d5bf23974b23f101e4";s:4:""36"";s:32:"677abba52a4b87eb227c07821ffd1616";s:8:""figeac"";s:32:"3725365c00eaa85fad851e085a15c14a";s:4:""47"";s:32:"4570db0a80e8f0e239367356d97aba51";s:10:""ormes-10"";s:32:"654f167b20e2203371702b2ed8b00149";s:10:""ormes-27"";s:32:"fcf271463fa023d920a1c9b932e97b78";s:10:""ormes-45"";s:32:"00f5086a613b6ed738191182b6ef22ff";s:10:""ormes-51"";s:32:"1ed603887cc52c4db10f1fcbf7d09eef";s:10:""ormes-71"";s:32:"50c010c14bdd4e06d152af49bec6cc07";s:10:""toulouse"";s:32:"8789547c05bfa02798ab3128eea30e2d";s:4:""32"";s:32:"ce071c3954d5512e009c7b46202f8e5f";s:10:""ormes-86"";s:32:"b9d6428e60451b368905a8f3c894c200";s:10:""ormes-89"";s:32:"c06fbdc9d1f1cf812926f5d535c622f3";s:16:""ormes-et-ville"";s:32:"bd0513ee11b720a9f4f22fe042e4cc7d";s:19:""ormes-sur-voulzie"";s:32:"763d6cab44316e0e3f4b570a17c576f2";s:10:""ormesson"";s:32:"0bd12c6f09869eccebc0b674b3a4ac95";s:20:""ormesson-sur-marne"";s:32:"fb072838c6cfd074a164b6924cf5a589";s:10:""ormoiche"";s:32:"44a7b5ab8b5840d84f9fa9aec0cfd8e8";s:10:""ormoy-28"";s:32:"10666432f9e47ce42115218312cca6ea";s:5:""dax"";s:32:"e43f73c74c66148a5143e4b66e571993";s:10:""ormoy-70"";s:32:"90921964be4e051c7eb9525459ebfa58";s:18:""beaulieu-sur-mer"";s:32:"d371d84dadaedf3ea26335f52f4c9b20";s:14:""aiguillon-47"";s:32:"7d8332c40ede7afa36d4eea6315bdc9a";s:4:""48"";s:32:"5c5186aec7a0a63122506633dac358b0";s:4:""06"";s:32:"f1571e1e749bf200f2ca2dbe10d6b42f";s:10:""ormoy-89"";s:32:"405234a249c994247cce61d5cd2aaa12";s:12:""monguilhem"";s:32:"7fba278df5e405b47ffb87433a2039a7";s:4:""33"";s:32:"55544c707b4c0ae0a612d05027e9672e";s:10:""ormoy-91"";s:32:"696b71dad1fec0540127f4c1eaff3de5";s:18:""ormoy-la-riviere"";s:32:"4b6bf2a07234e4b5d62a9c33653234b1";s:17:""ormoy-le-davien"";s:32:"b06c6ac9123936defa46ab924b68f30f";s:7:""blois"";s:32:"bdd2cab4714f4907b3fc8a0ff2f6f7cd";s:4:""42"";s:32:"888c8c07f94bacd6e4257f6f298d3701";s:24:""ormoy-les-sexfontaines"";s:32:"4308a34647875ab5a64a29235b58c87d";s:10:""martrois"";s:32:"caac65935e24e5f61350565aab805c78";s:15:""ormoy-villers"";s:32:"2b8fc1807c23f5885226ade8d805fa83";s:9:""mesquer"";s:32:"6fc0c5b72ed2c63b414d0491fdefc830";s:11:""ornacieux"";s:32:"8d771bd552db98a894e4d5c4f7b72579";s:22:""montilly-sur-noireau"";s:32:"c38b1fdb0b318ab1eb46c045f33e1e2e";s:11:""ornaisons"";s:32:"82cdec3c09623014bd12372b72acdd19";s:8:""ornans"";s:32:"01f1db3d15b847bb6706cb47dd74968d";s:13:""montsurvent"";s:32:"8ecb99d036d2d09cc51e7b45efbd6d5f";s:7:""ornes"";s:32:"e04907b228a3444c50606cdef1d4d7b3";s:13:""mortemer-76"";s:32:"4f6155705e6b133157ba93cba6de2662";s:21:""mousseaux-sur-seine"";s:32:"036d43b1332d874b77168910cedb8ad0";s:7:""ornex"";s:32:"e1d95f7d25f551416da4ed064cc44e92";s:13:""moutiers-35"";s:32:"4fb10662c6178e4d4d9468365e380a68";s:10:""norolles"";s:32:"4477f62b3f8c7bfb8758f2ac97c41ec8";s:7:""aspet"";s:32:"03bd2348b21ffe8b005b390634683116";s:18:""sarlat-la-caneda"";s:32:"d0cb6643bfa15c0def078dba89083012";s:8:""arleux"";s:32:"e8ade83b3133886783b73dbe2958bd22";s:4:""60"";s:32:"0f738a11e80d98fcc5f6412dc29ada34";s:22:""pernes-les-fontaines"";s:32:"f9f5f147f05d82ada7e773fb4b3a613b";s:4:""85"";s:32:"cadb21b62af1bd5ba11f1b9a6ea79bd5";s:18:""meslay-le-grenet"";s:32:"13108ecd230ac992c904d2febc925703";s:4:""29"";s:32:"e1543630535f2119d0dc7588b34698c1";s:8:""orniac"";s:32:"0a5d762120773929d096d7ef63afe885";s:9:""oisy-59"";s:32:"952fcba4c757c0d080dca6a37b49740d";s:25:""ornolac-ussat-les-bains"";s:32:"3dfcabe736d3d29c247792a3fcef87a1";s:11:""oppedette"";s:32:"ddd34ba2fe5b8a28f2a178b624f2dbdf";s:11:"`Agregat`.*";s:32:"c1ea053113d962dbaa050c3a22a0d1d5";s:15:"`Departement`.*";s:32:"99f486ac87e748598b211a14775326bb";s:4:""91"";s:32:"48213f5d898206effe03b2f20b1ed121";s:7:""ornon"";s:32:"f425a44effafc3c6a3f832120a184541";s:6:""orny"";s:32:"fe39b709462a6514bac764c764f1f6e7";s:7:""ougny"";s:32:"d7d776c4329581104f8124f401f99db5";s:7:""oroer"";s:32:"da5ee6023b23fd943501d6e2541cc43b";s:7:""oupia"";s:32:"b7bbef389061b18a6c93a02a501249e1";s:7:""oroix"";s:32:"c986423d200e22fd9219587f1e6e981b";s:9:""pîtres"";s:32:"b7e3baadbf734d700d5509a831f4e795";s:7:""passa"";s:32:"c63cd9c4018abac707fac2dea0be8847";s:8:""percey"";s:32:"7ce490648a9534d186ef8f7bb1a3f3b9";s:6:""oron"";s:32:"9ffb0eba8bc9b04c76d6330174e20b83";s:14:""baie-mahault"";s:32:"f54888a6f2560d5d39f5383499c461e7";s:4:""98"";s:32:"2b93c5d5c9fdde256b3b3b4f595fbadb";s:9:""biganos"";s:32:"a982bbb042538731dfd4791b2b615ac9";s:4:""34"";s:32:"42bc1e17a7b3e41d654a07513094eea0";s:12:""perreux-42"";s:32:"a816eadf2e70b93af9a0b720a29278f6";s:14:""champfromier"";s:32:"5098b74cdb212058f0c542fef23214da";s:8:""orphin"";s:32:"804e3784b7e8ffc7a0c4ccc1e85a430f";s:10:""orpierre"";s:32:"49a64de922909813a2dbbabbb235d086";s:9:""peyrole"";s:32:"7e6078803f2badf5ca3112c75565fb2d";s:8:""peyrun"";s:32:"593accd4789504f86c28d938da9757bd";s:11:""orquevaux"";s:32:"b9c99fca56fc707dcf509e8cb1895e6e";s:7:""orres"";s:32:"38e0b85ee1c101457f838a6e22a3ad28";s:10:""piblange"";s:32:"adf7e70015e580298b602fb233630fc7";s:7:""orret"";s:32:"3d5565a0453726d8002218414c0e3ae3";s:16:""pierreville-50"";s:32:"5ee52c1df02350fac9d7041d5b52ee12";s:4:""40"";s:32:"cb554817e874ad904a334bc8a3b5288c";s:10:""pinderes"";s:32:"70de4d107f498b438e2580791e66d6f4";s:9:""orriule"";s:32:"13d2692796a894010e322f7ce65ae7eb";s:4:""46"";s:32:"d44f8cec58bdc9a9d134944734e60b23";s:9:""orrouer"";s:32:"e6c6f6486b70b783a3cfa49c134765a4";s:8:""orrouy"";s:32:"9a3fa5283a4075f865bf69509331b284";s:8:""pirmil"";s:32:"fd3b0576527f8b4160e4ef47801df363";s:17:""poggio-di-nazza"";s:32:"e59131333c7ec9b62b34e8cfed7b5e33";s:15:""orry-la-ville"";s:32:"2d48bba10504af4f44d7988262d3e7a4";s:12:""poilley-35"";s:32:"8356bcaa9948b85f27a84bf52feecc6f";s:5:""ors"";s:32:"9f8f6e437689294f9c88535346c0a3e2";s:19:""poiseul-les-saulx"";s:32:"5b796f0cb1a0ca4f9d306727c9fa51ae";s:9:""raismes"";s:32:"4ba4b586222300963ff1ce0588a6f7a0";s:7:""orsan"";s:32:"488dc58151d11d4bac6bafc90a267222";s:4:""66"";s:32:"38659f7d67a1ae49d75abaf3b9c7b601";s:14:""polastron-32"";s:32:"30e0fbe2dedd7496d6607455959eba37";s:4:""51"";s:32:"b4162a400155f48cecc2264b77e77158";s:15:""sarreguemines"";s:32:"99ac0e71a40555b4f9bd78c12ecffe15";s:4:""58"";s:32:"a5aec07eefc1b51707a7307094944a1e";s:12:""ponteyraud"";}s:6:"fields";a:880:{s:32:"8ee4e381878886a74715e50c607da897";a:60:{i:0;s:20:"`Etablissement`.`id`";i:1;s:23:"`Etablissement`.`siren`";i:2;s:20:"`Etablissement`.`rs`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:21:"`Etablissement`.`img`";i:5;s:21:"`Etablissement`.`pdf`";i:6;s:21:"`Etablissement`.`lng`";i:7;s:21:"`Etablissement`.`lat`";i:8;s:22:"`Etablissement`.`desc`";i:9;s:28:"`Etablissement`.`historique`";i:10;s:26:"`Etablissement`.`chambres`";i:11;s:30:"`Etablissement`.`restauration`";i:12;s:27:"`Etablissement`.`situation`";i:13;s:25:"`Etablissement`.`parking`";i:14;s:30:"`Etablissement`.`animauxadmis`";i:15;s:29:"`Etablissement`.`equipements`";i:16;s:25:"`Etablissement`.`langues`";i:17;s:24:"`Etablissement`.`tarifs`";i:18;s:28:"`Etablissement`.`supplement`";i:19;s:26:"`Etablissement`.`capacite`";i:20;s:26:"`Etablissement`.`categ_id`";i:21;s:24:"`Etablissement`.`adress`";i:22;s:25:"`Etablissement`.`adress2`";i:23;s:26:"`Etablissement`.`cp_ville`";i:24;s:20:"`Etablissement`.`cp`";i:25;s:26:"`Etablissement`.`ville_id`";i:26;s:21:"`Etablissement`.`tel`";i:27;s:27:"`Etablissement`.`telecopie`";i:28;s:23:"`Etablissement`.`email`";i:29;s:26:"`Etablissement`.`site_web`";i:30;s:25:"`Etablissement`.`partner`";i:31;s:27:"`Etablissement`.`full_desc`";i:32;s:21:"`Etablissement`.`fin`";i:33;s:22:"`Etablissement`.`view`";i:34;s:32:"`Etablissement`.`departement_id`";i:35;s:28:"`Etablissement`.`agregat_id`";i:36;s:22:"`Etablissement`.`pets`";i:37;s:26:"`Etablissement`.`horaires`";i:38;s:27:"`Etablissement`.`date_call`";i:39;s:32:"`Etablissement`.`recall_creneau`";i:40;s:28:"`Etablissement`.`convention`";i:41;s:33:"`Etablissement`.`convention_text`";i:42;s:33:"`Etablissement`.`convention_date`";i:43;s:29:"`Etablissement`.`financement`";i:44;s:34:"`Etablissement`.`financement_text`";i:45;s:34:"`Etablissement`.`financement_date`";i:46;s:27:"`Etablissement`.`direction`";i:47;s:32:"`Etablissement`.`direction_name`";i:48;s:33:"`Etablissement`.`direction_email`";i:49;s:32:"`Etablissement`.`direction_move`";i:50;s:32:"`Etablissement`.`direction_text`";i:51;s:32:"`Etablissement`.`direction_date`";i:52;s:32:"`Etablissement`.`recall_travaux`";i:53;s:32:"`Etablissement`.`recall_maladie`";i:54;s:30:"`Etablissement`.`recall_autre`";i:55;s:29:"`Etablissement`.`recall_date`";i:56;s:29:"`Etablissement`.`observation`";i:57;s:25:"`Etablissement`.`user_id`";i:58;s:26:"`Etablissement`.`modified`";i:59;s:25:"`Etablissement`.`created`";}s:32:"45aa8e323441f4a058f9507aa58c1170";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"5ef5376c23915b319c95a55e27b463e2";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"4e1a697404c869a9c03323a32603f511";a:3:{i:0;s:18:"`Comment`.`pseudo`";i:1;s:19:"`Comment`.`contenu`";i:2;s:16:"`Comment`.`note`";}s:32:"1cbe811be4bff73e7bbcc2dcfcc35e3c";a:1:{i:0;s:12:"`Question`.*";}s:32:"6322747d71d2e67fa56eb794b4a20519";a:2:{i:0;s:27:"ROUND(AVG(note)) as moyenne";i:1;s:21:"COUNT(*) as countNote";}s:32:"6c20e359124192a0c10f2b0c233a566a";a:2:{i:0;s:31:"ROUND(AVG(noteprop)) as moyenne";i:1;s:21:"COUNT(*) as countNote";}s:32:"9a6ee3dbbff9f4abcff6821e49e118a3";a:2:{i:0;s:32:"ROUND(AVG(notechien)) as moyenne";i:1;s:21:"COUNT(*) as countNote";}s:32:"445cb8bdcd289d5638a4c3934c4377ad";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.916667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d2407751c0efc320dadde1da32fa3b78";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.916667- 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:"f1cc5d7fa5f17dac386d8a8fe01e0b92";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((48.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"bfd86fef84d866611c80071e3cfccd11";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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((48.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f0d62901f76b5abe7816ad11f20cd1b3";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"0cee2d085143a8852cce1c67d5991eff";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(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"4314bd4ed5fcf1eec8514515e173014d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6ef1b378f8063bba814c756fc2370b66";a:2:{i:0;s:368:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"31dab717b41e6b33bca5d6ba31234408";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:190:"(((acos(sin((43.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ee5f075a7d04870dd8858da54cf382ca";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((47.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"bd79676674a24db2e8fc0ddbdff5defe";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((47.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4cd562d3a97b41a66a6dd9016a20ed61";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"c155f9f6b4201f6c65072a1e7f46c2b6";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d07bb0dc66c8b9005a4ee5fc0b7b92c5";a:2:{i:0;s:368:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"acc22f9fd08490005631122499c08957";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:190:"(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9dff558c3c8defb5bd531280b535104c";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"5470a9cfb2211ef7b9a50b6bac6a4372";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8c14c75eee97eff0c2f1fc4b81785cd2";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.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"44d1b4b5fc6ef0cbab96a6a36f348747";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d01f05993e4b859ef34b15d5aa54e225";a:2:{i:0;s:378:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a2c6586c2040c80871d75a5e0a7dbf94";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:200:"(((acos(sin((46.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ad0bb9db2e1dc6ecabe203784a321d21";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((46*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"cb43b6c2210ab7811acee08136038bdf";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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((46*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbd945c5faa47e9d6fa3b3de911c97e4";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"56ac03917e3e4b7e2dc17b7eace55934";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((45.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"32d8d1d216724c3afe58c18abeb9b05d";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"66e5ff2b1e4e76813567ba68792ffb11";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6d09efca14e141b15eb9c636dd10e210";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.9545*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9545*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:"aafcbc6c5f2bdff9888173e2722ef755";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9545*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9545*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:"7e44cf5e30bfb341980b935547f6c081";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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"64cbc8fb6ab499d2a4c6d40871aca8b8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6aed85663bd1bd4705d853052038f2f6";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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8333*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:"4fa9d7bd64f6f4507c5babe1d9305b35";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8333*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:"046d57c9b790b29c26a0ebb9873647bd";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9167*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:"a463d9afb3b244efd5e895ca787bc587";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9167*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:"25459f2a16236e41b83c14bda09563e5";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"793066456e98791549762e48c5941fd5";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a5f757cfd2d242d3d76c16d8f3525264";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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"34a3d35c74117c93acdfc3c8bd6ce1a1";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"35a2385e2411f9c6c3d9c8dc0a3c4536";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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"81fb19c5cb3587251492d962c3a3c8ac";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"bc013b7883512024414e377d97f654f5";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"a65ff2a25464afb8aa962a5b856ba406";a:6:{i:0;s:14:"`Agregat`.`id`";i:1;s:16:"`Agregat`.`slug`";i:2;s:14:"`Ville`.`slug`";i:3;s:15:"`Agregat`.`lib`";i:4;s:19:"`Agregat`.`libRech`";i:5;s:15:"`Agregat`.`img`";}s:32:"61ae4de0b32204c3b056d6e2623132a2";a:2:{i:0;s:14:"`Agregat`.`id`";i:1;s:46:"(COUNT(`Agregat`.`id`)) AS `Agregat__nbeEtab`";}s:32:"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:"08d8887aff65252f7889296226a79665";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.26667- 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:"78187e588739c73b2bd588de22f6bf69";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.0362*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0362*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.14889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bf3ab950451e3ff2cb83aac5def496a8";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((43.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d868542e10cef853369425063dbc1460";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((47.2634*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2634*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.74362- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8cfc36bfce06ce09c9786e63c2f3a710";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2667*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:"432c4c1b1e261c16889d56afc876b7bb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((45.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7*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:"5077737d6d6c74a805ca149910b50606";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((49.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9a20fd03485495438a6de926f16723af";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((42.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ca5d944713d3c68205be2b72e4ea116f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((46.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}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:"c86887cc270702eddf323a7b90eb2682";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((45.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4895ca1257475e3a774f8072baf51ffd";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ee667be3f0ac9ee1c29039d38a7e5600";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:201:"(((acos(sin((46.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.933333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b6c20513a16ab05bd0bf4d7266d5c973";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*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:"e95a8b28a89acf3c35ecec05ce1e8678";a:13:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:24:"`Departement`.`tourisme`";i:10;s:20:"`Departement`.`img1`";i:11;s:20:"`Departement`.`img2`";i:12;s:20:"`Departement`.`img3`";}s:32:"26b854aececdcc92884bb15e85b005db";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"e8dfa4887c70f8b59ccd5552316f3338";a:1:{i:0;s:8:"`Post`.*";}s:32:"5487fda9911791f9f760d04cf4a96f54";a:3:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";}s:32:"1768885bd7dbab739b1c10fe00672843";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:49:"(CONCAT(code, " - ", nom)) AS `Departement__lib`";}s:32:"5745474c872d7b9a6bdcecb59dbbeabf";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(((1.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8a3ce99ac807870b239f32fd84d63143";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((47.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5167*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:"82f1ee2e4fb492b46aef298525c0541e";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"f05dc24f8ba7bda90ca6aab255b63734";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"17104e6a38d1757b57af7f73a69251c1";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"100fbe71e1aeb618456787beb825df32";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((45.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c2ae907ab1e4b8d941dbd8f7396b4f76";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"1cb270d2a080a9a19a7568e515197e9b";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((46.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"16de236db02d70fee993a1fdcf3a6947";a:2:{i:0;s:368:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"b19f6d88f73a38d4c46efeb41953cee0";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:190:"(((acos(sin((46.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"988d5e6a12b709e0e8ad7176948f5e89";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"54a283374b1205475efac20c02c884f2";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((46.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fe096062a37a2102b62dcb5ff13fba7f";a:2:{i:0;s:371:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"2550391942d6de4c0ae309ee0f100001";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:193:"(((acos(sin((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"df91a363144073016baf2dc93b79ba76";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((42.635*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.635*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((8.93751- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"59fa174a0a0892db38d734c9021f0c6e";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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((42.635*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.635*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((8.93751- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8d661721db9ab178a1ba38fc3be9a56c";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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3a9800635955740adc902fc0ec74af2f";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6167*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:"8ec6ecd72289a29072b69c0437a79ca4";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.933333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e9215b6d6540d73c68af4aee3d5f4987";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.933333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e92250dc24247b13b2a5d571e319865c";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.815*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.815*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.14861- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"20e231cc7c82b33c3ce6d14b2adf1bb8";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.815*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.815*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.14861- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bf82a87812fcb0712762797d5c1142d4";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*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:"548a735259c72e59f57af2ea42e06803";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*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:"b6ff72f9e3783d2a6993d92eb0abdf5f";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"65f8551661c31ee4109a78dbc9e7c595";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f933b9920ffa3353ccd68c6b4cb2cb4d";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((48.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"fb8604d7ecf899f32e9c7b7a5ff14306";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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((48.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0bce7eb441b3ade4b17c29383d6997c9";a:2:{i:0;s:370:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((45.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"e87e21aec3f663f56505669d9a1312c5";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:192:"(((acos(sin((45.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"510031a735d1098f8f49f0b7ca53a605";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"6d8dd49a1223e7b273fbc13e1eefb0a2";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"514be008786be98312a8851383339d59";a:2:{i:0;s:373:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"fa0b1a45b60bdcc0cd0c8ac87654e62c";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:195:"(((acos(sin((46.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2dd67114ac18dc13850ba05b20efc8a";a:2:{i:0;s:377:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((46.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"41ee0ff43401e34d0078f30b0fdd397f";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:199:"(((acos(sin((46.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc8435a1208f95d4c2d0f4ebdb270fde";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"a493563cd52defce8fdd5e2eb92bb45d";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c9a03d0a47efe4deeea944c51e1ca96c";a:2:{i:0;s:368:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((43.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"3bb7a282c778b6b0ef181341b3359e91";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Et' 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)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) 1750026445,
'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 Avis Hôtel Le Lavachey Tignes (73320) : avis, téléphone, horaires,...
Hôtel Le Lavachey, Tignes
Montée du Rosset
Hôtel dans la ville de Tignes, l'établissement Hôtel Le Lavachey ne nous a pas encore indiqué si il accepte ou non les chiens.
Tarifs
Non renseignés
Nous Joindre
Coordonnées non disponibles
Hôtel Le Lavachey, hôtel à Tignes
En savoir plus sur l'établissement
Avis Hôtel Le Lavachey Tignes
Actuellement 0 avis. Vous avez apprécié cet établissement ?
Laissez-lui un avis !
Questions des intéressés
Hôtel Le Lavachey répond à vos questions
À proximité de votre hébergement de vacances
Quelques activités, lieux touristiques ou d'intérêts dans le secteur de Tignes.
Eglise Saint-Jacques-d'Assyrie : En accès libre (0.00 Km)
Point info Vanoise de Val d'Isère (7.61 Km)
Eglise de Villaroger (10.05 Km)
Point info - Accueil de Landry (14.12 Km)
Eglise Saint-Jean-Baptiste : En accès libre (14.51 Km)
Eglise Saint-Michel : En accès libre (14.95 Km)
Eglise Baroque Saint-Pierre (15.84 Km)
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.
