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=2 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,9054,9176,9028,2104,6879,9127,2609,9126,9154,9004,6968,8453,3855,4640,6961,6963,8893,8891,9002,5760,9027,8913,2610,8945,9241,9003,9149,7892,6962,8319,7888,6706,7867,8995,1823,6169,7576,7893,8341,8456,7894,8338,5329,9032,7923,7887,8884,8880,7391,8250,7816,6960,9008,9031,7599,7384,7589,8268,6967,8230,8480,8213,7585,8504,8225,8214,6864,6472,7586,8332,8239,6200,8438,7649,8499,7815,8478,8336,8271,8232,8276,8441,8479,8526,8235,8527,3254,8510,7587,5175,7385,7633,8237,6871,8234,6691,8337,6284,6866,7829,8215,8391,8425,3561,6786,8216,8487,7491,6688,8424,5824,7025)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%'ORDER BY CASE produit WHEN 9054 THEN (num*4)+1 WHEN 9176 THEN (num*4)+2 WHEN 9028 THEN (num*4)+3 WHEN 2104 THEN (num*4)+4 WHEN 6879 THEN (num*4)+5 WHEN 9127 THEN (num*4)+6 WHEN 2609 THEN (num*4)+7 WHEN 9126 THEN (num*4)+8 WHEN 9154 THEN (num*4)+9 WHEN 9004 THEN (num*4)+10 WHEN 6968 THEN (num*4)+11 WHEN 8453 THEN (num*4)+12 WHEN 3855 THEN (num*4)+13 WHEN 4640 THEN (num*4)+14 WHEN 6961 THEN (num*4)+15 WHEN 6963 THEN (num*4)+16 WHEN 8893 THEN (num*4)+17 WHEN 8891 THEN (num*4)+18 WHEN 9002 THEN (num*4)+19 WHEN 5760 THEN (num*4)+20 WHEN 9027 THEN (num*4)+21 WHEN 8913 THEN (num*4)+22 WHEN 2610 THEN (num*4)+23 WHEN 8945 THEN (num*4)+24 WHEN 9241 THEN (num*4)+25 WHEN 9003 THEN (num*4)+26 WHEN 9149 THEN (num*4)+27 WHEN 7892 THEN (num*4)+28 WHEN 6962 THEN (num*4)+29 WHEN 8319 THEN (num*4)+30 WHEN 7888 THEN (num*4)+31 WHEN 6706 THEN (num*4)+32 WHEN 7867 THEN (num*4)+33 WHEN 8995 THEN (num*4)+34 WHEN 1823 THEN (num*4)+35 WHEN 6169 THEN (num*4)+36 WHEN 7576 THEN (num*4)+37 WHEN 7893 THEN (num*4)+38 WHEN 8341 THEN (num*4)+39 WHEN 8456 THEN (num*4)+40 WHEN 7894 THEN (num*4)+41 WHEN 8338 THEN (num*4)+42 WHEN 5329 THEN (num*4)+43 WHEN 9032 THEN (num*4)+44 WHEN 7923 THEN (num*4)+45 WHEN 7887 THEN (num*4)+46 WHEN 8884 THEN (num*4)+47 WHEN 8880 THEN (num*4)+48 WHEN 7391 THEN (num*4)+49 WHEN 8250 THEN (num*4)+50 WHEN 7816 THEN (num*4)+51 WHEN 6960 THEN (num*4)+52 WHEN 9008 THEN (num*4)+53 WHEN 9031 THEN (num*4)+54 WHEN 7599 THEN (num*4)+55 WHEN 7384 THEN (num*4)+56 WHEN 7589 THEN (num*4)+57 WHEN 8268 THEN (num*4)+58 WHEN 6967 THEN (num*4)+59 WHEN 8230 THEN (num*4)+60 WHEN 8480 THEN (num*4)+61 WHEN 8213 THEN (num*4)+62 WHEN 7585 THEN (num*4)+63 WHEN 8504 THEN (num*4)+64 WHEN 8225 THEN (num*4)+65 WHEN 8214 THEN (num*4)+66 WHEN 6864 THEN (num*4)+67 WHEN 6472 THEN (num*4)+68 WHEN 7586 THEN (num*4)+69 WHEN 8332 THEN (num*4)+70 WHEN 8239 THEN (num*4)+71 WHEN 6200 THEN (num*4)+72 WHEN 8438 THEN (num*4)+73 WHEN 7649 THEN (num*4)+74 WHEN 8499 THEN (num*4)+75 WHEN 7815 THEN (num*4)+76 WHEN 8478 THEN (num*4)+77 WHEN 8336 THEN (num*4)+78 WHEN 8271 THEN (num*4)+79 WHEN 8232 THEN (num*4)+80 WHEN 8276 THEN (num*4)+81 WHEN 8441 THEN (num*4)+82 WHEN 8479 THEN (num*4)+83 WHEN 8526 THEN (num*4)+84 WHEN 8235 THEN (num*4)+85 WHEN 8527 THEN (num*4)+86 WHEN 3254 THEN (num*4)+87 WHEN 8510 THEN (num*4)+88 WHEN 7587 THEN (num*4)+89 WHEN 5175 THEN (num*4)+90 WHEN 7385 THEN (num*4)+91 WHEN 7633 THEN (num*4)+92 WHEN 8237 THEN (num*4)+93 WHEN 6871 THEN (num*4)+94 WHEN 8234 THEN (num*4)+95 WHEN 6691 THEN (num*4)+96 WHEN 8337 THEN (num*4)+97 WHEN 6284 THEN (num*4)+98 WHEN 6866 THEN (num*4)+99 WHEN 7829 THEN (num*4)+100 WHEN 8215 THEN (num*4)+101 WHEN 8391 THEN (num*4)+102 WHEN 8425 THEN (num*4)+103 WHEN 3561 THEN (num*4)+104 WHEN 6786 THEN (num*4)+105 WHEN 8216 THEN (num*4)+106 WHEN 8487 THEN (num*4)+107 WHEN 7491 THEN (num*4)+108 WHEN 6688 THEN (num*4)+109 WHEN 8424 THEN (num*4)+110 WHEN 5824 THEN (num*4)+111 WHEN 7025 THEN (num*4)+112 END,numErr153a