Notice (8): unserialize(): Error at offset 104885 of 105080 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) 1738782016 $cachetime = (int) 1738782024 $data = 'a:3:{i:0;b:0;s:4:"name";a:514:{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:"adcc43a2d25dc203500e589dc69499c4";s:17:""penne-d-agenais"";s:32:"b0c00f584f41e29ee636e99a6a2f4659";s:7:""47203"";s:32:"fe755c17c602fff6a21cbf3ce1314f25";s:12:""lalandusse"";s:32:"6f0b162d7c90b97432f27216cf3005bb";s:7:""47132"";s:32:"0c0fdacb8bb1b6bf496e6421dac2995d";s:11:""jasseines"";s:32:"8cc7ddffcd4f75eabdfab0fe3f9c47d1";s:7:""10175"";s:32:"4696602720ecd6b38ad1edfe827951a6";s:16:""helfrantzkirch"";s:32:"06feb10179829d96131c0cb31eeaa103";s:7:""68132"";s:32:"7bcce400a849c4183bbfe2560f680d9d";s:14:""cuxac-d-aude"";s:32:"d68824edeaf64d54530409cecdda1cd5";s:7:""11116"";s:32:"fdc9de6ae314baa9a406e7f6dd6f7adc";s:18:""sorcy-bauthemont"";s:32:"5f4c8f688be416888d42d3b78ffb81e1";s:7:""08428"";s:32:"29dc99476d6df1159d16c2d3960b69f5";s:14:""casteljaloux"";s:32:"ae1407948ae6caa005b1ce064a277714";s:7:""47052"";s:32:"8684e79aee1406202e3a7263ac67f3f8";s:17:""ranspach-le-bas"";s:32:"b4ab4757acb729323080f736abd1797f";s:7:""68263"";s:32:"56bf7f9c1fb9a80ad7bd38e66ec443f7";s:11:""cernay-68"";s:32:"a0a0a3cfa4b7becb6da941119d7f0648";s:7:""68063"";s:32:"a34c67f04f9528ae69a9beb0f62b80e2";s:10:""uffholtz"";s:32:"505e027e436b0961deef575262ca262e";s:7:""68342"";s:32:"a95b918856c3aa92bab87096c80b00e6";s:9:""doussay"";s:32:"e49a33add34cd88da33907b92e1a2d8d";s:7:""86096"";s:32:"5182ee2a35719b77c85b70580460bae0";s:14:""boisserolles"";s:32:"defc0b94d4e7e69768a3543384e6a6e0";s:7:""79039"";s:32:"a272db8ecf6995e5844ee4a7202a17df";s:10:""locmaria"";s:32:"a6a1639391d3ac42513829ba638a2ab5";s:7:""56114"";s:32:"4d5f4e11289c9516cb4eecc4e610c256";s:12:""knoeringue"";s:32:"1fce5ef67a8bcebfb6979135ed2d6e61";s:7:""68168"";s:32:"3afdcc203837e9c493f3eabe1269b000";s:14:""petit-landau"";s:32:"12e8eafaa7ab1b4efaab8ce56a8cb3ec";s:7:""68254"";s:32:"84bb3243707990a52094324652e15737";s:8:""niffer"";s:32:"519538e639d332423fe4b0e6327a7e60";s:7:""68238"";s:32:"315b61774854805febd8780078638d3e";s:9:""buhl-68"";s:32:"c1467fba63b73e4045be69cd7a2a0f4c";s:7:""68058"";s:32:"08a70ed7606e4bde20583b54917b4831";s:15:""vaux-le-penil"";s:32:"25e4fcedaebbd1a80ee1e9fe6eead1e5";s:7:""77487"";s:32:"39b71ac2b1392e127713aa8d48f6448c";s:9:""murbach"";s:32:"73ecde0958bc60665e1652bb2864f649";s:7:""68229"";s:32:"e157bc4679449617a28ecf8f13bebca6";s:11:""mont-dieu"";s:32:"f46038a89173c0b958c092368b86ca6a";s:7:""08300"";s:32:"76df8ef42b1baf9031c836f044febfb6";s:13:""montigny-76"";s:32:"8dd3326416828c2646e5b76aa1944bf0";s:7:""76446"";s:32:"a4fec376ef4f8bbaac4658744cffceba";s:6:""etuz"";s:32:"6905dcb15f3c0355d50e3d81ac898ab7";s:7:""70224"";s:32:"853f372816864c044a09056666da6370";s:25:""rimbach-pres-guebwiller"";s:32:"ae837b893ae586f0748b88306661395e";s:7:""68274"";s:32:"614cc3606cdd955f9b605a8aea89593b";s:11:""montherme"";s:32:"f24e3371cd228fb4d525878e8eaa174b";s:7:""08302"";s:32:"192f461f703cfa43284a5c84f3de7a86";s:12:""guebwiller"";s:32:"ede5c27d17ca8004df52cedbb89ac221";s:7:""68112"";s:32:"043aabfece65eaa657a8fdab22ecaba4";s:25:""st-laurent-en-grandvaux"";s:32:"e2de60c40ef51dbd7a299ee7d7353f5b";s:7:""39487"";s:32:"1377f3db8fcaac5abb31e1e5f4aa25e5";s:16:""puch-d-agenais"";s:32:"f334248b40a72ea12677920d3b10274d";s:7:""47214"";s:32:"f2167797382244cd9e1c6455d90e1a1f";s:9:""vivonne"";s:32:"07575f4c4440f07496fd0c2c78f2eaac";s:7:""86293"";s:32:"347dbee33aa7d263c0e586524b16dcd9";s:18:""terron-sur-aisne"";s:32:"efaee9cff6cde3e5d8d0d4d25cc8f388";s:7:""08443"";s:32:"2daa5fbc5a7aa94ae7c55385a86b12b6";s:8:""caudan"";s:32:"d34d36ad5a7e179ad0c712071432a09d";s:7:""56036"";s:32:"e97bd7e1d8bb7506a83d556f3d057337";s:18:""villers-la-ville"";s:32:"083f77f43beb57b5002c080e625053ec";s:7:""70562"";s:32:"40dbe3246bb45c27e25d2e02637a1a16";s:10:""loisy-54"";s:32:"e23171a8265f07e4a075009c232d0662";s:7:""54320"";s:32:"364f136c71c7bda6b3d0a5e459cbbbff";s:9:""brûlon"";s:32:"c46e602cab754d0bcf64aea90e235e07";s:11:""pharmacie"";s:32:"78c3ebc8fc89dea4e4152cff4eb81754";s:24:""moncontour-de-bretagne"";s:32:"f1269139f52e54af963bb1fabcff2ea7";s:7:""22153"";s:32:"4a3bd1a0fcd56a417651dee38ac9cac5";s:14:""handschuheim"";s:32:"095ca9605d2e918f041fae27395021e0";s:7:""67181"";s:32:"f19e0c86c29b41543d7bc103c4d23125";s:15:""bennwihr-gare"";s:32:"d31900430d948aebff93c253a37bb6d1";s:7:""68270"";s:32:"e38991a3725dcef41e7985348cb9b1d2";s:25:""alland-huy-et-sausseuil"";s:32:"1f49973442e32855d3f973754c26cc66";s:7:""08006"";}s:6:"fields";a:189:{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:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s: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:"9053e87663b6bdd1da8d3aa7aba4def9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((44.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3974a97fd4a6a27e4f742a8a6c930c7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9afc68732468aaf31b6e1c15dd40f735";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2655726c632ef5aab3e33aae4a911582";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((47.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bec399a53f11746e2871728370d8ae0b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((43.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"63ad73662f9303e48a9f1e48db12366b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.55*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:"f3ee2483d493ea0f0b343391b00a5b3d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((0.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a8caa5be50531712028c710ca5a0559d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ac550b4a4020d2c8ef3f30f95051c79b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1a9d06cb4667148501c1d8ba70b942da";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.266667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1aef15c23caba1ba809cda66afd20c8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.466667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7c14b3af1a3b5571fa4eb47d6d129e2b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2917*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2917*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fd52c02041838999d1da5c38210a453c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0fe64eab189f6662d08fc4575383b6d0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"70f5de750830838c5e0a893ca4d0b6d2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((7.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"37c26535a7a9c01187b8284dbb13a168";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0f67eee35e87f79fa75191e5539b3a04";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fe0e3dbad0e78b65e3a0112181951191";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.535*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.535*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.87806- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6d6d8aa22377253c1dcaba5872b1634b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a03ca8bf99b63884fe4e6c284ea16a39";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*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:"66fe6bbf56ffd1502bc89c06fe3e0e07";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((47.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"11166ead9277fd78113773fe8516c451";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c5246a10cbd0b670b135991d90b8e2c0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5e6336200816202b630e3d6b75eccdbd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5764*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5764*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.95667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"edeff5cdf317faf90c4ad3d2d6e6c04d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3167*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:"c347477745651e29d07e119d84610722";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.266667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c72a9d0af9f06f003c719c34bcc59deb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d6b3006e2e39f96a921701e16bf11fed";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"43663115f99dafa2417fd174cf2d004b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ec42e0565c2277dfc71ea3e2f6683dab";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"de0ea3a3e5296c7be6a612c91dc55414";a:3:{i:0;s:50:"Ville.*, Etablissement.*, Agregat.*, Departement.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"03a375efbcbe5ee497b5d148673088ff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:178:"(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"556bac3a45c13590650dd218088bce2c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a3766adeff93443dc29f089025dcec6d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8fe579b4556c9f34dffa8d87a1ddc156";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"93434041f749d788a03e6641d773e503";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as'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 EtablissementsController::index() - APP/Controller/EtablissementsController.php, line 171 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 111
Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/dansmaprovince/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]Code Contextsetcookie($name, $c['value'], $c['expire'], $c['path'],$c['domain'], $c['secure'], $c['httpOnly']$c = array( 'name' => 'CakeCookie[autologin]', 'value' => '', 'expire' => (int) 1738740016, '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 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 294 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Etablissement.codeinsee' in 'where clause'
SQL Query: SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "22278"
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
try {$query = $this->_connection->prepare($sql, $prepareOptions);$query->setFetchMode(PDO::FETCH_LAZY);if (!$query->execute($params)) {$this->_result = $query;
array()
$options += array('log' => $this->fullDebug);$t = microtime(true);$this->_result = $this->_execute($sql, $params);
'SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "22278"' array()
if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {return $cached;}$result = $this->execute($sql, array(), $params);if ($result) {
'SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "22278"' array( 'log' => true ) array()
// Build SQL statement with the primary model, plus hasOne and belongsTo associations$query = $this->buildAssociationQuery($Model, $queryData);$resultSet = $this->fetchAll($query, $Model->cacheQueries);unset($query);
'SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "22278"' array()
* @return array*/protected function _readDataSource($type, $query) {$results = $this->getDataSource()->read($this, $query);$this->resetAssociations();
object(Etablissement) {
actsAs => array(
(int) 0 => 'Containable'
)
belongsTo => array(
'Etablissement' => array(
'className' => 'Etablissement',
'foreignKey' => 'etablissement_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
),
'Ville' => array(
'className' => 'Ville',
'foreignKey' => 'ville_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
),
'Agregat' => array(
'className' => 'Agregat',
'foreignKey' => 'agregat_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
),
'Plaquette' => array(
'className' => 'Plaquette',
'foreignKey' => 'plaquette_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
)
)
hasMany => array(
'EtablissementKeyword' => array(
'className' => 'EtablissementKeyword',
'foreignKey' => 'etablissement_id',
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'dependent' => '',
'exclusive' => '',
'finderQuery' => '',
'counterQuery' => ''
),
'Comment' => array(
'className' => 'Comment',
'foreignKey' => 'etablissement_id',
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'dependent' => '',
'exclusive' => '',
'finderQuery' => '',
'counterQuery' => ''
)
)
recursive => (int) -1
useDbConfig => 'default'
useTable => 'etablissements'
id => false
data => array()
schemaName => 'lepetitbz331'
table => 'etablissements'
primaryKey => 'id'
validate => array()
validationErrors => array()
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Etablissement'
alias => 'Etablissement'
tableToModel => array(
'etablissements' => 'Etablissement'
)
cacheQueries => false
hasOne => array()
hasAndBelongsToMany => array()
Behaviors => object(BehaviorCollection) {
modelName => 'Etablissement'
defaultPriority => (int) 10
[protected] _methods => array(
[maximum depth reached]
)
[protected] _mappedMethods => array([maximum depth reached])
[protected] _enabled => array(
[maximum depth reached]
)
[protected] _loaded => array(
[maximum depth reached]
)
}
whitelist => array()
cacheSources => true
findQueryType => 'all'
order => null
virtualFields => array()
__backAssociation => array()
__backInnerAssociation => array()
__backOriginalAssociation => array()
__backContainableAssociation => array()
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
'all' => true,
'first' => true,
'count' => true,
'neighbors' => true,
'list' => true,
'threaded' => true
)
[protected] _schema => null
[protected] _associationKeys => array(
'belongsTo' => array(
(int) 0 => 'className',
(int) 1 => 'foreignKey',
(int) 2 => 'conditions',
(int) 3 => 'fields',
(int) 4 => 'order',
(int) 5 => 'counterCache'
),
'hasOne' => array(
(int) 0 => 'className',
(int) 1 => 'foreignKey',
(int) 2 => 'conditions',
(int) 3 => 'fields',
(int) 4 => 'order',
(int) 5 => 'dependent'
),
'hasMany' => array(
(int) 0 => 'className',
(int) 1 => 'foreignKey',
(int) 2 => 'conditions',
(int) 3 => 'fields',
(int) 4 => 'order',
(int) 5 => 'limit',
(int) 6 => 'offset',
(int) 7 => 'dependent',
(int) 8 => 'exclusive',
(int) 9 => 'finderQuery',
(int) 10 => 'counterQuery'
),
'hasAndBelongsToMany' => array(
(int) 0 => 'className',
(int) 1 => 'joinTable',
(int) 2 => 'with',
(int) 3 => 'foreignKey',
(int) 4 => 'associationForeignKey',
(int) 5 => 'conditions',
(int) 6 => 'fields',
(int) 7 => 'order',
(int) 8 => 'limit',
(int) 9 => 'offset',
(int) 10 => 'unique',
(int) 11 => 'finderQuery'
)
)
[protected] _associations => array(
(int) 0 => 'belongsTo',
(int) 1 => 'hasOne',
(int) 2 => 'hasMany',
(int) 3 => 'hasAndBelongsToMany'
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {
[protected] _generalManager => object(CakeEventManager) {}
[protected] _listeners => array(
[maximum depth reached]
)
[protected] _isGlobal => false
}
[protected] _validator => null
}
array(
'conditions' => ' Etablissement.codeinsee = "22278"',
'fields' => array(
(int) 0 => '`Etablissement`.*',
(int) 1 => '`Agregat`.*',
(int) 2 => '`Ville`.`nom`'
),
'joins' => array(
(int) 0 => array(
'table' => 'villes',
'alias' => 'Ville',
'type' => 'LEFT',
'conditions' => array(
(int) 0 => 'Etablissement.codeinsee = Ville.code_commune'
)
),
(int) 1 => array(
'table' => 'categories',
'alias' => 'Categorie',
'type' => 'LEFT',
'conditions' => array(
(int) 0 => 'Categorie.siret = Etablissement.siret'
)
),
(int) 2 => array(
'table' => 'agregats',
'alias' => 'Agregat',
'type' => 'LEFT',
'conditions' => array(
(int) 0 => 'Agregat.id = Categorie.categorie'
)
)
),
'limit' => null,
'offset' => null,
'order' => array(),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'having' => null,
'lock' => null
)return null;}return $this->_readDataSource($type, $query);}
'all' array( 'conditions' => ' Etablissement.codeinsee = "22278"', 'fields' => 'Etablissement.*, Agregat.*, Ville.nom', 'joins' => array( (int) 0 => array( 'table' => 'villes', 'alias' => 'Ville', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Etablissement.codeinsee = Ville.code_commune' ) ), (int) 1 => array( 'table' => 'categories', 'alias' => 'Categorie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Categorie.siret = Etablissement.siret' ) ), (int) 2 => array( 'table' => 'agregats', 'alias' => 'Agregat', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Agregat.id = Categorie.categorie' ) ) ), 'limit' => null, 'offset' => null, 'order' => array(), 'page' => (int) 1, 'group' => null, 'callbacks' => true )
$d['artisans'] = $this->Etablissement->find('all', array('fields' => 'Etablissement.*, Agregat.*, Ville.nom','joins' => $joins2,'conditions'=>' Etablissement.codeinsee = "'.$d['data']['Ville']['code_commune'].'"'));
'all' array( 'conditions' => ' Etablissement.codeinsee = "22278"', 'fields' => 'Etablissement.*, Agregat.*, Ville.nom', 'joins' => array( (int) 0 => array( 'table' => 'villes', 'alias' => 'Ville', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Etablissement.codeinsee = Ville.code_commune' ) ), (int) 1 => array( 'table' => 'categories', 'alias' => 'Categorie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Categorie.siret = Etablissement.siret' ) ), (int) 2 => array( 'table' => 'agregats', 'alias' => 'Agregat', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Agregat.id = Categorie.categorie' ) ) ), 'limit' => null, 'offset' => null, 'order' => array(), 'page' => (int) 1, 'group' => null, 'callbacks' => true )
'st-brieuc'
'action' => $request->params['action']));}return $method->invokeArgs($this, $request->params['pass']);
object(EtablissementsController) {
helpers => array(
(int) 0 => 'Text',
(int) 1 => 'Js',
'Form' => array(
'className' => 'FormExt'
),
(int) 2 => 'Html',
(int) 3 => 'Date',
(int) 4 => 'Session'
)
components => array(
(int) 0 => 'AutoLogin',
'Auth' => array(
'loginAction' => array(
[maximum depth reached]
),
'loginRedirect' => array(
[maximum depth reached]
),
'logoutRedirect' => array(
[maximum depth reached]
),
'authorize' => array(
[maximum depth reached]
),
'authError' => 'You are not authorized to view this page.'
),
(int) 1 => 'RequestHandler',
(int) 2 => 'Session',
(int) 3 => 'Img',
(int) 4 => 'Paginator'
)
name => 'Etablissements'
uses => array(
(int) 0 => 'Etablissement',
(int) 1 => 'Departement',
(int) 2 => 'Ville',
(int) 3 => 'Epublic'
)
request => object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'pros/st-brieuc'
base => ''
webroot => '/'
here => '/pros/st-brieuc'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
response => object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _fileRange => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array(
[maximum depth reached]
)
}
viewPath => 'Etablissements'
layoutPath => null
viewVars => array(
'username' => null
)
view => 'index'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {
defaultPriority => (int) 10
[protected] _Controller => object(EtablissementsController) {}
[protected] _enabled => array(
[maximum depth reached]
)
[protected] _loaded => array(
[maximum depth reached]
)
}
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
(int) 0 => 'st-brieuc'
)
scaffold => false
methods => array(
(int) 0 => 'admin_MAJRGE',
(int) 1 => 'admin_addRGE',
(int) 2 => 'index',
(int) 3 => 'departements',
(int) 4 => 'annuaire',
(int) 5 => 'demande',
(int) 6 => 'view',
(int) 7 => 'partners',
(int) 8 => 'admin_index',
(int) 9 => 'admin_add',
(int) 10 => 'admin_add2',
(int) 11 => 'admin_delete',
(int) 12 => 'admin_plupload',
(int) 13 => 'plupload',
(int) 14 => 'admin_up_catalogue',
(int) 15 => 'admin_demandes',
(int) 16 => 'admin_demande',
(int) 17 => 'admin_del_dmd',
(int) 18 => 'admin_catalogue',
(int) 19 => 'admin_del_catalogue',
(int) 20 => 'admin_export',
(int) 21 => 'admin_set_cat_export',
(int) 22 => 'admin_export_imp',
(int) 23 => 'search',
(int) 24 => 'admin_desc',
(int) 25 => 'admin_update_finess',
(int) 26 => 'admin_finess',
(int) 27 => 'admin_finess_add',
(int) 28 => 'prono',
(int) 29 => 'admin_tpvoie',
(int) 30 => 'admin_fslug',
(int) 31 => 'admin_villeid',
(int) 32 => '_usersUsername',
(int) 34 => 'isAuthorized'
)
modelClass => 'Etablissement'
modelKey => 'etablissement'
validationErrors => null
AutoLogin => object(AutoLoginComponent) {
components => array(
[maximum depth reached]
)
model => 'User'
username => 'username'
password => 'password'
plugin => ''
controller => 'users'
loginAction => 'login'
logoutAction => 'logout'
cookieName => 'autologin'
expires => '+2 weeks'
cookieLocalDomain => false
redirect => true
requirePrompt => true
active => true
settings => array([maximum depth reached])
Cookie => object(CookieComponent) {}
Auth => object(AuthComponent) {}
[protected] _debug => false
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
Auth => object(AuthComponent) {
components => array(
[maximum depth reached]
)
authenticate => array(
[maximum depth reached]
)
authorize => array(
[maximum depth reached]
)
ajaxLogin => null
flash => array(
[maximum depth reached]
)
loginAction => array(
[maximum depth reached]
)
loginRedirect => array(
[maximum depth reached]
)
logoutRedirect => array(
[maximum depth reached]
)
authError => 'You are not authorized to view this page.'
unauthorizedRedirect => true
allowedActions => array(
[maximum depth reached]
)
request => object(CakeRequest) {}
response => object(CakeResponse) {}
settings => array(
[maximum depth reached]
)
[protected] _authenticateObjects => array(
[maximum depth reached]
)
[protected] _authorizeObjects => array([maximum depth reached])
[protected] _user => array([maximum depth reached])
[protected] _methods => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
RequestHandler => object(RequestHandlerComponent) {
ajaxLayout => 'ajax'
enabled => true
request => object(CakeRequest) {}
response => object(CakeResponse) {}
ext => null
params => array(
[maximum depth reached]
)
settings => array(
[maximum depth reached]
)
components => array([maximum depth reached])
[protected] _renderType => null
[protected] _inputTypeMap => array(
[maximum depth reached]
)
[protected] _viewClassMap => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Session => object(SessionComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Img => object(ImgComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Paginator => object(PaginatorComponent) {
settings => array(
[maximum depth reached]
)
whitelist => array(
[maximum depth reached]
)
components => array([maximum depth reached])
Controller => object(EtablissementsController) {}
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Departement => object(Departement) {
belongTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'departements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'departements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Departement'
alias => 'Departement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
belongsTo => array([maximum depth reached])
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array(
[maximum depth reached]
)
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Ville => object(Ville) {
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'villes'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'villes'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Ville'
alias => 'Ville'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
Departement => object(Departement) {}
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Epublic => object(Epublic) {
name => 'Epublic'
belongsTo => array(
[maximum depth reached]
)
validate => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'epublics'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'epublics'
primaryKey => 'id'
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
alias => 'Epublic'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasMany => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Etablissement => object(Etablissement) {
actsAs => array(
[maximum depth reached]
)
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
useDbConfig => 'default'
useTable => 'etablissements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'etablissements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Etablissement'
alias => 'Etablissement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => 'all'
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {
[protected] _generalManager => object(CakeEventManager) {}
[protected] _listeners => array(
[maximum depth reached]
)
[protected] _isGlobal => false
}
}
array(
(int) 0 => 'st-brieuc'
)$response = $controller->response;$render = true;$result = $controller->invokeAction($request);if ($result instanceof CakeResponse) {
object(CakeRequest) {
params => array(
'plugin' => null,
'controller' => 'etablissements',
'action' => 'index',
'named' => array(),
'pass' => array(
(int) 0 => 'st-brieuc'
),
'ville' => 'st-brieuc',
'isAjax' => false,
'models' => array(
'Departement' => array(
[maximum depth reached]
),
'Ville' => array(
[maximum depth reached]
),
'Epublic' => array(
[maximum depth reached]
),
'Etablissement' => array(
[maximum depth reached]
)
)
)
data => array()
query => array()
url => 'pros/st-brieuc'
base => ''
webroot => '/'
here => '/pros/st-brieuc'
[protected] _detectors => array(
'get' => array(
'env' => 'REQUEST_METHOD',
'value' => 'GET'
),
'patch' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PATCH'
),
'post' => array(
'env' => 'REQUEST_METHOD',
'value' => 'POST'
),
'put' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PUT'
),
'delete' => array(
'env' => 'REQUEST_METHOD',
'value' => 'DELETE'
),
'head' => array(
'env' => 'REQUEST_METHOD',
'value' => 'HEAD'
),
'options' => array(
'env' => 'REQUEST_METHOD',
'value' => 'OPTIONS'
),
'ssl' => array(
'env' => 'HTTPS',
'value' => (int) 1
),
'ajax' => array(
'env' => 'HTTP_X_REQUESTED_WITH',
'value' => 'XMLHttpRequest'
),
'flash' => array(
'env' => 'HTTP_USER_AGENT',
'pattern' => '/^(Shockwave|Adobe) Flash/'
),
'mobile' => array(
'env' => 'HTTP_USER_AGENT',
'options' => array(
[maximum depth reached]
)
),
'requested' => array(
'param' => 'requested',
'value' => (int) 1
),
'json' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'json'
),
'xml' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'xml'
)
)
[protected] _input => ''
}));}$response = $this->_invoke($controller, $request);if (isset($request->params['return'])) {
object(EtablissementsController) {
helpers => array(
(int) 0 => 'Text',
(int) 1 => 'Js',
'Form' => array(
'className' => 'FormExt'
),
(int) 2 => 'Html',
(int) 3 => 'Date',
(int) 4 => 'Session'
)
components => array(
(int) 0 => 'AutoLogin',
'Auth' => array(
'loginAction' => array(
[maximum depth reached]
),
'loginRedirect' => array(
[maximum depth reached]
),
'logoutRedirect' => array(
[maximum depth reached]
),
'authorize' => array(
[maximum depth reached]
),
'authError' => 'You are not authorized to view this page.'
),
(int) 1 => 'RequestHandler',
(int) 2 => 'Session',
(int) 3 => 'Img',
(int) 4 => 'Paginator'
)
name => 'Etablissements'
uses => array(
(int) 0 => 'Etablissement',
(int) 1 => 'Departement',
(int) 2 => 'Ville',
(int) 3 => 'Epublic'
)
request => object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'pros/st-brieuc'
base => ''
webroot => '/'
here => '/pros/st-brieuc'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
response => object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _fileRange => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array(
[maximum depth reached]
)
}
viewPath => 'Etablissements'
layoutPath => null
viewVars => array(
'username' => null
)
view => 'index'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {
defaultPriority => (int) 10
[protected] _Controller => object(EtablissementsController) {}
[protected] _enabled => array(
[maximum depth reached]
)
[protected] _loaded => array(
[maximum depth reached]
)
}
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
(int) 0 => 'st-brieuc'
)
scaffold => false
methods => array(
(int) 0 => 'admin_MAJRGE',
(int) 1 => 'admin_addRGE',
(int) 2 => 'index',
(int) 3 => 'departements',
(int) 4 => 'annuaire',
(int) 5 => 'demande',
(int) 6 => 'view',
(int) 7 => 'partners',
(int) 8 => 'admin_index',
(int) 9 => 'admin_add',
(int) 10 => 'admin_add2',
(int) 11 => 'admin_delete',
(int) 12 => 'admin_plupload',
(int) 13 => 'plupload',
(int) 14 => 'admin_up_catalogue',
(int) 15 => 'admin_demandes',
(int) 16 => 'admin_demande',
(int) 17 => 'admin_del_dmd',
(int) 18 => 'admin_catalogue',
(int) 19 => 'admin_del_catalogue',
(int) 20 => 'admin_export',
(int) 21 => 'admin_set_cat_export',
(int) 22 => 'admin_export_imp',
(int) 23 => 'search',
(int) 24 => 'admin_desc',
(int) 25 => 'admin_update_finess',
(int) 26 => 'admin_finess',
(int) 27 => 'admin_finess_add',
(int) 28 => 'prono',
(int) 29 => 'admin_tpvoie',
(int) 30 => 'admin_fslug',
(int) 31 => 'admin_villeid',
(int) 32 => '_usersUsername',
(int) 34 => 'isAuthorized'
)
modelClass => 'Etablissement'
modelKey => 'etablissement'
validationErrors => null
AutoLogin => object(AutoLoginComponent) {
components => array(
[maximum depth reached]
)
model => 'User'
username => 'username'
password => 'password'
plugin => ''
controller => 'users'
loginAction => 'login'
logoutAction => 'logout'
cookieName => 'autologin'
expires => '+2 weeks'
cookieLocalDomain => false
redirect => true
requirePrompt => true
active => true
settings => array([maximum depth reached])
Cookie => object(CookieComponent) {}
Auth => object(AuthComponent) {}
[protected] _debug => false
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
Auth => object(AuthComponent) {
components => array(
[maximum depth reached]
)
authenticate => array(
[maximum depth reached]
)
authorize => array(
[maximum depth reached]
)
ajaxLogin => null
flash => array(
[maximum depth reached]
)
loginAction => array(
[maximum depth reached]
)
loginRedirect => array(
[maximum depth reached]
)
logoutRedirect => array(
[maximum depth reached]
)
authError => 'You are not authorized to view this page.'
unauthorizedRedirect => true
allowedActions => array(
[maximum depth reached]
)
request => object(CakeRequest) {}
response => object(CakeResponse) {}
settings => array(
[maximum depth reached]
)
[protected] _authenticateObjects => array(
[maximum depth reached]
)
[protected] _authorizeObjects => array([maximum depth reached])
[protected] _user => array([maximum depth reached])
[protected] _methods => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
RequestHandler => object(RequestHandlerComponent) {
ajaxLayout => 'ajax'
enabled => true
request => object(CakeRequest) {}
response => object(CakeResponse) {}
ext => null
params => array(
[maximum depth reached]
)
settings => array(
[maximum depth reached]
)
components => array([maximum depth reached])
[protected] _renderType => null
[protected] _inputTypeMap => array(
[maximum depth reached]
)
[protected] _viewClassMap => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Session => object(SessionComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Img => object(ImgComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Paginator => object(PaginatorComponent) {
settings => array(
[maximum depth reached]
)
whitelist => array(
[maximum depth reached]
)
components => array([maximum depth reached])
Controller => object(EtablissementsController) {}
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Departement => object(Departement) {
belongTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'departements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'departements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Departement'
alias => 'Departement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
belongsTo => array([maximum depth reached])
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array(
[maximum depth reached]
)
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Ville => object(Ville) {
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'villes'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'villes'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Ville'
alias => 'Ville'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
Departement => object(Departement) {}
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Epublic => object(Epublic) {
name => 'Epublic'
belongsTo => array(
[maximum depth reached]
)
validate => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'epublics'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'epublics'
primaryKey => 'id'
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
alias => 'Epublic'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasMany => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Etablissement => object(Etablissement) {
actsAs => array(
[maximum depth reached]
)
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
useDbConfig => 'default'
useTable => 'etablissements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'etablissements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Etablissement'
alias => 'Etablissement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => 'all'
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {
[protected] _generalManager => object(CakeEventManager) {}
[protected] _listeners => array(
[maximum depth reached]
)
[protected] _isGlobal => false
}
}
object(CakeRequest) {
params => array(
'plugin' => null,
'controller' => 'etablissements',
'action' => 'index',
'named' => array(),
'pass' => array(
(int) 0 => 'st-brieuc'
),
'ville' => 'st-brieuc',
'isAjax' => false,
'models' => array(
'Departement' => array(
[maximum depth reached]
),
'Ville' => array(
[maximum depth reached]
),
'Epublic' => array(
[maximum depth reached]
),
'Etablissement' => array(
[maximum depth reached]
)
)
)
data => array()
query => array()
url => 'pros/st-brieuc'
base => ''
webroot => '/'
here => '/pros/st-brieuc'
[protected] _detectors => array(
'get' => array(
'env' => 'REQUEST_METHOD',
'value' => 'GET'
),
'patch' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PATCH'
),
'post' => array(
'env' => 'REQUEST_METHOD',
'value' => 'POST'
),
'put' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PUT'
),
'delete' => array(
'env' => 'REQUEST_METHOD',
'value' => 'DELETE'
),
'head' => array(
'env' => 'REQUEST_METHOD',
'value' => 'HEAD'
),
'options' => array(
'env' => 'REQUEST_METHOD',
'value' => 'OPTIONS'
),
'ssl' => array(
'env' => 'HTTPS',
'value' => (int) 1
),
'ajax' => array(
'env' => 'HTTP_X_REQUESTED_WITH',
'value' => 'XMLHttpRequest'
),
'flash' => array(
'env' => 'HTTP_USER_AGENT',
'pattern' => '/^(Shockwave|Adobe) Flash/'
),
'mobile' => array(
'env' => 'HTTP_USER_AGENT',
'options' => array(
[maximum depth reached]
)
),
'requested' => array(
'param' => 'requested',
'value' => (int) 1
),
'json' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'json'
),
'xml' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'xml'
)
)
[protected] _input => ''
}$Dispatcher = new Dispatcher();$Dispatcher->dispatch(new CakeRequest(),new CakeResponse());
object(CakeRequest) {
params => array(
'plugin' => null,
'controller' => 'etablissements',
'action' => 'index',
'named' => array(),
'pass' => array(
(int) 0 => 'st-brieuc'
),
'ville' => 'st-brieuc',
'isAjax' => false,
'models' => array(
'Departement' => array(
[maximum depth reached]
),
'Ville' => array(
[maximum depth reached]
),
'Epublic' => array(
[maximum depth reached]
),
'Etablissement' => array(
[maximum depth reached]
)
)
)
data => array()
query => array()
url => 'pros/st-brieuc'
base => ''
webroot => '/'
here => '/pros/st-brieuc'
[protected] _detectors => array(
'get' => array(
'env' => 'REQUEST_METHOD',
'value' => 'GET'
),
'patch' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PATCH'
),
'post' => array(
'env' => 'REQUEST_METHOD',
'value' => 'POST'
),
'put' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PUT'
),
'delete' => array(
'env' => 'REQUEST_METHOD',
'value' => 'DELETE'
),
'head' => array(
'env' => 'REQUEST_METHOD',
'value' => 'HEAD'
),
'options' => array(
'env' => 'REQUEST_METHOD',
'value' => 'OPTIONS'
),
'ssl' => array(
'env' => 'HTTPS',
'value' => (int) 1
),
'ajax' => array(
'env' => 'HTTP_X_REQUESTED_WITH',
'value' => 'XMLHttpRequest'
),
'flash' => array(
'env' => 'HTTP_USER_AGENT',
'pattern' => '/^(Shockwave|Adobe) Flash/'
),
'mobile' => array(
'env' => 'HTTP_USER_AGENT',
'options' => array(
[maximum depth reached]
)
),
'requested' => array(
'param' => 'requested',
'value' => (int) 1
),
'json' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'json'
),
'xml' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'xml'
)
)
[protected] _input => ''
}
object(CakeResponse) {
[protected] _statusCodes => array(
(int) 100 => 'Continue',
(int) 101 => 'Switching Protocols',
(int) 200 => 'OK',
(int) 201 => 'Created',
(int) 202 => 'Accepted',
(int) 203 => 'Non-Authoritative Information',
(int) 204 => 'No Content',
(int) 205 => 'Reset Content',
(int) 206 => 'Partial Content',
(int) 300 => 'Multiple Choices',
(int) 301 => 'Moved Permanently',
(int) 302 => 'Found',
(int) 303 => 'See Other',
(int) 304 => 'Not Modified',
(int) 305 => 'Use Proxy',
(int) 307 => 'Temporary Redirect',
(int) 400 => 'Bad Request',
(int) 401 => 'Unauthorized',
(int) 402 => 'Payment Required',
(int) 403 => 'Forbidden',
(int) 404 => 'Not Found',
(int) 405 => 'Method Not Allowed',
(int) 406 => 'Not Acceptable',
(int) 407 => 'Proxy Authentication Required',
(int) 408 => 'Request Time-out',
(int) 409 => 'Conflict',
(int) 410 => 'Gone',
(int) 411 => 'Length Required',
(int) 412 => 'Precondition Failed',
(int) 413 => 'Request Entity Too Large',
(int) 414 => 'Request-URI Too Large',
(int) 415 => 'Unsupported Media Type',
(int) 416 => 'Requested range not satisfiable',
(int) 417 => 'Expectation Failed',
(int) 429 => 'Too Many Requests',
(int) 500 => 'Internal Server Error',
(int) 501 => 'Not Implemented',
(int) 502 => 'Bad Gateway',
(int) 503 => 'Service Unavailable',
(int) 504 => 'Gateway Time-out',
(int) 505 => 'Unsupported Version'
)
[protected] _mimeTypes => array(
'html' => array(
(int) 0 => 'text/html',
(int) 1 => '*/*'
),
'json' => 'application/json',
'xml' => array(
(int) 0 => 'application/xml',
(int) 1 => 'text/xml'
),
'rss' => 'application/rss+xml',
'ai' => 'application/postscript',
'bcpio' => 'application/x-bcpio',
'bin' => 'application/octet-stream',
'ccad' => 'application/clariscad',
'cdf' => 'application/x-netcdf',
'class' => 'application/octet-stream',
'cpio' => 'application/x-cpio',
'cpt' => 'application/mac-compactpro',
'csh' => 'application/x-csh',
'csv' => array(
(int) 0 => 'text/csv',
(int) 1 => 'application/vnd.ms-excel'
),
'dcr' => 'application/x-director',
'dir' => 'application/x-director',
'dms' => 'application/octet-stream',
'doc' => 'application/msword',
'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
'drw' => 'application/drafting',
'dvi' => 'application/x-dvi',
'dwg' => 'application/acad',
'dxf' => 'application/dxf',
'dxr' => 'application/x-director',
'eot' => 'application/vnd.ms-fontobject',
'eps' => 'application/postscript',
'exe' => 'application/octet-stream',
'ez' => 'application/andrew-inset',
'flv' => 'video/x-flv',
'gtar' => 'application/x-gtar',
'gz' => 'application/x-gzip',
'bz2' => 'application/x-bzip',
'7z' => 'application/x-7z-compressed',
'hdf' => 'application/x-hdf',
'hqx' => 'application/mac-binhex40',
'ico' => 'image/x-icon',
'ips' => 'application/x-ipscript',
'ipx' => 'application/x-ipix',
'js' => 'application/javascript',
'jsonapi' => 'application/vnd.api+json',
'latex' => 'application/x-latex',
'lha' => 'application/octet-stream',
'lsp' => 'application/x-lisp',
'lzh' => 'application/octet-stream',
'man' => 'application/x-troff-man',
'me' => 'application/x-troff-me',
'mif' => 'application/vnd.mif',
'ms' => 'application/x-troff-ms',
'nc' => 'application/x-netcdf',
'oda' => 'application/oda',
'otf' => 'font/otf',
'pdf' => 'application/pdf',
'pgn' => 'application/x-chess-pgn',
'pot' => 'application/vnd.ms-powerpoint',
'pps' => 'application/vnd.ms-powerpoint',
'ppt' => 'application/vnd.ms-powerpoint',
'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
'ppz' => 'application/vnd.ms-powerpoint',
'pre' => 'application/x-freelance',
'prt' => 'application/pro_eng',
'ps' => 'application/postscript',
'roff' => 'application/x-troff',
'scm' => 'application/x-lotusscreencam',
'set' => 'application/set',
'sh' => 'application/x-sh',
'shar' => 'application/x-shar',
'sit' => 'application/x-stuffit',
'skd' => 'application/x-koan',
'skm' => 'application/x-koan',
'skp' => 'application/x-koan',
'skt' => 'application/x-koan',
'smi' => 'application/smil',
'smil' => 'application/smil',
'sol' => 'application/solids',
'spl' => 'application/x-futuresplash',
'src' => 'application/x-wais-source',
'step' => 'application/STEP',
'stl' => 'application/SLA',
'stp' => 'application/STEP',
'sv4cpio' => 'application/x-sv4cpio',
'sv4crc' => 'application/x-sv4crc',
'svg' => 'image/svg+xml',
'svgz' => 'image/svg+xml',
'swf' => 'application/x-shockwave-flash',
't' => 'application/x-troff',
'tar' => 'application/x-tar',
'tcl' => 'application/x-tcl',
'tex' => 'application/x-tex',
'texi' => 'application/x-texinfo',
'texinfo' => 'application/x-texinfo',
'tr' => 'application/x-troff',
'tsp' => 'application/dsptype',
'ttc' => 'font/ttf',
'ttf' => 'font/ttf',
'unv' => 'application/i-deas',
'ustar' => 'application/x-ustar',
'vcd' => 'application/x-cdlink',
'vda' => 'application/vda',
'xlc' => 'application/vnd.ms-excel',
'xll' => 'application/vnd.ms-excel',
'xlm' => 'application/vnd.ms-excel',
'xls' => 'application/vnd.ms-excel',
'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'xlw' => 'application/vnd.ms-excel',
'zip' => 'application/zip',
'aif' => 'audio/x-aiff',
'aifc' => 'audio/x-aiff',
'aiff' => 'audio/x-aiff',
'au' => 'audio/basic',
'kar' => 'audio/midi',
'mid' => 'audio/midi',
'midi' => 'audio/midi',
'mp2' => 'audio/mpeg',
'mp3' => 'audio/mpeg',
'mpga' => 'audio/mpeg',
'ogg' => 'audio/ogg',
'oga' => 'audio/ogg',
'spx' => 'audio/ogg',
'ra' => 'audio/x-realaudio',
'ram' => 'audio/x-pn-realaudio',
'rm' => 'audio/x-pn-realaudio',
'rpm' => 'audio/x-pn-realaudio-plugin',
'snd' => 'audio/basic',
'tsi' => 'audio/TSP-audio',
'wav' => 'audio/x-wav',
'aac' => 'audio/aac',
'asc' => 'text/plain',
'c' => 'text/plain',
'cc' => 'text/plain',
'css' => 'text/css',
'etx' => 'text/x-setext',
'f' => 'text/plain',
'f90' => 'text/plain',
'h' => 'text/plain',
'hh' => 'text/plain',
'htm' => array(
(int) 0 => 'text/html',
(int) 1 => '*/*'
),
'ics' => 'text/calendar',
'm' => 'text/plain',
'rtf' => 'text/rtf',
'rtx' => 'text/richtext',
'sgm' => 'text/sgml',
'sgml' => 'text/sgml',
'tsv' => 'text/tab-separated-values',
'tpl' => 'text/template',
'txt' => 'text/plain',
'text' => 'text/plain',
'avi' => 'video/x-msvideo',
'fli' => 'video/x-fli',
'mov' => 'video/quicktime',
'movie' => 'video/x-sgi-movie',
'mpe' => 'video/mpeg',
'mpeg' => 'video/mpeg',
'mpg' => 'video/mpeg',
'qt' => 'video/quicktime',
'viv' => 'video/vnd.vivo',
'vivo' => 'video/vnd.vivo',
'ogv' => 'video/ogg',
'webm' => 'video/webm',
'mp4' => 'video/mp4',
'm4v' => 'video/mp4',
'f4v' => 'video/mp4',
'f4p' => 'video/mp4',
'm4a' => 'audio/mp4',
'f4a' => 'audio/mp4',
'f4b' => 'audio/mp4',
'gif' => 'image/gif',
'ief' => 'image/ief',
'jpg' => 'image/jpeg',
'jpeg' => 'image/jpeg',
'jpe' => 'image/jpeg',
'pbm' => 'image/x-portable-bitmap',
'pgm' => 'image/x-portable-graymap',
'png' => 'image/png',
'pnm' => 'image/x-portable-anymap',
'ppm' => 'image/x-portable-pixmap',
'ras' => 'image/cmu-raster',
'rgb' => 'image/x-rgb',
'tif' => 'image/tiff',
'tiff' => 'image/tiff',
'xbm' => 'image/x-xbitmap',
'xpm' => 'image/x-xpixmap',
'xwd' => 'image/x-xwindowdump',
'psd' => array(
(int) 0 => 'application/photoshop',
(int) 1 => 'application/psd',
(int) 2 => 'image/psd',
(int) 3 => 'image/x-photoshop',
(int) 4 => 'image/photoshop',
(int) 5 => 'zz-application/zz-winassoc-psd'
),
'ice' => 'x-conference/x-cooltalk',
'iges' => 'model/iges',
'igs' => 'model/iges',
'mesh' => 'model/mesh',
'msh' => 'model/mesh',
'silo' => 'model/mesh',
'vrml' => 'model/vrml',
'wrl' => 'model/vrml',
'mime' => 'www/mime',
'pdb' => 'chemical/x-pdb',
'xyz' => 'chemical/x-pdb',
'javascript' => 'application/javascript',
'form' => 'application/x-www-form-urlencoded',
'file' => 'multipart/form-data',
'xhtml' => array(
(int) 0 => 'application/xhtml+xml',
(int) 1 => 'application/xhtml',
(int) 2 => 'text/xhtml'
),
'xhtml-mobile' => 'application/vnd.wap.xhtml+xml',
'atom' => 'application/atom+xml',
'amf' => 'application/x-amf',
'wap' => array(
(int) 0 => 'text/vnd.wap.wml',
(int) 1 => 'text/vnd.wap.wmlscript',
(int) 2 => 'image/vnd.wap.wbmp'
),
'wml' => 'text/vnd.wap.wml',
'wmlscript' => 'text/vnd.wap.wmlscript',
'wbmp' => 'image/vnd.wap.wbmp',
'woff' => 'application/x-font-woff',
'webp' => 'image/webp',
'appcache' => 'text/cache-manifest',
'manifest' => 'text/cache-manifest',
'htc' => 'text/x-component',
'rdf' => 'application/xml',
'crx' => 'application/x-chrome-extension',
'oex' => 'application/x-opera-extension',
'xpi' => 'application/x-xpinstall',
'safariextz' => 'application/octet-stream',
'webapp' => 'application/x-web-app-manifest+json',
'vcf' => 'text/x-vcard',
'vtt' => 'text/vtt',
'mkv' => 'video/x-matroska',
'pkpass' => 'application/vnd.apple.pkpass',
'ajax' => 'text/html'
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array()
[protected] _body => null
[protected] _file => null
[protected] _fileRange => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array()
[protected] _cookies => array(
'CakeCookie[autologin]' => array(
'name' => 'CakeCookie[autologin]',
'value' => '',
'expire' => (int) 1738740016,
'path' => '/',
'domain' => '',
'secure' => false,
'httpOnly' => false
)
)
}