$key = 'myapp_cake_core_method_cache'
$time = (int) 1750074881
$cachetime = (int) 1750074891
$data = 'a:3:{i:0;b:0;s:4:"name";a:461:{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:"090f8b730290f8550e329f26ed471ffb";s:9:""nesploy"";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"e7c32d144dfbfdcc3f58ae21827b8236";s:14:"`Departement2`";s:32:"67aacecb01204237dc496f70dd03bb8b";s:19:"`Departement2`.`id`";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";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:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"ad5832d3fe38e9a3ae4ff5a516294a79";s:12:""ploumagoar"";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:"4fb5749a2fa537436d74da4c5348b6a4";s:11:""bischheim"";s:32:"96eab8efae26a39620ce9cda92835ece";s:22:""neuville-aux-bois-51"";s:32:"b202ea44306a80f4f87da9794c9121e8";s:13:""ploumilliau"";s:32:"6957f1332d515601e135852f1feba2c1";s:26:""neuville-en-tourne-a-fuy"";s:32:"34cb9e6344101e2b832a248d252aa25c";s:12:""ploumoguer"";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:"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:"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:"1948a773876a158286b4db620922e4c6";s:13:""roquecourbe"";s:32:"4f9cd7d551ea5f6145781cf46d186558";s:4:""82"";s:32:"d096a0e47d35cc9ce5790cbbc44662c2";s:14:"`Departement3`";s:32:"0ec37699516eae0626bc53868916aa75";s:19:"`Departement3`.`id`";s:32:"ca639aa7397edb23ae76abc30e7d92a9";s:23:"`EtablissementKeyword2`";s:32:"fa37476c14e8bdb8e6403cd8dd4a24c1";s:42:"`EtablissementKeyword2`.`etablissement_id`";s:32:"2fe35282e812004170a32d85be0bf39b";s:10:"`Keyword2`";s:32:"783b4f7a045247c9e0b0f4b51cb73512";s:15:"`Keyword2`.`id`";s:32:"ea0e3653b3104978eb6a8c20321867ec";s:36:"`EtablissementKeyword2`.`keyword_id`";s:32:"f0390fa2e07b4a53538ebc42c3a44987";s:15:"`Keyword`.`lib`";s:32:"002849c2354331d18dc50d9a58fb23c1";s:16:"`Keyword`.`desc`";s:32:"b2f06ded35217196d1e2063a349f01c1";s:16:"`Keyword`.`view`";s:32:"65fdef50318c78482920242502f98c10";s:19:"`Keyword`.`created`";s:32:"53ba12bfcc4a17ec6c1d401917cf8c91";s:6:"`view`";s:32:"dfbba30d1f72467a860b279eae73a5d7";s:9:"`nb_view`";s:32:"574429db73f23e92fbf2f7bf6ce55bcc";s:17:""plouneour-menez"";s:32:"c9f85cd6c824f0d1e2b5d9c27650df04";s:14:""attigneville"";s:32:"5b2f330d6cad4adcaff0785a2c6b85a3";s:4:""89"";s:32:"7022a22c8a4b8a552f850004eb183999";s:10:""nogueres"";s:32:"398a7fe9fc4104c098e379761b085ba1";s:16:""normanville-76"";s:32:"acb27c92f1f165c73ea1f2743242a8c1";s:16:""plouneour-trez"";s:32:"9615e70e95e6ea312a83aa71c5a976fd";s:11:""oberbronn"";s:32:"c03f1d3ebd617058ad3e60d47edf8c09";s:11:""plounerin"";s:32:"fa824e0fad313faa34227df742319ef7";s:8:""obreck"";s:32:"516995475c50023592fcdb6bcb098366";s:14:""plouneventer"";s:32:"cb8a7da8622e8fbd0209982b52e0c709";s:7:""ocana"";s:32:"30a7d7280ef5b459053d5351a845f20b";s:21:""omonville-la-petite"";s:32:"b13663fb4357400e94a579c7fe5a5264";s:20:""plounevez-lochrist"";s:32:"7b69cf65a785cfaa32b10f044a27a96b";s:9:""oissery"";s:32:"195537a41e29a67bac30d3851a93dc9c";s:7:""orges"";s:32:"cbe14414962fba4de4cf45b1179009ca";s:18:""plounevez-moedec"";s:32:"fb072838c6cfd074a164b6924cf5a589";s:10:""ormoiche"";s:32:"036d43b1332d874b77168910cedb8ad0";s:7:""ornex"";s:32:"355b0fa6b6c60ef49e951d9316dbd065";s:8:""ouides"";s:32:"3218d4ca768cc9c19d494f4158500672";s:19:""plounevez-quintin"";s:32:"2f7f99f0e10230d927c4b78c7ed07818";s:18:""st-paul-d-izeaux"";s:32:"851b736803c5f49710a1d6b62039dc8f";s:11:""outrebois"";s:32:"ff2498b24336674966d2e63c3060c01f";s:13:""plounevezel"";s:32:"618994600e13a09b17b97fd49c991848";s:17:""ozoir-le-breuil"";s:32:"74a44968684b059d35f7378e09298b11";s:19:""parfouru-sur-odon"";s:32:"74ab93ec5bfaaa95e681da8f16440407";s:11:""plourac-h"";s:32:"2ecb7caa6fb453539790df77b1ae32b9";s:9:""harmoye"";s:32:"47ff6962f1b7e7bd8323a3cd4655ebbb";s:4:""23"";s:32:"ddd34ba2fe5b8a28f2a178b624f2dbdf";s:11:"`Agregat`.*";s:32:"c1ea053113d962dbaa050c3a22a0d1d5";s:15:"`Departement`.*";s:32:"52a8c6ab4f69e402f37349a5fb5b2a73";s:4:""12"";s:32:"c6610bb4f7c279a3d1c2a2f8a57549cd";s:9:""plouray"";s:32:"f585b9ec3d6fa7c7e6cd89ee02d57f33";s:8:""paulmy"";s:32:"597ec48388b39edc0e8d2cb714866cc0";s:10:""plourhan"";s:32:"fac7312560ccbb655389b526ee0e6f23";s:9:""paziols"";s:32:"ff12387e84a1ed3409d5eb85685f4e8c";s:5:""974"";s:32:"5bd96d1ce293d04f14e2f62599ab70a3";s:9:""perouse"";s:32:"2828d9771ebe1039e72eb5e7157d2e5d";s:20:""perrigny-les-dijon"";s:32:"98fe0311aec65bc2bba8c247a172ce5d";s:9:""plourin"";s:32:"e87ca75cc7c00dc4e4cb634d491aefdb";s:12:""torreilles"";s:32:"8180a70af018b9db6ae0f361c5c2bf8d";s:21:""plourin-les-morlaix"";s:32:"9ac5634c4aaeebc55d5610cb7c15a3ff";s:12:""meillonnas"";s:32:"c86a33e43fb18e4886b0cbf9fcbf4553";s:13:""montagny-73"";s:32:"02b6340a8c98453504eb092f4a844530";s:10:""plourivo"";s:32:"03101f85507db9a753e1f9b4e0264717";s:26:""monteignet-sur-l-andelot"";s:32:"f3cf54c74e3046bb151a3704ac88505f";s:10:""plouvain"";s:32:"4f9d69df8a6ec0c0d52c64fafd7de0c9";s:10:""montloue"";s:32:"2bd5d12558bf927dd28a34dcca850e0a";s:25:""mortefontaine-en-thelle"";s:32:"3e7457c240019cf7493b155ba9722b5a";s:10:""plouvara"";s:32:"4c9f5a825e49a6ba84646a996b6447f9";s:4:""25"";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"286b81f44f14f8fcd93c35510545bf19";s:21:"`Departement2`.`code`";s:32:"2c5e9f52d960e90ec5f07551ed2997d9";s:21:"`Departement3`.`code`";s:32:"1d7e457219fc27e7fa343049f6f7f966";s:17:"`Pub`.`region_id`";s:32:"7cbf88a1c386286cb3dfeeaebcc844ab";s:18:""petit-abergement"";s:32:"e257836cadf60d3a654cb6a8f13dead6";s:10:""peumerit"";s:32:"62c58c2045ca96e7bf8d8e8340e5a8d2";s:8:""piarre"";s:32:"8396f5cc84d1425c4e65dc9ba0df951f";s:10:""plouvorn"";s:32:"1abadf5039219b2adcf9d397221cb5ce";s:19:""germigny-des-pres"";s:32:"08c84cc5d051d17fcdb85ba1a1c79235";s:19:""bernieres-sur-mer"";s:32:"ce73be6a8bb7cfef2c58ae62373b0e18";s:8:""plouye"";s:32:"c5561cb50357499e66481bf2fde5e705";s:19:""lapeyrouse-mornay"";s:32:"a8efc4a48e6036344ddd7c7daac95cd3";s:13:""quercitello"";s:32:"6e4e0cff390cf4e777b5eb72e965f8a0";s:10:""plouzane"";s:32:"b48eb543cf607a0bd515156375ac6d03";s:3:""8"";s:32:"bca378769cc071b2dfd627a0ef0e2f0d";s:4:""87"";s:32:"6919cc83731ef136f6d4e5bb1608c395";s:18:""rablay-sur-layon"";s:32:"81c3552b9d843eb7814104cbe0ff256e";s:8:""raches"";s:32:"5c332aef6faa8122600b8144c7002d00";s:14:""plouzelambre"";s:32:"00ab3f6ade50674aca635973a071c1e3";s:13:""rainvillers"";s:32:"eb7f52246271f10a80301d15e673223e";s:9:""rairies"";s:32:"03e1471f5303b1c9acbce9a149c87583";s:12:""plouzevede"";s:32:"e76450155f476297e91353a30ceffbde";s:10:""laguiole"";s:32:"37c6b3d6ccbe21ab5740dca462b48f2c";s:21:""rancourt-sur-ornain"";s:32:"0252aceae7d7f57ab11e7f992aecc616";s:8:""plovan"";s:32:"0ff7bb588b8a6ee2fb6fe67c7d2a0d28";s:13:""reffuveille"";s:32:"514cad41a89791e8cd23c7626b4d9034";s:13:""remenoville"";s:32:"42da21f958f96a71da60a81281eec722";s:22:""ployart-et-vaurseine"";s:32:"4b93eef272f26bab5a0f634eeb3ce544";s:11:""resenlieu"";s:32:"cc61c76c3c18c0b84dd2c094b6344507";s:15:""riel-les-eaux"";s:32:"e25dfdb0627b7c130badc613d70c53ae";s:9:""ployron"";s:32:"e5f6409d42c9af02ec088928c81dbd9b";s:20:""rimbez-et-baudiets"";s:32:"44b540790c0ecef2896b90ac70710400";s:5:""roc"";s:32:"dc6887ca4caa5528050f56bedfb07eec";s:13:""rodelinghem"";s:32:"961b726fa479c0e474a36f36129a8287";s:9:""tronget"";s:32:"4d320744ed436d593e89374a73806c88";s:9:""rodelle"";s:32:"9ce1d17b9b16eb30348d7bf7072ef78a";s:10:""rouge-61"";s:32:"8768257db13b504f4cb4b03a902d2935";s:9:""pludual"";s:32:"37f37b93e0da0fff14e315506fd5dbbc";s:7:""rozel"";s:32:"f9f5f147f05d82ada7e773fb4b3a613b";s:4:""85"";s:32:"8b196d41bb2a0e7f885a82c0cf7d8a76";s:9:""pluduno"";s:32:"0460f5885890fa03be2cf502cce74325";s:11:""ruminghem"";s:32:"626114140f0a219f687ad31ca42cfdd4";s:8:""plufur"";s:32:"5de5836fc1a31e84c0999be346effe23";s:24:""rurange-les-thionville"";s:32:"62e24fb95d4bc8137ed1d49fd0771a18";s:11:""pluguffan"";s:32:"8e9f2077c37b0c6a9be6dffc2bc97883";s:21:""sailly-en-ostrevent"";s:32:"458b77a15f26e8b5007b4513d96197be";s:16:""sanry-les-vigy"";s:32:"f7ca448c9625163d6084240859365383";s:11:""pluherlin"";s:32:"d5c1d44f7d6ed8530c854bde2d345f44";s:14:""sapignicourt"";s:32:"59ebb88d551ef677f08587151c00113b";s:11:""sapignies"";s:32:"42d77cb4db0df6ecffd3575d28e979a1";s:11:""plumaudan"";s:32:"79a266a9c402343053e9e958b47cf030";s:9:""saulles"";s:32:"41997ecca117a50e0e50ce05562829be";s:11:""plumaugat"";s:32:"6ff9b106a564fc0077e1e19f7a984073";s:4:""59"";s:32:"ed46db43ff91eaa2161e414b6bc9ac71";s:15:""saulnieres-35"";s:32:"3dda34ca4023a40006d65d6cb176b919";s:10:""plumelec"";s:32:"4e5a125be38a09a57997450514c4cb29";s:9:""lecques"";s:32:"15d6b97cf557c9ef82700914e59762c0";s:4:""31"";s:32:"582d9530c600dd1bec91a748547dd5ab";s:9:""saulnot"";s:32:"d011f730c6d4404c46963b1215a0f4ee";s:8:""saulty"";s:32:"fd694fa7440532d8c4dad3968e5e6a71";s:11:""saussines"";s:32:"862ba92a0776cff78baca580b5e1f325";s:11:""plumeliau"";s:32:"c2c3c866424f1bce30cef898cd6dab22";s:20:""sauvigney-les-gray"";s:32:"14b888f88c9b66e8b1ae178f7218c6ca";s:13:""schwobsheim"";s:32:"9a60611becb8eecd9d30a0d784570291";s:10:""plumelin"";s:32:"2c9d591c85872f538f1fac90869d8c37";s:10:""scrignac"";s:32:"63aca575dd7d6dcf4a6f2ca677828d17";s:10:""sechault"";s:32:"06c7f2b02231e263d5bd5c58409f3094";s:11:""plumergat"";s:32:"ef9c451830dc8f6e8e049b33f7f30aa5";s:3:""9"";s:32:"bfd41f4b6c418c96827626f7e6347cb6";s:4:""73"";s:32:"a7e796463f7002741e3c842e90973322";s:14:""segalassiere"";s:32:"dd4a3903660bb2477fd5e2c097303d94";s:12:""seillonnaz"";s:32:"ef78c295ab47796e4818a26c72b2faf6";s:10:""plumieux"";s:32:"774743212d6ffd2d0da463ba8efabcd9";s:9:""plumont"";s:32:"9c8440d21ae70326fd70578bcf93e68a";s:10:""senailly"";s:32:"1424f458bc412fc46e36a063c056c348";s:10:""pluneret"";s:32:"37cba61c55244fd133fdc650cbe97cdd";s:9:""sepeaux"";s:32:"7c06aa1784394bbd131a30847281efdb";s:9:""plurien"";s:32:"7e679857ea9f821b9fe31df817c7f1d6";s:13:""plusquellec"";s:32:"6fe3380f8eec7095d7a4bdf0484414a0";s:12:""plussulien"";s:32:"e51dd6482d44657d90b851b26a9683d2";s:10:""pluvault"";s:32:"b8c12269b9c33627dc8340d15ad7c015";s:8:""pluvet"";s:32:"350df01e677bc5e8dd3bc68af78b589e";s:4:""39"";s:32:"cd84d1958c248f272506127dded31bc0";s:11:""servieres"";s:32:"443ca0488506b5e1fdb4bd235b182e18";s:11:""pluvigner"";s:32:"027a514caa0188cee7fdcf49947d9f78";s:10:""pluzunet"";s:32:"e63b38268ceba221081095b4921c687e";s:16:""sexey-les-bois"";s:32:"0fa0417dc11b18124b565937b6d107ca";s:9:""pocancy"";s:32:"8f39663769ca3c8d86b55badb7719b95";s:15:""poce-les-bois"";s:32:"a5e2a17e09234521540b06d258ac3ad7";s:16:""poce-sur-cisse"";s:32:"1d7e737624ee972cf64e03ff607729a1";s:10:""douville"";s:32:"852b5e53afdff090b6a64181e3bd424c";s:10:""podensac"";s:32:"64e1283bd1f9cc62772ccc8f9c52d069";s:9:""sologny"";s:32:"a2b20e40ba1692a2b7e3a574036faa19";s:6:""poet"";s:32:"311c5c50407595be6e9da29c52c23f87";s:13:""poet-celard"";s:32:"543903e0349dba953d1d02428ad95b9e";s:22:""passavant-la-rochere"";s:32:"5e9cfdab360c741297372892339bff92";s:16:""poet-en-percip"";s:32:"8a522c8b7942f8ca91b95cd0404d0f40";s:13:""pinterville"";s:32:"7bc2105506008d9fc7ec2ade2b6a5067";s:9:""revigny"";s:32:"851fe044c089d5d0d2fd867071af1b22";s:12:""poet-laval"";s:32:"cf2ec5001b2b2674c93777ef5529b828";s:18:""rigny-sur-arroux"";s:32:"c41b9bd2b06b3a1a9aef3a48e0a6b655";s:15:""poet-sigillat"";s:32:"77f46351d0f142c8f408dea35ccab3b0";s:9:""panazol"";s:32:"2fa1322936efc54d859582c876de0799";s:8:""urepel"";s:32:"c61e15f837797c811a3e0b23297d945b";s:15:""poey-d-oloron"";s:32:"5868e7705922af686d8e3c87de892d53";s:25:""soulosse-sous-st-elophe"";s:32:"acfa6f0ecce9485fbd9be9e3376336e6";s:18:""st-aubin-le-cauf"";s:32:"33abded9f6ac990ae3dfa062fe1d0bf8";s:12:""st-exupery"";s:32:"8e808d2999b0a16a6b999245c3c45732";s:14:""st-firmin-58"";s:32:"631a2f1e45fe47dcc192c2b873467e41";s:21:""st-jean-aux-amognes"";s:32:"a061d8fff72ab21114ad9d0a34c303ac";s:10:""tilly-78"";s:32:"d77df9c15c8938917e47b5f654ed3d77";s:9:""andrein"";s:32:"f90eea21e7f924152ce55baeaa8d2acf";s:4:""21"";s:32:"8a51ffe1523985ec053fc9ba08bdecce";s:12:""bethonsart"";s:32:"ecb861f5ce816d07c34422467d0687d3";s:20:""bettegney-st-brice"";s:32:"aeb26a26611075112dffef4a58910631";s:12:""rousses-39"";s:32:"869733023330b3ad62752fd75b1d3fc5";s:10:""brion-49"";s:32:"c35017f5f2976d3684e598f1e816367a";s:4:""72"";s:32:"ed4087b3535f8b56d7db44c748b4ad1f";s:9:""caligny"";s:32:"f375baf07576556c853af97fbe195ec9";s:9:""cauffry"";s:32:"167bbbccc66597a3e0bee5ee6c3eb216";s:4:""11"";s:32:"17017962381f3078fda3b97860cc08da";s:9:""chevain"";s:32:"241fa623015697b3d5c3558b10d8d78b";s:14:""chirassimont"";s:32:"e12617310c92b0a72597ad77f60469de";s:11:""cluses-66"";s:32:"5415cd2caf536fb9309a12b97ed7e0cd";s:12:""corcondray"";s:32:"46b487419433f86b8a024f7cac709201";s:9:""corscia"";s:32:"1316c2f1ca2aa4ede23b8f5a1ead3355";s:7:""degre"";s:32:"318e75e021a726633cb5f001250f58e3";s:16:""poey-de-lescar"";s:32:"b0629e0423a12cf56cbd732d5a050d5f";s:11:""ecouflant"";s:32:"08b002242999df17c5f06a31baffa8fe";s:7:""eduts"";s:32:"6d8b1714844d29b6542425c2543a6fc0";s:12:""embreville"";s:32:"ae58808b1ed8be87601c4f27faaac134";s:9:""engente"";s:32:"775be04b69394cb31befb154ef5cd74a";s:17:""francheville-51"";s:32:"4a87409b21bb29869e2206f5dc24fb38";s:16:""germignonville"";s:32:"80c1f798b2ba55a04619e2eaea5fd6f2";s:9:""hangard"";s:32:"fd3b0576527f8b4160e4ef47801df363";s:17:""poggio-di-nazza"";s:32:"0e48d55a4160356a30e1af3bdc415b94";s:9:""haussez"";s:32:"fed40e2ec69974c2780ea9317e987e7e";s:18:""poggio-di-venaco"";s:32:"add74dc2784e0d9aa36024f61ac9384a";s:12:""heurtevent"";s:32:"8a908bd434b3c4775892543720e5a4a3";s:6:""illy"";s:32:"ade1c99c179a6b601caf1733f8c70534";s:11:""jambville"";s:32:"b38296ebe6a2e7a6276dee02ce86b7db";s:19:""poggio-marinaccio"";s:32:"a1732b37954e5d94f599014c61d06111";s:7:""julos"";s:32:"b9ea361bf69ee075ce0a5c45728d3ed6";s:14:""kappelkinger"";s:32:"402cd2d20c7743529ac9b507a1cac6bf";s:9:""labroye"";s:32:"79e6d6760e55c9c8522f55843dd7d8be";s:9:""lambres"";s:32:"37cbb466cabf56e285c6d479f1a4bc19";s:10:""poggiolo"";s:32:"a4e80e27f658f3d704f8111356d1f85d";s:14:""landevieille"";s:32:"d2ebc74c3a06229aeed52024a51f898d";s:7:""pogny"";s:32:"b57d2ea3731ffb526080e50798428e59";s:10:""lavernay"";s:32:"59ebb67f6c3651ca0e36079dcd77e390";s:8:""lieoux"";s:32:"e8f4dcdcc3c5196e472c57307bad5521";s:15:""lubret-st-luc"";s:32:"660880d70c97de5b98908d7bbcaa6602";s:9:""luce-61"";s:32:"9a3099427e9c7864efca600c209f6cfb";s:8:""poigny"";s:32:"7233b3565afa2e43ea8568972eba440a";s:17:""poigny-la-foret"";s:32:"e033c0344de43e8833814c7532567836";s:8:""lys-64"";s:32:"d3f1cc05062595e9dcdbbf9b845ba105";s:6:""poil"";s:32:"3f1899f04daeb53128e3f9d24ec60951";s:8:""memont"";s:32:"975dc97d8392b814264c38f12fe5fbc8";s:4:""09"";s:32:"aae25e7317a2c0ff61ddebac827b053f";s:4:""30"";s:32:"7964e7f3a3817f11d5d1c5b55405a862";s:18:""poilcourt-sydney"";s:32:"9b73ac72b0861ca3184fa9a16e1e06d9";s:17:""menetou-couture"";s:32:"364a65429ae8a2789c1039c541f2a20d";s:5:""972"";s:32:"7647f61682a5da0df37f81b1613b61e8";s:22:""montreuil-des-landes"";s:32:"9ec542e6ff5ff3b1c53c04db0d79650c";s:9:""poilhes"";s:32:"18cda212d0cae033e123b7f10b4613fc";s:13:""montrichard"";s:32:"44c8701423d1436b8ed238ab2d46f896";s:10:""moraches"";s:32:"dbb3641871b067b9da1b2b5a87cb1e22";s:18:""poille-sur-vegre"";s:32:"211cedcddcc4a38917ce57a0598bdab8";s:10:""moustoir"";s:32:"2d48bba10504af4f44d7988262d3e7a4";s:12:""poilley-35"";s:32:"73910d59fd0cd70f64f2898e9ba51f80";s:18:""neuville-au-bois"";s:32:"0a3469c5316a7da2b91f022830f088f0";s:14:""neuville-roy"";s:32:"e8cbd1fddf4817521f3a8c8d06f55dd8";s:12:""poilley-50"";s:32:"10239d33cb51e574075bd7b4423476fd";s:8:""novale"";s:32:"e4e4d159b78d4b6a1d7bcf9d20f3737d";s:8:""poilly"";s:32:"d469db34b2d5701a848275cacf434e89";s:17:""poilly-lez-gien"";s:32:"9a464be0e22376800b6c01382b7c621e";s:10:""omecourt"";s:32:"47070379839a9e6a864391f70646687a";s:4:""63"";s:32:"5da80e8c99e89a6baccc7e1477be0138";s:19:""poilly-sur-serein"";s:32:"4c1aa898c631d1efe28830cc3856fa33";s:6:""ouge"";s:32:"2553ba48437671cd19e281df5d576c72";s:15:""perdreauville"";s:32:"82a4cbfc0496b6f4ae63b64cb71f18fd";s:19:""poilly-sur-tholon"";s:32:"57bbccccc6895f743ea12bf687a045c2";s:9:""pertain"";s:32:"5ff2bae1834298b28db0908834e012cf";s:20:""poincon-les-larrey"";s:32:"91725cc73155701b171b7c45a5de039a";s:10:""pianello"";s:32:"6990313ef629cac8806776a41e5e81fd";s:4:""68"";s:32:"86a4195913d1362d24ec57d29db5de69";s:25:""piets-plasence-moustrou"";s:32:"8f513797920ee9134a9f27c67bc435a0";s:12:""poinconnet"";s:32:"6c69cfe1cb3bf59143677c210f5d31b0";s:11:""planay-21"";s:32:"7b900d686ff0a9d15d881ad6a76ee742";s:9:""pomacle"";s:32:"51c3c998d02ee4e570177294d5dd3024";s:8:""poincy"";s:32:"e9d6795f428e4aa4e7699c37dbf0bf91";s:7:""ponts"";s:32:"fe3f3c7d976d34e1bf0daae7f84ba1f0";s:11:""poinsenot"";s:32:"36f58a651d7e19ec6ca32da9bfebb252";s:7:""raids"";s:32:"30662919da234ba53d6c9c9386202bd5";s:18:""poinson-les-fayl"";s:32:"683de2b2c004f3937de6aa7b5d89fe4b";s:12:""rangecourt"";s:32:"4dacf11fe358acf963db7262a4d5c966";s:8:""rognon"";s:32:"867a85425c13b1b35e7206e6ff41244a";s:21:""poinson-les-grancey"";s:32:"8e71dffbbc73c7dd7efcd0f422a2e158";s:6:""rouy"";s:32:"b4fc8ba1a98daa8d3f44b97b86faa95e";s:20:""roziers-st-georges"";s:32:"02d3fd6bcfded1af85d35d1fa02cf42c";s:20:""rumersheim-le-haut"";s:32:"4d13fd111ca1b3d871647000477c0145";s:20:""poinson-les-nogent"";s:32:"38141f60d6b11f7e08d9237d48b5ab8c";s:9:""salzuit"";s:32:"0ab5ddc7a23a272c7cc7cad0dcee0a01";s:16:""pointe-a-pitre"";s:32:"5fdcfb88f144dea9e6c05d500fdd49ce";s:17:""sauret-besserve"";s:32:"bace38bc60002f726a8e20bc390150d1";s:15:""septfontaines"";s:32:"0a441373271f61e8cfc73dcaf75bf5f5";s:14:""pointe-noire"";s:32:"719a7e5c73a9c926de8214af96200124";s:17:""sivry-la-perche"";s:32:"9effc849d644ac40aaf06bb56f302add";s:11:""brasparts"";s:32:"9eccb495e783ce78e97bb5ff3eb26429";s:18:""brazey-en-morvan"";}s:6:"fields";a:416:{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:"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:"979777e2390cabe194869b09570ff466";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"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:"c893cde65e0023b4a6bcb2506e54e62c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3950bfc521e7b96b85d5e8881da6efc2";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b1b32e9f6fbb1e3a1486896589797576";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*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:"e24e1971a59f308d20afe4bd2b540bec";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*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:"c477b97c2905cc50bbb0fd97f5be0545";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:197:"(((acos(sin((49.347*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.347*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.37639- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a8be5f58994990ad7dab4acf5426f748";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.71667- 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:"a7ea2086b0ca5ffecf375d9a84e104d5";a:2:{i:0;s:374:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug,Etablissement.img, Etablissement.pets,Ville.id,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((50.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"88f209d69b4d3afe5e9d47ffcf4dbfc9";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:25:"`Etablissement`.`partner`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:13:"`Ville`.`nom`";i:5;s:196:"(((acos(sin((50.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"26b854aececdcc92884bb15e85b005db";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"d4f9df82fdee4ad1c96d2e4e6935ad00";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((43.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b46f289809452c1309e6660dfca16251";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d6030f7a5bec8bfe753bc4db340ccf32";a:3:{i:0;s:272:"Etablissement.id, Ville.nom, Etablissement.adress, Etablissement.rs, Etablissement.partner, Etablissement.img, Etablissement.cp_ville, Etablissement.pets, Etablissement.slug,Agregat.id,EtablissementKeyword.*, GROUP_CONCAT(Keyword.lib SEPARATOR ", ") AS motscles, Keyword.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"f0d62901f76b5abe7816ad11f20cd1b3";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"82d10fc6e09b811b7dcf6bf89a807e6e";a:3:{i:0;s:353:"Etablissement.id, Etablissement.equipements, Etablissement.modified, Ville.nom, Etablissement.partner, Etablissement.adress, Etablissement.cp_ville, Etablissement.rs, Etablissement.slug, Etablissement.img, Etablissement.pets, Agregat.slug, Agregat.lib, Agregat.imgCat, Agregat.lib2, Agregat.libRech, GROUP_CONCAT(Keyword2.lib SEPARATOR ", ") AS motscles";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"4f4e56fa1b375ff739b6552ad033989f";a:6:{i:0;s:14:"`Keyword`.`id`";i:1;s:15:"`Keyword`.`lib`";i:2;s:16:"`Keyword`.`desc`";i:3;s:16:"`Keyword`.`view`";i:4;s:16:"`Keyword`.`slug`";i:5;s:19:"`Keyword`.`created`";}s:32:"68d6b8f992de5d53d2bad0ff4095c49a";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"9b6b899043e0181290a8dbf7d5f83864";a:3:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`slug`";}s:32:"eb6fd2c106f938179da639d0a5eb64fc";a:3:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";}s:32:"60537a99671cb9ed3191202f6d1ff7e3";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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"0df9abbd369e628603e32cd07112dce2";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.41667- 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:"92a895048d929a987c834afb1ae76e0c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5f33d18ac4dcb7df44c811bd2458192a";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c0368e1ebde5331056234283db614dff";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:199:"(((acos(sin((48.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2694957deed5919c30f2524fd8f206f1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((43.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3667*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:"0297dddb472fc3d81505d526738e904b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:189:"(((acos(sin((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a13eebfe6b7186e94bedd42c3c0893c6";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"540ecd64fca702e6e15922fa92c7f6e4";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6b423d5e3de4a73ec6d2fdb885839845";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5667*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:"929c21a29a1bf6e526893a55e664be88";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2461fdb58b2381e47ea7f8b7d5644c17";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"643ac51ba160b7051bb2f001dd09e187";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((41.9595*pi()/180)) * sin((Ville.lat*pi()/180))+cos((41.9595*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((8.93445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bcc9757c6be7a1527fb5f3e31dd2ee2b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:194:"(((acos(sin((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*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:"0607c61c858eeade4a3f807750fcb772";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"69897ea51bcb7485d990bed77dd4adf5";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*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:"59c74f41629e4c94e99d9731862afd08";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6a6b0f0a31539e3c31a1cd98fd580c65";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:197:"(((acos(sin((48.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9bccf02f9cd399568248126e4a7376bf";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((47.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"56a7f263c60c335d1dd6df6771a13584";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.116667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"d5537121ba667d07bd7a81ecf4397a85";a:6:{i:0;s:20:"`Etablissement`.`id`";i:1;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.116667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8c28ccb04a25eae13039dc55dd4d4944";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((46.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d49ca1ec2600baf2d8a9ac4f5d0b1e7b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((44.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"377b3b3a6051084da4f5f3bf025e632e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3bfd8133c5a1d438689b54cd6584a1fb";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((45.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*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:"dc9c76e5d8d7bc810ebc5b707370a199";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((50.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.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:"f4468acbbd3e77ff7fe2264a9c7ac89e";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:190:"(((acos(sin((48.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"600a61a8b1adcf7459a5f06ed148b461";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0167*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:"9a4d2801ba99d87bdaf56f1f8522b5a1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((49.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0833*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:"59c803e254afd50792121d705e7cd813";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:197:"(((acos(sin((48.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"75fd2d5c6a7e6c1fcad838d9cdc07ba3";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3333*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:"34e9240134adc9758bca33fe5f3a2472";a:5:{i:0;s:20:"`Etablissement`.`id`";i:1;s:20:"`Etablissement`.`rs`";i:2;s:22:"`Etablissement`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:200:"(((acos(sin((48.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3333*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:"b9a73823ae90a416a6803d4de8761868";a:1:{i:0;s:11:"`Agregat`.*";}s:32:"9d8f88cd388a6516c55c793e6cf6962f";a:1:{i:0;s:15:"`Departement`.*";}s:32:"09efbfdc553df6d3fdac8d2f1f455d56";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f696d23d81758fee3ec1d1ae8e56625c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((46.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"74f29e5188c20140982cf7f787962bbd";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.6306*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6306*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.12834- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"38b8d52510a2c43ea735c218e9f96b13";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((42.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9bedcc281848a631e497088980412f4d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((47.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6333*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:"5e403b9232bdb58ac4c3d444e1c2813c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((47.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b973ae0acab88bd3536a9bc987d5ade";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((48.5095*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5095*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.31306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4f0b836d3098e647c259659198c94d6b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((42.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.75*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:"94a6fe60af56a71b690de79650e68eea";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:197:"(((acos(sin((48.535*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.535*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.21028- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7094d9a1089ecfe550d7fd7dc5ef8e21";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:192:"(((acos(sin((46.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"985ead52ba61921171f508ab705c9b67";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(((6.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7e3b5cd3f08f633206e0808b1dfb2f6d";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((48.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*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:"e8a3f51f2fecd4f0543feaf3e1b1f97b";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((46.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*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:"fae5dd0cbfc948e53e4a67859fa9d82c";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((50.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1a9bb694cff0c7afea9587e7e40772ec";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"20272fec005b103f62eaf85450491b24";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((49.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2667*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:"b08f59896dbb6189bbb6c1edb99f6062";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"974557f62d9b7f91cae30550b7055d4a";a:2:{i:0;s:14:"`Ville`.`slug`";i:1;s:13:"`Ville`.`nom`";}s:32:"3137f9841110277cdfcc4f6a219bb771";a:3:{i:0;s:261:"Etablissement.id, Etablissement.adress, Etablissement.rs, Etablissement.partner, Etablissement.img, Etablissement.cp_ville, Etablissement.pets, Etablissement.slug,Agregat.id,EtablissementKeyword.*, GROUP_CONCAT(Keyword.lib SEPARATOR ", ") AS motscles, Keyword.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"1e61cc2b3d60e6f27130b253c35f2c0c";a:3:{i:0;s:27:"`EtablissementKeyword`.`id`";i:1;s:41:"`EtablissementKeyword`.`etablissement_id`";i:2;s:35:"`EtablissementKeyword`.`keyword_id`";}s:32:"52f583f69756f117339c9fc858039ade";a:3:{i:0;s:111:"Etablissement.id, Ville.nom, Ville.population, Ville.nom, Etablissement.cp_ville, Etablissement.slug,Agregat.id";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"aec2a629c478fa98aa85f470a7372bdc";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"480640a02a190501e52f1904aa07bec0";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:25:"`Departement`.`region_id`";}s:32:"4967df20c696e93ae6e0a19d556f7b72";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((46.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ec53c024432b76b08508063cef4e4266";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((47.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e084b4ec82fc8833c5d8d9cf12515860";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:196:"(((acos(sin((44.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8da95e8aad17433d791e17f13a7bc4be";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*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:"3c64bee38b2d7e501da90d89512eedaf";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:195:"(((acos(sin((47.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"559686f55d30f66d87f4a75a74c64306";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:201:"(((acos(sin((49.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"786f0fa79af64630c14a7a0c08cc7442";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"05bc1d2f046addfe1a30580bf6885157";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:193:"(((acos(sin((45.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1276c42a18e66c8186c0a3a4d41015d1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((42.4262*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.4262*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.35029- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9d25ebf068d52b01bf96fbd0ba557cd1";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:200:"(((acos(sin((48.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6c8cb8606fcddd271c4ed91fe353d1ef";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:201:"(((acos(sin((47.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2833*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:"fe79089fa139a1600eae9b201a5c416f";a:3:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:199:"(((acos(sin((50.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"06038e69cca942998c5229700ca91d7a";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,Vill'
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]
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