$key = 'myapp_cake_core_method_cache'
$time = (int) 1732192400
$cachetime = (int) 1732192409
$data = 'a:3:{i:0;b:0;s:4:"name";a:283:{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:"24d767c93dee7ed18dcecffd0cce819e";s:12:""coullemont"";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"d6c45eaaed67620bdf39e09fc229e9ec";s:4:""62"";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:"e956e77c3fdf2745b7c83694e211eec7";s:7:""62243"";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"aa6f19ed9ec143b96287f5c8fbf4472a";s:9:""gornies"";s:32:"a982bbb042538731dfd4791b2b615ac9";s:4:""34"";s:32:"e28f839b8bf9a064e57f701a50f534a4";s:7:""34115"";s:32:"0cd6862efeddc7606065629f23b08eb0";s:23:""st-aubin-des-coudrais"";s:32:"c35017f5f2976d3684e598f1e816367a";s:4:""72"";s:32:"5efa7a2bbecc4c40a495f2441e359a5e";s:7:""72267"";s:32:"0b52438643f5a8673089a34bacb22d4c";s:11:""cazaunous"";s:32:"15d6b97cf557c9ef82700914e59762c0";s:4:""31"";s:32:"1f57516cf35d2bd733f001ed67dc3b04";s:7:""31131"";s:32:"4f29883f7f841069769e98b3cbd52d2f";s:7:""ferin"";s:32:"6ff9b106a564fc0077e1e19f7a984073";s:4:""59"";s:32:"1fd46e65b5d48748d42b6e5681777d77";s:7:""59228"";s:32:"8d0d2f553e8f856bbd08ce0912a6dcda";s:11:""montclard"";s:32:"7142166d1e9021c22af48d53bc32d9e5";s:4:""43"";s:32:"5b8c9b91e1cbe24c892adaf3af58fe6b";s:7:""43139"";s:32:"e59cfcfe3d0227fe149936231683f8f3";s:11:""st-connec"";s:32:"8d26efc353156c4964f21eb7453a8e08";s:4:""22"";s:32:"7f4631a8bbc49b12dc7d6561820a45be";s:7:""22285"";s:32:"67f0169744a131df2dd7ccb1c1aefd54";s:12:""pian-medoc"";s:32:"7fba278df5e405b47ffb87433a2039a7";s:4:""33"";s:32:"dcb395de1252c169e5b6cb955d87d12e";s:7:""33322"";s:32:"08f8fd65caf941156646e3ddc3c44756";s:12:""gabriac-12"";s:32:"52a8c6ab4f69e402f37349a5fb5b2a73";s:4:""12"";s:32:"d3066e81437d488366eefad2a403df55";s:7:""12106"";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:"eb62521d65b126d50877cd9a47cca8e9";s:10:""pommerol"";s:32:"f0d21440ff5a65c3630b99a2c8335405";s:4:""26"";s:32:"a621851b4fcbf8be99f5c2ddf69a0b60";s:7:""26245"";s:32:"2446f959565a17c66127c9ab00048bb3";s:14:""beaurieux-59"";s:32:"d0424ee04ebcbe2ebb46ebb48b145f05";s:7:""59062"";s:32:"a6cf6699ae5e15d13a364695ea3ef8d1";s:12:""villars-71"";s:32:"b72f647a069067159e54870c48a9dde9";s:4:""71"";s:32:"804e6c666104cb588b2b453ec70f541e";s:7:""71576"";s:32:"8684e79aee1406202e3a7263ac67f3f8";s:17:""ranspach-le-bas"";s:32:"6990313ef629cac8806776a41e5e81fd";s:4:""68"";s:32:"b4ab4757acb729323080f736abd1797f";s:7:""68263"";s:32:"1c81547bf4d81a36a57cde41babe443d";s:9:""chammes"";s:32:"6e11f612c92a276a2ef74e3839222b11";s:4:""53"";s:32:"205f81e7f18bb6f5cb2c4e890a8e459d";s:7:""53050"";s:32:"ed6de4a8ba5f77e51d8f426ec3f354d7";s:8:""thenon"";s:32:"cc5bde3abaa177d24c17025c69a94f25";s:4:""24"";s:32:"62be67d8b6991e6ecdafbfcfe9dad7cf";s:7:""24550"";s:32:"0e7602f20951c15520e32a627f4d659a";s:11:""brigueuil"";s:32:"b8ac2f30f4341d6ca9249c0606009ff5";s:4:""16"";s:32:"9f0bd3245c1b07f6135dbc8abfd86314";s:7:""16064"";s:32:"95efeb0e57207423d20413d5f5f1e5c5";s:23:""forcelles-sous-gugney"";s:32:"80394ea42cc6092bc2561cabcb740ec8";s:4:""54"";s:32:"65a4179fcfdbff691c2636e4286b0bbf";s:7:""54204"";s:32:"9db13da071e8478e4a9254dcf1021935";s:14:""genetouze-17"";s:32:"2a505d3269598f3009c52295db47a5a7";s:4:""17"";s:32:"ac7523847eaaa1a288e13fa6182d6776";s:7:""17173"";s:32:"7a7d5e9d9b705ed1cfdbeca923becfa6";s:15:""grandville-08"";s:32:"68130c59efa49b950f1b6720973bb7a7";s:4:""08"";s:32:"12d6766bfb33778e8b53dd6a97b69b10";s:7:""08199"";s:32:"88427014c039a4bad90d6019f8a08f2f";s:14:""charleval-13"";s:32:"5a340de1227abddfbcbf93f153a8440f";s:4:""13"";s:32:"790c3bc9c342ca80ab8288c14f07502f";s:7:""13024"";s:32:"24caab1466766d2d4beeb3607f744320";s:10:""bouzeron"";s:32:"156a5b5f6aaa7f14511edab86c608481";s:7:""71051"";s:32:"d0cb6643bfa15c0def078dba89083012";s:8:""arleux"";s:32:"cde59658d9e308cc8fa4f3a72004e196";s:7:""59015"";s:32:"b03ee66ed085d297d90f8078756f6154";s:13:""contescourt"";s:32:"cc5f3c62de4eda0b1629d830636de7a8";s:4:""02"";s:32:"8720c636400eb33ec43817bf92e5c5a6";s:7:""02214"";s:32:"ef323abce0d8965e904ec7fff47adb95";s:9:""moleans"";s:32:"114c05c933ee040936c0b3f95f2ca4d5";s:4:""28"";s:32:"da1d26d40c4b0b2f9867639344f135d4";s:7:""28256"";s:32:"01265fbfc2f39c3c828c5d441dfcf414";s:9:""conquet"";s:32:"13108ecd230ac992c904d2febc925703";s:4:""29"";s:32:"777ac9d8549e2ca4c9058c375b5578bd";s:7:""29040"";s:32:"2dbf2db8744df8631ed0f76a34e4a32b";s:24:""st-hilaire-de-chaleons"";s:32:"38910b5f5001b084555a03a28492bd94";s:4:""44"";s:32:"266dfa29d958104facee19766aef122b";s:7:""44164"";s:32:"b1ee37807822a9ed57dafbc3f0171936";s:6:""jort"";s:32:"ca63792778e7aa577dc891758f6e9aab";s:4:""14"";s:32:"b981cb5da8a8fa014a57939937c34c69";s:7:""14345"";s:32:"8a76c19ed55e2355799a43de45acb65f";s:8:""farnay"";s:32:"bdd2cab4714f4907b3fc8a0ff2f6f7cd";s:4:""42"";s:32:"be81976aa6a4ed5b6b02d02f826c535a";s:7:""42093"";s:32:"cb0ccfe5e8da2da0c3ae2a416b0feffe";s:7:""juzes"";s:32:"1d3e8f1ada9f355d89aa21f9e9cdf53c";s:7:""31243"";s:32:"500ece7657576c78f5b4df3c7020db29";s:21:""st-julien-de-chedon"";s:32:"46285367973c1d568ab8b875167aaaf5";s:4:""41"";s:32:"b81c1662c4c168974863641948ab6604";s:7:""41217"";s:32:"ee233bbefb0497d709a290546cc29305";s:10:""huparlac"";s:32:"0d939fad644de5340afa5f7d98546bac";s:7:""12116"";s:32:"c5aa67c4cb2af5fd510c8807ae052811";s:21:""champagnac-le-vieux"";s:32:"491c24a0e819ba97545f2d12664d2b1b";s:7:""43052"";s:32:"bf4d65cd792097b5a47eb31e686d99a4";s:10:""chacrise"";s:32:"d0fa7e8c254cc8509ebacb4ac9cf208f";s:7:""02154"";s:32:"ed45cdf2f6b38962cae0c9211f5e1215";s:6:""aure"";s:32:"407b30a839428b48caa6603f01c7e835";s:7:""08031"";s:32:"9b41461414b7282c51ee09c9858dd0c5";s:11:""taillades"";s:32:"fdb204524e6231c6606712ff78ff4f79";s:4:""84"";s:32:"18ede381b8968dfa02f7f2820d1035d7";s:7:""84131"";s:32:"fd40f5e986c832a915b33f937eac4f69";s:13:""montigny-72"";s:32:"444c2c84d8e4e8cde5e19b3761d4ad05";s:7:""72207"";s:32:"af60d536239e9993db6d11881f5f04dc";s:10:""malandry"";s:32:"20c1c7735608c98f3a4075239ad213a0";s:7:""08269"";s:32:"d12c4646813ff940c7cc6758e3dca277";s:18:""berrogain-laruns"";s:32:"abed2f95e3e5b2885ff6f578794a26d8";s:4:""64"";s:32:"961a268524cec9dd19b6d59aeb787826";s:7:""64115"";s:32:"58008e3b2ecab18ca9e5d69523cde0be";s:12:""mayreville"";s:32:"167bbbccc66597a3e0bee5ee6c3eb216";s:4:""11"";s:32:"8d16ca553ed9219cf3700a24dcad269d";s:7:""11226"";s:32:"e4f8432124fee012e7743ac01e2ebbea";s:6:""toul"";s:32:"6dc9e8a87e7977d1518597e1ce6cf938";s:7:""54528"";s:32:"d7ae2b53c34185a4b60330a2bf4e8713";s:10:""loyettes"";s:32:"7c8c6b2b9440e853af2a2f5ae0ee0884";s:4:""01"";s:32:"d00704299fa3dfe56f5b9a59221013b0";s:7:""01224"";s:32:"34cc87f2ed3f9d8eba41bc091fca70dd";s:16:""labarthe-bleys"";s:32:"3498b7e117a5c0f1d431fe931c209df4";s:4:""81"";s:32:"aa4e0c84f8e18b406db9585d7d1e6f85";s:7:""81111"";s:32:"fb51459834c4e9982f4955c1100bfd4c";s:19:""ponce-sur-le-loir"";s:32:"0af9af7c6a91e60a62248aad73bca850";s:7:""72240"";s:32:"1ac74e11227fa5456b933f232c3abf3b";s:9:""dalhain"";s:32:"dc22fe3c1ec55a2edb2086efd4271ad8";s:4:""57"";s:32:"7e45cc7ec1116c289e0af0b9890d549a";s:7:""57166"";s:32:"99317736cfb0759da12927c59093cc4f";s:14:""casamaccioli"";s:32:"9ef324a0e918cc70bb944cdbb856e5f3";s:4:""2B"";s:32:"b225b0ab15a4d6c79d4b7401d2544fc8";s:7:""2B073"";s:32:"ad2ba8ab62596966af4afe5c74d06dcf";s:22:""lafeuillade-en-vezie"";s:32:"d1582db820a0fcfeecedba5685e3da9d";s:4:""15"";s:32:"c90c16fe8d9a23c4983e661cb21e6a13";s:7:""15090"";s:32:"b8b7023da49d175706b20162a3640a97";s:7:""frais"";s:32:"b6554ae489225685bf271d1d2ff0eb20";s:4:""90"";s:32:"770f0375d616e58700585515755f5c63";s:7:""90050"";s:32:"a1b24f9e09dabdd3352557481c6924ba";s:11:""excideuil"";s:32:"f4cab4ccca56c197a9aa3015a5bd45f8";s:7:""24164"";s:32:"0e38cf44a5d1dd0925f40c31de67518d";s:18:""cros-de-ronesque"";s:32:"8a0264652db657481d6b67ef2474fc72";s:7:""15058"";s:32:"8d194ba1a589f0ad7aee51117ce90ae4";s:24:""fleurey-les-lavoncourt"";s:32:"be7175f45c182640c54295ffb5040c51";s:4:""70"";s:32:"159824f415869106bb0af7851226389f";s:7:""70237"";s:32:"15eb8753bf9dac4a49b95540dd114d83";s:11:""chevrerie"";s:32:"73ea0da8d22791084536dc5c99aaaaae";s:7:""16098"";s:32:"4e3124e450cbccc5c4936db085ec1765";s:8:""millac"";s:32:"8b494f47bcbfd630030ff7131b5a3f2d";s:4:""86"";s:32:"f101893fa7ee193fe5fd57f2a6fc2b60";s:7:""86159"";s:32:"a71ab15366107e0ea0d56781b77a9317";s:19:""martres-sur-morge"";s:32:"47070379839a9e6a864391f70646687a";s:4:""63"";s:32:"48dc28cb0448a92ff7d2c011ba99b88f";s:7:""63215"";s:32:"0db4f74a646d7fee6918a8a0725ad326";s:10:""laval-53"";s:32:"9a63fd832c055c39687959d69c2cc28d";s:7:""53130"";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:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"2ffa10898e9954904e89a88f1a4375a1";s:9:""tazilly"";s:32:"99ac0e71a40555b4f9bd78c12ecffe15";s:4:""58"";s:32:"4002d8cd47be77aaa6d60268410ea972";s:7:""58287"";s:32:"bb7a062644b13b21b07d4278503caaa3";s:7:""balot"";s:32:"f90eea21e7f924152ce55baeaa8d2acf";s:4:""21"";s:32:"b44fdd5ec08d53027d659bad8ef1a1a4";s:7:""21044"";s:32:"92c834c007bc2c3914f439db5b8a7524";s:11:""anglefort"";s:32:"5634eb79c706f4f7d86f9506e377d9b0";s:7:""01010"";s:32:"8019dc0333efa392f3afd1da74de7940";s:8:""ruages"";s:32:"a1dbb62badd0baa962c3b88a723dc130";s:7:""58224"";s:32:"4a167815091f04463aea88570d269c99";s:19:""bourg-les-valence"";s:32:"6d14590ce14fb538e1c9fd83ff2b8d78";s:7:""26058"";s:32:"1a611641630a0f76448307de5e9bb480";s:14:""larressingle"";s:32:"8789547c05bfa02798ab3128eea30e2d";s:4:""32"";s:32:"2a844d3e7da75a66f1b5dee24064218c";s:7:""32194"";s:32:"895a9994304e21d72858cc4d8e46718d";s:12:""mansencome"";s:32:"f1116c4f803f9788a7aad22652728184";s:7:""32230"";s:32:"e5060cec3057f126160e18c950392999";s:12:""laprade-16"";s:32:"2af97a060a9fef44bf18103e7f822bc3";s:7:""16180"";s:32:"9b5bd4c2ccdf1b3d27607032bba8d50b";s:22:""ville-di-pietrabugno"";s:32:"9f5f17af35af502191884390514c12be";s:7:""2B353"";s:32:"76e23486faf6ec9c8015b7bc08cdee47";s:19:""hopital-st-blaise"";s:32:"eed51f41411284f4a1c959177f9c8661";s:7:""64264"";s:32:"26f5e3df19f50ce74dad21900fcd6eab";s:9:""ancizan"";s:32:"536752ea892f8bcc379795e80ead2ffb";s:4:""65"";s:32:"9f0fbf552583ab9e2ced45bcf9a85d75";s:7:""65006"";s:32:"d6709d82cc944bbe445acb0410037313";s:21:""martignas-sur-jalle"";s:32:"32bff9e80f10703e91f6a08f66e94632";s:7:""33273"";s:32:"69c20b5b25498620ccdc68389da7ceb2";s:11:""ameuvelle"";s:32:"25cdca52a35f09964121c4b572df2ddd";s:4:""88"";s:32:"a50d04bd55fe16839210f107df9e49de";s:7:""88007"";s:32:"23dc1e2dcf286cfe5ee1e3487ee40fd7";s:6:""lacq"";s:32:"b3a1cfff4530e80fde2e1825b5565e78";s:7:""64300"";s:32:"77310d3c1e1969573931b48622fd14ba";s:10:""st-satur"";s:32:"9d410b12215ce4f7fdc71e4e3019753f";s:4:""18"";s:32:"9eff58156c2541a78823d2d4be3eec89";s:7:""18233"";}s:6:"fields";a:225:{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:"3c34cd35d0a24352a7fb4362df01d2ad";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((50.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.48333- 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:"5e982d7f0463b7b090f543122780f8f2";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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2*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:"aa302b102e0384a811989e3fe8c4f6a3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8d4d5c40f8bafa939a03ac5602bf3fd3";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.9*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f0b02b5220b601e3a7a09f15c4e5cc03";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f51ae4c4136ded5d5133e46945b2a4ca";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.583333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"05650c51b5f8a5f986ee05bcf5cd14f5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9833*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:"9cc864ef27aed77f3c79716355645108";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.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9833*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:"92f897fe03adaf498b67b5286d785749";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e9661b316bb7673ed1afbdb3235d6010";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b3595964c489df43751cd24c1bf291c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2195cf967edb3ed4631a29046482215d";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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e02b554cda2d1476b3027e41a5b594f1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"61ce75a05968ba3bf3b84593cd2bf9dc";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"71b792456d650814589b5bdad1fb4516";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((44.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b1e3a1518559a2e0133d6655d3300dd3";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((44.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f300900096cf3213145afcb61973bfd9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((44.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b41eb5a41b93b004fd104dfac63b4ee8";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((44.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.8- 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:"fa92544554fe2daeb001a7cea9b3180e";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"8c3d294975878c3d977ae068591e1fda";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((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.516667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a8a3481db859d1b55cb5f7ed48a28133";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.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"223f77499f20517f464b667f9e82a1ea";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4462*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4462*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.45223- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2782a432621d6e04ad72b7f8baed9b70";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.4462*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.4462*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.45223- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fd83a1027f3cd6f49f5de171f69d0217";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a911139a3972c247834c8dd559431669";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.11667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6274d62ad0a8f6c4077db390eb804a34";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c7706e1efb098f99a46ef87c4b34b10d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*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:"80bf80cca7b1780a73eb98a4f7cc1837";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*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:"aca87e2808408cea0038d4ba41b3bcfb";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.8305*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8305*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.32526- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b6dde0aba140ee3ec58ace44ead25870";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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa5261c7d5cd0d6eee68138dfcc59c86";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((50.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a3584eee8ac4ea2c8b218989e4e74f3d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((47.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc66bff0b54c08896b18774c06ab2523";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.45- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b9d006d29c2f645def73f68246a6eb70";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:189:"(((acos(sin((49*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49*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:"e0b9fd376e22c0002d0e6291a386031c";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((45.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"01c8e8914b32fdb06138e2325e299740";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((48.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c2ce6da3eab3fac8d04fa37db8b44d2c";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((48.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a1df244fbd4b9a4c63badc6ba537571a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2bd97386a9a15ad7820f41b3e491d933";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"09e6f1884e508869e49fb22decc2f1fd";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((42.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"82f2d4dd9165690d4dfb7f4cdb76a5f8";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((45.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2147f5152e3c62d9b80c26a34942fbed";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.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*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:"aaf11bda73f81363f380dc6a61b46601";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9531*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9531*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.85879- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"987bd163096d8435f75c8474c308d433";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.9531*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9531*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.85879- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6a4f90faaabf4f8249c73986fcf5dcc2";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:194:"(((acos(sin((48.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c9c960eb0c3184ed3b9619a2830d928b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((6.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"912b5dbe2e41e38f1a3281f8dc4b43ce";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(((6.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"62302742748d77d61204cd9db53cee86";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((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f0cd30a51ea2f26ebe4033b7479c3f3a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"970fa8246008f648ddd214c7ac65a129";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.016667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2aa6d3530b2cb113d86202d69e6db574";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((44.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dcae0e575ffc361289c6ff9638ca7c32";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c9f8e91b1bbb755266fe06fe8d680055";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1abd02a0ab709d2fdde76eb7344f0c8e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*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:"1c6f4ecbf073827cb35c74ad15928cd1";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*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:"98cf6ce0d88b18a006b9bbe78d46ade4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1b2574631f5ccc5e0687bf76cf31f13a";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4fdd64106171af8a3b8b2881cbf881ca";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((50.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.5833*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:"229e642faa4bfb5fa025fdfd48f4a891";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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"550d12f1370c28713984a3e9948d3ad9";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((42.627*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.627*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.42001- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e53bb1ae6928de63af8604c34317f206";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((42.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.6667*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:"34fb904934a97ac8b786c1d05f8eb8d2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((50.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cf95baf0befd43e5a171c63dfb7f6b0a";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((50.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a5123f572b1df72fedb7083228a2387a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bb86f0a75616bb6629aa904601db823b";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.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.8*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"928b2560a07752f1452f3f1f318b65ef";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((44.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9e67a0c090ec4cab8fd069851ea7b6a";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6f85ecc22a813ffae6e63b1d73a3a22f";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((43.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a00171c56b222640509ce4ac23fb421c";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.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bc1cfb88828c2ba3816a7f05e0a72dfa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1167*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:"3ce08e36368d65dac9ef6dd0bd331491";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.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1167*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:"941235edd530dc7d586cc717a2dc7af3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a3e517b2c57a1308a1ea8db81409db67";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-4.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"79f6d244310867820c0835d8437e1012";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:194:"(((acos(sin((47.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"baa3ae1eec83e786c866ab7f6510d4cf";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:194:"(((acos(sin((47.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"852227acae7e4d342c621d390476ac13";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((48.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ae9c9e170a152efc2e1922bcd61b434f";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((48.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.083333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0de1e4d6e8ef9c9df960ca8b71450c00";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c49dbb5acaaa6c005e5a30a6d09e1f78";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((45.5*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.5*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f99e3fc2bba07157c05d066b317a0b34";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((43.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fb3ec543c6ca02d010a519a928476519";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((43.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"12f149453e5c0ff19eee48021b6f1cb8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((47.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7d2ecaa8851303ca1f70caaf6f6159d9";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((47.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5935bfe2780c03267a3f147d77eff97b";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((43.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f173ae803baba5c79819137a4a5fae3f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ba0e3cdeb91ec2dbcb896ca48925f859";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((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d6455822ffdb9775b9b51ea7375af517";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((45.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0f3eef065ea626c112795d7359957aba";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((45.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"58a119eab1ee6fb3e9e77c5e6b68f477";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3*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:"83e3128bc5f7e804481d7ccc536850f2";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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3*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:"3906fd28aded3c3ea485627e0060ba9c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0e3955baf6cac66b2694aa63ff81e20d";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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2667*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:"c3f05f7a80326dcec245bc7c4e6f99be";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b2c8a8ed4e479c22cb4e01ceab63465a";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((43.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"461be55ffcc55bcf96680253bd1c9dd6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e73575dd2f3f5729b9db32212bd7df27";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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a7fb5449cf7e1a06d0be3f7517761638";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.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cf111a5ce39215d6b0f271217a0f8844";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d8e480933a6381085d287161c8db72b3";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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2eec24769d37b2a52df6bcedfa82d73b";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.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8333*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:"d98578090925bded3ea02dc583c2e6b8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c9cc81a2b12cf14f8931bb632236fce9";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8c7dc13e68bdb0159a01962e108fe98a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bd55859507afd80f02d38ef20de1154e";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"de07db0fa91812dbe9aa734dd84c14c1";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.8415*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8415*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.29292- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0fc1ec2a9fef73d8a934f2596b45b152";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b207a8eea8b114378e673d1a134cdaab";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"abddda94de25aed51bbdc4f568278023";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.9- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e0a594f65f8b64c5858bc9e7ee4b1093";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ae6ff30dcec5764601a31af59dc4d71e";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"636027e563da41e4058e3b2ea0d1457e";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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"30dbe27d003b79f49a0f0676ea15f523";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0667*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:"d78373828241414608059849bd1378fc";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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0667*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:"71c2105c44257ccf171ff09f63e32328";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((47.762*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.762*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.655278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fa5f7ef0452c965f49d9cc82afd08ee5";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:198:"(((acos(sin((47.762*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.762*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.655278- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"49db19798e063164bd8ecd165c6728be";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3833*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:"05469b093efac976fd3be0147d99e4a8";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b73afaaacddfca9ab2645b6932901329";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"53d8c5e0372ec5c203a85354ebc38120";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0788661c991768b1253288f67216d287";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((42.3175*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.3175*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.0014- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a5648ece9b170918369e6e7a41c998f5";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:198:"(((acos(sin((42.3175*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.3175*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.0014- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c0d9757d41b13e92d93347e3236c7a42";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"690e4ead4ec85280dc05aac3fa8f6ed3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"793a9592345ba35e1518f855afbd76c2";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8ff030502cbf050a398607d819284802";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:186:"(((acos(sin((44*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eaea5216f53503fc0d3490e6b020e289";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((47.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dae38768f4a75e2ad799416da961c372";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((47.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"93f66ea078a3731397104cc02e5dee13";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.3589*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3589*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.18862- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"eb2529e08f7d3b96852e12f2798359f2";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((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*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:"e5bf3a6120c914d9b7b390ca388e2a89";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*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:"98a57a5e995f1d8abc5cd55fa62673ab";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3333*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:"a0e500599161f37c0b6a16ae23845bf3";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cb6c9684ab44619766ba30875f3005a3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"238205d90597d1c2fd49216adff2d7d5";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.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2876f403ded5038179a79c6eb6b59b01";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d7d58690d55616b28f18171fb922a8ab";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}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:"7d5628f7aff207e0d7697cd24171f56c";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.4- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"452b902c7ab99ed78a764933dea5e876";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6dc231205c161329c63127ad3ffb3d95";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.78333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e76a485dcb016c6e5fb894f5ae56d07e";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((49.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7324e60ec9271b7cbfe8b2c94d0dc616";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((46.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*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:"77b9e9ffaae141e8fe8b42319f89b3de";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((46.0333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.0333*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:"efbb45b1cad0632b1e0e1dd4fa0c3faf";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((44.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7333*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:"222b9b170a58b010fdcc6b0fc8e435a5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((46.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2591bd3f8ffabb16c2874ac53f723f05";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((46.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"124097a953fd14f73be2322f556a77d3";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((49.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"489ec61557fdaeea8a860eb5cce52247";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.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.56667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0aa612d8c4cc3f5c397c654abaebfde7";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.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d90cd852b2357b1b0508a0f0c0c07c86";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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"59bef5927a1ba738f4f0c8fb70e3041e";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((46.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.233333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c37c06426401ef367a22cd207fe68d90";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*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:"8a251edf99415d1b0df86d38e24f3023";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d00c56cc013ba987c3b98945d1f5c005";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.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.21667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"132b72739ceeec0f277b76eab6154931";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((42.0275*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.0275*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((8.84279- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ca04a3b8ae354d04eac94c679d85c2a7";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.7589*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7589*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.84139- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"af40fb0dc78a56310f06b01ef4e735e2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((48.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0667*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:"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:"81dd9719e97361544c264560e082513d";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"ac3d2877890c97f085ca3c1129984d0f";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((48.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0667*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:"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:"d30a7824e3233b735589b92867b821cd";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((48.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.6- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"83a0f8fb001ea8facae824e4ede38799";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((47.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"75bb4e4e29f5ab7ac0fe4f0b695c8a3e";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.266667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"edf54952b204cccf606ee47e854f1432";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"692945ac65dffbdd2537e9d2cbb76aa0";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbff2b34ee5e8c1d88d5dc35489b12ac";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((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*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:"0a0a5db1358d0f5bf9805cc8416f7080";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((43.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9333*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:"5f87ce5ff6d4321a5c812c063c6e60b3";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6fe12c0ba2a13b111b679b12fa22a230";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8167*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:"f315fd545e8368fb930f2e3c0ccd7a9d";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.8745*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8745*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35994- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e1d6e4096c115c874a18ac24717494b";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((49.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.85*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:"dd9d0776e625a4013dd3590dbbc4246c";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7833*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:"3ef1f3dc8ac4def792e2c5ef062aab13";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.8- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b707ed848efe474fe16a51a1611378f9";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9dac835736b3e511f940a1e74c27451d";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.8167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8167*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:"a90a6bd3102f1cac55e9eed2cdec8932";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((48.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"66bc94c814e602e059aa4fcc1b0f687e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.80833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7d3dccf095b8af88b60e1b3e5dff95e";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.9167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.80833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9acfeab1ff8cc482976e8f1e5e443ec4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"114bb739f844580852b2dfccec82c62f";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a741ee74ea95cc54d7ecde2cbac98384";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.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.1667*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:"51783f294d9648261e18c40915000265";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7ec7e634052c474925fba5028a70b7fc";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.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*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:"709757d3231a03a7f1f3e5c259ac7b60";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7dd147282621af499f465b9f34c702f8";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.7667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.283333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4accd65e2ca29de177aae8501a216766";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.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b279bb017d86e89d87897e7fd0f1557";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.4798*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4798*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:"2199a1196d3b18c7c448e243e808d523";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((44.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"74dac443b03668d908f4327256f6613b";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((44.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f9563cce452e922ffc93d12d94e013de";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((43.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9333*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:"d8c852ed872b2b2b76ba2a53480a61c0";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((43.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9333*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:"6afc731b90146819ab892bb66787f7c6";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.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"149d7ed164b3937561185fb64ce1b49f";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((49.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bfff6a0152bd40823e58ce969e0fdd89";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((43.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.333333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"77a6c38eee6e96925350d5913cdc83ea";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((43.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.333333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9625c3ff0a7e61dc4347a7227b6ad583";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7fa6e2cd62395ae2a6680d332181b62b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4737552814c211477ba734fe6fc1a052";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((45.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.183333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a72a0512654850f5db11a137c664621e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7134*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.7134*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.43112- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e37294d1ce150394595f7cad19f2b9f3";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.7134*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.7134*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((9.43112- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"753d5c7faef31b370b430e8db42f5a19";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((43.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.25*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:"23f9f86c2936a41b7703e465b7abc57a";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((43.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.25*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:"09c7b4d0e9968d18251af386d9d0f791";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8833*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:"6c1d6e0836476fc1e1db69064d1ae460";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.333333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d2f60208baea53eb2d79b055e2aa001d";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.333333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b384a0e495a1faa6768edb95aeccf73";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*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:"24cf78f9f1480d333eb75dfa42f870fc";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((44.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8333*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:"0efd99fdf4730643352cf256dc6700e6";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((48.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.35*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6aec9b8c6c38248cb89eab5910834fcd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:192:"(((acos(sin((47.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ffe7e6af80b4f9292885954f99bbc388";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((47.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"40adf21f095c29558faca4d57725a152";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:201:"(((acos(sin((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c0c9fa3d5c8f33010a49435aeb8a951f";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((43.4167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.633333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9dff35d5a0ad85cfada227a00cd042db";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"41df6b164725937c010cf2be86e4b094";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.3333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c7c1a4e7653fea40ee8b09baf55bb1e5";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.43333- Ville.lng)*pi()/180)))'
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 Mazures (08) : audit, apport en nature ou transformation de société
Vous recherchez un commissaire aux comptes à Mazures (08) 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 Ardennes (08) et plus exactement à Mazures.
Missions du commissaire aux comptes
Audit légal Mazures
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 Mazures
É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é Mazures
Changement de forme sociale d'une entreprise (ex : transformation d'une EURL en SARL)
À la recherche d'un commissaire aux comptes à Mazures, la majorité sont installés en centre-ville mais parfois aussi en zone commerciale, sinon peut-être dans la commune limitrophe :
Sécheval, Laifour, Deville, Montcornet, Revin, Arreux, Renwez, ...
Choisir un commissaire aux comptes à proximité
Commissaires aux comptes du secteur Mazures
En choisissant un commissaire aux comptes à Mazures, 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 Ardennes, nous avons fait le listing complet des experts-comptables et parmi eux plusieurs commissaires aux comptes à Mazures 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 à Mazures
Actuellement, nous avons recensé aucun commissaire aux comptes installé à Mazures (08500) mais plusieurs sont installés à proximité (voir liste ci-dessous).
Liste d'experts-comptables secteur Mazures 08500
Dans un rayon de 25 kilomètres autour Mazures
Findeo a listé des experts-comptables dans 10 communes dont le plus proche à REVIN.