$sqlstatut = '';
$sqlstatutjoin = '';
if ($entite[$lis['ent_id']]['ent_code'] == 'famille' && $lis['lis_locked']) {
- $sqlstatut = " AND personne_info.inf_code ilike 'famille_'";
- $sqlstatut .= " AND personne_info_integer_get(".$_SESSION['token'].", personne_info.per_id, 'statut_usager') = ANY(select array_agg(sta_id) from liste_statut inner join liste using (lis_id) where lis_locked and lis_id = ".$lis['lis_id'].")";
+ $sqlstatut = " AND personne_info.inf_code ilike 'famille%'";
+ $sqlstatut .= " AND personne_info_integer_get (".$_SESSION['token'].", personne_info.per_id, 'statut_usager') = ANY(select sta_id from liste.liste_statut inner join liste.liste using (lis_id) where lis_locked and lis_id = ".$lis['lis_id'].")";
$sqlstatutjoin = " LEFT JOIN personne_info_lien_familial ON personne_info_lien_familial.per_id_parent = personne.per_id LEFT JOIN personne_info using (pin_id)";
}