SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,8741,8757,8736,8768,8740,8738,7484,8756,5920,8733,8754,7322,7558,7486,7488,7493,7449,7330,7533,7538,7536,7323,7539,7325,7537,6317,7534,7487,7494)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%57%'ORDER BY CASE produit WHEN 8741 THEN (num*1)+1 WHEN 8757 THEN (num*1)+2 WHEN 8736 THEN (num*1)+3 WHEN 8768 THEN (num*1)+4 WHEN 8740 THEN (num*1)+5 WHEN 8738 THEN (num*1)+6 WHEN 7484 THEN (num*1)+7 WHEN 8756 THEN (num*1)+8 WHEN 5920 THEN (num*1)+9 WHEN 8733 THEN (num*1)+10 WHEN 8754 THEN (num*1)+11 WHEN 7322 THEN (num*1)+12 WHEN 7558 THEN (num*1)+13 WHEN 7486 THEN (num*1)+14 WHEN 7488 THEN (num*1)+15 WHEN 7493 THEN (num*1)+16 WHEN 7449 THEN (num*1)+17 WHEN 7330 THEN (num*1)+18 WHEN 7533 THEN (num*1)+19 WHEN 7538 THEN (num*1)+20 WHEN 7536 THEN (num*1)+21 WHEN 7323 THEN (num*1)+22 WHEN 7539 THEN (num*1)+23 WHEN 7325 THEN (num*1)+24 WHEN 7537 THEN (num*1)+25 WHEN 6317 THEN (num*1)+26 WHEN 7534 THEN (num*1)+27 WHEN 7487 THEN (num*1)+28 WHEN 7494 THEN (num*1)+29 END,numErr153a