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'