Notice (8): unserialize(): Error at offset 158135 of 158325 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) 1738774629
$cachetime = (int) 1738774638
$data = 'a:3:{i:0;b:0;s:4:"name";a:716:{s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"abfe790023ff0d1611edcb6dfce6802d";s:14:"`Moyennevente`";s:32:"c1955c45da499f15d5021c8c72d79c2f";s:26:"`Moyennevente`.`codeinsee`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"3c8d21fc2164772cb7201fe48deb9396";s:15:"`moyenneventes`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"e98730f90300942f7658578869727a4c";s:12:""lamasquere"";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:"32b8d28d89e5f9feed7a144f382768d1";s:7:""31269"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"4980ed713520c53a5ef7bfe59bfe3568";s:14:"`Mur`.`pseudo`";s:32:"5df22fc0ee63f77314a59940fedac466";s:15:"`Mur`.`contenu`";s:32:"78f75bec59f89c734ad73833bc56b727";s:14:"`Mur`.`posted`";s:32:"f0a34e9f16b52b8585fb8852c455febf";s:6:"`murs`";s:32:"025bf5e280fa1a5abe6649e1e4de4e90";s:16:"`Mur`.`ville_id`";s:32:"aeb9c0f91b83d19a86e2de9383c8aea7";s:16:"`Mur`.`validate`";s:32:"9d1b58c9bf83bd6b146c7059e2971034";s:5:"`Mur`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"359ac070c703c6225869362821552643";s:11:"`Annonce`.*";s:32:"40afeb1c40614860e01d0748c5f553df";s:10:"`annonces`";s:32:"8027d37245b611a3fbdf14a1e89d8f29";s:20:"`Annonce`.`ville_id`";s:32:"404f56ef6af3757e2e643f86960284d3";s:18:"`Annonce`.`statut`";s:32:"f95ddc2be023960209cb5ce5f087ddbd";s:9:"`Annonce`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"9e1d9110347404e406234081e6860946";s:12:""courtemont"";s:32:"ad0bad1d8ba77cde0514c9844e3d4cf3";s:7:""51191"";s:32:"e1d51633d24f19696d618bbda8ae8642";s:10:""quartier"";s:32:"f1b891900701cab29f2d3370bf6f5081";s:7:""63293"";s:32:"128c448ca4417e416719743e81bf9419";s:6:""youx"";s:32:"3a69f78ab7c2005df56d449e0e13c6ad";s:7:""63471"";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:"234056bc02405f1484c1d182edc2595f";s:22:""st-julien-la-geneste"";s:32:"88bf149b9c8ce4efd65e9a1c0bf68a54";s:7:""63369"";s:32:"750b1c47ab88d20bfb64742387725c6e";s:9:""pionsat"";s:32:"4a33f415146d08b1bac3608262f251df";s:7:""63281"";s:32:"fb58afa3d5843d6b1e1509bbe3a46700";s:15:""gouttieres-63"";s:32:"10bf07ceb81eadb44e7e4a9db9a9bf34";s:7:""63171"";s:32:"e1c1295a78d9e07bdba7f6b50a4351bd";s:14:""espinasse-63"";s:32:"14f2e3ba95b6da5c52b88ab05b04934e";s:7:""63152"";s:32:"65fe2662c6aae70e1f1d457a294c7bed";s:8:""manzat"";s:32:"bcc8281ca6d3c4f8d9ff355380cb4f5f";s:7:""63206"";s:32:"68c977840be752839dfa8eb2dfa9d1c2";s:7:""menat"";s:32:"e2a97c27966dc0f75a5714248a198a22";s:7:""63223"";s:32:"d1cdfb79113f4224069d8c27c4352242";s:24:""coulouvray-boisbenatre"";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:"4148d0cea28f623b91c94ef91324ce43";s:23:""chateauneuf-les-bains"";s:32:"817789a5b458410637871fa2e2656dbf";s:7:""63100"";s:32:"07c95f600536b1778cec3d6982e3e9ba";s:19:""louroux-de-bouble"";s:32:"a620422cdb2eeb5cc28f19ea19eae980";s:7:""03152"";s:32:"73a1ecd4459c2e2174597d2564493ef5";s:9:""servant"";s:32:"5089c0e80164ac936a4f22c7d783bb05";s:7:""63419"";s:32:"0f329d03880f29f11f56c6a4ad629f92";s:6:""bert"";s:32:"3b6120233767ce76b2e7fb96027b50b4";s:7:""03024"";s:32:"74716f329e53a5033fd2801421ada313";s:19:""barrais-bussolles"";s:32:"61032582534aa9414cce38d2d56e4a12";s:7:""03017"";s:32:"7905dee4a9c7fbd57647259f016137ea";s:8:""donjon"";s:32:"679b4d3c70ac4a58324a9e2a7f3444e1";s:7:""03103"";s:32:"f6d91efb65accd8f2a49c644a36b014d";s:19:""monetay-sur-loire"";s:32:"eaa6e592f73f8b1dba7fd94cd6175742";s:7:""03177"";s:32:"83242abb10d075813e12c2a8b1509ff8";s:8:""pin-03"";s:32:"345968492d89a679d2b29011c2e0c708";s:7:""03208"";s:32:"a83a120a0ea523d6546e3d9a1cafb3da";s:9:""chagnon"";s:32:"c59f854492c40536ff9ccdafd09b0257";s:7:""42036"";s:32:"1229e39de16c90a1294b7928d3b1f1da";s:9:""lecaude"";s:32:"c28bdc3dad7379db96e4cc1190522fba";s:7:""14359"";s:32:"af7146e3595cb3ddd1e500c456b0caa5";s:9:""chauray"";s:32:"f1634da84d85717f69d52b5aa2ba0da2";s:7:""79081"";s:32:"90b7f129e0c7507448dab1883b1266fc";s:18:""st-ouen-sur-iton"";s:32:"517568df71640cdde5a5504f35166635";s:7:""61440"";s:32:"153e1c06b23469895d33d6d67a2dbbd2";s:24:""st-pierre-de-bressieux"";s:32:"01d2f1c54ec6b7b248a3d1123c8f9408";s:7:""38440"";s:32:"bd9eadda5a72f073a5b26965e1d5ba99";s:13:""st-leger-17"";s:32:"48ce094a3cb9abc1b44d3ed572d13d3c";s:7:""17354"";s:32:"9bf420e10a72818d853b4f991c8d67ab";s:10:""nantille"";s:32:"41ad38ecd86555da63b7a8205aeb7774";s:7:""17256"";s:32:"9a60611becb8eecd9d30a0d784570291";s:10:""plumelin"";s:32:"a77881460f92ffc9eae229d7b57e79f4";s:7:""56174"";s:32:"f067813764d36af673e4549660548787";s:14:""rochefort-17"";s:32:"c53ab888ccfa8c923497166706a59e71";s:7:""17299"";s:32:"3e4c1a21e367a806214c342779fcd1bb";s:11:""bocquence"";s:32:"f88ded23dc326fb220f560e9a9f13d84";s:7:""61047"";s:32:"6ca5940897dc4cb62dc995e631059deb";s:9:""couarde"";s:32:"1667c1e0fa9b33c9a88796a657344e46";s:7:""79098"";s:32:"c394628e15000ed4ae1bbf7119a7fc5f";s:11:""aumont-80"";s:32:"57cc08d155149f3880f5a7a53da61ae8";s:7:""80041"";s:32:"e5ce8504b2e73516f043c97089cf628f";s:22:""heudreville-sur-eure"";s:32:"17819114a87e33808d50776913afdc3b";s:21:""andrezieux-boutheon"";s:32:"f3a5ad32dcd9512de4523405c9e39c7c";s:7:""42005"";s:32:"60258506a309866b19ababb174efbfa4";s:16:""herqueville-50"";s:32:"23525a34cc24c59acb66d58ee7c3beb9";s:7:""50242"";s:32:"a76c9bfad315957d6ed1dd7096841d87";s:9:""tourbes"";s:32:"5b37ec471ffef9d14326f8182ae496b2";s:7:""34311"";s:32:"dc58f6fb080e77d0af1a6c002acd8693";s:12:""bartenheim"";s:32:"a5da3a03d9875b8dd15d07d56b40ff54";s:7:""68021"";s:32:"31646b814a9970eece034821d2bea6cb";s:11:""fleury-50"";s:32:"53d2d9b9bee86d205ad5d99512637fe3";s:15:""chevrieres-42"";s:32:"098cb302063cf58c56f8ea0c84a291ad";s:7:""42062"";s:32:"d062b8db261746730959a8b9a5951e60";s:20:""chatelaillon-plage"";s:32:"8b06b583028bab6bb886c4f872e559bb";s:7:""17094"";s:32:"918749a558450470c85a93cd7ff42211";s:8:""mauron"";s:32:"e972bffc745f98778c7ee0a9c86143d0";s:7:""56127"";s:32:"35c2bef75444cf3d048e27aee96b3a78";s:12:""sorneville"";s:32:"2566c83e097c931594e0714f22e4bee3";s:7:""54510"";s:32:"d7afe0ea56aee5aeb59b3db31c1d4cda";s:10:""leimbach"";s:32:"39ef7478916a4ae2559d6661464c3750";s:7:""68180"";s:32:"9991e3a52e8c02508958e94bb068cb03";s:10:""st-vitte"";s:32:"5d498c2b167bffe0ad65af5e79d195b4";s:7:""18238"";s:32:"23d3a5eafbbf1a6feece5ec16262241d";s:13:""vieux-thann"";s:32:"1ee7f141a1d1a5c875564b659757c909";s:7:""68348"";s:32:"96233eb7b23a32f577a190ae7450ded6";s:11:""steinbach"";s:32:"f895436137c10a539158c3aa8267fa62";s:7:""68322"";s:32:"838b73dd1aa5908c53a1766d1323dd78";s:20:""st-mars-de-coutais"";s:32:"fca5d89bcdf8aeeb95718a056eb8523b";s:7:""44178"";s:32:"d995a20fe703d9c0b293287023e70a6e";s:23:""st-christophe-du-luat"";s:32:"8d7de9db367de1c843c93f3035ad69b3";s:7:""53207"";s:32:"1c88d799434b36a6085c4b2b06291acc";s:12:""balagueres"";s:32:"50778d0ed72eec65d5d1c44ff0443897";s:7:""09035"";s:32:"a88497b63dc85a541fecdedccc6befe5";s:14:""lavaufranche"";s:32:"f52968646064d4d0f400243a509f9241";s:7:""23104"";s:32:"9d45fe9422c57ff50b04b224e645c84d";s:11:""jettingen"";s:32:"84eb0fe80a8e74d3636a79718f85667e";s:7:""68158"";s:32:"5d61b6c5fe8e25b0e379335435b69870";s:15:""berentzwiller"";s:32:"87fab80003e16241f742ac5d9ab8373c";s:7:""68027"";s:32:"2010fa95c39d2b3444fae27d7a95d03e";s:8:""willer"";s:32:"4b5d89d6252d0486af5e97a0f767014d";s:7:""68371"";s:32:"e15a1936e9718bafb54fcc4ee871d948";s:9:""chandai"";s:32:"0193d086890dbfd238aa3e32a26d36d0";s:7:""61092"";s:32:"6288f27c01c496b2d9e2e060111db7ca";s:11:""meyenheim"";s:32:"be5ee7bdb2eb3609962bd517f181f5c6";s:7:""68205"";s:32:"a9b39551b3969362af5aae077f9b6e52";s:14:""niederentzen"";s:32:"c2ac0fd5d0da17fa0f019a72552111eb";s:7:""68234"";s:32:"f2e2c7851153bf87826c3a26fb9f23eb";s:12:""rustenhart"";s:32:"2d419ee02720f1d5bfc9cfd46a305ff4";s:7:""68290"";s:32:"f14babea98ed024d9d0f220f537b67b3";s:12:""perigny-17"";s:32:"dbba19a15172287e6acd24fae39c48f0";s:7:""17274"";s:32:"e5d7a5cfeb648023b985b71ab9b528b9";s:12:""oberentzen"";s:32:"de5d1a9abfb97d69415e90b5b2300208";s:7:""68241"";s:32:"bc4b8d0273379c657790fe710ae31067";s:7:""herre"";s:32:"f6be19d7115f35d5364412f63e74c517";s:7:""40124"";s:32:"f1a4331d5c4900de9a7b3636be9cbf6d";s:10:""chalampe"";s:32:"9e680a05833881582a8e1c3f3138e737";s:7:""68064"";s:32:"63956166bf5b080d280ba8e9b36be33e";s:10:""hombourg"";s:32:"24c0fe3899adf68a43852188b1fda335";s:7:""68144"";s:32:"8c5a4e9924f500fd675253ee6aa54ec5";s:13:""ottmarsheim"";s:32:"ed1bae376c35e0e504151b106484658b";s:7:""68253"";s:32:"37bc0ee14e7d66fd9af0f5580ebe8cf8";s:23:""st-martin-de-la-cluze"";s:32:"e0422901330c0fcd0eec4eb312bdef34";s:7:""38115"";s:32:"aaeda6b2cff4ddf1afb1b825460d5e1d";s:10:""voyennes"";s:32:"1323f668f7c3addca99772b09b007e5f";s:7:""80811"";s:32:"a6ab16bf586c5a9ea8292e607abf8492";s:11:""nambsheim"";s:32:"1da0e91ab6247cb56b58cd432cbca5f5";s:7:""68230"";s:32:"dd2de9817107b681732fbfb441b2b164";s:13:""feuillie-76"";s:32:"8fc86d1133a6343b8a47e86323a03820";s:7:""76263"";s:32:"77a00a3baf5c0b4a7432f4d59f3e1a26";s:21:""vernosc-les-annonay"";s:32:"050a84133227fa259c9409b34161541d";s:7:""07337"";s:32:"2364cf8ac748841a1f4ca43d9b5d1d46";s:11:""bergholtz"";s:32:"524d300e5cacbeaad2658f208fa9d8f0";s:7:""68029"";s:32:"2c79b87889a6f64791ac3dc3a2171927";s:11:""orschwihr"";s:32:"1e3f2aa3b30e5b86a4fda2907bce4d41";s:7:""68250"";s:32:"8ced7f6fa186b1a6e182309477924547";s:18:""villiers-couture"";s:32:"7e18a1412462460f4c32ec7379160111";s:7:""17477"";s:32:"a676c19e7ed0061decb4d98ccf0eb0ad";s:10:""montchal"";s:32:"1d2f552216df7bb410fe762ef3b2e5d5";s:7:""42148"";s:32:"722c579351e092ab1a6a249d40aede7d";s:12:""westhalten"";s:32:"aa40ef30e69d5e8db2c6e3b29c02ac9a";s:7:""68364"";s:32:"d35c101426462fe2a27eb708b3809fbe";s:11:""jungholtz"";s:32:"9bdef7980d8bf762786512fead232a7f";s:7:""68159"";s:32:"a572a3538563a5c4db9951d6dd634e37";s:18:""soultz-haut-rhin"";s:32:"fc5bc86e1e6dc191d806607772fc9080";s:7:""68315"";s:32:"228a4d63257f10f0730871794eff247d";s:13:""wittelsheim"";s:32:"3eea8c3a242a68e267c93ef47421e942";s:7:""68375"";s:32:"6aa99b7ad86099c31407f086126a6b81";s:12:""wattwiller"";s:32:"36d5c36b28d6e9acd69f8ea386f48b7b";s:7:""68359"";s:32:"5f4be2eda1a2a06f4f8eadd140b3c54b";s:21:""st-vincent-sur-oust"";s:32:"db381bcb22010bcd2f67305292e7f920";s:7:""56239"";s:32:"3a99b9de3e585cd8d97b5e582031575c";s:15:""croix-hellean"";s:32:"25c3de18bdc6c24776a984c4152ffacf";s:7:""56050"";s:32:"e2b13d62cf7af256a14d14ad2f292c26";s:12:""rochepaule"";s:32:"c9929734cf6f401eb01a2670d8a6b809";s:7:""07192"";s:32:"03234be24752c899eb63402cd51875c2";s:10:""besse-38"";s:32:"2dc688d737e53a7022a3335055054133";s:7:""38040"";s:32:"515f0bdec3315e2edaba845314be3f2d";s:12:""geiswasser"";s:32:"dfe9cbc26948a681545643887708fac4";s:7:""68104"";s:32:"ee2977a830a132033b99881ce931a4cf";s:8:""caromb"";s:32:"694e4da2135fb59761c1d0d338ea11ea";s:7:""84030"";s:32:"29fba0975c7e34eaa5084ad1046461ed";s:8:""dezert"";s:32:"9ee78cc766f2c75350751b54b0b8b9d6";s:7:""50161"";s:32:"0bff489a104a39a623bce4a649dadd63";s:14:""neuf-brisach"";s:32:"4ade580c5ea532b96a7a21b2c6e48528";s:7:""68231"";s:32:"0df6d24e8b5e32e8dc6f7129dfa726f1";s:11:""biltzheim"";s:32:"9ae1a67090a5b30440ff13221575d042";s:7:""68037"";s:32:"273fac009d04e704b0b9017fd5bf703b";s:19:""souffelweyersheim"";s:32:"8d4fbc6861cb595706a888245beb4536";s:7:""67471"";s:32:"7043bd71c1f760992d4a5d863c28b6db";s:17:""ferreux-quincey"";s:32:"5af8900c167093f4a95cb188f4cc7a18";s:7:""10148"";s:32:"4df1db9efb224f2f58d03727bac82f2a";s:10:""ambierle"";s:32:"158df01cefaf52cc0ea0e9f961dd924a";s:7:""42003"";s:32:"fc05d1bb5c3eac7babebd09c9c2e09ab";s:11:""kolbsheim"";s:32:"0ae5f0ebf95eb434c40853196d60c995";s:7:""67247"";s:32:"a3ee24287977ca6aee44b297f4907819";s:20:""st-aubin-sur-loire"";s:32:"ae91341474f043bc13e2b6d31cd0803d";s:7:""71389"";s:32:"56f31c8345793c5165a6f768acc74db6";s:20:""chapelle-en-lafaye"";s:32:"ebbc2cd08446d23a6b40eec8ce6adf2c";s:7:""42050"";s:32:"e5a769dd05d54bf8acf541d77f8ff42e";s:20:""villiers-sur-chize"";s:32:"d025d571cd23c67be76c11f67d175192";s:7:""79352"";s:32:"c0352c29c7e4cfcaae51d32f29a02d23";s:13:""mundolsheim"";s:32:"9401478dad8c04b19e1ff9b91d5e54e1";s:7:""67309"";s:32:"518ac56da66a0222a1dfd4d071e3e7f6";s:9:""perigne"";s:32:"b8a5a50d4fb768902b12f625388860dc";s:7:""79204"";s:32:"ebea1074cf2e4315c19742b5ca18a031";s:9:""mirvaux"";s:32:"50341d391a320d1d9aa4461317b38bee";s:7:""80550"";s:32:"42c359fee9a522a6a5e01aabb31292bf";s:11:""dingsheim"";s:32:"b2e8c671b5bfbcfabf4bf90030d0d1ad";s:7:""67097"";s:32:"08ea8a696db2bc9433aa667637462001";s:12:""baerendorf"";s:32:"5a839521b7ecd332aef5f618b9c73c66";s:7:""67017"";s:32:"40c06f9390e58db848f947ade316aaf0";s:20:""breuschwickersheim"";s:32:"02098a0ed7c203d77faa4c156a6fdf02";s:7:""67065"";s:32:"0d408d32f1cca4704d74db588c40b2c0";s:19:""st-gal-sur-sioule"";s:32:"702b905f9277dfb443e44f3e02f28ee2";s:7:""63344"";s:32:"1d2ba15c186ab1fcf74910eef31435b8";s:11:""ittenheim"";s:32:"fc878ea1b62ddc8685c4fea8a78f2b49";s:7:""67226"";s:32:"e9d2362d456c3d28fb8be278edb82e03";s:12:""st-aigulin"";s:32:"ab552c084b80f528a596ee875d88bbfd";s:7:""17309"";s:32:"c099ee025d2f84652ef433458237a60c";s:13:""roudouallec"";s:32:"7063ca0bc94bd4ca432d1191b44a2328";s:7:""56199"";s:32:"0ba801130ed29cf466760eed8121231a";s:12:""limersheim"";s:32:"ef3ddd6cc4f19da980c56e2b4088d4ef";s:7:""67266"";s:32:"c087aba9ad36de368d261a575aee3809";s:13:""duttlenheim"";s:32:"d6345cdde57693c63124c6544c11ce48";s:7:""67112"";s:32:"991ad9a4a9e5a86913029d4ac44bc5a0";s:21:""angerville-bailleul"";s:32:"abdf2509842fc1aa5c507c5698e6aca9";s:7:""76012"";s:32:"56760a15b915467c2fa8e0b067291e96";s:11:""trelevern"";s:32:"879e523382b3befae170304be45e91e0";s:7:""22363"";s:32:"3c5994325597fcc175cf35f0ac7e5a5f";s:19:""ernolsheim-bruche"";s:32:"fd673f819929e1e10096b1108475520b";s:7:""67128"";s:32:"4fbe6b722f2c52707005ae54f9d4b04e";s:23:""putanges-pont-ecrepin"";s:32:"747c9ef381cb6e1a1aa7deb58cc7df44";s:7:""61339"";s:32:"96f45da689e2c5c5d30d86361083ab0b";s:12:""reichstett"";s:32:"ecb4d93ee5cfcc2ffef3eecb001b2cfd";s:7:""67389"";s:32:"9576d413deeeea6851037c35305594b3";s:11:""grivesnes"";s:32:"850abef6bea27bb369694fb8d6e0e292";s:7:""80390"";s:32:"e1ccce5f96308c3834a7d667fe055ab7";s:13:""eckwersheim"";s:32:"cfde917bc16d0d289e54be9411856ade";s:7:""67119"";s:32:"504caea4a3fae10ab90aa324b703ce46";s:9:""salsein"";s:32:"55dd9801e93dd0a263ac433fd4055d81";s:7:""09279"";s:32:"e37efd8eb10530ea57c9f4fb0f712f7e";s:11:""langoelan"";s:32:"1e1e2227d5e2a42c780006b5959375d5";s:7:""56099"";s:32:"20962fd4a4151dd7f2c0bfee514ad47e";s:7:""oison"";s:32:"babf1a95c9e98b9860001da13a1b0a86";s:7:""45231"";s:32:"8dfa709484d4e9cbb83e2f394e2912c9";s:14:""locmariaquer"";s:32:"3153c2fb13a413822d94c63f375f4376";s:7:""56116"";s:32:"6309707833e01e938d375771208ff314";s:21:""bussac-sur-charente"";s:32:"1384b645e788057460f61e389d12e12c";s:7:""17073"";s:32:"484926c5b74d804965f2e5fb115cf1a1";s:11:""sommereux"";s:32:"8ef9f77e34d16a99d8d7e75b7bf5b9fe";s:7:""60622"";s:32:"708800baaf3fe0f74852c3477d85e26e";s:13:""clevilliers"";s:32:"52c4705ea75808be5d75fa3394465003";s:7:""28102"";s:32:"44c3cb2e1985946acb222fd08f74d935";s:10:""arconsat"";s:32:"ee16bad7e7728d55eec43d3317b299d0";s:7:""63008"";s:32:"ad33ef52f24a4f16474168fd2c51c9a1";s:17:""lucenay-les-aix"";s:32:"8498766ec85791a4fe4456043bf7cd31";s:7:""58146"";s:32:"4ed04be4f43552bdb17d4f15c691b56e";s:7:""potte"";s:32:"ecb67755699ec629e4ce819719ee7470";s:7:""80638"";s:32:"4a3bd1a0fcd56a417651dee38ac9cac5";s:14:""handschuheim"";s:32:"095ca9605d2e918f041fae27395021e0";s:7:""67181"";s:32:"1cfd6b014280e7943c42c097f82e2946";s:11:""st-gelven"";s:32:"b84f0c96e5f35b239210675b5110ee57";s:7:""22290"";s:32:"26154679699ed5171b303a3e94abcaa6";s:12:""furdenheim"";s:32:"8f13b4552875469567a0ac2a16c20b58";s:7:""67150"";s:32:"6b8cc2f04197dd2d3520732a233aa9e6";s:10:""ristolas"";s:32:"eef9e96d73726cece1843a7abb85e536";s:7:""05120"";s:32:"3e71437363184b32cc0974063ed7d495";s:17:""aurions-idernes"";s:32:"9479c766406d68240f1debc0e856b50a";s:7:""64079"";s:32:"4fcf481cc1b04a544ede9fb391dab652";s:20:""st-genest-malifaux"";s:32:"80f74b3760dc5cb198a8bc799adce854";s:7:""42224"";s:32:"50f2f4d76a36145b451ee04fa9ed19fe";s:25:""griesheim-pres-molsheim"";s:32:"b346b8260d312753434bf956f6d6e4be";s:7:""67172"";s:32:"b41a597d775471221ce2d208898fce19";s:10:""fressain"";s:32:"4013d50063bdf8847274e01357b533ba";s:7:""59254"";s:32:"cc5b0b30f682742789c4df3b29f16fda";s:9:""arradon"";s:32:"8593947f6b38d19c2c47a25655f3a623";s:7:""56003"";s:32:"ed372ab4e062776521f181d780978d1b";s:11:""squiffiec"";s:32:"cc3fb7cf744b276e1b0f68abf6d9be76";s:7:""22338"";s:32:"6ff257ff811e9f1e57b38627c22da5ac";s:12:""sigournais"";s:32:"6b6adbb418956547d70b13601297436c";s:8:""buleon"";s:32:"324838c0705a95da71ab6e6817ccc004";s:7:""56027"";s:32:"8e3ff7db8dedbcda7555265237701615";s:12:""st-servant"";s:32:"cb9d01b56a8e41ca479b31c617b9c9d8";s:7:""56236"";s:32:"a3b3b426bc8ca57fef4a492564e7ba74";s:19:""st-julien-d-oddes"";s:32:"fdf197134199f878fc6ec9bb4fc43baf";s:7:""42243"";s:32:"a8a0179eaddb84b29ec1bf955f5db320";s:8:""hoedic"";s:32:"fa0e296061eb1f78ccda48336032632c";s:7:""56085"";s:32:"4af27b14e544ba587b6f884e30ef7cc0";s:10:""murinais"";s:32:"4dd59ebc040afb3bd00d6dd440406570";s:7:""38272"";s:32:"fb6559445061a2c6df32e303c0e17534";s:20:""margny-aux-cerises"";s:32:"ba34592f609424973569060aed848bc4";s:7:""60381"";s:32:"033eb05b6b66ab8a07b4cf9a043ec003";s:18:""molliens-au-bois"";s:32:"cca519554261dd761ae082014f7ba236";s:7:""80553"";s:32:"d7dad374a9d9e4cd2525ee841a99e7cc";s:9:""beaufin"";s:32:"8ad08d89713663f918aad0604a8f3c99";s:7:""38031"";s:32:"99eff80dfe50f87596255f15376d52aa";s:9:""melrand"";s:32:"f367e441a58ec9a14cb040850d0a8fd1";s:7:""56128"";s:32:"549bed36bd84cec12edd65f0eaa56a42";s:12:""viricelles"";s:32:"fa5333cf95db4ae87433e5b5405345cf";s:7:""42335"";s:32:"afc96238f5cf66cdbb431b06be805553";s:12:""batilly-54"";s:32:"308efc9b1275bad98f3b5914a060cd9d";s:7:""54051"";s:32:"4dd173adb06d1088c809550c7f98de96";s:13:""tremeven-22"";s:32:"8922b734261055fa5c21c831d5819dd1";s:7:""22370"";s:32:"d35ee5c8451dd143ad38f79087509f48";s:9:""mousson"";s:32:"02fcf75a4e8c942deaf4235c734d8646";s:7:""54390"";s:32:"e586513c378ce567c561f8523e574e31";s:9:""peillac"";s:32:"442c447964895c5951bf898ae8fa1106";s:7:""56154"";s:32:"3af9f4017c29a5bf1563ce32c8e70788";s:9:""treogan"";s:32:"6d3eb7b2eff55d09ee81d4ac1571f44d";s:7:""22373"";s:32:"dbecd4025ba9c1ae5fa165798ec07f1b";s:12:""st-chamond"";s:32:"ba31487f4a2978b29d81c435fe5f2c10";s:7:""42207"";s:32:"c17309bcfed3c28657bbe00f58da7b97";s:22:""st-julien-des-points"";s:32:"dcae18854980d799f1a34c38c9af7b45";s:7:""48163"";s:32:"3c586511d79b66d321408c6397883a94";s:9:""hellean"";s:32:"e936a8675a70a88a1f58dfaa51446042";s:7:""56082"";s:32:"05f7ef2cc0fa686ab6e715e42758693d";s:9:""meauffe"";s:32:"ba0138ea41545c14acc8523c7c7f1426";s:7:""50297"";s:32:"eaf9f1a23e545fb781552b157f08d471";s:13:""lande-patry"";s:32:"ef5c4b81819d4e0c43f9cff77b3f1ef4";s:7:""61218"";s:32:"50d12315f4daed3770b5c667a811b231";s:18:""creon-d-armagnac"";s:32:"3750f1de78f84ee86856936eb1593515";s:7:""40087"";s:32:"be57375f77de26b50128ac3d84529916";s:8:""lothey"";s:32:"dc0e1c93183e6f98714200aa82644f09";s:7:""29142"";s:32:"91c960d204bb787498c5358fec4418ab";s:10:""treguier"";s:32:"7d248e007d74fa51a3fc57043081f5fa";s:7:""22362"";s:32:"1a7f679a5c0e4e4b8b5d5d631e8dc304";s:13:""lezardrieux"";s:32:"0d7e12eab9c04cd72bd4af4f719b1040";s:7:""22127"";s:32:"e9ee546a11708e4f893454f0991e3617";s:23:""st-genis-de-saintonge"";s:32:"f330eb41bf47c9359299c4d7b8346561";s:7:""17331"";s:32:"302d0887b02a1a7a82e07ba8e6f83036";s:21:""st-loup-de-buffigny"";s:32:"05d298f3ceb01e05430c97a7d5bd081c";s:7:""10347"";s:32:"6ec471059b14b56022ae65b5b53d3bc9";s:12:""rouffignac"";s:32:"8a866d3e415d7899d3ad6de8bdefc2e6";s:7:""17305"";s:32:"0eba3ff942ab872699179d7feeaeb7b0";s:20:""montrond-les-bains"";s:32:"cfbc2f9046901b11cda662c0b15530f8";s:7:""42149"";s:32:"d49a983b558b5d79915ae65b2f546d79";s:11:""chambilly"";s:32:"ebd55fe8c648429d059987df873db106";s:7:""71077"";s:32:"d9d6a7ccfe14f98d8b6cc676b344970e";s:20:""elbeuf-sur-andelle"";s:32:"172c77efb7a6d32ff0daadecef309ade";s:7:""76230"";s:32:"8559438da44efbe2c5a024a23c3a5ca1";s:15:""champgeneteux"";s:32:"816e2dd398aea31b3428eaf204b506cc";s:7:""53053"";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:"41da324f85350fcc7441299b5508b82c";s:7:""ciron"";s:32:"28e5100bfb88434dcf6dc0d1280bc0c2";s:26:""essertines-en-chatelneuf"";s:32:"91b68a11fd8a1f9512972fe48e0af1cb";s:7:""42089"";s:32:"04950d2706efa5952ce7bd3718ca804d";s:18:""cauville-sur-mer"";s:32:"f1a622c6d4fc291c9e176b99eecb2e47";s:7:""76167"";s:32:"b8732e2b7b68e76aef5124180d972ab8";s:10:""chadenac"";s:32:"8f35cd458f8e0e22606e0feaac524569";s:7:""17078"";s:32:"fdea9758dbbd5270a0b1a3a2c2f1d34f";s:12:""saussey-50"";s:32:"cef0992d1756194d0b78d0d863d291f5";s:7:""50568"";s:32:"398c9321cebce0cf676f71510b835413";s:12:""lesigny-77"";s:32:"63abeae7d35e2ccbdc75f7b0a501dc51";s:7:""77249"";s:32:"808ddc1a2932c9bc653843c45381eacc";s:10:""jumieges"";s:32:"5e41aec361eb66031500774d68fc0a08";s:7:""76378"";s:32:"46316fbc53358cb6b4afa5d313c50456";s:9:""coux-07"";s:32:"145e7f9bb044e918c9d94fea6f1c0492";s:7:""07072"";s:32:"7d312eecbb041b1bdc80a9cda91359b3";s:11:""bordes-71"";s:32:"11bd105b9a728de214db1aefc11f9df4";s:7:""71043"";s:32:"c0d0e996894d56d44209ee68505b71aa";s:11:""lantillac"";s:32:"e7732a50c59e89d5792d3c7d81026b6b";s:7:""56103"";s:32:"70b7cf5209356d75b479d9bc9f704d57";s:11:""lussac-17"";s:32:"00eb504ef7de9bcba2efafe237e2f9b2";s:7:""17215"";s:32:"7b7560c2cb80c9bb1cf1ff935f218c98";s:27:""varces-allieres-et-risset"";s:32:"be343d78e214f22430efde5281d61608";s:7:""38524"";s:32:"6bdf4a614b5a00eb5808ae6e24da7427";s:11:""epouville"";s:32:"7a3d469bb8b9f64c903abbd728e79b04";s:7:""76238"";s:32:"1257303dfea0bdcda412abc2e0ec81a2";s:13:""herbitzheim"";s:32:"2c497bcbc021c18f617aebab3ae7912c";s:7:""67191"";s:32:"ed31a61c54e42623709b625d47e10cc2";s:17:""st-loup-lamaire"";s:32:"eeaa59c3ecddf227841a220f4085877c";s:7:""79268"";s:32:"9e6c8fdc93210422773985cccc524909";s:8:""combre"";s:32:"3b9c3e88607f103a666c0e23bc4ed98f";s:7:""42068"";s:32:"65a58fbca37496286759e0adb6f8cde9";s:23:""st-nicolas-de-la-haie"";s:32:"79e7b2a17c504859af3edc00bdb3ae0b";s:7:""76626"";s:32:"c6856f4f36bda29b6d045c8c55fb267e";s:21:""st-georges-d-oleron"";s:32:"84a76ac1c335e567ae71dcf3a3195201";s:7:""17337"";s:32:"838d83117434a19ceb96eff9f22d8d6b";s:13:""wildenstein"";s:32:"50d2c38f0a741c7448f03d519258ffd9";s:7:""68370"";s:32:"bd8226beb29dfeccf5253b3dbb2ac286";s:13:""monterblanc"";s:32:"cc72e311f361533f8019bf0ec1cfb093";s:7:""56137"";s:32:"560423624d1fde2c207e12a9a7c17fb0";s:12:""romazieres"";s:32:"6ace1bb2a3c3b7fc8b358a647aa589db";s:7:""17301"";s:32:"53b22deb201a60809f85a27dd0d8937d";s:8:""plevin"";s:32:"96694f49308f397771d8ae4a9bf84ccd";s:7:""22202"";s:32:"a556ea484528589390777ad96568521d";s:20:""chapelle-pouilloux"";s:32:"0feb6086a6e1ce4c28f8b5e941df7cb2";s:7:""79074"";s:32:"55899e9a02c6321fbb698089dd448e2a";s:26:""chatillon-sur-chalaronne"";s:32:"aa8787d6a6df0a6e30851e388c10ac30";s:7:""01093"";s:32:"d400c52160ea08f8a237ac665fa9c185";s:20:""marcq-en-ostrevent"";s:32:"eab68c9142ed8f54c15373473c19e1c2";s:7:""59379"";s:32:"c93a44ae7b22b05c1dd4f0805c5dec8d";s:11:""trefflean"";s:32:"0f5f422664c6dea3313535cbe097c06c";s:7:""56255"";s:32:"0adbdac0a2ed1ee55e22742f827fabc5";s:12:""moncoutant"";s:32:"f306ec61d49866d3a9ea2669fa3257e5";s:7:""79179"";s:32:"40e639cb7ed79ec6d7874ab2036b4165";s:8:""chives"";s:32:"7546c687aac8b0c9c4c5d7f8a3346094";s:7:""17105"";s:32:"54ee53e9ad03d2e9a0cce3854d17f859";s:13:""fontanes-42"";s:32:"03d0b78a221e9854a69634df6b441e07";s:7:""42096"";s:32:"90a240ddad1ecc6b68e916fb9a4a775e";s:20:""anneville-en-saire"";s:32:"d4a5f1411d9a4ff097339b422c9c2de0";s:7:""50013"";s:32:"3747d21d1775528050b1e9b37993d7fd";s:19:""st-pierre-le-bost"";s:32:"8046830238628945c2168034f64992b8";s:7:""23233"";s:32:"29a18f1e5d82340fd2b90c3c9f936185";s:12:""vacquieres"";s:32:"9b9a09e257aaf64dd8ca1dd365804ae3";s:7:""34318"";s:32:"5b683f17ba99ec712a235dee1bf10bc8";s:16:""roppentzwiller"";s:32:"e3c98910b9f3769bc194a6808cc3f74f";s:7:""68284"";s:32:"bc2899c2ddba6845d21bac8cf74b7945";s:8:""bessey"";s:32:"27a3d508a6875a0b98000287e428dc90";s:7:""42018"";s:32:"82770619bd4b7a15440673b2383c8c46";s:8:""thaire"";s:32:"403e050ed40505b27b1602122fa574c5";s:7:""17443"";s:32:"542a7a4cc0577bc8ed3a2ce4e4909c69";s:10:""oberdorf"";s:32:"2ead189a63ed18742713effc529059b9";s:7:""68240"";s:32:"5e98f3e3582ce036e2c44eee297e72cb";s:10:""montroty"";s:32:"78d7105d6073e7ff8530faf18be9c9e3";s:7:""76450"";s:32:"7992ab0ede68014ee2ebb67e2269cec3";s:11:""hirtzbach"";s:32:"a2662893da27dbb5888cfef858c43baa";s:7:""68139"";s:32:"40433401afc49700ee0ddfc32c8c998e";s:11:""hirsingue"";s:32:"e64f6ee788245b6bb7a948089888d821";s:7:""68138"";s:32:"692ea9c630d6ff8b16bbe701b1845cb8";s:7:""arces"";s:32:"bd40f76455c385a8ce15990f5f7285f0";s:7:""17015"";s:32:"186237d81cd4f5a71c8b4c7fa490c3c2";s:9:""thou-17"";s:32:"cd41f86b7d6aee4b7eadc2647c75493f";s:7:""17447"";s:32:"c1b44b6c5762100630eb59fc5970eb75";s:20:""chapelle-en-serval"";s:32:"523bf279fbb254d858ce8a8d18eb3756";s:7:""60142"";s:32:"1535ae74652b671990eaecd318173655";s:17:""st-hippolyte-17"";s:32:"59deb02048bc7f7e85466153e832d1a3";s:7:""17346"";s:32:"b12b43d11962effba1c45716db63b848";s:12:""amponville"";s:32:"92f95ccbceb232785393bf7b15e49aae";s:7:""77003"";s:32:"fd9e9e4d5cf77c797dc67704a0873b94";s:22:""conches-sur-gondoire"";s:32:"124e9279fa3f7bab8053dcfd90793097";s:7:""77124"";s:32:"953dfce50b2f53dbaccdb40da1eaf696";s:9:""porcaro"";s:32:"b21b91bacba057d48bfd6aaa8aa727db";s:7:""56180"";s:32:"1f5423ea9e8c68daf606527f8f0298f3";s:7:""gelos"";s:32:"3e04499f8525f8f41cced52375c7ae25";s:7:""64237"";s:32:"3e9305392788027c922edc95a68187fd";s:7:""mably"";s:32:"e95724aef8dcd4b1554d42a8d224e570";s:7:""42127"";s:32:"7afd1f062d2389c7ccb1c8b118f92d70";s:18:""barre-de-semilly"";s:32:"8e13e14c05b0412b82e30c465eaeb726";s:7:""50032"";s:32:"f8b116cf78c3703e9a5cffebdc506eb2";s:9:""nostang"";s:32:"b2da784da9b2aa1064fd575e77c69c06";s:7:""56148"";s:32:"ee77306574bb6f0b234838af096fafa2";s:11:""thenac-17"";s:32:"0b2d883e77b7e9ed03e56d8be99a8af5";s:7:""17444"";s:32:"08d7e2e41897da5333923d86efc16e35";s:9:""authiou"";s:32:"b75f965a92cb8ba56604815786116354";s:7:""58018"";s:32:"0fff712eecc7da219c21ff983edbef80";s:7:""arzal"";s:32:"701fde1f1e5a7b6a90e5b628f65f001b";s:7:""56004"";s:32:"cc72d4c720ad03e23f252876d286dca4";s:22:""rechicourt-la-petite"";s:32:"f0718ef09685117813ea239659f62913";s:7:""54446"";s:32:"6dd94f63e8f4799ac6e4a680eb912c26";s:10:""larchant"";s:32:"fc256e00fc975fd010247106455627e9";s:7:""77244"";s:32:"648a0fb391bed2e17b13f704f2ccf91e";s:16:""vandelainville"";s:32:"f78dc4d2617907b451af37ea1ca7b748";s:7:""54544"";s:32:"000db2981b34f188965cbe27c33adb11";s:10:""bouin-79"";s:32:"33ceb2dab504d6f4e1f8326e87076858";s:7:""79045"";s:32:"8a4c7ecc5f47136efc79235c44a7ae41";s:15:""salt-en-donzy"";s:32:"9108115613212a57c5280a936e48b5de";s:7:""42296"";s:32:"dfd7e3c491564e99a01f8e30e9dcbdcb";s:19:""st-just-la-pendue"";s:32:"eb83c5a0137a6a52c657da5052081d09";s:7:""42249"";s:32:"5cb57b7c03761946ed4cd4255072f0e1";s:7:""rivas"";s:32:"9f9c2c526b9d4dbf8eb1063dc9531142";s:7:""42185"";s:32:"b6710894e23900598665d4cdd7cf49bf";s:23:""puygaillard-de-quercy"";s:32:"b8f9f226e4c55a8a66de34c7049ad23f";s:7:""82145"";s:32:"dfb2b2b0308d59b06f3609378ee15a55";s:12:""villars-42"";s:32:"0a01b43cd5a847f9ac6909ec572fbbe7";s:7:""42330"";s:32:"1a385d1b64bb2ce004cbe16a789d0d22";s:11:""champigne"";s:32:"f7b60e56dae864bf19bc62905a0e07b8";s:7:""49065"";s:32:"a151f1ddbb020c752f0f1eeeac40041e";s:13:""alboussiere"";s:32:"52cec7b1c515027d1b11cddcd0348ace";s:7:""07007"";s:32:"17b0a901b34ed19adf6a9349b2114a20";s:10:""llagonne"";s:32:"626d3f7d697398df5983b2ef020661b7";s:19:""octeville-sur-mer"";s:32:"816054132e856fbcec5355686ed965ba";s:7:""76481"";s:32:"b6bdabec5ef4898e4fa6f79a2770f3c7";s:11:""parthenay"";s:32:"eed674b16800dc51ad314532dcbd9cde";s:7:""79202"";s:32:"b0869b607298e9a4a191d4f8c7896b7d";s:20:""perrigny-sur-loire"";s:32:"d69b626bce16af735fc3927af5df4953";s:7:""71348"";s:32:"682e9c82bfece1dacce04130058ade67";s:10:""bataille"";s:32:"5ac74425f28699120b7a256f720eb357";s:7:""79027"";s:32:"5c14edb335bd623d6e90d7110eb4b820";s:14:""st-porchaire"";s:32:"ff95f4c0073d20ee62bc97164390156c";s:7:""17387"";s:32:"70d63b32268715d9295ac6bb323aa7d5";s:10:""cordelle"";s:32:"02243f5b9a8629ac826f0690f6df29f2";s:7:""42070"";s:32:"03a1d1b76652998551c0f66ba4a42b67";s:19:""ste-croix-a-lauze"";s:32:"06b96369d486232bc64ce798f4f33947";s:7:""04175"";s:32:"4b9c2d30e08821905cf3d8b6c910d00b";s:20:""st-gilles-les-bois"";s:32:"d2411655cc7108f63e67b8262e04954d";s:7:""22293"";s:32:"643475b699d561e621af28f1c4b93088";s:13:""chazeuil-58"";s:32:"7d8f574546476be1360b0509f12d4bbb";s:7:""58070"";s:32:"248de055bfb27f8c3f213ebbf339774c";s:18:""chaumont-d-anjou"";s:32:"2df3d59dbb5eec27d7b3bf544aebcc1e";s:7:""49084"";s:32:"861a5d83e5071bbc94bb677fb266dd16";s:11:""vallee-17"";s:32:"ef0ee1b0be6f553f1e9de6e95bbe343f";s:7:""17455"";s:32:"6a1892e32d66268132e91f09daf16216";s:12:""gourfaleur"";s:32:"e19a04a8296dc9f3fbdf5ecd0d31fffc";s:7:""50213"";s:32:"e07cd5664aef395a06c5f856e8efd1c3";s:10:""billiers"";s:32:"ac1ef7afe61c8fd20603d537fd7666ec";s:7:""56018"";s:32:"2a38bfe3fb12091cc1bfbb196080f150";s:11:""dehlingen"";s:32:"3b4775aa2cfce29aa989f606f07a0f92";s:7:""67088"";s:32:"ddad4d1f2bf116cacb7ddb996f38971e";s:23:""st-vincent-de-boisset"";s:32:"29bef89de3158e36b1e70f283a15ec28";s:7:""42294"";s:32:"a6ce284d635400134e969c50647918d7";s:7:""menou"";s:32:"43697a4a31ac89bf1b70c77d454e7592";s:7:""58163"";s:32:"0b4573b5165ceae26d35bdad294d1d6c";s:15:""chevrieres-38"";s:32:"15a6075874dcd375defce8a924499813";s:7:""38099"";s:32:"fd45313c11c2b00488e7eba308d4db2e";s:7:""donzy"";s:32:"5a9cdad00743da2310b5a1220c159bd4";s:7:""58102"";s:32:"ab2c5824dfab6b83cd9ca9ee6656c1c0";s:12:""st-ferjeux"";s:32:"e4251d1ba81c49992d0e2c4f775c2bb7";s:7:""70462"";s:32:"120ee6fa6f36ae304004402a4f14d0a8";s:7:""oudan"";s:32:"e9ebe69d59a9c7d29592c7794d7781cb";s:7:""58201"";s:32:"3475327c148687eafb0490dbbd2e8886";s:16:""aisy-sous-thil"";s:32:"76d44cac0acf563f6c30e34786388275";s:7:""21007"";s:32:"fe75b6ac260652c5ef692fcdc6e259d9";s:8:""locarn"";s:32:"d72960b9d569a0bca49cf689d31fae5b";s:7:""22128"";s:32:"797f284b8326eb70ff09eb5370d72f21";s:12:""ploufragan"";s:32:"c4cc2869a249bba29c39ba914bdc37f9";s:7:""22215"";s:32:"ee1dd6e1379753ad5f200f32b07c0d61";s:20:""blainville-sur-mer"";s:32:"988d9f43cd2e4bcf8dee22afe78affa6";s:7:""50058"";s:32:"4c9e7afa2041c94411f1c806930d7748";s:7:""guern"";s:32:"30317129db2694bd109a96827f8bfc0f";s:7:""56076"";s:32:"039102858f842894ecd53b62169a6f6f";s:18:""brehain-la-ville"";s:32:"465755f0510256be8b33d2e902e63c85";s:7:""54096"";s:32:"81331a5451422f872b738eea274e5201";s:21:""st-pierre-es-champs"";s:32:"a8e3af3563dad3bdfe2d80c906e2c4b8";s:7:""60592"";s:32:"7b48c7ba6987fce7056b44daf506be29";s:21:""st-georges-antignac"";s:32:"101acbdac5a38ef415151bca4b0f5ae5";s:7:""17332"";s:32:"ee4adf7cd1e3d81d055a1e40791d4599";s:10:""malansac"";s:32:"2d89d51643dece88a3cdbad1b155454f";s:7:""56123"";s:32:"7ba19daf98f10e1fcb0b04b5bf3179ad";s:14:""st-medard-79"";s:32:"e946a8a5465f6efa74de9cd335b7f2ca";s:7:""79282"";s:32:"f7b6edbb64d206603aa642d7bdaf0738";s:7:""unias"";s:32:"fed6351448af209053b3118d5ab227b7";s:7:""42315"";s:32:"aaff0852ee3ffb9446a473e80d26f1f2";s:9:""marnans"";s:32:"721b7a15bcd608e2367cd229537fb4d5";s:7:""38221"";s:32:"dfed4a3acfe7fc286fdd67e3af85ed26";s:16:""herenguerville"";s:32:"c742c65670755d24f53e313dfcaf1029";s:7:""50244"";s:32:"dc7692bb9c50e05369dca3a4ffa34e11";s:9:""burbach"";s:32:"112007070a42f3a60065639e96d9af35";s:7:""67070"";s:32:"7a07602ee25c615e4a1f699293f949e8";s:20:""st-thomas-de-conac"";s:32:"98ecf07a9512b761162c1c8c6f7db4d3";s:7:""17410"";s:32:"32b66a56e5603f049e80a9e86798fc83";s:10:""nivillac"";s:32:"23c1292ed4cb3771af03cc3b6031b3b4";s:7:""56147"";s:32:"66e8ac731a29a3c5f379a8e9bceb1b08";s:9:""quintin"";s:32:"46b4019bfd790690c9cd55922bcff10f";s:7:""22262"";s:32:"8e0fa8d4074c3cee84e8758474ab4fc6";s:10:""juscorps"";s:32:"3290967d8e8c42cfa013d3b155a2da93";s:7:""79144"";s:32:"db9cf3aaf366448aba7bfe1799371c02";s:22:""chailly-sur-armancon"";s:32:"9bc9f01b4c1db00360625c7d5bd5fed3";s:7:""21128"";s:32:"d9bced568256c794adf3c7983fb89828";s:10:""champien"";s:32:"201f9b893a4e67431eaa45268848fb00";s:7:""80185"";s:32:"8eafa1951a438dd03804db6f73a62b46";s:13:""chatellenot"";s:32:"e6fc6d98ffc2a49d4df1fba67b823231";s:7:""21153"";}s:6:"fields";a:291:{s:32:"0776bc5a07b6293ad7a608503c8f0fbb";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:52:"(CONCAT(nom, " (", code,")")) AS  `Departement__lib`";}s:32:"6ebd007b29cf065d538dcc3a7c4187b9";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:37:"(CONCAT(code)) AS  `Departement__lib`";}s:32:"d56346cbc1a9c1c07ecb6f77d7298a85";a:2:{i:0;s:87:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*, Moyennevente.*";i:1;s:18:"`Departement`.`id`";}s:32:"0ab0e11802732f4801804b133b98019d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}s:32:"1ac2a7de1032f79c4b8218c21288e0c1";a:3:{i:0;s:54:"Etablissement.id, Etablissement.rs, Etablissement.slug";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"c4fd98c43562097d790d7e33c74a05f1";a:3:{i:0;s:14:"`Mur`.`pseudo`";i:1;s:15:"`Mur`.`contenu`";i:2;s:14:"`Mur`.`posted`";}s:32:"227110cb1331a56c3995a31fd8c4db7c";a:1:{i:0;s:11:"`Annonce`.*";}s:32:"8ee4e381878886a74715e50c607da897";a: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:"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:"ab33026ab35ecdaaff7997d90d84cc28";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((4.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9757d7ddd410d8b36176729c187e212d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.76667- 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:"1db54e59dcb29c0d166342ac6af25caa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}s:32:"d079ccb6fe94f60c0b5775ba687fd30c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa3317ffd6732cf289a0cd747d629d0b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((46.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1*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:"cc5c3105bd65b07a9e5cd4f658a5fbcd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f4a3733548bb52efc6c4cc198b706845";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0378*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0378*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.71111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"78005114d016ddadc6c0f368d368a190";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c3e0aa775d6d524dcec4fda062acd7a4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((46.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"b4930a03f2926db2abc51f38542164ba";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((48.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"65d5530ec29d5171a6b39d744e65b7bd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f826692ef1a3a4ad8c46f03200e160ab";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"08fe478213139ea4f07e5cc76daeb2aa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d560313b0e6035d318ea185057178ed1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1779f4988b74b97fa95484656d395447";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"808a822e94db1401f18082b91688f2c9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1984b783032bebe0de0f18718b6c3116";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5b303e309270a9cf0d83310a69c53c60";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4125*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4125*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.89417- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bf1bb66c5c0eb64ec195cd052a730c2a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((45.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5ef5376c23915b319c95a55e27b463e2";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"c9ae86e9897417e2b8b2222b6940ef15";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1*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:"29c93c11b6f8a91a385cc24bb3aac3ed";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*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:"3aa08d9cdb39956c86ed5dd8b825cb34";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7333*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:"d04cbc2197039547c04fea16e24f6b36";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"996141c69430926ce0283bd0d28abdc9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b34cba4cb2fc3b05d528cec1de194971";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c7f39013f2c3b2d6d7cd807123e77827";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*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:"0a0d1abbbab150d23427d48cecf9bfa0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.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:"3702d7feb0af174bc5f6ac16f09d0026";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.466667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a2f241cfa71faee83cc5777535ea575c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3167*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:"555b398d2b944c31ae1f9d8c94399b24";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((1.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"71b3a09398e375b3d02c7a4ccdda45b9";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((49.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ce251c5660e750e9b6b131e744ac330e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.5262*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5262*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.26028- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2fb0f10a548d865026b1fb9d7f4f42c4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b53f99d29c34b8058589acfcf7036ae4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((3.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f18884cd49085790f1dbd3ceb59bf40";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b73fc53f71d8ef35c20dd3de3af5e80";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((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8cb9a9b05a6412637d5d814de36a3dff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9d3a2735f1fbdca0920f94ac86b050f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"728fc01d00b768297e6f1770a7db775b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"45d9da3fb7bcd5f275d78e903a751c76";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e22bb44fa20d9e3c2f0e9ba376c156a2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a844973a0c5be23a8c37cf502dbc310f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*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:"34cf0afec3f89178be192da529f10972";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((47.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0a9e29ae2f489bf9bcb9b8b2aa8e18fc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cd00d1d53a731422111a65de140866a4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b1282c776eac56f40139645918c875f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.466667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"101551216d868d483799a3b0bff69038";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((42.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"593e34e03e1351939feec53dfc008b90";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"490f22f3d151943f5042e3b1191948f0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((47.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6*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:"3bb6064c11220432af25f7e906ff6271";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((7.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2aebea70d298effe86c36b6a74710219";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((7.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2a209415a462741c224fb6694ab2ebb6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"809934bb38cc358c01d066305e840425";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1e3ce51aee525f3f780879291daf662";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e69ba3ccf29d9184619069e2043c38a9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e5d6a7a870f5e768692cae74b8ebf9f9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"366a9147e70b7e584d8912de09c3bb50";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44*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:"0e7ffc7c453068f34249f9e240dda7cd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b2d1761ab1e3f7e7b269eb7f93dd7d2a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5f1feeeb051b6b87f791c9d76f502e17";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5f78da60d66a43d34490a957d5a9cceb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9828*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9828*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.65862- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"145a5ee5c986f847bc53c7e352a03797";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2331736aeb01629fd5789f0287f88ca";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"adc081ab863f6d58ec3bb11e7b49c38b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bd923f7321e0a02fe355405982c267e9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a56cde1eea5fc6fcf658af94f3b5cc2f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3e92778c30584b52bbbd40765ef91c0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9348*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9348*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.23223- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b23189139873997e492ebccf1f10f314";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*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:"8fda7d7de9263b4c97b7c85bb2bbed3e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.8259*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8259*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.31473- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b123fda7b3cbe169e8ab2482fcfbe62d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5ac61273f9ed354e471b72c7bc676b29";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a8c3756895cb42c7c4e244c8103f32d8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"12f75515ad9f3e861eb28ce04fb99a8e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"53f4b119386297273d2d13b3b6f28ab4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"059e1cc437a809e1c7223a4537ee78dc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6368a83ad5d24d233e236a3e00eb2ec0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((47.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e14d7f72504b4bdfbb50d3595d21f13";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"578b692b4b0c8ce6c3523693560fa3d3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f2ed447700277eebc6442c7ab1435ddd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1768f70965115244985fedfe5a420e27";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d9c0a0af8e62ea81b6df8d12c86bfcb0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1c13181f771b756c0436d300e0a68d5b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b46685610680cc0939494878bf3f65b3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9578*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9578*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.38806- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"10a6cea758432d787caf8e5d0b3e9600";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"746ab32a93652b3214e6f13c37560b0e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((48.4506*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4506*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.6125- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4aba21e84f7367f16f991f74ac5bbf89";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((46.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b479d1d82e850b825ca99d03f3f2bb6d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f4b4791894d65e2c895daabf81dfce0d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"62b67e260d129ba019cfb21068cfde86";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6df638db0b5994a95d35416d24b44dc8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((46.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d367388b0ec626800900133503dad745";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6c4b95bb687ffc77ad74760f0a4325d7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*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:"0aa87d127c37e99232d871516e5d349c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:185:"(((acos(sin((50*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50*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:"8ee5d7eee531553732a3da9c51e31abd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"92862d5613f98e311b77eb7c3a4878dd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2dd482fd62d6f18cbf4f48fa4bf27a21";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"86ad27405580de0a7c2adc46b255f4f1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aaf421baa39f4d03899d4c2b5d96acee";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"77b18e7c8e1215f53397f79d9c210680";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.15*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:"28c6abf241e6a4a469a4b8163e3288ff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((48.125*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.125*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c25cddd2914ee7a2640c30718a19d50f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"036a4f31ac68fabadb81fb6d58fe14cc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"47e1b62651425084b358f0041144ed02";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b8e4cb4235c5c121a9b7cf36c80bc251";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8882e0b07cf174a944892a76919cce1e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"710f935f70f437423b797c24bd3e6539";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*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:"49c14087630f3eb5522729e9cae88735";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dec93c17a55fe40b69e0cbcc2af4495c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"11fdb274d89a94b3d368721668ddc543";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2a15e9088714e5f95d153e3cbdf6d41d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((42.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2701dea885d56e506aa46d9eba42b57";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f7e56f4acaa03fc77e372ed2f562d413";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1333*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:"eeb2a9cdaf27b781c1b26e9a7d5bb1f7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((47.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"54434027a1bdbae5c5bfa26e828c927c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7862*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7862*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.634167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1702cfc0fe789f73115ff0b325aea7da";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((49.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6833*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:"bb4c64893fa3de0c65fbddd5b2fb39c6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5ebc43da72f77ed0383df6347c3af4e4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cf9b544cd5dd350a45b8c595f1c184ca";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((46.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9ea964cc7ac78af67fd1d5b569f7a6b4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a3766adeff93443dc29f089025dcec6d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0d05e81cd3664cef6f445f95aa9826b0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2333*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:"2cf463c4a69398441c842accab0d7ef6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a9b5633ce3e5ce5203fa2f6924696457";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d51784417bf891485730b0fde40d7ada";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4df67a56477fa2eafc793336665bf6ae";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8f1a84e218590d7c4cb5022256e41dba";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"01db3cbee059a3c0590b881637b8b186";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((50.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e747a0a6c4741204d186239732679760";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6333*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:"a033c047096ba0d3fa78074045e31c62";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b75b8f83df5e5b1af1b14a7bf07afed9";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((46.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7*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:"b15051e56a0a65ddeb30a0d3ae754fbc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9333*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:"98fb366451171de0c7afac876130ec43";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((-2.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f4c09908707c4afe35288820bc983356";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0b0e953b3fca0f0280f4e2c0fc9331d5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*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:"95e14c6f594ffbca7ec64fb09e6fe423";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d29d32b287da0605652c54cf881df403";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6833*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:"df5ebf5d38574d2ab962ea78c7279e17";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"69ccc8dc30ac07c9e2147e0bd97610d2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3dbc00d3e7b7801c5d54696a285d40b1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"32f67178854c7e5ac98d19990dd48765";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9c154686e6079a3db75890a3ef0a02f9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4ac0a5b6d30b0d2cecaa080727805699";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6faf9598561770cd7fd401ff6176f4d9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9*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:"24e986fb7cacea872887bef0f20a2f74";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((-2.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"faa0210cd0c94dbf8a13c863376bf5c5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"70214e4ee1a394d4ec2105a80f8e2d5d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8a2370908e5683b2e03c8ab4c3907b62";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1e63a638be7d13f4907fb46861c45b95";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"edfdcb0a015b7a0216d57f6d6cbd7b69";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fdd7113031814085d433ee9e2a3bbd0d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c6fb5cc6ec5269c49d0ae356fe31375f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:186:"(((acos(sin((44*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44*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:"b80e02e8a7075ab4eb271e1883f226eb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1823*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1823*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.97223- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f750e45e350964a7472d66ec42c156d2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"791d51ac1a4746d42ac5063530ab68b0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*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:"13e7ff8347eed8c9aca9c5eaa6d3912d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*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:"1ccb5504fcb38ab300d684784b132249";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aae2c2f9f0c2f1091b104db5454c76ec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa29eed2adbd2f8ee029389b75ca483c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e0736802c1c29fe4e5d6671b40142b5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f5f7bd117a698ca16df49188aca104a1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b90195bcdf0f11b31c3cbaff545209c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"843e08cff27be498350eaeefc1f72435";a:2:{i:0;s:382:"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((46.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- 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:"742a891601baea45e328bc89c2995bfa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((45.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f8c9b2a9374dc0a050977548957a8ff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6fa7c47010898715b8c01d85818f7bd3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*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:"6198720c462420c751bcffc784b5751a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3ff721c3ee41ea40344b2e48af396e1b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bd2be88e28941dc0575529c9fab41978";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.816667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5991fd5637b0333bf2b87cf384851779";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2fa8d69ced80635dee5afd78a87250cd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8964*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8964*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.02889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"afdbedd83c3e593126ec4c4682618da5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((47.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3cb27c5b62f3b7fac57ebd0002a5e084";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((45.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"57da85546d3fb91b21f8ac82b9512944";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.0867*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0867*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.68195- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"61970e07d51828927970449fac0bffbe";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5667*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:"f699490143a76bbe6ad3e15327f890bd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e1794c3fa308eabc01cf20586f2a5fa0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7884*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7884*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.165278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f24388d8beb3db591d2156a9c080b413";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9aceaea7183a5998a898918fd8280730";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.55*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:"521e2282c07cd16b0c6bbd6939de0c00";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((45.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"782b356403eabd0de383c32b6e729f30";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"202ac9d60be2a3616e56668f5cfd7d5f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d7f8e6e50322d30f964e61b373530547";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*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:"cd1120da788fb2c1cef3ab2f8e0704c0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8fbbf1e7b3152dc8c47c5fb784a54d9f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1333*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:"9263d3b119cc919f3250937818138fb4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"40779fe721a7b6c43c4f8e2e24e0ad04";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((50.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"64ed1bf3df7b8092b3f680e5790bca47";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8ae846563f97207ecd4ae0fabf0b5ddc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c3f0e86c8b43a2ee2a118ec0ea9bc08b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.116667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c6884afe1746e285e651ea2a3b9f2dca";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4c69afaf488b674cacd5cda33171e1b3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5a931c3f32b621096e56ff061013ecbd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((46.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ede69767f9ccdf4e5f6e952e40bbab81";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8439*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8439*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.94445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ad716835c58739af85e83b75c811ebb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7de7a89a7ff7f22dc80a212ac7f7ed7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*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:"0c8c0ab9d0d8408bffa795f36df341f8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b40442d092ec10dacae9d3c68aa5886d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a84b418613618334af197fd19ee94527";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4395*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4395*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.66639- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b9d617169dfd7c9aba14b7f8f5688d6b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((47.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9fb20f625bfed14840d1b567b6be74b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6ae6abd898f469ce771ef637ee47ac7d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5531*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5531*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.859722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c4654615322502f1a9a7cf91a996d62a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0833*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:"f31563f95017eac53dc5b8bd3e23c085";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((2.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d31a8cd651d9457a77c4ca4f8d0c5889";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9167*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:"ecee024b033ccc34a3713faa3fa343d4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2833*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:"9395f201ed283a4d361f0c07f1d71424";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8556*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8556*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.71806- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a24313c9c5bb0fe44bc140275df6eb72";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"249806a7ad8de9f9f0bccba11ce180df";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"89cbb198d2d18a4017ddcb66d965685a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"532b8f1c46003661877dbcd212c277e8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1167*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:"9b441ec2b4312763c9c8c384bfc12e42";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6423adc8e51316878a3f1d93c5838968";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d1a3bd8a76fecd86f6f10049fe88807e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2667*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:"a5dd85379f4314a3bd544ca0ef313bd8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c9ede28d7473e15c0903584d2153f772";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"76283fbd0628deaf76bcc80e3b182fb1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2833*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:"ba1ffae3bec9dca831802cead522679d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"83f4fdf926780248c7e992acd5253f82";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0833*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:"3d2176236359baa98964b1b4a17a6503";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8efbec1a620f204e997e9dd343688f0f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((45.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"47f0c436f346f727f55c0790746da8a9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((45.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"82a0bd0439ba2413ce34ebde7c1e318b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b0e635807fba6b28318f41053e5bf11e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((45.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"06715e2f7c7d2b133e5e37b81cbc95a7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6667*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:"f515268f377807a1fad1fb878b31f44f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"adeec45d1519418e746166910d74480a";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((42.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d1fecb0064ec14ef895ee6b83b108af3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.55*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:"91eec5e335ecbaebf92b963cff3141aa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.65*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:"d953df5a79ac8be9f4c9f13e2fed3a71";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ee0105ba933b63b6e508f47c1052206c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0833*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:"26df32d0569bbc8a00a210f37c3342c1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8167*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:"4493f58a196e540f20213834d2ff8b5c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3af6555e8121eb838499850cad6b0442";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ecf4147185e1c74fea0f543fc59ba697";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*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:"cd7df3a8cbd203c7f0772fc708469bf5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"51951f7b7a05cb9121d6f933009e70e2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5333*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:"d3d4cc7390417faafea9426b017a79c5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*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:"3928802a3e72ce5dae97f5385faefe5f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"24af18467fa7bc23a1cb82cdf7f04527";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f823789f8f6cf5b19080f283d92a72ba";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"91f1ac095c970b7f8c8c2aa20541c3c9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((46*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dd09d75edbcc18ee6b216cc778f16f8a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((3.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d4d7908776eb7c4ff5d0f7e77bc00b26";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3629e971bfa26c168c5d92efa2e42eae";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3706*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3706*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.12389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"70f263cfad82752afefefa46f579730e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0a1d2e8a9a39ebc2e79890b517d6ad71";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((47.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7f8a83d3acd1c10347e59b5ff2bbbe65";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((47.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f82f2e7ae5fc176b54d743fdb8b7d77e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3167*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:"6d53ecc9dd211cad3ac0ab4d046b9f15";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2a68b7c3577e905d333393fee3121b8f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b0a0839b02a286d48af90a662bbd54bb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5b8aa62623aa72578df4168f6c0d90e2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((5.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b8df81ffade051aa13ed9fafcb12281e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4312*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4312*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.72722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"28a16762e52980c0d2783881729bac94";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((45.4937*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4937*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.503889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1384850d02d50e69534b9a4721de3bde";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a20c30f58cfd33d1e8269f98d618fca7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2167*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:"8b55e9d1ccc869b4bdb7283d4d5b1f1c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((45.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9610788218fc4cdd551e1f8ff12bed55";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((45.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4117c8494e33d77aa12a33c401f9dbcf";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5fbdf852614833f0317da37652bf3fe6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"67db574f4d0e547372e14381145d0ded";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((45.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0098c51e9851dda37a12826efbc9e8d4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.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:"facb5d683781df3eed586e20b926644d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1dd48f50f5fafaf87aa3c0690551da4b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2167*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:"8ed430f41275e3c6e80b78de34ce3926";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2dac97acf5b6d3c64b9f33c6067eccdb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"828b59b790759b4931d701e5f47fde09";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2362*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2362*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.48917- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*100'
unserialize - [internal], line ??
FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828
DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
VillesController::index() - APP/Controller/VillesController.php, line 14
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/dansmaprovince/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]
Code Context
            setcookie(
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1738732629,
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)
$name = 'CakeCookie[autologin]'
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 174
[main] - APP/webroot/index.php, line 111

