Notice (8): unserialize(): Error at offset 99687 of 99687 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) 1738782400
$cachetime = (int) 1738782409
$data = 'a:3:{i:0;b:0;s:4:"name";a:473:{s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"8f48e0e9a64852c3f50eb1f79fc34cec";s:11:""st-brieuc"";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:"969a358cd02317e4f8397c982aebaa78";s:7:""22278"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"4b5b179f3d4d02caf2bc8f10c9508150";s:17:"`Etablissement`.*";s:32:"ddd34ba2fe5b8a28f2a178b624f2dbdf";s:11:"`Agregat`.*";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";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:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"2c62152eb8c6e394c181c6dd4ec49616";s:23:"`Categorie`.`categorie`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"abfe790023ff0d1611edcb6dfce6802d";s:14:"`Moyennevente`";s:32:"c1955c45da499f15d5021c8c72d79c2f";s:26:"`Moyennevente`.`codeinsee`";s:32:"3c8d21fc2164772cb7201fe48deb9396";s:15:"`moyenneventes`";s:32:"542a36960498c722592cd6b208119756";s:9:""moreuil"";s:32:"761f6d92359307dbeec0ea5ed4e19577";s:7:""80570"";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"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:"3c5d5315720434ff5cbcf92a8af6ac05";s:7:""coucy"";s:32:"a993a518a1ce84abff0df5be7ec64af1";s:7:""08133"";s:32:"3c36f1d3969668047bb312f157157ae5";s:9:""hillion"";s:32:"9d05436549dbad82685c152f0af445e5";s:7:""22081"";s:32:"26154679699ed5171b303a3e94abcaa6";s:12:""furdenheim"";s:32:"8f13b4552875469567a0ac2a16c20b58";s:7:""67150"";s:32:"3e13cf881ec484d0c12e7523ec8c2ec8";s:12:""hurtigheim"";s:32:"75a062aa153dd29fc6046e2e8002b52d";s:7:""67214"";s:32:"cd6a3077ab67bcf031c143c6b17e75c4";s:16:""port-ste-marie"";s:32:"4fd9dacf09c91911e9ccd436350d1000";s:7:""47210"";s:32:"e203e3ab43470bee9637613093e74eaf";s:9:""dommery"";s:32:"99b12eaacbd1ee05ff0e285b5b860e84";s:7:""08141"";s:32:"3782ea7b7bd63e467a3403b5fedd034b";s:8:""hommes"";s:32:"f37f22794c6c4a5bd7b37c9bb390e912";s:7:""37117"";s:32:"f3a7eef2903be3de0d280479d193b3d0";s:12:""cahuzac-47"";s:32:"bda274f04437f934156e1e33b2d4fd02";s:7:""47044"";s:32:"b6b543242b3ff6c8739b5d89990123f3";s:17:""laroque-timbaut"";s:32:"93701b81aa27b9490cc6596c638df097";s:7:""47138"";s:32:"c54c4baff114b16829d072c70db7270e";s:12:""falaise-08"";s:32:"42cae77bbc7e3d36d5c3e8c5bfdf33cb";s:7:""08164"";s:32:"41582915bfbbfce9c4c381c7ebefbebe";s:8:""altorf"";s:32:"1b75422a437d2a80f94e65991d454b72";s:7:""67008"";s:32:"d7fe03c66f9686f2bb9e041c95c4bc8f";s:20:""plestin-les-greves"";s:32:"89bb64e0f8a6642b5ad900e3efb862b9";s:7:""22194"";s:32:"af78c77717f153c7f98491cd7a9b0fbe";s:12:""ergersheim"";s:32:"62ef13ea628080a12df94d5a3fb9015a";s:7:""67127"";s:32:"aa048602a294456c2a08fbd43b0e6663";s:19:""clermont-soubiran"";s:32:"10fe67c629d757e8cec63ed196790536";s:7:""47067"";s:32:"fa001d738ca651eaef35195af9818936";s:5:""roe"";s:32:"1dc3d8ff53744074b2f092f6ca1397a3";s:7:""53191"";s:32:"e1ccce5f96308c3834a7d667fe055ab7";s:13:""eckwersheim"";s:32:"cfde917bc16d0d289e54be9411856ade";s:7:""67119"";s:32:"ed3bbec7dd314fe38d799cf4e611a169";s:15:""mas-d-agenais"";s:32:"2bb21572644482482e6864a617fcfb1f";s:7:""47159"";s:32:"86269a5e363cbab23de922c484472dae";s:15:""st-arnoult-41"";s:32:"c88a96c9cb067f93a45b3469dede07ff";s:7:""41201"";s:32:"b8a7bd96311005cf9c95f2c3eba03f90";s:8:""berrie"";s:32:"fbe6f6622b3aa81a30ed41d49bbc8133";s:7:""86022"";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:"fd5da3f047411a1361824a37d9dfadb7";s:11:""olwisheim"";s:32:"fd7d9d6789f744e0502de3e80f7ee654";s:7:""67361"";s:32:"82f755b48ef7692b04714084efc322d9";s:21:""castelnau-sur-gupie"";s:32:"9a39c48f737d6bd816a0ae111ac55c6d";s:7:""47056"";s:32:"227452ed1833ff97b29763d8cd966f0f";s:11:""tayrac-47"";s:32:"ea16bd9b794113654865c08385c49a49";s:7:""47305"";s:32:"67e2d412722f550c6d72810d72ae0658";s:7:""bricy"";s:32:"60bd35ce849853d3b0eabaeeea41943c";s:7:""45055"";s:32:"7d8cafa84cdf432b810caef3300a6ca7";s:16:""courcebœoeufs"";s:32:"8a005c0ce8b1746f347b3a297d5de8ea";s:7:""2011-"";s:32:"0eff2b74a60689e7283c8dd9dbb6b2f5";s:17:""chateau-garnier"";s:32:"4892ace91034e4e792ab99d812ea4983";s:7:""86064"";s:32:"0486e882dc94bf85453f8b30bc94ebac";s:11:""soudan-44"";s:32:"76c5f0687414b2fc1c8e33a4ebf37dd7";s:7:""44199"";s:32:"dc636dd62b526c52c074bddef2f071c1";s:21:""st-brieuc-de-mauron"";s:32:"e4a7cf9e47a8b5a2431aa75771fa5cb4";s:7:""56208"";s:32:"588cea6a864c31e9c77de82a5b54f804";s:21:""castelmoron-sur-lot"";s:32:"8aca0c93d628de9d11a60ad14561e28c";s:7:""47054"";s:32:"c801ec09803ebe0e4ae2425acb49f579";s:8:""colmar"";s:32:"fe5c3e617219804684a85617ba123766";s:7:""68066"";s:32:"33d39b10e46790bc4be84673f1d53659";s:11:""faouet-56"";s:32:"a7188f2a1cac33259430c3855b3fca08";s:7:""56057"";s:32:"f2bd626f69391e8c429769ef5bc81047";s:10:""calignac"";s:32:"5aeea7ba5c4d0e40daa71ce0f65fd21b";s:7:""47045"";s:32:"e81ae522f9f7481939e62142202d121a";s:12:""courgeoût"";s:32:"848d846433c8c6410623a69dd46be482";s:7:""61130"";s:32:"f88c239b7ff94cc23908c40c64aedb27";s:15:""pied-de-borne"";s:32:"5c0ca416741d2ad50a03d3d903b86012";s:7:""48015"";s:32:"62c342a305c8da39d8bda1fa2aec51ee";s:11:""flacey-28"";s:32:"335671e21f5fe0bb5118b09637f12f20";s:7:""28153"";s:32:"d06bccdbdc4d7d73df79470ce681ec55";s:13:""chenevelles"";s:32:"ae4969397c24eb4932567db8b84faf8c";s:7:""86072"";s:32:"b2c56d6ef83d44b4b1c546c9637bf530";s:8:""moings"";s:32:"d6aa0061f19a745e976418b0cdd8b1ab";s:7:""17238"";s:32:"8462583254f2c5a2294f45835781d07f";s:9:""pressac"";s:32:"9b61812dc441409ead9d1a34d6aee61f";s:7:""86200"";s:32:"9645e5f55161753f5f47c595a661bb36";s:10:""croûtes"";s:32:"bf158bf4c526dca72b7731ef98450688";s:7:""10118"";s:32:"c7532742e74a6e9b0eb92391d8a6e8e8";s:9:""rosheim"";s:32:"55a37361096c3723c2fa97a6a7558798";s:7:""67411"";s:32:"7a87ca53bed6d3b6a769e7d560c79f5f";s:15:""bischoffsheim"";s:32:"49e9d5f328db25332e26b185466a8e24";s:7:""67045"";s:32:"f8437f36a72eb0b43f489539ce89a08f";s:18:""clermont-dessous"";s:32:"be8d71783da677b6cc0c22ebb819a77c";s:7:""47066"";s:32:"d993fdf994f215b2d14e8fbd0426ca10";s:22:""ste-marie-du-mont-50"";s:32:"68678d6d3346477e5ba1722f1e0d69b4";s:7:""50509"";s:32:"698e1c2300f35c182472073c6a2b2b0a";s:10:""galapian"";s:32:"24de11ea91dc1855e4beefe43f1f67fe";s:7:""47107"";s:32:"25861a135f3816d418e00a2f818121b9";s:25:""bouvaincourt-sur-bresle"";s:32:"e7500b5c55ff05f138916e9d4c0f6621";s:7:""80127"";s:32:"c5dfa655b34e9e69f6919cf45df264ed";s:10:""blaymont"";s:32:"0626826d657fd5e7224d1da2f06a304a";s:7:""47030"";s:32:"3b3823a8ae05f466d85969580a05aef4";s:17:""hautes-rivieres"";s:32:"ed4cf83fbf5a485f08f1d06206a147d2";s:7:""08218"";s:32:"138b52710a52582054a4004504aaefa3";s:9:""durance"";s:32:"e77eea3adc7bfe82755a958181c42e33";s:7:""47085"";s:32:"d2c86ac24781d2f47ad4ab751889c393";s:23:""sauveterre-la-lemance"";s:32:"ee05bf1e41b2c4da63d11718b665091d";s:7:""47292"";s:32:"1662d7d64b49f7952d84f0809501eafc";s:12:""mesmont-08"";s:32:"af11386a1ab3152cf57bcdf90b7328a5";s:7:""08288"";s:32:"537206ed0656fc7bf33cde4e86892c6a";s:11:""guiscriff"";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:"ac8dca022525299c0b2c035f4244cea1";s:11:""goxwiller"";s:32:"10679efdea5844a413c1d44684b16687";s:7:""67164"";s:32:"f3d0ac7b179f176fd1f7e1eb73842062";s:20:""fontenay-sous-bois"";s:32:"0764ad536421f0bec46a515796fcf150";s:7:""94033"";s:32:"d6383adb1766931cec263d92dc16211f";s:9:""obernai"";s:32:"eb53b5fc636778b1f126531d0e6ddb28";s:7:""67348"";s:32:"26811d038a6d549ac3fc343464aa8f38";s:9:""ouzilly"";s:32:"593afb62b0cda33900e8ae5d824ca7b0";s:7:""86184"";s:32:"09a13d1242dbf03bd0647357b261c5f0";s:18:""erize-la-brûlee"";s:32:"e33e4d27c9dad88b18b10e15f6c8e17c";s:7:""55175"";s:32:"5d801355734673280dc6bd279f2547c1";s:20:""verteuil-d-agenais"";s:32:"557bb4ce3e1c2ec68737b6d730d227a0";s:7:""47317"";s:32:"330fb04650a05bfd23e0b2efc62af53f";s:15:""pouru-st-remy"";s:32:"0223ab10a6c6524f7d69992e50d9c1af";s:7:""08343"";s:32:"63d07acd26d37e7958065d9a00af7791";s:14:""maizieres-70"";s:32:"6cb116985e6c6ef8365924373dfb721b";s:7:""70325"";s:32:"1ff37cf9a75728260e953bea2d31542b";s:21:""vouneuil-sous-biard"";s:32:"6eceff4fd8caf4e325499106d37b5e37";s:7:""86297"";s:32:"92d2f42b6add0c4723d90dfc2b4189b3";s:20:""savigne-sur-lathan"";s:32:"e962dd77f1e6d26917a0d774e145b458";s:7:""37241"";s:32:"89a03e3f5199e56be6420bcea40f7e20";s:14:""estrebœoeuf"";s:32:"509d3791cae8fece4e9d183da5274d39";s:7:""80287"";s:32:"eb6a6e578bd32527fa550af452118673";s:12:""ancteville"";s:32:"5ece77c59c1040c074fee58c1cbe0982";s:7:""50007"";s:32:"5ff5904a3b3e60539006ed99a58666ba";s:10:""magne-86"";s:32:"2f603e83040f14e5329653865a25122a";s:7:""86141"";s:32:"3d4f6cf6070847b39312adae434dae49";s:23:""st-marcel-les-annonay"";s:32:"7332101545a83f8d1e00ba01b6c3f1b6";s:7:""07265"";s:32:"cb1078672549f060975fc4ae1123247f";s:11:""aubiac-47"";s:32:"2502185c914f64ee6c8351a9bb5eaf56";s:7:""47016"";s:32:"a617dd56306d2497120bb402aba280e7";s:11:""tremeloir"";s:32:"492a080943899e27bac870fadd7c834a";s:7:""22367"";s:32:"1664ea761e70adaddc6b2f69736c442d";s:18:""soultz-les-bains"";s:32:"646de4ab2663e7210e5aca0d05d7ec1c";s:7:""67473"";s:32:"3abc836f97f4d4a00a310867a5d418c4";s:19:""allemans-du-dropt"";s:32:"b0a6c8767fbb4ecfc4600763dc3f8772";s:7:""47005"";s:32:"9f63e319956f99e3adaffee3aaa7ba49";s:12:""mellionnec"";s:32:"3261c5056cc0103802991ab15b13cbb8";s:7:""22146"";s:32:"589f217edea993a2128f543c9a40e9dd";s:7:""anzex"";s:32:"7d630409f9a7b45f0fe5194ee972a2ec";s:7:""47012"";s:32:"ea6c197a751e0bc7b86f0a16ee5662ef";s:22:""rouziers-de-touraine"";s:32:"c04ff7685532fe3b721eaec29778dd64";s:7:""37204"";s:32:"6a615b53970c6002e40375ee19544bf5";s:19:""seyssinet-pariset"";s:32:"d3aae0796e4c644dd1ff3419d9b19912";s:7:""38485"";s:32:"bc2e28599b82e76e9ca4fa032aa51f28";s:12:""monclar-47"";s:32:"d004a552fd89bcb4df4130d882df9952";s:7:""47173"";s:32:"22dce5dfa722429529d6aa0cc628a378";s:17:""froeœschwiller"";s:32:"46baa259ecdda191e6f262988365513b";s:7:""67147"";s:32:"4343d2fe2608f97dea0610a2a8897cd8";s:11:""st-leomer"";s:32:"442bc7ecb386bfb3154fcc72af80f641";s:7:""86230"";s:32:"6fd5f2d21abd25d08a22c70de2e5341d";s:14:""planguenoual"";s:32:"db69319d137844ff1211cb04f48c3f0f";s:7:""22173"";s:32:"a9fa976f2d4b2d0cae4080612815d944";s:8:""gencay"";s:32:"da80e7e102dedfb8237eef1a6e1db39b";s:7:""86103"";s:32:"9360c2e00638ef3db7b65f647290eb67";s:8:""plouha"";s:32:"bb530a93c695fdf27b52a1bee465dec4";s:11:""marcellus"";s:32:"7082890e0f7575721125e8ebed59edb0";s:7:""47156"";s:32:"28b9a18113c5d47e284e39b47fd8b13d";s:10:""lagruere"";s:32:"4e0cf615cd97d1ada528893fc61f54b1";s:7:""47130"";s:32:"a86003b24cd58e110ba2e899efbb8365";s:22:""auvillers-les-forges"";s:32:"0ef75950c44c1747620cbc084ea8bb37";s:7:""08037"";s:32:"4d22cf0ee396ebf36da1333038d4f091";s:22:""sapogne-et-feucheres"";s:32:"e0f1f02a4241e4c2803c93d8c303fb6d";s:7:""08400"";s:32:"5585335f0c97535755e86ac83caca0fc";s:24:""montagnac-sur-auvignon"";s:32:"852fe520de7fd17c9c0a40262360d7d8";s:7:""47180"";s:32:"1b675eec2ae045db9ccc663680da7050";s:10:""montenay"";s:32:"f9a9ca7cd36d7551d8e7e0ee471baf4e";s:7:""53155"";s:32:"f63407c26a5541fc55a7ec3eecbc00d5";s:12:""mackenheim"";s:32:"87d43ccb6a3ac2c80d791ba8f741ddf8";s:7:""67277"";s:32:"7180b694c9eb337012d22cd8edf456ec";s:14:""froeœningen"";s:32:"5dc5d558d3bad261d040f02892c23803";s:7:""68099"";s:32:"1776fd4c3cbf765c1a2a18d1857ad8c2";s:19:""gue-de-la-chaîne"";s:32:"a73acbf22059a165529b813cb8bb67d1";s:7:""61196"";s:32:"9f16051343812c9e75f1e7671b114978";s:16:""mael-pestivien"";s:32:"09f9e8f92e990a4652edfa52b154133c";s:7:""22138"";s:32:"4890e1acd3357dc7499816de26604258";s:13:""coublanc-71"";s:32:"3629b783fa65843b22e7aa721cabdcc5";s:7:""71148"";s:32:"63a0fc2d8082466140d3e7e3915ce248";s:7:""ernee"";s:32:"2a528cafd917782363f1674a2e018bc4";s:7:""53096"";s:32:"5cd5ce0ea65a5d350edaecedf935d7fc";s:9:""guînes"";s:32:"701518aa46d6bc35d685c7ab0b33b7cc";s:24:""boulangerie-patisserie"";s:32:"1f4a4250dd9b8e2965da6647b0db3b63";s:8:""rahart"";s:32:"355d8827f7abb657ed98708a73d73bf2";s:7:""41186"";s:32:"20b2544a2dbfd864f782faa687eb61c6";s:10:""douzains"";s:32:"0951132c782b3a4a2a332803d63d3a9b";s:7:""47084"";s:32:"f524d8c28d8dc7d0c05edfeecc9b36a7";s:7:""douzy"";s:32:"b5e39101ae32803f71978c1f5eea8d3b";s:7:""08145"";s:32:"91c4394056da3b15560415740242d80b";s:22:""muhlbach-sur-munster"";s:32:"318c5d6163d93dd0f9a95f38d6fcc97d";s:7:""68223"";s:32:"325e795639f2a9990db9838379adde39";s:13:""supermarche"";s:32:"77837fe1a5dfb1542faeaa7c6eaaf1aa";s:20:""ascheres-le-marche"";s:32:"0b03f59d013094e24956307d23673ca9";s:7:""45009"";s:32:"d72b0ae63ee48ecce1521106e467b433";s:6:""bono"";s:32:"c89d9d319ce70e950be12c60fe0e47c1";s:7:""56262"";s:32:"9ffc6ff1a77ae225a01b29aab688bd9a";s:13:""vaudreville"";s:32:"ef7408a2c297de568ba29584bbf37100";s:7:""50621"";s:32:"4a518314d8a3095d423e4d69e7f38504";s:11:""chantesse"";s:32:"8ba25d2a9f9c7fca6448cd27fb795724";s:7:""38074"";s:32:"a038a6c5d493d751ee3fa830648afe66";s:8:""lametz"";s:32:"3b2864a00a9cb2bf64754965e2bd85ad";s:7:""08244"";s:32:"cb97539040be486baccb146ad60e342d";s:13:""angliers-86"";s:32:"33016ffa082aefb499bb8468d599c23d";s:7:""86005"";s:32:"80b74d80cc91142d0892fad2118feaa5";s:17:""bord-st-georges"";s:32:"a0680ff5722ed87820296bb3d9fea2a1";s:7:""23026"";s:32:"032094989389752a5287d1a58ca88511";s:16:""haÿ-les-roses"";s:32:"2a52f0f55ad0e0eaaf427b2c42b3b4de";s:7:""94038"";s:32:"3b2d72499d1da8858ba7dfb2b960950d";s:15:""lagarrigue-47"";s:32:"34d4cb00d0053c87b77f9e46e6eabf5a";s:7:""47129"";s:32:"8d1e3149ce0832f2fc3ab9b179d12f25";s:13:""st-amans-09"";s:32:"c982061332d14cc40f3706716b0bba02";s:7:""09255"";s:32:"f3f8a32bf08622dcd20631347b35516a";s:11:""rancennes"";s:32:"5f7a6e5f9ac392543036835ae074f375";s:7:""08353"";s:32:"c902a6c22bc9ce8739ed50e7785a673b";s:9:""bignoux"";s:32:"91dad481b5fd203a101651830653a08b";s:7:""86028"";s:32:"51e963b39add174ccb61fef5e4ebd530";s:11:""ploubalay"";s:32:"e2d9f40651ef949b322bc0db5bc0702c";s:7:""22209"";s:32:"70927010c3be12973f0d4862ba1bfe15";s:9:""tregrom"";s:32:"a84e780164ea240d01973995dc43e466";s:7:""22359"";s:32:"7ee7bfc993df8285025925ddfd7c8bb4";s:11:""regniowez"";s:32:"2ea31f03aab44c7d82cf68336a324316";s:7:""08355"";s:32:"c80030229a10274d37254a4fc476b11e";s:9:""pledran"";s:32:"476ecfa89037f23f3ac5d6bed3c174ca";s:7:""22176"";s:32:"7a8990026758f84710135dc659924389";s:7:""treal"";s:32:"e7a7c0de55de9f344c44b97c12e7c11f";s:7:""56253"";s:32:"b1ee54b6512b05bb0c2995ef5e2db17a";s:21:""st-gineis-en-coiron"";s:32:"7e6d669a108531784f48e6dd4acba992";s:7:""07242"";s:32:"601cc973b40bd64d83c6e96dc955c8e2";s:13:""santeuil-28"";s:32:"55766d333d6b3a4624d7e3164650caae";s:7:""28366"";s:32:"dfc57b423480c1a2e3c5e4f71a8d3438";s:12:""marœoeuil"";s:32:"6fcbbb226c2aa810132056e0855c4e18";s:7:""62557"";s:32:"cd6ed5cc732bff84c17e4f2b58e978d1";s:9:""maîche"";s:32:"f6bd17a5fc7e36778aac6c4c0b0cf321";s:7:""25356"";s:32:"7fe2c41b856cb1cbf3d440ee6c33dd1d";s:9:""carnoet"";s:32:"32c67b0e3908de5d58bbaa54a6b791d7";s:7:""22031"";s:32:"970d721fe52fe6c1f17b58c56441085a";s:13:""clavy-warby"";s:32:"48b6caa98a53ddc9af6e17d1fc6067b9";s:7:""08124"";s:32:"0753cef1edd2295cb17a1e6137c73a8c";s:22:""briarres-sur-essonne"";s:32:"be79205ac48320588b32a00aba00e580";s:7:""45054"";s:32:"fdf51b1b7501e908cfb658b687b31ff7";s:8:""emagny"";s:32:"daf3ce1c7274e393a6cdaee7204e1a36";s:10:""cramenil"";s:32:"b9204f1811bd90b49b4a483d8a58c57f";s:7:""61137"";s:32:"b9be7ac024482d6ddd1c83f4d2644b78";s:17:""villers-semeuse"";s:32:"0fddf63736b71adc4219050074a6481e";s:7:""08480"";s:32:"adcc43a2d25dc203500e589dc69499c4";s:17:""penne-d-agenais"";s:32:"b0c00f584f41e29ee636e99a6a2f4659";s:7:""47203"";s:32:"172e4529be9b4f206dcf3f2a1eec0abe";s:11:""senlis-60"";s:32:"28d56e545c71a65dd2b17f9bade5409e";s:7:""60612"";s:32:"0b68bc24a61656e967bb470b97434a4e";s:21:""vendeuvre-du-poitou"";s:32:"6446903b7472d50af5a085a75d79b1f1";s:7:""86281"";s:32:"9ceb33c7f4244fa6f4fc88b9133d5236";s:15:""mont-l-eveque"";s:32:"0cebda77b1d91cde9aa4a2a59af9a711";s:7:""60421"";s:32:"fd9e9e4d5cf77c797dc67704a0873b94";s:22:""conches-sur-gondoire"";s:32:"124e9279fa3f7bab8053dcfd90793097";s:7:""77124"";s:32:"320866fb3ce5284c8b7e4610ea4aed07";s:10:""chouppes"";s:32:"3738c15e36d37de053e5eae494f959fb";s:7:""86075"";s:32:"1b9d8aa597fcf8792c6610818b7de13b";s:11:""lougratte"";s:32:"d6892c53fc7d853938a97cb3be0d9c68";s:7:""47152"";s:32:"cb7b2ee9f7816bf7cd1559aa8683635f";s:20:""dompierre-sur-hery"";s:32:"92dd262dbd999691d870f80bc9ff9e2c";s:7:""58100"";s:32:"6adb9eaf1550285623486b407548de83";s:22:""st-pardoux-du-breuil"";s:32:"a076062c56151f1eda3a155362d735f8";s:7:""47263"";s:32:"7743c0961772edab17e08151e030bc3b";s:9:""st-guen"";s:32:"6792358328dca1357feb8914551ef628";s:7:""22298"";s:32:"26ff2e40908b4298e8f42559a5180cf7";s:10:""marcy-58"";s:32:"a6dcc71b88c681c3d44ecf891acc3e08";s:7:""58156"";s:32:"c2fe21390ce8400027a8095c69dad2a3";s:13:""deux-villes"";s:32:"53bf463b5244dedc328ad0af096ed39d";s:7:""08138"";s:32:"4de244c809b358a98224aa0db1340d5b";s:20:""brinon-sur-beuvron"";s:32:"8fcc3ad96ae44d2365b957e944909a13";s:7:""58041"";s:32:"7b6c5d6e95d32634b44fce849d2117fe";s:11:""niergnies"";s:32:"539b59915a1cbd438691ed9a53926241";s:7:""59432"";s:32:"8c44da8d76febf0b1f3af63deeefdaab";s:22:""teissieres-de-cornet"";s:32:"07e4a67b560018bad0d2b024b35cf6c6";s:7:""15233"";s:32:"1f63222c1e04c7503c42f62b41ac2c94";s:11:""couloutre"";s:32:"62701e2f39d447cf36b0d32f4e190b68";s:7:""58089"";s:32:"5f3557710f08923b829b4e1a7277c581";s:10:""pedernec"";s:32:"16a42664f1a23eb0f232d2e6c6f2bde0";s:7:""22164"";s:32:"0c27c69a19ffe37e4497c8c199b04a05";s:24:""chatelliers-notre-dame"";s:32:"5036700439d9ae9db85fc9edbf4aca7b";s:7:""28091"";s:32:"3f137d57e18b87de61f8873b87ea49d0";s:10:""martaize"";s:32:"e60530d6a6df904c7d8186ed12d219db";s:7:""86149"";s:32:"175c542a3674c7fa52531398e6af8e4f";s:11:""servignat"";s:32:"b49d8f2fb35349c922225b63f166f944";s:7:""01406"";s:32:"fe86acc7311ce6ed512a423a0148a49e";s:13:""baldersheim"";s:32:"207576fd21c709b003b928b2be8aa64c";s:7:""68015"";s:32:"0d6c268ba8fc801c5032b77c9cb9be4e";s:8:""perroy"";s:32:"efda9b318336e241c402a6e26268f6b9";s:7:""58209"";s:32:"15d9d8df1ac95910b38f6d2252eebc02";s:19:""savigny-sur-aisne"";s:32:"fbd853c74ba9f7f4604af835f5c3bdec";s:7:""08406"";s:32:"51f45be2cfd53c938283eeefca2481a3";s:13:""nalliers-86"";s:32:"5112828200b8044ff17d0d4068c5f7df";s:7:""86175"";s:32:"a52e11b7d41dedfed61737ee7e7c4171";s:20:""villiers-le-sec-58"";s:32:"72fd745c285b92ce9e74d7cf440d1d34";s:7:""58310"";s:32:"7cb44c19c4e3fad86f48013a950b518c";s:17:""parigny-la-rose"";s:32:"14ef4c7d02481e4b2cf5b4db1e8d8d6f";s:7:""58206"";s:32:"7869ff86b5a40ca705cd1659a8d32884";s:19:""pouilly-en-auxois"";s:32:"e067c72ce73a2cf580466286cdab4d1c";s:7:""21501"";s:32:"3ffb1279eee166dba9d63ea8b2e47799";s:7:""vrizy"";s:32:"ece9757ae0442e5b9dccd64016b0ecfd";s:7:""08493"";s:32:"0d3dcd64914f6e8239716a454861e6a2";s:10:""frasnois"";s:32:"4af0b0ea85f8d1f55f0f69b32e27053d";s:18:""thoisy-le-desert"";s:32:"283f4ab816d457cf7a7e6a6ea6684a87";s:7:""21630"";s:32:"a8053a2227da8a6c80549b9603807e8c";s:12:""st-pere-58"";s:32:"53e977086c882d6f0068bf2f4b4c229a";s:7:""58261"";s:32:"ae484830c741a2befbac4878263b4ea7";s:19:""charenton-le-pont"";s:32:"89b8ec7c6c43c930895ebff237c72847";s:7:""94018"";s:32:"34f80c4f5cb8c3d36f54d54e87896edc";s:10:""mirebeau"";s:32:"133b42399c33aeb88356765310680ad4";s:7:""86160"";s:32:"d569640ac3c222b7a51bad9965213196";s:7:""rayet"";s:32:"33265ed0616035d2fb6a404c28c44451";s:7:""47219"";s:32:"92b0ae436542bfb5aa3f9340ba840030";s:18:""bois-d-ennebourg"";s:32:"ba0b0f083b662a183104cf9ce1efe59d";s:7:""76106"";s:32:"821ed7d681e2b1b97274d534eb48feed";s:20:""nadaillac-de-rouge"";s:32:"6a26ca47f3810c5585214cd267f87271";s:7:""46209"";s:32:"3cf4069e8acd19fd4d03631e25ab3489";s:13:""villebaudon"";s:32:"e019c109e64bf59559ef5af243fe1826";s:7:""50637"";s:32:"63aaa4deeb1e87bc50820ca379ccada8";s:11:""vincennes"";s:32:"1475d6dc39b9828fe16a9d0117d353b6";s:7:""94080"";}s:6:"fields";a:176:{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:"bbb4049ff44acfac692ab12128a8ad9c";a:2:{i:0;s:71:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*";i:1;s:18:"`Departement`.`id`";}s:32:"fd89c1b16c4841c0554e2a9e2d5ab824";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.78333- 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:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}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:"3d3ca36e9f39331b48bf48bdcf53d95f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8ee4e381878886a74715e50c607da897";a:59:{i:0;s:20:"`Etablissement`.`id`";i:1;s:23:"`Etablissement`.`siren`";i:2;s:20:"`Etablissement`.`rs`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:21:"`Etablissement`.`img`";i:5;s:21:"`Etablissement`.`pdf`";i:6;s:21:"`Etablissement`.`lng`";i:7;s:21:"`Etablissement`.`lat`";i:8;s:22:"`Etablissement`.`desc`";i:9;s:28:"`Etablissement`.`historique`";i:10;s:26:"`Etablissement`.`chambres`";i:11;s:30:"`Etablissement`.`restauration`";i:12;s:27:"`Etablissement`.`situation`";i:13;s:25:"`Etablissement`.`parking`";i:14;s:30:"`Etablissement`.`animauxadmis`";i:15;s:29:"`Etablissement`.`equipements`";i:16;s:25:"`Etablissement`.`langues`";i:17;s:24:"`Etablissement`.`tarifs`";i:18;s:28:"`Etablissement`.`supplement`";i:19;s:26:"`Etablissement`.`capacite`";i:20;s:26:"`Etablissement`.`categ_id`";i:21;s:24:"`Etablissement`.`adress`";i:22;s:25:"`Etablissement`.`adress2`";i:23;s:26:"`Etablissement`.`cp_ville`";i:24;s:20:"`Etablissement`.`cp`";i:25;s:26:"`Etablissement`.`ville_id`";i:26;s:21:"`Etablissement`.`tel`";i:27;s:27:"`Etablissement`.`telecopie`";i:28;s:23:"`Etablissement`.`email`";i:29;s:26:"`Etablissement`.`site_web`";i:30;s:25:"`Etablissement`.`partner`";i:31;s:27:"`Etablissement`.`full_desc`";i:32;s:21:"`Etablissement`.`fin`";i:33;s:22:"`Etablissement`.`view`";i:34;s:32:"`Etablissement`.`departement_id`";i:35;s:28:"`Etablissement`.`agregat_id`";i:36;s:22:"`Etablissement`.`pets`";i:37;s:26:"`Etablissement`.`horaires`";i:38;s:27:"`Etablissement`.`date_call`";i:39;s:32:"`Etablissement`.`recall_creneau`";i:40;s:28:"`Etablissement`.`convention`";i:41;s:33:"`Etablissement`.`convention_text`";i:42;s:33:"`Etablissement`.`convention_date`";i:43;s:29:"`Etablissement`.`financement`";i:44;s:34:"`Etablissement`.`financement_text`";i:45;s:34:"`Etablissement`.`financement_date`";i:46;s:27:"`Etablissement`.`direction`";i:47;s:32:"`Etablissement`.`direction_name`";i:48;s:33:"`Etablissement`.`direction_email`";i:49;s:32:"`Etablissement`.`direction_move`";i:50;s:32:"`Etablissement`.`direction_text`";i:51;s:32:"`Etablissement`.`direction_date`";i:52;s:32:"`Etablissement`.`recall_travaux`";i:53;s:32:"`Etablissement`.`recall_maladie`";i:54;s:30:"`Etablissement`.`recall_autre`";i:55;s:29:"`Etablissement`.`recall_date`";i:56;s:29:"`Etablissement`.`observation`";i:57;s:26:"`Etablissement`.`modified`";i:58;s:25:"`Etablissement`.`created`";}s:32:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"5ef5376c23915b319c95a55e27b463e2";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"bc013b7883512024414e377d97f654f5";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"17e6d4266e40dd6aed76e78a72f46091";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((49.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1a732ac269c6a95bf79d736b47d66f50";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.68333- 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:"610485157f9e9a61fafc92ef217eed12";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9993e61b38275a2cbdd14c062d78ffca";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((44.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9554d5e5bef370cde7a24379e0c0bb85";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6667*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:"552c8db1b8cb7c519ec21cd4ad841466";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4333*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:"aca2180dd6a3f77a60ee4b14c653bf5c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"992250233d6ea5a93d4f5c84adc45b18";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"66d8f0a8f9ed002e9917e87e0e61055b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*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:"c41b5d9b53cb581ea24d10ff12899ce6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9a1d854af0fdf9c29ee6c4c1a2b67efa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*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:"a09644ef0c39070bc327dbb8c54cfe90";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"89d60c3d58a0624dcfffabdbdeac424b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.1406*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1406*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.831944- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"88e9caea41381e602b2c5b064af6688c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*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:"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:"6c58a9d30691bee026b36156bdd7d6f3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4*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:"7ef630fc933b22594913318e168de8f9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((47.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8dfa46e8e697fc83ef011cb66d49e336";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"275ff5be94e291183f3643dfeccadbbe";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7*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:"42cc5de4de412ca94fbca15fb58189a4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((44.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.55*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:"cbd6b869d3eda0e472ab2ccd20b427be";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((44.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*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:"084cca81f4e2694cf05137fd2e8ffa01";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"de0ea3a3e5296c7be6a612c91dc55414";a:3:{i:0;s:50:"Ville.*, Etablissement.*, Agregat.*, Departement.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"03a375efbcbe5ee497b5d148673088ff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:178:"(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5e46c7567078e7a2573e6fb53d633399";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4f4f7708ad2834d5f7975ef86b4ad363";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e04909edff5156c8e164c8aba42ee198";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*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:"a4874b7691018db17ad16c8e6e376881";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((44.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5725b90e6ba2cf078f431e80a23e074e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"66ce9a1240b857a2912f72c54a2cad4a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0417*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0417*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:"129c04689aee819ee2ca7d16edbbab21";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1333*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:"eaf1d6b4e1ed9331b20d054784c8386f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5*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:"90566f1b0153262047e1cbde01280c39";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4756*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4756*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.98473- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"16108a13053fc0db8c3974fdbb18a5f3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"95400eb14cfb25d1e7a6c28c94b62a8b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9459d921a62ea52aef5192a0bce0e19e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"58ab570843e19f3766032dedc3954bb8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*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:"a1df0fc78e2304a4dd82f651b7f91cbc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ed70b163945ca2faf35f01b7ae050bcf";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c71fcd4b05e8f51b3bd00fecd13d5521";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc8390d137e3e4721b86e5da7ea20952";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1502771145ed4bc589758301966c936c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"05b5bb7df07e869565ef092df3f7b9c8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4c1f85a73519e813453f0d5b81bad5d0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0333*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:"5cff84150fb0746eaeb57f5161c98f35";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.966667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8ab822521b2f7a2beb6f32f03652027e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3462e220e520f6ca164fd7a8fd571459";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1667*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:"cb6ef25786c2fd704f89c1f6e34edbbb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5833*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:"77f70df29a5c7576e07d18ca8b748017";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6167*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:"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:"0db6998f4642eaee74aee9a0a534509f";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:193:"(((acos(sin((48.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"41a448cc01ad91fd5f1bd670f88346a1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5b4f4e2e63ca28c84425ab7d95effc30";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*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:"0e9f6a1ea4e673ed2248ae06ff6367a0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5054f57ccc45e45ec4ad2fc217ac473e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7833*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:"c36da485966e811056258dcb2d402f94";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc443414502831f66012d590c26e90d9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0d8ad2eba32122c089f6b2bd040d172a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((5.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"563eb7115bd269eb4b9e25fcb442ac9b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f4ce439ae857c85e344534c58664367";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.266667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"919f234bb60af1f81db53e0a61aba620";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"25d9fe49a6b1b735f9cd09b3633db44d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"42183a44561d9745a82c4c1ecf3111ae";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((-1.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8016db9b1408f4edaf93c160c6922bf7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((0.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"acb624d4c3dd98b9d76959dd852c9f70";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c3338e67df1b94f122ef13b4001aeb5c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1333*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:"b47714263883ef4247ee63f7c8b9f228";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.55*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:"a0de31537d5f14c03876dc2277852a69";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e5e6834940f3b21e5993c7b31bd2b278";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.283333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"464886a060dac32f043e39e8b27af166";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc0da41a0ffdd11765553ff7be31ac2e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2833*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:"c3e11d1160548f4836525e36e1334225";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5167*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:"f8da6da78530620b53de618f8965d3f3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ab5abff0212ef230ec16099d2982ab21";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((44.447*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.447*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.525833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2d42ce83e4590c49706a1c75afe7c613";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7925d330dc06a67811b2ac626338932e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*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:"6b424816e520fcc55e5ff1ad2252c228";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5d4c0a8345b50e6ad8dbbb2b92e02024";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3733*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3733*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.405833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"566293e6d7ec698e501eb90c55fda402";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:200:"(((acos(sin((48.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*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:"cf738595ee3184333c8df7c6eae21dec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4833*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:"92907718b97dc58cb549136de340d971";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.233333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0a1f9e19fb906f086c3a51733ba4672a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8667*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:"a528eb1a2182605363089ab5fea69331";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((49.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c1b7b25943ee72cf60e36632184caef6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.15*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:"4eb0628c703cf1d043c7048ca68d56bd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"444b9755ac13fce390fda46a5d416c42";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*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:"aebd8ef274cfede396fbbf19f836d2d7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6833*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:"6aec02f6a63ecc9904fbb8064651aac6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.516667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"79c0d2b36361c76883457e6648922955";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"24c53da744a39a8de2ca846d3c2c59b9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3662c3b661f90e749a97dddbad17fab3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.933333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"788fe136fd40d70b1bb8d8bf94a16ead";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b5cf90602f9a28d5825393abd05628e4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5184a4bce80b23835489e58b7211a26b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((5.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"741a7b5c667c63fe80cab1611aefddee";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0333*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:"738d3b405a797447eb2c6ced7e348c68";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:187:"(((acos(sin((48.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1*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:"3a995e6f11df71a56c57bec6dd9e36d8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6403*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6403*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.04917- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b72a3b9922d031bd99d8738c8d832bd4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fb73b30cfced55eb4fc6ccab23a07d0f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f2f7d94321886baba35727b2f03ee461";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5333*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:"a5b72e31a71b3425088642c16fdde43e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9462*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9462*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.116944- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f10b640e25ca810c84d1ea702c67c237";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2667*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:"a253f52813461309e6b777590cb2d377";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f5fa4ce33fa5c03f297708473f6d7909";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2a45b77d2528a368b35928463038d93";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((43.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6dd6eb68b1ee608f474f7b558db153ea";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((50.1083*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1083*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:"1bc7174469d19e202176640fc9c70570";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6*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:"126a0d87b33910ec29aa7f80ad3fb8d7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*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:"780298fe036477134a13825b9f639b27";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*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:"a1bc8165588d3d02326e1f8630d24ca7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eae275d4bf98fab6ca755fb7ee34fec5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7c0826cbbcce3bf5bdba2df90a90f4d1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8333*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:"c4f01c0d7e21c56143093aa5fb86c41c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6328*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6328*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.53306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4224e558e9596ba6899216645fdaf73d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*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:"0c06f8d4a98b095c2e626a30d6ae566f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.3167*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:"1ed41283f82081f7b6fd42060587e4d7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a387735a38be03019ff73e6cc62603a7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*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:"df4e61010308b2e96d87ebbd32259cac";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((49.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.75*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:"bfbfd54b32047e08830a2382c72ea36f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dfae0b8ef5da9c6158b939362377ddf3";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:199:"(((acos(sin((47.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ca5a8d99a7fed120a1e8e909d6af14c5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*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:"deb236ae2ff57920f9c6d2459d3e3079";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9053e87663b6bdd1da8d3aa7aba4def9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dafe0f33daeae359745e19da48d1831f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f7a5e111bd890d8fac9d9289a497b2f0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1178ac7fb10b7efec5aeff89e0f6ff9b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"8655abbf002d6eae1f1f1f080c2c16b6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8167*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:"bdd991b448ac6314b4dfa7786509a913";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26dd88672e7461e9a122bb53b626fd6c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aab28b72641879d804aa2e3a2314f71f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4833*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:"f83172081b1f1cf44430e15a5afb9e7f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2167*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:"37150e3ce05cd1b62fa66c1b5dee678d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.32*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.32*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.40834- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2e2b106c8ed4d40aa1cb6560f2e687b1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6506*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6506*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23195- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f68400ef25fd036f8de8997f6b55d92c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c7700cb59bec2e4f478a548979c42496";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((50.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.15*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:"f2ceb7e30abe48c6691e8ba93e2aad3e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b84a22fb243c77bd10411553b8fa41d3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"28b630fe027ab44d6e8f0b1f18abdf80";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"55be7d431c791429791ffc6b208019e1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3492*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3492*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.20417- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1284f26163c04b6a623dce086e757347";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a86de7fe9417839a95a8f34ca251b600";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((5.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ee77ce93f4cc3749004b23cb1e8edff5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4fff64b4249e3c97bfb20b11dc9e378f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((3.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cca0f15b825ad05b06729379638d48ce";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.35*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:"c9944f478f742bccb253709abe02df3f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"997d5f2fde6049a091959ddd0679a427";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7e24e93fba5bd374a70ec4f2a585750";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9dbad6e06139555f1401a3aca4012ccf";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2667*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:"189d1a70d11cf141d12d1b618ff1ec60";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((4.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3a0a02b5c580b7ece5ca4818f2869cbd";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2939644fa5f9af12bc003e9b0b8fbc27";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"23ad159bac1ce2236eb5a83cc4eb38a8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.412*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.412*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.96028- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7aec32414164014ed5a288a8e0d8cafd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"246236af2b186ecfebc083c4cc96dbb9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ec8940697141542b265e4aa331791fc4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cdbc6a22439cb80d5056f8fb0cb15912";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2d725258bda80c9228081103f5d9fb6f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*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:"78fd2a9a81778568647953a12943c41b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6aab6236ad11c297949c499a5b95092a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance"'
unserialize - [internal], line ??
FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828
DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
VillesController::toiture() - APP/Controller/VillesController.php, line 129
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/dansmaprovince/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]
Code Context
            setcookie(
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1738740400,
	'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