SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE num=0 AND prix!="0.00" AND affich=1 AND photo2!="" AND volume!=4  AND produit IN(0,9255,9400,9409,9329,9194,9349,9271,9328,9344,9188,9265,9374,6362,9375,8890,9258,8744,9350,9245,9267,7153,8327,6945,6734,8507,8366,8935,8883,8921,8924,9171,8931,8599,9383,9322,9146,9384,9301,7306,9119,9303,9220,9413,9382,9398,7482,9390,9358,9388,9389)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) GROUP BY produit ORDER BY CASE produit WHEN 9255 THEN (num*1)+1 WHEN 9400 THEN (num*1)+2 WHEN 9409 THEN (num*1)+3 WHEN 9329 THEN (num*1)+4 WHEN 9194 THEN (num*1)+5 WHEN 9349 THEN (num*1)+6 WHEN 9271 THEN (num*1)+7 WHEN 9328 THEN (num*1)+8 WHEN 9344 THEN (num*1)+9 WHEN 9188 THEN (num*1)+10 WHEN 9265 THEN (num*1)+11 WHEN 9374 THEN (num*1)+12 WHEN 6362 THEN (num*1)+13 WHEN 9375 THEN (num*1)+14 WHEN 8890 THEN (num*1)+15 WHEN 9258 THEN (num*1)+16 WHEN 8744 THEN (num*1)+17 WHEN 9350 THEN (num*1)+18 WHEN 9245 THEN (num*1)+19 WHEN 9267 THEN (num*1)+20 WHEN 7153 THEN (num*1)+21 WHEN 8327 THEN (num*1)+22 WHEN 6945 THEN (num*1)+23 WHEN 6734 THEN (num*1)+24 WHEN 8507 THEN (num*1)+25 WHEN 8366 THEN (num*1)+26 WHEN 8935 THEN (num*1)+27 WHEN 8883 THEN (num*1)+28 WHEN 8921 THEN (num*1)+29 WHEN 8924 THEN (num*1)+30 WHEN 9171 THEN (num*1)+31 WHEN 8931 THEN (num*1)+32 WHEN 8599 THEN (num*1)+33 WHEN 9383 THEN (num*1)+34 WHEN 9322 THEN (num*1)+35 WHEN 9146 THEN (num*1)+36 WHEN 9384 THEN (num*1)+37 WHEN 9301 THEN (num*1)+38 WHEN 7306 THEN (num*1)+39 WHEN 9119 THEN (num*1)+40 WHEN 9303 THEN (num*1)+41 WHEN 9220 THEN (num*1)+42 WHEN 9413 THEN (num*1)+43 WHEN 9382 THEN (num*1)+44 WHEN 9398 THEN (num*1)+45 WHEN 7482 THEN (num*1)+46 WHEN 9390 THEN (num*1)+47 WHEN 9358 THEN (num*1)+48 WHEN 9388 THEN (num*1)+49 WHEN 9389 THEN (num*1)+50 END,numErr153a