• contact [at] dansmaprovince.fr
• à venir

Déposer une annonce

Partager la page

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

Maison de ville à rénover (annonce exemple)

• Où 56300 Pontivy
• Ajouté en juin 2021
• 137 000 €

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

en savoir plus

Annonces de maisons à vendre à proximité

• Le Sourn
• Malguénac
• Saint-Thuriau
• Neulliac
• Noyal-Pontivy
• Saint-Gérand
• Guern

je suis agent immobilier

Pontivy Immobilier (56) à la loupe

Situation géographique : Lanester 45 kms - Lorient 45 kms - Vannes 48 kms -

Dans cette commune de 14491 habitants, installée en Morbihan (56), on compte 11 agences immobilières. À noter que 250 biens ont été vendus durant l'année passée (2020) pour un prix de vente moyen de 1371 € / 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 Pontivy ou dans un secteur proche et vous avez une maison à rénover à vendre ?

Déposez votre annonce, c'est gratuit

Prix immobilier Pontivy

	Ventes	Prix € / m²
2019	273	1281 €
2020	250	1371 €
Évolution	-8.4%	7%

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

Archive des maisons vendues à Pontivy (56)

Située Rue Des Diligences à Pontivy, maison composée de 4 pièces principales pour 93 m² sur un terrain de 680 m² - Vendue 121000 €

