$key = 'myapp_cake_core_method_cache'
$time = (int) 1757008854
$cachetime = (int) 1757008864
$data = 'a:3:{i:0;b:0;s:4:"name";a:196:{s:32:"96b7280d050422e829f8f5efce76ed71";s:12:"`maisocr587`";s:32:"4b5b179f3d4d02caf2bc8f10c9508150";s:17:"`Etablissement`.*";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"9cc9932f961dd20be2485b6e784c67c9";s:9:"`Ville`.*";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"7ab0ad68d7b28d18fabfe0fdc5224200";s:42:"`Etablissement`.`codeCommuneEtablissement`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"c5697e1e5c979d7ac16a2058fe255e21";s:13:"`Ville`.`nom`";s:32:"f340c52a13f3cf8684f61cdbc6725f3f";s:13:"`Ville`.`lat`";s:32:"b4707c5ae31d038ddd76310d59aceb1c";s:13:"`Ville`.`lng`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"e6b8ac227bd20feed342e5ed0866d680";s:10:"`comments`";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:"c87b6288c09482f582fd3874f1e9f7a8";s:9:"`Comment`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"b3a132b3002f0a095c207367d2386438";s:13:"`Ville`.`dep`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"c1f9b57df40a583acfdf261e4793fe99";s:20:"`Ville`.`population`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";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:"fefb0237c146f1bc62e1e6c7a9cad243";s:9:""clisson"";s:32:"38910b5f5001b084555a03a28492bd94";s:4:""44"";s:32:"f721416f99749f3df35aa11d34cb1cf3";s:12:"`population`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";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:"d441840077f22e082bbbfeae4eee3749";s:7:""44043"";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";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:"62cc5c66a904a35ffc17b0b57cd00fde";s:21:""hauteville-sur-fier"";s:32:"a1ac42450bd1111d8370fb8428a1ad1c";s:4:""74"";s:32:"8b88957fa7732fb17e1a2eb216957c49";s:21:"`Etablissement`.`cac`";s:32:"b512ec92ff189b82d26e2a787e67a294";s:7:""74141"";s:32:"aeb441d4df09df8a60cf67b1f18c657a";s:16:""billy-sur-oisy"";s:32:"99ac0e71a40555b4f9bd78c12ecffe15";s:4:""58"";s:32:"1cd04614bba8dcd3a164e15fe6e8d169";s:7:""58032"";s:32:"7dccff2396b5f1e0ee3cba6ef3b4f54b";s:16:""haye-bellefond"";s:32:"0f970b5fe98c06a4d54c1bebf0a509d7";s:4:""50"";s:32:"d02ef10e885a099f3f00e7552b173444";s:7:""50234"";s:32:"cefb6f7b584525c234c81c30c5688788";s:20:""hauteville-sur-mer"";s:32:"b171b372adbbb9b6931245723cb377c6";s:7:""50231"";s:32:"22dce5dfa722429529d6aa0cc628a378";s:17:""froeschwiller"";s:32:"f47b005a37f014816c39065cdca3bb00";s:4:""67"";s:32:"46baa259ecdda191e6f262988365513b";s:7:""67147"";s:32:"12dc0473a3e1d8a97b607a92236ea5e6";s:17:""coulonges-cohan"";s:32:"cc5f3c62de4eda0b1629d830636de7a8";s:4:""02"";s:32:"16eb5bcb57f4938a8c74a6755387f013";s:7:""02220"";s:32:"31747d0a3adef99ab62449dd7f0fa9f4";s:24:""congerville-thionville"";s:32:"99f486ac87e748598b211a14775326bb";s:4:""91"";s:32:"0ac6abad9092b4d45629571b7d22aa1f";s:7:""91613"";s:32:"6768b650f03baf8927418197774bd7de";s:25:""biefvillers-les-bapaume"";s:32:"d6c45eaaed67620bdf39e09fc229e9ec";s:4:""62"";s:32:"356f097ad45c430e447b5f319c06b7b0";s:7:""62129"";s:32:"ef9a5de27e7e9572522a6e49bab88603";s:23:""beuzeville-la-guerard"";s:32:"2bce4c68d271bdd14898a6d63dc065d6";s:4:""76"";s:32:"c2f857c60687e56b108caf124214bd3d";s:7:""76091"";s:32:"f36e0d6f205cf8b7c59e1b02cefcbb1d";s:19:""ste-marie-de-vaux"";s:32:"bca378769cc071b2dfd627a0ef0e2f0d";s:4:""87"";s:32:"08f3f27efe3251bd9435291d73b4b173";s:7:""87162"";s:32:"88689258caecfed85698e045e1739f60";s:11:""brinay-58"";s:32:"9e8712cc732f3b5290985347ed5d312f";s:7:""58040"";s:32:"2306d3225403cde36e347e2d181db21c";s:11:""bagnizeau"";s:32:"2a505d3269598f3009c52295db47a5a7";s:4:""17"";s:32:"15afc648071de79b3491f3413ad9ad20";s:7:""17029"";s:32:"a90b58450d69308bc26e5a069bc533dc";s:12:""beuvrequen"";s:32:"247225cccd65d17638240ea748f67625";s:7:""62125"";s:32:"f0aae2325fbad46fce5281a9f093d986";s:10:""pereille"";s:32:"975dc97d8392b814264c38f12fe5fbc8";s:4:""09"";s:32:"2e3c4d9b5d22eef0d1350dddcc3f3b71";s:7:""09227"";s:32:"00572c3b979d3065bc94d9c36995c899";s:13:""estables-48"";s:32:"7d8332c40ede7afa36d4eea6315bdc9a";s:4:""48"";s:32:"37b68f67e9dca4132344e0fb97bfb092";s:7:""48057"";s:32:"600960d95aa81da8dc654d2856804638";s:11:""engwiller"";s:32:"2b1769032583e02cdc28da2c726a9139";s:7:""67123"";s:32:"f0117dccbf5539b302dee5b6e01f865b";s:11:""rocles-03"";s:32:"724b1beb283d617dd938e00092fc9084";s:4:""03"";s:32:"0266f3e75af652e8cf68be0f332d9f87";s:7:""03214"";s:32:"02baf950b431b7a62739e6e77659db35";s:12:""huttendorf"";s:32:"cadaa4f8a6e7a2e2d508f384fc9479c9";s:7:""67215"";s:32:"81af1716957d6ec1948ed8b11b76816b";s:9:""hohwald"";s:32:"789d96b191350c5a3b5122b27227d985";s:7:""67210"";s:32:"3bae5f835b674810ca40c745c9e8d3a4";s:8:""berfay"";s:32:"c35017f5f2976d3684e598f1e816367a";s:4:""72"";s:32:"849ea804af9d43985a4ff10ae222672d";s:7:""72032"";s:32:"25d99b9f25356d921c1ee521ec9806f7";s:20:""st-pierre-de-boeuf"";s:32:"bdd2cab4714f4907b3fc8a0ff2f6f7cd";s:4:""42"";s:32:"1d51113765a26d4b8434daeb1bd877fc";s:7:""42272"";s:32:"416858d8a55f20e064ef33fb05e04e0a";s:9:""domptin"";s:32:"8025d018c65af9b4960894cdab9e45b9";s:7:""02268"";s:32:"6e37ff523cdef925aa6d1d62e719724d";s:12:""littenheim"";s:32:"b7f47db3ad284b565c617957843d59f7";s:7:""67269"";s:32:"7a5d62d4019fa503f6e5b4400186acac";s:10:""brevands"";s:32:"819868a9590d4ebeedbbac707e54803c";s:7:""50080"";s:32:"5668f9f93c84243ccba120feb9d9ec85";s:9:""fleurey"";s:32:"4c9f5a825e49a6ba84646a996b6447f9";s:4:""25"";s:32:"75dddc7812260ceb5fa15947d2521e7d";s:7:""25244"";s:32:"2bec14c658f86a69e095eabc7e77272d";s:11:""cernay-86"";s:32:"8b494f47bcbfd630030ff7131b5a3f2d";s:4:""86"";s:32:"19899ec097e42d2be238e369ee7d38ff";s:7:""86047"";s:32:"310a5ca692c7659c34729c2a3fadc4e0";s:22:""chavannes-les-grands"";s:32:"b6554ae489225685bf271d1d2ff0eb20";s:4:""90"";s:32:"edbf86e6afc7126a1a44289ddc876889";s:7:""90025"";s:32:"e83987eb2af37a2dd184eca5f798098c";s:10:""blarians"";s:32:"a3d160ec14090add26cd7839fed7b6c3";s:7:""25065"";s:32:"2b2b827a8c3787fecde16c0746abfbd8";s:16:""ecury-le-repos"";s:32:"30e0fbe2dedd7496d6607455959eba37";s:4:""51"";s:32:"bcc5201997e81b50f6b728b912bfa315";s:7:""51226"";s:32:"dce9d6cd753e00949f9169a0e9ef7031";s:18:""cesny-aux-vignes"";s:32:"ca63792778e7aa577dc891758f6e9aab";s:4:""14"";s:32:"460028814ea97a0dc1572d9b30a910ed";s:7:""14149"";s:32:"4ec3b4e0a21a72dd949e187a176056e0";s:9:""adriers"";s:32:"378e9a664782aa226fe5b508e3dc6d16";s:7:""86001"";s:32:"a545360d6366a2cd5017027082a8422c";s:9:""autoire"";s:32:"13d2692796a894010e322f7ce65ae7eb";s:4:""46"";s:32:"01fd2ee6689c7c2bd6ea545c7347c2cc";s:7:""46011"";s:32:"24a9e01046a2e586647422f7abc7933d";s:21:""essarts-les-sezanne"";s:32:"14d396f767b9c72f6fb5fa51917b0416";s:7:""51235"";s:32:"2d88a8d0c96e81885c9dcfe94f73595f";s:16:""feche-l-eglise"";s:32:"5154b6b07cec10bb4b65d90c27dd7da6";s:7:""90045"";s:32:"d23b68b9059c72965a015e1418ae7178";s:21:""juvigny-sur-seulles"";s:32:"dc1a2e829564ebd516e108b8822bdab5";s:7:""14348"";}s:6:"fields";a:131:{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:"47fe77480deacb89fc30d44e13b569d1";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((48.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7473d037d6c360ca7a0f05c7a7dcad15";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:52:"(CONCAT(nom, " (", code,")")) AS `Departement__lib`";}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:"cfadf4aa5ad571097215d7443c039ce2";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:191:"(((acos(sin((44.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc8c8314de9982423fddceead9bbafe7";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(((2.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9dc5947a98d0c7c9606112179e75d619";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:193:"(((acos(sin((47.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be202e9bdb10b1c635478671f5e70ed5";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4167*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:"0992cb8f73bc90b6c7cae3cb877c2bd0";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((49.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b6ddd1b671eeaee6b1ffb4327ca1aeb0";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4798129250c5e2b420357f827e418861";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6266f63ce13cd9d1f81c4c8854616b67";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((45.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ce974bc1d51dab01b6e44c58dfa8251a";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"761d92e937d5f29259e73a86318755e7";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((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*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:"2f7e37eab77554d8fa72a2053946ff40";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:201:"(((acos(sin((49.1539*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1539*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.330278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"12044ba587f0cffab9347babd87933c2";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-3.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"783a8dfa0896b732a951ebac27ac7151";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((47.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:"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:"2d3689f4f3274cb3b9519aed8d394294";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((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:"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:"84b61767f0b1196bd353453b2b1debae";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:193:"(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"659ccc8ca2fc4420776807c35613443f";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((47.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f167018735d1f16d66d18cbcd8c7a20e";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((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"84e36baa7c6f6c7017dee47b123cd7b1";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((49.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2e6795d69c13fd4942838d44930376a";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((45.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"46c0af661475ec14a9ff215e7aaeacd1";a:7:{i:0;s:17:"`Etaslug`";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.1812*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1812*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.99556- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f8f6b70329708f971181645c41c01f43";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:193:"(((acos(sin((46.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.83333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ad7b53b5e93bd126450792681b20f4b6";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((45.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.733333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f3d4b752722233efe348603b2b10de40";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:193:"(((acos(sin((44.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ed19089ecb8b6f5e5cb0c8f4bbe1d12c";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((45.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d8a2e7f332381eccdabc3f907c5bf664";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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"32e36096fa83f9db1cdc4a782a7560de";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1adab3b7d8ad5fd32d6dd2937fdb0bda";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((46.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"629ce6612aa4bf70617472404b734d2f";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((46.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"38445b19e2193016294ce8a3ae7ef755";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((44.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.65- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1b13d05fcd1899bb71c030bfc726a97a";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((49.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"828c45d081b3d4896d472c98c3b8bf83";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:192:"(((acos(sin((46.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2e045d82b57e1016c879ef0c4ca9f3d0";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"66b1001bf27a7fb21eb917fc0c72beea";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:190:"(((acos(sin((47.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f059e7aaa1c1367071fe9b0360d783ed";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d28d756bfcc381534b15b8267611a61f";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((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"192ba3b984d352bf0cdad2911834d908";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((49.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d40c62c0583946fd2e4d8d9c1db15652";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((50.1053*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1053*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.54111- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9bad7141430966d5ebf4f5e75d2153ea";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((48.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e001b9d1d1b57bd1dd2b07b0c5c2d7a";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((44.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4a5b5756c19afab1d510b1a62b490fe2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((45.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"7bf54fca10e7fda74829cf28d76f2d84";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((45.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1f682be5ac003c87cb796e44c938a712";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a98ef90c252071012cf538aa08c6c01d";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.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"91e72fbc9bc1947ce345122694dfdfe6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.9837*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9837*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.815834- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bec6c065983aba4f697745bc7f405401";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((48.9837*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9837*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.815834- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f87c56ba88bfdfb2b1a5dc2d04e7355f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"835fa020c5334b16690ca85485746e3e";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((48.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7396664100912ccb605f95c6b110e176";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b69933049f18843ca674fb4817ec4dfa";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(((7.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"70f7d184d9dad01d082de31a15317b29";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2012*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2012*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.63639- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4c41113e203c78025ae7c664762049ea";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.2012*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2012*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.63639- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6bdb7a7172cdcc7fb6ae5c549bb8e422";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3778*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3778*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.99445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"efd8875b4a6c59b095161f6c3ab5cc5a";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.3778*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3778*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.99445- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"acc70de0c7bb3685bf7672db3b2711d5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ff818183dc370b547bbac88a0a053bd";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.81667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"368712c811dd0351527a8c1c518b73d0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b12fd9aee053a4ef7917f9b9ccbb2b5a";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((49.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.616667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5087a3195d5b3f5f5ef2aa359ce4db59";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3cfee256d5b0080c077ef67143d6b792";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6e437e4d6783b2fb43b75685105fcedb";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((45.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"77c249f775c192c4af2451d86ac75ff3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:185:"(((acos(sin((47*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c44af6dcb3515d7bebad6bbdf128cbbf";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:185:"(((acos(sin((47*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.7- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"90577228751794eb9a7f9f001dbebf37";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.1914*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1914*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.92584- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c93767556512ac8751a30d8d6016edcf";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:198:"(((acos(sin((45.185*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.185*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.661389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e37ac59ffc83e6150a22f90d5fd9dc68";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.133333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f2086fa54f7c623424d6bb6157abc0e2";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((44.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c3eae41f8f2443954e93afa50785fd03";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.6103*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6103*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.08417- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b68ab64e1defdf56beda50cfb62b9378";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.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e8c56524e74551c52dda9b976276ad3e";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((49.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dabd442878ef29cbbef9d1def16c2c06";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0972431586e5faedcf2f3e70cc2323c9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((45.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4f55f2121a674d87254f4f3aaba810dd";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:201:"(((acos(sin((45.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.316667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0727173101771bd7b0235050c34f50e9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((50.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5602a33a37e7daf6f2ee876c3b5e669a";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((50.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6d4663ce0e226dfbf09b4c4463bd5228";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9386*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9386*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.80167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"484f16cfef14c4a3a1259573296b135e";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.9386*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9386*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.80167- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"224c50669fb0f48e8133539be6306c51";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0030217b4848f66a0c8a2d43114c1844";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((44.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e18d1488db82a8d93a2f8ef76850510d";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.8293*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8293*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36022- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0c75ce6a4dab69a1b20b164a58fe9ff1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2a9975ababba40fae1224741e4f072d";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1b8fb80c5601c23dba9d718a7ff21fa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ed4d5302911914e57138e696a787b42";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.03333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"232b11dadcc05481e63ca0f8fb901436";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((7.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3b686d5ae1c55972a15aa44becc7bcb9";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(((7.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d77b5065079ac4bc4f7a1531a8ad7c23";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4035*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4035*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.32448- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ac8ac5cba608564f7563e01260161692";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.4035*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4035*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.32448- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a6d095db7cfaafd8571d2dd60da7fb8c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7c6200ee9d11b7b7a31f35a3bc5ebd41";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((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.766667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ca545e808f7bb37c1956687f3bccd4f3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b74739b1e8fa0f4a08b5cffd52cbb97a";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4c25e4f931d9d59c48b98e2d435ec738";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((3.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"30653fadf8caddff0af0d1727eef8b12";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(((3.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"67fc62cf60e35901a78a32427471e6ec";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"053e7f42d0fe4f032150e77e0f9045d5";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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"14c818ce09b9217e4dbc8fd3a433fe8c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"054848125a7b0ad43c8e06694c7786b0";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((49.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"089a56e10b87cf8b7086792dcd36c48c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2851bc1f744ac9c6d305c79c5c75c072";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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2f53e43f9ff05e3f5f736379b7c4cbde";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1733acc172592a22615ff624eff8a0eb";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((46.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b616655bf1b312b01a9bd1c01a4fb89";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a977bf7465d51d10764013859b524851";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((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0093244968fe6387f650839509adb609";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3fdfef6fc86d1bde6363482d7e20b8e6";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"500dd085622820d61b9e50fb271ad362";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c29dde48e4e2441f4a47caad168e4fb1";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.13333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"199a5003313804bfbc38039dba7b9c53";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"62a3959b0edc9763708ece41b216886d";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((44.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cc2393b6e03f5771fab4bea35b2c11a4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0731*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0731*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.82667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e725ab9cb2b13a5c137838108d584592";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.0731*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.0731*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.82667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a88c58681c4136e07b6cc266a9e6694a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((45.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1006e5dcfee30771d3f80da50ea88d3e";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((45.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"012477a0b155d6814912be25c4c67a1f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"658faa415be09d7f86e77d3a9789cbf3";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((46.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"69e963d4ea17e193e2088ffa8637145e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b5cd6d8c04bcd0e94f2197fead4b676b";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.15*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.15*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2648e74cada1f5ff6539111c1e5619fe";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"17658bc94ac3b6a01c6ddb0425583bea";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}}}
000) 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 Cos (09) : audit, apport en nature ou transformation de société
Vous recherchez un commissaire aux comptes à Cos (09) 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 Ariège (09) et plus exactement à Cos.
Missions du commissaire aux comptes
Audit légal Cos
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 Cos
É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é Cos
Changement de forme sociale d'une entreprise (ex : transformation d'une EURL en SARL)
À la recherche d'un commissaire aux comptes à Cos, la majorité sont installés en centre-ville mais parfois aussi en zone commerciale, sinon peut-être dans la commune limitrophe :
Saint-Martin-de-Caralp, Saint-Pierre-de-Rivière, Vernajoul, Foix, Loubières, Ganac, Baulou, ...
Choisir un commissaire aux comptes à proximité
Commissaires aux comptes du secteur Cos
En choisissant un commissaire aux comptes à Cos, 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 Ariège, nous avons fait le listing complet des experts-comptables et parmi eux plusieurs commissaires aux comptes à Cos 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 à Cos
Actuellement, nous avons recensé aucun commissaire aux comptes installé à Cos (09000) mais plusieurs sont installés à proximité (voir liste ci-dessous).
Liste d'experts-comptables secteur Cos 09000
Dans un rayon de 25 kilomètres autour Cos
Findeo a listé des experts-comptables dans 10 communes dont le plus proche à FOIX.
