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