Située Rue Du Stade à Pontivy, maison composée de 4 pièces principales pour 91 m² sur un terrain de 565 m² - Vendue 98000 €

Située Av Des Otages à Pontivy, maison composée de 4 pièces principales pour 66 m² sur un terrain de 517 m² - Vendue 125000 €

Située Rue Des Ajoncs à Pontivy, maison composée de 4 pièces principales pour 75 m² sur un terrain de 511 m² - Vendue 153900 €

Située Rue De La Republique à Pontivy, maison composée de 4 pièces principales pour 63 m² sur un terrain de 500 m² - Vendue 95000 €

Située Rue Des Petits Champs à Pontivy, maison composée de 3 pièces principales pour 72 m² sur un terrain de 669 m² - Vendue 90000 €

Située Rue Des Glycines à Pontivy, maison composée de 4 pièces principales pour 91 m² sur un terrain de 591 m² - Vendue 65400 €

Située Rue Leon Durocher à Pontivy, maison composée de 5 pièces principales pour 110 m² sur un terrain de 645 m² - Vendue 160000 €

Située Rue Beaumarchais à Pontivy, maison composée de 4 pièces principales pour 67 m² sur un terrain de 563 m² - Vendue 80000 €

Située Rue Senechal De Kercado à Pontivy, maison composée de 5 pièces principales pour 114 m² sur un terrain de 92 m² - Vendue 112500 €

Rénovation maison Pontivy (56)

Artisans du bâtiment

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

• Entreprise générale du bâtiment (4)
• Électricité (3)
• Maçonnerie (5)
• Charpente, menuiserie, serrurerie (5)
• Peinture, plâtrerie (7)
• Couverture, plomberie, chauffage (12)
• Nettoyage toiture Pontivy (demandez un devis)

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

Déclaration de travaux

Selon la rénovation envisagée, une déclaration préalable de travaux doit être réalisée auprès de la mairie de Pontivy 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 - Pontivy
8 rue François-Mitterrand 56300 Pontivy
02 97 25 00 33

Aide financière pour les travaux

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