Notice (8): unserialize(): Error at offset 83136 of 83275 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) 1738770762 $cachetime = (int) 1738770770 $data = 'a:3:{i:0;b:0;s:4:"name";a:438:{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:"96ec2c347d59c0391308e7bfcf799c46";s:22:""champagnac-de-belair"";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:"bea7217984cbd0348b60d2b9cc4d8b90";s:7:""24096"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"34f765a0ada941237178708193a83a85";s:11:""marquerie"";s:32:"fd6604bb72070ae6974e8b29ff5db4b6";s:7:""65298"";s:32:"3e1617eae643d38f5e2007b9b1a7eb2b";s:15:""vieux-berquin"";s:32:"63a91b17bd78db1394d2d090f4d53d91";s:7:""59615"";s:32:"830b5dd6cbf609557fc2f319640df7e5";s:20:""penne-sur-huveaune"";s:32:"a377dfc6ad0e881f0795a884d019343a";s:7:""13070"";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:"20875c955b05d8da2e6c148ba80d1368";s:10:""louannec"";s:32:"00a6b92efa96b3a80585dac1d6e0705e";s:7:""22134"";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:"55b7fba22a3bf1eb6ffeba2982e89a6e";s:9:""coursan"";s:32:"828477917dae8d563d271dd16c171274";s:7:""11106"";s:32:"9fb87b8e6cffe6e124e8bb6ba79c6903";s:7:""fulvy"";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:"62a0193219c25bb5bb36beca2e64a23f";s:18:""bourg-de-bigorre"";s:32:"dd57a54cab6f95cf525c027cd2a2e5cd";s:7:""65105"";s:32:"7e9a3b4cbda75c3f60b956c1c9338f33";s:9:""moroges"";s:32:"af1f4746c47fb3a9bff0c14c969c2944";s:7:""71324"";s:32:"266571b8fba4c97685f30a698d9be48c";s:9:""monviel"";s:32:"d40235ce0505bec2df5ccafe784b8075";s:7:""47192"";s:32:"841ce0708163da4f3fff005b6036c59e";s:10:""poudenas"";s:32:"45f23ae9d72335b7017cd27a4e5d2b75";s:7:""47211"";s:32:"d43397341374a0279ea194279eb8973c";s:8:""auriol"";s:32:"e57150032e6feef1c935a381910b4c95";s:7:""13007"";s:32:"82363d59544f2b53e632210f580c6bc4";s:5:""bay"";s:32:"1a930d48458439a1d26664e0b91ff0c5";s:7:""70057"";s:32:"4b4698742a37fe998954fdab5c657d5b";s:21:""st-denis-sur-huisne"";s:32:"44b9d6c4004dd2f255524a0792a822c9";s:7:""61381"";s:32:"23e6a576c1edf2cee7b0797d6201b363";s:14:""mignovillard"";s:32:"247a006b4bd76c7826703b9ddf0321a3";s:7:""39331"";s:32:"a5a32745cb9fdec3ad8f904d5bb8fa3e";s:8:""allier"";s:32:"04122b582c9b9f664eb307279bf69424";s:7:""65005"";s:32:"58799f2d37f44da7546bc31307e2e65c";s:10:""st-salvy"";s:32:"97ee730cbf3596745081581353762f4f";s:7:""47275"";s:32:"8c4ddaa5cb352a531d9e4bab055df48c";s:9:""boulbon"";s:32:"e09d3023b013c8ebf26cd813b825e998";s:7:""13017"";s:32:"9ceb33c7f4244fa6f4fc88b9133d5236";s:15:""mont-l-eveque"";s:32:"89266b52238a64e5884f44155ccbd546";s:10:""graveson"";s:32:"13db2c2880ce73b8dbb3064abf069b4e";s:7:""13045"";s:32:"e795fa217b8b445763049f160ecd69b6";s:15:""faverolles-80"";s:32:"4f8abb8159d6e43c7964babb38bb0b2b";s:7:""80302"";s:32:"c9746a2915c2348dabf4c8b6b38ec63a";s:10:""st-pever"";s:32:"d0240e1dd6ce9ca788f8d805eabc7364";s:7:""22322"";s:32:"895732a5be9d34772593b530ff63c82e";s:21:""courtemont-varennes"";s:32:"97df397e05204d3f8d1b9000eb89caec";s:7:""02228"";s:32:"b48773f9df964186d2b5e2bfc5f120c6";s:14:""st-robert-47"";s:32:"87d0469b348245255e6a0df0c90566b5";s:7:""47273"";s:32:"2b935a43da798cf7ce5288a508d5cf77";s:18:""ventes-de-bourse"";s:32:"0f965f032356a5b8a3dba93c55cc462c";s:10:""puymirol"";s:32:"2c9cb031011d46d80206fb9463944290";s:7:""47217"";s:32:"d1c5cf76e257560ecf658382fcd44013";s:11:""esclottes"";s:32:"90abf6ff49d0b020d3156a27b4612aa8";s:7:""47089"";s:32:"215c67f292720b504ceb9f017de80c13";s:10:""devillac"";s:32:"cf0f73b4273d425cbf5b9b02ae6fd6ed";s:7:""47080"";s:32:"aca5dbb34bf04d30edd43b8161c63f7d";s:10:""oudon-14"";s:32:"e82543454c417afbead6e2616aff4b91";s:7:""14697"";s:32:"88dd79a75014f6f0839fa8a28afcf4c9";s:8:""ourdon"";s:32:"ca8c4569918548bbfb6b64e9c066eded";s:7:""65349"";s:32:"1eab30c00e805bff84258649a2431075";s:9:""marzens"";s:32:"60293706b2e517028d5584f82ec74421";s:7:""81157"";s:32:"7054c771fb2fad973655c7511b54766a";s:12:""defaul.php"";s:32:"84fccad98d6c617b067fb0ed473a1770";s:11:""ploulec-h"";s:32:"2f2ab36a429cfc1d5b6b0c972993cfe8";s:7:""22224"";s:32:"cbd4cc1083043e1243283ce8758ad2b9";s:10:""sancerre"";s:32:"389727b03a58191f9fba156eaabed100";s:7:""18241"";s:32:"e749d5e7aa8755759dbf69a55734ada5";s:11:""thauvenay"";s:32:"5f409d3373d648460c466afc32987362";s:7:""18262"";s:32:"993e2fb54a70645ce0b80c48a45e0de1";s:13:""artigues-65"";s:32:"318471314d57c062f6daf72037790c66";s:7:""65038"";s:32:"7e679857ea9f821b9fe31df817c7f1d6";s:13:""plusquellec"";s:32:"4e3fcc11f6d1aa33ac8c03dac297a925";s:7:""22243"";s:32:"a5408002d7fa481bffc2cf40d6e78386";s:18:""peyrat-de-bellac"";s:32:"f541374a9d27d2259a2b08d9ac873f61";s:7:""87116"";s:32:"9862eab5e2e0ff8c3b400dff1b28993d";s:12:""upload.php"";s:32:"78743dc980a53e4495e96089b35df248";s:16:""carry-le-rouet"";s:32:"3f5090678885942ce6c0c59f31b4d8c4";s:7:""13021"";s:32:"5c5c98eeb1bf6828de73aaffeb7c9196";s:7:""haims"";s:32:"8b442d531544d25440eef1c52c4d79bf";s:7:""86110"";s:32:"14fa7c60d5952e8e0778e8a2db20e509";s:13:""boulancourt"";s:32:"78201e6e288582154c43ab90c8fa90e1";s:7:""77046"";s:32:"0baaac97fc997daf8e293b2427464985";s:12:""taillebois"";s:32:"dd065a1e910cd2434d7df9167bd99c7c";s:7:""61478"";s:32:"c801ec09803ebe0e4ae2425acb49f579";s:8:""colmar"";s:32:"fe5c3e617219804684a85617ba123766";s:7:""68066"";s:32:"b9258125613ca93e9b87428acfc793f4";s:15:""marquivillers"";s:32:"9b2698b69df4816476f3361b9ecf4143";s:7:""80517"";s:32:"c5d34d422bdd2a29fe6a265a5d22fc99";s:14:""montmorillon"";s:32:"094db4f619e915067dcf63508a778c5f";s:7:""86165"";s:32:"73ab54ab1cd1ce51d14e18b82c4ea58a";s:19:""beaumont-la-ronce"";s:32:"b0af3275be53e2c984189d18519e4fba";s:7:""37021"";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:"325797a6c4139b10899da813dff5611e";s:20:""siorac-en-perigord"";s:32:"72a380527291b77980c4e71d6a320822";s:10:""st-helen"";s:32:"c690d9ca449555b2731087147edc2c6c";s:7:""22299"";s:32:"ef78c295ab47796e4818a26c72b2faf6";s:10:""plumieux"";s:32:"0537f5ff518f719b641d1ace4bb78c9e";s:7:""22241"";s:32:"ce844f9a5a84c47a6d09be38c503377f";s:6:""chey"";s:32:"6cd5ea8ccc6f038fca7b8f68e0c43cd3";s:7:""79087"";s:32:"9e6392f664d94d47bd14f306ef7b940f";s:7:""fumel"";s:32:"5a1d777dbc8d6beb8e15fb9f05ec3115";s:7:""47106"";s:32:"1f7888536140157ea538d64a60e00bfe";s:9:""barlest"";s:32:"bb780ede7f616bb5f4a2d6a15cbd4594";s:7:""65065"";s:32:"5edd4bc8f79f85449fec99bdf0d87de5";s:7:""moisy"";s:32:"c42e6a20c118bf9f85fc2de7d31ef877";s:7:""41141"";s:32:"0a1579615a7b64e123b7a7e899ebe6e0";s:8:""dondas"";s:32:"6821f3654e9bbba1ec7615fa5c608c9f";s:7:""47082"";s:32:"332d146404562215bf206a5b01b3d3bf";s:21:""beaulieu-en-argonne"";s:32:"ed872e63302a0dd5799a278f797a0a19";s:7:""55038"";s:32:"597fffdf8109bcc880768b7f2c5f6498";s:11:""ploubezre"";s:32:"7ebd2736b2f5562f1741be2af846d1e7";s:7:""22211"";s:32:"b5ed0ad89ab6f4bb674ba99d530ee098";s:21:""st-martin-en-bresse"";s:32:"f2a81e2ed6d1c8f3eaf586b2b4eea17a";s:7:""71456"";s:32:"f067813764d36af673e4549660548787";s:14:""rochefort-17"";s:32:"141da201e81dd6e9e39781f9ebb79c28";s:20:""tredrez-locquemeau"";s:32:"a7e05398ec807251a7653ff40ac99a76";s:7:""22349"";s:32:"0ddcd7de1d0cce8849674943dbc040e8";s:11:""lutilhous"";s:32:"42268e60a4658ae667ceb321c63d5db4";s:7:""65294"";s:32:"659b9afad0a0303af2170401e7773562";s:20:""st-ellier-du-maine"";s:32:"f4fc17cc297998d27735775ad2b480a0";s:7:""53213"";s:32:"7e65da889619e098fb6a127a829436ca";s:16:""lac-d-issarles"";s:32:"3aacfc0df590d5d5add810628f09803a";s:7:""07119"";s:32:"3ca2c086b8cb9febb64a6706f1630ed2";s:12:""magdeleine"";s:32:"30756510b04a8ca7b9dcbb711ab222ad";s:7:""16197"";s:32:"8e972d3d95fd1fa4088ce50edcfd5cb3";s:9:""cromary"";s:32:"0d74faec6154e0e74df36cce3e605dad";s:7:""70189"";s:32:"233d2e81e9d6f0c0e736965872da9a30";s:9:""marigne"";s:32:"22e87be320284d01deff019546fff177";s:7:""49189"";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"70a4a1faf343973daaf7a89bac3df075";s:27:"`Departement`.`nom_soundex`";s:32:"e6b58a6fd2dddaf18714b7433a8c7703";s:20:"`Departement`.`view`";s:32:"b74474e63c80be3416038fc312c4ea9c";s:28:"`Departement`.`presentation`";s:32:"aa3e4e25ef57c9a2187d8b8f38d66317";s:24:"`Departement`.`tourisme`";s:32:"58a859cc9ae1c3a16eba65ee4ba041d1";s:20:"`Departement`.`img1`";s:32:"8d1bfdd6c45677e3b05204c9cd512952";s:20:"`Departement`.`img2`";s:32:"f237f95c23798028c944020938923a2f";s:20:"`Departement`.`img3`";s:32:"f5807bd4b1e800229c1cfd99f42893f8";s:13:"`Region`.`id`";s:32:"5767ad9b0f3bcc5a12a47df58a8ab96d";s:14:"`Region`.`nom`";s:32:"976fd89e2c4c73a0e8f3638485c299c7";s:9:"`regions`";s:32:"e03a777181ec5a87bd0b60a2076b7467";s:8:"`Region`";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"b42b4c7247223233b0c5541183cc48a7";s:12:"`Pub`.`hook`";s:32:"592473832ad432920cfa4eb5718cdbcc";s:17:"`Pub`.`format_id`";s:32:"9da1d158b7b3f5102350b7a469c676c4";s:16:"`Pub`.`national`";s:32:"33308d760485ee8483eae282fc35be3f";s:13:""vielle-aure"";s:32:"e2beaccf440d3431782ae013cdf4c870";s:7:""65465"";s:32:"18d649e5260030c2d47e66bde6b43524";s:8:""ecleux"";s:32:"935652d4baf09bd3f5d93029cec4411c";s:7:""39206"";s:32:"577f8a9743a0402e19e7e49b159d9456";s:11:""massoules"";s:32:"73d390d99c8f3a2d9ee7033035d2181f";s:7:""47162"";s:32:"a36cc606270c171bc34b4c5a1c3deadd";s:22:""st-benoît-des-ondes"";s:32:"dd803df630e3a0da1a5f30dbfcf4a550";s:7:""35255"";s:32:"5be65ea9f749d8fe5714e313fe74484f";s:11:""calorguen"";s:32:"8432bc13f9b0aa0a346be59946be71e1";s:7:""22026"";s:32:"6adc093c37a38459150ee706243dd554";s:10:""st-rieul"";s:32:"9e3ae64fc9a6b20e813137e975438b5f";s:7:""22326"";s:32:"831052aaadf3c94320c3a8a836cacd00";s:19:""fontaine-couverte"";s:32:"7a9075bb2851db9bf54ddc91cd5fbed6";s:7:""53098"";s:32:"9579f027d2693177da4d5b25b803ca50";s:17:""borderes-louron"";s:32:"92fc0cc65627090e97fe8b0660e94496";s:7:""65099"";s:32:"8e307a66bed836f386d6db7ac9141605";s:7:""curac"";s:32:"cf7fc0342c7084d34ed753b2ca88f1ac";s:7:""16117"";s:32:"a12ea207b29d97b139213e0adce9ee98";s:10:""maillane"";s:32:"4d6a191a63e3f46b643722964d397e70";s:7:""13052"";s:32:"bb99958294387ffeaf7fbf0e6b652ff5";s:22:""ste-gemme-martaillac"";s:32:"bcc51a93f99a255fa163815c208328f9";s:7:""47244"";s:32:"77d84843e26687527bf33dcec245d870";s:14:""cazaux-debat"";s:32:"3c940c9e57f1046af579724bb6149be7";s:7:""65140"";s:32:"6efd2ec0d104c433f386ed85333bc358";s:19:""auzouville-sur-ry"";s:32:"b0f8adb1b67e8d745a51d99298a1f0d4";s:7:""76046"";s:32:"901cec35e131d1bbb34316e404e1b3ec";s:11:""st-desert"";s:32:"ceec80b5ba27857a362fcc1f3c58ba20";s:7:""71404"";s:32:"b622ceed5c0adcae7d47c897ea516503";s:10:""landehen"";s:32:"925fa240086ad82aad543f2020c8d7cc";s:7:""22098"";s:32:"af81a80da3d1f1a6876a5094d5772a69";s:17:""foncine-le-haut"";s:32:"99d9afe3f52f1dbaf9efc62b45413fb2";s:7:""39228"";s:32:"f7cfac285ad7f761cd9ecd15e6df9afd";s:7:""londe"";s:32:"6459a67bffdc2a562ee494d8dec5a267";s:7:""76391"";s:32:"8b196d41bb2a0e7f885a82c0cf7d8a76";s:9:""pluduno"";s:32:"b0361d2880473e2bc6a281450698d7ab";s:7:""22237"";s:32:"7030879fc5279ce7262fa248b87b58db";s:10:""sausheim"";s:32:"439d3da9c5a87479bb866337aaabbcfa";s:7:""68300"";s:32:"66adc614a11405a750ea4384b3ed53f7";s:9:""langoat"";s:32:"bab15ec784fa6bd34552d89ce1e28c1f";s:7:""22101"";s:32:"53b93ce7e96627433f3e7477d176870a";s:9:""bartres"";s:32:"caa2b3f8861c360d742e1ae26f6aa010";s:7:""65070"";s:32:"20b2544a2dbfd864f782faa687eb61c6";s:10:""douzains"";s:32:"0951132c782b3a4a2a332803d63d3a9b";s:7:""47084"";s:32:"7e6078803f2badf5ca3112c75565fb2d";s:8:""peyrun"";s:32:"c9d9ae0a460eab94a76b94ba356d8685";s:7:""65361"";s:32:"34789e579e374439e46109549b5fcdd1";s:22:""appenai-sous-belleme"";s:32:"25601051f6cf8261e3030b9087994421";s:7:""61005"";s:32:"3242e074993f01710227d80e7afca11c";s:8:""scrupt"";s:32:"af760910dd5a48b24d0ac5dbe9da256d";s:7:""ossen"";s:32:"0966be03f1e279726ddc2e0c54774808";s:7:""65343"";s:32:"d06e46f09e18b3c68d996740670b5c3c";s:14:""plenee-jugon"";s:32:"b6945a6594d55d28ca27a236ee3c1494";s:7:""22185"";s:32:"6fb42320eb9541e02a5b2d2d0c6c9a2b";s:9:""massels"";s:32:"c4df0c43085f986ad15c44247afe0e1b";s:7:""47161"";s:32:"dd0c53180620af86d138f86463976f47";s:10:""plouasne"";s:32:"6be71daf2d8105c61d57b2373e845548";s:7:""22208"";s:32:"2fdd5181926e65c0e4c38c23823444c9";s:16:""juillac-le-coq"";s:32:"7f6a20856341b10656ee9e34b28f2ad1";s:7:""16171"";s:32:"84f6c7d8b301e6844d966e25854ebb6b";s:7:""ivrey"";s:32:"82a7cfe8826435c225460c278e35636f";s:7:""39268"";s:32:"d543a46f40054cc9b403b9f882be4b33";s:9:""saligos"";s:32:"60fdd1ac2b6634bc84aaede855739689";s:7:""65399"";s:32:"c83c91425a05b31b687026ac6db01918";s:9:""cierzac"";s:32:"c44b324b0580c073cb3ed8ea292bcc53";s:7:""17106"";s:32:"bc2f34e639c5ea44bc2f3f16980e826c";s:9:""quillio"";s:32:"8512eb2520c5d981144f89625708fdd3";s:7:""22260"";s:32:"a9fc31abcc1f5549642cde88867df744";s:11:""quintenic"";s:32:"58a14f2bc185747083709f5ef19638ff";s:7:""22261"";s:32:"0e54d9bf20e78e53abfc879181d0185b";s:10:""ouchamps"";s:32:"d6d17d444d302cb9a517af3029eba7f0";s:7:""41170"";s:32:"95fda403f4ca552354e34aa87797eeea";s:20:""st-jacut-de-la-mer"";s:32:"c57d1290b5a295e7b77716d5c5b88262";s:7:""22302"";s:32:"aa75f9cff84ab3db3ecc480b51d41141";s:11:""st-lormel"";s:32:"bbbe4d5e536379fc3bc0e3077a986bdd";s:7:""22311"";s:32:"f445831db912520ccfd5e724e4166345";s:12:""allonne-79"";s:32:"569e1101dc31d80e160d3363c03309ac";s:7:""79007"";s:32:"4405e52368cd32189bb54e185c9cf787";s:10:""bruville"";s:32:"4fca8f9cfc1107470ebd7f2f40a18d1f";s:7:""54103"";s:32:"235ad36d68a5e7275d74315660119dac";s:10:""bours-65"";s:32:"4410d5e2a55551cbc31a656e8982f0c0";s:7:""65108"";s:32:"f8d1270b728a175f28180ba4b6f1d4f7";s:9:""lambesc"";s:32:"e5c7a4aa97087f19350c92245c70c67a";s:7:""13050"";s:32:"cd6ed5cc732bff84c17e4f2b58e978d1";s:9:""maîche"";s:32:"f6bd17a5fc7e36778aac6c4c0b0cf321";s:7:""25356"";s:32:"ac18dc58b38ad2418a61b81963c81f85";s:10:""sevenans"";s:32:"728e596cb5feec39ef9042fb1d03b3f8";s:7:""90094"";s:32:"c316431e68d18518b25416e82fbb75a8";s:14:""st-astier-47"";s:32:"40083c5a3a26f8753d78f0408a7b90c8";s:7:""47229"";s:32:"a5fd5b5cb11d0af84792d562aef915c0";s:11:""chef-haut"";s:32:"ef19ea4b0933fe4165b7bb3c721b8c4a";s:11:""marseille"";s:32:"11b076b5d07a480295a9ad216392596a";s:7:""13055"";s:32:"0e27e2b3e08a23fce86b1d095921203a";s:10:""fauillet"";s:32:"bd7c847fd9950b6ef96f23c5a69e5966";s:7:""47095"";s:32:"b85a60be85fbf9c65396033b7402bb00";s:23:""st-mitre-les-remparts"";s:32:"e737f01805a0c0df505f094a1dfacbee";s:7:""13098"";s:32:"6954b57f580473db058730de80d8646f";s:11:""montbozon"";s:32:"c67ea9698c7ce129820a2f2e60662043";s:7:""70357"";s:32:"73991500e4015e344ea32a9e7cb897ef";s:10:""eyragues"";s:32:"bc95ee33900f2fd9a6017a535c49ce82";s:7:""13036"";s:32:"bec9e59cecce08f864e40505f32802bf";s:21:""plorec-sur-arguenon"";s:32:"f72913937ead9ca1092bae02ec4db266";s:7:""22205"";s:32:"5f30fb115a2f10f29f0bb338cac46ee6";s:10:""st-lezer"";s:32:"2e025840bdfe0689468107cb345e8ee0";s:7:""65390"";s:32:"f3a7eef2903be3de0d280479d193b3d0";s:12:""cahuzac-47"";s:32:"bda274f04437f934156e1e33b2d4fd02";s:7:""47044"";s:32:"f990330844b05dd3f3edd0501abb1f0b";s:20:""st-aubin-des-grois"";s:32:"719cf46a0f135e133a4d6b4715b121f9";s:7:""61368"";s:32:"949b3eaf0b6ac3d76208d0c4fbeff3b3";s:19:""st-martin-de-crau"";s:32:"3ec02a4a8b7b5ec755ab10905d132c81";s:7:""13097"";}s:6:"fields";a:150:{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:"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:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}s:32:"8ee4e381878886a74715e50c607da897";a:59:{i:0;s:20:"`Etablissement`.`id`";i:1;s:23:"`Etablissement`.`siren`";i:2;s:20:"`Etablissement`.`rs`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:21:"`Etablissement`.`img`";i:5;s:21:"`Etablissement`.`pdf`";i:6;s:21:"`Etablissement`.`lng`";i:7;s:21:"`Etablissement`.`lat`";i:8;s:22:"`Etablissement`.`desc`";i:9;s:28:"`Etablissement`.`historique`";i:10;s:26:"`Etablissement`.`chambres`";i:11;s:30:"`Etablissement`.`restauration`";i:12;s:27:"`Etablissement`.`situation`";i:13;s:25:"`Etablissement`.`parking`";i:14;s:30:"`Etablissement`.`animauxadmis`";i:15;s:29:"`Etablissement`.`equipements`";i:16;s:25:"`Etablissement`.`langues`";i:17;s:24:"`Etablissement`.`tarifs`";i:18;s:28:"`Etablissement`.`supplement`";i:19;s:26:"`Etablissement`.`capacite`";i:20;s:26:"`Etablissement`.`categ_id`";i:21;s:24:"`Etablissement`.`adress`";i:22;s:25:"`Etablissement`.`adress2`";i:23;s:26:"`Etablissement`.`cp_ville`";i:24;s:20:"`Etablissement`.`cp`";i:25;s:26:"`Etablissement`.`ville_id`";i:26;s:21:"`Etablissement`.`tel`";i:27;s:27:"`Etablissement`.`telecopie`";i:28;s:23:"`Etablissement`.`email`";i:29;s:26:"`Etablissement`.`site_web`";i:30;s:25:"`Etablissement`.`partner`";i:31;s:27:"`Etablissement`.`full_desc`";i:32;s:21:"`Etablissement`.`fin`";i:33;s:22:"`Etablissement`.`view`";i:34;s:32:"`Etablissement`.`departement_id`";i:35;s:28:"`Etablissement`.`agregat_id`";i:36;s:22:"`Etablissement`.`pets`";i:37;s:26:"`Etablissement`.`horaires`";i:38;s:27:"`Etablissement`.`date_call`";i:39;s:32:"`Etablissement`.`recall_creneau`";i:40;s:28:"`Etablissement`.`convention`";i:41;s:33:"`Etablissement`.`convention_text`";i:42;s:33:"`Etablissement`.`convention_date`";i:43;s:29:"`Etablissement`.`financement`";i:44;s:34:"`Etablissement`.`financement_text`";i:45;s:34:"`Etablissement`.`financement_date`";i:46;s:27:"`Etablissement`.`direction`";i:47;s:32:"`Etablissement`.`direction_name`";i:48;s:33:"`Etablissement`.`direction_email`";i:49;s:32:"`Etablissement`.`direction_move`";i:50;s:32:"`Etablissement`.`direction_text`";i:51;s:32:"`Etablissement`.`direction_date`";i:52;s:32:"`Etablissement`.`recall_travaux`";i:53;s:32:"`Etablissement`.`recall_maladie`";i:54;s:30:"`Etablissement`.`recall_autre`";i:55;s:29:"`Etablissement`.`recall_date`";i:56;s:29:"`Etablissement`.`observation`";i:57;s:26:"`Etablissement`.`modified`";i:58;s:25:"`Etablissement`.`created`";}s:32:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"5ef5376c23915b319c95a55e27b463e2";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"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:"10987e9dd509339ca990c892dad3c715";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2667*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:"dcc3beabcec151ee31744fb435253535";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((50.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbb4049ff44acfac692ab12128a8ad9c";a:2:{i:0;s:71:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*";i:1;s:18:"`Departement`.`id`";}s:32:"14508adec7cbe5b6adbdc403d5a86e58";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}s:32:"460d24147c4186d7066a776f04ab029c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((48.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"7b5ef8b9d2b5f2260c04b475d89cf0b8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c2b5dea3860db439a0511fae9f642b65";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"080442d55a8a10460cb619ac2c8030fe";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:199:"(((acos(sin((47.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d49a81d459c2620ebff5ec4cfb361c56";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.0903*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0903*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.260278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1d433a92cd8fe1cb38e779af70713f24";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"788d59b99ccd903fd15e34481fc0d991";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3b44b9b6161857d93d39bcbf1aa867e7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.05*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:"3596de52f9a5377410e431ebfdeddd00";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bfdee05d000c6f90ec81015f23e887a5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4d95946039a824d22cebf9ca659abf78";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0ddba50a12a650b19081a44f50771c8b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((46.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7c006f3f16b2b7066a671be5bb2db7d1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*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:"34d07796324127dd2702a6394beffba8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3*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:"4d25ff76f341641eba82988ff6f0f9d7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1bad5e36aec24206768585b87878996e";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:193:"(((acos(sin((49.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"224102566d9fbd5eef71a6c7f40c2e0e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2524331920ebb676ecffdcf5c2c4bf1d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.6487*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6487*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.62056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f88e01b58f8195248fb3aa37b0ce54f7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b62b6aa9b54cb3449a8b6374f23c31c5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"040c21c106a4f9b6d5546caabd8a4b63";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((44.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f1a1195d394ef752a0684d46bc971d87";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:200:"(((acos(sin((48.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*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:"175afc7ced630c21a2dd7de20aeac06c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"527b186b34e316d286ccab0e49b1019e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e831902e559cede60c490cf758bc3339";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6*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:"c679ca6ec5a196abd15737d5d5163909";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((48.9678*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9678*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.0744444- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"919a5d249bf7051b919bfcce928dc945";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((43.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8e395c7316c3adbc7ebff1b012c4a28a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4d307fcf6b6a455e316387f8d4ca4292";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s: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:"93d869916b8ca0a765e709ad8e93e605";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7181*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7181*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.49556- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7e382698258eb724671a6f6aa235eb2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d0cf5f6e5986e39af04758b217010e94";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3d5d56d58fea76912a086d1d0d171e9d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((43.0748*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0748*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.0025- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc8fe401c6c7354560097f650413f9e1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b28e0feda8077410677f53a3c6902194";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2e831e071cddf5ae34045008decd596d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc4992cf700651bea169e8cc84b51c77";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5*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:"c7516fd87dc093071d6d266a16cd804c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f737d9d7bc4547a6423e0e6c604c1ecd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8*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:"5725b90e6ba2cf078f431e80a23e074e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"939123375722558fc5c1e12c51ab032c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((49.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c63aff4a1c4d7fc22344f8743f4c4559";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*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:"2a6883ba77a74b9c185647c77eb75764";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((47.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.666667- 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:"899dd3a9e4362b283d2722648f4a62f0";a:2:{i:0;s:386:"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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.983333- 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:"221c5a93256bd80cfae3dac1184b94ad";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"932c04a31108635d25d4fc4a2c65593e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((48.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"16fc171d0c971992bf5c7362ec0018f9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((46.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3*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:"38ba3aeb39feab0adf46a96c49ba168a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5*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:"d44f6070d90d92b6c05c711971dfe588";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((43.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.15*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:"8427ba97a091401d0ae8c939d1e9fe77";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b3e3d948f080819a177126e5b9bfe440";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((44.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*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:"53f60df53522408ef9eb374cdda648eb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"810bd946f78c87041ec3814e9d853589";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((48.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"59b19658d901f965373b6c1226403fe8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aed049b2454b5b7dbd59a1c1cef478cf";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:201:"(((acos(sin((45.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*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:"1e15385166503b1dcd6cd93b6cea8e50";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((48.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6aa5b1dc6f1ab3767b2fadb626fedb32";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1333*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:"c2191b38f553eb2b93c9bcdb9e1ca8ed";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*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:"29e69707d04a9270505724c128a59899";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8209*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8209*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.06084- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2f174c22870b01567bf27cec102ce3ec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9a8398ffe68b2d96e3c5ad47576a5759";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4ca797019a5b333d32f644b306f17ee8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((47.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e95a8b28a89acf3c35ecec05ce1e8678";a:13:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:24:"`Departement`.`tourisme`";i:10;s:20:"`Departement`.`img1`";i:11;s:20:"`Departement`.`img2`";i:12;s:20:"`Departement`.`img3`";}s:32:"3fece0e910f4aa12809ad5fdf460149a";a:2:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";}s:32:"2541e02a8984576ba212eab20c302b2c";a:5:{i:0;s:18:"`Departement`.`id`";i:1;s:19:"`Departement`.`nom`";i:2;s:20:"`Departement`.`code`";i:3;s:20:"`Departement`.`slug`";i:4;s:25:"`Departement`.`region_id`";}s:32:"26b854aececdcc92884bb15e85b005db";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"67d7e85f70f2b142470864afe2f60177";a:2:{i:0;s:13:"`Region`.`id`";i:1;s:14:"`Region`.`nom`";}s:32:"4cc1d818cf2f1495c414f8b3bf55739c";a:6:{i:0;s:10:"`Pub`.`id`";i:1;s:13:"`Pub`.`title`";i:2;s:12:"`Pub`.`link`";i:3;s:11:"`Pub`.`img`";i:4;s:12:"`Pub`.`hook`";i:5;s:17:"`Pub`.`format_id`";}s:32:"b93b06faaf8b5f3c7cb6c1639669cbc7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((42.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8333*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:"bf485e4e8edd7b3b50c5460fab1fecc0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((47*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f56f5064ef353e83918668984eb640c3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.883333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc7aec713fd0b93e44fe5dc70991b6e2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((48.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6167*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:"5c94eb8f1f6e45e9142dedd7e299656a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4103*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4103*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.97111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0729671cfb2de32b9aae82b8d736a8ff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"85c42033c4f158a0c34f62a963bb824b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*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:"f703f28ab171f21e34da0a7f9b6737ce";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((42.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8833*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:"964c2ac4458220f27edddaf356820722";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"97f70a0c927ea5220e25482f872f3161";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f098d2292f9cee4fb91c61bceda69f9a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"25f15cfe3418a9166c6f79cf1487197f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((42.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2197ce0c7827186ed6abac2b54df725f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d01702ef56c71c191dfb038bb716fd89";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((46.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e69b5ccddd07f8f5dfe2f6e9c229750";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"04740c4f5c848b1bd6d33a7a61e9d76d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8d099d19bd3c05f6235880cc957f58af";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((49.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3*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:"34591f74e5cb0f385c09bc108566f3c7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5333*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:"cc8e07393bed4c0b4d743cc94ae5d87d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ebb0962f350f47597cdb1321d75ed50e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a8c4ad26becbe4a4cd38efe3d2dedbd5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((43.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b5cf90602f9a28d5825393abd05628e4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"157467420e9051c75f3602f5e912c8d6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((43.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3333*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:"94efba2b8c9964b409716afd992b214f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.35*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:"e3b8f8e0ed0ec28bba8d4ae306f60239";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:199:"(((acos(sin((48.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"109482774bb06cdb70a965b19ed849df";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((43.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0667*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:"16ef21d75320972126e795eaf6776f09";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e1ed9206c6bdd199949febd337b622f7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3167*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:"32300783fba4cfeed368877879f42d3b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:188:"(((acos(sin((48.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"644b38a69dddf0b135678f86732d8e54";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.266667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"664557ad1685f670493dbe62c8c99069";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c7dfc09e97a03586b71bdba13595d2c4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((42.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f0cd3f6af64d3ea85a5a4485dcf9c61f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*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:"743f327957a1b51b152982feb30d7bde";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5548e9466d2bd28d84e39dfe61d24d56";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"899807554cd18cd0129343826db1ca10";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"827d1ee521e328c3c5fd409b2825c807";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eb6f6c80a75ab99b19853a359e07cc3e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.55*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:"e5f3c053c4428b3c775b6a660f635cef";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5833*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:"d9dc5042b30c1f14f89247df5796accc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"31dda42dde9af3a0a2607c78113b42f6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*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:"da67eb82c78c65e1b5a50009404db673";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ed41283f82081f7b6fd42060587e4d7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"595a2e9bea09b0d37fe094ffce0d2a5d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"581d62f3ddc69d7bf9e39041446ede25";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.725*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.725*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:"fededed14998c33855c948c9f0191f57";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:195:"(((acos(sin((48.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5b9d62781f4b2552d5a30ec34fa822b7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.2967*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2967*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.37639- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8162aa2a55d14d5bb55072ddf942339e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4167*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:"3c6415427fb832b52a6d3527721d8fb3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bcccec557300f7542f6455cae907c81d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e408af4ca132874275cdfb7c04be5d3c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4902c6fdc10621793af4b36d9226b552";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b98c153353fe0cfb3eb88120cee8874c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aca2180dd6a3f77a60ee4b14c653bf5c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b0446cfa96ae752199d1e9a279803848";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((48.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.65- Ville.lng)*p'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::name() - CORE/Cake/Model/Datasource/DboSource.php, line 925 Mysql::listSources() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 232 Model::setSource() - CORE/Cake/Model/Model.php, line 1168 Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686 Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053 Model::find() - CORE/Cake/Model/Model.php, line 3025 VillesController::toiture() - APP/Controller/VillesController.php, line 129 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 111
Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/dansmaprovince/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]Code Contextsetcookie(
$name, $c['value'], $c['expire'], $c['path'],
$c['domain'], $c['secure'], $c['httpOnly']
$c = array( 'name' => 'CakeCookie[autologin]', 'value' => '', 'expire' => (int) 1738728762, 'path' => '/', 'domain' => '', 'secure' => false, 'httpOnly' => false ) $name = 'CakeCookie[autologin]'setcookie - [internal], line ?? CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458 CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 174 [main] - APP/webroot/index.php, line 111
Pour le bon entretien de votre maison, l'entretien de votre couverture est essentiel. Pour un nettoyage de la toiture à La Barthe-de-Neste en Hautes-Pyrénées (65) comprenant démoussage et traitement hydrofuge, nous listons actuellement plusieurs entreprises dont voici le répertoire ci-dessous pour le secteur La Barthe-de-Neste :
Le climat tempéré favorise la croissance des mousses, des algues et des lichens sur les toitures. Ces organismes végétaux peuvent causer des dommages structurels et esthétiques à votre toit. Le démoussage est le processus d'élimination de ces envahisseurs. À l'aide de techniques spécialisées, les professionnels expérimentés du secteur La Barthe-de-Neste enlèvent en douceur ces mousses, garantissant ainsi la protection de votre toiture contre leur retour.
À La Barthe-de-Neste ou Labarthe-Rivière, Villeneuve-de-Rivière, Barbazan-Debat, Soues, ... dans le 65 plus globalement (Hautes-Pyrénées), l'humidité est l'un des principaux ennemis de votre toiture. Les infiltrations d'eau peuvent causer des dommages coûteux et accélérer le processus de détérioration. C'est là qu'intervient le traitement hydrofuge. En appliquant un revêtement hydrofuge de qualité sur votre toiture, nous créons une barrière protectrice qui empêche l'eau de pénétrer. Cela non seulement préserve l'intégrité structurelle de votre toit mais aussi son apparence, vous offrant une tranquillité d'esprit même lors des pluies les plus torrentielles.
Pour vous accompagner dans la rénovation de votre maison à La Barthe-de-Neste, 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 La Barthe-de-Neste 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 - La Barthe-de-Neste
25 avenue de l'Église 65250 La Barthe-de-Neste
05 62 98 21 32
Selon vos revenus et les travaux envisagés dans votre logement, l'ANAH Hautes-Pyrénées (65) peut vous venir en aide.