Notice (8): unserialize(): Error at offset 74460 of 74466 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) 1738770700 $cachetime = (int) 1738770709 $data = 'a:3:{i:0;b:0;s:4:"name";a:403:{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:"b43e12546d1d6a786426c191ae09869e";s:20:""st-martin-des-bois"";s:32:"5bd91b5e75b0ac3aba5c268289d18e14";s:7:""41225"";s:32:"51522fbfdd3d804e3513cba5f68bc97b";s:8:""drubec"";s:32:"bf43154225f19c3b4758fa04bee736e3";s:11:""eyguieres"";s:32:"f64acc6ed0aac353fc6a83085612dc1e";s:7:""13035"";s:32:"dab6ae959ae3447d97a2b7a33668b822";s:12:""pelissanne"";s:32:"a8c77cfda4405ace2cb4f6871e662ec3";s:7:""13069"";s:32:"a89765872c38df8aa27bdd411937cb12";s:10:""lugagnan"";s:32:"3456a4fad0c98a13ae3e6ee4a07f9a3c";s:7:""65291"";s:32:"f8e920249ab6e2deb52d467763145dc7";s:19:""blanzy-les-fismes"";s:32:"4e0906c4d27279437ddc687d008e4211";s:7:""02091"";s:32:"c5870361a9273788555f1c6ee76d9a1a";s:7:""gabre"";s:32:"305d383cdb07e40ea8dc85d793387ac5";s:7:""09127"";s:32:"e6014ee68a1b9bce8395a7220523dcd0";s:17:""vitry-sur-seine"";s:32:"76b16d69dbdca30e05311c809ab019ad";s:7:""94081"";s:32:"df44a38206f6b6916f4ff534b9233bfc";s:6:""viey"";s:32:"d56cbbe850fa49533de16475a3a61ed4";s:7:""65469"";s:32:"91a266b6d8339285940ebd578eb871df";s:20:""st-michel-de-feins"";s:32:"4ea275b374b9905d70a32f1c89cca737";s:7:""53241"";s:32:"31914fe4c25474f507ebe54669a1fa7f";s:10:""gieville"";s:32:"6af2b4507dfa530d9bf151154a2dd465";s:7:""50202"";s:32:"0a032d91aa86b0b52595547715a8c59c";s:10:""hamel-80"";s:32:"45e28725c8e8a6ad0f4f74234c4468cb";s:7:""80411"";s:32:"ea4db766bc438791629242a8571aa0b8";s:10:""allinges"";}s:6:"fields";a:133:{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:"ba5891ed2bc9bb3ea841a8c096546dd0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*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:"6c000dbe30f609b15e72f5cfb896b95c";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:196:"(((acos(sin((49.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.25*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:"0130ddc9ccadc03d3ad1a684bf04a5cf";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((43.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"319eb13fc34848070a8cb28786b700ab";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6333*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:"b3da4f2bb799ee9b867dea576a85628e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((43.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.05*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:"2de35847f744bbb411409bf46bebd456";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9ab5480a0e65ac19da7cfd49e0d2a5bd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bee554e802a494183b8ca26523d65e81";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*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:"168e63006db61109ced0a8dd14d868ea";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6c28eb187ec74eda2f598b281a754d07";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7833*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:"fcb5d2d9f8c607d4512897d18176c930";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*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:"95afd5b6440815c4b994dbbc989549b3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"75'unserialize - [internal], line ?? FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194 Cache::read() - CORE/Cake/Cache/Cache.php, line 363 DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828 DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658 DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171 Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053 Model::find() - CORE/Cake/Model/Model.php, line 3025 VillesController::index() - APP/Controller/VillesController.php, line 14 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 111
Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/dansmaprovince/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]Code Contextsetcookie($name, $c['value'], $c['expire'], $c['path'],$c['domain'], $c['secure'], $c['httpOnly']$c = array( 'name' => 'CakeCookie[autologin]', 'value' => '', 'expire' => (int) 1738728700, '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 la recherche d'une maison à rénover à Labastide-Castel-Amouroux en Lot-et-Garonne (47), nous comptabilisons à ce jour peu de résultats dans cette ville.
Maison datant des années 60 en centre bourg de Labastide-Castel-Amouroux, elle comprend 4 chambres, 2 salles de bain...
en savoir plus
Situation géographique : Agen 44 kms - Villeneuve-sur-Lot 48 kms -
Dans cette commune de 307 habitants, installée en Lot-et-Garonne (47), aucune agence immobilière. À noter que 3 biens ont été vendus durant l'année passée (2020) pour un prix de vente moyen de 1801 € / par m², une indication clé dans votre future négocation immobilière. Vous voulez en savoir plus ? Consultez les agences immobilières locales.
Vous habitez Labastide-Castel-Amouroux ou dans un secteur proche et vous avez une maison à rénover à vendre ?
| Ventes | Prix € / m² | |
|---|---|---|
| 2019 | 4 | 1188 € |
| 2020 | 3 | 1801 € |
| Évolution | -25% | 51.6% |
Soit une hausse significative de 51.6 % pour le prix du mètre carré à Labastide-Castel-Amouroux entre 2019 et 2020.
Située Chasteou à Labastide-Castel-Amouroux, maison composée de 3 pièces principales pour 128 m² sur un terrain de 1800 m² - Vendue 178500 €
Située Enclos De Maupas à Labastide-Castel-Amouroux, maison composée de 5 pièces principales pour 125 m² sur un terrain de 1731 m² - Vendue 218000 €
Située Reche à Labastide-Castel-Amouroux, maison composée de 4 pièces principales pour 95 m² sur un terrain de 100 m² - Vendue 215000 €
Située Gravillon à Labastide-Castel-Amouroux, maison composée de 4 pièces principales pour 110 m² sur un terrain de 1645 m² - Vendue 75000 €
Pour vous accompagner dans la rénovation de votre maison à Labastide-Castel-Amouroux, 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 Labastide-Castel-Amouroux 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 - Labastide-Castel-Amouroux
Veyries 47250 Labastide-Castel-Amouroux
05 53 93 19 06
Selon vos revenus et les travaux envisagés dans votre logement, l'ANAH Lot-et-Garonne (47) peut vous venir en aide.