Notice (8): unserialize(): Error at offset 79142 of 79142 bytes [CORE/Cake/Cache/Engine/FileEngine.php, line 194]
Code Context
                $data = str_replace('\\\\\\\\', '\\', $data);
            }
            $data = unserialize((string)$data);
$key = 'myapp_cake_core_method_cache'
$time = (int) 1738756200
$cachetime = (int) 1738756207
$data = 'a:3:{i:0;b:0;s:4:"name";a:402:{s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"abfe790023ff0d1611edcb6dfce6802d";s:14:"`Moyennevente`";s:32:"c1955c45da499f15d5021c8c72d79c2f";s:26:"`Moyennevente`.`codeinsee`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"3c8d21fc2164772cb7201fe48deb9396";s:15:"`moyenneventes`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"6b170f4988a2fbc2af3d3634dc058028";s:11:""montrabot"";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"b3a132b3002f0a095c207367d2386438";s:13:"`Ville`.`dep`";s:32:"c5697e1e5c979d7ac16a2058fe255e21";s:13:"`Ville`.`nom`";s:32:"f340c52a13f3cf8684f61cdbc6725f3f";s:13:"`Ville`.`lat`";s:32:"b4707c5ae31d038ddd76310d59aceb1c";s:13:"`Ville`.`lng`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"c1f9b57df40a583acfdf261e4793fe99";s:20:"`Ville`.`population`";s:32:"f721416f99749f3df35aa11d34cb1cf3";s:12:"`population`";s:32:"3857f2e1b78a705845c11758b879ec11";s:11:"`Epublic`.*";s:32:"6504b0970e350614eba7cc0cf66aae51";s:10:"`epublics`";s:32:"311ac503c2c83d277449d5c03a0ee2e8";s:23:"`Epublic`.`identifiant`";s:32:"95ccb19139b56742a7732f163bad069e";s:10:""%mairie%"";s:32:"47b08794347dfb2384d73f46d8cdcb32";s:21:"`Epublic`.`codeinsee`";s:32:"17173059dcc498c135008ebda33d1e27";s:7:""50351"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"2f3e82da9f1dbabf0af16b4a946a1e08";s:25:""st-barthelemy-d-agenais"";s:32:"f88d5e9196557e8d289d078906703a1e";s:7:""47232"";s:32:"267c99ed98b5f8dbfbb036d1a07a9a0b";s:8:""orange"";s:32:"738f18f2d8446333419ae02b43316d00";s:7:""84087"";s:32:"4b5b179f3d4d02caf2bc8f10c9508150";s:17:"`Etablissement`.*";s:32:"ddd34ba2fe5b8a28f2a178b624f2dbdf";s:11:"`Agregat`.*";s:32:"db3637d11fcdcd69df12fd155007380a";s:27:"`Etablissement`.`codeinsee`";s:32:"9e9324354827438087cb97d78e67cb63";s:11:"`Categorie`";s:32:"6c96c7067859c92b2cd5c584da7020fd";s:19:"`Categorie`.`siret`";s:32:"becfa4e4a7c9b2d19025948a972a6478";s:23:"`Etablissement`.`siret`";s:32:"469f0eca4934529a8ebe3db2dddf24e6";s:12:"`categories`";s:32:"2c62152eb8c6e394c181c6dd4ec49616";s:23:"`Categorie`.`categorie`";s:32:"b4a89b5674de566c843e6f22da4852c7";s:22:""st-front-sur-lemance"";s:32:"8df6e828d082213c1d1c96c4ec90b2ad";s:7:""47242"";s:32:"37c2154a84cbcb9317edd3f9f609db64";s:15:""ville-d-avray"";s:32:"c7de46215f4b53a4b599025712417699";s:7:""92077"";s:32:"b24919d551cd63b85e5623901d437801";s:13:""remiencourt"";s:32:"0954ef224dffd39d7d3421ecbf7cedc3";s:7:""80668"";s:32:"3045c2d0a75aff40967dde6de2dde08a";s:22:""st-sylvestre-sur-lot"";s:32:"3783a1acdfbe22fa1660fc2df76caa1a";s:7:""47280"";s:32:"931eae210c35d72ea48a75e9c92939d5";s:22:""st-martin-d-armagnac"";s:32:"050c74892d6c1fc201701783c5a5bc58";s:7:""32390"";s:32:"64be9c00fbe0b0400e0b758937413111";s:12:""sorinieres"";s:32:"34ca781b2f5b7f429c044d09b149aa3c";s:7:""44198"";s:32:"05f4b00864825bf69c37f153450ed9f2";s:19:""st-bonnet-du-gard"";s:32:"b606b0b0644c7cfeed426b3f00467325";s:7:""30235"";s:32:"4980ed713520c53a5ef7bfe59bfe3568";s:14:"`Mur`.`pseudo`";s:32:"5df22fc0ee63f77314a59940fedac466";s:15:"`Mur`.`contenu`";s:32:"78f75bec59f89c734ad73833bc56b727";s:14:"`Mur`.`posted`";s:32:"f0a34e9f16b52b8585fb8852c455febf";s:6:"`murs`";s:32:"025bf5e280fa1a5abe6649e1e4de4e90";s:16:"`Mur`.`ville_id`";s:32:"aeb9c0f91b83d19a86e2de9383c8aea7";s:16:"`Mur`.`validate`";s:32:"9d1b58c9bf83bd6b146c7059e2971034";s:5:"`Mur`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"359ac070c703c6225869362821552643";s:11:"`Annonce`.*";s:32:"40afeb1c40614860e01d0748c5f553df";s:10:"`annonces`";s:32:"8027d37245b611a3fbdf14a1e89d8f29";s:20:"`Annonce`.`ville_id`";s:32:"404f56ef6af3757e2e643f86960284d3";s:18:"`Annonce`.`statut`";s:32:"f95ddc2be023960209cb5ce5f087ddbd";s:9:"`Annonce`";s:32:"4b7b5013f5336e5b279947c192745df4";s:10:""chaignes"";s:32:"8e8e512f1166d6a781b42b0a5456b017";s:7:""27136"";s:32:"f03ffd564b288675c46d8b1a14573e38";s:22:""st-etienne-des-sorts"";s:32:"038329b0fa01dc2890d754102f197be0";s:7:""30251"";s:32:"718a91aa548a3daaba68fa2027ced089";s:9:""reallon"";s:32:"69cfa833e20153310e4bb3d4ef3e84f6";s:7:""05114"";s:32:"033ed0c3214bee999ea9b73be10752fb";s:8:""barran"";s:32:"abb6e691b9ccbc2c4b93b3d7d45c1a41";s:7:""32029"";s:32:"acde26bf90e0fb0994377023e7c94a4e";s:9:""grillon"";s:32:"9594570fb1655200eaf56771f2d3ce2b";s:7:""84053"";s:32:"42bf8fe4ba4d97ed553a7daa4a02b57a";s:24:""st-hilaire-de-lusignan"";s:32:"003eb991bfa18c40a62eb38377c3c0fb";s:7:""47246"";s:32:"cf075310184324d011ba527a3df63e63";s:16:""lagarde-hachan"";s:32:"6aa5fe267157fa03f680f00ca55b7bf6";s:7:""32177"";s:32:"a4888390de3add608e150eaf36529afe";s:10:""courties"";s:32:"ef8153171b528f3c944381cb79dd6a2f";s:7:""32111"";s:32:"a30c35e004e0ecbdb4bec68422346447";s:22:""gueblange-les-dieuze"";s:32:"45f33d1240640e13718d1ff4b4b26388";s:7:""57266"";s:32:"851b736803c5f49710a1d6b62039dc8f";s:11:""outrebois"";s:32:"35f885aecdce5246bdcfeeb58973dc7c";s:7:""80614"";s:32:"ad5002dd817be86474732d7893b2f1a8";s:9:""simorre"";s:32:"f3b791ecf197c864010465279305d0b8";s:7:""32433"";s:32:"dfd16db232eefcee9a289852bf80b3b5";s:17:""mont-de-marrast"";s:32:"c3a07158669b94c8cfcd15316e6ecab2";s:7:""32281"";s:32:"449371cf3557d49e79fd4281555d7ff6";s:9:""bezouce"";s:32:"54c7b7c5f3eece932ac4d659fa9187b3";s:7:""30039"";s:32:"b69b33bd28ce29dc0205d2636909c7c7";s:19:""villers-carbonnel"";s:32:"bccac0641174d0ccefaf0bf972eeb84b";s:7:""80801"";s:32:"27231bd210a17f43599abc94236765a3";s:21:""st-etienne-de-l-olm"";s:32:"5fa56b53580997423cc54b5c220b611d";s:7:""30250"";s:32:"c97bba73d1a64724ac3d1d6fee844258";s:26:""ste-colombe-en-bruilhois"";s:32:"1f6ebdf12eafdcb29455079553509ccf";s:7:""47238"";s:32:"e90b16ceb60939a8339ee4e356cee786";s:14:""guilberville"";s:32:"c017f0fc2510645d5141059b2875ddce";s:7:""50224"";s:32:"097304811c9fb117995a21a81812bcee";s:11:""antras-32"";s:32:"cbf9bd536dbaa09d91ab74233ae35862";s:7:""32003"";s:32:"4dc57498c28003e49d019770691b33dd";s:21:""st-colomb-de-lauzun"";s:32:"33a505f413079fd7285bed0e17197b2a";s:7:""47235"";s:32:"d7523d28faac312303346aae69e9aab0";s:20:""st-eutrope-de-born"";s:32:"3d48386c37de4707881940416f136cc4";s:7:""47241"";s:32:"33ef0e01fa971e9ed7219729f3f482c3";s:8:""merens"";s:32:"f8db0a9c8d4ec3c938305be2f083a35a";s:7:""32251"";s:32:"4a6c70cd97344793571cf244a1785b2a";s:18:""buzet-sur-baïse"";s:32:"f7cb83c6bb16ad581467163496597e59";s:7:""47043"";s:32:"9e99620ea5da2153a3d35f1e70c1ffaa";s:8:""garnay"";s:32:"5f2da547de6564064b207f95b944d3e0";s:7:""28171"";s:32:"0e8ad92cdba858e4e1cd37261fd8b2ed";s:17:""monferran-saves"";s:32:"fde92be6e2dfbee0e8fb27758bbf85fb";s:7:""32268"";s:32:"9621e04d77c32dfa029e59ee696f2a9f";s:13:""lagardiolle"";s:32:"f246e1966f3f8b13d14a5e9e36aef14f";s:7:""81129"";s:32:"a094ca8de9b88371d00d1f788b267e3d";s:17:""chateaubourg-07"";s:32:"90b76cc91919d693fb4d4b4ee532030b";s:7:""07059"";s:32:"f0365d054c50c761f6f2d0f1014e9a7f";s:9:""arvieux"";s:32:"3909a0cfd483e0621675d7d5a094555e";s:7:""05007"";s:32:"7bef7cb2944155354a055d25d1967345";s:17:""chapelle-st-luc"";s:32:"b4afbf00b917a766dd085335217e7b24";s:7:""10081"";s:32:"972a37df61058c7fece2a35ff7c23f95";s:10:""monlezun"";s:32:"013f91a8b3ba6dceef4cf0d6c197c2c0";s:7:""32273"";s:32:"acdc9d0a357a883596eec0a762cbcb2e";s:10:""crespian"";s:32:"3f141c817d5dcc324c6e9e9eaff394fd";s:7:""30098"";s:32:"ee3001a2bd599ae4af5e929aa4cc6b41";s:7:""legna"";s:32:"2df4334d2c15a684a79aaa9b34490ab9";s:7:""39290"";s:32:"6990d02b104bc5692286a23065e960d5";s:10:""sarrogna"";s:32:"cc62a555e30ee9187369b3d5c86cea05";s:7:""39504"";s:32:"a90a995b9a2b57a1e51025ad81a607ae";s:14:""chatonnay-39"";s:32:"d02d10bb3f5ab09b8dcda913b98c5ab9";s:7:""39123"";s:32:"f5b8d32e14c49515b070cf8696fb2490";s:9:""hailles"";s:32:"307ce9087b5ff5517ade2d047e70dc92";s:7:""80405"";s:32:"3b1cc66dcfa914719214e4085e1d03a2";s:11:""chamberia"";s:32:"090f02a2fbc98e3c525becf6084be4ef";s:7:""39092"";s:32:"3a63a9652d81db95216329ceb726d143";s:9:""justian"";s:32:"1b4d03cebe5df95b496a64832c32f59a";s:7:""32166"";s:32:"a18cd2506e5da8b06274f7072949084a";s:14:""puy-sanieres"";s:32:"a7adc93f9b1a20ceb3c45c4a08c88b66";s:7:""05111"";s:32:"d580e345af08ac80be66487876f72f57";s:8:""maisod"";s:32:"abdec24f410c09ada69759f3d04414b9";s:7:""39307"";s:32:"b00e046172b61b5f7855e6ecb9340fce";s:7:""biran"";s:32:"0c94f3b09606eda851555e3b776978d6";s:7:""32054"";s:32:"d8fd95b138390e223adbac6698b7bb4e";s:11:""lescheres"";s:32:"32860b5c8a9b7f4a5ea4a89a19302534";s:7:""39293"";s:32:"4451ccddd807874f66edd0a872a60cf1";s:9:""crenans"";s:32:"13e881b6fe9357ade6c97e1a97a49a20";s:7:""39179"";s:32:"f5e1bc8e901a076d710895f0c415ad8e";s:9:""crozets"";s:32:"92291b209258d6f18901293979e0d991";s:7:""39184"";s:32:"a5df98a30f0329dfbe163f54a3ff2a69";s:14:""boisemont-95"";s:32:"8cd3c701b5f2edee7a2872b3bc47f0db";s:7:""95074"";s:32:"5f7c10264ccdffc17467036b1469e60a";s:10:""pontigne"";s:32:"0849f3e3be0acbbdc080f32842ba7a1a";s:7:""49245"";s:32:"225e9a30099cfcdec2c3a77b39460cc6";s:9:""morigny"";s:32:"572fa86fb97db94d9f6fc070b6b345d1";s:7:""50357"";s:32:"c25a4d05c8ba24f1aea7e0035ffbbe7f";s:7:""lains"";s:32:"cacd34e919b2478d352340ecf429688b";s:7:""39273"";s:32:"d29d015e72ee43332b2e9c314eb55fe1";s:14:""boissiere-39"";s:32:"feef41bc5616651bcc85facecd1c7b8d";s:7:""39062"";s:32:"add3ba2e005989b97ec31abfd35881a4";s:8:""dessia"";s:32:"e113fa8cc7c62b790e9755325ca5dcce";s:7:""39195"";s:32:"9896e3ce607a2abbd856e5bc7851462d";s:10:""vigneaux"";s:32:"f6118ad10da29ade979af855266d9778";s:7:""05180"";s:32:"42df7bec587bedad109a6e6a0bcaa182";s:14:""rochegude-30"";s:32:"e248f3648deb15e81f87a252c687ad30";s:7:""30218"";s:32:"76b44478f626df657061583692dff14d";s:19:""monetier-allemont"";s:32:"fc35ec31edc54f752430d66220e6971d";s:7:""05078"";s:32:"4aff490dd54c16691284d0d3327e4221";s:12:""matzenheim"";s:32:"bd9507158b073853242115c2391e8fee";s:7:""67285"";s:32:"e07312b10722c04b70e6dfba7cca4064";s:9:""bezeril"";s:32:"69c4ae6045fd3b617998723c8ae0d48d";s:7:""32051"";s:32:"6af9fe34417ae672f51121c1d1531d65";s:6:""sand"";s:32:"209d85b092bf049d1628360008bc87d5";s:7:""67433"";s:32:"9cb6f209a0090aece075abce738f4d33";s:16:""placy-montaigu"";s:32:"7ad957cc6862f85ef78f79f35c718f4e";s:7:""50404"";s:32:"a360d57616509e87f00a2669fe9b72af";s:12:""st-lattier"";s:32:"c3afbf4918dd403504667c216b5d8905";s:7:""38410"";s:32:"bf80285922416ad56d4409e72aab020e";s:20:""breau-et-salagosse"";s:32:"8d34fd0398e2926c94fb57108657cc90";s:7:""30052"";s:32:"6131bb73e1394d1211b0c4fd01642f38";s:7:""valff"";s:32:"d5225563834291b456ce05e8c72c6e29";s:7:""67504"";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"d1582db820a0fcfeecedba5685e3da9d";s:4:""15"";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"777d20b5a9ffbd0ad2caeaf5aa948406";s:16:""mittelbergheim"";s:32:"7d9a0e4ddc2d89e6787809ea99ce242a";s:7:""67295"";s:32:"c529925c22f9bb3dcd607a6946056a60";s:14:""prunieres-05"";s:32:"dcf7407671eff491d0343b6933bd1211";s:7:""05106"";s:32:"75bba794f758bed5d0008317f15250cf";s:9:""mouchan"";s:32:"56da7b08e2d4a07389b257564bf00bb3";s:7:""32292"";s:32:"080afdf11a5ea140f88826aa16309c6a";s:6:""barr"";s:32:"b9df195e30257aad694f983481d283e4";s:7:""67021"";s:32:"be5f9e07109d43375a3115727de23fca";s:11:""peyrecave"";s:32:"351baf587f7576d1ec52c152257619ee";s:7:""32314"";s:32:"cd786fd8e921b49e47de7fcce6868cfc";s:23:""st-marcel-de-careiret"";s:32:"b19ba265feee33cbe7016eb8e6676939";s:7:""30282"";s:32:"50fe2bd556a435905428f47ff030c0d7";s:12:""beuzeville"";s:32:"e5755df914373ab1b216b476ab03a3d1";s:7:""27065"";s:32:"64d6a0fe374b646f223b37b1ab4efa96";s:13:""condeissiat"";s:32:"80be4076cb5078073fd06de506cbacdc";s:8:"`Info`.*";s:32:"65c814b1b540f6da677533b16200a366";s:9:"`Sujet`.*";s:32:"6e09c806ee1568f15d870232c9ad7192";s:7:"`Sujet`";s:32:"9cc9932f961dd20be2485b6e784c67c9";s:9:"`Ville`.*";s:32:"0d0d440f3c7e653c8e2c7441c2a0d952";s:7:"`infos`";s:32:"3173fb2701c28779fb55d9fccb0214d0";s:17:"`Info`.`ville_id`";s:32:"3f291f5951c2401d928d43a105167167";s:17:"`Sujet`.`info_id`";s:32:"47595faa5061b239a137aa95ab2d051e";s:11:"`Info`.`id`";s:32:"b790d6f73c2cec29a0d7d28fa5e12bce";s:8:"`sujets`";s:32:"e8e3ca76fb86257b3cc96203366fa277";s:6:"`Info`";s:32:"09dd8fecc401560e8d221105a5a4dca7";s:12:"`Sujet`.`id`";s:32:"f5fc3afe9bd0789831e706635dce83fd";s:8:""rhinau"";s:32:"0be3037235eb2cd6dcca1cc10084c28b";s:7:""67397"";s:32:"dd06fd46529b9c257bc4298b0508cbb2";s:20:""neuviller-la-roche"";s:32:"ebe3e71d787cf7033381c75b7e502252";s:7:""67321"";s:32:"8d3d80924764057eb2caa664286e3ee3";s:22:""ste-cecile-d-andorge"";s:32:"016aa023d73d7fb7598df9697c40c1e7";s:7:""30239"";s:32:"bb4f128b534a28753fdef109aeee6446";s:21:""gonfreville-caillot"";s:32:"8c686950614d9fe67c30c56d66b57b82";s:7:""76304"";s:32:"d3cbd3bef7e28448a437b58f00e3bb3c";s:10:""mirville"";s:32:"776f4b9887bb9e203015918ba8196263";s:7:""76439"";s:32:"15da8db1b7245d801be0a773c6314b51";s:13:""rouville-76"";s:32:"ab6b9e6f90e2eea5c62a4f57a700e506";s:7:""76543"";s:32:"f42fcc9354595958716a68d7daca7e68";s:11:""chanousse"";s:32:"291109f68b3daa89b545f8aeae81b8c4";s:7:""05033"";s:32:"000c46b528145db8d105f575758a4bf7";s:16:""ladeveze-ville"";s:32:"d2b6ae8d5cd2b3fd4a1b5f1802545a3b";s:7:""32175"";s:32:"e8c674dbe38addd82d0909eb1593f0b8";s:8:""rothau"";s:32:"09e837ad5cea10146d36e53d09e97b36";s:7:""67414"";s:32:"db52e81f939b952e081b288223a4488a";s:14:""domessargues"";s:32:"20dc211b5640df8c6de778f6700c3148";s:7:""30104"";s:32:"7526b32369bbb69d4063804186aa49d3";s:10:""ledignan"";s:32:"8c1b8bbad1ad0e892844540edbc884a2";s:7:""30146"";s:32:"0c5408ab462c508946fd06c04e7c0a75";s:14:""ste-marie-05"";s:32:"b689ca47505e9d5e7a128c463d25b0fe";s:7:""05150"";s:32:"206e4823e498c70e2efa2e590295e6b5";s:10:""besseges"";s:32:"74db5da983880fa55454444726d605cb";s:7:""30037"";s:32:"b5bcec2ebb0cae9d6fcea372ab82d332";s:14:""st-medard-32"";s:32:"29ad86e567e6fb349400166688a636ed";s:7:""32394"";s:32:"eb8bb430c8d9556acec5e896ef89fd8c";s:21:""bellegarde-en-diois"";s:32:"d0e71df84835a198cfcb49d5fea31bac";s:7:""26047"";s:32:"149a4f065feeed870363a33d22287870";s:9:""volvent"";s:32:"94d88d67080f580dcd7cff0bdabe109e";s:7:""26378"";s:32:"bd4df97ca33405f557293c6f165e6ab3";s:11:""joncheres"";s:32:"e4151ef07cf051fb92095bfe6aada98d";s:7:""26152"";s:32:"437ba9a833b379b185ad44c605c3ca67";s:9:""moydans"";s:32:"ce0ac545ce2346ea396061f381cd9f3f";s:7:""05091"";s:32:"0f8670c2808ec51e412217c7ed835fb6";s:12:""espinasses"";s:32:"90740fe9a034595ec6632c77191277d4";s:7:""05050"";s:32:"735d5ff79aa2817d864567d7720fd279";s:16:""pont-en-royans"";s:32:"6cae5278a319b2a81db39f07d8e0bbba";s:7:""38319"";s:32:"8e78000c07a008f34dee9f11526b412c";s:20:""monetier-les-bains"";s:32:"6f0be484ecdda152885448bcc516160f";s:7:""05079"";s:32:"54aeb8e471b5818a2a4529b7b2963440";s:8:""carnas"";s:32:"d6218164f1676217e1564a0792aec1a5";s:7:""30069"";s:32:"d0154d3d12a25841ac2d869610fb4fea";s:5:""gap"";s:32:"352d648087cd2773b0e7b0b7f5b0ea8a";s:7:""05061"";s:32:"ce35dc0f64fef5464c65f091f2f31797";s:9:""marciac"";s:32:"f693639672651bb673e26f7dcb9347a4";s:7:""32233"";s:32:"e9cbebd7d155308f89276239f43de243";s:9:""ercourt"";s:32:"5f0634fbc64d6bcf6f735d9c3ac44332";s:7:""80280"";s:32:"6b431dbbb676ccb2597f335da2f4a5d7";s:24:""st-etienne-de-fougeres"";s:32:"309f18e5b6cd2ca37ddccd8b5fe44437";s:7:""47239"";s:32:"542a36960498c722592cd6b208119756";s:9:""moreuil"";s:32:"761f6d92359307dbeec0ea5ed4e19577";s:7:""80570"";s:32:"7e2b6254effb1f6a51d7ce25042ebc8d";s:12:""fouencamps"";s:32:"8724632d9d6fa86b158636926dc15f3b";s:7:""80337"";s:32:"a7dd038f3d857fe4ea38620c12d884bb";s:9:""malabat"";s:32:"77d4a4d373e210c7973da47c89caf575";s:7:""32225"";s:32:"018626196d1ffcb4034464ab5f6c6688";s:19:""st-julien-d-eymet"";s:32:"7b12b970931644594570da9c8287bd77";s:7:""24433"";s:32:"ee2270889936d941db894b7f288d065f";s:14:""cervieres-05"";s:32:"ff8bf650064e9fcfd0d842d3102f457f";s:7:""05027"";s:32:"a86c897d8e16f692e0a4b9070df409c2";s:17:""manas-bastanous"";s:32:"1ac7d6e80fa2d446a0ab77900b5f3d2d";s:7:""32226"";s:32:"30bc81650d7ce75147d4ae16a150f49d";s:14:""coltainville"";s:32:"3a54cb413387e1e592d6bdbfef97c61f";s:7:""28104"";s:32:"b8582666460cb52af2b46838012c5a52";s:13:""fourques-30"";s:32:"35962955b8aaada01a36856020685bda";s:7:""30117"";s:32:"c9a26aee46bff6dd4bd9bda5b4440baa";s:14:""lamothe-goas"";s:32:"8392ebfdb2a5d0e9a4a2b01271684116";s:7:""32188"";s:32:"80f38fcb817b4e4a965e5b818338dffd";s:21:""bettencourt-riviere"";s:32:"99450196ee2125a521c813abd94d36a9";s:7:""80099"";s:32:"a02740496e7b5245fd825032a3531aad";s:26:""st-pierre-d-entremont-61"";s:32:"0ebd6dd4fd7df0cf2dcc450e2eb91c6f";s:7:""61445"";s:32:"226fa9172c0ebe60df3d729da2316555";s:10:""larre-61"";s:32:"e52c854d3ff27f2e7e15e8486ccd4e8f";s:7:""61224"";s:32:"9813cad08ab1fa2eaaac7e99518f8691";s:12:""navacelles"";s:32:"f6e750ed6189dd70bffdc8f3d1807fec";s:7:""30187"";s:32:"59d0125bb9bc1b7997da7e846f7da0d4";s:12:""st-ouen-80"";s:32:"19a49e49399fb28d09a2396a1341519c";s:7:""80711"";s:32:"d24d15eaccf0fb13685bb64f76c56db6";s:20:""castelnau-d-arbieu"";s:32:"428487e24e5b8c87d6523c83f1b79293";s:7:""32078"";s:32:"408944ec90e5c9538b9a5e5ef4b366a3";s:8:""berrac"";s:32:"483bebc731957c00bc89d1f8c6e5d35d";s:7:""32047"";s:32:"1439f282c7e3bf08e86bab77f2b7ecde";s:22:""st-leger-les-melezes"";s:32:"3c6bdde3d2b3c4165f670bd66b4afa70";s:7:""05149"";s:32:"7f19b2bb25640b136d75ccc17533510a";s:24:""st-genies-de-malgoires"";s:32:"00614c534a211d30be3577ca63efa98c";s:7:""30255"";s:32:"bcf1a31166df1f8e27a1e979d1d8d09d";s:17:""chateau-bernard"";s:32:"21eb7e10f66abbaa95fa252d5b02fc12";s:7:""38090"";s:32:"efe757fe8294a1ba58f729ba21439b38";s:34:""durfort-et-st-martin-de-sossenac"";s:32:"face9f6d1953ad4dae0be6798f496e52";s:7:""30106"";s:32:"86df2cd600d9dd9d9f4695cb46d7f7fa";s:9:""vars-05"";s:32:"4ec556aba8b499e13efa19e3ff028c5d";s:7:""05177"";s:32:"12a563d416e8310e6e57e50a3d7bfe42";s:10:""cessales"";s:32:"2af9fa3a38e21af68b66dfd6f109f8fe";s:7:""31137"";}s:6:"fields";a:140:{s:32:"0776bc5a07b6293ad7a608503c8f0fbb";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:52:"(CONCAT(nom, " (", code,")")) 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:"d56346cbc1a9c1c07ecb6f77d7298a85";a:2:{i:0;s:87:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*, Moyennevente.*";i:1;s:18:"`Departement`.`id`";}s:32:"0bb6bc173a2b45b2ceb92ec73da488ad";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((49.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.883333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}s:32:"8ee4e381878886a74715e50c607da897";a:59:{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:26:"`Etablissement`.`modified`";i:58;s:25:"`Etablissement`.`created`";}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:"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:"08fbd6a6e670d6ff45baa1e317520a22";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbb4049ff44acfac692ab12128a8ad9c";a:2:{i:0;s:71:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*";i:1;s:18:"`Departement`.`id`";}s:32:"acb3fd07040bde11e87243022dc952d6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}s:32:"ae695de10974c35a00afb6f4e020bd90";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.966667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"99347376626bb8ca02bd1bd8ed7af2f7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((48.825*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.825*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.19167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}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:"8ad976faf6a138f9a8ae10a341a70680";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"83febd30a6972fd975b313699f719176";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.816667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c80f71925ac3cecbd5aed7190ff3e9f0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dc0988f29148098ee1dab42097ac1751";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c2dba63dc4c9653a6bb2720fa8700413";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ac2a7de1032f79c4b8218c21288e0c1";a:3:{i:0;s:54:"Etablissement.id, Etablissement.rs, Etablissement.slug";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"c4fd98c43562097d790d7e33c74a05f1";a:3:{i:0;s:14:"`Mur`.`pseudo`";i:1;s:15:"`Mur`.`contenu`";i:2;s:14:"`Mur`.`posted`";}s:32:"227110cb1331a56c3995a31fd8c4db7c";a:1:{i:0;s:11:"`Annonce`.*";}s:32:"c8626a9c14dd4a852b7e666e6295b3a2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*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:"91d8e7f8be750f3bd94cf277e708a109";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"20e9df009beaf1b826b1e62cab4f65bf";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((44.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"639e5a377bd0c2327799e4a25655e67c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6167*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:"173ebc9062a26e2702f0e3b009180c28";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((44.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4*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:"087826a170bee71a96d8f9367f04d7eb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((44.2264*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2264*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.5125- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"158a7109619e93c4e5c5fc1e3ef61e4b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*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:"7cf45341b2f40ca8f39f2b84a7e97935";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"730eefd90841f33100387a997693067c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"acff4b99f20147c6b0ddec268f613efc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;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:"9669e0399577f542d96e4aaca390155f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d89bd9328e04ae289985533b362ef734";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1884c6d8d6141eaf3ab663ccd8b973e3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1e6c50f0ef05937c946927dab5c74d18";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((49.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"105f2ef755fcadb929cb4b4fbb662cbc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.0587*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0587*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.18445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"41c398ae45ba06ef3bb5876dd6730cee";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.516667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"71ea315b620df3d38458957f51d48390";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((48.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c29eddc33e46e47cb0fd29d95f55e28f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7333*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:"9493e28069b805cdc7f7dffb741ed0ff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.466667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d8a9def7f80e083c74aa1a586f8725fe";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"df3aef3b86f29a508385bc36961e0cea";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.516667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8659c4955c241a1fce18354e2ea8a78f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.2581*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2581*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.299167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ec5fa72ee4096b38df0263405812f1e4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be5c1e778c973fb156c00d0857859a80";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b13d4432dfbb702314c03d80f0505bf8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((43.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d1ef7aba87b9406b88ac18a7a967fc97";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:186:"(((acos(sin((45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ffc6a9bf2f5a32ef99f3269319af5457";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fa875c89041313a7f4fcb581f2bbee58";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1aa4c938a316716a1add1d5b5f6b83f7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((43.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.216667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"40458cbef0a58c80a2122ec8c28b1eb3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((43.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"156d3e366625f5b9206cc242d2ce73f9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*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:"d3aae0c0cf80eed6f7fbf985a38a4a09";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4667*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:"d3be55d74475789863b381a96feec560";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f62a4a47655b472fab81b62196413ba";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((49.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"05e084dfcdde9c6a55430bd6e84c56cc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3af0034f757147e64fbd2d75b6cecde";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((43.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b5af0727315419a448535766d6a654c0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"540c69ffe11282ae59c561cea3f1a99b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dadfa8b3d00179b822407e41ecc0fbb9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((43.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*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:"963a87d98ce2e25957140a0347206868";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4ec22edd48c2e782d9450396a2d1cc84";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e81164f89d3f03c94176c43e97ea73d6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"113faa44fa9123e3ce99e0168ea912ab";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f52c80d731c3008b7cc266099a99db91";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((47.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1320847f829683456ea8e4c12581547d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7041c837a8b6275fa6d8b9abe159dead";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((46.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9a9948fcbd12724af2ee9dc513dfa041";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"93d8da1d69489f0645c2a42936fd1504";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"947f14fdde4994d793d2a6fee65834dc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"430a6f0649d340d0fd3cb3fd5255efe5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((44.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*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:"2707491a06b050b55ed025a40375adb9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0c44082d1c3e778c3d49c3dc65053f3b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"201eb4ce31a0416b8984bb2e8bf7eaa0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f02c854d84ad56eb57b2c5910ab2a683";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5c8c6895c83f7c82f3e7c1fc7c4b2d71";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((49.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e52e80ab4878361c2b6d260df9469c85";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3d49958415dde15934c44496fe06211c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8a2f4e31b2c31cc28e1372953541fa1f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a2edf2a2f3c3664b3338a7a470d1b8f9";a:2:{i:0;s:90:"Etablissement.*, Departement.nom, Departement.slug, Departement.code, Ville.nom, Agregat.*";i:1;s:12:"`Ville`.`id`";}s:32:"aec2a629c478fa98aa85f470a7372bdc";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"a4024e4edc643d361dd57fddbf82a488";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbc4a6b86649341a6b1be2e4ed294591";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"04f72f7aaa401eb4051a139a039aac16";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((43.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.283333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa988c5aa06006dbe92d109cc1acdbe3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"43d6c4c3caa4d3e6a2bf84a4a10ca88f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((44*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44*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:"135d2d50731819ea18087aeedc69103a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"edd93e1e6b567f0a1356a90aa7641e5a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((49.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3333*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:"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:"9abaa330400ae2409ddb10f474ee2588";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:199:"(((acos(sin((46.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2d826b8b748dedd2698c1c21df9eb71f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b44c615c5057ffe569dd87e5fdce7faf";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((48.4392*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4392*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.2389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"db29527870172952171c12b7dedcdd9c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*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:"e2909999721b8297e22df95af86744af";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((49.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.433333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5d4d9e49e3a96d8ee8c69813610f79b2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((49.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6167*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:"2527b7cd05258105d4a955ffa2d64aad";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.6153*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6153*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.499167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d4cbfd31254ee8029d0a6926c0aa918a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((44.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.35*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:"7537855fcf7756429ab3f7f1a54e2a76";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3a39ed51a4828960f9cf614046248127";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"27c77e24eda187957a633cbdf2476012";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b8711348d39560011ce0260063da07ad";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((43.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e83d0ba98a37af60976d4cc5fc578518";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((44.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.475- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b2fbb88e2142cc359976d9c1283ae9a8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"459c7ae35894944b1af8b737ede8a16d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.466667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"91b3347560d4b55ffaf73ed130c6785c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eac20c62a803f2aa2baf695d71d8ce99";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*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:"b6c7d8a6178eee0be31916b353114d7b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d95861bd07a07cdf2384f7032405fbb0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((44.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a66ce7df74dc0109a54bb1b1bf708513";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"41fd74890291093f80dc379a4b5f738e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((45.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0667*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:"3a57ae5a2589033e77d88580ee4fd452";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2c020dc8417b291160a915cc51dc2fb2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8167*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:"3cef5551e41bf977ec6eef5ad04e3258";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*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:"d9eae96d993f1cf2eadc5e5f49387361";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"21e4949320996ee610a8e44dcd306ebc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((50.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bb34bcd2882f10c515d336977635286e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3d3ca36e9f39331b48bf48bdcf53d95f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"54be861ed68692da35b8e62ff2b5b70f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a3b08c1838e3ac8d7d60e303ab84bf5d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"60835ab4336c9cb545764c5ba0f7a15a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.433333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ade7c918a393a7d8d61a508d957a5dd8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b6eb840c1bb5ca4778fdbdb55bb075c4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2487c1731ec0376e02e61ec539fb066e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"614c3e337d29326f7869d876b661a7fd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.6931*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6931*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.61056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"65ce83a6973c846a34a445c7d359c925";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"df0144cfb2ce76339fa72fefc86acbd1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"78b82f85241f9498b071c2f85a4f4e00";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((48.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b2105971d30c120c653b1c72f60af595";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((48.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a47602c295b3a6aee47a41a99cf2d763";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e1f1825ddffb19a834955d2caf7965d5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((50.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1d164a2748f921671801eb31f063bf48";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((43.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"33c2c83dc14dcec7616abc7bb42bdc11";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c46b24813295e79ae5df6f01dade3cd1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6939fc6184ca1eaf27f343b7eb5c3209";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((43.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance'
unserialize - [internal], line ??
FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828
DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
VillesController::index() - APP/Controller/VillesController.php, line 14
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 111

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

