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,6504,8176,6377,9409,9410,9524,9519,9518,9484,9478,8790,8809,9450,9423,9143,9305,9362,9322,8869,9363,9391,9390,8599,9360,9327,8807,6474,9206,9202,8842,6376,9336,5542,3140,8866,8020,8870,6375,8820,6506,8789,8166,8875,8782,6473,6505,8732,6603,6476,8167,3609,5031,8788,8691,8783,6564,7133,8697,8765,7531,5511,6495,8822,6565,6497,8794,8635,5030,7474,8126,8744,7236,5541,8596,8684,6508,8634,8627,8633,8632,8766,6496,6151,8693,8630,5093,6475,7295,7937,7538,8631,7995,7355,7247,7398,8008,7224,7251,7248,8808,7245,7318,6499,8075,7753,6365,8129,6493,7959,8051,7249,6364,8694,7957,8014,5696,8823,7353,8871,7152,8095,7357,7308,7639,8055)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 6504 THEN (num*6)+1 WHEN 8176 THEN (num*6)+2 WHEN 6377 THEN (num*6)+3 WHEN 9409 THEN (num*6)+4 WHEN 9410 THEN (num*6)+5 WHEN 9524 THEN (num*6)+6 WHEN 9519 THEN (num*6)+7 WHEN 9518 THEN (num*6)+8 WHEN 9484 THEN (num*6)+9 WHEN 9478 THEN (num*6)+10 WHEN 8790 THEN (num*6)+11 WHEN 8809 THEN (num*6)+12 WHEN 9450 THEN (num*6)+13 WHEN 9423 THEN (num*6)+14 WHEN 9143 THEN (num*6)+15 WHEN 9305 THEN (num*6)+16 WHEN 9362 THEN (num*6)+17 WHEN 9322 THEN (num*6)+18 WHEN 8869 THEN (num*6)+19 WHEN 9363 THEN (num*6)+20 WHEN 9391 THEN (num*6)+21 WHEN 9390 THEN (num*6)+22 WHEN 8599 THEN (num*6)+23 WHEN 9360 THEN (num*6)+24 WHEN 9327 THEN (num*6)+25 WHEN 8807 THEN (num*6)+26 WHEN 6474 THEN (num*6)+27 WHEN 9206 THEN (num*6)+28 WHEN 9202 THEN (num*6)+29 WHEN 8842 THEN (num*6)+30 WHEN 6376 THEN (num*6)+31 WHEN 9336 THEN (num*6)+32 WHEN 5542 THEN (num*6)+33 WHEN 3140 THEN (num*6)+34 WHEN 8866 THEN (num*6)+35 WHEN 8020 THEN (num*6)+36 WHEN 8870 THEN (num*6)+37 WHEN 6375 THEN (num*6)+38 WHEN 8820 THEN (num*6)+39 WHEN 6506 THEN (num*6)+40 WHEN 8789 THEN (num*6)+41 WHEN 8166 THEN (num*6)+42 WHEN 8875 THEN (num*6)+43 WHEN 8782 THEN (num*6)+44 WHEN 6473 THEN (num*6)+45 WHEN 6505 THEN (num*6)+46 WHEN 8732 THEN (num*6)+47 WHEN 6603 THEN (num*6)+48 WHEN 6476 THEN (num*6)+49 WHEN 8167 THEN (num*6)+50 WHEN 3609 THEN (num*6)+51 WHEN 5031 THEN (num*6)+52 WHEN 8788 THEN (num*6)+53 WHEN 8691 THEN (num*6)+54 WHEN 8783 THEN (num*6)+55 WHEN 6564 THEN (num*6)+56 WHEN 7133 THEN (num*6)+57 WHEN 8697 THEN (num*6)+58 WHEN 8765 THEN (num*6)+59 WHEN 7531 THEN (num*6)+60 WHEN 5511 THEN (num*6)+61 WHEN 6495 THEN (num*6)+62 WHEN 8822 THEN (num*6)+63 WHEN 6565 THEN (num*6)+64 WHEN 6497 THEN (num*6)+65 WHEN 8794 THEN (num*6)+66 WHEN 8635 THEN (num*6)+67 WHEN 5030 THEN (num*6)+68 WHEN 7474 THEN (num*6)+69 WHEN 8126 THEN (num*6)+70 WHEN 8744 THEN (num*6)+71 WHEN 7236 THEN (num*6)+72 WHEN 5541 THEN (num*6)+73 WHEN 8596 THEN (num*6)+74 WHEN 8684 THEN (num*6)+75 WHEN 6508 THEN (num*6)+76 WHEN 8634 THEN (num*6)+77 WHEN 8627 THEN (num*6)+78 WHEN 8633 THEN (num*6)+79 WHEN 8632 THEN (num*6)+80 WHEN 8766 THEN (num*6)+81 WHEN 6496 THEN (num*6)+82 WHEN 6151 THEN (num*6)+83 WHEN 8693 THEN (num*6)+84 WHEN 8630 THEN (num*6)+85 WHEN 5093 THEN (num*6)+86 WHEN 6475 THEN (num*6)+87 WHEN 7295 THEN (num*6)+88 WHEN 7937 THEN (num*6)+89 WHEN 7538 THEN (num*6)+90 WHEN 8631 THEN (num*6)+91 WHEN 7995 THEN (num*6)+92 WHEN 7355 THEN (num*6)+93 WHEN 7247 THEN (num*6)+94 WHEN 7398 THEN (num*6)+95 WHEN 8008 THEN (num*6)+96 WHEN 7224 THEN (num*6)+97 WHEN 7251 THEN (num*6)+98 WHEN 7248 THEN (num*6)+99 WHEN 8808 THEN (num*6)+100 WHEN 7245 THEN (num*6)+101 WHEN 7318 THEN (num*6)+102 WHEN 6499 THEN (num*6)+103 WHEN 8075 THEN (num*6)+104 WHEN 7753 THEN (num*6)+105 WHEN 6365 THEN (num*6)+106 WHEN 8129 THEN (num*6)+107 WHEN 6493 THEN (num*6)+108 WHEN 7959 THEN (num*6)+109 WHEN 8051 THEN (num*6)+110 WHEN 7249 THEN (num*6)+111 WHEN 6364 THEN (num*6)+112 WHEN 8694 THEN (num*6)+113 WHEN 7957 THEN (num*6)+114 WHEN 8014 THEN (num*6)+115 WHEN 5696 THEN (num*6)+116 WHEN 8823 THEN (num*6)+117 WHEN 7353 THEN (num*6)+118 WHEN 8871 THEN (num*6)+119 WHEN 7152 THEN (num*6)+120 WHEN 8095 THEN (num*6)+121 WHEN 7357 THEN (num*6)+122 WHEN 7308 THEN (num*6)+123 WHEN 7639 THEN (num*6)+124 WHEN 8055 THEN (num*6)+125 END,numErr153a