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(62,1190,1375,1400,1479,1487,1488,1664,2580,2659,2920,2931,2933,2935,2936,2937,2938,2941,2943,2944,3424)
GROUP BY produits.id
ORDER BY  champ_opt.val_c DESC  LIMIT 0, 12<br/>Got error 28 from storage engine