1 2 3 4 5 6 7 8 9 10 11 12
|
select clientcont3_.valeur, client0_.id as id1_6_, client0_.activite_commerce_interdite as activite2_6_, client0_.civilite_id as civilit23_6_, client0_.code_magasin as code_mag3_6_, client0_.createur_id as createu24_6_, client0_.date_anniversaire as date_ann4_6_, client0_.date_creation as date_cre5_6_, client0_.date_creation_sys as date_cre6_6_, client0_.date_mariage as date_mar7_6_, client0_.date_modification as date_mod8_6_, client0_.date_modification_sys as date_mod9_6_, client0_.date_suppression as date_su10_6_, client0_.entite_id as entite_25_6_, client0_.genre_client as genre_c11_6_, client0_.modificateur_id as modific26_6_, client0_.nom as nom12_6_, client0_.origine as origine13_6_, client0_.prenom as prenom14_6_, client0_.societe as societe15_6_, client0_.supprimeur_id as supprim27_6_, client0_.taux_remise as taux_re16_6_, client0_.type_client as type_cl17_6_, client0_.type_envoi_courrier as type_en18_6_, client0_.type_envoi_email as type_en19_6_, client0_.type_envoi_sms as type_en20_6_, client0_.type_libre as type_li21_6_, client0_.uuid as uuid22_6_
from client client0_
inner join entite entite1_ on client0_.entite_id=entite1_.id
left outer join client_adresse clientadre2_ on (clientadre2_.client_id=client0_.id) and (upper(clientadre2_.ville) like ('%'||upper('')||'%') or upper(clientadre2_.code_postal) like ('%'||upper('')||'%'))
left outer join client_contact clientcont3_ on (clientcont3_.client_id=client0_.id) and (clientcont3_.valeur is not null and clientcont3_.valeur like ('%'||'@mail'||'%'))
where (entite1_.numero_licence in ('ZB230EC'))
and (upper(client0_.nom) like ('%'||upper('')||'%'))
and (client0_.prenom is null or upper(client0_.prenom) like ('%'||upper('')||'%'))
and (client0_.date_creation_sys is null or client0_.date_creation_sys>='2017-01-01')
and (client0_.date_modification_sys is null or client0_.date_modification_sys>='2017-01-01')
and (client0_.date_suppression is null or client0_.date_suppression>='9999-12-12') |
Partager