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='2' AND p.active = 1 GROUP BY p.id ORDER BY Rand()
Trouvez votre Bon Plan selon vos criteres de recherche.