SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,9132,8845,9018,8256,7770,9141,9079,9081,4849,9080,9019,5375,4264,3989,8386,6732,5431,8464,4205,5817,9103,8898,6263,6737,5191,8508,8261,6204,8493,2991,8862,6727,7771,3432,8473,6240,8415,6200,8839,8834,8163,8383,4368,8416,8076,7767,6302,8258,7800,8758,8138,3680,8421,8759,6306,7778,5481,7763,8260,8381,8253,8784,7971,8255,8384,8137,7282,8254,8136,6383,6749,8135,6733,7276,7972,7974,6729,7970,8863,8494,8411,8141,7272,7277,8419,7973,7780,6813,8382,6741,8836,8385,7775,8413,8262,8835,8052,7777,7779,7273,7803,8763,7774,8785,8838,9102,9020,9142,5293,8833,7801,7768,7776,8509,7875,4745,8391,8844,6199,8786,8760,6816,7281,7270,7271,8142,7969,6301,7274,8837,5849)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%55%'ORDER BY CASE produit WHEN 9132 THEN (num*6)+1 WHEN 8845 THEN (num*6)+2 WHEN 9018 THEN (num*6)+3 WHEN 8256 THEN (num*6)+4 WHEN 7770 THEN (num*6)+5 WHEN 9141 THEN (num*6)+6 WHEN 9079 THEN (num*6)+7 WHEN 9081 THEN (num*6)+8 WHEN 4849 THEN (num*6)+9 WHEN 9080 THEN (num*6)+10 WHEN 9019 THEN (num*6)+11 WHEN 5375 THEN (num*6)+12 WHEN 4264 THEN (num*6)+13 WHEN 3989 THEN (num*6)+14 WHEN 8386 THEN (num*6)+15 WHEN 6732 THEN (num*6)+16 WHEN 5431 THEN (num*6)+17 WHEN 8464 THEN (num*6)+18 WHEN 4205 THEN (num*6)+19 WHEN 5817 THEN (num*6)+20 WHEN 9103 THEN (num*6)+21 WHEN 8898 THEN (num*6)+22 WHEN 6263 THEN (num*6)+23 WHEN 6737 THEN (num*6)+24 WHEN 5191 THEN (num*6)+25 WHEN 8508 THEN (num*6)+26 WHEN 8261 THEN (num*6)+27 WHEN 6204 THEN (num*6)+28 WHEN 8493 THEN (num*6)+29 WHEN 2991 THEN (num*6)+30 WHEN 8862 THEN (num*6)+31 WHEN 6727 THEN (num*6)+32 WHEN 7771 THEN (num*6)+33 WHEN 3432 THEN (num*6)+34 WHEN 8473 THEN (num*6)+35 WHEN 6240 THEN (num*6)+36 WHEN 8415 THEN (num*6)+37 WHEN 6200 THEN (num*6)+38 WHEN 8839 THEN (num*6)+39 WHEN 8834 THEN (num*6)+40 WHEN 8163 THEN (num*6)+41 WHEN 8383 THEN (num*6)+42 WHEN 4368 THEN (num*6)+43 WHEN 8416 THEN (num*6)+44 WHEN 8076 THEN (num*6)+45 WHEN 7767 THEN (num*6)+46 WHEN 6302 THEN (num*6)+47 WHEN 8258 THEN (num*6)+48 WHEN 7800 THEN (num*6)+49 WHEN 8758 THEN (num*6)+50 WHEN 8138 THEN (num*6)+51 WHEN 3680 THEN (num*6)+52 WHEN 8421 THEN (num*6)+53 WHEN 8759 THEN (num*6)+54 WHEN 6306 THEN (num*6)+55 WHEN 7778 THEN (num*6)+56 WHEN 5481 THEN (num*6)+57 WHEN 7763 THEN (num*6)+58 WHEN 8260 THEN (num*6)+59 WHEN 8381 THEN (num*6)+60 WHEN 8253 THEN (num*6)+61 WHEN 8784 THEN (num*6)+62 WHEN 7971 THEN (num*6)+63 WHEN 8255 THEN (num*6)+64 WHEN 8384 THEN (num*6)+65 WHEN 8137 THEN (num*6)+66 WHEN 7282 THEN (num*6)+67 WHEN 8254 THEN (num*6)+68 WHEN 8136 THEN (num*6)+69 WHEN 6383 THEN (num*6)+70 WHEN 6749 THEN (num*6)+71 WHEN 8135 THEN (num*6)+72 WHEN 6733 THEN (num*6)+73 WHEN 7276 THEN (num*6)+74 WHEN 7972 THEN (num*6)+75 WHEN 7974 THEN (num*6)+76 WHEN 6729 THEN (num*6)+77 WHEN 7970 THEN (num*6)+78 WHEN 8863 THEN (num*6)+79 WHEN 8494 THEN (num*6)+80 WHEN 8411 THEN (num*6)+81 WHEN 8141 THEN (num*6)+82 WHEN 7272 THEN (num*6)+83 WHEN 7277 THEN (num*6)+84 WHEN 8419 THEN (num*6)+85 WHEN 7973 THEN (num*6)+86 WHEN 7780 THEN (num*6)+87 WHEN 6813 THEN (num*6)+88 WHEN 8382 THEN (num*6)+89 WHEN 6741 THEN (num*6)+90 WHEN 8836 THEN (num*6)+91 WHEN 8385 THEN (num*6)+92 WHEN 7775 THEN (num*6)+93 WHEN 8413 THEN (num*6)+94 WHEN 8262 THEN (num*6)+95 WHEN 8835 THEN (num*6)+96 WHEN 8052 THEN (num*6)+97 WHEN 7777 THEN (num*6)+98 WHEN 7779 THEN (num*6)+99 WHEN 7273 THEN (num*6)+100 WHEN 7803 THEN (num*6)+101 WHEN 8763 THEN (num*6)+102 WHEN 7774 THEN (num*6)+103 WHEN 8785 THEN (num*6)+104 WHEN 8838 THEN (num*6)+105 WHEN 9102 THEN (num*6)+106 WHEN 9020 THEN (num*6)+107 WHEN 9142 THEN (num*6)+108 WHEN 5293 THEN (num*6)+109 WHEN 8833 THEN (num*6)+110 WHEN 7801 THEN (num*6)+111 WHEN 7768 THEN (num*6)+112 WHEN 7776 THEN (num*6)+113 WHEN 8509 THEN (num*6)+114 WHEN 7875 THEN (num*6)+115 WHEN 4745 THEN (num*6)+116 WHEN 8391 THEN (num*6)+117 WHEN 8844 THEN (num*6)+118 WHEN 6199 THEN (num*6)+119 WHEN 8786 THEN (num*6)+120 WHEN 8760 THEN (num*6)+121 WHEN 6816 THEN (num*6)+122 WHEN 7281 THEN (num*6)+123 WHEN 7270 THEN (num*6)+124 WHEN 7271 THEN (num*6)+125 WHEN 8142 THEN (num*6)+126 WHEN 7969 THEN (num*6)+127 WHEN 6301 THEN (num*6)+128 WHEN 7274 THEN (num*6)+129 WHEN 8837 THEN (num*6)+130 WHEN 5849 THEN (num*6)+131 END,numErr153a