SELECT DISTINCT G_T0.personne_uid ,
G_T0.personne_num ,
G_T0.personne_eid|| TO_CHAR(1, '9999999999') ,
substr(md5(to_char(random()*1000000,'999999')),1,6)
FROM public.data_personne G_T0 INNER JOIN (SELECT G_T3.contrat_assure_uid AS G_F1
FROM public.data_contrat G_T3,
public.dim_contrat_nature G_T4,
public.dim_contrat_statut G_T5
WHERE ( G_T5.contrat_statut_uid = G_T3.contrat_statut_uid )
AND ( G_T4.contrat_nature_uid = G_T3.contrat_nature_uid )
AND ( G_T4.contrat_nature_eid = 'S' AND G_T3.contrat_eid NOT LIKE '%groupe' AND ( G_T5.contrat_statut_eid IN ('in_force' , 'pending_1' ) OR G_T3.contrat_date_resiliation IS NULL OR G_T3.contrat_date_resiliation >= NOW() )
) G_T2
ON G_T2.G_F1 = G_T0.personne_uid } LEFT OUTER JOIN public.data_espace_client_internet G_T1
ON G_T0.personne_uid = G_T1.espace_client_internet_personne_uid
WHERE G_T1.espace_client_internet_uid IS NULL