• contact [at] dansmaprovince.fr
• à venir

Déposer une annonce

Partager la page

Pour la recherche d'une maison à rénover à Pouzilhac en Gard (30), nous comptabilisons à ce jour peu de résultats dans cette ville.

Maison de ville à rénover (annonce exemple)

• Où 30210 Pouzilhac
• Ajouté en juin 2021
• 137 000 €

Maison datant des années 60 en centre bourg de Pouzilhac, elle comprend 4 chambres, 2 salles de bain...

en savoir plus

Annonces de maisons à vendre à proximité

• La Capelle-et-Masmolène
• Gaujac
• Connaux
• Saint-Victor-la-Coste
• Saint-Paul-les-Fonts
• Valliguières
• Saint-Pons-la-Calm

je suis agent immobilier

Pouzilhac Immobilier (30) à la loupe

Situation géographique : Orange 20 kms - Avignon 22 kms - Nîmes 30 kms -

Dans cette commune de 709 habitants, installée en Gard (30), une seule agence immobilière pourra vous conseiller. À noter que 14 biens ont été vendus durant l'année passée (2020) pour un prix de vente moyen de 2101 € / par m², une indication clé dans votre future négocation immobilière. Vous voulez en savoir plus ? Consultez les agences immobilières locales.

Vous habitez Pouzilhac ou dans un secteur proche et vous avez une maison à rénover à vendre ?

