Hammam

SQL : SELECT DISTINCT idproduitoption AS id, agglo.index as indexAgglo,parent,agglo.id as id_agglo FROM produitoption AS po RIGHT 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 = 24 OR FIND_IN_SET(prod.categsec, 24)) ORDER BY parent,id_agglo,agglo.index, idproduitoption DESC