SELECT p.id as idpart, p.*,i.*,rn.* FROM bpm_partenaires p LEFT JOIN bpm_images i ON p.id=i.fk_partenaire LEFT JOIN bpm_region_natif rn ON p.id=rn.fk_partenaire WHERE 1=1 AND fk_activite='1' AND p.active = 1 GROUP BY p.id ORDER BY Rand()