Notice (8): unserialize(): Error at offset 98142 of 98293 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) 1762147355 $cachetime = (int) 1762147365 $data = 'a:3:{i:0;b:0;s:4:"name";a:471:{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:"8151d7c583cf02715cfac50c8817e535";s:8:""lapege"";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:"e176ac01144c24b0c5319ff019be464b";s:7:""09152"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";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:"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:"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:"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:"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:"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:"3c997aa1ca53e4a5352de1499b5fb6ba";s:21:""chapelle-taillefert"";s:32:"872f0975742d44875b74a7ffea3f3217";s:7:""23052"";s:32:"ffa4b2f3515565a3ccb5aa733d2c1398";s:8:""cosges"";s:32:"80e5f70f75cbd8f9ef57c0f3905d4480";s:7:""39167"";s:32:"39ffa6d9ea8dfb78e218b83e401ea8da";s:12:""chamouille"";s:32:"5e4dc74f195feae68ad3f834acab4f9d";s:7:""02158"";s:32:"168a1611a5d191cb59d4b3a7ef64ac44";s:11:""termes-48"";s:32:"a4d5d5840844452ad7797353852687cd";s:7:""48190"";s:32:"0232037d008538299637eeaae72dacf3";s:8:""portet"";s:32:"6fbb3430610a4866b5bbcb3c605cdc40";s:7:""64455"";s:32:"942d334278a96d066aeaaa656e025090";s:5:""sus"";s:32:"e852416d58b135424a3351617acf478f";s:7:""64529"";s:32:"5dc4dd33b46b3ad2356aa437dd14cf9c";s:8:""bandol"";s:32:"fe822159041cd5585c7dee8f70a8c23d";s:7:""83009"";s:32:"f1dc8fb2582cb5c4e5da66641dde8eea";s:9:""poussay"";s:32:"ab649d9b7e56369b993b115a913442d8";s:7:""88357"";s:32:"d1ce87452269d16d9197036f1689fc68";s:9:""blagnac"";s:32:"c2c04c5fc77fada43e9347ac3d8c0910";s:7:""31069"";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:"5218208c55ba4407359d382521db3b31";s:8:""vendel"";s:32:"af065ae004801541235113f2c4eed84f";s:7:""35348"";s:32:"05992dbb8005380d06f987f18635006a";s:18:""st-pierremont-08"";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:"22307b9e7bc54a266d6e79c4b5addd35";s:23:""st-denis-des-coudrais"";s:32:"75f23928b89328c33318d68674a23108";s:7:""72277"";s:32:"446074accf70841c032758c1645ed6e9";s:14:""isle-d-abeau"";s:32:"f68bedcecbf1a31874741fa021e4f9d0";s:7:""38193"";s:32:"8c4bfab16883a287ed6928b90de27696";s:10:""curbigny"";s:32:"e8d92710ca4c8204b51a154592225a20";s:7:""71160"";s:32:"4451ccddd807874f66edd0a872a60cf1";s:9:""crenans"";s:32:"13e881b6fe9357ade6c97e1a97a49a20";s:7:""39179"";s:32:"467ef4fae9ed1cecca3146e6dfdf38f1";s:5:""ney"";s:32:"cfe6e5ef67dc486b9d0cd7f5839d1c2f";s:7:""39389"";s:32:"5bd96d1ce293d04f14e2f62599ab70a3";s:9:""perouse"";s:32:"c61c13ddee959a70a7f458f4c0d28c73";s:7:""90076"";s:32:"ad9e5dee500c068c6617f0dbc682b462";s:18:""sauliac-sur-cele"";s:32:"c8bb41228c0b7ba6b4b8e775fc176d7e";s:7:""46299"";s:32:"55cd8a508ce2577a77c01f2b9394b95b";s:9:""combres"";s:32:"c5130f2cb3da826a2f5d00c181f459f5";s:7:""28105"";s:32:"7878accad73bca00d0a636a5f668c134";s:17:""aix-en-provence"";s:32:"546c6c0cebd871de286defeb9e5e838c";s:7:""13001"";s:32:"9d347ba9886c4dca56e45976d0d3827e";s:8:""arthun"";s:32:"7be9327d1e2102e90a6a9e5e00f7de6a";s:7:""42009"";s:32:"a41bdf29c6da0277a0aa575b1c72bdf8";s:22:""st-etienne-en-bresse"";s:32:"c8caa728937891ec45a979030f8b70f3";s:7:""71410"";s:32:"10380469e73de40e6645c5f4de19dbf1";s:6:""rans"";s:32:"e44f449ed79262c6dd45382cab325c62";s:7:""39452"";s:32:"1a5cc7e4ef3ff231ac1af1a2f58e4eb9";s:12:""longcochon"";s:32:"2b218265f098f3425e4cc927748c7c53";s:7:""39298"";s:32:"aa07edca648449819da03e538383ec49";s:20:""thorigny-sur-marne"";s:32:"9bbe16af974cca929fb03bc24091a07b";s:7:""77464"";s:32:"c9d2b59aeb12eae9d5aefee00bf1cc1b";s:10:""bouchoux"";s:32:"f666acd5302471da781c95f33e63fbc7";s:7:""39068"";s:32:"81a8ef8a90c0dffe862beda7084ca4e6";s:12:""st-eloi-23"";s:32:"d3d0d1107a0dee54a287a2dc9387f1ad";s:7:""23191"";s:32:"ce57d1506546e509a6292ffeb7e0768a";s:10:""chatelay"";s:32:"1f262341f80960274c61732d26fa0f8a";s:7:""39117"";s:32:"7a1a3e082b77f27d1a575172917dedb8";s:10:""st-usuge"";s:32:"a5afab3daec89f2bf9c14905c11d4510";s:7:""71484"";s:32:"6c5893692ecd8a3e8af27e076502ff33";s:12:""montholier"";s:32:"395520442325d7062e374ef3e229a76e";s:7:""39354"";s:32:"375dba6daced4a6e5df513203b767366";s:21:""largillay-marsonnay"";s:32:"5b0d2bf1e49828fed43c024de612279d";s:7:""39278"";s:32:"c09444a6e0eae407140e0ab3d25d6b2f";s:12:""equevillon"";s:32:"5bf7408958efac4f70c3a39784293573";s:7:""39210"";s:32:"a320dac861a0f9c23627833f1eb4c02f";s:20:""masbaraud-merignat"";s:32:"6afa205d6c3e7cbfc3e545dafb86db09";s:7:""23126"";s:32:"73e60ce149ecf67e47eb031e8c284a6a";s:10:""gevingey"";s:32:"6118f893f1223b4ad052fe13fa376c00";s:7:""39251"";s:32:"f2558450ced8cf059e4341633bb76c4b";s:8:""maucor"";s:32:"bd122ee4fc84254185777daa526bd1c9";s:7:""64370"";s:32:"ace3030da21eb407dc194f1b24b76a64";s:10:""basville"";s:32:"b599e9b74e813e3d1b4e3912ae56d792";s:7:""23017"";s:32:"7af888fd27dedf6bd22ab13e0d398adb";s:8:""tingry"";s:32:"8b06e1d2ad040a4db45f9d530092da16";s:8:""sermur"";s:32:"750a228c3ef8034e7d513f66f504612d";s:7:""23171"";s:32:"be8844a82b370dcb9cbe336d1942a87c";s:10:""loutehel"";s:32:"7876cfcf60cbcc11334f31a7e6edfd13";s:7:""35160"";s:32:"019e2fa5b33ef7c761ad9fc681094616";s:10:""lupersat"";s:32:"246685233c969b1e59761b1cbd977f5c";s:7:""23113"";s:32:"2580daef0a1001577df8990c04c80bbf";s:16:""lamotte-buleux"";s:32:"9367eae2e9f54b67b1a37f8ccc0321d6";s:7:""80462"";s:32:"2fc9b1ac1e802a99492716e01c6a1ac4";s:17:""foret-du-temple"";s:32:"b03d9cab1bf9a75a03de92e049f6d172";s:7:""23084"";s:32:"2b8fc1807c23f5885226ade8d805fa83";s:9:""mesquer"";s:32:"9bb0d998e8fb13d12d15fad76a7bfcec";s:15:""bief-du-fourg"";s:32:"f161a48bfe66fb4ee68cb8f4bc803238";s:7:""39053"";s:32:"f8db6e01d00aa269962b2debd120dd0a";s:18:""lioux-les-monges"";s:32:"2362d96b8d422ed0902314e090b72b74";s:7:""23110"";s:32:"bdfca8803e8e21ce28a8b075b633ec9f";s:9:""laussou"";s:32:"e64eb8eed90d85390e1e93b2f3ce6947";s:7:""47141"";s:32:"b2bb4ed9fdee09b2b37df20bc559cb32";s:7:""nance"";s:32:"5524af7bb67f95eabea954a4fdeaaf39";s:7:""39379"";s:32:"0c57ca45a31968e62f6746f367aa13c2";s:17:""st-priest-palus"";s:32:"c00c0a05bf54e9f63c2a4557c018c025";s:7:""23237"";s:32:"8f92dad84c9f9ddb35b4a89ce52c1ec2";s:12:""pardailhan"";s:32:"3e1e79eae024a7cd3de162f2c4628e36";s:7:""34193"";s:32:"0a22aa8b7e3b7d4d77d86679d768d3ee";s:14:""petit-mercey"";s:32:"976691899b4397c9bfd02737c7c3bc4d";s:7:""39414"";s:32:"600aaecf945f53ad0b807adf4de440af";s:14:""st-priest-23"";s:32:"0acbc3615b305d61d989009f638d5358";s:7:""23234"";s:32:"f3793d4cfa767458effb4d1e79df9e68";s:11:""baillolet"";s:32:"69bb9e3fb47e1d8aa87c70dc72abb83d";s:7:""76053"";s:32:"5e2a4317605b8fe72fb3f60f2872bf70";s:8:""bonnat"";s:32:"b57d9d31f6c043bd0539abd896ec5c02";s:7:""23025"";s:32:"fc700d192aec08b37a6b2a5594c89c9c";s:9:""sardent"";s:32:"8623f93036401f3bae4d320330ebdfcd";s:7:""23168"";s:32:"543100affbfbf8aca5f2cc2d44848042";s:10:""dramelay"";s:32:"e02b2f5fc6ff958b92cda5eebcd5d165";s:7:""39204"";s:32:"8b5404789a1ed642a1de8e6389189c9a";s:11:""lalbenque"";s:32:"72180d40d227a927ef4f89b42c288143";s:7:""46148"";s:32:"d98f6578545dc84f3b650d3dba249fbc";s:13:""st-chabrais"";s:32:"4193796387a80b6bf79484a97278b3d3";s:7:""23185"";s:32:"5c36dee2a9bb6d25a09d98d85c44969c";s:12:""plenisette"";s:32:"dbb799d5a8b98eeeefeb02f025ac13d9";s:7:""39428"";s:32:"1191fb8ef0e8263f3c9cee5a9b5aba75";s:9:""measnes"";s:32:"eb716cbbffad0ed77e8644dbc10230ad";s:7:""23130"";s:32:"be963a214200ad783f886dd83fc9b1f3";s:8:""biarne"";s:32:"2d20e4f01cc563419d847a5ff23e778e";s:7:""39051"";s:32:"a71e5d1d7ef6680c39177a8e55d76915";s:7:""ajain"";s:32:"b35bb87db79496c432c136eccda9f6cc";s:7:""23002"";s:32:"057c77c6bb014f49846c2e21e4ec7401";s:17:""chapelle-baloue"";s:32:"7b32b70cecd44544e1b7c58f4ae6eb97";s:7:""23050"";s:32:"416e13c55a896f8fb33464c51b8cab4f";s:10:""st-domet"";s:32:"607828bfa32388e78fb654cf90c4e5bc";s:7:""23190"";s:32:"04c91a308037f9280e82364d3d671703";s:11:""neuvilley"";s:32:"748041c71313a45472c82fee0dd4d49a";s:7:""39386"";s:32:"25877d9b3e45ba8c1ef2bca33cfa4224";s:6:""onoz"";s:32:"294e593be0f4cebdaedfc428e3c82e66";s:7:""39394"";s:32:"c8ba5347dc68cabdd0deaf6d3debb73f";s:8:""chille"";s:32:"af638faa7072eae95d07bc688c53a35c";s:7:""39145"";s:32:"f8a6577c3c7611cf6ca6aed114488434";s:20:""st-germain-beaupre"";s:32:"0279d4661c1e023de73f5ea6703e8e26";s:7:""23199"";s:32:"8b134e2dea151a9cef4416b45a052bff";s:11:""courbette"";s:32:"fd7f0f52ac99fa991dd7c126b1f1e8d4";s:7:""39168"";s:32:"761352ef0d57d6023207ac8efd9fce4a";s:8:""malval"";s:32:"a765286e7043ff57affcb7f98a46864c";s:7:""23121"";s:32:"3cbeb9dd9313c1cfd4a210f55f58940e";s:14:""framboisiere"";s:32:"b2444e163d129bf4bd0d6279c388cfb1";s:7:""28159"";s:32:"c1991e4d780e469b72bce08ba6c1d21f";s:23:""st-pardoux-le-neuf-23"";s:32:"81e604fc05da6d3f75db29eda418e69a";s:7:""23228"";s:32:"765e149fc77d83a1c5a049b594266b23";s:7:""neoux"";s:32:"54f75f4fe204a664a5ddf5021e49db8c";s:7:""23142"";s:32:"cd3b3c760dc894c665e82c32b54e4e0b";s:12:""charchilla"";s:32:"d0a8336953a285ade0b7004231b97a6e";s:7:""39106"";s:32:"119bfa6fb4bb6f9ac3b1866469910498";s:12:""brousse-23"";s:32:"93eb1218f284d05aabb296a8fa9ea1b9";s:7:""23034"";s:32:"c5c9fbd985b19a76e9023fc40ce10600";s:24:""villeneuve-sous-pymont"";s:32:"d659407ec86f91fce06c77cef980f730";s:7:""39567"";s:32:"66bacb92069268bc640baee7ebb0bf60";s:18:""magnat-l-etrange"";s:32:"56882fea408d0b182f9ac28ddd0b1ac9";s:7:""23115"";s:32:"e289a516171ff697ed3dd9e52040323f";s:24:""heudreville-en-lieuvin"";s:32:"b77846467a8d4ad54cbb163c7496cb4e";s:7:""27334"";s:32:"24909b3a07d4a19ecf5c7980130ce36d";s:6:""noth"";s:32:"c49d9453144518f87196f8b9d9230a61";s:7:""23143"";s:32:"39bca111a8102e2568a30e2ab1ca5cbf";s:7:""prehy"";s:32:"2d15648db2d709f28c6a89573d05fd27";s:7:""89315"";s:32:"88642291638f0f8e05b9c48dc9749214";s:11:""etoile-39"";s:32:"d507ef263e8f1ff36af65c736ce10823";s:7:""39217"";s:32:"c25a4d05c8ba24f1aea7e0035ffbbe7f";s:7:""lains"";s:32:"cacd34e919b2478d352340ecf429688b";s:7:""39273"";s:32:"a5875955d97a7b5418bdcd5ea194176b";s:20:""st-marc-a-frongier"";s:32:"f2fbdfdb1c89de360ebf3e17c497dc95";s:7:""23211"";s:32:"6d9555ce5160c06fdb16f6c0e4fa25f9";s:17:""dun-le-palestel"";s:32:"630a43cf8a0397aaf85c86e34bbea7b2";s:7:""23075"";s:32:"f3ee8459fc0406e2e65ec66d424b3fdc";s:11:""quintigny"";s:32:"b374f9019da4262a7401200d8a2eaaac";s:7:""39447"";s:32:"a9dfca6eab9d9796688a80da688ce863";s:13:""larchamp-61"";s:32:"6feb60152c251a2cc03fafe145aec5ee";s:7:""61223"";s:32:"e13b27d3580bb962c7eac7d96399bf22";s:11:""vigeville"";s:32:"4b13d00cb161eca87f05c4c2df889021";s:7:""23262"";s:32:"b6cd94afeb2dbb3b0f8294bc1fd12f24";s:22:""st-sulpice-le-dunois"";s:32:"0705fbb0556082aeeefbe9a48bbdaddd";s:7:""23244"";s:32:"62ec8ceee208e62633d3db7c3b965e96";s:23:""st-sulpice-les-champs"";s:32:"4e1e14823143da662d9086e8bb7dc353";s:7:""23246"";s:32:"7f2a23b395beedac82857f727c58c8c6";s:20:""vaux-les-st-claude"";s:32:"01cb21b13b632524645de95b01cfb102";s:7:""39547"";s:32:"21310ab34a283fe3329b28f9fdcf8111";s:13:""houdreville"";s:32:"92ece64e4af700f5789f48a84d051d67";s:7:""54266"";s:32:"238a22aae6657f1631a7f7e36c0bf315";s:8:""argein"";s:32:"a10fdda306f67cb5afecc9875048f2d2";s:7:""09014"";s:32:"f12b6737cfcde4f6b7f42ad7b322d5ec";s:7:""guran"";s:32:"86f2eae9da2a849d6f8dfe3b10e0b6cc";s:7:""31235"";s:32:"c81b767036d10fec6961591269b762fe";s:10:""nizas-34"";s:32:"7128f65d18ddeb7bc20145bf42d5b829";s:7:""34184"";s:32:"308ade26d48b236e06439f6043d9b331";s:9:""asserac"";s:32:"1efdd75c753bf1cf0261e0339ab4fc2e";s:7:""44006"";s:32:"cfb88ac1a5ab1905e30d1af873415108";s:15:""francourville"";s:32:"773e7a5a38501af2931683514f3656bc";s:7:""28160"";s:32:"30477304ef591fa8f58b7ae6b579c3b6";s:16:""amorots-succos"";s:32:"242adbfc2753990353494d7a989d9634";s:7:""64019"";s:32:"1629dbf13ad30a9b33483580d196fe59";s:9:""buffard"";s:32:"788fcf7124f26294c7b61ad62ff5a67c";s:7:""25098"";s:32:"5d0a6b50f300f12424471f5cb8614f42";s:7:""yenne"";s:32:"9c5c02687cf72c4506f1fd8e92f805ce";s:7:""73330"";s:32:"d88cf5c759f21ec47cf181ca34b705d4";s:12:""bromeilles"";s:32:"e84316ffe0962f56ba34b0d36bbe5d67";s:7:""45056"";s:32:"52eda2273baae49be9a3ecac6bebd933";s:13:""chivres-val"";s:32:"1502a89602592397aa5c4e0a1b8bf765";s:7:""02190"";s:32:"feb189f21b3c1a6dc5215f4b3c2ab0ef";s:11:""st-bonnot"";s:32:"6748fbaebc821f6df11131530e231cfa";s:7:""58234"";s:32:"7490d0845137623894c52de08763256b";s:16:""bray-sur-somme"";s:32:"7e2c95bafeba1f9e2f5708d1c1ccf5f4";s:7:""80136"";s:32:"68df75b5638bb641c6dbbe56b5146c33";s:17:""granges-sur-lot"";s:32:"8abdb603bbd2d7b7c4e61b9df8b68858";s:7:""47111"";s:32:"f396a3e76bc51a8c38cf1f79bed6d840";s:11:""volesvres"";s:32:"2f4f5688b3a3f834ae923fa206aba4b9";s:7:""71590"";s:32:"d99ea7b997b08760460f7efd135e0a79";s:8:""glenic"";s:32:"6f2b40766a06befc12be2c0f5c63fe10";s:7:""23092"";s:32:"958af31aae29937a50ceabb6e70e0e20";s:14:""beauchene-61"";s:32:"7abec4dca4e7348913f984bde344d34c";s:7:""61031"";s:32:"a25d525ac2b2ac584983e814fc81be74";s:11:""montmorot"";s:32:"520738ed29bd215dec87657d022fe1b6";s:7:""39362"";s:32:"66102f3b9466f13d911d369c396c7833";s:15:""champagnat-23"";s:32:"e5859bbb5d69a8f64fb933c88a9c4a22";s:7:""23048"";s:32:"8455a60d00549fa22b7988a6ab428979";s:8:""ars-23"";s:32:"9f30301e9eef56fb25fdeaaac60e953a";s:7:""23007"";s:32:"d9bc2db7f7e24be5843a78b113cb467e";s:8:""rix-39"";s:32:"f34d67f7968f67abab204d7a5a8e3305";s:7:""39461"";s:32:"0ca74661142e45e9dd4c1f3440a44286";s:12:""villard-23"";s:32:"c63cf9b1084e7a7b74065161424715d0";s:7:""23263"";s:32:"af30f0097af289a9ac121bb6c2cb2eb9";s:8:""noards"";s:32:"aa7b330e39817e9824bf52354403c4a8";s:7:""27434"";s:32:"fd2aaf4a1c1b2c2e34352b820907c229";s:8:""pagnoz"";s:32:"8c73863c7b30bdfcc6c1de5a4988e665";s:7:""39403"";s:32:"576278bc3be6f3ef163c381d524268aa";s:13:""port-lesney"";s:32:"b60f0a96032a45837e3fdcb0d476d8df";s:7:""39439"";s:32:"fa244f371a59d6a0fb3d1719e6839512";s:22:""st-priest-la-feuille"";s:32:"84e6e7b751751ec92fcf1c818ca28453";s:7:""23235"";s:32:"d4f9c197a55d2481b4c74b5bbd45a657";s:13:""balme-d-epy"";s:32:"bc3da542e0fd1f99ec4e94abc43fef88";s:7:""39036"";s:32:"ebd9e8f6d5d6087aba3cd294d9ddf06e";s:22:""st-agnant-pres-crocq"";s:32:"ebcb3d136ce109aad3d470ac24da3665";s:7:""23178"";s:32:"5e384c2939d9ec1fd29f4679b3ff3679";s:9:""moissey"";s:32:"798a7a9704eeb4b67c5540a9412b41cb";s:7:""39335"";s:32:"095f5ab880af476d7a35372d4a9a5320";s:9:""dournon"";s:32:"1467a97cc7ec362077c8e6865f9ba55a";s:7:""39202"";s:32:"7cb4e25f5e41f7187aa6c1c8781b51b2";s:9:""lucarre"";s:32:"850e96b6bdcb2ce9bc029f7742f0c1fd";s:7:""64357"";s:32:"2e2caa260fc067b33d7cbdc7bc87e97f";s:12:""etrepigney"";s:32:"db64ed56e6be0fe487dad8254827fc11";s:7:""39218"";s:32:"d1aa7090b30a1d930e8775b51ced26c9";s:24:""st-pardoux-morterolles"";s:32:"eaf05194ac672e012ca62690a8972c06";s:7:""23227"";s:32:"23e6a576c1edf2cee7b0797d6201b363";s:14:""mignovillard"";s:32:"247a006b4bd76c7826703b9ddf0321a3";s:7:""39331"";s:32:"83f3ab09e3c8eafeee4fe523fd816f68";s:21:""st-pierre-cherignat"";s:32:"28f309e169c2f022d913df807c965f05";s:7:""23230"";s:32:"5bef23e36eed8af4821886112e608bef";s:19:""st-avit-de-tardes"";s:32:"fb7307cc6c2ee6b0c7e4ee58bfca7ad2";s:7:""23182"";s:32:"e75193f4011a03024761c0fa9f74e57a";s:13:""st-goussaud"";s:32:"e842f4b983252d4f446549263e5a4ae9";s:7:""23200"";s:32:"c2049c345ffe950709e6992cb0e4c31d";s:13:""montboucher"";s:32:"70ebe062859867f5b9310b70c1665def";s:7:""23133"";s:32:"d667674f8ceef68784c3a32faa0a45da";s:10:""paimpont"";s:32:"58828a2a0d998e232b94fb6a92d2b09b";s:7:""35211"";s:32:"eda695e4500ab5af3423a1044bf9a0d4";s:10:""chauchet"";s:32:"07594e9ce759f30d962d3360f8d9ab8e";s:7:""23058"";s:32:"5d67937b9bea7f1335a9e7363ca13513";s:8:""amange"";s:32:"882fed29d771e26b04cf92bf043b6ff5";s:7:""39008"";s:32:"f16e6bf9403728fa88e1bbef1d03c0ac";s:8:""gueret"";s:32:"c61d6156fd21c8e74c94807fbd39bdde";s:7:""23096"";s:32:"63d05609c712ccf9d2da3b61d277a507";s:12:""bourganeuf"";s:32:"9598dc9f8e6b5e218b25e1c1cdd737fa";s:7:""23030"";s:32:"ffb83b1aa2e75ab673304e8b98b168c7";s:11:""chene-sec"";s:32:"e9708d8cc743dccd8569ed18e45ed020";s:7:""39140"";s:32:"c6e377cff2cd2b91c68e3ee4ee8e78f0";s:19:""st-prix-les-arnay"";s:32:"ef6fa9865d033ac81ab8f0650f45dafd";s:7:""21567"";s:32:"5077ae2ed9a2515018a6f4304e7f4100";s:13:""crecy-couve"";s:32:"4ea90d902ed5423967a07692ba91d4be";s:7:""28117"";s:32:"b1d45b30f255c5090fc2cf2e8e60bbce";s:16:""mers-les-bains"";s:32:"597c6e9f49f97f02c1c1dacc064b8b42";s:7:""80533"";s:32:"97777108874c4dd5fb09015cbe6a6215";s:7:""harly"";s:32:"7f397226b252753d134b7696ec0ed7bb";s:7:""02371"";s:32:"2daa5fbc5a7aa94ae7c55385a86b12b6";s:8:""caudan"";s:32:"79193a47855f08e70c6f2b2168192e9f";s:8:""winkel"";s:32:"c9674c2a1408857f706a3075768eb04d";s:7:""68373"";s:32:"9cc7745c8ed313bbd151bee4b68eeb05";s:15:""ligny-thilloy"";s:32:"f695f178854f392dea3ff0f5ede196dc";s:7:""62515"";s:32:"24449d048c21e2a834d4987cdd17a760";s:11:""reboursin"";s:32:"26e19aeba4377d8c5c079a213d90c425";s:7:""36170"";s:32:"4f169545fa231ba66f6fb58e913703ea";s:10:""mallerey"";s:32:"68fc2aa98ea93ac1cf8918f7fe381556";s:7:""39309"";s:32:"42f8189fa6d81143bdfa6d6340ecf492";s:11:""charme-16"";s:32:"8b90ae6825d2d32cebdbf7adde9caefa";s:7:""16083"";s:32:"9a383032260fb5440eb70cc92fb938dd";s:14:""condamine-39"";s:32:"f0cc94aecdeeaff44fa23694ac5e2075";s:7:""39162"";s:32:"35df049096084d35a38025c804a8e694";s:10:""saligney"";s:32:"ab973e17b689906bcf8f4d237702783f";s:7:""39499"";s:32:"dfa9ac1204c18fea14f95ee350c7d55c";s:12:""charron-23"";s:32:"3abeca19514fc5effecb74fb33f004b9";s:7:""23054"";s:32:"316ac236087347ecf7424ca370f7590d";s:8:""ougney"";s:32:"74a3cc2b5f0b96df17a306b34eb13f9b";s:7:""39398"";s:32:"262ebc5db9d99b871fb559ad7569abf1";s:21:""baume-les-messieurs"";s:32:"6d0e05b706194c6f7b055974b22020a1";s:7:""39041"";s:32:"6540fa7662dee335e8d7ae41bc7c4043";s:7:""ferte"";s:32:"87e734922231c38676d809a2f2dcc146";s:7:""39223"";s:32:"6cac00c2cf552f801cb4cc528fbadee8";s:11:""chaussade"";s:32:"1f23e30dbc2ff600d7a4bb260a142721";s:7:""23059"";s:32:"f7bcf93fd21526f6d1d80a0418f760bd";s:11:""st-moreil"";s:32:"08f8ae53c88a53028306c488ab030704";s:7:""23223"";s:32:"0e0323cc69707183b708115497ff9d58";s:9:""faviere"";s:32:"93bb13528ba781d57209b56a772b8cf4";s:7:""39221"";s:32:"eb404a50992aff4367a04b126f56616e";s:8:""cajarc"";s:32:"5166aef1a1acd350026beb70e2c39c98";s:7:""46045"";s:32:"296c53de44024de152346e19adb09c1d";s:23:""montaigut-le-blanc-23"";s:32:"ef1fcf49c25e13dacae9c1d43fdf0b6e";s:7:""23132"";s:32:"9245ae4404720835733ab92246fdc7e8";s:8:""bornay"";s:32:"3662588e061aa9bd994c30ae9655afd2";s:7:""39066"";s:32:"0998cb47503d4c6ebd1aea4b29e443e8";s:14:""chatelard-23"";s:32:"992bcc0f7eeea13e1c09fee89d062128";s:7:""23055"";s:32:"f3eebe03a4b3d26c6ba59d13df156bbf";s:15:""foucherans-39"";s:32:"c11f86876ebf6044ab216ec2e51bd7b1";s:7:""39233"";s:32:"26a301bc3c7cf131f8d15e93b62d7a46";s:10:""lamballe"";s:32:"fe8857060c652867a30ea6ddf9a5a86c";s:7:""22093"";s:32:"88b0529b3c952f4c6ecae10c84ad22a4";s:23:""st-leger-le-gueretois"";s:32:"30c48bbf2379ec842e878b91c16efb6f";s:7:""23208"";s:32:"244ac170686a892fc8f221fd31eb06eb";s:15:""puy-malsignat"";s:32:"84bd9873ef38a76eb027387809dbca7b";s:7:""23159"";}s:6:"fields";a:175:{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:"892a66a60371a0078a4b7d8dc33a7c62";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((42.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8*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:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}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:"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:"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:"2d8a596c8be7b26cc165f1d38c289902";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((46.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e9e00fd587c6ddfc4f4401de37ede83c";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((46.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.75*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:"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:"313ab1516ac711ed64882ee4bbc2a6cf";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b4601b94504215c41d165c2ce7011f05";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.8131*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8131*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ca3293b8f800c32921827c2153fc8f97";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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5667*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:"cf0e25f37ed819130a2c7a2010d197ff";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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cc51aceceb004ffabcb9b2ddfcb3bcfb";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"04abc172df57aa5641cdf50312a6dd4c";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbb4049ff44acfac692ab12128a8ad9c";a:2:{i:0;s:71:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*";i:1;s:18:"`Departement`.`id`";}s:32:"1ccd1ac74a72bcfc13ab90654506c446";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}s:32:"f27357ca96e303be445a904287ac18a5";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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"d36b3141afe79448007d315e81d657b6";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((49.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4833*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:"eb2e22ec606e882c822a2c62ad2fe95f";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.15*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:"d33a3673b59d912919cad747c8deb547";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((45.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2bf70ad614f632b383a83fa5d16f525d";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((46.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3*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:"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:"2562d912a534d63a495fd092d0b1e6da";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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c33088c8637da6a8d2519d4c48eef2df";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((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:"3a21dfa724ef709e766af50539ae05c7";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5167*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:"4deee186ce161fb195c1f6547a45229b";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3167*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:"1862ca63668dd7e2787eda27d21f4432";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"993dfa64269a3ad9ea43d9144ee606cb";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((45.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*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:"46ad8b6393cf93cf5961b50c48867a57";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((46.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d3f7eae62414ae2041c7a86aa242b7ec";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((47.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1333*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:"30430e069e9960fb9242c0f36fb2a052";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eff5e219df5caa201a2bed3ed3a524a3";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*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:"8c26e854800909682496f8cb22a266cc";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((46.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3*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:"e41e3f4dc98cdf39a663d78e4bd920aa";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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5801f9b352c86b728108e3986ee605c6";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((47.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a7b7b7e91aee3f0a7fd603b6e60b1eed";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6286e1bfa445439cb4882c52e90b82a9";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((46.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9*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:"5840a3e51db422ae07544196ee91d39a";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6c9caa54868c89da22b216daf80203ff";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7667*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:"82b305b7d0e05be323c58de8272c76e2";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2c08094a025b189068192249d17a3b3a";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6333*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:"01704a4081b7636967ad8ed29d3a0afb";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((43.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.35*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:"196cdcce5e406b5387ddf80cad69cf9b";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c97518e2c6d443affd799a27c42916ba";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((50.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1f87c4c6678790fa1cdb729450646587";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((45.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*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:"c9b1cfa709227c36a74c6ccf2dcbf452";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((47.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9333*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:"e5a03e26dfb0e11da741708b9ac3e01a";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e04fa0f65a94302c91a6e9ad9973ed53";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4be5f774422e52271aba3788c72df40f";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a50a59194f0c4f7daecfcc3c4c2e48d1";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:191:"(((acos(sin((47.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4d6b7e97a0229feddcd5e22261198183";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d69ac25f5a7284570d1669fb574848ae";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((45.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3f4059ed8f8306179e81b71bf094dc68";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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5833*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:"40f1bab74ab856e0fa8ff56a2e0bff1b";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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7333*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:"21ebf5d30880e604fe18d2af1b536676";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((45.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"da70c0cc58bd3977ea3ee9c4d7ef4991";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((43.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*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:"dd56511da40d30a1b69c454a8360ac93";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((47.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa536428a1472b36c01eaabd8ad04a42";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3def9fa0aae294be178f19e6498e67e";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(((1.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e9247fabc7941d6850262193cb6087a0";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9a51835e9f2a39b734d5b80616d87224";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((46.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7514a4d6f151649148214b62dc3e24ea";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((46.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4*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:"5ac49e43a69391a052aef9a9319327b7";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b9cf3defe68cdad70c3dc78ea863ba30";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4cc7274f322391ccf1fc952e7f633d3f";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((46.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8feb0eebb7e4c67b13a13adec86b674a";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(((1.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3ed28449ae951b394315ce4a0fd947b8";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((47.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d357ef841f3bb31dde77c0fde943c36e";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:187:"(((acos(sin((46.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2*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:"cfaead4fc96d87b106209fc8b6a00263";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3667*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:"296949e438f6692d9db310a6846d1812";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((46.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.05*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:"d4bc9bbaecf8d87639a81827d6fb1ccf";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"697fe6947e3f84f6724ebdc4b1d838de";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((46.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.45*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:"d5508d8c70407afc01a0b0139e896ab2";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((46.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7*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:"fbcc41d140a745c1b756e798effd1ba9";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"36c4bd6176a2108f93dbdedaec0bcba3";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((46.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6*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:"7c59ecbe27783e937e3b37edc84d2bb6";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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*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:"eaa7f98eeb9733a3c0044e289e6cc46b";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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d0b8d3cec4a6782758364e60a15dc6b4";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((45.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"32c3194a8f464f8063b816c7bf7aeb6d";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9167*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:"a8c9bd70695006b6f3949eb41d9bd7c7";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.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"54a4b49588d665f3d3f4ac5289d20c84";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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7d39cd57e135a42268851985b2e42804";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6833*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:"e92b57058710099716624662645f79b6";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((45.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"12cced9ec0a3cd19470bc75eed41ae62";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((49.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*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:"0cff438a590c687d73426db97c81ffcb";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2333*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:"c2182965fc97eae0a9dc095470789b84";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((47.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7ccd11786efa1283dd130f412d60aa8";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*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:"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:"850429778a8bba093a027043dc7d94fc";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((45.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*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:"712cafbbe4193f1c54720bd62a4d50f9";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((46.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4464e375d0a6c4e5bdcd2132d4a5e74c";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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7333*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:"9b02c2e55827e607f26a9d1844769a67";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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7*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:"dc8786193a55841e58e1bb2b109911a5";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a73c31ea6ad14d1e584fc740de500b66";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((46.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ecd11127c7ceb363fdd3497a103d01d8";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"782f4b1e1b0cd78a14529873ed4fc66f";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3667*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:"e17d5a2f68f9ff85d51c79c0982e5e09";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((48.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5*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:"bc09ff0aa0c363d87eae7194c51f0a9d";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((42.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f7856931028d8b2531083802fb8e001c";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((42.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8833*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:"b697882d84a36bc015b8204292141a59";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5167*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:"ec18f57101c8da2792745105c1fd7b8e";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((47.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4333*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:"98124c564f9b4d8404f423690f67ffbb";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(((1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d359b7fcf6e1afeedd0f87ddb2a682a9";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"880a3f390f0ac8369365dffdaa292156";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((47.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0333*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:"1fd90cd177125487299ffe80a7d1742a";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((45.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cfb071808f1cd52bfd8fbcbf542ef4e0";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7fab4f1005a1aae69e89cbd6a18d3ed2";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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"73fa9b76192effb0f11b5672900c77d2";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((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fcf0cb85a4269499d642f522dfc784ce";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9333*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:"9959825717f5b528712b7a19eca050a5";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3833*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:"29a05c95ff480a1b2fe6122db9055e39";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8cc58b3a3fec420fc6619a2fca1aeeb2";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2991232d34b844ae9e22364d2bf5959c";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((48.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9e98048bc7b7655843bbfb22c77b29b4";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f36326a83da00061903426db7e5216e3";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"49532017e07574acc9ba6795fa383a78";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*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d21f0804256e40c32837e9d27e573312";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5637e5d62231df97b114bcd8b757ce04";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bab7d60aaaf8cc88cad65a9e013b0e90";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2167*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:"7d448c1268a3dd4a59564637ec278e88";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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9667*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:"60461abc324656b346ad26eb071832d5";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((47*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47*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:"de8488401d60b6ce316c2296dbccfe0f";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((46.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2*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:"860aa61190e513fe345b4c34e9cec517";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3054c579b4634deac8bbc6ff0aca068f";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((45.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0a850f486aea9507e1f25632119880a6";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((47.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d7447760d3bcebe8f2694f3ad47dd7d3";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4e7d0bc6916d1defc759a2d52aab8912";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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7663a0f87f767d7fde62fa21cc7abb4b";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((47.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0f7a17b8f1fe3eafacce78772209cd05";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((45.8975*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8975*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.82111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0ddba50a12a650b19081a44f50771c8b";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((46.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"453b8cb4e94d4c7d3cdd3efe2af254a8";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((45.9728*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9728*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.61417- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9304349cc7a1cbf719746587919d3e28";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((45.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"11e6bce80c1756ac9b091cd912582c9f";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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*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:"a03315d0b3a279f294ce6b5bfc558a4d";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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"815244858893bbe05ef04f172c60d064";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0167*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:"de90ea19b2cd799625df99d4e9977728";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.1075*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1075*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33361- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c3ef827e666387925a43661dca84f0e3";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((47.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.15*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:"3d7b9b2fc8e0aeae429b8280be3787e0";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2b8f0ea89dd1fce74cd03010659775a0";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((45.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1f934aff4a2fb981645351085d15b897";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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.85*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:"77f878dbc812d3c72fb796db717cfffb";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((47.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5b0d091275c92f5e365f951370d09249";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e43c9ff2114c6defe45f0aa7ecde56d3";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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"06f1596f5cfda6f3cdd0131b5bd30fd7";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(((3.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fcf413e573f261a8d754cf75ddd22716";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:200:"(((acos(sin((47.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"653ad9d0e1e3bc989dc5177061d00737";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((47.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4c89f3ef34bde7b6e33fe092dbedddf3";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d3a9c7007365342f1339cda414f4c375";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((47.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9da57eb12befb59165fa57e6e4167f04";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2a4d6af905aefd2e88de974d2aa26119";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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*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:"8a9235b7284e80d9107f878dd1d07824";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.65*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:"e34760725aae2503c99f3d0cc26e5b97";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((47.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"73845a4938faab38a0715cde8428913c";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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"147dfe08c5a51fd671b94b15496e282b";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((47.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"93bbc921c14d1f6980a72fb4af85e599";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"92b679e80915bb2185a3ea045ddd4a77";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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aadafad532b301f9bd294383875122be";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((45.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"549a4c38f4b3d3b658ba31cfd577800c";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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"12dae09025e4b3360078d5c72f7b23de";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.7528*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7528*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.03306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9bf72c440ed4616450f07ea7206fce1c";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dfae86ab30b0ae8c96f90fdc436b54c3";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"85bd51b8eeae184fe8497e484afe9297";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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6167*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:"2edab681ec477afdb8a0f7f0d4801d7a";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((45.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c0b3338fa9d799bec0612ed4ab96a1d2";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5c34ff8b6994edd96149d5c254cf45ec";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.51667- Ville.lng)*pi()/'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::toiture() - APP/Controller/VillesController.php, line 129 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 Contextsetcookie($name, $c['value'], $c['expire'], $c['path'],$c['domain'], $c['secure'], $c['httpOnly']$c = array( 'name' => 'CakeCookie[autologin]', 'value' => '', 'expire' => (int) 1762105355, '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
Pour le bon entretien de votre maison, l'entretien de votre couverture est essentiel. Pour un nettoyage de la toiture à Ruffey-sur-Seille en Jura (39) comprenant démoussage et traitement hydrofuge, nous listons actuellement plusieurs entreprises dont voici le répertoire ci-dessous pour le secteur Ruffey-sur-Seille :
Le climat tempéré favorise la croissance des mousses, des algues et des lichens sur les toitures. Ces organismes végétaux peuvent causer des dommages structurels et esthétiques à votre toit. Le démoussage est le processus d'élimination de ces envahisseurs. À l'aide de techniques spécialisées, les professionnels expérimentés du secteur Ruffey-sur-Seille enlèvent en douceur ces mousses, garantissant ainsi la protection de votre toiture contre leur retour.
À Ruffey-sur-Seille ou Pierre-de-Bresse, Mervans, Chaussin, Louhans, ... dans le 39 plus globalement (Jura), l'humidité est l'un des principaux ennemis de votre toiture. Les infiltrations d'eau peuvent causer des dommages coûteux et accélérer le processus de détérioration. C'est là qu'intervient le traitement hydrofuge. En appliquant un revêtement hydrofuge de qualité sur votre toiture, nous créons une barrière protectrice qui empêche l'eau de pénétrer. Cela non seulement préserve l'intégrité structurelle de votre toit mais aussi son apparence, vous offrant une tranquillité d'esprit même lors des pluies les plus torrentielles.
Pour vous accompagner dans la rénovation de votre maison à Ruffey-sur-Seille, nous avons listé les entreprises du bâtiment.
Selon la rénovation envisagée, une déclaration préalable de travaux doit être réalisée auprès de la mairie de Ruffey-sur-Seille 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 - Ruffey-sur-Seille
120 rue du Général-Lecourbe 39140 Ruffey-sur-Seille
03 84 85 03 35
Selon vos revenus et les travaux envisagés dans votre logement, l'ANAH Jura (39) peut vous venir en aide.
