$key = 'myapp_cake_core_method_cache'
$time = (int) 1750011189
$cachetime = (int) 1750011198
$data = 'a:3:{i:0;b:0;s:4:"name";a:332:{s:32:"96b7280d050422e829f8f5efce76ed71";s:12:"`maisocr587`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"b3a132b3002f0a095c207367d2386438";s:13:"`Ville`.`dep`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"c5697e1e5c979d7ac16a2058fe255e21";s:13:"`Ville`.`nom`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"c1f9b57df40a583acfdf261e4793fe99";s:20:"`Ville`.`population`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"b4707c5ae31d038ddd76310d59aceb1c";s:13:"`Ville`.`lng`";s:32:"f340c52a13f3cf8684f61cdbc6725f3f";s:13:"`Ville`.`lat`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"70a4a1faf343973daaf7a89bac3df075";s:27:"`Departement`.`nom_soundex`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";s:32:"e6b58a6fd2dddaf18714b7433a8c7703";s:20:"`Departement`.`view`";s:32:"b74474e63c80be3416038fc312c4ea9c";s:28:"`Departement`.`presentation`";s:32:"58a859cc9ae1c3a16eba65ee4ba041d1";s:20:"`Departement`.`img1`";s:32:"8d1bfdd6c45677e3b05204c9cd512952";s:20:"`Departement`.`img2`";s:32:"f237f95c23798028c944020938923a2f";s:20:"`Departement`.`img3`";s:32:"1deb75f50240a5e88d7e4ef44de6d70f";s:25:"`Departement`.`centreDep`";s:32:"96d6b96a24deda50cd542bad76aa9110";s:22:"`Departement`.`geoDep`";s:32:"754e30ff7c998fada2906cf837ec8cbc";s:26:"`Departement`.`population`";s:32:"68d8e0e34e114d3adfcc89f60b9c87c3";s:11:""lentilles"";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"19c7910987b75b908fec5bc5eb4ba426";s:4:""10"";s:32:"f721416f99749f3df35aa11d34cb1cf3";s:12:"`population`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"8b88957fa7732fb17e1a2eb216957c49";s:21:"`Etablissement`.`cac`";s:32:"488e02d2d9b1182f63c3d8f5f847895a";s:43:"`Etablissement`.`dateCreationEtablissement`";s:32:"becfa4e4a7c9b2d19025948a972a6478";s:23:"`Etablissement`.`siret`";s:32:"8bea2320f371062a7b0ab922743bdbd0";s:32:"`Etablissement`.`nomUniteLegale`";s:32:"39941f15b49a2123784b162f8a31c536";s:36:"`Etablissement`.`prenom1UniteLegale`";s:32:"a29bb400575f4ad025669248520b5fd9";s:41:"`Etablissement`.`denominationUniteLegale`";s:32:"c7b4465e36264adda51d3dfc880ea50d";s:41:"`Etablissement`.`numeroVoieEtablissement`";s:32:"8ca3ee58be10f4b9b4b725e42ade3fc6";s:39:"`Etablissement`.`typeVoieEtablissement`";s:32:"de1f07c3d6a17cb43da0576792c1c478";s:42:"`Etablissement`.`libelleVoieEtablissement`";s:32:"e44f29c308bcb4d3419f9acea8bd0088";s:41:"`Etablissement`.`codePostalEtablissement`";s:32:"a35619803f6ab7ff11b719bb5c3cbd7f";s:45:"`Etablissement`.`libelleCommuneEtablissement`";s:32:"9cc9932f961dd20be2485b6e784c67c9";s:9:"`Ville`.*";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"7ab0ad68d7b28d18fabfe0fdc5224200";s:42:"`Etablissement`.`codeCommuneEtablissement`";s:32:"cb457f2b4a1d0ec943ce7dc688d439c8";s:7:""10192"";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"01b1f88d852c1eab2146540107201997";s:9:""etretat"";s:32:"2bce4c68d271bdd14898a6d63dc065d6";s:4:""76"";s:32:"6b65a5620748158d68c40d64fcd80fa8";s:7:""76254"";s:32:"07324375301323e09367293823ad1766";s:8:""lagery"";s:32:"30e0fbe2dedd7496d6607455959eba37";s:4:""51"";s:32:"15eecb2828f07ede85ff56d83e45bf27";s:7:""51314"";s:32:"f7c933cf8ccb3f58bde0be2e58502742";s:10:""monthyon"";s:32:"0c814091063da1002aeaafcae22b575b";s:4:""77"";s:32:"c9443786e19af104a4434132f0adbf2b";s:7:""77309"";s:32:"4b5b179f3d4d02caf2bc8f10c9508150";s:17:"`Etablissement`.*";s:32:"4881f20c5aa26c0469f4bd33c64d89e5";s:14:"`Comment`.`id`";s:32:"60b99a41e18de7d4f2356593a1c2cc3d";s:18:"`Comment`.`pseudo`";s:32:"91239733a2f8a455459509f5d6a17048";s:19:"`Comment`.`etab_id`";s:32:"d1fcf017825e414e48d0f305631b4799";s:19:"`Comment`.`contenu`";s:32:"bc377e3ee747a291022e3d709a322d04";s:16:"`Comment`.`note`";s:32:"79381faecb510d816a0b81f6ae2c6d92";s:20:"`Comment`.`antispam`";s:32:"9941ed581a2ed345603ca6c4fe47d0fc";s:17:"`Comment`.`actif`";s:32:"7907a258585a2c024cf585030578d69d";s:19:"`Comment`.`created`";s:32:"0698907dc910891be17ff02b797ae0bf";s:18:"`Comment`.`posted`";s:32:"e6b8ac227bd20feed342e5ed0866d680";s:10:"`comments`";s:32:"c87b6288c09482f582fd3874f1e9f7a8";s:9:"`Comment`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"467bf317792b573d54885f896ad5118b";s:21:""st-privat-du-dragon"";s:32:"7142166d1e9021c22af48d53bc32d9e5";s:4:""43"";s:32:"e0c54cf4488854ac9aa1823632437f68";s:7:""43222"";s:32:"859c82098f993dcbcb78a7c2e9985800";s:19:""st-bon-tarentaise"";s:32:"bfd41f4b6c418c96827626f7e6347cb6";s:4:""73"";s:32:"0a08c39844bb197a8768e2ab028ef0aa";s:7:""73227"";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"6eb4dd7015d184f5ffa3b3c365c7cbb8";s:21:"`Etablissement`.`nic`";s:32:"982c0b08471d3eb19d95d39ca5a4c90e";s:30:"`Etablissement`.`presentation`";s:32:"e755c47b00b95d0a80664a2eaea7d4e4";s:26:"`Etablissement`.`services`";s:32:"66e1a083d9c40ddbe09a2decd511e929";s:27:"`Etablissement`.`telephone`";s:32:"afee796164b525314c1b52cfaa023a8a";s:30:"`Etablissement`.`siteInternet`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"02a4d5932e057ef23859d2d66ad62328";s:29:"`Etablissement`.`horaireslun`";s:32:"823f98fbb37f74a2082edb4ae0e50bff";s:29:"`Etablissement`.`horairesmar`";s:32:"9220a275d0a1e9825b456ed738b49fab";s:29:"`Etablissement`.`horairesmer`";s:32:"60e136a46f7ff3d2ae54e97d9bcb8b2a";s:29:"`Etablissement`.`horairesjeu`";s:32:"5254a6c5b8c5abc918df881507dc2739";s:29:"`Etablissement`.`horairesven`";s:32:"b97a8a6cd1a7e7eaeeb6dbbf8f55cbd8";s:29:"`Etablissement`.`horairessam`";s:32:"fd7af57afe67e203874bf15fd116c5ed";s:29:"`Etablissement`.`horairesdim`";s:32:"91646e4d20d4df23fbc7f1c1f12e52d5";s:46:"`Etablissement`.`statutDiffusionEtablissement`";s:32:"7a67bc6c84d0e933845655206bd57299";s:47:"`Etablissement`.`trancheEffectifsEtablissement`";s:32:"4cca03bc736d240682f31bc479175fc6";s:45:"`Etablissement`.`anneeEffectifsEtablissement`";s:32:"b5e0acc5fb74973c97b6fa65ee7ab9b7";s:64:"`Etablissement`.`activitePrincipaleRegistreMetiersEtablissement`";s:32:"609d2a146130d598c4995a161aaa9c69";s:52:"`Etablissement`.`dateDernierTraitementEtablissement`";s:32:"f9c94f79342395a7366e95f8dd71212f";s:36:"`Etablissement`.`etablissementSiege`";s:32:"3cbd36ac216dc89e29a18b1a09420d35";s:46:"`Etablissement`.`etatAdministratifUniteLegale`";s:32:"2abf0d6375fdc1490cc75ec9107f8035";s:44:"`Etablissement`.`statutDiffusionUniteLegale`";s:32:"35c0dc49a58aeb81ed994edc8288eaeb";s:40:"`Etablissement`.`unitePurgeeUniteLegale`";s:32:"602d262ec1e0468544d0d74cadf9ac5f";s:41:"`Etablissement`.`dateCreationUniteLegale`";s:32:"3c1bb8be6c41adf6e2af25a9e30a2553";s:47:"`Etablissement`.`categorieJuridiqueUniteLegale`";s:32:"16bbebe410db7ec7764f30f52c59b72d";s:34:"`Etablissement`.`sigleUniteLegale`";s:32:"8172380beca10b657cc6f4bb921a6af3";s:49:"`Etablissement`.`denominationUsuelle1UniteLegale`";s:32:"f361f067350959b3718ab4af57cf7f04";s:49:"`Etablissement`.`denominationUsuelle2UniteLegale`";s:32:"9d1db6de9a316fdc5904f44404fdcec4";s:49:"`Etablissement`.`denominationUsuelle3UniteLegale`";s:32:"1340637afb3ff9ec0b7fb134a88af827";s:33:"`Etablissement`.`sexeUniteLegale`";s:32:"a01c6c637251b20e4de3add569b0a94d";s:37:"`Etablissement`.`nomUsageUniteLegale`";s:32:"281d62a3f604db57876fefd825282fbb";s:36:"`Etablissement`.`prenom2UniteLegale`";s:32:"91382a18baf0d948db0e751ed1189ccc";s:36:"`Etablissement`.`prenom3UniteLegale`";s:32:"d8ca101fdc013efca011a2fcc2113287";s:36:"`Etablissement`.`prenom4UniteLegale`";s:32:"e72a1bfa2789a2b2c61e0cafbb6e07ae";s:40:"`Etablissement`.`prenomUsuelUniteLegale`";s:32:"1165ed12e49da8990a00fcce893216cb";s:39:"`Etablissement`.`pseudonymeUniteLegale`";s:32:"39ca3bfa482d6f040374fea0f28c59e6";s:47:"`Etablissement`.`activitePrincipaleUniteLegale`";s:32:"22e1d764d2a7b79d9a5324cc3d76c042";s:59:"`Etablissement`.`nomenclatureActivitePrincipaleUniteLegale`";s:32:"407e709042920f11d6919aa965148c51";s:51:"`Etablissement`.`identifiantAssociationUniteLegale`";s:32:"f1bb9f988a3023b82d1d5ccb7c62e859";s:53:"`Etablissement`.`economieSocialeSolidaireUniteLegale`";s:32:"7ee4fede5fffb621bc5751c0d5736b06";s:47:"`Etablissement`.`caractereEmployeurUniteLegale`";s:32:"aad5b19747ad6f1965cc70f960d52829";s:45:"`Etablissement`.`trancheEffectifsUniteLegale`";s:32:"a1db1f2da63d817d6f1efafa5dcde392";s:43:"`Etablissement`.`anneeEffectifsUniteLegale`";s:32:"416c5a0d2dbefea27aa5e827fd66fb59";s:37:"`Etablissement`.`nicSiegeUniteLegale`";s:32:"991b30e7103faa2b0e6255947f2b2cc2";s:50:"`Etablissement`.`dateDernierTraitementUniteLegale`";s:32:"b13f5382b8909d0347eb133690ae2628";s:37:"`Etablissement`.`categorieEntreprise`";s:32:"d78772155310451e2b65e5512676d363";s:42:"`Etablissement`.`anneeCategorieEntreprise`";s:32:"aefb3de8acd255b5bb5299fbbffc68ee";s:48:"`Etablissement`.`complementAdresseEtablissement`";s:32:"99cbf40c24566faadf1ac4d5af7fbd2e";s:47:"`Etablissement`.`indiceRepetitionEtablissement`";s:32:"c7ae1c9d05f52f464bc8d6f1bbec1bbc";s:53:"`Etablissement`.`libelleCommuneEtrangerEtablissement`";s:32:"4e645885d33d4c6f1626169cc2e5a7a4";s:51:"`Etablissement`.`distributionSpecialeEtablissement`";s:32:"a837d761825cff5305e1c7f1c5e1143b";s:43:"`Etablissement`.`codeCommuneEtablissement2`";s:32:"e8e7a1c4580e17a90a623f1d676a54ed";s:40:"`Etablissement`.`codeCedexEtablissement`";s:32:"90b3f54fd7011094ea994244ed00f840";s:43:"`Etablissement`.`libelleCedexEtablissement`";s:32:"7b3fb100ebb134bf6669f5872183faa6";s:47:"`Etablissement`.`codePaysEtrangerEtablissement`";s:32:"9a591ece696d1465d7ee0fa49b856a7b";s:50:"`Etablissement`.`libellePaysEtrangerEtablissement`";s:32:"b8caf8150f9b5be24db690c319617977";s:49:"`Etablissement`.`complementAdresse2Etablissement`";s:32:"2548fdf0bd24ca7bd3fca4cf20d85833";s:42:"`Etablissement`.`numeroVoie2Etablissement`";s:32:"57ded096db335b8e79eeb4c225699cfb";s:48:"`Etablissement`.`indiceRepetition2Etablissement`";s:32:"3d11687fa0b88b9f7cac3c3161faf921";s:40:"`Etablissement`.`typeVoie2Etablissement`";s:32:"6a0314f1c329279c7552201453426cc0";s:43:"`Etablissement`.`libelleVoie2Etablissement`";s:32:"57750bcb7e82144af44f2cf500c99bbf";s:42:"`Etablissement`.`codePostal2Etablissement`";s:32:"27fb5d6abb1ee1979b27cfa0e15cc123";s:46:"`Etablissement`.`libelleCommune2Etablissement`";s:32:"69744e1290be0f92d195d834a20504a1";s:54:"`Etablissement`.`libelleCommuneEtranger2Etablissement`";s:32:"81a311c7fd8bb764f7017358166bb1b9";s:52:"`Etablissement`.`distributionSpeciale2Etablissement`";s:32:"1b3dd96f644e357c4bc40851f683a2c1";s:43:"`Etablissement`.`codeCommune2Etablissement`";s:32:"dac3173c50e1da9dead581dc8714aa20";s:41:"`Etablissement`.`codeCedex2Etablissement`";s:32:"9c81fccc3255f0742cf83f16a3eff67a";s:44:"`Etablissement`.`libelleCedex2Etablissement`";s:32:"db090b58ef534748d9d76d2daa34213c";s:48:"`Etablissement`.`codePaysEtranger2Etablissement`";s:32:"de3bc155a41faa2d0afc6a07df061aaf";s:51:"`Etablissement`.`libellePaysEtranger2Etablissement`";s:32:"fcd3b5a8a5cc19a9aa3917fa000aeadc";s:48:"`Etablissement`.`etatAdministratifEtablissement`";s:32:"be0bf932ad08be1a54f9ed1c6a404f41";s:40:"`Etablissement`.`enseigne1Etablissement`";s:32:"2942361e1313f4efc0ee323d275f5038";s:40:"`Etablissement`.`enseigne2Etablissement`";s:32:"a33bbb06cfd9104bfb2d365d839191d9";s:40:"`Etablissement`.`enseigne3Etablissement`";s:32:"cbea822955397739af5822498976f656";s:50:"`Etablissement`.`denominationUsuelleEtablissement`";s:32:"ad7240c6819361336ad79d787d656f1d";s:49:"`Etablissement`.`activitePrincipaleEtablissement`";s:32:"7b4df81ea615348a74bcc9a9e3fdcfe0";s:61:"`Etablissement`.`nomenclatureActivitePrincipaleEtablissement`";s:32:"652deaf192f45232fac0312631b2ebe8";s:49:"`Etablissement`.`caractereEmployeurEtablissement`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"5ddb6a98d302488c768f47878b537713";s:8:""jalons"";s:32:"4b6fabfe5d0cbb9514e71a50c5a764e3";s:7:""51303"";s:32:"262ebc5db9d99b871fb559ad7569abf1";s:21:""baume-les-messieurs"";s:32:"350df01e677bc5e8dd3bc68af78b589e";s:4:""39"";s:32:"6d0e05b706194c6f7b055974b22020a1";s:7:""39041"";s:32:"47e54c2616353cb9cc80ef4d6254a741";s:12:""bonsecours"";s:32:"fa310feebcb7001aa817e8e82a9b6871";s:7:""76103"";s:32:"11c320450122705f7bd8e0c1ef4b89f9";s:8:""pallud"";s:32:"c629a14f60eac327918b3795766c3835";s:7:""73196"";s:32:"29d58d006eeb6f73457fe1a5a5371343";s:10:""estissac"";s:32:"0a6f04050bb4b68fba1a270255e64035";s:7:""10142"";s:32:"b349cc4a261d68ba8d6391b95eb58dc8";s:26:""englesqueville-la-percee"";s:32:"ca63792778e7aa577dc891758f6e9aab";s:4:""14"";s:32:"c7d4c2eb1646066e9deac6cf73d7a208";s:7:""14239"";s:32:"5d2c9a0d970a9d0d69384e9180a16de0";s:14:""frechet-aure"";s:32:"536752ea892f8bcc379795e80ead2ffb";s:4:""65"";s:32:"ebe577b565a5a71159de77bbe9ce841e";s:7:""65180"";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"e34b60478ce1cef3ccc89cca861f05f9";s:19:"`Service`.`NB_B101`";s:32:"07e70f22f37a549af7d22b7c28e865e9";s:19:"`Service`.`NB_B102`";s:32:"1c5b949b427e7e1b3aeae0620d972ae8";s:19:"`Service`.`NB_B103`";s:32:"aca45966f82d09b0ee2d88be1ce3df1c";s:19:"`Service`.`NB_B201`";s:32:"79ea3716e58e315008fd776f60c11bc9";s:19:"`Service`.`NB_B202`";s:32:"dc8a7a3b7e8033b403197b19fd07975e";s:19:"`Service`.`NB_B203`";s:32:"9bae0dc971489368e8494000b09ae6bb";s:19:"`Service`.`NB_B204`";s:32:"9a7b3341d7f5c3787707af4cdd0b11e0";s:19:"`Service`.`NB_B205`";s:32:"40a6054c006a0b1c7c9a311d40465e07";s:19:"`Service`.`NB_B206`";s:32:"5c48108c2e7c486b82d640a57cf05912";s:19:"`Service`.`NB_B301`";s:32:"5fa9458a3a1754a77363355e3757ea30";s:19:"`Service`.`NB_B302`";s:32:"4c39997739bdd4f31eadccf0bc845c57";s:19:"`Service`.`NB_B303`";s:32:"aef37473cf0f18fe791c005e4c63c90b";s:19:"`Service`.`NB_B304`";s:32:"90088d9e1eef44a282a9d956a5f37503";s:19:"`Service`.`NB_B305`";s:32:"14a89eb6273eaf86f23518c2cc7110c6";s:19:"`Service`.`NB_B306`";s:32:"9ba00a5169a4cf2de4c82d114c92a09e";s:19:"`Service`.`NB_B307`";s:32:"67c7ac8728c814a2ce44fc314ffcf353";s:19:"`Service`.`NB_B308`";s:32:"07407fbb6de4cd59233c477d837582b5";s:19:"`Service`.`NB_B309`";s:32:"fb7b9c044eef55d3cd3ab813b8a4bfd9";s:19:"`Service`.`NB_B310`";s:32:"39b14590ba9369a9ec2e66d785934f42";s:19:"`Service`.`NB_B311`";s:32:"ca9eb4a16bf08454a1145437a2650b52";s:19:"`Service`.`NB_B312`";s:32:"57524c4a80b277792b471e374e0b9607";s:19:"`Service`.`NB_B313`";s:32:"b3fb97d4b638447dcdca139f59c7d358";s:19:"`Service`.`NB_B315`";s:32:"04607308bb52a925bba2de8d4a32fe08";s:19:"`Service`.`NB_B316`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"e83ac8eb41c3d42d891f0266417a4012";s:13:""garencieres"";s:32:"85ed4586b3a874961dffea950e023db7";s:4:""27"";s:32:"ca49b0f89719e7d043bf12bf070f379a";s:7:""27277"";s:32:"0ba180858f7d414c3ae6193244af9945";s:14:""fontenermont"";s:32:"ff899938d2bfeb4ba59651b2b6dda4ac";s:7:""14279"";s:32:"7eae05858abff094b2ebbbccb65bcc94";s:12:""argenteuil"";s:32:"f4ebec65cb31150c430473d49bc1fa69";s:4:""95"";s:32:"9e26fdea744f692cbe9a8127ba4c394d";s:7:""95018"";s:32:"af6cac276cec3c3c32448724a837c0a8";s:22:""plombieres-les-dijon"";s:32:"f90eea21e7f924152ce55baeaa8d2acf";s:4:""21"";s:32:"1bea58145f6792a38fe4be0798fe5d97";s:7:""21485"";s:32:"34789e579e374439e46109549b5fcdd1";s:22:""appenai-sous-belleme"";s:32:"163a7339f96775efc0bb74624746a9fd";s:4:""61"";s:32:"25601051f6cf8261e3030b9087994421";s:7:""61005"";s:32:"e247eae43a65a4bcf785c904177d793d";s:23:""montagnac-d-auberoche"";s:32:"cc5bde3abaa177d24c17025c69a94f25";s:4:""24"";s:32:"df30a7955f1e4089c1aabb0332d7c36b";s:7:""24284"";s:32:"4ca2ed59735d0c27d8b6a50ec8ed9073";s:26:""st-berthevin-la-tanniere"";s:32:"6e11f612c92a276a2ef74e3839222b11";s:4:""53"";s:32:"c464f5b07429cacd399108f6042540a8";s:7:""53202"";s:32:"564364b79e09aa8cef1e90d937abf146";s:8:""alenya"";s:32:"488dc58151d11d4bac6bafc90a267222";s:4:""66"";s:32:"fad3ed4014d7cdedaf6d85ed40a4a3c5";s:7:""66002"";s:32:"9ce223b1c3e7c5fdb20a484d9fcfef9f";s:17:""huisnes-sur-mer"";s:32:"0f970b5fe98c06a4d54c1bebf0a509d7";s:4:""50"";s:32:"fb6a8865ac95e1e28e6bc288f2ffa2ee";s:7:""50253"";s:32:"330cc9571e26287e913710ddeacbd310";s:8:""amblie"";s:32:"9543ecc5e3f76479aacc499e1daab968";s:7:""14008"";s:32:"e5c07b60d157a3d8374b9a8bef2e48e1";s:10:""baverans"";s:32:"3bd19ed047f3cadfc242c757d306b6b5";s:7:""39042"";s:32:"f41068eddd1f9b584488c998a0eca632";s:11:""isle-adam"";s:32:"5fa2df1169e28e4720137789203e2f77";s:7:""95313"";s:32:"4bfab99f40870aa5fade58dae6ada7b5";s:24:""st-georges-sur-baulche"";s:32:"5b2f330d6cad4adcaff0785a2c6b85a3";s:4:""89"";s:32:"dc13a9d9a5ae86ff4140d33bd5080772";s:7:""89346"";s:32:"73ba8296002195d01e7a94de2491728f";s:11:""beauchamp"";s:32:"d3fae9615ac6e74776cd35f5cc11a308";s:7:""95051"";s:32:"88359a53ee9818f2a6e72fe20ffea2d4";s:13:""agenvillers"";s:32:"630617fdb0bf0dc3c88c42b6effdb583";s:4:""80"";s:32:"ba5cb6f84a7a1caad8334b282c3d69f1";s:7:""80006"";s:32:"208123c39d8a6a86e8092290c776d4a7";s:21:""champrond-en-gatine"";s:32:"114c05c933ee040936c0b3f95f2ca4d5";s:4:""28"";s:32:"68ab808c06836b36962112485f6f6b1c";s:7:""28071"";s:32:"f786b5c746a92a63f4dd66bd77532e8b";s:9:""brusson"";s:32:"dd60083beb218e77bc091931195ac6f9";s:7:""51094"";s:32:"9b4f6ef96b9fcaf5d2af35143ee9e33c";s:13:""eturqueraye"";s:32:"4e2602278847c7ac413790c2084977aa";s:7:""27228"";s:32:"3cdf9c1a2026d0bdc71028a6bade64d9";s:9:""gueprei"";s:32:"fde22a386e5736033b40c303d5a925b1";s:7:""61197"";s:32:"9494b38d50bf63402bc967dc72c06751";s:12:""bosnormand"";s:32:"083854e4707f0dc44d1494310e31184c";s:7:""27093"";s:32:"c1443da5ceda875f75b4cebaf0ef0843";s:24:""st-genies-des-mourgues"";s:32:"a982bbb042538731dfd4791b2b615ac9";s:4:""34"";s:32:"2e8679b115c8a6b008947841aef01ce9";s:7:""34256"";s:32:"50675399e50e31accb394bfef80bd724";s:23:""st-hilaire-le-chateau"";s:32:"47ff6962f1b7e7bd8323a3cd4655ebbb";s:4:""23"";s:32:"ba482a3f205f7f68abc668cc8f8192a4";s:7:""23202"";s:32:"e19b3146651873cb0ee16597ef270491";s:10:""valsonne"";s:32:"1df51dd1653034a991bccb998695011b";s:4:""69"";s:32:"233cf4a55d5c525e8fc85e153e022673";s:7:""69254"";s:32:"e4831a79ee6c5f9f7f737e530b20f4be";s:7:""berne"";s:32:"b935e92bc471b44350f38db369fbe2e1";s:4:""56"";s:32:"33fb246d84bbdf5f9d97c0949518cf14";s:7:""56014"";s:32:"682f1246af4d227866e35da90cf5922e";s:19:""grosley-sur-risle"";s:32:"4d4afe33929aab7a24b50cfedc4431f9";s:7:""27300"";s:32:"5dfe6f8a9a72f9f4daae165388a909b8";s:18:""espaly-st-marcel"";s:32:"cfeb21509c00bd852fc755847351d959";s:7:""43089"";s:32:"5bf0a87216590833716a9a12393273bb";s:7:""aiton"";s:32:"fd57016df93496b93bf00823ead483cc";s:7:""73007"";s:32:"a76ca8150395d07dbfd41f5f7a98db5a";s:13:""frechendets"";s:32:"f25e3b3add16721b9d6e049b9262f42f";s:7:""65179"";s:32:"2b2b827a8c3787fecde16c0746abfbd8";s:16:""ecury-le-repos"";s:32:"bcc5201997e81b50f6b728b912bfa315";s:7:""51226"";s:32:"45819cc003f65584ede2f5cad190f41a";s:20:""bonneuil-en-france"";s:32:"db881f0888c891b029bcbbf62a8d0a18";s:7:""95088"";s:32:"e945c16fde72e2e14f1b5d3df9dd1953";s:10:""verzenay"";s:32:"ba347de42291a5f0f00149fda20f8808";s:7:""51613"";s:32:"e46de6f60ee590cf08c161f4fb1de9aa";s:24:""santo-pietro-di-venaco"";s:32:"9ef324a0e918cc70bb944cdbb856e5f3";s:4:""2B"";s:32:"88b22f624fb40db11f128d27295120c2";s:7:""2B315"";s:32:"58b5024c840c48922c8e4d8f22ccba0d";s:5:""973"";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"0a1510d0dffae11b88c8130de3cc3c6a";s:14:"`Pub`.`format`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";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:"9da1d158b7b3f5102350b7a469c676c4";s:16:"`Pub`.`national`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";s:32:"ef1f9bc7c4c152af4fc7dcd369fb08a1";s:7:""ivory"";s:32:"417d9f7a7e66eecfbc98cbeb4b73e90e";s:7:""39267"";s:32:"f0fc165376fb69850f3069c68e3794a6";s:18:""marnay-sur-seine"";s:32:"7ee703409b2770a5afff669827bf7303";s:7:""10225"";s:32:"039c39ea4f6aca10fb94e99076be8801";s:19:""epineux-le-seguin"";s:32:"342b31e3ebc81601f29ed7ef518050a8";s:7:""53095"";s:32:"e35cfa9eb5f8d813437922f85456a4d9";s:20:""maudetour-en-vexin"";s:32:"9f3772947b5da425faec2507738ceac8";s:7:""95379"";s:32:"e280c71a08817a579e1c64527ea511bc";s:22:""gauville-la-campagne"";s:32:"9f3693f56dbba17668b490ad23d68a03";s:7:""27282"";s:32:"ad4ad49bfa8d910bc2ce0d2cb466b392";s:19:""beaumont-sur-oise"";s:32:"24e8b73f4f67213b5ad787743a986bb5";s:7:""95052"";s:32:"6f474ebea68d1bd8295cca69e692a631";s:12:""hammeville"";s:32:"80394ea42cc6092bc2561cabcb740ec8";s:4:""54"";s:32:"d9a5b90b0c90365316cd16344aafd2b2";s:7:""54247"";s:32:"ba9c0e69e001483113b5fa519ddef13d";s:9:""jallans"";s:32:"fe41a70e986b7600dc87fd5200afe0e7";s:7:""28198"";}s:6:"fields";a:138:{s:32:"7473d037d6c360ca7a0f05c7a7dcad15";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:52:"(CONCAT(nom, " (", code,")")) AS `Departement__lib`";}s:32:"fe867edca8ab85a51970a29ed498e70a";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:37:"(CONCAT(code)) AS `Departement__lib`";}s:32:"3d947d1887c0e832bda59ae152b12dcd";a:18:{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`.`lng`";i:13;s:13:"`Ville`.`lat`";i:14;s:24:"`Ville`.`departement_id`";i:15;s:17:"`Ville`.`created`";i:16;s:20:"`Ville`.`descriptif`";i:17;s:13:"`Ville`.`img`";}s:32:"6896a9646a3349fde56a8e1182c3d4af";a:16:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:20:"`Departement`.`img1`";i:10;s:20:"`Departement`.`img2`";i:11;s:20:"`Departement`.`img3`";i:12;s:25:"`Departement`.`centreDep`";i:13;s:22:"`Departement`.`geoDep`";i:14;s:26:"`Departement`.`population`";i:15;s:37:"(CONCAT(code)) AS `Departement__lib`";}s:32:"680c55965c560e79d75f20f35783fde2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f970338eeb0c18bd32d7cc16cccedd03";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:21:"`Etablissement`.`cac`";i:3;s:43:"`Etablissement`.`dateCreationEtablissement`";i:4;s:23:"`Etablissement`.`siret`";i:5;s:32:"`Etablissement`.`nomUniteLegale`";i:6;s:36:"`Etablissement`.`prenom1UniteLegale`";i:7;s:41:"`Etablissement`.`denominationUniteLegale`";i:8;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:9;s:39:"`Etablissement`.`typeVoieEtablissement`";i:10;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:11;s:41:"`Etablissement`.`codePostalEtablissement`";i:12;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:13;s:9:"`Ville`.*";}s:32:"c09cbdd43c6810a02021b14bd5ea4fc4";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((48.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3c1af4d1ec49dd29f4b664e1097cb5dd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"781e962612e4704a5536ac7bf267c9a2";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:189:"(((acos(sin((49.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be54eaf9925d872d83b8921d77d298ca";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"32a26a5ed3499705fae5ac250bceb221";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:190:"(((acos(sin((49.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"edaf60a53debced5fcc839ebfa21350e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7564648e9e5d1df2918128bdc0fbe8ec";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8df82ba0c89e4b562164968c2ac7008b";a:5:{i:0;s:17:"`Etablissement`.*";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:20:"`Departement`.`slug`";i:4;s:9:"`Ville`.*";}s:32:"344a92bdc908ab556f82105261d93a12";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2984ab281f986abd86882304e9364592";a:9:{i:0;s:14:"`Comment`.`id`";i:1;s:18:"`Comment`.`pseudo`";i:2;s:19:"`Comment`.`etab_id`";i:3;s:19:"`Comment`.`contenu`";i:4;s:16:"`Comment`.`note`";i:5;s:20:"`Comment`.`antispam`";i:6;s:17:"`Comment`.`actif`";i:7;s:19:"`Comment`.`created`";i:8;s:18:"`Comment`.`posted`";}s:32:"977332bfd4dc4d5c27b3c6965da6d198";a:2:{i:0;s:27:"ROUND(AVG(note)) as moyenne";i:1;s:21:"COUNT(*) as countNote";}s:32:"c124979da6fadce083aeb7c57251e7b3";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"c107545585dbd04728d17ba532ca1f86";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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(((2.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aaa18b32b4b454e92173be87170303f2";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8adcf1625a4ae4120b72fd5559e8d794";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b6992d761843338fd8af938fc5569f0c";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((43.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"99053b4ba29410af712ba5f1cd087bea";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f8e066191614438feb65803e55218361";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((45.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7813811bf5747a4005031fc251c8e264";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"180d66ae5a43d172425ea4ee099b67bc";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((45.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"629bee5de33d24cc9df22bbe79ca14e9";a:94:{i:0;s:23:"`Etablissement`.`siren`";i:1;s:25:"`Etablissement`.`partner`";i:2;s:21:"`Etablissement`.`nic`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:30:"`Etablissement`.`presentation`";i:5;s:26:"`Etablissement`.`services`";i:6;s:21:"`Etablissement`.`cac`";i:7;s:27:"`Etablissement`.`telephone`";i:8;s:30:"`Etablissement`.`siteInternet`";i:9;s:26:"`Etablissement`.`horaires`";i:10;s:29:"`Etablissement`.`horaireslun`";i:11;s:29:"`Etablissement`.`horairesmar`";i:12;s:29:"`Etablissement`.`horairesmer`";i:13;s:29:"`Etablissement`.`horairesjeu`";i:14;s:29:"`Etablissement`.`horairesven`";i:15;s:29:"`Etablissement`.`horairessam`";i:16;s:29:"`Etablissement`.`horairesdim`";i:17;s:46:"`Etablissement`.`statutDiffusionEtablissement`";i:18;s:43:"`Etablissement`.`dateCreationEtablissement`";i:19;s:47:"`Etablissement`.`trancheEffectifsEtablissement`";i:20;s:45:"`Etablissement`.`anneeEffectifsEtablissement`";i:21;s:64:"`Etablissement`.`activitePrincipaleRegistreMetiersEtablissement`";i:22;s:52:"`Etablissement`.`dateDernierTraitementEtablissement`";i:23;s:36:"`Etablissement`.`etablissementSiege`";i:24;s:46:"`Etablissement`.`etatAdministratifUniteLegale`";i:25;s:44:"`Etablissement`.`statutDiffusionUniteLegale`";i:26;s:40:"`Etablissement`.`unitePurgeeUniteLegale`";i:27;s:41:"`Etablissement`.`dateCreationUniteLegale`";i:28;s:47:"`Etablissement`.`categorieJuridiqueUniteLegale`";i:29;s:41:"`Etablissement`.`denominationUniteLegale`";i:30;s:34:"`Etablissement`.`sigleUniteLegale`";i:31;s:49:"`Etablissement`.`denominationUsuelle1UniteLegale`";i:32;s:49:"`Etablissement`.`denominationUsuelle2UniteLegale`";i:33;s:49:"`Etablissement`.`denominationUsuelle3UniteLegale`";i:34;s:33:"`Etablissement`.`sexeUniteLegale`";i:35;s:32:"`Etablissement`.`nomUniteLegale`";i:36;s:37:"`Etablissement`.`nomUsageUniteLegale`";i:37;s:36:"`Etablissement`.`prenom1UniteLegale`";i:38;s:36:"`Etablissement`.`prenom2UniteLegale`";i:39;s:36:"`Etablissement`.`prenom3UniteLegale`";i:40;s:36:"`Etablissement`.`prenom4UniteLegale`";i:41;s:40:"`Etablissement`.`prenomUsuelUniteLegale`";i:42;s:39:"`Etablissement`.`pseudonymeUniteLegale`";i:43;s:47:"`Etablissement`.`activitePrincipaleUniteLegale`";i:44;s:59:"`Etablissement`.`nomenclatureActivitePrincipaleUniteLegale`";i:45;s:51:"`Etablissement`.`identifiantAssociationUniteLegale`";i:46;s:53:"`Etablissement`.`economieSocialeSolidaireUniteLegale`";i:47;s:47:"`Etablissement`.`caractereEmployeurUniteLegale`";i:48;s:45:"`Etablissement`.`trancheEffectifsUniteLegale`";i:49;s:43:"`Etablissement`.`anneeEffectifsUniteLegale`";i:50;s:37:"`Etablissement`.`nicSiegeUniteLegale`";i:51;s:50:"`Etablissement`.`dateDernierTraitementUniteLegale`";i:52;s:37:"`Etablissement`.`categorieEntreprise`";i:53;s:42:"`Etablissement`.`anneeCategorieEntreprise`";i:54;s:48:"`Etablissement`.`complementAdresseEtablissement`";i:55;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:56;s:47:"`Etablissement`.`indiceRepetitionEtablissement`";i:57;s:39:"`Etablissement`.`typeVoieEtablissement`";i:58;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:59;s:41:"`Etablissement`.`codePostalEtablissement`";i:60;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:61;s:53:"`Etablissement`.`libelleCommuneEtrangerEtablissement`";i:62;s:51:"`Etablissement`.`distributionSpecialeEtablissement`";i:63;s:42:"`Etablissement`.`codeCommuneEtablissement`";i:64;s:43:"`Etablissement`.`codeCommuneEtablissement2`";i:65;s:40:"`Etablissement`.`codeCedexEtablissement`";i:66;s:43:"`Etablissement`.`libelleCedexEtablissement`";i:67;s:47:"`Etablissement`.`codePaysEtrangerEtablissement`";i:68;s:50:"`Etablissement`.`libellePaysEtrangerEtablissement`";i:69;s:49:"`Etablissement`.`complementAdresse2Etablissement`";i:70;s:42:"`Etablissement`.`numeroVoie2Etablissement`";i:71;s:48:"`Etablissement`.`indiceRepetition2Etablissement`";i:72;s:40:"`Etablissement`.`typeVoie2Etablissement`";i:73;s:43:"`Etablissement`.`libelleVoie2Etablissement`";i:74;s:42:"`Etablissement`.`codePostal2Etablissement`";i:75;s:46:"`Etablissement`.`libelleCommune2Etablissement`";i:76;s:54:"`Etablissement`.`libelleCommuneEtranger2Etablissement`";i:77;s:52:"`Etablissement`.`distributionSpeciale2Etablissement`";i:78;s:43:"`Etablissement`.`codeCommune2Etablissement`";i:79;s:41:"`Etablissement`.`codeCedex2Etablissement`";i:80;s:44:"`Etablissement`.`libelleCedex2Etablissement`";i:81;s:48:"`Etablissement`.`codePaysEtranger2Etablissement`";i:82;s:51:"`Etablissement`.`libellePaysEtranger2Etablissement`";i:83;s:48:"`Etablissement`.`etatAdministratifEtablissement`";i:84;s:40:"`Etablissement`.`enseigne1Etablissement`";i:85;s:40:"`Etablissement`.`enseigne2Etablissement`";i:86;s:40:"`Etablissement`.`enseigne3Etablissement`";i:87;s:50:"`Etablissement`.`denominationUsuelleEtablissement`";i:88;s:49:"`Etablissement`.`activitePrincipaleEtablissement`";i:89;s:61:"`Etablissement`.`nomenclatureActivitePrincipaleEtablissement`";i:90;s:49:"`Etablissement`.`caractereEmployeurEtablissement`";i:91;s:20:"`Etablissement`.`id`";i:92;s:22:"`Etablissement`.`slug`";i:93;s:26:"`Etablissement`.`modified`";}s:32:"2d07c3b9bb1e48fb80683a8c5371708e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((49*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3a65a7008f01c819835ed118a5469de3";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:189:"(((acos(sin((49*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d33bb4ccbe94029fb334ac1b3ff9211e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eca6d13df639efa099230e682f0c3de3";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((46.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c2b639f31e919e43a50123197875b209";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"08c7b61af4a6a4510dd1c44ba5d82aac";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((49.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7ff09a2eee056eb0d76de02c991aab3e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d3dc490bb39562824a45eff278addb5c";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((45.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"31b0834a1112a91b6252e410f7c2e140";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aed5c0041fcdeec64dac5de7f9888134";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((48.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"738df357e4a6496876b14a97dcfcb2eb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc171811661e3b8704d1489b8ed76a97";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:197:"(((acos(sin((49.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a0eec571347fc47b5ac1967ef2d45097";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((42.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8cf2abe77df49e5fd7ca2624d47b1e93";a:13:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";}s:32:"2af933101dd0c74ba241b4c7e7d940f2";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:200:"(((acos(sin((42.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"327d2eaf6b919c8fcc7b4029ee1ba5f3";a:25:{i:0;s:18:"`Service`.`CODGEO`";i:1;s:19:"`Service`.`NB_B101`";i:2;s:19:"`Service`.`NB_B102`";i:3;s:19:"`Service`.`NB_B103`";i:4;s:19:"`Service`.`NB_B201`";i:5;s:19:"`Service`.`NB_B202`";i:6;s:19:"`Service`.`NB_B203`";i:7;s:19:"`Service`.`NB_B204`";i:8;s:19:"`Service`.`NB_B205`";i:9;s:19:"`Service`.`NB_B206`";i:10;s:19:"`Service`.`NB_B301`";i:11;s:19:"`Service`.`NB_B302`";i:12;s:19:"`Service`.`NB_B303`";i:13;s:19:"`Service`.`NB_B304`";i:14;s:19:"`Service`.`NB_B305`";i:15;s:19:"`Service`.`NB_B306`";i:16;s:19:"`Service`.`NB_B307`";i:17;s:19:"`Service`.`NB_B308`";i:18;s:19:"`Service`.`NB_B309`";i:19;s:19:"`Service`.`NB_B310`";i:20;s:19:"`Service`.`NB_B311`";i:21;s:19:"`Service`.`NB_B312`";i:22;s:19:"`Service`.`NB_B313`";i:23;s:19:"`Service`.`NB_B315`";i:24;s:19:"`Service`.`NB_B316`";}s:32:"fe7977b7c8b38e2f7f5eb2ec2e53c483";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9288ee5c5c539bc1dd1fd73d9f59c1a7";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0cf465c0e8cfebc96e746bbedf1a8e7e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c5d78e1152d496860ca893763ad20393";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((48.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bf66c669cd0e85c5fd5d523a1431ca79";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"81dd9719e97361544c264560e082513d";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"5500c7f2c3c6f66743b7718dcf5965ef";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:192:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"618faf65d1b1c7d887967cbbe97f5a46";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8c7d0c67fc186f65d2b81581f2d60ae8";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((47.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fe6c71efe9ee8f85f9e01331fab60f14";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.566667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cdb0e59023514560dd3c20d8fe2291c4";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((48.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.566667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"40b2652479957b8ab8a6ef2afcae37e8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((45.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"263c5f3c1ecd6953e013e3e0e03f7949";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((45.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"91c9d388a2e547dfa18f3a3f4a97386d";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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.8502*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8502*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"77dd3cd0ef6de5ab7d0685d3169bfdc8";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((2.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((2.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((48.9333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7644644e253bff9366ab418f26bc339b";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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.872*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.872*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.31187- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a415fdf85a9d1ead82028fe67ca5d9e7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9f0066c3bb790aefdc9d7a12bf123ea2";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:191:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"babf876e6d850179b55faf057858aaeb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"318b934e1433fbbaed05494586def72a";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((42.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"362ce4a4844ad241e987b821df9b7a2c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"955b2a289908b731d94149917a470922";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:191:"(((acos(sin((48.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4c5a528a379c36d3f330d56946214384";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"261c7f085612fe8db5bfaac68c70e7ae";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((49.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.483333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"27cb7d963ae82b3c76e35ca412828a57";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bed3c4100f0f5a6b877d2365390369c1";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:193:"(((acos(sin((47.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c6fe9f699c7fbc3a1743b29ec48946f1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1623aada5afbb2fc1ca275c55438c3ac";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((49.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f7bf8bae30323b2612ad26f45285965e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8053*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8053*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.53306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"24eb4736d8c57ed2146dee6b2a49838f";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((47.8053*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8053*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.53306- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"76e296c3cc7f8f91c8b33d07a61d2802";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6dbd69065cda7d6dce1b303749c8e3ab";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((49.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0f0a7e4b5cb9cf0cf344c7363c8b8548";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*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:"4e4ce5754b0bbd065b01686d8d9a03a6";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((50.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*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:"9253fbeb46a2762137ac1a83fa829632";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*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:"46b7544c4598d6e1a4df39a0b9841aec";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:193:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*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:"20fcfe70dc90c230ad4df9f02bb560a3";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a9d8141b452a3050cf16f4c4fb134066";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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.4339*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4339*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.73611- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"baaf36943f2d20315f2c77bb11b1859b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((48.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ef40efa1351404125af8d1d2066e1fc";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:191:"(((acos(sin((48.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ab8868fe636404baed281bb640c6a64";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cd85a7855b6c42fc0eb1d78f038f6388";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((49.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b0dabb9c7ad199c83851151365cde565";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:203:"(((acos(sin((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.00833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"71e65d58cf4b1d2369d7465bb0ddf7e7";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:203:"(((acos(sin((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.00833333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"376888d953d65f6e90fe3416f73b1fb4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"960696e6ce7e0c6748a561355e12e450";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((49.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"663d03b96e51620e536dcd74ad5d5164";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((43.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2014f0d4cce52d759c90edb5cd7265d9";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:193:"(((acos(sin((43.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7f7b155722dda9a73f9af703878ed84f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2c00d66e06da06bc9ceae88cb5a3a429";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((45.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f547e19a75c89230fdb7883d4cf720c4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((45.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"40786c4551bd57b776d4a1816c54170b";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((45.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2fd83b4e149e097cdbdc821ec8b591d9";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"461125bad242fee6be2dd3b264df20ad";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:186:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b4f22ce4de59de4a659e6a8a1bed6de0";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:186:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2d9621632c702dc1e0d87ebecc83d2d6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*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:"fb8470a845eb9c6e1679978fbb0b8f90";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((49.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*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:"2c300e533b9a8c02ba6a52b1aab95944";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.05*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:"4733c1bea9d16833d66f865b360dc32a";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((45.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.05*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:"d9845ccef4e68635812757a72ca7f461";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((45.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e632fac4bbcdccd9196f9336a17c4e08";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((45.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"238f3b55fb62a9a29591200522e5d885";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((43.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0667*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:"9726b61529c0b861a83321c4f8a1dc22";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((43.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.0667*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:"ef5dc85ca20cd48b8055e7394d1275ee";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c824da41b83c7561f4506bd94c973a63";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:193:"(((acos(sin((48.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a63df2771b2bc86f3700c1dbfa323709";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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(((2.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e637142de3981f4f347a6a85467f0e7c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*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:"c53be5677f7490c9e2845975fb0b46d3";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((48.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*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:"adfd84f9453f9b49c3419edeb6f8f707";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1954a485a51b28d836b350ee101e48ca";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((49.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c726c6bc337024bbec844ad4f8b193a1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2459*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.2459*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.17168- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"313f40d274f7ddf4a792d14bd5e1c309";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((42.2459*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.2459*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.17168- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e297f97f53b2f50b9ad6939c7a7f85c0";a:1:{i:0;s:18:"`Departement`.`id`";}s:32:"cfcb07753438195b57aabd45bb358ebe";a:15:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:20:"`Departement`.`img1`";i:10;s:20:"`Departement`.`img2`";i:11;s:20:"`Departement`.`img3`";i:12;s:25:"`Departement`.`centreDep`";i:13;s:22:"`Departement`.`geoDep`";i:14;s:26:"`Departement`.`population`";}s:32:"b9c2e13f67bdcc2d8131af7642f76123";a:4:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`lat`";i:3;s:13:"`Ville`.`lng`";}s:32:"94204132cf814e28e78d395f8e3a7c6d";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"386a444cea1bbfe78bc8a94275486a29";a:1:{i:0;s:25:"`Departement`.`region_id`";}s:32:"e510bd77f60485f19ba962387dfcd845";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:"29b4a7a201f24597bfd5281ff5a956be";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ca3c18f4367b4d44e058e6e93935327b";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((46.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cfa3cad59125494d04515d857a4a765f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"791f3cc7bc19217547fd44c1c0c799e4";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((48.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"24e1850c84cc0799c73168b4ecbe0304";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0c2889e64e1dd1d86c6c8e74706571b2";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:197:"(((acos(sin((47.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.366667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f5566c0e6865a355ce0e61b3b1e420c4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4d137a04973cd5e3a8ed7e5a34812012";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:193:"(((acos(sin((49.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eeb5e8dddcc78ea76c665b7651e6cb2e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*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:"4193f0597f9dffe579ec7b4ba5aceed7";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((49.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*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:"51e2645813cbe6cfa4f2e707ba711972";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.5333*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:"14586bee5a757be086cb5c25821466a8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c6dc0409d281a5c3fe29e450d53c0769";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((49.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b65325cad00ddc89f87db8944cd03e27";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((6.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b4734e7dea414ec2a77903602d2841eb";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:193:"(((acos(sin((48.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7ca46d5dbfa03b69631711b2ed3a94d0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6ff02658a5e944b3ef384c5355e04282";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((48.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}}}'
unserialize - [internal], line ??
FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828
DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
VillesController::cac() - APP/Controller/VillesController.php, line 194
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/maisocr/findeo/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]
setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 174
[main] - APP/webroot/index.php, line 111
Commissaire aux Comptes Balâtre (80) : audit, apport en nature ou transformation de société
Vous recherchez un commissaire aux comptes à Balâtre (80) pour un audit légal et certifier les comptes de votre société ? Alors findeo.fr va tout mettre en oeuvre pour vous présenter une liste des commissaires aux comptes situés en Somme (80) et plus exactement à Balâtre.
Missions du commissaire aux comptes
Audit légal Balâtre
Examen des comptes annuels de l'entreprise afin d'apporter une vérification externe et indépendante à propos de la sincérité et la fiabilité des informations financières.
Commissaire aux Apports Balâtre
Évaluation des apports en nature d'un associé tout en veillant à ce que toutes les procédures légales et réglementaires soient appliquées. Contrôle des documents d'authenticité à l'appui des apports ou la validité des actes afin de certifier que les apports sont conformes.
Transformation de société Balâtre
Changement de forme sociale d'une entreprise (ex : transformation d'une EURL en SARL)
À la recherche d'un commissaire aux comptes à Balâtre, la majorité sont installés en centre-ville mais parfois aussi en zone commerciale, sinon peut-être dans la commune limitrophe :
Biarre, Billancourt, Rethonvillers, Marché-Allouarde, Solente, Gruny, Carrépuis, ...
Choisir un commissaire aux comptes à proximité
Commissaires aux comptes du secteur Balâtre
En choisissant un commissaire aux comptes à Balâtre, vous envoyez un signal positif aux investisseurs et l'administration fiscale sur le fait que les comptes annuels sont conformes aux normes comptables et légales en vigueur. En fournissant cet audit indépendant sur la solidité financière de l'entreprise et ses performances, l'opinion générale positive est renforcée. Le commissaire aux comptes peut également aider l'entreprise à identifier et résoudre les problèmes et à se conformer aux règles et réglementations en vigueur. L'intervention du commissaire aux comptes est facultative pour les plus petites entreprises mais peut devenir obligatoire au-delà de certains seuils.
En Somme, nous avons fait le listing complet des experts-comptables et parmi eux plusieurs commissaires aux comptes à Balâtre ou appelé aussi commissaire aux apports (lors d'un apport en nature) ou encore commissaire à la transforation (lors d'un changement de statut jurique). Toutefois, si le choix n'est pas suffisant, voici les principales villes à proximité où vous obtiendrez de nouvelles adresses pertinentes :
Besoin d'un devis avec une réponse rapide ? Remplissez ce formulaire.
Liste des experts-comptables et commissaires aux comptes
Ci-dessous la liste des experts-comptables présents à Balâtre
Actuellement, nous avons recensé aucun commissaire aux comptes installé à Balâtre (80700) mais plusieurs sont installés à proximité (voir liste ci-dessous).
Liste d'experts-comptables secteur Balâtre 80700
Dans un rayon de 25 kilomètres autour Balâtre
Findeo a listé des experts-comptables dans 10 communes dont le plus proche à ROYE.
