Relooking
SQL : SELECT DISTINCT idproduitoption AS id, agglo.index as indexAgglo
FROM produitoption AS po
JOIN produit AS prod ON prod.id = po.produit
JOIN partenaire AS part ON prod.partenaire = part.id
JOIN agglomeration AS agglo ON agglo.id = part.agglo
WHERE po.actif = 'on'
AND (prod.categ = 67 OR FIND_IN_SET(prod.categsec, 67))
ORDER BY agglo.index, idproduitoption DESC