_ERREURRECHERCHE2
select pro_establishments_beta.id,pro_establishments_beta.establishment_name,pro_establishments_beta.address,pro_establishments_beta.telephone,pro_establishments_beta.postal_edited,pro_establishments_beta.parking_city_id_fk,pro_establishments_beta.city_id_fk,pro_establishments_beta.counter, pro_establishments_beta.Identifiant_Laposte, Bureaux_Postes.libelle_du_site, Bureaux_Postes.identifiant_a, Bureaux_Postes.caracteristique_du_site, Bureaux_Postes.adresse, Bureaux_Postes.complement_d_adresse, Bureaux_Postes.code_postal, Bureaux_Postes.localite, Bureaux_Postes.code_insee, Bureaux_Postes.latitude, Bureaux_Postes.longitude
from pro_establishments_beta, Bureaux_Postes
where Bureaux_Postes.identifiant_a=pro_establishments_beta.Identifiant_Laposte COLLATE utf8_unicode_ci and pro_establishments_beta.is_active>0 and pro_establishments_beta.is_refuse=0 and pro_establishments_beta.is_account_close=0 and pro_establishments_beta.is_account_cessation=0 and pro_establishments_beta.doublon is NULL and pro_establishments_beta.counter>0 and (pro_establishments_beta.city_id_fk='80327' or pro_establishments_beta.city_id_fk='80328' or pro_establishments_beta.city_id_fk='80329' or pro_establishments_beta.city_id_fk='80330' or pro_establishments_beta.city_id_fk='80331' or pro_establishments_beta.city_id_fk='80332' or pro_establishments_beta.city_id_fk='80333' or pro_establishments_beta.city_id_fk='80334' or pro_establishments_beta.city_id_fk='80335' or pro_establishments_beta.city_id_fk='80320' or pro_establishments_beta.city_id_fk='80321' or pro_establishments_beta.city_id_fk='80322' or pro_establishments_beta.city_id_fk='80323' or pro_establishments_beta.city_id_fk='80324' or pro_establishments_beta.city_id_fk='80325' or pro_establishments_beta.city_id_fk='80326') and (pro_establishments_beta.Identifiant_Laposte!='' and pro_establishments_beta.Identifiant_Laposte IS NOT NULL and pro_establishments_beta.Identifiant_Laposte!='NO') and Bureaux_Postes.caracteristique_du_site!='Relais poste commerçant'
order by pro_establishments_beta.counter desc,pro_establishments_beta.establishment_name desc,pro_establishments_beta.postal_edited asc
_ERREURRECHERCHE2
select pro_establishments_beta.id,pro_establishments_beta.establishment_name,pro_establishments_beta.address,pro_establishments_beta.telephone,pro_establishments_beta.postal_edited,pro_establishments_beta.parking_city_id_fk,pro_establishments_beta.city_id_fk,pro_establishments_beta.counter, pro_establishments_beta.Identifiant_Laposte, Bureaux_Postes.libelle_du_site, Bureaux_Postes.identifiant_a, Bureaux_Postes.caracteristique_du_site, Bureaux_Postes.adresse, Bureaux_Postes.complement_d_adresse, Bureaux_Postes.code_postal, Bureaux_Postes.localite, Bureaux_Postes.code_insee, Bureaux_Postes.latitude, Bureaux_Postes.longitude
from pro_establishments_beta, Bureaux_Postes
where Bureaux_Postes.identifiant_a=pro_establishments_beta.Identifiant_Laposte COLLATE utf8_unicode_ci and pro_establishments_beta.is_active>0 and pro_establishments_beta.is_refuse=0 and pro_establishments_beta.is_account_close=0 and pro_establishments_beta.is_account_cessation=0 and pro_establishments_beta.doublon is NULL and pro_establishments_beta.counter>0 and (pro_establishments_beta.city_id_fk='80327' or pro_establishments_beta.city_id_fk='80328' or pro_establishments_beta.city_id_fk='80329' or pro_establishments_beta.city_id_fk='80330' or pro_establishments_beta.city_id_fk='80331' or pro_establishments_beta.city_id_fk='80332' or pro_establishments_beta.city_id_fk='80333' or pro_establishments_beta.city_id_fk='80334' or pro_establishments_beta.city_id_fk='80335' or pro_establishments_beta.city_id_fk='80320' or pro_establishments_beta.city_id_fk='80321' or pro_establishments_beta.city_id_fk='80322' or pro_establishments_beta.city_id_fk='80323' or pro_establishments_beta.city_id_fk='80324' or pro_establishments_beta.city_id_fk='80325' or pro_establishments_beta.city_id_fk='80326') and (pro_establishments_beta.Identifiant_Laposte!='' and pro_establishments_beta.Identifiant_Laposte IS NOT NULL and pro_establishments_beta.Identifiant_Laposte!='NO') and Bureaux_Postes.caracteristique_du_site='Relais poste commerçant'
order by pro_establishments_beta.counter desc,pro_establishments_beta.establishment_name desc,pro_establishments_beta.postal_edited asc