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(151,206,208,211,212,213,226,359,370,605,678,1772,2095,2099,2100,2101,2259,2619,2620)
GROUP BY produits.id
ORDER BY  champ_opt.val_c DESC  LIMIT 0, 12<br/>Got error 28 from storage engine