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(28,29,30,32,34,35,36,37,39,53,64,94,136,145,149,152,153,159,161,162,163,164,181,183,186,207,209,210,267,364,365,368,371,374,596,610,660,661,1156,1163,1182,1183,1468,1469,1480,1481,1485,1491,1522,1528,1530,1683,1692,1798,1801,1804,1835,1847,1850,1859,2029,2160,2245,2273,2278,2298,2304,2313,2317,2323,2329,2576,2612,2620,2631,2932,2934,2939,2940,2942,2945,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2987,2988,2989,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3222,3227,3233,3239,3255,3262,3264,3270,3280,3281,3370,3373,3378,3379,3397,3399,3426,3428)
GROUP BY produits.id
ORDER BY  champ_opt.val_c DESC  LIMIT 0, 12<br/>Got error 28 from storage engine