SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo,CASE WHEN isable!=0 THEN photo WHEN wi1!=2 AND photo1_2!="" THEN photo1_2 WHEN wi1!=4 AND photo1_4!="" THEN photo1_4 ELSE photo END photo,CASE WHEN isable!=0 THEN photo2 WHEN wi1!=2 AND photo1_2!="" AND photo1_2=photo2 THEN photo ELSE (CASE WHEN wi2=1 AND photo2_2!="" THEN photo2_2 ELSE photo2 END ) END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,9424,6598,9448,8933,9277,9267,4654,4653,9011,9091,8915,9115,5134,8900,9328,5135,7711,6882,9403,7059,9412,6739,9341,8859,5307,7048,6685,8439,7217,9304,8857,2598,8856,8854,8696,5009,7238,8708,5967,8774,5966,8585,8598,8013,7536,7241,6607,7485,7533,7981,6007,4587,8403,6690,6863,8653,3998,7683,7537,6876,4799,6417,7690,7001,8281,8162,7166,6361,6684,7532,6873,7487,7177,7758,8881,1569,7056,6878)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%57%'ORDER BY CASE produit WHEN 9424 THEN (num*3)+1 WHEN 6598 THEN (num*3)+2 WHEN 9448 THEN (num*3)+3 WHEN 8933 THEN (num*3)+4 WHEN 9277 THEN (num*3)+5 WHEN 9267 THEN (num*3)+6 WHEN 4654 THEN (num*3)+7 WHEN 4653 THEN (num*3)+8 WHEN 9011 THEN (num*3)+9 WHEN 9091 THEN (num*3)+10 WHEN 8915 THEN (num*3)+11 WHEN 9115 THEN (num*3)+12 WHEN 5134 THEN (num*3)+13 WHEN 8900 THEN (num*3)+14 WHEN 9328 THEN (num*3)+15 WHEN 5135 THEN (num*3)+16 WHEN 7711 THEN (num*3)+17 WHEN 6882 THEN (num*3)+18 WHEN 9403 THEN (num*3)+19 WHEN 7059 THEN (num*3)+20 WHEN 9412 THEN (num*3)+21 WHEN 6739 THEN (num*3)+22 WHEN 9341 THEN (num*3)+23 WHEN 8859 THEN (num*3)+24 WHEN 5307 THEN (num*3)+25 WHEN 7048 THEN (num*3)+26 WHEN 6685 THEN (num*3)+27 WHEN 8439 THEN (num*3)+28 WHEN 7217 THEN (num*3)+29 WHEN 9304 THEN (num*3)+30 WHEN 8857 THEN (num*3)+31 WHEN 2598 THEN (num*3)+32 WHEN 8856 THEN (num*3)+33 WHEN 8854 THEN (num*3)+34 WHEN 8696 THEN (num*3)+35 WHEN 5009 THEN (num*3)+36 WHEN 7238 THEN (num*3)+37 WHEN 8708 THEN (num*3)+38 WHEN 5967 THEN (num*3)+39 WHEN 8774 THEN (num*3)+40 WHEN 5966 THEN (num*3)+41 WHEN 8585 THEN (num*3)+42 WHEN 8598 THEN (num*3)+43 WHEN 8013 THEN (num*3)+44 WHEN 7536 THEN (num*3)+45 WHEN 7241 THEN (num*3)+46 WHEN 6607 THEN (num*3)+47 WHEN 7485 THEN (num*3)+48 WHEN 7533 THEN (num*3)+49 WHEN 7981 THEN (num*3)+50 WHEN 6007 THEN (num*3)+51 WHEN 4587 THEN (num*3)+52 WHEN 8403 THEN (num*3)+53 WHEN 6690 THEN (num*3)+54 WHEN 6863 THEN (num*3)+55 WHEN 8653 THEN (num*3)+56 WHEN 3998 THEN (num*3)+57 WHEN 7683 THEN (num*3)+58 WHEN 7537 THEN (num*3)+59 WHEN 6876 THEN (num*3)+60 WHEN 4799 THEN (num*3)+61 WHEN 6417 THEN (num*3)+62 WHEN 7690 THEN (num*3)+63 WHEN 7001 THEN (num*3)+64 WHEN 8281 THEN (num*3)+65 WHEN 8162 THEN (num*3)+66 WHEN 7166 THEN (num*3)+67 WHEN 6361 THEN (num*3)+68 WHEN 6684 THEN (num*3)+69 WHEN 7532 THEN (num*3)+70 WHEN 6873 THEN (num*3)+71 WHEN 7487 THEN (num*3)+72 WHEN 7177 THEN (num*3)+73 WHEN 7758 THEN (num*3)+74 WHEN 8881 THEN (num*3)+75 WHEN 1569 THEN (num*3)+76 WHEN 7056 THEN (num*3)+77 WHEN 6878 THEN (num*3)+78 END,numErr153a