SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,8964,7667,8954,4663,8866,7668,3140,7677,6375,7133,8766,8822,7680,8697,5542,7669,7236,8820,6376,8765,5031,4597,5541,8789,7995,8782,7474,4155,3609,5030,7890,7247,7639,6286,7825,8257,7717,7716,8051,6705,7753,4158,6364,8129,8055,7959,6365,8823,7152,4266)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%55%'ORDER BY CASE produit WHEN 8964 THEN (num*2)+1 WHEN 7667 THEN (num*2)+2 WHEN 8954 THEN (num*2)+3 WHEN 4663 THEN (num*2)+4 WHEN 8866 THEN (num*2)+5 WHEN 7668 THEN (num*2)+6 WHEN 3140 THEN (num*2)+7 WHEN 7677 THEN (num*2)+8 WHEN 6375 THEN (num*2)+9 WHEN 7133 THEN (num*2)+10 WHEN 8766 THEN (num*2)+11 WHEN 8822 THEN (num*2)+12 WHEN 7680 THEN (num*2)+13 WHEN 8697 THEN (num*2)+14 WHEN 5542 THEN (num*2)+15 WHEN 7669 THEN (num*2)+16 WHEN 7236 THEN (num*2)+17 WHEN 8820 THEN (num*2)+18 WHEN 6376 THEN (num*2)+19 WHEN 8765 THEN (num*2)+20 WHEN 5031 THEN (num*2)+21 WHEN 4597 THEN (num*2)+22 WHEN 5541 THEN (num*2)+23 WHEN 8789 THEN (num*2)+24 WHEN 7995 THEN (num*2)+25 WHEN 8782 THEN (num*2)+26 WHEN 7474 THEN (num*2)+27 WHEN 4155 THEN (num*2)+28 WHEN 3609 THEN (num*2)+29 WHEN 5030 THEN (num*2)+30 WHEN 7890 THEN (num*2)+31 WHEN 7247 THEN (num*2)+32 WHEN 7639 THEN (num*2)+33 WHEN 6286 THEN (num*2)+34 WHEN 7825 THEN (num*2)+35 WHEN 8257 THEN (num*2)+36 WHEN 7717 THEN (num*2)+37 WHEN 7716 THEN (num*2)+38 WHEN 8051 THEN (num*2)+39 WHEN 6705 THEN (num*2)+40 WHEN 7753 THEN (num*2)+41 WHEN 4158 THEN (num*2)+42 WHEN 6364 THEN (num*2)+43 WHEN 8129 THEN (num*2)+44 WHEN 8055 THEN (num*2)+45 WHEN 7959 THEN (num*2)+46 WHEN 6365 THEN (num*2)+47 WHEN 8823 THEN (num*2)+48 WHEN 7152 THEN (num*2)+49 WHEN 4266 THEN (num*2)+50 END,numErr153a