Déposez votre annonce, c'est gratuit

Prix immobilier Pouzilhac

	Ventes	Prix € / m²
2019	9	1977 €
2020	14	2101 €
Évolution	55.6%	6.3%

De 2019 à 2020, on peut lire une augmentation de 6.3 % pour le prix du mètre carré à Pouzilhac.

Archive des maisons vendues à Pouzilhac (30)

Située Pl Du Chateau D Eau à Pouzilhac, maison composée de 5 pièces principales pour 114 m² sur un terrain de 890 m² - Vendue 204760 €

Située Rue De L Enclos à Pouzilhac, maison composée de 5 pièces principales pour 126 m² sur un terrain de 796 m² - Vendue 180000 €

Située Che De L Escougoul à Pouzilhac, maison composée de 3 pièces principales pour 75 m² sur un terrain de 900 m² - Vendue 209000 €

Située La Rouveirole Et Les Cases à Pouzilhac, maison composée de 6 pièces principales pour 165 m² sur un terrain de 1130 m² - Vendue 327500 €

Située Che Du Puget à Pouzilhac, maison composée de 4 pièces principales pour 120 m² sur un terrain de 579 m² - Vendue 225000 €

Située Che De L Escougoul à Pouzilhac, maison composée de 5 pièces principales pour 99 m² sur un terrain de 1308 m² - Vendue 221750 €

