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,8419,8385,7800,8383,8384,8258,7763,8256,9433,2991,8254,8416,8255,8415,7767,8834,8253,7771,8421,8260,9439,7778,9436,7803,9324,7801,8163,9325,9435,9438,9437,9434,8844,6302,4368,8763,9483,9482,9481,9480,8845,9440,9432,9431,9132,6306,7971,8137,6204,7770,8138,4849,5431,8261,9018,9081,6737,4205,8508,9080,9141,3432,4264,5375,8464,3989,5817,6240,7282,6732,9079,8076,8839,9019,5191,8136,8386,8473,3680,9102,6200,7972,6727,8493,6263,5293,6383,7276,8898,8135,7270,6733,8837,8786,7776,4745,7875,6749,8381,9103,8862,8784,8391,7774)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 8419 THEN (num*4)+1 WHEN 8385 THEN (num*4)+2 WHEN 7800 THEN (num*4)+3 WHEN 8383 THEN (num*4)+4 WHEN 8384 THEN (num*4)+5 WHEN 8258 THEN (num*4)+6 WHEN 7763 THEN (num*4)+7 WHEN 8256 THEN (num*4)+8 WHEN 9433 THEN (num*4)+9 WHEN 2991 THEN (num*4)+10 WHEN 8254 THEN (num*4)+11 WHEN 8416 THEN (num*4)+12 WHEN 8255 THEN (num*4)+13 WHEN 8415 THEN (num*4)+14 WHEN 7767 THEN (num*4)+15 WHEN 8834 THEN (num*4)+16 WHEN 8253 THEN (num*4)+17 WHEN 7771 THEN (num*4)+18 WHEN 8421 THEN (num*4)+19 WHEN 8260 THEN (num*4)+20 WHEN 9439 THEN (num*4)+21 WHEN 7778 THEN (num*4)+22 WHEN 9436 THEN (num*4)+23 WHEN 7803 THEN (num*4)+24 WHEN 9324 THEN (num*4)+25 WHEN 7801 THEN (num*4)+26 WHEN 8163 THEN (num*4)+27 WHEN 9325 THEN (num*4)+28 WHEN 9435 THEN (num*4)+29 WHEN 9438 THEN (num*4)+30 WHEN 9437 THEN (num*4)+31 WHEN 9434 THEN (num*4)+32 WHEN 8844 THEN (num*4)+33 WHEN 6302 THEN (num*4)+34 WHEN 4368 THEN (num*4)+35 WHEN 8763 THEN (num*4)+36 WHEN 9483 THEN (num*4)+37 WHEN 9482 THEN (num*4)+38 WHEN 9481 THEN (num*4)+39 WHEN 9480 THEN (num*4)+40 WHEN 8845 THEN (num*4)+41 WHEN 9440 THEN (num*4)+42 WHEN 9432 THEN (num*4)+43 WHEN 9431 THEN (num*4)+44 WHEN 9132 THEN (num*4)+45 WHEN 6306 THEN (num*4)+46 WHEN 7971 THEN (num*4)+47 WHEN 8137 THEN (num*4)+48 WHEN 6204 THEN (num*4)+49 WHEN 7770 THEN (num*4)+50 WHEN 8138 THEN (num*4)+51 WHEN 4849 THEN (num*4)+52 WHEN 5431 THEN (num*4)+53 WHEN 8261 THEN (num*4)+54 WHEN 9018 THEN (num*4)+55 WHEN 9081 THEN (num*4)+56 WHEN 6737 THEN (num*4)+57 WHEN 4205 THEN (num*4)+58 WHEN 8508 THEN (num*4)+59 WHEN 9080 THEN (num*4)+60 WHEN 9141 THEN (num*4)+61 WHEN 3432 THEN (num*4)+62 WHEN 4264 THEN (num*4)+63 WHEN 5375 THEN (num*4)+64 WHEN 8464 THEN (num*4)+65 WHEN 3989 THEN (num*4)+66 WHEN 5817 THEN (num*4)+67 WHEN 6240 THEN (num*4)+68 WHEN 7282 THEN (num*4)+69 WHEN 6732 THEN (num*4)+70 WHEN 9079 THEN (num*4)+71 WHEN 8076 THEN (num*4)+72 WHEN 8839 THEN (num*4)+73 WHEN 9019 THEN (num*4)+74 WHEN 5191 THEN (num*4)+75 WHEN 8136 THEN (num*4)+76 WHEN 8386 THEN (num*4)+77 WHEN 8473 THEN (num*4)+78 WHEN 3680 THEN (num*4)+79 WHEN 9102 THEN (num*4)+80 WHEN 6200 THEN (num*4)+81 WHEN 7972 THEN (num*4)+82 WHEN 6727 THEN (num*4)+83 WHEN 8493 THEN (num*4)+84 WHEN 6263 THEN (num*4)+85 WHEN 5293 THEN (num*4)+86 WHEN 6383 THEN (num*4)+87 WHEN 7276 THEN (num*4)+88 WHEN 8898 THEN (num*4)+89 WHEN 8135 THEN (num*4)+90 WHEN 7270 THEN (num*4)+91 WHEN 6733 THEN (num*4)+92 WHEN 8837 THEN (num*4)+93 WHEN 8786 THEN (num*4)+94 WHEN 7776 THEN (num*4)+95 WHEN 4745 THEN (num*4)+96 WHEN 7875 THEN (num*4)+97 WHEN 6749 THEN (num*4)+98 WHEN 8381 THEN (num*4)+99 WHEN 9103 THEN (num*4)+100 WHEN 8862 THEN (num*4)+101 WHEN 8784 THEN (num*4)+102 WHEN 8391 THEN (num*4)+103 WHEN 7774 THEN (num*4)+104 END,numErr153a