$key = 'myapp_cake_core_method_cache'
$time = (int) 1743648765
$cachetime = (int) 1743648772
$data = 'a:3:{i:0;b:0;s:4:"name";a:497:{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:"8723bdf08285db6c2a5de04f959fa8d6";s:9:""annonay"";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"7d5bf0a4d28e38856d4a75ddbf57dded";s:4:""07"";s:32:"f721416f99749f3df35aa11d34cb1cf3";s:12:"`population`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"488e02d2d9b1182f63c3d8f5f847895a";s:43:"`Etablissement`.`dateCreationEtablissement`";s:32:"becfa4e4a7c9b2d19025948a972a6478";s:23:"`Etablissement`.`siret`";s:32:"8bea2320f371062a7b0ab922743bdbd0";s:32:"`Etablissement`.`nomUniteLegale`";s:32:"39941f15b49a2123784b162f8a31c536";s:36:"`Etablissement`.`prenom1UniteLegale`";s:32:"a29bb400575f4ad025669248520b5fd9";s:41:"`Etablissement`.`denominationUniteLegale`";s:32:"c7b4465e36264adda51d3dfc880ea50d";s:41:"`Etablissement`.`numeroVoieEtablissement`";s:32:"8ca3ee58be10f4b9b4b725e42ade3fc6";s:39:"`Etablissement`.`typeVoieEtablissement`";s:32:"de1f07c3d6a17cb43da0576792c1c478";s:42:"`Etablissement`.`libelleVoieEtablissement`";s:32:"e44f29c308bcb4d3419f9acea8bd0088";s:41:"`Etablissement`.`codePostalEtablissement`";s:32:"a35619803f6ab7ff11b719bb5c3cbd7f";s:45:"`Etablissement`.`libelleCommuneEtablissement`";s:32:"9cc9932f961dd20be2485b6e784c67c9";s:9:"`Ville`.*";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"7ab0ad68d7b28d18fabfe0fdc5224200";s:42:"`Etablissement`.`codeCommuneEtablissement`";s:32:"fd3e2c0d8ed3b202e02ad85262c8401a";s:7:""07010"";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"e34b60478ce1cef3ccc89cca861f05f9";s:19:"`Service`.`NB_B101`";s:32:"07e70f22f37a549af7d22b7c28e865e9";s:19:"`Service`.`NB_B102`";s:32:"1c5b949b427e7e1b3aeae0620d972ae8";s:19:"`Service`.`NB_B103`";s:32:"aca45966f82d09b0ee2d88be1ce3df1c";s:19:"`Service`.`NB_B201`";s:32:"79ea3716e58e315008fd776f60c11bc9";s:19:"`Service`.`NB_B202`";s:32:"dc8a7a3b7e8033b403197b19fd07975e";s:19:"`Service`.`NB_B203`";s:32:"9bae0dc971489368e8494000b09ae6bb";s:19:"`Service`.`NB_B204`";s:32:"9a7b3341d7f5c3787707af4cdd0b11e0";s:19:"`Service`.`NB_B205`";s:32:"40a6054c006a0b1c7c9a311d40465e07";s:19:"`Service`.`NB_B206`";s:32:"5c48108c2e7c486b82d640a57cf05912";s:19:"`Service`.`NB_B301`";s:32:"5fa9458a3a1754a77363355e3757ea30";s:19:"`Service`.`NB_B302`";s:32:"4c39997739bdd4f31eadccf0bc845c57";s:19:"`Service`.`NB_B303`";s:32:"aef37473cf0f18fe791c005e4c63c90b";s:19:"`Service`.`NB_B304`";s:32:"90088d9e1eef44a282a9d956a5f37503";s:19:"`Service`.`NB_B305`";s:32:"14a89eb6273eaf86f23518c2cc7110c6";s:19:"`Service`.`NB_B306`";s:32:"9ba00a5169a4cf2de4c82d114c92a09e";s:19:"`Service`.`NB_B307`";s:32:"67c7ac8728c814a2ce44fc314ffcf353";s:19:"`Service`.`NB_B308`";s:32:"07407fbb6de4cd59233c477d837582b5";s:19:"`Service`.`NB_B309`";s:32:"fb7b9c044eef55d3cd3ab813b8a4bfd9";s:19:"`Service`.`NB_B310`";s:32:"39b14590ba9369a9ec2e66d785934f42";s:19:"`Service`.`NB_B311`";s:32:"ca9eb4a16bf08454a1145437a2650b52";s:19:"`Service`.`NB_B312`";s:32:"57524c4a80b277792b471e374e0b9607";s:19:"`Service`.`NB_B313`";s:32:"b3fb97d4b638447dcdca139f59c7d358";s:19:"`Service`.`NB_B315`";s:32:"04607308bb52a925bba2de8d4a32fe08";s:19:"`Service`.`NB_B316`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"a607c62eb7627b017d17dd2da59b0c9f";s:18:""escles-st-pierre"";s:32:"e8ade83b3133886783b73dbe2958bd22";s:4:""60"";s:32:"198894e6a0e8523d415b568fbb6d3517";s:7:""60219"";s:32:"31f60943a6f9d7ae8190fb02e41ae2fe";s:8:""billio"";s:32:"b935e92bc471b44350f38db369fbe2e1";s:4:""56"";s:32:"dd8aebade9eb284a283a0f3f9c928fc2";s:7:""56019"";s:32:"ae083c444b4c9966e1765b50df500c6f";s:12:""grosbreuil"";s:32:"f9f5f147f05d82ada7e773fb4b3a613b";s:4:""85"";s:32:"0c3e52f608aa1e4a82eae41b178dc2ec";s:7:""85103"";s:32:"4b5b179f3d4d02caf2bc8f10c9508150";s:17:"`Etablissement`.*";s:32:"e6b8ac227bd20feed342e5ed0866d680";s:10:"`comments`";s:32:"4881f20c5aa26c0469f4bd33c64d89e5";s:14:"`Comment`.`id`";s:32:"60b99a41e18de7d4f2356593a1c2cc3d";s:18:"`Comment`.`pseudo`";s:32:"91239733a2f8a455459509f5d6a17048";s:19:"`Comment`.`etab_id`";s:32:"d1fcf017825e414e48d0f305631b4799";s:19:"`Comment`.`contenu`";s:32:"bc377e3ee747a291022e3d709a322d04";s:16:"`Comment`.`note`";s:32:"79381faecb510d816a0b81f6ae2c6d92";s:20:"`Comment`.`antispam`";s:32:"9941ed581a2ed345603ca6c4fe47d0fc";s:17:"`Comment`.`actif`";s:32:"7907a258585a2c024cf585030578d69d";s:19:"`Comment`.`created`";s:32:"0698907dc910891be17ff02b797ae0bf";s:18:"`Comment`.`posted`";s:32:"c87b6288c09482f582fd3874f1e9f7a8";s:9:"`Comment`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"14741c911531ed3fea114a6c33434481";s:22:""st-guilhem-le-desert"";s:32:"a982bbb042538731dfd4791b2b615ac9";s:4:""34"";s:32:"12febcd46bc9acb7649aa23a6bb9a90e";s:7:""34261"";s:32:"d8a93473fab780ca0db994753056abd6";s:8:""caylar"";s:32:"f6aff11847284fdbd7632ebeada9947e";s:7:""34064"";s:32:"355735c66c5dec02fbd7d2bf180d2e5e";s:5:""eup"";s:32:"15d6b97cf557c9ef82700914e59762c0";s:4:""31"";s:32:"9263252d9a4ad43aa6f2085f7f42e2a2";s:7:""31177"";s:32:"3577074038e5dae578aa3c46f135161b";s:11:""bligny-51"";s:32:"30e0fbe2dedd7496d6607455959eba37";s:4:""51"";s:32:"cfd712722766aae0664f426518db20f0";s:7:""51069"";s:32:"8a98359e9dad041aa422fbacd58db5dd";s:18:""challes-les-eaux"";s:32:"bfd41f4b6c418c96827626f7e6347cb6";s:4:""73"";s:32:"5f5f3b9a2f02aa33f8385ce1b7d12b77";s:7:""73064"";s:32:"bb8f4bccd0beb6cec55fa65db8edf730";s:21:""champigny-en-beauce"";s:32:"46285367973c1d568ab8b875167aaaf5";s:4:""41"";s:32:"8b88957fa7732fb17e1a2eb216957c49";s:21:"`Etablissement`.`cac`";s:32:"56ccad41f25b93335590dcac935d83e3";s:7:""41035"";s:32:"7496552f138665f9283eba6216a671cc";s:8:""aignes"";s:32:"8fcda820d43a54d11957547444547517";s:7:""31002"";s:32:"57bc24f025bf9a0abbc483c6692e2267";s:20:""st-bonnet-avalouze"";s:32:"cce1cc10a574f13a093a92350396d473";s:4:""19"";s:32:"69af9d82baabf9ae2a3271c3369ce5b7";s:7:""19185"";s:32:"5c5186aec7a0a63122506633dac358b0";s:4:""06"";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"0a1510d0dffae11b88c8130de3cc3c6a";s:14:"`Pub`.`format`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";s:32:"8ecaaa87ac95fb6026267ddc489d4e00";s:10:"`Pub`.`id`";s:32:"03bcab00ea59985094d3823102128dc9";s:13:"`Pub`.`title`";s:32:"19ae68421a7af6fd53280292661686a5";s:12:"`Pub`.`link`";s:32:"adf6b0dc760d6ba40793e6ccab265414";s:11:"`Pub`.`lat`";s:32:"3911c9de594ddd79639957c57fa6f86c";s:15:"`Pub`.`adresse`";s:32:"013acd686b9d6a62ae480ddd5854054a";s:11:"`Pub`.`lng`";s:32:"9a9117f5211facf70dbcba9197db0119";s:11:"`Pub`.`img`";s:32:"a0ec82037a4d9290d4b4962c6dd972ca";s:14:"`Pub`.`height`";s:32:"c584a2fb465c8e8da20fba3f63f5f9f5";s:12:"`Pub`.`view`";s:32:"40c6caef6b63d5cc208b1f45871b776a";s:16:"`Pub`.`view_max`";s:32:"9da1d158b7b3f5102350b7a469c676c4";s:16:"`Pub`.`national`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";s:32:"0eff2b74a60689e7283c8dd9dbb6b2f5";s:17:""chateau-garnier"";s:32:"8b494f47bcbfd630030ff7131b5a3f2d";s:4:""86"";s:32:"4892ace91034e4e792ab99d812ea4983";s:7:""86064"";s:32:"26225bc4fd56bc1ccdeba8101917faae";s:23:""creyssensac-et-pissot"";s:32:"cc5bde3abaa177d24c17025c69a94f25";s:4:""24"";s:32:"c10cfc68baa31b06867eaa3755346306";s:7:""24146"";s:32:"b39520d61b8b8e2e7d041ae48fb83dbb";s:21:""coulanges-sur-yonne"";s:32:"5b2f330d6cad4adcaff0785a2c6b85a3";s:4:""89"";s:32:"fd14cf5db31bf2a47445e0c95292f8db";s:7:""89119"";s:32:"0de673ce82dd719cb3024118657aa0f4";s:14:""cotes-d-arey"";s:32:"8f4f7252001b87bb9ebc001ec6ba70a6";s:4:""38"";s:32:"762922b64c14f6970e61d232acf8f652";s:7:""38131"";s:32:"5429968c725d7890c9c96637c89168cb";s:13:""bourdeilles"";s:32:"a4237b0e00429af9c66066f5ca8f8de2";s:7:""24055"";s:32:"3fbafb36807c6b8f2e67eb29201ebf90";s:21:""st-jean-la-bussiere"";s:32:"1df51dd1653034a991bccb998695011b";s:4:""69"";s:32:"5e410572b67479c32c269d1bdfd8d201";s:7:""69214"";s:32:"779913a5744e3eabcc948dde8bd9d0f9";s:9:""croisic"";s:32:"38910b5f5001b084555a03a28492bd94";s:4:""44"";s:32:"b1c4f16081e960a48b2a16258757a8b9";s:7:""44049"";s:32:"f90eea21e7f924152ce55baeaa8d2acf";s:4:""21"";s:32:"2f1994005a322d4911a8898c9107f7b0";s:11:"`Comment`.*";s:32:"fb23b95c5ee2e3ba4d214f558bc45d48";s:11:"`countNote`";s:32:"e0b19f8936eaff31dc903351796a713c";s:22:""st-andre-goule-d-oie"";s:32:"3539655e6a26a10ae5c1d64a7e978f96";s:7:""85196"";s:32:"d82078edc863c21113e8f48a4ac7ad3f";s:9:""lanouee"";s:32:"1186920e20a0b809dfe32c2bf9ab20d0";s:7:""56102"";s:32:"96ea891e222ec418d41e2e4eded502ac";s:18:""roque-d-antheron"";s:32:"5a340de1227abddfbcbf93f153a8440f";s:4:""13"";s:32:"3fda54cc8370c5c50cd8ac240fd60814";s:7:""13084"";s:32:"cbd38969de31645cb4476f29b3199d19";s:13:""manchecourt"";s:32:"23b80b839585ad4545664371948eb48a";s:4:""45"";s:32:"7bf71a5184c1e80ae63300ce430ee4c8";s:7:""45192"";s:32:"0d1c1e821362a025369deb745cfef963";s:27:""grandchamps-des-fontaines"";s:32:"766d5e8b8ad53d9f0d68a64c2744fb27";s:7:""44066"";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"a315219725f5512de7f49d3389fc6d1a";s:8:"`Post`.*";s:32:"cfacfed443d6f30e67edf9bbcb06ce30";s:7:"`posts`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"7dfd722c23fe891c8e2591a704a556ab";s:19:"`Post`.`agregat_id`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"e13d78515036382daf55fa083088c902";s:11:"`Post`.`id`";s:32:"c0a33fa0f04ac4682dcdc4b25167b3a8";s:6:"`Post`";s:32:"b4f1ad1de4cdc3a3f82e905f8dfd8673";s:16:"`Post`.`created`";s:32:"bcbd8f2dbc9172e3a3142affb2892e5f";s:14:"`Keyword`.`id`";s:32:"f0390fa2e07b4a53538ebc42c3a44987";s:15:"`Keyword`.`lib`";s:32:"a82fe8f431f55ca3e5c6eeb1425d6fa5";s:16:"`Keyword`.`slug`";s:32:"a88baf43cd357230f8c9342b8d8c1fce";s:10:"`keywords`";s:32:"6c66eb299f72f8ea6373806e1792c9db";s:9:"`Keyword`";s:32:"aafd056e6d53878a75ab4ee3f18645a1";s:14:"`Post`.`title`";s:32:"9ddb253dbdc4f0cd59c063afc2867b24";s:13:"`Post`.`slug`";s:32:"05f7ee1081ffc383a68b6f03f65b8eff";s:17:"`Post`.`keywords`";s:32:"3ace1aa89900c4f756239bf4d42ff255";s:6:""%11%"";s:32:"c12fa088b43d2744956f7a404ee820ed";s:15:"`Post`.`resume`";s:32:"4ef28fa2b0703a50ec749713ff9d67d6";s:12:"`Post`.`img`";s:32:"5d7d1bbf380198dd4b539493b0a9ca2e";s:16:"`Post`.`content`";s:32:"e7fa88aee3faef8b86139e3abbf5133c";s:19:"`Post`.`marronnier`";s:32:"591e71c6b2ed774dfc5eeee5191ce1a7";s:16:"`Post`.`modifed`";s:32:"154f7de5609eff20afd32fd5b5ba38cb";s:20:"`Post`.`publication`";s:32:"c854e1423a502a6afe92112a9e734816";s:21:""abbeville-st-lucien"";s:32:"258653a6544d6049c39af48d79463b65";s:7:""60003"";s:32:"aba4c9f55c050f4ea4d0bab9bed473fb";s:10:""crachier"";s:32:"d70ca5fa0354f4126da0c79b3a8af2c1";s:7:""38136"";s:32:"08053378fa607ad6ae5abf1df861cff2";s:17:""longvilliers-78"";s:32:"fabcf25abfd5f87138769bbc7a1c4666";s:4:""78"";s:32:"77f674dab40ac8dd5d484e85119a3da0";s:7:""78349"";s:32:"b2f4d934b8afe1c6d601df129f839322";s:13:""st-porquier"";s:32:"4f9cd7d551ea5f6145781cf46d186558";s:4:""82"";s:32:"529dc3167ec59f39515d9d111167e7e4";s:7:""82171"";s:32:"dabc341e4ace94c4b13082402b11562f";s:14:""champvans-70"";s:32:"be7175f45c182640c54295ffb5040c51";s:4:""70"";s:32:"19c1fda105189d056d96f90a3af57dfa";s:7:""70125"";s:32:"efad87c4673e925a7e89958ae720956b";s:7:""pavie"";s:32:"8789547c05bfa02798ab3128eea30e2d";s:4:""32"";s:32:"6b308945e4df6f15f956b24343642385";s:7:""32307"";s:32:"8e0aaefb30b9921fb01bd5edf3e0c37a";s:8:""onnion"";s:32:"a1ac42450bd1111d8370fb8428a1ad1c";s:4:""74"";s:32:"c556b4cba434ffda00b1b39065db0743";s:7:""74205"";s:32:"05ddbad04f2ead81b660bdad3a35fb98";s:15:""roquebilliere"";s:32:"d900f621563ddb05722e6a6cb972d634";s:7:""06103"";s:32:"675421fdec7e6e95457cdf24afb02fc4";s:13:""rougegoutte"";s:32:"b6554ae489225685bf271d1d2ff0eb20";s:4:""90"";s:32:"77870d61c7270311a9246b329d8083f1";s:7:""90088"";s:32:"c53ee75b1f0aa448692f7f5df4fefff6";s:19:""gevrey-chambertin"";s:32:"4941b9fb09281563de4f0b558e45bbf4";s:7:""21295"";s:32:"bbdddc1181d966bce8bef325d9e40949";s:19:""st-michel-d-euzet"";s:32:"aae25e7317a2c0ff61ddebac827b053f";s:4:""30"";s:32:"208dc453c464e4580d555aa3f6128070";s:7:""30287"";s:32:"201cdce86db51a4afaee6fc1e69dd68a";s:14:""montchevrier"";s:32:"baae300ee34d04d5bf23974b23f101e4";s:4:""36"";s:32:"9103bd5d3511874711722f4da9b9e891";s:7:""36126"";s:32:"d524967d3bb320fe3ee190c187e8a011";s:15:""st-nazaire-30"";s:32:"d580c16771379c7cfd991471db262c63";s:7:""30288"";s:32:"cbf8d8fca33aa84cef057e64477a098f";s:15:""paizay-le-sec"";s:32:"9bde475ccee1d083a96a0b2f0371328c";s:7:""86187"";s:32:"44d18e6797fdf831f07d930b7f11b39c";s:13:""st-clair-07"";s:32:"cee9bf0655d80138a3fa6472cb0e527b";s:7:""07225"";s:32:"fcf89665b73fc67786aeead09d51fad0";s:13:""fos-sur-mer"";s:32:"466def362e06a59d64628667453ef35d";s:7:""13039"";s:32:"2c338433acabcd715652d887232e27c1";s:7:""drain"";s:32:"acfdd912be647bfb5468f663ea2fc696";s:4:""49"";s:32:"ec67caedc9a1b95bc6b31e40185b94ea";s:7:""49126"";s:32:"995f3933f6bee0eb74886f5edf43d433";s:19:""buire-sur-l-ancre"";s:32:"630617fdb0bf0dc3c88c42b6effdb583";s:4:""80"";s:32:"ff3999c3f4d125779df6407123beac81";s:7:""80151"";s:32:"d5f321a3f986332c9791145bf08a512f";s:7:""yvrac"";s:32:"7fba278df5e405b47ffb87433a2039a7";s:4:""33"";s:32:"364683e418f1604ba46a3ff7d2883878";s:7:""33554"";s:32:"75b9068f5dcf167aca16350b79dc2273";s:9:""divajeu"";s:32:"f0d21440ff5a65c3630b99a2c8335405";s:4:""26"";s:32:"82ae10a6df82fc3218ed48b0e1e45779";s:7:""26115"";s:32:"6d0e9d1c605c093a510b8babccf512a6";s:13:""cravenceres"";s:32:"de9c0d7cfb1ed444b897ef4574b3f0fd";s:7:""32113"";s:32:"ac809f6ef0c26b5c7a99aee9ceb5aaf3";s:21:""beaumotte-aubertans"";s:32:"2b0a1af3ff0d6238431f7fedeaa0bf41";s:7:""70059"";s:32:"7cddf756b81a1b0a4f2e4847497e7fc8";s:10:""clamerey"";s:32:"3cbc200b0b1894b4ed70a10c31b05872";s:7:""21177"";s:32:"c210cfcc441e479e99e5bb1f0b71ec1b";s:7:""marne"";s:32:"fb0c95e5a4ae5ab2d57fcb2a0f42332c";s:7:""44090"";s:32:"26c00b48adf30cb149cf9c375ca3c00a";s:8:""clessy"";s:32:"b72f647a069067159e54870c48a9dde9";s:4:""71"";s:32:"4b998f30b79eae5586e09fb4af80bbf8";s:7:""71136"";s:32:"83e5360661e656e470dbe2ef4abec014";s:19:""st-paul-de-tartas"";s:32:"7142166d1e9021c22af48d53bc32d9e5";s:4:""43"";s:32:"e6c3fd591fe4208745a1d933c50f92c8";s:7:""43215"";s:32:"4c9bf475a2b3811e1dd655cd67873064";s:9:""bacouel"";s:32:"58561c13046d6fbdebc2164e7321ad55";s:7:""60039"";s:32:"facb9d8f0944252eaab4fc2c163bfc5f";s:11:""montsalvy"";s:32:"d1582db820a0fcfeecedba5685e3da9d";s:4:""15"";s:32:"098959000d0486c33bc163dd1857716d";s:7:""15134"";s:32:"66cbae171a5a75c1d12d16c0abc2f7bc";s:10:""st-aunes"";s:32:"8bf992615405f558da6ca57b999ae4d2";s:7:""34240"";s:32:"f59bea546129b051d952b3d411be34d8";s:9:""astugue"";s:32:"536752ea892f8bcc379795e80ead2ffb";s:4:""65"";s:32:"3d49cd8e152f325f0dd0eace9d167760";s:7:""65043"";s:32:"742206641ced543abfaa5f7845cd5244";s:18:""laval-sur-luzege"";s:32:"9c77b91b7b5e02e32d3fb96387090412";s:7:""19111"";s:32:"1811365b580e9394351cb857245fa7bc";s:19:""arraute-charritte"";s:32:"abed2f95e3e5b2885ff6f578794a26d8";s:4:""64"";s:32:"87cbad5cd7865abe5a13a95d57bb6153";s:7:""64051"";s:32:"a44e68ede17230c42336c5698e32e34f";s:14:""st-privat-19"";s:32:"5250f9b06cd2d1027928e838246f282a";s:7:""19237"";s:32:"5d49aebbf47b9039e1c88bd7f73dd3be";s:8:""couret"";s:32:"890879197e529423b22324810d486764";s:7:""31155"";s:32:"99ade9c258b0314f21b9b2d3466c1f8d";s:10:""cazarilh"";s:32:"7d0accdf099e9b02e3d030e7a7bb2666";s:7:""65139"";s:32:"c8770a038f880fd0398f25672be0279c";s:10:""castetis"";s:32:"1ada4026deb4e46e2c8ce76eebc913b6";s:7:""64177"";s:32:"ae87024dd66bf980a3c29a38cd3fd89c";s:9:""hurigny"";s:32:"a8f7764a3314f9dd69e40aa2cfe54abb";s:7:""71235"";s:32:"6b66fa91903c9ede78c012293004fb85";s:7:""lavit"";s:32:"9f4a917394a2e55ee5b9037b72482c84";s:7:""82097"";s:32:"6762f1e9eeec151108d5bcc5076fbef4";s:8:""yvoire"";s:32:"144ee232547210fbf6c9883d9c8983a7";s:7:""74315"";s:32:"9a320c76c12f2d14b9f49ec222fca96a";s:8:""gumond"";s:32:"149c755e373ab3e981f80af15e7707bd";s:7:""19090"";s:32:"2b85cd1935bae734dcca70617c66addd";s:16:""beurey-bauguay"";s:32:"4b46a602e9b92d69a6bcdfe817751306";s:7:""21068"";s:32:"19bb66f781666b47004c3bdd86a10c45";s:11:""chalifert"";s:32:"0c814091063da1002aeaafcae22b575b";s:4:""77"";s:32:"aa3a2c56e4e9ecdc7fb31ed726502c95";s:7:""77075"";s:32:"f6d2c7080309ad8a1e28bb0ecec73296";s:10:""montilly"";s:32:"724b1beb283d617dd938e00092fc9084";s:4:""03"";s:32:"40d266c266c7008ac8f845a7ea4fe59d";s:7:""03184"";s:32:"40df92f4a24d3e81b467589cf8c84576";s:12:""chantonnay"";s:32:"e2a542675f70b8b5c8b0b4e1c44b3007";s:7:""85051"";s:32:"925f463b59a476f89b7c8ca9ad107862";s:12:""outarville"";s:32:"863419585dba3fce6f7399191ef29f81";s:7:""45240"";s:32:"984f871c8fdb9122c10fd7e2f12aec84";s:23:""st-etienne-la-geneste"";s:32:"f8ed962cbed3901a3530f64d7657ed19";s:7:""19200"";s:32:"da13b63da87fb795520e5d5ef7ee442c";s:8:""arette"";s:32:"0b6b4d86ed429050d2653b51ad3d657d";s:7:""64040"";s:32:"c1ff7c998a7337ffb0b9ca30a1c75d5c";s:9:""alembon"";s:32:"d6c45eaaed67620bdf39e09fc229e9ec";s:4:""62"";s:32:"6339c1eb6d93bb992f33b682b379ede1";s:7:""62020"";s:32:"15a7376292c823844d53544cd03dac77";s:6:""auby"";s:32:"6ff9b106a564fc0077e1e19f7a984073";s:4:""59"";s:32:"d0716a8a4fcd6184c6af104030bf77d1";s:7:""59028"";s:32:"9672a2ed8787406e78b748c65620ea75";s:9:""lommoye"";s:32:"5366402154e26c06f1f9211850f339fb";s:7:""78344"";s:32:"d7ffcc08943a4790bb02e81886c2edb3";s:12:""cramchaban"";s:32:"2a505d3269598f3009c52295db47a5a7";s:4:""17"";s:32:"512d3439942d8db7b9427334662c5da7";s:7:""17132"";s:32:"8c432cc47902b869aed3a25c169324b9";s:19:""st-geniez-o-merle"";s:32:"848e98984c965129721d05770d3ca56e";s:7:""19205"";s:32:"01790d676e6f2975a72a6f2ea1d1e145";s:19:""vaison-la-romaine"";s:32:"fdb204524e6231c6606712ff78ff4f79";s:4:""84"";s:32:"5cc6ffd6950bb0511b92eea5594bc829";s:7:""84137"";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"6eb4dd7015d184f5ffa3b3c365c7cbb8";s:21:"`Etablissement`.`nic`";s:32:"982c0b08471d3eb19d95d39ca5a4c90e";s:30:"`Etablissement`.`presentation`";s:32:"e755c47b00b95d0a80664a2eaea7d4e4";s:26:"`Etablissement`.`services`";s:32:"66e1a083d9c40ddbe09a2decd511e929";s:27:"`Etablissement`.`telephone`";s:32:"afee796164b525314c1b52cfaa023a8a";s:30:"`Etablissement`.`siteInternet`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"02a4d5932e057ef23859d2d66ad62328";s:29:"`Etablissement`.`horaireslun`";s:32:"823f98fbb37f74a2082edb4ae0e50bff";s:29:"`Etablissement`.`horairesmar`";s:32:"9220a275d0a1e9825b456ed738b49fab";s:29:"`Etablissement`.`horairesmer`";s:32:"60e136a46f7ff3d2ae54e97d9bcb8b2a";s:29:"`Etablissement`.`horairesjeu`";s:32:"5254a6c5b8c5abc918df881507dc2739";s:29:"`Etablissement`.`horairesven`";s:32:"b97a8a6cd1a7e7eaeeb6dbbf8f55cbd8";s:29:"`Etablissement`.`horairessam`";s:32:"fd7af57afe67e203874bf15fd116c5ed";s:29:"`Etablissement`.`horairesdim`";s:32:"91646e4d20d4df23fbc7f1c1f12e52d5";s:46:"`Etablissement`.`statutDiffusionEtablissement`";s:32:"7a67bc6c84d0e933845655206bd57299";s:47:"`Etablissement`.`trancheEffectifsEtablissement`";s:32:"4cca03bc736d240682f31bc479175fc6";s:45:"`Etablissement`.`anneeEffectifsEtablissement`";s:32:"b5e0acc5fb74973c97b6fa65ee7ab9b7";s:64:"`Etablissement`.`activitePrincipaleRegistreMetiersEtablissement`";s:32:"609d2a146130d598c4995a161aaa9c69";s:52:"`Etablissement`.`dateDernierTraitementEtablissement`";s:32:"f9c94f79342395a7366e95f8dd71212f";s:36:"`Etablissement`.`etablissementSiege`";s:32:"3cbd36ac216dc89e29a18b1a09420d35";s:46:"`Etablissement`.`etatAdministratifUniteLegale`";s:32:"2abf0d6375fdc1490cc75ec9107f8035";s:44:"`Etablissement`.`statutDiffusionUniteLegale`";s:32:"35c0dc49a58aeb81ed994edc8288eaeb";s:40:"`Etablissement`.`unitePurgeeUniteLegale`";s:32:"602d262ec1e0468544d0d74cadf9ac5f";s:41:"`Etablissement`.`dateCreationUniteLegale`";s:32:"3c1bb8be6c41adf6e2af25a9e30a2553";s:47:"`Etablissement`.`categorieJuridiqueUniteLegale`";s:32:"16bbebe410db7ec7764f30f52c59b72d";s:34:"`Etablissement`.`sigleUniteLegale`";s:32:"8172380beca10b657cc6f4bb921a6af3";s:49:"`Etablissement`.`denominationUsuelle1UniteLegale`";s:32:"f361f067350959b3718ab4af57cf7f04";s:49:"`Etablissement`.`denominationUsuelle2UniteLegale`";s:32:"9d1db6de9a316fdc5904f44404fdcec4";s:49:"`Etablissement`.`denominationUsuelle3UniteLegale`";s:32:"1340637afb3ff9ec0b7fb134a88af827";s:33:"`Etablissement`.`sexeUniteLegale`";s:32:"a01c6c637251b20e4de3add569b0a94d";s:37:"`Etablissement`.`nomUsageUniteLegale`";s:32:"281d62a3f604db57876fefd825282fbb";s:36:"`Etablissement`.`prenom2UniteLegale`";s:32:"91382a18baf0d948db0e751ed1189ccc";s:36:"`Etablissement`.`prenom3UniteLegale`";s:32:"d8ca101fdc013efca011a2fcc2113287";s:36:"`Etablissement`.`prenom4UniteLegale`";s:32:"e72a1bfa2789a2b2c61e0cafbb6e07ae";s:40:"`Etablissement`.`prenomUsuelUniteLegale`";s:32:"1165ed12e49da8990a00fcce893216cb";s:39:"`Etablissement`.`pseudonymeUniteLegale`";s:32:"39ca3bfa482d6f040374fea0f28c59e6";s:47:"`Etablissement`.`activitePrincipaleUniteLegale`";s:32:"22e1d764d2a7b79d9a5324cc3d76c042";s:59:"`Etablissement`.`nomenclatureActivitePrincipaleUniteLegale`";s:32:"407e709042920f11d6919aa965148c51";s:51:"`Etablissement`.`identifiantAssociationUniteLegale`";s:32:"f1bb9f988a3023b82d1d5ccb7c62e859";s:53:"`Etablissement`.`economieSocialeSolidaireUniteLegale`";s:32:"7ee4fede5fffb621bc5751c0d5736b06";s:47:"`Etablissement`.`caractereEmployeurUniteLegale`";s:32:"aad5b19747ad6f1965cc70f960d52829";s:45:"`Etablissement`.`trancheEffectifsUniteLegale`";s:32:"a1db1f2da63d817d6f1efafa5dcde392";s:43:"`Etablissement`.`anneeEffectifsUniteLegale`";s:32:"416c5a0d2dbefea27aa5e827fd66fb59";s:37:"`Etablissement`.`nicSiegeUniteLegale`";s:32:"991b30e7103faa2b0e6255947f2b2cc2";s:50:"`Etablissement`.`dateDernierTraitementUniteLegale`";s:32:"b13f5382b8909d0347eb133690ae2628";s:37:"`Etablissement`.`categorieEntreprise`";s:32:"d78772155310451e2b65e5512676d363";s:42:"`Etablissement`.`anneeCategorieEntreprise`";s:32:"aefb3de8acd255b5bb5299fbbffc68ee";s:48:"`Etablissement`.`complementAdresseEtablissement`";s:32:"99cbf40c24566faadf1ac4d5af7fbd2e";s:47:"`Etablissement`.`indiceRepetitionEtablissement`";s:32:"c7ae1c9d05f52f464bc8d6f1bbec1bbc";s:53:"`Etablissement`.`libelleCommuneEtrangerEtablissement`";s:32:"4e645885d33d4c6f1626169cc2e5a7a4";s:51:"`Etablissement`.`distributionSpecialeEtablissement`";s:32:"a837d761825cff5305e1c7f1c5e1143b";s:43:"`Etablissement`.`codeCommuneEtablissement2`";s:32:"e8e7a1c4580e17a90a623f1d676a54ed";s:40:"`Etablissement`.`codeCedexEtablissement`";s:32:"90b3f54fd7011094ea994244ed00f840";s:43:"`Etablissement`.`libelleCedexEtablissement`";s:32:"7b3fb100ebb134bf6669f5872183faa6";s:47:"`Etablissement`.`codePaysEtrangerEtablissement`";s:32:"9a591ece696d1465d7ee0fa49b856a7b";s:50:"`Etablissement`.`libellePaysEtrangerEtablissement`";s:32:"b8caf8150f9b5be24db690c319617977";s:49:"`Etablissement`.`complementAdresse2Etablissement`";s:32:"2548fdf0bd24ca7bd3fca4cf20d85833";s:42:"`Etablissement`.`numeroVoie2Etablissement`";s:32:"57ded096db335b8e79eeb4c225699cfb";s:48:"`Etablissement`.`indiceRepetition2Etablissement`";s:32:"3d11687fa0b88b9f7cac3c3161faf921";s:40:"`Etablissement`.`typeVoie2Etablissement`";s:32:"6a0314f1c329279c7552201453426cc0";s:43:"`Etablissement`.`libelleVoie2Etablissement`";s:32:"57750bcb7e82144af44f2cf500c99bbf";s:42:"`Etablissement`.`codePostal2Etablissement`";s:32:"27fb5d6abb1ee1979b27cfa0e15cc123";s:46:"`Etablissement`.`libelleCommune2Etablissement`";s:32:"69744e1290be0f92d195d834a20504a1";s:54:"`Etablissement`.`libelleCommuneEtranger2Etablissement`";s:32:"81a311c7fd8bb764f7017358166bb1b9";s:52:"`Etablissement`.`distributionSpeciale2Etablissement`";s:32:"1b3dd96f644e357c4bc40851f683a2c1";s:43:"`Etablissement`.`codeCommune2Etablissement`";s:32:"dac3173c50e1da9dead581dc8714aa20";s:41:"`Etablissement`.`codeCedex2Etablissement`";s:32:"9c81fccc3255f0742cf83f16a3eff67a";s:44:"`Etablissement`.`libelleCedex2Etablissement`";s:32:"db090b58ef534748d9d76d2daa34213c";s:48:"`Etablissement`.`codePaysEtranger2Etablissement`";s:32:"de3bc155a41faa2d0afc6a07df061aaf";s:51:"`Etablissement`.`libellePaysEtranger2Etablissement`";s:32:"fcd3b5a8a5cc19a9aa3917fa000aeadc";s:48:"`Etablissement`.`etatAdministratifEtablissement`";s:32:"be0bf932ad08be1a54f9ed1c6a404f41";s:40:"`Etablissement`.`enseigne1Etablissement`";s:32:"2942361e1313f4efc0ee323d275f5038";s:40:"`Etablissement`.`enseigne2Etablissement`";s:32:"a33bbb06cfd9104bfb2d365d839191d9";s:40:"`Etablissement`.`enseigne3Etablissement`";s:32:"cbea822955397739af5822498976f656";s:50:"`Etablissement`.`denominationUsuelleEtablissement`";s:32:"ad7240c6819361336ad79d787d656f1d";s:49:"`Etablissement`.`activitePrincipaleEtablissement`";s:32:"7b4df81ea615348a74bcc9a9e3fdcfe0";s:61:"`Etablissement`.`nomenclatureActivitePrincipaleEtablissement`";s:32:"652deaf192f45232fac0312631b2ebe8";s:49:"`Etablissement`.`caractereEmployeurEtablissement`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"1cf5402c49c35e2200f008c4fbb3941c";s:12:""montbouton"";s:32:"2fb9d9f57915aa856370121bd649f0cb";s:7:""90070"";s:32:"91dc29f88357670ec6d3c7159094f0a8";s:9:""sansais"";s:32:"7d5ba110e1322d57ed023c424b1e1caa";s:4:""79"";s:32:"21bef66c221d70e2414c74913a5a3ac3";s:7:""79304"";s:32:"147dbc22a007070ae3bda9f0cf5d4036";s:8:""bilieu"";s:32:"85564a87d3132cd859d5d128ea1ff0ab";s:7:""38043"";s:32:"45e74b2a06eaad55b357e7e4633ec09c";s:10:""captieux"";s:32:"2bf08abc75f0204e9fbd4a56cc58f00f";s:7:""33095"";s:32:"ac3871ecc179d0430db6f3c5d9126880";s:12:""yssingeaux"";s:32:"e58925828a58c668c04230177b1aff16";s:7:""43268"";s:32:"7b8b39079fa573c9f544d38354d88384";s:14:""rochechinard"";s:32:"3428499d9a55273120112adcc0bf4c2e";s:7:""26270"";s:32:"d57e6fe3ba51a7f5c6f2713116a0f243";s:8:""huille"";s:32:"efd9cb6d1069263bbc3e11ca9a43ff07";s:7:""49159"";s:32:"ecfdec0f5d9b920be4117e7600cb84f2";s:13:""gonfreville"";s:32:"0f970b5fe98c06a4d54c1bebf0a509d7";s:4:""50"";s:32:"603be8838006e3442b1d7c5c3def8332";s:7:""50208"";s:32:"2a34974f77422d3dec826f081e0807a6";s:22:""roque-ste-marguerite"";s:32:"52a8c6ab4f69e402f37349a5fb5b2a73";s:4:""12"";s:32:"9a2f74084972ae5888cdbd2e4a16d1b8";s:7:""12204"";s:32:"49a5e019e7fcd14083b267b3a5111b39";s:9:""chantes"";s:32:"9583462f09db9e00e9279e4061ef3599";s:7:""70127"";s:32:"0bf2279d109379ccf27e9da72190d319";s:13:""chambretaud"";s:32:"0389514df65b98a8743be19a0b207a55";s:7:""85048"";s:32:"67858454070923b806dd94d43471c559";s:18:""chalon-sur-saone"";s:32:"982751f4c3c27157b05b2d5e9218696e";s:7:""71076"";s:32:"f0dc1fa5136c722777382cdf3f30915a";s:16:""aix-la-fayette"";s:32:"47070379839a9e6a864391f70646687a";s:4:""63"";s:32:"027b9ca0c76d1a27bebf367be8f0c7e0";s:7:""63002"";s:32:"223e474e6457dd946d6fcd7681410239";s:9:""soursac"";s:32:"60ae2368a95930c61d04e3eb178e456a";s:7:""19264"";s:32:"7f1c4e54a4df11e16108d3c0dfd7fad4";s:15:""heutregiville"";s:32:"ec36111db6bf02725423c1fcf0334dfa";s:7:""51293"";s:32:"2a71a8e8727a5a2f950225aa38180304";s:17:""larroque-toirac"";s:32:"13d2692796a894010e322f7ce65ae7eb";s:4:""46"";s:32:"5fd8fac440d7eff7d4c2114192bfcc89";s:7:""46157"";s:32:"3c9378944c8a7d9b40c5576f6921bc81";s:9:""charols"";s:32:"ebc9a1f8af1935ed58337cadde50ea42";s:7:""26078"";s:32:"d782616c8039348d54b63c2d8f40d417";s:12:""esclauzels"";s:32:"b7aeabab9643dd58c2bd2cb6fc1f5cc4";s:7:""46092"";s:32:"8229cb5724860d884210787335549a3f";s:17:""chenille-change"";s:32:"3ad0d6ea16bfd5eb48a9b6af0f8f7139";s:7:""49095"";s:32:"2c9b82507efbbeea031cd5be04bc3413";s:12:""laqueuille"";s:32:"f49b6748f4a1ae8b2e907e87ad13c2f8";s:7:""63189"";s:32:"035ba9514363dacc1275b29fee08309a";s:10:""flaugnac"";s:32:"76501f172c3fb79ac48169d3438523ff";s:7:""46103"";s:32:"e87a81140e2de1094995910dbd145551";s:13:""montreal-89"";s:32:"653ca117bb9ff1b745bbd379e01d9d19";s:7:""89267"";s:32:"4aa9451b8e861dd97b59151fa5782791";s:9:""chivres"";s:32:"0b902499687702bb0b29e81aa9408948";s:7:""21172"";s:32:"c32d3cb981df3b82a5d7f626dd71c3ba";s:23:""bonningues-les-calais"";s:32:"ccd512561803f8b68d993d236af62c86";s:7:""62156"";s:32:"8e03062876f4d256a7cecf59f74eb2b2";s:13:""st-angel-19"";s:32:"65f7aeddc3986dfb86d395b04fb42c70";s:7:""19180"";s:32:"96fce050d703873136743c2aacc4995a";s:10:""loperhet"";s:32:"13108ecd230ac992c904d2febc925703";s:4:""29"";s:32:"90b837ace864aaf4450f2e9d2083fc8d";s:7:""29140"";s:32:"b8ef39d667732dd9140abaa41b5fe74e";s:7:""noves"";s:32:"8677492cbc01d0e7ede3b3141d74738c";s:7:""13066"";s:32:"85b13c370a3167d0c0d755e452e70e31";s:10:""bagneaux"";s:32:"158677ed3118f3b841e01d2fe093bcc6";s:7:""89027"";s:32:"ce2ea84155b0feb4b0aac53c580d39a8";s:9:""wissous"";s:32:"99f486ac87e748598b211a14775326bb";s:4:""91"";s:32:"d15510c9edadb53640d642d7c60e166f";s:7:""91689"";s:32:"304a3434b4cad18ad349d62cddceffe4";s:14:""st-julien-34"";s:32:"bd88e0d83a324e095ba183c83c582e34";s:7:""34271"";s:32:"75006363b1157643c4d7988632d4237e";s:7:""laizy"";s:32:"649d298cf3b59121a0f5d3745d4f9a09";s:7:""71251"";s:32:"cb0ccfe5e8da2da0c3ae2a416b0feffe";s:7:""juzes"";s:32:"1d3e8f1ada9f355d89aa21f9e9cdf53c";s:7:""31243"";}s:6:"fields";a:273:{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:"a02f2d6153545b0b8e850b121e7f1e1d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.66667- 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:"5f28180f7c34d64e5a49db5f54f983d7";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.66667- 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:"b5855de762bbb064d659f724df5d48c7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((49.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.75*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:"e0c56b336572b892b67f507f4fd70be3";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((49.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.75*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:"1c3c6ca3f42429be1bc6421c4ae73462";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((47.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b0b6cc3a93f7a8955b8b49f0b488a388";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:200:"(((acos(sin((47.8667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.8667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.63333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"48d3148f6f0ba2fd28ce5cfeda417d2d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.61667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"315460df1db179a764d9a4318a663cd4";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.5333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.61667- 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:"77dd3cd0ef6de5ab7d0685d3169bfdc8";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((2.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((2.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((48.9333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"24a845026398b6232a50a39e6a4d86cf";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8b915e9f5c660e3cbed4e794cbb79217";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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.55- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d45aa8734bc7fde4c9a901c9311f775f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"502d6186909821c113b2be790a282cce";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.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8bf25680c05795b9939d71e587a6230a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((42.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"22df5260b5d48b2b4e9427f8d024848a";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:200:"(((acos(sin((42.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.683333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ffcdd630a41af05d603044e94cdb8776";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6d70ab85905487957c1d598000372bfa";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.1833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.86667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5d77605acc12a0ea5e69727bbcfaedb1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f6b03cd0839d1d8ebada64d24fac390f";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"21dd968d912e66d284e446c4ad311769";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*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:"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:"3827a0fd084c7bf9d663f11801218ec0";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*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:"fa9ca5c8bf682abcd6e5503e81aac9f9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*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:"f500a84aac730e36b046cffa9fdd3160";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.3167*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:"d6230d2b30759283e7184f6cf2dec9e2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2562*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2562*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83195- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"44590adb4473cf85d4269939350287b8";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.2562*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2562*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.83195- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9527277b9324d2211343ff40bf76a137";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.6667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e297f97f53b2f50b9ad6939c7a7f85c0";a:1:{i:0;s:18:"`Departement`.`id`";}s:32:"cfcb07753438195b57aabd45bb358ebe";a:15:{i:0;s:18:"`Departement`.`id`";i:1;s:20:"`Departement`.`code`";i:2;s:19:"`Departement`.`nom`";i:3;s:29:"`Departement`.`nom_uppercase`";i:4;s:20:"`Departement`.`slug`";i:5;s:27:"`Departement`.`nom_soundex`";i:6;s:25:"`Departement`.`region_id`";i:7;s:20:"`Departement`.`view`";i:8;s:28:"`Departement`.`presentation`";i:9;s:20:"`Departement`.`img1`";i:10;s:20:"`Departement`.`img2`";i:11;s:20:"`Departement`.`img3`";i:12;s:25:"`Departement`.`centreDep`";i:13;s:22:"`Departement`.`geoDep`";i:14;s:26:"`Departement`.`population`";}s:32:"b9c2e13f67bdcc2d8131af7642f76123";a:4:{i:0;s:13:"`Ville`.`nom`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`lat`";i:3;s:13:"`Ville`.`lng`";}s:32:"94204132cf814e28e78d395f8e3a7c6d";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"386a444cea1bbfe78bc8a94275486a29";a:1:{i:0;s:25:"`Departement`.`region_id`";}s:32:"e510bd77f60485f19ba962387dfcd845";a:10:{i:0;s:10:"`Pub`.`id`";i:1;s:13:"`Pub`.`title`";i:2;s:12:"`Pub`.`link`";i:3;s:11:"`Pub`.`lat`";i:4;s:15:"`Pub`.`adresse`";i:5;s:11:"`Pub`.`lng`";i:6;s:11:"`Pub`.`img`";i:7;s:14:"`Pub`.`height`";i:8;s:12:"`Pub`.`view`";i:9;s:16:"`Pub`.`view_max`";}s:32:"655df8533d44b45414d275b3295949ac";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"760a55d7afd6075b75926fd0efddef0c";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.2667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.416667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3ff8491cb6cd241011333aeec9334794";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*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:"75c017f5244f17aaaf43cd0331ecc63f";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.0833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.0833*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:"e3b06bfe4c6bfc74612f78fd27520a8e";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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"87a16b483cf9aeeccfd2ddc862f3e5b0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5167*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:"3ab86cb5b1583655a0fa6227fe9f461f";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.5167*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:"ae91b0827e1bdfabbfdf5120e018b332";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4559*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4559*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.86695- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"31c6165b20a12e8d1bc7204c2c110c69";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.4559*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.4559*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.86695- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"551b8023e26b7b32d782bb1cc7e752b1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*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:"11d5ece09d83e0314423b417abc44304";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.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.3167*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:"ed87c09e9d5ce14d13412c799ead0468";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ce78e18605cb551799502c67e946cc21";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((46*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3791dc000983fa64ff3bfe955920d742";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.8464*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8464*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.38571- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4a8d0e236ca16e31707153e4c64a4465";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.8624*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8624*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36093- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fc15a99eed5821421fcc2beb6e402a0d";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.8769*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8769*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33735- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a175deb6a6869577abb97d900fe25b76";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"544ef88aae6defaa625f2a2b60d5d650";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.3*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.51667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9b17b78c24dbe76dfcb415ba82c72530";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.633333- 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:"801a1ce277f873e50db9767f20b047f5";a:4:{i:0;s:11:"`Comment`.*";i:1;s:17:"`Etablissement`.*";i:2;s:27:"ROUND(AVG(note)) as moyenne";i:3;s:21:"COUNT(*) as countNote";}s:32:"059bb993dabb7430ddf8501069124227";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0a05b7e5ea6d36cf9c0d0ae66cca6fdc";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((46.8333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.8333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7b512f7bcf53758336099c508af1aa47";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e7c35086edb5e2b302c94acf3e2c58d";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:190:"(((acos(sin((48*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.58333- 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:"7acb95dd0d77292bcb0212d30722d688";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"567f32fdc4c2bd3b2a9ed685dce2f109";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((43.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.7167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.31667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5326644b9bab518070fbe3d7a0a4fd59";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"58fea468c9d7a7be3b73037326944db1";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"08b323833a0a914eb88adbea9a77c80a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.365*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.365*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.394723- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c600c6be86bc130070abb3bd540b4792";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.365*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.365*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.394723- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b3d9f341a4dd62d7991fb25df6d61fff";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.8587*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8587*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.37834- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f43ef7aabf6cf21f5e9c54b95dac930c";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.8887*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8887*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.34366- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0ba86dfbf8bdc650df112168a8dfd7c0";a:4:{i:0;s:14:"`Agregat`.`id`";i:1;s:16:"`Agregat`.`slug`";i:2;s:15:"`Agregat`.`lib`";i:3;s:8:"`Post`.*";}s:32:"ab0e3a52568b349c96f2a502f3a84c46";a:3:{i:0;s:14:"`Keyword`.`id`";i:1;s:15:"`Keyword`.`lib`";i:2;s:16:"`Keyword`.`slug`";}s:32:"ed948e0b2975fff89c36b5e5432f3dee";a:3:{i:0;s:11:"`Post`.`id`";i:1;s:14:"`Post`.`title`";i:2;s:13:"`Post`.`slug`";}s:32:"485ccfd14d9aae42544464ffa3972023";a:3:{i:0;s:14:"`Keyword`.`id`";i:1;s:15:"`Keyword`.`lib`";i:2;s:16:"`Keyword`.`slug`";}s:32:"fb45efb61adf01330efa2475fbc21160";a:12:{i:0;s:11:"`Post`.`id`";i:1;s:14:"`Post`.`title`";i:2;s:13:"`Post`.`slug`";i:3;s:15:"`Post`.`resume`";i:4;s:12:"`Post`.`img`";i:5;s:16:"`Post`.`content`";i:6;s:19:"`Post`.`agregat_id`";i:7;s:17:"`Post`.`keywords`";i:8;s:19:"`Post`.`marronnier`";i:9;s:16:"`Post`.`created`";i:10;s:16:"`Post`.`modifed`";i:11;s:20:"`Post`.`publication`";}s:32:"e59b6aa08c7605744a28f004ca7aa08e";a:3:{i:0;s:14:"`Agregat`.`id`";i:1;s:16:"`Agregat`.`slug`";i:2;s:15:"`Agregat`.`lib`";}s:32:"21c4498b7a0e61f99521f33d8542797b";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.8859*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8859*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.30975- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9c68d7b6a19d667234e71e78b86c3a2c";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.8589*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8589*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.32004- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"56af0a7530d2a0d9929af0d986164187";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ce688b99fb129e0b0ae8db52982d3a54";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.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"70e1eaeeade01d638ab3754525739bce";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e1cef358a9dcb2670453c675417c11e2";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.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"dea7831d9ba9adcd91064121bb386f15";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e48e6893aa5427d418dace73277ee5e4";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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a7300e6113d9db72f20b0af225616718";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((44*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9ba6e4a6ef4e911a924a040e462e956d";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((44*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a9e53d2a5304ed7c69bbcbb18e60287f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3937*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3937*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.57612- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"88bd43429685c72eb79a0a0718774f71";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.3937*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3937*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.57612- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0c6baf29c8797769172d158a271d3e02";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6167*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:"81307d519e8459cf25a028e7abc95e8a";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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6167*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:"7e36182e3439978163079c45f095ae99";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*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:"8e0c60c30274a021ff87838a05fda507";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.1833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1833*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:"d233df47cdb4f9f544fe53540299974b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e628b8bcfd0cdc73895262f0f12526ef";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.0167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.3- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"72b50e4df393ae7b533673b2c08a0277";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"05a21e8c7ee8dc88b1261b0966a0faba";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.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.85- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e18d1488db82a8d93a2f8ef76850510d";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.8293*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8293*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.36022- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7644644e253bff9366ab418f26bc339b";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((48.872*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.872*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.31187- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"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:"53228be5a71865d5fb6f861f6e43c9fa";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e5e9a88431328a358194442d8e78a6d9";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b318ebd340d8aeccc740e94f9a412173";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e319e67bd76afb92a2fd35c5b1a203e9";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.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.53333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8efd7edb8dff3a7abc487d8bc8dd6f2e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e2d86602aab802117964e4c3b8af165a";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((46.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.75- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"62dc829ad33648cc9c22c56c492820b4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1978*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1978*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.62473- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6df5cc28259f1cd61e76d3d92522178d";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.1978*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.1978*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.62473- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"07f379ccead92db18865af7b910e257a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((46.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2c6da175cd6205f77723c726a88a4f01";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.5833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.5833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.783333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"676b67b5492c3680652e0edb6f288887";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e95c63a91bf0f9c7b42833ea062223e4";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.2833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.68333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"32ae203470869b07671cdab4bfacd011";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26435e64e1a5b9773c2a34ba3324b144";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.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.95- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"84b61767f0b1196bd353453b2b1debae";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((43.6*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.43333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"ad57ed9c64f20acaf9ea74eeca78c72f";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.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9d3ff780b39a6bcc5cbdcaeaabbfd551";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*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:"82bd36ff888063425be4f5496cddb9ef";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.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.35*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:"e45ae2caeba8d2fafbe71690129fa477";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"85ac647dd4ad3e7f3a05d03419604911";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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"be2471133bed7bb491b133b04c5c6b68";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.466667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2614b4fbf149836706070da9b0dca8cb";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.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.466667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c8f49b3fa9b1eacbed727c1027c0bed3";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.7167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.7167*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:"ac1960de12880f3d472ed778eaf62ec8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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(((5.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b4db1686650610458b54f7a42c22384";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(((5.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"caca94bbf06ddf251e3f828d711f62ce";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"496f0a2e7e54ce8244146c2b8cfa7b92";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.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cf40f9f62f6b6a6e63d975ae2decd3cd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.42*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.42*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.17917- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d564075c92b85688c256311e8348ddd8";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.42*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.42*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.17917- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"74349d195c873dbf3739c52164d0a253";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3833*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:"42414455c1907c2a7c98c8740aed538a";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.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3833*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:"004f495f2df463886065db2f2a5a1fa7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((47*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.73333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"caee4208a5d2fb882fe7412d927c436c";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:190:"(((acos(sin((47*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.73333- 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:"5c320106904dbedf14534c5263818d5e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((46.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5ddfa6a2f8efd83bbe9057cc9c924672";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:195:"(((acos(sin((46.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.08333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"91c9d388a2e547dfa18f3a3f4a97386d";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.8502*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8502*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.33389- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a39c8a486017b4607137f68bcc3ad4cc";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((48.8451*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8451*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.3492- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d172a55717b1ae7341ea02fb238ca8a8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*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:"f4110969c0cf51e4bc880a6f6c1fbdac";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((44.8*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.8*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:"becb08732a237302f4702aabbd9fd48d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3fbb67aabd6493bf6a5add8d6648e18f";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.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.38333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bb2b2dbe90a85fb245194dffb0bd13a9";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:189:"(((acos(sin((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"88613683ea8369262344a2a281c89ce9";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((44.7*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.7*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26afc5c94abeeccfc022a789bacc0625";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((43.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9267972b48531df77db6edd979273519";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((43.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.96667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"06c912e416b73f9819a6ee044e56515a";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.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.71667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1fba3cd8c4ce72d94c5b1995e11640df";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((43.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"93c0d13be58c007b85e8dae8b7386a79";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((43.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.066667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5554db5a5205414c2e52ad7c2c98d290";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c4a4ceb3332b8daf265ebfcd811a1e52";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.15- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"02eced82c6e5d59c8052d181a54b4933";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:190:"(((acos(sin((43.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f1a7e9baa49f746bb1318d20346ea998";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:190:"(((acos(sin((43.4*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-1.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7e4862c065c00a0abac7c5092cca3ded";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f13606e13ef047e7e7442c49ed91ac61";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.1333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.1333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"46eab2cdb9283ee41743a2a31f6e8ea4";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.816667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b03e35a42082ad7debf8d2634e78e36a";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.05*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.05*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.816667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"7e7e372f628c6dfb670414768b4fd4d4";a:7:{i:0;s:17:"`Etablissement`.*";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:197:"(((acos(sin((48.856*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.856*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.31339- 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:"cf3a54086eb3dcd8bd2a43503b6bfad1";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.8676*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8676*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.34376- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e38598039e6f2150c979b80e43920e57";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9667*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:"65b0ad9859d8d5965c68fcfa20ac8c79";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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((42.9667*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:"1b5d7050e07b9cebab8a57cb86e73765";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"8d7007e8cc4b4da7358dfcb09362bd39";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.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4d7ec50fe51054d3f57e9729b6bc9c9e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((46.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*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:"3631ff35ac8223694521fd2df261fc3f";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((46.35*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.35*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:"cb5c47ba32c9dffacd301ce278cc58c6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.916667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d54da9545ebd641957f535a3b554f964";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.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.916667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"cf49dec092d1af98127340b8555eefe0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e3438bacd6e1a7cca5be09aa5f2867de";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.3667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.3667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.33333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0607abf7d2bed80f2012553759ab0450";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7aadfea40a5e36b23001b4c07c8918c";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((45.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.2167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.98333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"73c418a96d4d0b0aff6ca062b2999f1a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2333*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:"257ea9d6bba682939b82fe5610d93986";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.2333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.2333*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:"0f4f0c07964e92182a59d7b1aaf6ee75";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"aa6c00ab943c4965c4334e4073cd4637";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:199:"(((acos(sin((48.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.76667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5efe6b2ad9e1383786740b1618a27c83";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((46.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f90cf489526969f333043c939270e130";a:14:{i:0;s:20:"`Etablissement`.`id`";i:1;s:22:"`Etablissement`.`slug`";i:2;s:43:"`Etablissement`.`dateCreationEtablissement`";i:3;s:23:"`Etablissement`.`siret`";i:4;s:32:"`Etablissement`.`nomUniteLegale`";i:5;s:36:"`Etablissement`.`prenom1UniteLegale`";i:6;s:41:"`Etablissement`.`denominationUniteLegale`";i:7;s:41:"`Etablissement`.`numeroVoieEtablissement`";i:8;s:39:"`Etablissement`.`typeVoieEtablissement`";i:9;s:42:"`Etablissement`.`libelleVoieEtablissement`";i:10;s:41:"`Etablissement`.`codePostalEtablissement`";i:11;s:45:"`Etablissement`.`libelleCommuneEtablissement`";i:12;s:9:"`Ville`.*";i:13;s:196:"(((acos(sin((46.6167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.25- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5681d8fc4e6489664495056b2e1d91b2";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((46.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6833*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:"f456b162939b59cf0dc4b7f8ca82437a";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((46.6833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.6833*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:"becb8a7d375626a9400d29541b8c3d48";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2167*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:"0963ea9b7e53b988e0df89fef2852107";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.2167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.2167*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:"ac404386af1e826891bd15e9a5ae95b3";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.8539*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.8539*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.27387- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6a04b08ba8fd66044ff2750c0b62435f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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((45.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6fad1147532dd2d55f844b018b84a1f1";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((45.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.35- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"694f6becfe8970fe868cb5a8d2e49438";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"26f6ea83d471c60f4963bf309ccd5ced";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.1*pi()/180)) * sin((Ville.lat*pi()/180))+cos((43.1*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.716667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"76908a09a53da1484ced158cc1d6a9ab";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s: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.7833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.7833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.'
unserialize - [internal], line ??
FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828
DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658
DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
EtablissementsController::view() - APP/Controller/EtablissementsController.php, line 70
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
Avis CHOUCHA LIONEL Paris 4ème (75004) : horaires, téléphone, adresse...
Établie à Paris 4ème, la société "CHOUCHA LIONEL" est enregistrée parmi les entreprises aux activités comptables (code APE / NAF 6920Z) du secteur 75 : Paris.
Associée au numéro de SIRET 33815833000054, sa création remonte au 2000-12-31.
Basé sur 0 avis
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoile
Admin – 28 septembre 2022 :
Actuellement AUCUN avis n'a été déposé à propos de la société "CHOUCHA LIONEL, Paris 4ème" via le portail Findeo qui répertorie les experts-comptables. Vous êtes ancien ou actuel client du cabinet ou un salarié ? Merci de partager votre avis !