Située Che Des Conques à Pouzilhac, maison composée de 5 pièces principales pour 162 m² sur un terrain de 1000 m² - Vendue 340000 €

Située Rue De La Liberation à Pouzilhac, maison composée de 4 pièces principales pour 112 m² sur un terrain de 760 m² - Vendue 220000 €

Située Rue Rd 6086 à Pouzilhac, maison composée de 1 pièces principales pour 48 m² sur un terrain de 2047 m² - Vendue 190000 €

Située Che De Saint Paul à Pouzilhac, maison composée de 6 pièces principales pour 123 m² sur un terrain de 1545 m² - Vendue 215000 €

Rénovation maison Pouzilhac (30)

Artisans du bâtiment

Pour vous accompagner dans la rénovation de votre maison à Pouzilhac, nous avons listé les entreprises du bâtiment.

• Électricité (1)
• Maçonnerie (9)
• Charpente, menuiserie, serrurerie (3)
• Couverture, plomberie, chauffage (2)
• Nettoyage toiture Pouzilhac (demandez un devis)

Annuaire des entreprises de rénovation Pouzilhac à et proximité

Déclaration de travaux

Selon la rénovation envisagée, une déclaration préalable de travaux doit être réalisée auprès de la mairie de Pouzilhac par le formulaire 13703*07. Agrandissement de la maison, réalisation d'une pièce annexe (véranda, garage...), création d'une fenêtre...

Mairie - Pouzilhac
6 rue de l'Hôtel-de-Ville 30210 Pouzilhac
04 66 37 17 77

Aide financière pour les travaux

Selon vos revenus et les travaux envisagés dans votre logement, l'ANAH Gard (30) peut vous venir en aide.