SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,8757,8447,9176,9028,9076,9090,9124,8812,9089,9026,9153,9022,8815,8810,8814,9127,9126,9123,6968,9075,6880,6961,9125,9027,8813,7489,8243,9149,8241,6962,8319,8811,6959,9152,8314,8339,7383,6881,9023,8242,8240,9025,9024,8316,7381,6882,8400,8340,8342,7567,7569,8315,7930,8529,9122,8341,6874,7391,7484,8250,8321,6966,5920,6960,8248,8459,8323,8343,8528,8322,8741,8457,7435,7416,6967,7386,8736,7446,7488,8768,8318,7486,7447,7429,6864,8756,8740,8738,7533,7536,7538,8733,7558,7400,7322,7539,7428,8754,7537,8399,7389,6875,7493,6873,7443,7449,6876,7379,7490,7330,7534,7323,7390,7410,7325,6871,7487,6868,6317,7026,7491,7423,7440,7426,7434,7025)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%57%'ORDER BY CASE produit WHEN 8757 THEN (num*6)+1 WHEN 8447 THEN (num*6)+2 WHEN 9176 THEN (num*6)+3 WHEN 9028 THEN (num*6)+4 WHEN 9076 THEN (num*6)+5 WHEN 9090 THEN (num*6)+6 WHEN 9124 THEN (num*6)+7 WHEN 8812 THEN (num*6)+8 WHEN 9089 THEN (num*6)+9 WHEN 9026 THEN (num*6)+10 WHEN 9153 THEN (num*6)+11 WHEN 9022 THEN (num*6)+12 WHEN 8815 THEN (num*6)+13 WHEN 8810 THEN (num*6)+14 WHEN 8814 THEN (num*6)+15 WHEN 9127 THEN (num*6)+16 WHEN 9126 THEN (num*6)+17 WHEN 9123 THEN (num*6)+18 WHEN 6968 THEN (num*6)+19 WHEN 9075 THEN (num*6)+20 WHEN 6880 THEN (num*6)+21 WHEN 6961 THEN (num*6)+22 WHEN 9125 THEN (num*6)+23 WHEN 9027 THEN (num*6)+24 WHEN 8813 THEN (num*6)+25 WHEN 7489 THEN (num*6)+26 WHEN 8243 THEN (num*6)+27 WHEN 9149 THEN (num*6)+28 WHEN 8241 THEN (num*6)+29 WHEN 6962 THEN (num*6)+30 WHEN 8319 THEN (num*6)+31 WHEN 8811 THEN (num*6)+32 WHEN 6959 THEN (num*6)+33 WHEN 9152 THEN (num*6)+34 WHEN 8314 THEN (num*6)+35 WHEN 8339 THEN (num*6)+36 WHEN 7383 THEN (num*6)+37 WHEN 6881 THEN (num*6)+38 WHEN 9023 THEN (num*6)+39 WHEN 8242 THEN (num*6)+40 WHEN 8240 THEN (num*6)+41 WHEN 9025 THEN (num*6)+42 WHEN 9024 THEN (num*6)+43 WHEN 8316 THEN (num*6)+44 WHEN 7381 THEN (num*6)+45 WHEN 6882 THEN (num*6)+46 WHEN 8400 THEN (num*6)+47 WHEN 8340 THEN (num*6)+48 WHEN 8342 THEN (num*6)+49 WHEN 7567 THEN (num*6)+50 WHEN 7569 THEN (num*6)+51 WHEN 8315 THEN (num*6)+52 WHEN 7930 THEN (num*6)+53 WHEN 8529 THEN (num*6)+54 WHEN 9122 THEN (num*6)+55 WHEN 8341 THEN (num*6)+56 WHEN 6874 THEN (num*6)+57 WHEN 7391 THEN (num*6)+58 WHEN 7484 THEN (num*6)+59 WHEN 8250 THEN (num*6)+60 WHEN 8321 THEN (num*6)+61 WHEN 6966 THEN (num*6)+62 WHEN 5920 THEN (num*6)+63 WHEN 6960 THEN (num*6)+64 WHEN 8248 THEN (num*6)+65 WHEN 8459 THEN (num*6)+66 WHEN 8323 THEN (num*6)+67 WHEN 8343 THEN (num*6)+68 WHEN 8528 THEN (num*6)+69 WHEN 8322 THEN (num*6)+70 WHEN 8741 THEN (num*6)+71 WHEN 8457 THEN (num*6)+72 WHEN 7435 THEN (num*6)+73 WHEN 7416 THEN (num*6)+74 WHEN 6967 THEN (num*6)+75 WHEN 7386 THEN (num*6)+76 WHEN 8736 THEN (num*6)+77 WHEN 7446 THEN (num*6)+78 WHEN 7488 THEN (num*6)+79 WHEN 8768 THEN (num*6)+80 WHEN 8318 THEN (num*6)+81 WHEN 7486 THEN (num*6)+82 WHEN 7447 THEN (num*6)+83 WHEN 7429 THEN (num*6)+84 WHEN 6864 THEN (num*6)+85 WHEN 8756 THEN (num*6)+86 WHEN 8740 THEN (num*6)+87 WHEN 8738 THEN (num*6)+88 WHEN 7533 THEN (num*6)+89 WHEN 7536 THEN (num*6)+90 WHEN 7538 THEN (num*6)+91 WHEN 8733 THEN (num*6)+92 WHEN 7558 THEN (num*6)+93 WHEN 7400 THEN (num*6)+94 WHEN 7322 THEN (num*6)+95 WHEN 7539 THEN (num*6)+96 WHEN 7428 THEN (num*6)+97 WHEN 8754 THEN (num*6)+98 WHEN 7537 THEN (num*6)+99 WHEN 8399 THEN (num*6)+100 WHEN 7389 THEN (num*6)+101 WHEN 6875 THEN (num*6)+102 WHEN 7493 THEN (num*6)+103 WHEN 6873 THEN (num*6)+104 WHEN 7443 THEN (num*6)+105 WHEN 7449 THEN (num*6)+106 WHEN 6876 THEN (num*6)+107 WHEN 7379 THEN (num*6)+108 WHEN 7490 THEN (num*6)+109 WHEN 7330 THEN (num*6)+110 WHEN 7534 THEN (num*6)+111 WHEN 7323 THEN (num*6)+112 WHEN 7390 THEN (num*6)+113 WHEN 7410 THEN (num*6)+114 WHEN 7325 THEN (num*6)+115 WHEN 6871 THEN (num*6)+116 WHEN 7487 THEN (num*6)+117 WHEN 6868 THEN (num*6)+118 WHEN 6317 THEN (num*6)+119 WHEN 7026 THEN (num*6)+120 WHEN 7491 THEN (num*6)+121 WHEN 7423 THEN (num*6)+122 WHEN 7440 THEN (num*6)+123 WHEN 7426 THEN (num*6)+124 WHEN 7434 THEN (num*6)+125 WHEN 7025 THEN (num*6)+126 END,numErr153a