SQL : SELECT DISTINCT idrubrique AS id
FROM rubrique AS rub
LEFT JOIN produit AS prod ON prod.categ = rub.idrubrique
LEFT JOIN produitoption AS po ON po.produit = prod.id
JOIN partenaire AS part ON prod.partenaire = part.id
JOIN agglomeration AS agglo ON agglo.id = part.agglo
WHERE (agglo.parent = 75 OR FIND_IN_SET(prod.famillesec, 75)) AND po.actif = 'on'