Notice (8): unserialize(): Error at offset 114536 of 114677 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) 1756224563 $cachetime = (int) 1756224573 $data = 'a:3:{i:0;b:0;s:4:"name";a:723:{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:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";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:"3fb5eafaa8f0dbd31e85da4c6e2fc27a";s:13:""chevanceaux"";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:"1f8a834212f7d9cea8ae7d37e2a87ab0";s:7:""17104"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"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:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"96ec2c347d59c0391308e7bfcf799c46";s:22:""champagnac-de-belair"";s:32:"bea7217984cbd0348b60d2b9cc4d8b90";s:7:""24096"";s:32:"0fe871c7cc44875c70df11cfaae96589";s:10:""oriolles"";s:32:"14d467cbf3ce732e26ff6ee74e1051e3";s:7:""16251"";s:32:"98fdfa4d37da3c7971a2b3cc49cfc848";s:20:""condat-sur-trincou"";s:32:"ddd7a04a8b991fd061cdbd9478e712d4";s:7:""24129"";s:32:"6fcd24fd4e1059173482fa484d30617d";s:25:""eyzies-de-tayac-sireuil"";s:32:"69878f31873780be9f025ead20124475";s:7:""24172"";s:32:"3b20a5f1eee68923e3d437e9b4a7c495";s:20:""neuvicq-le-chateau"";s:32:"78f5f76a37b4cec74caaf847caf2b33c";s:7:""17261"";s:32:"67b8964b87b638791f0d86cf993f5f9f";s:24:""st-antoine-d-auberoche"";s:32:"a65b00648ce685918ea1c4f54c8cfb75";s:7:""24369"";s:32:"6ca2fd74a62a921614b665d6fb300442";s:13:""monplaisant"";s:32:"70dc65877d5645874bbe4fdc72481507";s:7:""24293"";s:32:"6b134dd4ea2644f0da19e149b82069df";s:13:""macqueville"";s:32:"fa220b0e94c668e9cd0dfe11d95e196e";s:7:""17217"";s:32:"9df5e163e9413fded02ea2fe7c2088ab";s:20:""boresse-et-martron"";s:32:"d6378e776a7329def35621d194860d2c";s:7:""17054"";s:32:"67858454070923b806dd94d43471c559";s:18:""chalon-sur-saone"";s:32:"982751f4c3c27157b05b2d5e9218696e";s:7:""71076"";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:"255cf3b8ba62967445556031f88649ea";s:24:""st-palais-de-negrignac"";s:32:"5218ed83bcc0d0aeae23f01d8535b6ce";s:7:""17378"";s:32:"9ca77c9af2335f9e800f12b8a58378a1";s:13:""guizengeard"";s:32:"fc784b13c3907641d1fa9cb9c2bc7fc6";s:7:""16161"";s:32:"42139a5be25c19bc2add7bebff65f56c";s:10:""chatenet"";s:32:"86354338b5b391f71406f87b986305d5";s:7:""17095"";s:32:"6dd62cc49f4045dceaef0a4b35e33d5c";s:12:""fossemagne"";s:32:"9478865305230a6b3049d8e66569d2f6";s:7:""24188"";s:32:"5567889538424dfa55087f72e034c0ed";s:12:""courbillac"";s:32:"deab6255e33e9b813cada897fd5b02f7";s:7:""16109"";s:32:"e671b583c45063c35766091e5caa615e";s:10:""tremolat"";s:32:"644de9aef0b8948c344564112edf1f26";s:7:""24558"";s:32:"e247eae43a65a4bcf785c904177d793d";s:23:""montagnac-d-auberoche"";s:32:"df30a7955f1e4089c1aabb0332d7c36b";s:7:""24284"";s:32:"2567d2f081a731f3203967caad238f2e";s:10:""limeyrat"";s:32:"35e1a831dea4d81987c8fd68ca201590";s:7:""24241"";s:32:"8767c97babefaf9a877020cdd7b43197";s:20:""st-amand-de-belves"";s:32:"9be9090aa36f9c6e5d3ac615d035f0c6";s:7:""24363"";s:32:"39149503b2e034ec2c9dfad9d6355dde";s:18:""boiry-notre-dame"";s:32:"60bbf07e17aad6a6c23c3e26c7a9c927";s:7:""62145"";s:32:"0ccc803e9a681bd5d8d5aac7b0182887";s:9:""sagelat"";s:32:"b3d07f22f4b59b9aad8571ac335bdc6a";s:7:""24360"";s:32:"f16565b9af0ad297156e67aa85911fc2";s:19:""montlieu-la-garde"";s:32:"08c5eea6df83a3e8d72b53f8d4e95101";s:7:""17243"";s:32:"30f0588b3942ed76ebd34af55eac7358";s:23:""st-pardoux-et-vielvic"";s:32:"41e900e2e634b28949ceab65513584e6";s:7:""24478"";s:32:"1d7e737624ee972cf64e03ff607729a1";s:10:""douville"";s:32:"e528c8da73bd8e429f9ed8562182901b";s:7:""24155"";s:32:"72d3b20de71be223b3bbc129e21cde24";s:9:""sartene"";s:32:"f5ed72070f4074a94cc68cbc2db00c36";s:7:""2A272"";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:"0d333600b64af8cb67fb2b5886169af0";s:10:""gardonne"";s:32:"623f5446b98d5f17fbff2571e03f1e9d";s:7:""24194"";s:32:"cb91afc2c39e632f99cd97670fe7dad4";s:10:""journiac"";s:32:"11c405f154e78524862bede759927c36";s:7:""24217"";s:32:"c5f12cda8afc3544437876fbb0db072c";s:10:""gabillou"";s:32:"6cb509d6219d8f47fd8bed4454adbcb3";s:7:""24192"";s:32:"d97b604e3a1b9829c46496231258d61e";s:19:""ste-foy-de-belves"";s:32:"02fe9756c06efebfde3731ce0241abb8";s:7:""24406"";s:32:"a19f8de4c0e9038acaee170835aa9b44";s:12:""chantillac"";s:32:"15d7fc3ba9626cac9f68593cb2118384";s:7:""16079"";s:32:"1dc8af11f3dfcb0d405624547f6a51fb";s:8:""jussas"";s:32:"55d859effefa259c5bc77bc9b621b257";s:7:""17199"";s:32:"b5da4ece9024d504b6704c5579619ca2";s:8:""leches"";s:32:"d911b6550de177b46699f316bb1a0e27";s:7:""24234"";s:32:"8a0bc9ea73bc98f0893ab3a5b4dec702";s:12:""expiremont"";s:32:"aa3e63e09962bb4fc993cb63c41b4c49";s:7:""17156"";s:32:"3f3ddf913dbd65b4ff97e1fdd3843977";s:10:""mussidan"";s:32:"5111755b45fc31491074407a0d1c7881";s:7:""24299"";s:32:"ae36a8c2b85e2df3b557aad4c6a71580";s:8:""vigean"";s:32:"ce3a8a8483e93c679529f0e4528a7ee0";s:7:""15261"";s:32:"6cf69e102aad0edd4159253c9d92849e";s:13:""malataverne"";s:32:"cb612a291413690978c67756559ff018";s:7:""26169"";s:32:"ce5dff90fa1063e39931e9406bdef1fc";s:8:""pleaux"";s:32:"857ae2298b4173f6b0f6dff90487fabe";s:7:""15153"";s:32:"7ef983ce35d8c7b936cadaac0a3ee3ea";s:8:""paunat"";s:32:"ff2fe546f6e103f189957690a9c7c5f3";s:7:""24318"";s:32:"93b5d74eb49aa633089edb58340078b1";s:10:""pontours"";s:32:"602ab6e4496f258a239a73a2fd851249";s:7:""24334"";s:32:"b3909b4d3e24eef5ce15bd995b644b65";s:19:""ste-eulalie-d-ans"";s:32:"63d6fe57dc2a5cdec28b04face565d02";s:7:""24401"";s:32:"ea5e00ed73b8d8bf113f41c4af421f5a";s:22:""st-laurent-la-vallee"";s:32:"1d10879e7f7abd5296a11e22b9203692";s:7:""24438"";s:32:"97dfb7451f017603799cdd457e40a720";s:18:""salles-de-belves"";s:32:"0d1653d80f5c825d76c60b18ac791683";s:7:""24517"";s:32:"883de9c7c1299da322ef084511af107d";s:10:""sigoules"";s:32:"2ad16a66a41a28d6810c4b951ce71be2";s:7:""24534"";s:32:"924eaa5d32aa0fafcd4e25bb70e8acbf";s:26:""st-laurent-des-combes-33"";s:32:"c79d01904d0560c07e62b4827906a78e";s:7:""33426"";s:32:"6d1ecfb3ec2c4d570e89f6b1224d4e7f";s:10:""soumeras"";s:32:"45ead9bf7cdfc16ca32479f2e09904f7";s:7:""17432"";s:32:"954c9402b621690071625e271faac509";s:7:""pizou"";s:32:"f780bcaa6966130c49d84c988c34296f";s:7:""24329"";s:32:"4840ad2babb66f8ea609b67c8fd2d1b1";s:7:""siecq"";s:32:"1c12932cb5dbae9c0e839de4a301cc8e";s:7:""17427"";s:32:"168cc25bf4bea3d822a4806c609f15ca";s:7:""gioux"";s:32:"298390e7b03aceb1694b6c11e34a2c18";s:7:""23091"";s:32:"2ebdfd3f0e8d453efaad39c092c660ab";s:8:""guimps"";s:32:"b45b35d406cb5f553d0f59de432768c4";s:7:""16160"";s:32:"6cba4ec5360bdb39af546fd36eaa3c4d";s:12:""verfeil-82"";s:32:"0c751adad87b5515016eb8c91d13c82f";s:7:""82191"";s:32:"801c615b8f805f2c417a8ffeb94ba6df";s:19:""prats-du-perigord"";s:32:"e5e88905b7b23d4c57f717c01c037b0e";s:7:""24337"";s:32:"479b1b13e61e83db30bfb53ba2d8aee4";s:25:""st-sulpice-de-faleyrens"";s:32:"60b961498c9f026fc312017f4dea0b80";s:7:""33480"";s:32:"018626196d1ffcb4034464ab5f6c6688";s:19:""st-julien-d-eymet"";s:32:"7b12b970931644594570da9c8287bd77";s:7:""24433"";s:32:"fa476b2b4cc56abf493e657286c74261";s:15:""ste-innocence"";s:32:"0cd4fc7576bddbcdaf46addd32130f55";s:7:""24423"";s:32:"506ce6d4b42ff7bc45e6ffc9a17a7bec";s:8:""mainxe"";s:32:"40b3c70afb7a416b5206904aeec9fddf";s:7:""16202"";s:32:"3cda4b93d0a206f2c917ce3191df2c12";s:13:""mazeyrolles"";s:32:"c40af7badecedbc07a0ea8937a4883fb";s:7:""24263"";s:32:"a7d331ed3355de79ac6401e242b48d58";s:12:""clairavaux"";s:32:"8ed8be7a4b4b44b2fabb54eef02efc9a";s:7:""23063"";s:32:"3d1dd0c9a0b1adb41ca46fd212f79555";s:20:""st-ciers-champagne"";s:32:"5f5c637b9fb88141f54512dc1020a07e";s:7:""17316"";s:32:"c5383844d91478f0952b321824decea8";s:24:""castelnaud-la-chapelle"";s:32:"a4b6e1540fa61c8deb8dc4526d22e2a4";s:7:""24086"";s:32:"06c524210e86014a0640258eb10776c5";s:21:""st-vincent-de-cosse"";s:32:"da068979529f8bdfd7ed0ec0b2d5f750";s:7:""24510"";s:32:"839ae2c8ff73fddcbfb02a0a5a033994";s:26:""villefranche-du-perigord"";s:32:"0ece43beedc1fcfcc8e9d9701644587f";s:7:""24585"";s:32:"55d7ffcafe60db1da43e194253908fe2";s:9:""capdrot"";s:32:"f3090e2264bc26d86a4b09bdfcf02ac3";s:7:""24080"";s:32:"f83814afbc202c6cbd5432fcc550dea8";s:19:""brie-sous-archiac"";s:32:"eeb40f4e5ceabef6959abcc54421c057";s:7:""17066"";s:32:"b138e1c4f1332bdf53732d629ac0ac13";s:16:""cherveix-cubas"";s:32:"594daf02ca947b29a9cd03a9c7066072";s:7:""24120"";s:32:"ab745748c84ff4cdc999592806f546fa";s:9:""auradou"";s:32:"dff42363e21490324b4c77b0c8b39ac2";s:7:""47017"";s:32:"2700807c7b9c4c2812b0969e78eb45aa";s:21:""ste-eulalie-d-eymet"";s:32:"8bded4bd1aaa8113f85eac6d5f1f0143";s:7:""24402"";s:32:"39cb33128e5fb7ac7950381505a0cb05";s:21:""st-cernin-de-l-herm"";s:32:"8f11e35f449b8fe94381c31fba358b63";s:7:""24386"";s:32:"562b79f8457d39c51922056ac6ac534f";s:22:""st-germain-de-vibrac"";s:32:"9110e8c501d77fa6264c483cf17fc085";s:7:""17341"";s:32:"4fc66fd1783578ed4e2b4c618c8045a4";s:19:""beynac-et-cazenac"";s:32:"92145868d0b8d158c36ab3a99f0e8072";s:7:""24040"";s:32:"8db6dfeb688f0231571de56e846111d1";s:7:""roncq"";s:32:"c46e602cab754d0bcf64aea90e235e07";s:11:""pharmacie"";s:32:"5d355d339e1f39e7169f7f7708f85a5d";s:16:""temple-laguyon"";s:32:"b4ad48096dcd117e200827cd4bb370f0";s:7:""24546"";s:32:"d951f73cfc9bb5795c85a746837947a9";s:7:""aynac"";s:32:"24927013c288c35fffc74fa3af6cd259";s:7:""46012"";s:32:"c9fc29ef3167f5fe1b29d8974825df10";s:12:""singleyrac"";s:32:"f1439a2c1db7a3e716e1beed6df3649a";s:7:""24536"";s:32:"b9ddd919c94c97f4c20690cf788211d4";s:10:""fonroque"";s:32:"ab463cd5f860eacc87bc6c8dcdd73e93";s:7:""24186"";s:32:"6ec471059b14b56022ae65b5b53d3bc9";s:12:""rouffignac"";s:32:"8a866d3e415d7899d3ad6de8bdefc2e6";s:7:""17305"";s:32:"1cba5c58965fcaf9d6fdb32c0aeb2131";s:24:""st-romain-de-monpazier"";s:32:"5127a3c6d14fd352d2e8521a8d3f5743";s:7:""24495"";s:32:"7e8bb94a75f33151fed281e0d14f2c90";s:10:""auzielle"";s:32:"cb5f54a2f3a3b6c805dbe92eaac78e16";s:7:""31036"";s:32:"49dffa12ef7abbe9c317b0f0d29e9168";s:27:""blanquefort-sur-briolance"";s:32:"ddb8576177bfd9284e53b664b3b29e53";s:7:""47029"";s:32:"2ec63ac13722b76fba85bece075f1255";s:18:""chapelle-st-jean"";s:32:"1b7ca9bbc4a4126d50b954212cd7cc93";s:7:""24113"";s:32:"cdffe96b360cd5ae9fb82dc2be9e9843";s:21:""st-capraise-d-eymet"";s:32:"df457062a5ac6756e01aeb130ab723d5";s:7:""24383"";s:32:"77c8a883d8bd537ae351610d4e814a55";s:9:""nailhac"";s:32:"4eaa61b4b50358afa1b93b07b40fd19e";s:7:""24302"";s:32:"ff8371aa13cac58380203d86ccfb828c";s:22:""serres-et-montguyard"";s:32:"e8120158e913c7275e94383a53d97731";s:7:""24532"";s:32:"00c057dadda23f13ab6338eeda503546";s:23:""salignac-de-mirambeau"";s:32:"c7d799bc49f7f950df90585bad6f87a3";s:7:""17417"";s:32:"da1469b73d0cafe81550dad1275d2061";s:25:""montferrand-du-perigord"";s:32:"0d0e34e630a79bfa166ab447b72b51d6";s:7:""24290"";s:32:"97d19ed7ce2a9c8abe8d7e75f40b1b3c";s:20:""tugeras-st-maurice"";s:32:"42a859cf54f2890d3da16e507d3276a8";s:7:""17454"";s:32:"b4a89b5674de566c843e6f22da4852c7";s:22:""st-front-sur-lemance"";s:32:"8df6e828d082213c1d1c96c4ec90b2ad";s:7:""47242"";s:32:"286b324220f1cb6cee35d14af9a31262";s:20:""st-martin-le-redon"";s:32:"86e5505b93e5944f527f817a5af3e15d";s:7:""46277"";s:32:"03bd2348b21ffe8b005b390634683116";s:18:""sarlat-la-caneda"";s:32:"559f17f497529f578c697a1d1f8be3de";s:7:""24520"";s:32:"fb20015eb7c23a65c699d51574004a71";s:22:""st-vincent-le-paluel"";s:32:"a46ff93f0dcc65591fee2db7011861fd";s:7:""24512"";s:32:"ddda3c6e7a3755ffb967c2b0a4062765";s:13:""villexavier"";s:32:"cc4669f38e19ba54d5c96fbc10638eae";s:7:""17476"";s:32:"96310bd093055f8aa74353b5c3fd41da";s:16:""montcabrier-46"";s:32:"b2e14101b4f227bfd9f3fd6e153fd4b0";s:7:""46199"";s:32:"4ce4a1521cca714ff7a1e7213154bed5";s:22:""st-aubin-de-cadelech"";s:32:"c4db253008576dcdc0d5ba74f8ed4066";s:7:""24373"";s:32:"c2c0a2eccf1e1c06d9ee92c76582cd86";s:15:""loubes-bernac"";s:32:"dd519808c4126b2c634bc8e86a52a051";s:7:""47151"";s:32:"db4bb6ff89b114964d9fc4ad4ab01d6b";s:17:""st-avit-senieur"";s:32:"b64f2380651e7d5dbdd5f52263cb1473";s:7:""24379"";s:32:"37a7523cdfe128aef00945fec1930fc8";s:21:""fontaines-d-ozillac"";s:32:"3e47f29595c748d7800830302cdeb41d";s:7:""17163"";s:32:"8c5ea1598076a86b7dfe41148dbc6ba5";s:14:""allas-bocage"";s:32:"fa08a51e107f3217963aa259d653d585";s:7:""17005"";s:32:"a1a77879920284d1d9c831e3bb8b40c9";s:13:""labouquerie"";s:32:"b55e67f285c318206125ad1a077ee37e";s:7:""24219"";s:32:"45385f0a24d314e7b113033d4cc2a7ce";s:12:""gourdon-71"";s:32:"4526720a70300e35681134f70243037e";s:7:""71222"";s:32:"7a9afa43a824d3ee162fb57c0a5cfc35";s:15:""ste-nathalene"";s:32:"2f010aa8a4a972daa4bb9aa0e44047ee";s:7:""24471"";s:32:"7e86a9409882efc09f2bde694e661fce";s:14:""condamine-01"";s:32:"2f7507f63585149f90eb080c42061b26";s:7:""01112"";s:32:"06a201328ab3f4921c742f4c61a63b45";s:21:""villeneuve-de-duras"";s:32:"7f240503466286b2fa7d7044df380824";s:7:""47321"";s:32:"9ac0482c1198c19f29060daee033c6aa";s:9:""chaunac"";s:32:"ad2396183299cdd0ac29eb780f16b56d";s:7:""17096"";s:32:"6223b86c34ffc5b0ef7d24918ed202df";s:10:""leoville"";s:32:"f3984d52ddb0d6b9d67d0a8f6795ae93";s:7:""17204"";s:32:"634bb747a148f69bfe2e35b2c47002ee";s:18:""nieul-le-virouil"";s:32:"fda16a8f5fa132e365c0903f37999d5c";s:7:""17263"";s:32:"f74face7977db66feb8f4ae31c1a73ec";s:22:""beaumont-du-perigord"";s:32:"ed86aace30aaefdde4cb09d4434a8a87";s:7:""24028"";s:32:"7ed06d99e62544a3836daeeb48281870";s:21:""st-julien-de-lampon"";s:32:"651333d6d433629fd625f1fa63c107d9";s:7:""24432"";s:32:"efdc947f61af7a60b7157aa86dad73a1";s:22:""marcillac-st-quentin"";s:32:"bac0543f34d912e05431a6942a9765c7";s:7:""24252"";s:32:"64a387fcd4015fb70e9530da0ac377fb";s:23:""st-crepin-et-carlucet"";s:32:"f242354bf0fe0f233a46705bc0e74a66";s:7:""24392"";s:32:"b64283ca925b5c9eac37c51f7364c0c8";s:9:""soubran"";s:32:"628df5e5553082cee31503e6b89fe403";s:7:""17430"";s:32:"c009d68fe86d96b688d12432b65e9593";s:18:""nojals-et-clotte"";s:32:"16cf77541446871fc218362ce46be34c";s:7:""24310"";s:32:"2559dc81cf778ee4d8ba9cda504ac9ce";s:19:""savignac-de-duras"";s:32:"9661610f760c4e0a27d190817023c3d6";s:7:""47294"";s:32:"dd53fae41e3e894c6d8467fdf1d10ca8";s:19:""lacapelle-cabanac"";s:32:"d24f4bd29f602adb9f2c141f2bc2a1d8";s:7:""46142"";s:32:"f58e5c3c0bd6cd28403bb56ca9e7c4ca";s:12:""courpignac"";s:32:"903148b034bc733938f51aefb53d912f";s:7:""17129"";s:32:"e98390f31e03ac9e907ae30feeeb76a0";s:22:"`EtablissementKeyword`";s:32:"f05318129420810d2df6af6f21777fb9";s:41:"`EtablissementKeyword`.`etablissement_id`";s:32:"08bee90596866040d3863d3b099b92dd";s:24:"`etablissement_keywords`";s:32:"6c66eb299f72f8ea6373806e1792c9db";s:9:"`Keyword`";s:32:"bcbd8f2dbc9172e3a3142affb2892e5f";s:14:"`Keyword`.`id`";s:32:"093651e381ef81925313bc1034b19f99";s:35:"`EtablissementKeyword`.`keyword_id`";s:32:"a88baf43cd357230f8c9342b8d8c1fce";s:10:"`keywords`";s:32:"a82fe8f431f55ca3e5c6eeb1425d6fa5";s:16:"`Keyword`.`slug`";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"cc7a4a34d97ffbb85978393c1dc3d808";s:27:"`EtablissementKeyword`.`id`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"0a1510d0dffae11b88c8130de3cc3c6a";s:14:"`Pub`.`format`";s:32:"cc6101a4c51d389cc83aaaa353064e30";s:24:"`Pub`.`etablissement_id`";s:32:"61eedb5524a37da074a515d3499b0fc1";s:16:"`Pub`.`ville_id`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";s:32:"8ecaaa87ac95fb6026267ddc489d4e00";s:10:"`Pub`.`id`";s:32:"03bcab00ea59985094d3823102128dc9";s:13:"`Pub`.`title`";s:32:"19ae68421a7af6fd53280292661686a5";s:12:"`Pub`.`link`";s:32:"adf6b0dc760d6ba40793e6ccab265414";s:11:"`Pub`.`lat`";s:32:"3911c9de594ddd79639957c57fa6f86c";s:15:"`Pub`.`adresse`";s:32:"013acd686b9d6a62ae480ddd5854054a";s:11:"`Pub`.`lng`";s:32:"9a9117f5211facf70dbcba9197db0119";s:11:"`Pub`.`img`";s:32:"a0ec82037a4d9290d4b4962c6dd972ca";s:14:"`Pub`.`height`";s:32:"c584a2fb465c8e8da20fba3f63f5f9f5";s:12:"`Pub`.`view`";s:32:"40c6caef6b63d5cc208b1f45871b776a";s:16:"`Pub`.`view_max`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";s:32:"46f29ac25e7661e43671699137a77bac";s:13:""valleraugue"";s:32:"96e4181da8d2a4ad7d484a2564592262";s:26:""st-sigismond-de-clermont"";s:32:"69666fc6d0470a4d6774a284e4f04650";s:7:""17402"";s:32:"d1270a59cbf8c9a04a910aecc284bc71";s:13:""guitinieres"";s:32:"82d3c52e54ad58717ce9557fe7f44808";s:7:""17187"";s:32:"7f4a87346a783008828e3344626d5da7";s:19:""st-dizant-du-bois"";s:32:"c53398c4fdb0b3241def3fe85ba2e91d";s:7:""17324"";s:32:"4a19e889863c2a1439a23b1ab9b77d7f";s:12:""bourniquel"";s:32:"3ae64f023f61afe2929e4a3ec120ca49";s:7:""24060"";s:32:"d69dd78c263ef1811714a3be91216198";s:19:""chapelle-aubareil"";s:32:"12bd246106e4b17f3471f1141f572919";s:7:""24106"";s:32:"a4f199cb913935a16ee3fdc42be7e207";s:9:""tamnies"";s:32:"c83ac9ec0656b97a9b891ea1300baf3e";s:7:""24544"";s:32:"f4aab8b380b7aba4d1d54684b9009d74";s:10:""lavalade"";s:32:"5112f50209ba9c54e87a45ac5f857baf";s:7:""24231"";s:32:"eeb7354bc9b51b26db78cd55616f8607";s:19:""salignac-eyvigues"";s:32:"02131fd3a3bcc4d641795d059551cb79";s:7:""24516"";s:32:"9aa63a9b4b975260794d5c53941614ea";s:22:""ste-colombe-de-duras"";s:32:"84c464462cbab683f14801a5c42537a8";s:7:""47236"";s:32:"c6cc75073ddfa21f0b8a12e99ff95c22";s:10:""sadillac"";s:32:"4f666d78e1d2c09d772f96b9ac8e7d47";s:7:""24359"";s:32:"d1323a29e72347488e54ef3984cca431";s:14:""baleyssagues"";s:32:"5e17e0f12747b81a461c7cee4a82f329";s:7:""47020"";s:32:"3786e395b40389178233b52516010539";s:12:""vimoutiers"";s:32:"59b937fc8776c287e28ad4203f2f5e6c";s:7:""61508"";s:32:"6cf505750d63d105712bc3182f8e2ccd";s:9:""sergeac"";s:32:"90027d221c09754ff70903e03a92fc31";s:7:""24531"";s:32:"879aa1baf41ca528a4e13642d7088f50";s:25:""st-martial-de-mirambeau"";s:32:"2cc318cac45d75798186f81ee39e79b8";s:7:""17362"";s:32:"274497ef283ee00c06dc9bbad93539ba";s:20:""peyzac-le-moustier"";s:32:"d83869741cb55aed140dcb88e0594039";s:7:""24326"";s:32:"0e42e8331efc090ea2df194a904435ca";s:10:""moustier"";s:32:"4fdc5b8ff3c89ae49052a10d86c1e869";s:7:""47194"";s:32:"79d5dd62b5acc97a97519ada0b9048ac";s:10:""tourliac"";s:32:"f5b7006f6458293db39065612cffa1ad";s:7:""47311"";s:32:"fe755c17c602fff6a21cbf3ce1314f25";s:12:""lalandusse"";s:32:"6f0b162d7c90b97432f27216cf3005bb";s:7:""47132"";s:32:"d3ab6bcfc31cb0396de82575b74831a8";s:19:""cours-de-monsegur"";s:32:"60afffa45ab3cad817454944ff12a641";s:7:""33136"";s:32:"ac8e96539f85503a22451905f5816eb6";s:13:""taillecavat"";s:32:"a01cbf78ca050717ae05101ee43604cc";s:7:""33520"";s:32:"6aff6a38853c0cb1ec3a973fccdfeab7";s:25:""st-martial-de-vitaterne"";s:32:"2df976daa02c40f569040b1e0cd3f828";s:7:""17363"";s:32:"4b755a4ec74b7d45c879fa2dcd0dcc9d";s:12:""bouniagues"";s:32:"db038c791c0e61a139da25da15fcb412";s:7:""24054"";s:32:"7b48c7ba6987fce7056b44daf506be29";s:21:""st-georges-antignac"";s:32:"101acbdac5a38ef415151bca4b0f5ae5";s:7:""17332"";s:32:"9941067ba7b58137604903ffc3f0c7b3";s:19:""maizieres-les-vic"";s:32:"85e0243e1643a20b14aee056e3102347";s:7:""57434"";s:32:"bfe0a28782c5b7f57805434003dbd139";s:22:""st-palais-de-phiolin"";s:32:"9cc2ebf173af21458ad27293191e105a";s:7:""17379"";s:32:"e4ff41dd2cd1e6e6889f760a6cd88fc0";s:21:""st-ciers-du-taillon"";s:32:"5998e3ef8c4817ab46f0724411b72b20";s:7:""17317"";s:32:"3abc836f97f4d4a00a310867a5d418c4";s:19:""allemans-du-dropt"";s:32:"b0a6c8767fbb4ecfc4600763dc3f8772";s:7:""47005"";s:32:"d569640ac3c222b7a51bad9965213196";s:7:""rayet"";s:32:"33265ed0616035d2fb6a404c28c44451";s:7:""47219"";s:32:"225e7c96d8adfc4403e75c7e4a6b4286";s:21:""st-quentin-du-dropt"";s:32:"ded5c390e7c3caa2dc90b18f5eac8337";s:7:""47272"";s:32:"8be5f4ae6390f36a19ed61c5a67c7075";s:23:""st-vivien-de-monsegur"";s:32:"59a05f4374d562c578047f076e5ec726";s:7:""33491"";s:32:"ba1ceef1537483a9f1f922d246e2ab21";s:21:""levignac-de-guyenne"";s:32:"891ed1f2657a3332927db0fc0711354a";s:7:""47147"";s:32:"3c833110bdb5e634c4492aa046b2007f";s:22:""st-cernin-de-labarde"";s:32:"3b0e2e301ad68adabb71550325c864d2";s:7:""24385"";s:32:"ffd28f6a32724ac9e06443acf1df44f3";s:24:""st-gregoire-d-ardennes"";s:32:"ded401da60fec1d0e09c0c40f134dc21";s:7:""17343"";s:32:"f2d9171824f937a9346081ea9fc1f1ae";s:25:""st-maurice-de-tavernole"";s:32:"0db5712d607b2c33daa768efa6c5d0ac";s:7:""17371"";s:32:"5079710ab6d84347c9c260cd586dad18";s:21:""st-pierre-sur-dropt"";s:32:"2806782ea5d03f9bfc95fc2f3a759290";s:7:""47271"";s:32:"67bf67a4bf1d7cda49037de1c2e8b610";s:12:""charmes-52"";s:32:"2f6d612790685529f5be803471ccb6b6";s:7:""52108"";s:32:"57cb400ffacb71ac643b5eb41ac84990";s:24:""st-quantin-de-rancanne"";s:32:"f12f61e5543129236451888dd23e5258";s:7:""17388"";s:32:"a5bfd4da1bee31af67eed0f6335e245f";s:24:""st-martin-de-villereal"";s:32:"02e5b876646c280bacf4e07072552ecb";s:7:""47256"";s:32:"25cb1d56ee41f3ce8b1e1227e57dbf1a";s:25:""st-etienne-de-villereal"";s:32:"0dce765975eed5d6db3811b96f994d8a";s:7:""47240"";s:32:"f7d7acaf429216471da30bd02d07c72f";s:18:""enquin-les-mines"";s:32:"1d8e65f1543b18e0d4b09e36f54faeb7";s:7:""62295"";s:32:"70842392ebd4653188449c9103208fab";s:28:""st-sulpice-de-guilleragues"";s:32:"d87a3b0d3454d5d9dc2f74dc717e6a0c";s:7:""33481"";s:32:"8bd5a37e8c04d7ac6f4d8e9262274bbb";s:22:""st-aubin-de-lanquais"";s:32:"76da2de226a114a6dbcda819424bb43f";s:7:""24374"";s:32:"dba18cb1a29f2b0d0c61a76a133f15ca";s:23:""st-michel-de-lapujade"";s:32:"8be28675758563523353a52c8c20d248";s:7:""33453"";s:32:"f1b5c6b94c0757d7fcb3a232a90711e1";s:18:""st-dizant-du-gua"";s:32:"0512234c528849c6e0cdbda0f454acc0";s:7:""17325"";s:32:"b8928f4fa76987acda276c5e201001e0";s:19:""caubon-st-sauveur"";s:32:"5fb44aa5f39dfe2a44ed0b67b77246ce";s:7:""47059"";s:32:"a2eaead5b7c427a9de2e2c4f4109008f";s:18:""conne-de-labarde"";s:32:"9d654f4fc8c81210e5960f95cfc456bf";s:7:""24132"";s:32:"215c67f292720b504ceb9f017de80c13";s:10:""devillac"";s:32:"cf0f73b4273d425cbf5b9b02ae6fd6ed";s:7:""47080"";s:32:"665b66e057f447dd63347dbbc2e8c576";s:18:""fleac-sur-seugne"";s:32:"a618cd570239065465e7c2859dcca075";s:7:""17159"";s:32:"943cb1cffbe84a698892f6c1b4ceb1c4";s:20:""st-sorlin-de-conac"";s:32:"04632abd33dec90bb127e5bbed4105c3";s:7:""17405"";s:32:"b167a390e0139ccce16876cbe771c4e8";s:23:""st-bonnet-sur-gironde"";s:32:"54f1a4794b7b0f674b57ef41057245ba";s:7:""17312"";s:32:"92655fb375b1520e4b5d350168faf9c3";s:26:""st-hilaire-de-la-noaille"";s:32:"ee897da523d7a65a305491907dd3194c";s:7:""33418"";s:32:"7427ff8fee5ece3af64081d4bf7128f9";s:18:""bellefontaine-88"";s:32:"95d861cb8806ec749bdfd6dd2d484b18";s:7:""88048"";s:32:"4e96bed3769a1979cba578b4675fbb29";s:21:""fosses-et-baleyssac"";s:32:"f080d45c4b3e5c7e6651ac841abcac65";s:7:""33171"";s:32:"dd4e572fb38b4b72e34c8d2423ca993e";s:18:""auriac-sur-dropt"";s:32:"3c36631ad675cfe555ea486acc8af192";s:7:""47018"";s:32:"53a570b0debd0016f34bd14db5e5970f";s:8:""geaune"";s:32:"65df8022d35e3fe7a01150118ed2cddb";s:7:""40110"";s:32:"cb6150374804739c9414848a44671c20";s:10:""monteton"";s:32:"c04f61d5b37baccecb21b9dc8582345d";s:7:""47187"";s:32:"452a3a361b768ae7c7f072346688f688";s:20:""mauvezin-sur-gupie"";s:32:"a260212e4d44e09d9a9ba26297f28740";s:7:""47163"";s:32:"2d145306ab607c1382a6aa4ceba8a9e1";s:21:""st-fort-sur-gironde"";s:32:"7de93c253aa06156c3f962ecad097bbe";s:7:""17328"";s:32:"4158175a99132ab2716d9f592caa28c8";s:15:""villepinte-11"";s:32:"127fcbea54f0bbbeeb89ea566c66c838";s:7:""11434"";s:32:"bbf396d3e78275c1165ee9683ca6bc14";s:11:""bonnefond"";s:32:"ae52e038879a3d17f7a2776e42fa000d";s:7:""19027"";s:32:"14dd950ed181cf2028021e00815dc54f";s:15:""vauvillers-80"";s:32:"e336cc3ee62ad7cdd8e38c0b85ceb3d3";s:7:""80781"";s:32:"82f755b48ef7692b04714084efc322d9";s:21:""castelnau-sur-gupie"";s:32:"9a39c48f737d6bd816a0ae111ac55c6d";s:7:""47056"";s:32:"c2e97d515cce4537006eb63663ac1fc6";s:13:""escassefort"";s:32:"062b01849aac1191793a8c65539b4ab5";s:7:""47088"";s:32:"15ce4d971ac1be333d465f11d59f87ff";s:22:""st-ciers-sur-gironde"";s:32:"24941aae3ad9658cab97c3e6a4c806c5";s:7:""33389"";s:32:"0c6c4e44a9a2d7555f13b15c4b0551a2";s:23:""st-romain-sur-gironde"";s:32:"6c34733b2fcec5a53b41d3cbe4b3289e";s:7:""17392"";s:32:"7590a0cb359258919aaa07e7bad8addd";s:13:""mesterrieux"";s:32:"f663bcdd51953fd1cd8ef37799860c39";s:7:""33283"";s:32:"5d621c32d4480dc14b302f2695bcfea1";s:13:""montagoudin"";s:32:"5d74e77e7bf578ad5c37263a0886288c";s:7:""33291"";s:32:"177a1a6e9e2d0faf38158813bc7ddab3";s:12:""monmadales"";s:32:"14b7e825fd5563359174dadf183355ab";s:7:""24278"";s:32:"b804e2cd9325b057ebc4c6c3d2be8fe7";s:10:""mongauzy"";s:32:"46e2136310a4d4a452588b37246096c2";s:7:""33287"";s:32:"bd950363217b1a5cff10bd46d9c00317";s:10:""roumagne"";s:32:"22d41144e7fe994c6339761560b2fe29";s:7:""47226"";s:32:"7e7dc2c308643f8738bb5663ba1b5750";s:9:""lagupie"";s:32:"56d59d8b41f27bb9d281bd920293f9b6";s:7:""47131"";s:32:"e2c6491528f2b07aa135db34af0270cb";s:20:""brie-sous-mortagne"";s:32:"470d5deb1b6e7eda216b4adab10b1f64";s:7:""17068"";s:32:"69268f4f159eff77fdec61c76e7a0776";s:18:""boutenac-touvent"";s:32:"3b616de40ce4acd4331b6e69a7a09717";s:7:""17060"";s:32:"70024402e1dca04220e5fc3d0f75262a";s:21:""st-caprais-de-blaye"";s:32:"d9e8be8c8d4ce9f42eb7f487b9ad1b64";s:7:""33380"";s:32:"7295683f5b2410a299f3555a12fe8fa3";s:19:""st-aubin-de-blaye"";s:32:"cca1108c36784e76e62caea8611273ae";s:7:""33374"";s:32:"2dd89e7d6ea1c49264048e9f15d11081";s:23:""landerrouet-sur-segur"";s:32:"2f9e7491b041a5fc1a5a6030689aa9f2";s:7:""33224"";s:32:"649d98c23abfae242094a04970d44202";s:19:""st-martin-de-lerm"";s:32:"23dcfcafddeddea38cf53967c96f03a5";s:7:""33443"";s:32:"03d709e507cf279bd7794beab915e6fa";s:19:""braud-et-st-louis"";s:32:"a34476b33275106340af6d1d7771816b";s:7:""33073"";s:32:"3abd1473826ec86381ea441b4006f75d";s:22:""castelmoron-d-albret"";s:32:"9f85b324f351125065c6639fb1be3405";s:7:""33103"";s:32:"4c03d5620926a7c7e8e376be21b49ee1";s:9:""seyches"";s:32:"9c7ab83877ea70144d098bbc74b55e14";s:7:""47301"";s:32:"36c81dc5fca5bcd2a5f62dc037c71da0";s:21:""miramont-de-guyenne"";s:32:"85caef5db923c9c39d4b89900fa83d83";s:7:""47168"";s:32:"440673e464d24e0d49e5cb89c602f3f1";s:23:""couthures-sur-garonne"";s:32:"7c707a86bb1c1d8bd4b425f605d7a9ea";s:7:""47074"";s:32:"5fa88c95c920184411d4e93d4fc548ee";s:18:""st-pardoux-isaac"";s:32:"265f9831ee88ab9f2c3564f7c2231b9f";s:7:""47264"";s:32:"759922685b5c0248870bf83a7c367180";s:12:""bourdelles"";s:32:"49a8de74a7e3648c70cf43872b09f430";s:7:""33066"";s:32:"d862d78773e5f4563f8faef406d2b849";s:25:""chenac-st-seurin-d-uzet"";s:32:"caba6fe2fcd528b05956418f98db7fcf";s:7:""17098"";s:32:"20b2544a2dbfd864f782faa687eb61c6";s:10:""douzains"";s:32:"0951132c782b3a4a2a332803d63d3a9b";s:7:""47084"";s:32:"adbd78e536a654a136500c731c99fc3f";s:10:""belluire"";s:32:"176bcbbc873bb9b06f8ea0314ef5ef52";s:7:""17039"";s:32:"49f7d2eaf849fe48023bf237b84d8386";s:21:""st-martin-du-puy-33"";s:32:"79702433030f611c922b7b3eb05ac12f";s:7:""33446"";s:32:"ceff044ad16655bdff2134d6fd7f8b5b";s:9:""camiran"";s:32:"bf3430825b481db0f5d0e4629fa5a9b7";s:7:""33087"";s:32:"45977d83028de1eb1ad5f4887c28d9e7";s:22:""montignac-toupinerie"";s:32:"0b69b89fb1fa0b1efcdd8fe2109c61df";s:7:""47189"";s:32:"81e2bfa75e18a288c2a362025ec2c771";s:21:""meilhan-sur-garonne"";s:32:"21d89a7ad02c97fb81c966a72572ba71";s:7:""47165"";s:32:"6f20948e7ddb049ea9775962883a3703";s:8:""monsac"";s:32:"652119ea1122d3b011e605b5dfb18cd6";s:7:""24281"";s:32:"a7d247c14abcc97417df7b47020609c0";s:14:""montpouillan"";s:32:"344944527214f2f4662b27114dc18ddb";s:7:""47191"";s:32:"50454e102b7f00ba228f43f9206ba563";s:15:""bourgougnague"";s:32:"546e0610312005583a0e38c2d2cf3305";s:7:""47035"";s:32:"9700fd5c94a14eb15764b3ddb268af84";s:21:""loupiac-de-la-reole"";s:32:"3646ac222ab787276808ce2af3dd8b51";s:7:""33254"";s:32:"ca5115fc3022dbbf90fc0452f177d779";s:21:""st-martin-valmeroux"";s:32:"20f0a487515a109a18957bfcc52fd6eb";s:7:""15202"";s:32:"ecbe6674aa3d7cacbe84912d66bd9ddd";s:10:""epargnes"";s:32:"f7564250b10dde8c5e96926bfec64a93";s:7:""17152"";s:32:"60cc8d555cfa803a2aa35d64afa0057f";s:8:""consac"";s:32:"722b6652ff5c375a529cb1d290655ccb";s:7:""17116"";s:32:"90ff1293ea3e70a6b52ccb4dc3e538d7";s:11:""broquiers"";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:"a709e8c455d24cf6e39514dd5c3b417a";s:21:""talmont-sur-gironde"";s:32:"5ffe72e4141b1327ae6dadced826534d";s:7:""17437"";s:32:"82cd9d2df03d16ba541be79f7f51c448";s:8:""thonac"";s:32:"3dff4dd633c8b0ccb813f1dae741cc17";s:7:""24552"";s:32:"2f3e82da9f1dbabf0af16b4a946a1e08";s:25:""st-barthelemy-d-agenais"";s:32:"f88d5e9196557e8d289d078906703a1e";s:7:""47232"";s:32:"9f85df7f9dc3299a9aa1162953344caa";s:23:""st-sauveur-de-meilhan"";s:32:"4d556e2fa69393a79b704c1d84792f26";s:7:""47277"";s:32:"7df3e0745f4b2f167c166288d3098f1a";s:22:""fourques-sur-garonne"";s:32:"16ecd164d598421faeb60e1fd03c10aa";s:7:""47101"";s:32:"8063711769b5c57ba1073ef8e28c05b3";s:10:""fongrave"";s:32:"5a342c039e9b65ac1b4ed663a36af3ca";s:7:""47099"";s:32:"4dc57498c28003e49d019770691b33dd";s:21:""st-colomb-de-lauzun"";s:32:"33a505f413079fd7285bed0e17197b2a";s:7:""47235"";s:32:"c1a780362d3b99cf2b99c5df3b10541d";s:9:""samazan"";s:32:"2970f86d54a56222e24e3054066c0c03";s:7:""47285"";s:32:"266571b8fba4c97685f30a698d9be48c";s:9:""monviel"";s:32:"d40235ce0505bec2df5ccafe784b8075";s:7:""47192"";s:32:"631ae089423b702e88c3310a600ac328";s:24:""st-maurice-de-lestapel"";s:32:"4cd0e81930162c38e6223f2d9126e1ff";s:7:""47259"";s:32:"54c99db9fcbfb62caa39223aee581c69";s:19:""st-andre-de-lidon"";s:32:"7b9aa2013820a738288a1f2742076e10";s:7:""17310"";s:32:"dcfcf726317c2aa36bd16705088ff8f4";s:9:""floudes"";s:32:"d3099b69d3647e2a48625b6b8354d97d";s:7:""33169"";s:32:"427d1c82d239efa5e07f405ee81d7a83";s:10:""marmande"";s:32:"d91a5e9ef07096edddd3341ed96a5409";s:7:""47157"";s:32:"7cd9942b940953dd2d8622fad7f1cc45";s:10:""cocumont"";s:32:"a8edb8eccd3b1156c75c05b44be103a5";s:7:""47068"";s:32:"619d21665d1afdea062f27d7b4a1557e";s:12:""romestaing"";s:32:"2a0cdaa9937d19ea8ed91c0825bd2917";s:7:""47224"";s:32:"6adb9eaf1550285623486b407548de83";s:22:""st-pardoux-du-breuil"";s:32:"a076062c56151f1eda3a155362d735f8";s:7:""47263"";s:32:"e300e50f078ee69dedf7d75d7a508a5c";s:21:""caumont-sur-garonne"";s:32:"09b582803644503fba8c0d3541f9c731";s:7:""47061"";s:32:"5402a4dc87bcd76271ca3f18c57f9b32";s:16:""taillebourg-47"";s:32:"31d55ba80ed938cdd9a92a43b1fedc43";s:7:""47304"";s:32:"acbfd259c4970f716d6251e2befec860";s:16:""longueville-47"";s:32:"e490f2182ea2c1f0b80a0866de6eac61";s:7:""47150"";s:32:"5f5006b823ccdd1f0dc668c5f0f4d9ea";s:14:""fauguerolles"";s:32:"bcd92fcda26f6cd9ececd145d31dbbe5";s:7:""47094"";s:32:"ba1bdf34b485ad82c5c4aa23298a0422";s:12:""tombeboeuf"";s:32:"a72b695f42a60d0b2e4d0a6364f2e19c";s:7:""47309"";s:32:"2655abd473da8abbe7795ad28f2832f9";s:21:""montignac-de-lauzun"";s:32:"c84189fa88c8de8a68be6f6f572a5b16";s:7:""47188"";s:32:"75b2f142e8ff3f7b33357c3457ba3015";s:7:""laree"";s:32:"053d21ad5c8a92247f355ce8421c492d";s:7:""32193"";s:32:"88c2f95cbe13cafbe53d1615caca8b47";s:17:""grezet-cavagnan"";s:32:"12cad7e200ec8a6a995910ae8efddfbd";s:7:""47114"";s:32:"d371d84dadaedf3ea26335f52f4c9b20";s:14:""aiguillon-47"";s:32:"3d7a8fa37a81436565214d0da6df6e57";s:7:""47004"";s:32:"d3e3284a8ec2d79ef310d357f5c69ab1";s:19:""gironde-sur-dropt"";s:32:"da3275b313521ddd2d7a2edaa408a98a";s:7:""33187"";s:32:"6caa11586df9315ae8bf8e5246e18e45";s:20:""gontaud-de-nogaret"";s:32:"b5013ddba17cedb9282175715a42d4f7";s:7:""47110"";s:32:"c553a81764cddc742729f4656539fda2";s:9:""bouglon"";s:32:"f607c49a5b9006af24d6858f63b13bce";s:7:""47034"";s:32:"591e032f1745ec87299392da3e2fc28f";s:10:""monbahus"";s:32:"bbef8c64603157f4ebee7b5e8ef5c3a1";s:7:""47170"";s:32:"95aa853fd8a04e0556aedbeec364fc13";s:10:""argenton"";s:32:"3f27175cf302beace0232dcc4cf41222";s:7:""47013"";s:32:"068a23466e4a8e397f8e2343487cc6ee";s:13:""villebramar"";s:32:"179fb75c465c44408adddddf0b99392e";s:7:""47319"";s:32:"bb99958294387ffeaf7fbf0e6b652ff5";s:22:""ste-gemme-martaillac"";s:32:"bcc51a93f99a255fa163815c208328f9";s:7:""47244"";s:32:"8ad6cd532dca9ca02d46df6a6d87c9e1";s:27:""labastide-castel-amouroux"";s:32:"0dff8de991e9afe3551753961c5bbb1d";s:7:""47121"";s:32:"6ddafe1af3440f814571c7fdbcad3881";s:10:""tourtres"";s:32:"2df8bb13ca6f6c466dbb35c54c7f7529";s:7:""47313"";s:32:"0e27e2b3e08a23fce86b1d095921203a";s:10:""fauillet"";s:32:"bd7c847fd9950b6ef96f23c5a69e5966";s:7:""47095"";s:32:"d0d63170a8aa6d6c75c330e55f995c2c";s:14:""hautesvignes"";s:32:"bb0185658c44cef682b50a053a28813c";s:7:""47118"";s:32:"8a9f0cf0ac29ad801704f1f0c680dbb9";s:9:""lavazan"";s:32:"4e236b8180b3494d5e4ead66ceaed5f9";s:7:""33235"";s:32:"a8d55c6e71f29398fd655ba7b7890ac3";s:10:""casseuil"";s:32:"4ec477d4bad1e56792dde40c0016807a";s:7:""33102"";s:32:"3bedd7db70ad5d73a67f5e652cfa35d6";s:8:""tesson"";s:32:"f7f623c4523f3bffbb9b25aa625fb71c";s:7:""17441"";s:32:"3a5ca0e195190b18741ccaa922b202ae";s:8:""sillas"";s:32:"f2afa733fdba51dadfc4870b8de29c86";s:7:""33513"";s:32:"9ab76f0ae55316561080a5f83b5998cf";s:10:""sigalens"";s:32:"a09ff66e32b45703b3697a3a93f4ef57";s:7:""33512"";s:32:"fe87391d5c4d79a800c67f6fe7f6ad07";s:10:""semillac"";s:32:"164e0e0d0a4e6e373e8478f497147ab1";s:7:""17423"";s:32:"cb9d8e2ac10f2c1dc51e0b029d0aa28e";s:23:""st-hilaire-du-bois-17"";s:32:"46df0414e13d88549c057129c87dcd3d";s:7:""17345"";s:32:"32af77bf80fe2abd9e7bc2d653729347";s:19:""leyritz-moncassin"";s:32:"0004c0ffe78316d6424f483d6464d7be";s:7:""47148"";s:32:"28b9a18113c5d47e284e39b47fd8b13d";s:10:""lagruere"";s:32:"4e0cf615cd97d1ada528893fc61f54b1";s:7:""47130"";s:32:"92fed2091e0ddfbb7dba3b2e14319316";s:23:""st-hilaire-du-bois-33"";s:32:"9a3aea79633a19a8cd1cd0def0b57063";s:7:""33419"";s:32:"6d50342324b825a2250d5c0ff2d1f994";s:22:""castillon-de-castets"";s:32:"c589c4484bb647d7ea4f8556b4f205aa";s:7:""33107"";s:32:"51631ef6e2d9a51ad7f4015111b66c37";s:19:""ste-foy-la-longue"";s:32:"853f5bf8a5cd68d413eadec851086753";s:7:""33403"";s:32:"24d77c27b4c9f834f24c7e29fc67242c";s:7:""rioux"";s:32:"55bc875ca03b7e745ca9769a64e5d546";s:7:""17298"";s:32:"fcb71c363b0bd62a84c991dbf9c2f6ad";s:12:""preguillac"";s:32:"fd13847e6f08f8aec0019f5ec5b7debe";s:7:""17289"";s:32:"1cef1db929fed99bae9184a75f569994";s:10:""labescau"";s:32:"18be51cecb4eb8d3fc7bab5041e3c6fd";s:7:""33212"";s:32:"93835875db0c65993c8b21eb743ac752";s:18:""st-pierre-toirac"";s:32:"9aee04fa7f75ed8a59b51a3bc58417fd";s:7:""46289"";s:32:"9317b77211e9d97e742b13a10382dbde";s:7:""tatre"";s:32:"df494992dc3c7f22b395d290f0121702";s:7:""16380"";s:32:"27088bcc2ac39aa397b928d075b032f6";s:17:""st-jean-de-cole"";s:32:"d5df8b638a0cfac7c419b8ff74d7e0ee";s:7:""24425"";s:32:"22ceb3b1cafb94e8309ccd885680a48e";s:25:""villefranche-du-queyran"";s:32:"35f96c859906cd66da9bb67ad4fdf6be";s:7:""47320"";s:32:"eda92efe3d33b37a371411227afe297d";s:18:""cros-de-montvert"";s:32:"01c8d9c664cc3f8fb50cf17ac1dc4a1c";s:7:""15057"";}s:6:"fields";a:291:{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:"802a1322a04505cf1bd9c64295c21a8c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.233333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}s:32:"8ee4e381878886a74715e50c607da897";a: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:"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:"4b1e725e8c91342afdcfec1b3280c704";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"fd5a7ec0899048458083f94204370744";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.35*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:"e8eb81f803e659c26f6f05e62ff15904";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*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:"b889cf4bd0910decfc6cc216d6e87594";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9356*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9356*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.01695- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"39b1d424edf3047dcaf9a91b10a381f4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ae7b20590728374e6236d120cf70acc6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1a8d3cc097df30c7e2246e2f3ea357bb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e191d1a3bc4999a44e4f5604c3517c65";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.216667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e265785453184bbaed5cda6f05e984f6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*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:"bbb4049ff44acfac692ab12128a8ad9c";a:2:{i:0;s:71:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*";i:1;s:18:"`Departement`.`id`";}s:32:"f4c0e4962ebc6c6dce3c68e566c65f43";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}s:32:"d2cc5378c0bccb6bc28605f94474ef09";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.216667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3bb8013c4144f4fcf29daeea6a48af5e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"821c94f8bafe5677c0e023016b4fb94a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8068156d8b29a1ac1930113f2d4bb687";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bd8218c06e5aa9de0cc92a41c133fa27";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6e7740f4b57d87eaff94e0ac86463f92";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2dee178b362dbd0625f4312ef5e46ddc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b53b54378cb07b6539e77973f87710a2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a0b8b5afc956b28ba00a15a1c0187b11";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a9b9870d033e2c7c83b1be1099cf97f6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((50.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c4bf81f1dc4cbd49566cfcaf6dc75e5a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((44.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*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:"66fada8b417a7d87bf2b175cd120a390";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.2448*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2448*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.255278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7e52d348f94175da5d47273ac843cdb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d6bd6b477fa9cb887c22f5c2988d0f4b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1454f8f8764e92a19f36a78a3de68fe";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((41.6209*pi()/180)) * sin((Ville.lat*pi()/180))+cos((41.6209*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((8.97362- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ac2a7de1032f79c4b8218c21288e0c1";a:3:{i:0;s:54:"Etablissement.id, Etablissement.rs, Etablissement.slug";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"c4fd98c43562097d790d7e33c74a05f1";a:3:{i:0;s:14:"`Mur`.`pseudo`";i:1;s:15:"`Mur`.`contenu`";i:2;s:14:"`Mur`.`posted`";}s:32:"227110cb1331a56c3995a31fd8c4db7c";a:1:{i:0;s:11:"`Annonce`.*";}s:32:"147548c6fd78f304b4de7841bdfbdbcc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ee7a4423fc212b472145048f5e4efd14";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dcadae6ce12b8eb7c0e9b72f42ca9142";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3848d978f8c5c85008ce21888d12af0d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa153e5d0cf4b8ba65fd89ee5a608eda";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f6a24d151b7d6c2a58ceb8eb4e7382d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"489be8248fe0ae42907c695bee930ed1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b0dee2777b1a4c21f1a830400eeffe6c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"03caf3783dcdd4910d2e3a49c241ffcb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e0164151b7584c71e4afca68d87e9d28";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"76d8451ff83a06daf8af7834eea5a97a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4875*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4875*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.75112- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"565451ed7e9702ebee28dd24f5fd612d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*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:"ee2a5fea7a01561e47709829f1e45a20";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"103652153df5d12997f66434e0423ff6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*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:"db5ce4c824e4873a654bfa89be3c94bc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.25*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:"788a8ac4d1507a3824f19b8da9b0c601";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1aa647cd4b5117c6a2a3c8c8bb6d28f5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*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:"5a1105c6fd1394563e843225b793464f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0fa36beb144665f61a95e57d477e4f7c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3f5ef44f11fdb9dc6be1a6da0d413bdd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dff10bc3d1736b6f5a3ef6c67da16dc2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a483b51c4700a3b748cfe3bfacceb879";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8b20883bbf1f0ae516c1a87f7bdf4f4a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.8083*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8083*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.125- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5a8c22e2d1f473a17075bc6b1b2afabc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0f3d7ba27f21e1cd14c99e5f589526c8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1833*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:"d893fb02ff720c1d5a4795cf3b8ebc3a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*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:"8adeb8b819db6ed9a2624570c86362ec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((44.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"60835ab4336c9cb545764c5ba0f7a15a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.433333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d1945397faaf7885c17f66912f714dc1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"65e50ca72d5a890e822880560f9d5ade";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6333*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:"a85289fe6865675dac3a257ddac7fb97";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*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:"055b6966d5b592e8fc31662a33436180";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"73ddbc0e242fbe3fc8ced61cde5091f3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f1b6efc01dd8b417fcefe8f5e89db57b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((44.815*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.815*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.14861- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9085d7603566e0226a506b99913ec284";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*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:"7fe76f9cb28f9340e4087c6904c53b3f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2e9e89d49fbfa676e40240de58bc94da";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.916667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ccb4fb09f2774a6a2bc7cc6725da61ef";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2efd0aa408a08a7aaf64168842d96892";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"12351816f62f53af48b79fb1eb6f2887";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.35*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:"f7785fc1514ec7f86b1ba710f81e8a06";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6a1b8e1a4ec8c847aa35e50695fe5873";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"18ee395fc978fa55a9a6f21e11f0cd04";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a0fdcba8f16173c96aa1beb54611089d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"de0ea3a3e5296c7be6a612c91dc55414";a:3:{i:0;s:50:"Ville.*, Etablissement.*, Agregat.*, Departement.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"03a375efbcbe5ee497b5d148673088ff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:178:"(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"613c6983ed1bf2e587b8f880b6b06a32";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2339*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2339*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:"d24c4b73668d59c1505814a9c3c0e80a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*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:"9b7d381ab812e8adc70a4cab88b34354";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*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:"c9a4a83d9ef4e87d32b83e6d24067514";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aae2c2f9f0c2f1091b104db5454c76ec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"362ad58d4f11065eb6ac6b3073a89e59";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.883333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"27fd1db420ce75848e266a456c2056a2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9f50190c18a6762dd4e71a03c851072";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.966667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"82c909f7a0c8dcb1a6c3ba9bdd857a85";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1d88915ba43cdcf142642a967761f702";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f085686780a2a19928c5a05a4839423";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"78153627085fcae7454ea689b0eddaa1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6739*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6739*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.453056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4bcc7675b5276d471e6fc7f86c6201ab";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc8fb847d29505d3712ddb98b67a6866";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"abe31bdd8f0311d1cb0498e732af3192";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3598*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3598*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.4075- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ae695de10974c35a00afb6f4e020bd90";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.966667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d3ba360c50e4a26b453145bee54b3733";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b8ef77f30c94cd3eb51a9870f3019d73";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c658ecc27116c142d260b52324e0ee2a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b7af42037fdf09d79029b73d018b8b1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.433333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ffb58d00684933ad0a6f56f85f82e9b8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5417*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5417*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.07417- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"439c69fda9e26396a45ed66472a26cf7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*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:"58dfff58dc5f075f2a9af1a027141aa2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.283333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4f87fc8753aa383e009e9e71044bb50e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*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:"6e60e313a964f39efdba0e63aab7b4a1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"517c1a39dec7505ea7ebda718764c86b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5795921b890b3c2f1a9afa8c6be70459";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"556ad0529261df2a117a1ff9c1827076";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((4.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa7e4a307bbb1c2c311146adbdd63acb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3b0b206a69836b1e0d8993c68649bc19";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((5.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6821a81801f2f376b8b3cacd8edd10fb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.233333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"12d6cb7a645cc7fac8b0fb8cf55fc47c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"03d781a40652990bbbb470e6a9d2e63c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.333333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a4065f43413574d55b6755ac762337ad";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"65f164186ae4374b7a230c155dee180d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7698*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7698*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.766944- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9527db3a3866f7cd9dc525f672c4445c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8f4ed7accbcfb90ec1d75e19e5551dc1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc737ca004dab5c71409a06df04d5f95";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"676d33c5e2737361c1fffc976c19a43f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.35*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:"ae878257ae3300ef9f4f1152c73b9748";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((44.725*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.725*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.758611- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e9feff2c41bc658ffb0788ea5e68d164";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"479f2e0398c268bab0c1b827ddb3accb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"597a2f4b297d76665f0b7ad8edf04552";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2bd8ce20b017e6f20ce506284b860f29";a:3:{i:0;s:88:"Etablissement.*, Departement.code, Departement.nom, Departement.slug, Ville.*, Agregat.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"e669f0d22331769dcb711a7148f19ed5";a:2:{i:0;s:385:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Agregat.imglist, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.slug,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"403c6e660a82fa69b87a696f1c113a11";a:1:{i:0;s:37:"Keyword.lib, Keyword.slug, Keyword.id";}s:32:"eb6fb1782adfc6d8a8864d3f32dab591";a:1:{i:0;s:20:"`Etablissement`.`id`";}s:32:"dd08a8531e9f680ecbf27f45e43f296f";a:3:{i:0;s:27:"`EtablissementKeyword`.`id`";i:1;s:41:"`EtablissementKeyword`.`etablissement_id`";i:2;s:35:"`EtablissementKeyword`.`keyword_id`";}s:32:"c6852640fcf038dc2e7ee42c8b6c4097";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"eeab83cba95d4a0d201dbcb17f0e8d55";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"1b2c074bd5e2d269d177aa66ef6ab159";a:1:{i:0;s:24:"`Ville`.`departement_id`";}s:32:"ea0e1579f0e6d3ac7f276247b53988e6";a:1:{i:0;s:25:"`Departement`.`region_id`";}s:32:"041ee62018e3ca758af163685add8078";a:10:{i:0;s:10:"`Pub`.`id`";i:1;s:13:"`Pub`.`title`";i:2;s:12:"`Pub`.`link`";i:3;s:11:"`Pub`.`lat`";i:4;s:15:"`Pub`.`adresse`";i:5;s:11:"`Pub`.`lng`";i:6;s:11:"`Pub`.`img`";i:7;s:14:"`Pub`.`height`";i:8;s:12:"`Pub`.`view`";i:9;s:16:"`Pub`.`view_max`";}s:32:"d1cdddacab2cb2b9feb13fed1f91aee6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eec613c829dc2e87f4aa822922460e4e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*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:"855f5465080ab86f1833c35061e38457";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.566667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9a35b4f05875950c7dcd72b83baa28ea";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a4818be869738ce70dd5cd1ccc490ef0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"93873bc6fdfb356e112d44561ab78ca0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e7a4a0dfad05259ce8bffd8d3b4cf3ea";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6953*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6953*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.863333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be474783993ca8d32eb9f9d6cc2a6015";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9745*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9745*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.32278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ff61620e25e6503ce349b22a05834823";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2345a28c61beac9b6624dc6608ffa3ac";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"148fe85cb071fcb0c68a12236dd76527";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1ca7e2c51485e1116e6001d19201064";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"acf3674ab4313434adc08d6b58b93069";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:185:"(((acos(sin((45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45*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:"106a695dd983a0e1c0a6df1a8cf589cd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1997e86c311378066c864b1c4cf0d72";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0c2522e2663cec31bee8942a36bba542";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f61cc18741666bf604a5d14db85495e8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*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:"f3974a97fd4a6a27e4f742a8a6c930c7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ff4c66184484e398893d234adf2b19cb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4ef8fe8c68bde038fd95d6413e02b769";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0862ace5ea4a1211928ed5a40dfd822c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.433333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4657f48a9384b682fc9e3a6cda07c01b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"28a16762e52980c0d2783881729bac94";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4937*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4937*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.503889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6b50b5b9db356f50850a9d78309c5b3d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"15cb7baee5d0607cba6099be6b517bbe";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4cd2a7805c84c392044eeea30e1fb497";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e5e6834940f3b21e5993c7b31bd2b278";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*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:"ec8940697141542b265e4aa331791fc4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ff4e8b6c94ea2c2981301f5b4cf4a4a9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e5363906db5a73b3f82488e35e183813";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6167*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:"b04945b402850322c1f6856daae74696";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"98d4dfd06848fb42bffd32fcb4e7e6d1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.566667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dbd480637cba8d34a3cd8c5ae62a9e81";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5*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:"42ad9faef4df96811966c87479f27450";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f5cecdb83f80bb1a016c0ce9e3ff706f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9203*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9203*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.35112- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"618ed5833b95992d6be2010220487c20";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"94dc5481cb36c29c419131f437c12356";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"891b103c9d427125f5e76601a804cb82";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6167*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:"68f2e15de17223f272da8873169a9d51";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.5833*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:"cd2fdc6ca709f0cf3e706a4160f24821";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6292*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6292*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2d23a030e71d3a5f2b42abfd48d04fd4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a7d302524b838e86ed5357e8d47a5f64";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((44.5817*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5817*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.0705556- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"99ed505c70031f085be90de32481134f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.7- Ville.lng)'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::shampouineuse() - APP/Controller/VillesController.php, line 226 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) 1756182563, '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
La location d'une shampouineuse pour les tapis est idéale pour un nettoyage en profondeur et un entretien efficace. Elle permet d'éliminer les salissures et les taches tenaces tout en préservant la qualité de vos tapis, sans avoir à investir dans un appareil coûteux. Pour louer une shampouineuse à Charny-le-Bachot en Aube (10) nous avons répertorié une liste de particuliers et professionnels pour le secteur Charny-le-Bachot :
La shampouineuse à sec utilise une méthode de nettoyage qui ne nécessite pas d'eau ou de solution liquide. Elle fonctionne avec des produits secs ou des poudres spéciales qui sont appliquées sur le tapis, puis aspirées après un certain temps. Ce type de nettoyage est rapide, permet de sécher les tapis immédiatement et est particulièrement adapté pour des tapis, des canapés ou moquettes sensibles à l'humidité. Il est aussi pratique pour des nettoyages réguliers, car il ne perturbe pas l'utilisation immédiate de la pièce.
Contrairement à la shampouineuse à sec, la shampouineuse à humide utilise de l'eau mélangée à un détergent pour nettoyer les tapis en profondeur. Elle permet d'éliminer les taches plus tenaces et de désinfecter les fibres grâce à l'humidité et à l'action mécanique de la brosse. Cependant, cette méthode nécessite un temps de séchage plus long et peut être moins adaptée pour des tapis qui ne supportent pas une exposition prolongée à l'eau. Elle est idéale pour un nettoyage en profondeur, notamment pour des tapis très sales ou des taches persistantes.
À Charny-le-Bachot ou Saint-Lyé, Fère-Champenoise, Marigny-le-Châtel, Sainte-Maure, ... peut être qu'un voisin aura la possibilité de vous en louer. Pour une utilisation annuelle, vous pouvez même chercher dans le 10 plus globalement (Aube)
Pour vous accompagner dans la rénovation de votre maison à Charny-le-Bachot, 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 Charny-le-Bachot 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 - Charny-le-Bachot
1 rue de l'Aube 10380 Charny-le-Bachot
03 25 37 45 68
Selon vos revenus et les travaux envisagés dans votre logement, l'ANAH Aube (10) peut vous venir en aide.