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 volume!=4  AND produit IN(0,8240,4632,6964,9151,9148,9501,9500,9496,6966,9100,9147,9104,9153,8316,9069,9166,9150,9078,9007,9152,9132,7489,9418,9138,9416,9024,9039,9048,9124,8975,9129,8246,8969,8452,6208,9000,9004,8339,6232,9165,9176,8323,8315,9026,6854,7865,7770,9023,7381,8343,9160,8495,8936,9125,8314,9122,8997,8887,5431,6737,2101,4849,9018,9038,9033,5149,9080,7422,8886,6487,8318,8970,9059,8888,9050,5422,7590,5375,7420,9159,8465,9061,7857,8982,9052,9097,9157,5336,7650,8429,8972,8322,9025,8947,8427,8464,4264,9022,8940,8939,9101,9019,8991,5817,8414,8943,6240,9047,8950,8942,8500,9141,8352,8995,8994,8983,9081,9053,8508,8974,8909,4667,8247,7814,8528,8231,7606,9102,9156,6732,8261,5191,9167,7432,6263,7588,8228,8955,8430,8976,9079,8226,8274,7619,7811,4000,6490,8938,8420,8227,7598,9058,8525,8386,8739,6687,8473,8272,8298,8498,8275,7620,8898,7390,7573,8497,8423,7379,8223,7828,7410,7581,7400,7490,7389,6733,8440,8488,3952,7452,6749,7777,8273,5218,7641,7021,7129,7642,6923,8009,5384,8516,7414,7607,8262,7775,8267,8494,7426,5759,6273,7624,8509,7776,4745,8477,7812,8401,8941,9142,9020,8282,8381,9103,7380,7591,8474,8422,7388,7774,6199,1289,5178,7844,7403,4612,7672,6829,7026,8218)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 8240 THEN (num*6)+1 WHEN 4632 THEN (num*6)+2 WHEN 6964 THEN (num*6)+3 WHEN 9151 THEN (num*6)+4 WHEN 9148 THEN (num*6)+5 WHEN 9501 THEN (num*6)+6 WHEN 9500 THEN (num*6)+7 WHEN 9496 THEN (num*6)+8 WHEN 6966 THEN (num*6)+9 WHEN 9100 THEN (num*6)+10 WHEN 9147 THEN (num*6)+11 WHEN 9104 THEN (num*6)+12 WHEN 9153 THEN (num*6)+13 WHEN 8316 THEN (num*6)+14 WHEN 9069 THEN (num*6)+15 WHEN 9166 THEN (num*6)+16 WHEN 9150 THEN (num*6)+17 WHEN 9078 THEN (num*6)+18 WHEN 9007 THEN (num*6)+19 WHEN 9152 THEN (num*6)+20 WHEN 9132 THEN (num*6)+21 WHEN 7489 THEN (num*6)+22 WHEN 9418 THEN (num*6)+23 WHEN 9138 THEN (num*6)+24 WHEN 9416 THEN (num*6)+25 WHEN 9024 THEN (num*6)+26 WHEN 9039 THEN (num*6)+27 WHEN 9048 THEN (num*6)+28 WHEN 9124 THEN (num*6)+29 WHEN 8975 THEN (num*6)+30 WHEN 9129 THEN (num*6)+31 WHEN 8246 THEN (num*6)+32 WHEN 8969 THEN (num*6)+33 WHEN 8452 THEN (num*6)+34 WHEN 6208 THEN (num*6)+35 WHEN 9000 THEN (num*6)+36 WHEN 9004 THEN (num*6)+37 WHEN 8339 THEN (num*6)+38 WHEN 6232 THEN (num*6)+39 WHEN 9165 THEN (num*6)+40 WHEN 9176 THEN (num*6)+41 WHEN 8323 THEN (num*6)+42 WHEN 8315 THEN (num*6)+43 WHEN 9026 THEN (num*6)+44 WHEN 6854 THEN (num*6)+45 WHEN 7865 THEN (num*6)+46 WHEN 7770 THEN (num*6)+47 WHEN 9023 THEN (num*6)+48 WHEN 7381 THEN (num*6)+49 WHEN 8343 THEN (num*6)+50 WHEN 9160 THEN (num*6)+51 WHEN 8495 THEN (num*6)+52 WHEN 8936 THEN (num*6)+53 WHEN 9125 THEN (num*6)+54 WHEN 8314 THEN (num*6)+55 WHEN 9122 THEN (num*6)+56 WHEN 8997 THEN (num*6)+57 WHEN 8887 THEN (num*6)+58 WHEN 5431 THEN (num*6)+59 WHEN 6737 THEN (num*6)+60 WHEN 2101 THEN (num*6)+61 WHEN 4849 THEN (num*6)+62 WHEN 9018 THEN (num*6)+63 WHEN 9038 THEN (num*6)+64 WHEN 9033 THEN (num*6)+65 WHEN 5149 THEN (num*6)+66 WHEN 9080 THEN (num*6)+67 WHEN 7422 THEN (num*6)+68 WHEN 8886 THEN (num*6)+69 WHEN 6487 THEN (num*6)+70 WHEN 8318 THEN (num*6)+71 WHEN 8970 THEN (num*6)+72 WHEN 9059 THEN (num*6)+73 WHEN 8888 THEN (num*6)+74 WHEN 9050 THEN (num*6)+75 WHEN 5422 THEN (num*6)+76 WHEN 7590 THEN (num*6)+77 WHEN 5375 THEN (num*6)+78 WHEN 7420 THEN (num*6)+79 WHEN 9159 THEN (num*6)+80 WHEN 8465 THEN (num*6)+81 WHEN 9061 THEN (num*6)+82 WHEN 7857 THEN (num*6)+83 WHEN 8982 THEN (num*6)+84 WHEN 9052 THEN (num*6)+85 WHEN 9097 THEN (num*6)+86 WHEN 9157 THEN (num*6)+87 WHEN 5336 THEN (num*6)+88 WHEN 7650 THEN (num*6)+89 WHEN 8429 THEN (num*6)+90 WHEN 8972 THEN (num*6)+91 WHEN 8322 THEN (num*6)+92 WHEN 9025 THEN (num*6)+93 WHEN 8947 THEN (num*6)+94 WHEN 8427 THEN (num*6)+95 WHEN 8464 THEN (num*6)+96 WHEN 4264 THEN (num*6)+97 WHEN 9022 THEN (num*6)+98 WHEN 8940 THEN (num*6)+99 WHEN 8939 THEN (num*6)+100 WHEN 9101 THEN (num*6)+101 WHEN 9019 THEN (num*6)+102 WHEN 8991 THEN (num*6)+103 WHEN 5817 THEN (num*6)+104 WHEN 8414 THEN (num*6)+105 WHEN 8943 THEN (num*6)+106 WHEN 6240 THEN (num*6)+107 WHEN 9047 THEN (num*6)+108 WHEN 8950 THEN (num*6)+109 WHEN 8942 THEN (num*6)+110 WHEN 8500 THEN (num*6)+111 WHEN 9141 THEN (num*6)+112 WHEN 8352 THEN (num*6)+113 WHEN 8995 THEN (num*6)+114 WHEN 8994 THEN (num*6)+115 WHEN 8983 THEN (num*6)+116 WHEN 9081 THEN (num*6)+117 WHEN 9053 THEN (num*6)+118 WHEN 8508 THEN (num*6)+119 WHEN 8974 THEN (num*6)+120 WHEN 8909 THEN (num*6)+121 WHEN 4667 THEN (num*6)+122 WHEN 8247 THEN (num*6)+123 WHEN 7814 THEN (num*6)+124 WHEN 8528 THEN (num*6)+125 WHEN 8231 THEN (num*6)+126 WHEN 7606 THEN (num*6)+127 WHEN 9102 THEN (num*6)+128 WHEN 9156 THEN (num*6)+129 WHEN 6732 THEN (num*6)+130 WHEN 8261 THEN (num*6)+131 WHEN 5191 THEN (num*6)+132 WHEN 9167 THEN (num*6)+133 WHEN 7432 THEN (num*6)+134 WHEN 6263 THEN (num*6)+135 WHEN 7588 THEN (num*6)+136 WHEN 8228 THEN (num*6)+137 WHEN 8955 THEN (num*6)+138 WHEN 8430 THEN (num*6)+139 WHEN 8976 THEN (num*6)+140 WHEN 9079 THEN (num*6)+141 WHEN 8226 THEN (num*6)+142 WHEN 8274 THEN (num*6)+143 WHEN 7619 THEN (num*6)+144 WHEN 7811 THEN (num*6)+145 WHEN 4000 THEN (num*6)+146 WHEN 6490 THEN (num*6)+147 WHEN 8938 THEN (num*6)+148 WHEN 8420 THEN (num*6)+149 WHEN 8227 THEN (num*6)+150 WHEN 7598 THEN (num*6)+151 WHEN 9058 THEN (num*6)+152 WHEN 8525 THEN (num*6)+153 WHEN 8386 THEN (num*6)+154 WHEN 8739 THEN (num*6)+155 WHEN 6687 THEN (num*6)+156 WHEN 8473 THEN (num*6)+157 WHEN 8272 THEN (num*6)+158 WHEN 8298 THEN (num*6)+159 WHEN 8498 THEN (num*6)+160 WHEN 8275 THEN (num*6)+161 WHEN 7620 THEN (num*6)+162 WHEN 8898 THEN (num*6)+163 WHEN 7390 THEN (num*6)+164 WHEN 7573 THEN (num*6)+165 WHEN 8497 THEN (num*6)+166 WHEN 8423 THEN (num*6)+167 WHEN 7379 THEN (num*6)+168 WHEN 8223 THEN (num*6)+169 WHEN 7828 THEN (num*6)+170 WHEN 7410 THEN (num*6)+171 WHEN 7581 THEN (num*6)+172 WHEN 7400 THEN (num*6)+173 WHEN 7490 THEN (num*6)+174 WHEN 7389 THEN (num*6)+175 WHEN 6733 THEN (num*6)+176 WHEN 8440 THEN (num*6)+177 WHEN 8488 THEN (num*6)+178 WHEN 3952 THEN (num*6)+179 WHEN 7452 THEN (num*6)+180 WHEN 6749 THEN (num*6)+181 WHEN 7777 THEN (num*6)+182 WHEN 8273 THEN (num*6)+183 WHEN 5218 THEN (num*6)+184 WHEN 7641 THEN (num*6)+185 WHEN 7021 THEN (num*6)+186 WHEN 7129 THEN (num*6)+187 WHEN 7642 THEN (num*6)+188 WHEN 6923 THEN (num*6)+189 WHEN 8009 THEN (num*6)+190 WHEN 5384 THEN (num*6)+191 WHEN 8516 THEN (num*6)+192 WHEN 7414 THEN (num*6)+193 WHEN 7607 THEN (num*6)+194 WHEN 8262 THEN (num*6)+195 WHEN 7775 THEN (num*6)+196 WHEN 8267 THEN (num*6)+197 WHEN 8494 THEN (num*6)+198 WHEN 7426 THEN (num*6)+199 WHEN 5759 THEN (num*6)+200 WHEN 6273 THEN (num*6)+201 WHEN 7624 THEN (num*6)+202 WHEN 8509 THEN (num*6)+203 WHEN 7776 THEN (num*6)+204 WHEN 4745 THEN (num*6)+205 WHEN 8477 THEN (num*6)+206 WHEN 7812 THEN (num*6)+207 WHEN 8401 THEN (num*6)+208 WHEN 8941 THEN (num*6)+209 WHEN 9142 THEN (num*6)+210 WHEN 9020 THEN (num*6)+211 WHEN 8282 THEN (num*6)+212 WHEN 8381 THEN (num*6)+213 WHEN 9103 THEN (num*6)+214 WHEN 7380 THEN (num*6)+215 WHEN 7591 THEN (num*6)+216 WHEN 8474 THEN (num*6)+217 WHEN 8422 THEN (num*6)+218 WHEN 7388 THEN (num*6)+219 WHEN 7774 THEN (num*6)+220 WHEN 6199 THEN (num*6)+221 WHEN 1289 THEN (num*6)+222 WHEN 5178 THEN (num*6)+223 WHEN 7844 THEN (num*6)+224 WHEN 7403 THEN (num*6)+225 WHEN 4612 THEN (num*6)+226 WHEN 7672 THEN (num*6)+227 WHEN 6829 THEN (num*6)+228 WHEN 7026 THEN (num*6)+229 WHEN 8218 THEN (num*6)+230 END,numErr153a