1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| with clientcont3_ as
( select client_id, valeur
from client_contact
where clientcont3_.valeur like '%'||'@mail'||'%'
/* and clientcont3_.valeur is not null*/
)
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 clientcont3_
on (clientcont3_.client_id=client0_.id)
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