SELECT produits.id as id ,produits.nom as nom,produits.arbo as arbo
FROM produits
INNER JOIN champ_opt ON produits.id = champ_opt.id_l AND  champ_opt.id_cgen=7 AND champ_opt.id_l IN(1167,1207,1364,1365,1436,1439,1440,1441,1453,1456,1516,1518,1677,1702,1703,1760,1809,1883,2084,2651,2696,2757,2868,3390,3403)
GROUP BY produits.id
ORDER BY  champ_opt.val_c DESC  LIMIT 0, 12<br/>Got error 28 from storage engine