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(756,1419,1640,1699,1732,1982,2026,2576,2581,3420,3423,3424) GROUP BY produits.id ORDER BY champ_opt.val_c DESC LIMIT 0, 12
Got error 28 from storage engine