SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=1 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,6109,9307,6610,6106,9314,6520,9456,9308,9494,9455,9511,9509,9454,9506,9491,9505,4650,9502,2107,9528,9501,9527,9523,9500,9510,9492,9507,6132,2104,9504,5109,4632,9503,5133,4640,9017,3827,9499,7944,9497,9316,1809,9498,5132,1811,7450,9315,9014,9496,8568,9495,5111,6459,7452,1814,6612,7448,7374,5322,6108,8606,5108,6232,6597,5336,6598,5985,3952,6124,7110,6749,6609,5966,6763,7942,7202,5744,6611,4922,5745,2464,6133,8132)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%'ORDER BY CASE produit WHEN 6109 THEN (num*3)+1 WHEN 9307 THEN (num*3)+2 WHEN 6610 THEN (num*3)+3 WHEN 6106 THEN (num*3)+4 WHEN 9314 THEN (num*3)+5 WHEN 6520 THEN (num*3)+6 WHEN 9456 THEN (num*3)+7 WHEN 9308 THEN (num*3)+8 WHEN 9494 THEN (num*3)+9 WHEN 9455 THEN (num*3)+10 WHEN 9511 THEN (num*3)+11 WHEN 9509 THEN (num*3)+12 WHEN 9454 THEN (num*3)+13 WHEN 9506 THEN (num*3)+14 WHEN 9491 THEN (num*3)+15 WHEN 9505 THEN (num*3)+16 WHEN 4650 THEN (num*3)+17 WHEN 9502 THEN (num*3)+18 WHEN 2107 THEN (num*3)+19 WHEN 9528 THEN (num*3)+20 WHEN 9501 THEN (num*3)+21 WHEN 9527 THEN (num*3)+22 WHEN 9523 THEN (num*3)+23 WHEN 9500 THEN (num*3)+24 WHEN 9510 THEN (num*3)+25 WHEN 9492 THEN (num*3)+26 WHEN 9507 THEN (num*3)+27 WHEN 6132 THEN (num*3)+28 WHEN 2104 THEN (num*3)+29 WHEN 9504 THEN (num*3)+30 WHEN 5109 THEN (num*3)+31 WHEN 4632 THEN (num*3)+32 WHEN 9503 THEN (num*3)+33 WHEN 5133 THEN (num*3)+34 WHEN 4640 THEN (num*3)+35 WHEN 9017 THEN (num*3)+36 WHEN 3827 THEN (num*3)+37 WHEN 9499 THEN (num*3)+38 WHEN 7944 THEN (num*3)+39 WHEN 9497 THEN (num*3)+40 WHEN 9316 THEN (num*3)+41 WHEN 1809 THEN (num*3)+42 WHEN 9498 THEN (num*3)+43 WHEN 5132 THEN (num*3)+44 WHEN 1811 THEN (num*3)+45 WHEN 7450 THEN (num*3)+46 WHEN 9315 THEN (num*3)+47 WHEN 9014 THEN (num*3)+48 WHEN 9496 THEN (num*3)+49 WHEN 8568 THEN (num*3)+50 WHEN 9495 THEN (num*3)+51 WHEN 5111 THEN (num*3)+52 WHEN 6459 THEN (num*3)+53 WHEN 7452 THEN (num*3)+54 WHEN 1814 THEN (num*3)+55 WHEN 6612 THEN (num*3)+56 WHEN 7448 THEN (num*3)+57 WHEN 7374 THEN (num*3)+58 WHEN 5322 THEN (num*3)+59 WHEN 6108 THEN (num*3)+60 WHEN 8606 THEN (num*3)+61 WHEN 5108 THEN (num*3)+62 WHEN 6232 THEN (num*3)+63 WHEN 6597 THEN (num*3)+64 WHEN 5336 THEN (num*3)+65 WHEN 6598 THEN (num*3)+66 WHEN 5985 THEN (num*3)+67 WHEN 3952 THEN (num*3)+68 WHEN 6124 THEN (num*3)+69 WHEN 7110 THEN (num*3)+70 WHEN 6749 THEN (num*3)+71 WHEN 6609 THEN (num*3)+72 WHEN 5966 THEN (num*3)+73 WHEN 6763 THEN (num*3)+74 WHEN 7942 THEN (num*3)+75 WHEN 7202 THEN (num*3)+76 WHEN 5744 THEN (num*3)+77 WHEN 6611 THEN (num*3)+78 WHEN 4922 THEN (num*3)+79 WHEN 5745 THEN (num*3)+80 WHEN 2464 THEN (num*3)+81 WHEN 6133 THEN (num*3)+82 WHEN 8132 THEN (num*3)+83 END,numErr153a