Notice (8): unserialize(): Error at offset 73712 of 93040 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) 1738781955
$cachetime = (int) 1738781965
$data = 'a:3:{i:0;b:0;s:4:"name";a:463:{s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"abfe790023ff0d1611edcb6dfce6802d";s:14:"`Moyennevente`";s:32:"c1955c45da499f15d5021c8c72d79c2f";s:26:"`Moyennevente`.`codeinsee`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"3c8d21fc2164772cb7201fe48deb9396";s:15:"`moyenneventes`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"34e02714804cbfc6c4e77d15ff243fc4";s:5:""fye"";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:"61fc668d21d9cdd50ea8d9db258a8e0c";s:7:""72139"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"4980ed713520c53a5ef7bfe59bfe3568";s:14:"`Mur`.`pseudo`";s:32:"5df22fc0ee63f77314a59940fedac466";s:15:"`Mur`.`contenu`";s:32:"78f75bec59f89c734ad73833bc56b727";s:14:"`Mur`.`posted`";s:32:"f0a34e9f16b52b8585fb8852c455febf";s:6:"`murs`";s:32:"025bf5e280fa1a5abe6649e1e4de4e90";s:16:"`Mur`.`ville_id`";s:32:"aeb9c0f91b83d19a86e2de9383c8aea7";s:16:"`Mur`.`validate`";s:32:"9d1b58c9bf83bd6b146c7059e2971034";s:5:"`Mur`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"359ac070c703c6225869362821552643";s:11:"`Annonce`.*";s:32:"40afeb1c40614860e01d0748c5f553df";s:10:"`annonces`";s:32:"8027d37245b611a3fbdf14a1e89d8f29";s:20:"`Annonce`.`ville_id`";s:32:"404f56ef6af3757e2e643f86960284d3";s:18:"`Annonce`.`statut`";s:32:"f95ddc2be023960209cb5ce5f087ddbd";s:9:"`Annonce`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"5300c109f940de210789b8688e33b2d8";s:22:""st-amans-de-pellagal"";s:32:"8120e980e81741ecb699530f0bb7f317";s:7:""82154"";s:32:"1c13ae0a7d762721df470aa07e5f9f9c";s:8:""heloup"";s:32:"5b73fe9ddc61de38dfe45f0f3714b4c0";s:7:""61203"";s:32:"d70eb9ac0a9010ab2f6d55b592a65ae5";s:14:""charsonville"";s:32:"4ffb555d3cb41704c8b42ad3ab89ab49";s:7:""45081"";s:32:"4b2cdc402546d99042a8db2b43d6116a";s:23:""st-germain-sur-sarthe"";s:32:"f46d4abe1a3f411e10deeac552615fff";s:7:""72284"";s:32:"64392c7bd7063dc6e24c19e78c745240";s:8:""cognet"";s:32:"0630896db81286c3b6c3ade2f34ba84b";s:7:""38116"";s:32:"057fc5e7e1127cdffaba473a7b75ace5";s:9:""pace-61"";s:32:"5192ae27f276c0eae39cadce015d4c16";s:7:""61321"";s:32:"500df8c23269d08b948413d6743ade86";s:13:""lavilledieu"";s:32:"579494773bd9e8c4ebbea3fcfbeecd46";s:7:""07138"";s:32:"e1bf2ae46384a048ebea80f399560322";s:20:""ponson-debat-pouts"";s:32:"8e759734168f06572459cba01573c211";s:7:""64451"";s:32:"924b7cc4dcbae73e79a062bd1b270e77";s:12:""st-thibaut"";s:32:"ef2e612fcf53d35f55fab7237def18ea";s:7:""02695"";s:32:"ba4db59e83b9a0f1f262c4b8a46f60ff";s:13:""fromelennes"";s:32:"c0ef033ffd215e104481cac1cc8d0721";s:7:""08183"";s:32:"5e1e4c08a50931899f74b1d308953e40";s:11:""vernantes"";s:32:"a8d8a9a57d850a31b25a8f2595dca94d";s:7:""49368"";s:32:"183a9a30b82afe9bcf09de5f5067e279";s:7:""fromy"";s:32:"df723b184edb993df956255ce1e63889";s:7:""08184"";s:32:"42f8f8a9a22c728b9d33ad9f6f0c5bc4";s:17:""st-julien-l-ars"";s:32:"0f4ffdfb04cf2b5697e78ea13c65fde3";s:7:""86226"";s:32:"5ade4bf9d54ed7924a4511ad95cc8021";s:7:""vandy"";s:32:"f5408c40b7c74f09998fd91b9e3bd06d";s:7:""08461"";s:32:"24aa66faddab6cd0556bb1ee4c09603d";s:24:""bosseval-et-briancourt"";s:32:"5225df220384865280f038cf5843f7e5";s:7:""08072"";s:32:"bdc6831a6aa73a85159c03674ae0da17";s:9:""reguiny"";s:32:"9502cbfa5b4a6fc3bff67cfcd4374fb8";s:7:""56190"";s:32:"4b5b179f3d4d02caf2bc8f10c9508150";s:17:"`Etablissement`.*";s:32:"ddd34ba2fe5b8a28f2a178b624f2dbdf";s:11:"`Agregat`.*";s:32:"db3637d11fcdcd69df12fd155007380a";s:27:"`Etablissement`.`codeinsee`";s:32:"9e9324354827438087cb97d78e67cb63";s:11:"`Categorie`";s:32:"6c96c7067859c92b2cd5c584da7020fd";s:19:"`Categorie`.`siret`";s:32:"becfa4e4a7c9b2d19025948a972a6478";s:23:"`Etablissement`.`siret`";s:32:"469f0eca4934529a8ebe3db2dddf24e6";s:12:"`categories`";s:32:"2c62152eb8c6e394c181c6dd4ec49616";s:23:"`Categorie`.`categorie`";s:32:"5cf72367a170b49bc579e873244918de";s:19:""chapelle-baton-86"";s:32:"828777d8491831f7acb71ed58997a29b";s:7:""86055"";s:32:"1b5567bbefb1f7bf28d97c39b10476e4";s:15:""laval-morency"";s:32:"b9aaed24a1d80df1841abf6e1ca73fc5";s:7:""08249"";s:32:"159d15451c096645323c1d53d21b4aed";s:26:""ste-ceronne-les-mortagne"";s:32:"4ec296d641f4e33580f7312b91abfba5";s:7:""61373"";s:32:"8e2519745414363ee6ca2730d06ec664";s:24:""st-maurice-en-cotentin"";s:32:"4e74ced8377431eb38f8e7696e6ff20f";s:7:""50522"";s:32:"be49ea571cad8c3f981bd5cd764fb4d2";s:11:""viella-65"";s:32:"4e44469b3adf690f8e7dad7b3aac5a2f";s:7:""65463"";s:32:"255b7eaf03dbcfd15bf1da74163b70f4";s:12:""fenouiller"";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:"c34ad5af7f5b810797f595a67da48c0d";s:8:""guagno"";s:32:"c4e8923e0dc96d1d0842159a359b6acb";s:7:""2A131"";s:32:"4c9c9368805e71f0709f52a12b809081";s:22:""st-etienne-de-valoux"";s:32:"6d434dc65441b1a71a4ced5efa8291a7";s:7:""07234"";s:32:"bb4f128b534a28753fdef109aeee6446";s:21:""gonfreville-caillot"";s:32:"8c686950614d9fe67c30c56d66b57b82";s:7:""76304"";s:32:"e7198bd554a18958963924dc1471792d";s:13:""marcheville"";s:32:"3bc7111514db861f1427bfde4915ee2c";s:7:""28234"";s:32:"c38026ef46eaf78a58e8e09dc162848d";s:9:""mouille"";s:32:"4412ad97f443c41cb922fb33a60496c9";s:7:""39371"";s:32:"3c0ff8c08cca0f87c6dd6fde4f7117fe";s:10:""habsheim"";s:32:"544f690b1864b5239fad0dcc00d73ca0";s:7:""68118"";s:32:"31930592723349b48578d37ad063a93f";s:7:""lehon"";s:32:"71c13c465108e73b25d82955cc29711d";s:7:""22123"";s:32:"fa7d76d2dab3520eb8401c56cfc6d483";s:15:""croix-blanche"";s:32:"9ed80b578a3de9d82188bd6963469efe";s:7:""47075"";s:32:"379299a08818ea2105d8f1bf6db403c1";s:8:""moreac"";s:32:"4f6f50536b58cbf14baa0cd4b46e657b";s:7:""56140"";s:32:"25da394d209c4c59476153f81d44fbea";s:15:""tour-d-aigues"";s:32:"c90c87ee594f18243c43415284afb559";s:22:""auboncourt-vauzelles"";s:32:"f189dddc636c4cd0aabc70e09752db72";s:7:""08027"";s:32:"4a5dab6d84f96486bb6f7199abda8e81";s:13:""conquereuil"";s:32:"d42dfabc9efdcbcd7a8fbc155efedaa8";s:7:""44044"";s:32:"77148d625e7c47b018aaea6363ae4c15";s:18:""loguivy-plougras"";s:32:"c3edfa0d6e35c5e9c7645bc9e86fd8b9";s:7:""22131"";s:32:"01d611cea31f44c92a8c6fde96083483";s:19:""albaret-ste-marie"";s:32:"81d41ab60ec1b0e57b58b37cecb43a0b";s:7:""48002"";s:32:"62ab43bab0a55c2284348e2e11da8c8f";s:10:""jouillat"";s:32:"74dfb271ce18f0b382b2b256517635e6";s:7:""23101"";s:32:"5c7cb404cd2ba344f093ba98a84e76e1";s:8:""unzent"";s:32:"613b15525732b1940dd234c87e301d96";s:7:""09319"";s:32:"d25b0b175ef1be46ee9490ba4616f04f";s:7:""delle"";s:32:"7f505a8380dcb196e19291f71795e2ba";s:7:""90033"";s:32:"063dead91848ac57ba0a99f2df0e9d88";s:13:""longavesnes"";s:32:"696c79597ee5844051424ee86961b338";s:7:""80487"";s:32:"84d44c4a4b4fe8a2e14d6672e21796c8";s:13:""villersexel"";s:32:"d15f30843029197ed474e17784f6b09f";s:7:""70561"";s:32:"fe288cbefeabc986b817b90f597babc1";s:8:""meslin"";s:32:"cefdcdd3e974a83ca6cdf4450db8b745";s:7:""22151"";s:32:"0daf9643e7395a9bf18ff64e14c60b6d";s:17:""magny-le-desert"";s:32:"ca8ad15d3c74d0d6e9b5594fa578601a";s:7:""61243"";s:32:"5b6d6e88ddc04987f9d18b15412bf2a2";s:10:""virazeil"";s:32:"d37f3cbc83ef62f3424c5f22403fe373";s:7:""47326"";s:32:"c91d5030cf35182bae4dabdaf727cc5e";s:21:""st-bomer-les-forges"";s:32:"3a5a29387bb04b313c6e65903a4e39ad";s:7:""61369"";s:32:"1e6bcdd7e043cafb5d13d013f78eda4f";s:18:""roches-sur-marne"";s:32:"b59cfaeebb1d190bce14bcd2d15e4240";s:7:""52429"";s:32:"cf455073f501f91edd1e4e6b41a72f21";s:21:""st-pierre-de-mearoz"";s:32:"e2e53e37ad17f11728334e6e2a071e7f";s:7:""38444"";s:32:"5535da4690fd7d03d0cc50bc308b5b1b";s:24:""louvilliers-les-perche"";s:32:"539b89486492212a23554b441c358f1b";s:7:""28217"";s:32:"385e6f25cfb3b64603df1e758abd7581";s:10:""touligny"";s:32:"7a9ec7f22c1af9530bfdd39b9532cea8";s:7:""08454"";s:32:"f6e900e3543a138b8f0dac2ce705ef86";s:13:""cardonnette"";s:32:"e56b73e70cfd47e3386440483d3d77f3";s:7:""80173"";s:32:"50f6a7aff218c558a969978464826aa3";s:8:""ger-50"";s:32:"89951c01ecbd30a819a774a0432f8f0b";s:7:""50200"";s:32:"5d50ccbcdefa878f629c6c23004b8881";s:13:""beaumont-86"";s:32:"afa0b7b75a7cdfeb073fdfc588233ce1";s:7:""86019"";s:32:"ce0ca96651604cd22474b7ba9747f105";s:12:""palazinges"";s:32:"c9ae99dee29a0c4dae011d914c574c68";s:7:""19156"";s:32:"3045c2d0a75aff40967dde6de2dde08a";s:22:""st-sylvestre-sur-lot"";s:32:"3783a1acdfbe22fa1660fc2df76caa1a";s:7:""47280"";s:32:"04c9739bc7de096c601f40c5421bff3b";s:20:""st-priest-de-gimel"";s:32:"e8f09da37b21a065892d65b82e4e7f52";s:7:""19236"";s:32:"dd1db268004524126d819d5720bf5955";s:11:""madaillan"";s:32:"caef34cb611c21bc3b830c65796e0fc2";s:7:""47155"";s:32:"925b91edadfea31fee63d86c92fa0c90";s:11:""maidieres"";s:32:"9c377bdefccba7d41956337b8d2eeda5";s:7:""54332"";s:32:"4628a61b1d7085b4b89d05dea5f33fd2";s:7:""rille"";s:32:"bdc1c571edbd96154f5761d9f4bab7fe";s:7:""37198"";s:32:"9f6d3025ded6edb6a07366bd1fa7afd7";s:20:""gimel-les-cascades"";s:32:"a5e51c0013ca6a85113289d2d05c977d";s:7:""19085"";s:32:"663107cf15c1cf30dd46e9c01afb0b4d";s:18:""bassignac-le-bas"";s:32:"8f37181ebb773472a04ec321dca7cb9b";s:7:""19017"";s:32:"2ad99e1a9edd5191dcf5d8d156aad282";s:10:""bouillie"";s:32:"f9151ac78633d3f49add8da6caf27d9f";s:7:""22012"";s:32:"27d3c982df3f7c86cd2386f020ec177b";s:17:""bar-les-buzancy"";s:32:"dd27beb075ae3ab958d107d8e0c035d3";s:7:""08049"";s:32:"5e3dbdf446241b1bc669c5303b5cc177";s:15:""escaudoeuvres"";s:32:"a209b785c423ed2f69ab43d6fdc75899";s:7:""59206"";s:32:"354c03ee474014b7dccfdb66c7a6f33d";s:10:""bajamont"";s:32:"70bf19acd850c3cfabe75f1fd32877aa";s:7:""47019"";s:32:"a395926ee71646e9fac7df8553b71f32";s:10:""labrosse"";s:32:"fafe0d809529737971249d87c97481c3";s:7:""45057"";s:32:"e2bb9d4c5947a1923afe7fd33d420efa";s:8:""renwez"";s:32:"5d508dbb7a2fe90c2c88266a67dbd436";s:7:""08361"";s:32:"b742db16a5da64930b434f2a2f761b6d";s:11:""labathude"";s:32:"e1903f34ec138c1c3d64415ff3565be2";s:7:""46139"";s:32:"dfb15a310e3d93b7c9b0f951e2907450";s:14:""ste-bazeille"";s:32:"1f34dabe3e8b9ddf556dfbd0d2791b68";s:7:""47233"";s:32:"d79b860885890e5b17f1e6794575d11c";s:18:""montet-et-bouxal"";s:32:"414602cf72dd24b52ad6aeee38b676dc";s:7:""46203"";s:32:"53dd4053ce33173d20c5907f081471e7";s:19:""marolles-les-buis"";s:32:"b44fca0a70049f25acc155a8d24caa14";s:7:""28237"";s:32:"417cfe34eec9cad0e3ea656daa51383b";s:8:""guitte"";s:32:"41a0a467f46869b1f85812808393b386";s:7:""22071"";s:32:"f03cd895f69e7d1948d31b244068593b";s:8:""lannes"";s:32:"c9f06e5530a0a68402d49aa165012be5";s:7:""47134"";s:32:"8742076ea3de7b7728567251ac036dad";s:9:""sossais"";s:32:"20c99f8789cf2a5f2561e849fe66e580";s:7:""86265"";s:32:"2d1f7bb8da1e79c2be991503912055c6";s:22:""st-maurice-en-quercy"";s:32:"9741b17e3cb29b67766efc3e0bb9cca7";s:7:""46279"";s:32:"674c21694a126e60b797694321fe0fd9";s:12:""cardaillac"";s:32:"f61142db26959a0ab25c94186fd31832";s:7:""46057"";s:32:"dd93be8dfde819dcf1b873b2e1a92bce";s:12:""st-bressou"";s:32:"df7436c3527d4ffe54a27589422cad90";s:7:""46249"";s:32:"70fd55ba236e77cf1a57eaa0a34ce35e";s:18:""rozoy-bellevalle"";s:32:"fc675403843c4d7c3299338f6af558a5";s:7:""02664"";s:32:"0220f2bff535d21e303a94b8bf791024";s:20:""boulogne-la-grasse"";s:32:"9e74c9068bb3ca5a1dcf58dca49ed163";s:7:""60093"";s:32:"bfd633e11dd685dd74c1591f8d5fea06";s:15:""laval-de-cere"";s:32:"eb931e9e01c3c6d9fdc582d0980f6ed6";s:7:""46163"";s:32:"9fba87e17edd00cd9117816e8b130ddd";s:17:""gagnac-sur-cere"";s:32:"3e0f00d70687740448337134692b1f35";s:7:""46117"";s:32:"174522b39534ef390e3cf3a4ef64195c";s:11:""montayral"";s:32:"a6f7ad9e91c8575773e38b94154e3916";s:7:""47185"";s:32:"2550dd3024a2666f5337036fe5e1ca3e";s:16:""st-cyr-sur-mer"";s:32:"4cca1698046ac61ed9e1bbbdd1f5e641";s:7:""83112"";s:32:"6ce244e61e71ffdc8074770d406964f1";s:7:""bruys"";s:32:"1ec3a07321fd1875a42593c17a59e366";s:7:""02129"";s:32:"61135bc56857072b9b55ff25e35fb07c";s:12:""st-dionisy"";s:32:"7fc2b4bfbf6cdb063ba79ac63acdb58e";s:7:""30249"";s:32:"79f7e8cc13ccbad4aedc20b75077fe6e";s:12:""frolois-21"";s:32:"8f77103c62c5efd597ddf579ac400177";s:7:""21288"";s:32:"cce919fb41aff1925f323531c1ff8170";s:12:""st-remy-01"";s:32:"bb99958294387ffeaf7fbf0e6b652ff5";s:22:""ste-gemme-martaillac"";s:32:"bcc51a93f99a255fa163815c208328f9";s:7:""47244"";s:32:"dfc57218718fa33b11deb92a0c9399c2";s:21:""nouaille-maupertuis"";s:32:"006c5fe10fb3e55466217d1ded181383";s:7:""86180"";s:32:"0d91747cd3873cbf15efef6e9e5af35e";s:13:""blignicourt"";s:32:"d19ce19bf4b55e8df4d7eec1842d006b";s:7:""10047"";s:32:"7df3e0745f4b2f167c166288d3098f1a";s:22:""fourques-sur-garonne"";s:32:"16ecd164d598421faeb60e1fd03c10aa";s:7:""47101"";s:32:"97ef53fe455e74450a932d8053d9bc8e";s:7:""meral"";s:32:"d933b0ad012969c12e1f97677cd21f92";s:7:""53151"";s:32:"ac96140e403f6111ff1fe2f2975f320e";s:11:""st-egreve"";s:32:"ffec5bae6b2daf91a86963e507073168";s:7:""38382"";s:32:"4cb2949faab602fe4eb8e032503a383e";s:18:""coussay-les-bois"";s:32:"fc00f6f6fef160e8ea50971495855f33";s:7:""86086"";s:32:"61058c2f0199a4c7777fdde8d87120f7";s:15:""ste-helene-71"";s:32:"7d753a5ea2556ac120bc17c619442542";s:7:""71426"";s:32:"b32f1c4798bbf582c044e5e0f0ffa683";s:7:""fepin"";s:32:"0143a0758be6ee7910f13f7062433052";s:7:""08166"";s:32:"96e6382207398e36d146496a394365e9";s:8:""balham"";s:32:"562d70c57db0977a552aed3991a6e36f";s:7:""08044"";s:32:"8d362108b2fee0e3dbfe4dacab9f77ed";s:8:""cavarc"";s:32:"068f1f6eab9a9f4822dcdd2583e662d7";s:7:""47063"";s:32:"4a6c70cd97344793571cf244a1785b2a";s:18:""buzet-sur-baïse"";s:32:"f7cb83c6bb16ad581467163496597e59";s:7:""47043"";s:32:"45042b676ee75f05b3e35de06af5249c";s:9:""luze-70"";s:32:"20abce785b008b08886f7850322fa1b2";s:7:""70312"";s:32:"62f6718a720f552674267d32788293de";s:14:""montpezat-47"";s:32:"6757b662b07d674ab164fb66e29b60af";s:7:""47190"";s:32:"537ead2c25ac243ee82440cf21b1868a";s:21:""andelot-en-montagne"";s:32:"fbf71b77e0e52281f5ff3dc3d5ea2f28";s:7:""39009"";s:32:"ab1b52dd92491e969039cd8cdfb0a652";s:9:""lalobbe"";s:32:"cf67e42a20a0f365c4ae45e8a9262854";s:7:""08243"";s:32:"00660d9a83617a2f5edc0dc1cf172bfd";s:15:""roche-rigault"";s:32:"dbf9e8615493961ee6332e3bea8fa0e8";s:7:""86079"";s:32:"d89d58df69aa81e2a3942e662d1113da";s:13:""molieres-46"";s:32:"b469303a733b3d68b7087c6dd981be1e";s:7:""46195"";s:32:"61a7252b41aaa80ba76addc3bcaaa0a3";s:11:""espeyroux"";s:32:"e9e7b04c2909116e49f3ce46b67b4588";s:7:""46096"";s:32:"abda07fc70b96bc23903bdd307083b80";s:21:""latouille-lentillac"";s:32:"d04af22b752fa49ee83df62604dd21e2";s:7:""46159"";s:32:"27f49907808cfda3caa23789b852ac7b";s:11:""randonnai"";s:32:"24abfbb23d421a2f50b15fc094063f2c";s:7:""61343"";s:32:"d48dd00e9ae2fd131690b9f302969144";s:11:""allons-47"";s:32:"a04bcfa8df542148f412d09daf23659e";s:7:""47007"";s:32:"58ecec4ee680f4e289c455d39c5a1128";s:21:""st-pierre-de-maille"";s:32:"b0501dd4b56a7133125794caa7845a03";s:7:""86236"";s:32:"a595b6cf654852b04dd8867a1c021e07";s:11:""bretenoux"";s:32:"b58561104837699c672bd466549ca5d0";s:7:""46038"";s:32:"e98390f31e03ac9e907ae30feeeb76a0";s:22:"`EtablissementKeyword`";s:32:"f05318129420810d2df6af6f21777fb9";s:41:"`EtablissementKeyword`.`etablissement_id`";s:32:"08bee90596866040d3863d3b099b92dd";s:24:"`etablissement_keywords`";s:32:"6c66eb299f72f8ea6373806e1792c9db";s:9:"`Keyword`";s:32:"bcbd8f2dbc9172e3a3142affb2892e5f";s:14:"`Keyword`.`id`";s:32:"093651e381ef81925313bc1034b19f99";s:35:"`EtablissementKeyword`.`keyword_id`";s:32:"a88baf43cd357230f8c9342b8d8c1fce";s:10:"`keywords`";s:32:"a82fe8f431f55ca3e5c6eeb1425d6fa5";s:16:"`Keyword`.`slug`";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"cc7a4a34d97ffbb85978393c1dc3d808";s:27:"`EtablissementKeyword`.`id`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"0a1510d0dffae11b88c8130de3cc3c6a";s:14:"`Pub`.`format`";s:32:"cc6101a4c51d389cc83aaaa353064e30";s:24:"`Pub`.`etablissement_id`";s:32:"61eedb5524a37da074a515d3499b0fc1";s:16:"`Pub`.`ville_id`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";s:32:"8ecaaa87ac95fb6026267ddc489d4e00";s:10:"`Pub`.`id`";s:32:"03bcab00ea59985094d3823102128dc9";s:13:"`Pub`.`title`";s:32:"19ae68421a7af6fd53280292661686a5";s:12:"`Pub`.`link`";s:32:"adf6b0dc760d6ba40793e6ccab265414";s:11:"`Pub`.`lat`";s:32:"3911c9de594ddd79639957c57fa6f86c";s:15:"`Pub`.`adresse`";s:32:"013acd686b9d6a62ae480ddd5854054a";s:11:"`Pub`.`lng`";s:32:"9a9117f5211facf70dbcba9197db0119";s:11:"`Pub`.`img`";s:32:"a0ec82037a4d9290d4b4962c6dd972ca";s:14:"`Pub`.`height`";s:32:"c584a2fb465c8e8da20fba3f63f5f9f5";s:12:"`Pub`.`view`";s:32:"40c6caef6b63d5cc208b1f45871b776a";s:16:"`Pub`.`view_max`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";s:32:"978e55ac27dd8f14873eaa30e837246e";s:9:""devoluy"";s:32:"258b09b0ef89444b03882332a012b082";s:20:""st-michel-loubejou"";s:32:"cb6b9a2586a5f20ae39d91d35ec992de";s:7:""46284"";s:32:"dcab5e9cf3cf8259dd2c9da25e0c4e7c";s:7:""estal"";s:32:"e7def6b6a0e674c6b87b612ecf5adf6c";s:7:""46097"";s:32:"613035335df3ecfa7cb7abed99ab531b";s:12:""chassenard"";s:32:"01568a59a8056a8e99b6563932dbf33a";s:7:""03063"";s:32:"af8db226aa9e8a85a26c07a6b87ace9e";s:10:""givry-08"";s:32:"2c492a75e531c857346c5a17b44ea48f";s:7:""08193"";s:32:"65ac2ace429283b66ca82c7fe81f6a94";s:14:""coulanges-03"";s:32:"ebc2f52b49405038bfff32cba146d098";s:7:""03086"";s:32:"cbf8d8fca33aa84cef057e64477a098f";s:15:""paizay-le-sec"";s:32:"9bde475ccee1d083a96a0b2f0371328c";s:7:""86187"";s:32:"e51ebf81e0dfbd4fd0a40464e405c780";s:10:""charnois"";s:32:"8d58e5f589e5a9cd56ea9cfd05abae59";s:7:""08106"";s:32:"5d5f439bcd1567844a0cec744776b3c9";s:16:""vaux-montreuil"";s:32:"8efad22143a9342a1035e063976fef53";s:7:""08467"";s:32:"c0b065c1ae625deff2e0aebcea86ab88";s:20:""st-leger-les-paray"";s:32:"da54b395462945a119bde904f55825c4";s:7:""71439"";s:32:"6321c5bcfc42b82090706b5793747bbe";s:9:""biermes"";s:32:"4524cd56b8f051348ca6df7bcea93212";s:7:""08064"";s:32:"e925ca1017ba98c8e55e44db72c8b572";s:10:""frediere"";s:32:"5ced974f13d0a442bc47f893f1d9555c";s:7:""17169"";s:32:"1c6b100b67232d7ca216a838db258849";s:6:""pern"";s:32:"5c3785d93ecce76ecb9dce06e20a9c86";s:7:""46217"";s:32:"d246b5c3bb89ff08ac65f2ef65499848";s:8:""albenc"";s:32:"25b14ddfb2043c3cb5f2be00d5b1491e";s:7:""38004"";s:32:"fffbf79455bcbc350b05e7d22a09c49d";s:15:""perros-guirec"";s:32:"19a92484ca90219a89bdff526a9f6e0b";s:7:""22168"";s:32:"e0c35969e0e533fc18f02f43e89389c8";s:23:""guignicourt-sur-vence"";s:32:"7c193211759aaaa009310247f0d1cc16";s:7:""08203"";s:32:"663ca2fa48f3b7da3416bc3b3130826c";s:7:""kembs"";s:32:"59154203d9466743fa100897b54037ed";s:7:""68163"";s:32:"035c05bcb8d3604ed529a37f61281a7e";s:10:""sierentz"";s:32:"1a61bce7e3b9a9a6b87ebba6f186d085";s:7:""68309"";s:32:"6caa11586df9315ae8bf8e5246e18e45";s:20:""gontaud-de-nogaret"";s:32:"b5013ddba17cedb9282175715a42d4f7";s:7:""47110"";s:32:"e08f234d6710bcb88f5a6501fceeaa78";s:18:""noeœux-les-auxi"";s:32:"d1c5cf76e257560ecf658382fcd44013";s:11:""esclottes"";s:32:"90abf6ff49d0b020d3156a27b4612aa8";s:7:""47089"";s:32:"da93e65ac630ebec8ed9945a11c56cd8";s:17:""nohant-en-goût"";s:32:"2ecb7caa6fb453539790df77b1ae32b9";s:9:""harmoye"";s:32:"61f52170833d8f91b6b7dc6eb83d8a1d";s:7:""22073"";s:32:"1b8abf520f6774e06d906e24c1d46af6";s:23:""noirmoutier-en-l-île"";s:32:"1c9b4fc74e77903575c4715552649357";s:9:""angaïs"";s:32:"95f328a6cb104ad8361827659a3769bc";s:7:""64023"";s:32:"0e1985808079f480a0d313b97705b798";s:8:""lohuec"";s:32:"c893da6ea608f7d95bdc16ae28d5c99a";s:7:""22132"";s:32:"161731bbaf1699b61ef216e6980c79b0";s:9:""bosjean"";s:32:"9613a855e3fdb21feb941212bc56d454";s:7:""71044"";s:32:"d35e0162d74940d10f08642194fcd833";s:11:""brûlatte"";s:32:"d1efc9b34fce0b0f8b69453ae5b9e32c";s:7:""53045"";s:32:"d06e46f09e18b3c68d996740670b5c3c";s:14:""plenee-jugon"";s:32:"b6945a6594d55d28ca27a236ee3c1494";s:7:""22185"";s:32:"d742e992909825db8462779153c5502f";s:16:""azay-le-brûle"";s:32:"f7ed217dcaa4f484643854b20857c58b";s:7:""79024"";s:32:"69d9beef0952ac794f087cf9bea38b2b";s:12:""coudray-53"";s:32:"75563d98700c33cdabba35cc4e83d1c1";s:7:""53078"";s:32:"3ddc4c8b11e92671d6abeb6b2da8c450";s:11:""didenheim"";s:32:"a1e01a4e029d6c50b09ce66a3821e4f8";s:7:""68070"";}s:6:"fields";a:166:{s:32:"0776bc5a07b6293ad7a608503c8f0fbb";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:52:"(CONCAT(nom, " (", code,")")) AS  `Departement__lib`";}s:32:"6ebd007b29cf065d538dcc3a7c4187b9";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:37:"(CONCAT(code)) AS  `Departement__lib`";}s:32:"d56346cbc1a9c1c07ecb6f77d7298a85";a:2:{i:0;s:87:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*, Moyennevente.*";i:1;s:18:"`Departement`.`id`";}s:32:"05337ebf975c7cf6f83863c334431b6b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3333*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:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}s:32:"1ac2a7de1032f79c4b8218c21288e0c1";a:3:{i:0;s:54:"Etablissement.id, Etablissement.rs, Etablissement.slug";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"c4fd98c43562097d790d7e33c74a05f1";a:3:{i:0;s:14:"`Mur`.`pseudo`";i:1;s:15:"`Mur`.`contenu`";i:2;s:14:"`Mur`.`posted`";}s:32:"227110cb1331a56c3995a31fd8c4db7c";a:1:{i:0;s:11:"`Annonce`.*";}s:32:"8ee4e381878886a74715e50c607da897";a:59:{i:0;s:20:"`Etablissement`.`id`";i:1;s:23:"`Etablissement`.`siren`";i:2;s:20:"`Etablissement`.`rs`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:21:"`Etablissement`.`img`";i:5;s:21:"`Etablissement`.`pdf`";i:6;s:21:"`Etablissement`.`lng`";i:7;s:21:"`Etablissement`.`lat`";i:8;s:22:"`Etablissement`.`desc`";i:9;s:28:"`Etablissement`.`historique`";i:10;s:26:"`Etablissement`.`chambres`";i:11;s:30:"`Etablissement`.`restauration`";i:12;s:27:"`Etablissement`.`situation`";i:13;s:25:"`Etablissement`.`parking`";i:14;s:30:"`Etablissement`.`animauxadmis`";i:15;s:29:"`Etablissement`.`equipements`";i:16;s:25:"`Etablissement`.`langues`";i:17;s:24:"`Etablissement`.`tarifs`";i:18;s:28:"`Etablissement`.`supplement`";i:19;s:26:"`Etablissement`.`capacite`";i:20;s:26:"`Etablissement`.`categ_id`";i:21;s:24:"`Etablissement`.`adress`";i:22;s:25:"`Etablissement`.`adress2`";i:23;s:26:"`Etablissement`.`cp_ville`";i:24;s:20:"`Etablissement`.`cp`";i:25;s:26:"`Etablissement`.`ville_id`";i:26;s:21:"`Etablissement`.`tel`";i:27;s:27:"`Etablissement`.`telecopie`";i:28;s:23:"`Etablissement`.`email`";i:29;s:26:"`Etablissement`.`site_web`";i:30;s:25:"`Etablissement`.`partner`";i:31;s:27:"`Etablissement`.`full_desc`";i:32;s:21:"`Etablissement`.`fin`";i:33;s:22:"`Etablissement`.`view`";i:34;s:32:"`Etablissement`.`departement_id`";i:35;s:28:"`Etablissement`.`agregat_id`";i:36;s:22:"`Etablissement`.`pets`";i:37;s:26:"`Etablissement`.`horaires`";i:38;s:27:"`Etablissement`.`date_call`";i:39;s:32:"`Etablissement`.`recall_creneau`";i:40;s:28:"`Etablissement`.`convention`";i:41;s:33:"`Etablissement`.`convention_text`";i:42;s:33:"`Etablissement`.`convention_date`";i:43;s:29:"`Etablissement`.`financement`";i:44;s:34:"`Etablissement`.`financement_text`";i:45;s:34:"`Etablissement`.`financement_date`";i:46;s:27:"`Etablissement`.`direction`";i:47;s:32:"`Etablissement`.`direction_name`";i:48;s:33:"`Etablissement`.`direction_email`";i:49;s:32:"`Etablissement`.`direction_move`";i:50;s:32:"`Etablissement`.`direction_text`";i:51;s:32:"`Etablissement`.`direction_date`";i:52;s:32:"`Etablissement`.`recall_travaux`";i:53;s:32:"`Etablissement`.`recall_maladie`";i:54;s:30:"`Etablissement`.`recall_autre`";i:55;s:29:"`Etablissement`.`recall_date`";i:56;s:29:"`Etablissement`.`observation`";i:57;s:26:"`Etablissement`.`modified`";i:58;s:25:"`Etablissement`.`created`";}s:32:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"bc013b7883512024414e377d97f654f5";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"15c2382ab74ec6528a379fa58bd0a625";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"dfa446fee06836828f657f7efc2b4ab4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"468a0841b286d7010840d6bafb4efe5c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ff47ed5255fd670311aa6fd675044167";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8839bff7125eb663158582821fe23fa9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8ab2abea0c6bca6f31522e2eb30e8e19";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.00388889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fa19c61e89658e7fa742a76dbe5ae8b1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5667*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:"ebbde721d4efc8e15ec8d8a5b5806960";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((43.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1b961a08dfd03e85bd2bda9cfe336ab2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5a44d9b39fd46c229747ad57d8cdd258";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((50.125*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.125*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.85833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dabf176e7e23d4ebb2ca873a9db00519";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ab74cdafefb7272e989ff04e2a63738c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b16f2702c57fffee6b185613a1a9507";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.55*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:"60e66cf29d0fac185497ff771484ee54";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"65b0779c41b6a791afcd28e6bd8ed102";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbb4049ff44acfac692ab12128a8ad9c";a:2:{i:0;s:71:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*";i:1;s:18:"`Departement`.`id`";}s:32:"a667cda868c7745e17a3480cb94c5137";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*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:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}s:32:"8a7e8d45817d1aca006aebea5c0e82f8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*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:"536544046aa3d1f40c601ad3e5dea4a9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3efad7d7e0aefd7a441be2505bd1125";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e7679ddbb729031160b1c8bf4bd47716";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ace6d931b1a0e433d30ff7ca3c498ec5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((42.8767*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8767*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.0141667- 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:"e5d859c72a927d08011ef5e9c8903514";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((46.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d4d20947b456f87d9f8d0c7026caa516";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((42.1687*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.1687*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((8.94862- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8193bd8b7f9619d9ae64b9b282318693";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2909999721b8297e22df95af86744af";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.65*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:"e975c67105a1222c9ad506c75ba8fcda";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2bdd823d1206d8ba156947c6ea1f2f5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f752ec31f207c1f9d6853ffdb7ede184";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3bdeb82635fe4a8670bd23d6ade18fb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d1c7099cbbd53ca9f62cd1312fa4412b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"30a11c81461bab7b99b7b1e09b1827ec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7a55400ec045c966734f5c425a24012";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:196:"(((acos(sin((43.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ed2ddf2b2c760b6ce7ec9aefaa8b22d5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1c93fb848508b3b66bd90d4d47c472fd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9ddd93d43fe5b3e37e6903a4db1f0917";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d941ae88b56a8d5028b68fe388630e58";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"40f5b40331e01134c310e8b9e60b092e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5cee3658946061b9630c8dbb140a86a4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"13d0489c9b5c5df42e2d8c9009684d82";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((47.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6e8e382472e8629fceda3430aad8f418";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa433adcea0f44243b8d78a63cb10f75";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d577756bbb05aca7d4db6d04b9393302";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e3a23ac093fb0803cfc0919ac250a1b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((48.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.333333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5ac4180f62969138d98088f04214394e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.216667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d1e46a44ec74a8db34cc8f543f653468";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*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:"bf477e4fee5cc309ae8af7fc4fa282ac";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((5.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ef11a24de356f1da11f8606748c88724";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a292348b96c7aee789f8199940d611b2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((1.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"62004e6421bb35e28106b291fe91b802";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ed2c60aed5d6f851843389ff1297f13b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e7e13da394eaea7143fd571d17574ebe";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5a5c7a6a24e507eb2c4196d56f493a57";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.433333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"988b6303f5b831baac223cd334380c9f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"83febd30a6972fd975b313699f719176";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.816667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7f1d00d462fac795276e6a78d67d37e7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((45.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9e506aed78fa822e56612e47723c3ce1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.277*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.277*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.573889- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eb396bd1556eab6ce7eea1e2343f65bc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d33fbe76db815e7650af89693583860c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((47.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d63f0ec79a9ec9e211c53b41112445d3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2995*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2995*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.85056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbff84c6364f946b23e630d73b0e7a69";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b08b730ef5fe7d849e77ed1a8d32f200";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"327d58673980fbbcb32b0c83939dd079";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"67425fc7044c59be85c4bc16cb14dbe1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((50.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"94a756b38980b42b5d0de0d61fb85d32";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2656*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2656*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.706111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6cdfd6add2c2e72207b69f29265df8cc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"163563c7ff20ad1b6b6f7d369a4bd10f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc7ff2698de4309f49e0ee5cd3e3638b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*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:"663f2c8be1583fb393bbdf9bc501675b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3560bc15433405ff9e320499256ad335";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c5496201d0e27a2cfa44751b61c3f032";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.933333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4114d870f5b6a537c7d77fd27fadeae4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3440cbd27455b67dfd96e9e0deb4cbef";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0333*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:"6ccb4acc815ac84d632063d9e09caf20";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.85*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:"2dd818f9d8c7e104dfa44a0e09359004";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26f9a81f00568b06661d67c52378f563";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((44.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"400253c67a854875b12de1af91e00377";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b3085d088bd744d728955ab1b591c8ba";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"05ceb8579c7bfabadbee92f8055b24de";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e830cc9f44dbe78798d33c5fe6ed784f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fa5ca98a21933c427cd94d800cb4e391";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9389*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9389*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.87722- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0871c231bb5c7eae99bcc949bb98a43c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b8c3ab13b410de474b8c92a80d23fbe2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"08ad0484d33813e44b2c1cd5c001cd2b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.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:"adb80729f535effbfa5d01f49ace2c1e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((43.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"889c9ef3bed1f4169ef9b04e87f218fd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c3c6555aef70ba259a6b69c23407c934";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((46.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f098d2292f9cee4fb91c61bceda69f9a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"638eaaccf0514571e85d981c91894351";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5167*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:"982818be2361d644cba843b0989d7fb2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((4.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be42d25ddae2029c3582b0181ca437eb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.45*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:"855106794f4965e7e34389fd0a03794a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.983333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2ab7c4ccb319d2f597d2645c70b103a7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2317*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2317*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.68306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d4c4c7467de194eb7f41bc5241f6a053";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((46.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9aaf4b6c687d1a10eec67d982ecb3b94";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3203abab7f9005b67d0a24e88a6564bc";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.0167*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:"ab6e101001681e1d56ee8102afba0eb2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"312d36583e0625b123b90018da787097";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8659c4955c241a1fce18354e2ea8a78f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.2581*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2581*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.299167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"44de61341d2bbde4c56a120e0fe5edde";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((47.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"db672d2f0cf8d5367a6ae78954c07c0a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.516667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"798b910d074a5fc90cf7e4d12f3e26ec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b02069cf17e1a476c5bb4bd49a284532";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.36667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4df5703d2898f74e56f9149125c51a7c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9695*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9695*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.178056- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8808545d49c54ef00eb6dfcdf98d586f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7939*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7939*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.93528- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"23b41e68471b892247c590303ab8a8b5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e0aa057ceb20a71926c6c5c149aa0663";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0343b7a8a037964da78586a58b68826c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"25b193078433738fc18fdc69b255b713";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ee138e5895f52872d5cbe5d823a77091";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6833*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:"2e071500db3b23923ea314092fe3a0e2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2bd8ce20b017e6f20ce506284b860f29";a:3:{i:0;s:88:"Etablissement.*, Departement.code, Departement.nom, Departement.slug, Ville.*, Agregat.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"385ad030ae416408b0b18595029a5c5d";a:2:{i:0;s:379:"Etablissement.id, Etablissement.adress, Etablissement.cp_ville, Agregat.imglist, Etablissement.rs, Etablissement.slug,Etablissement.img,Ville.id,Ville.slug,Ville.nom,Ville.lat,Ville.lng,(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";i:1;s:12:"`Ville`.`id`";}s:32:"403c6e660a82fa69b87a696f1c113a11";a:1:{i:0;s:37:"Keyword.lib, Keyword.slug, Keyword.id";}s:32:"eb6fb1782adfc6d8a8864d3f32dab591";a:1:{i:0;s:20:"`Etablissement`.`id`";}s:32:"dd08a8531e9f680ecbf27f45e43f296f";a:3:{i:0;s:27:"`EtablissementKeyword`.`id`";i:1;s:41:"`EtablissementKeyword`.`etablissement_id`";i:2;s:35:"`EtablissementKeyword`.`keyword_id`";}s:32:"c6852640fcf038dc2e7ee42c8b6c4097";a:1:{i:0;s:41:"`EtablissementKeyword`.`etablissement_id`";}s:32:"eeab83cba95d4a0d201dbcb17f0e8d55";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"1b2c074bd5e2d269d177aa66ef6ab159";a:1:{i:0;s:24:"`Ville`.`departement_id`";}s:32:"ea0e1579f0e6d3ac7f276247b53988e6";a:1:{i:0;s:25:"`Departement`.`region_id`";}s:32:"041ee62018e3ca758af163685add8078";a:10:{i:0;s:10:"`Pub`.`id`";i:1;s:13:"`Pub`.`title`";i:2;s:12:"`Pub`.`link`";i:3;s:11:"`Pub`.`lat`";i:4;s:15:"`Pub`.`adresse`";i:5;s:11:"`Pub`.`lng`";i:6;s:11:"`Pub`.`img`";i:7;s:14:"`Pub`.`height`";i:8;s:12:"`Pub`.`view`";i:9;s:16:"`Pub`.`view_max`";}s:32:"0bb5dcb994ccbba507f69081cc992ddb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b9c92f355d2e79a5bd9b220d22325205";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2ea3395a7876f0f8a0f6f8a44b6ced6f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"83a49161c138390efcd5ca235290e6d4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4833*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:"ca501b94b7e86d1a08821282b1d7cfe3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4833*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:"9633ba93fa1025541cb533424cfd2239";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"edecc85b02aab99bfd6200bc7f182062";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((50.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.808- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6953ce82c2f37afc8e19f813b410b6a1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((49.577*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.577*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.56306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a4ceec624c16582667e355cdc5168f8b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4734*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4734*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.08917- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e66feed840617799da3cdd7b38ce8d1e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5e54143c8db57ea76136ed81ceb70522";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((45.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b4337ed72e91e7d874e8539b233c5902";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9d8f3b53af8eb3b36539c5f23fc83c34";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bfd0ce986b7f610d071e5e9e4345f055";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"21dc832b9919be5d5ea7aaf7ec3c2cda";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((49.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ce3ce594ef76817167a9a16de0c14996";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"90da87a2aa3f8a334e37e268f0c583b4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6667*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:"f91736299a81df819f09a3245fabc139";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((44.4564*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4564*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.295- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f6b3c543f8246682f141378566aa04aa";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((50.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"527b186b34e316d286ccab0e49b1019e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.166667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"690301d060ff54cb34cca915658c645a";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((47.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ca1db67603aee538303e86bbb648ccee";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"90af771b95256e1ec16741e2231b7a20";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:198:"(((acos(sin((47.0083*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0083*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.225- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9882f03422e2c6a8d8b18772caa353b6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((43.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"579752296781577cc0a98d45667d4d54";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3dbcc28cdfab57377270e8a992bc077b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"85fcc1bb01b2ce3bc303f490568880b4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"16ef21d75320972126e795eaf6776f09";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"badabb79e77a48239992e1e37b4f3c3b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1851ccfe9e9270003826f106fa188d2c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0167*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:"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";}}}'
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) 1738739955,
	'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