SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_ko 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,9352,9380,7897,7226,5326,8452,2104,7898,8960,7887,6962,8319,4632,9150,9146,7892,7895,5950,9119,9151,9092,9062,9148,9132,9440,9502,9501,9500,9497,9496,9417,9483,9426,9418,9416,9089,9408,9326,9298,9242,9090,9199,9198,9197,9134,9131,9012,9128,9176,9160,9033,9153,9149,9024,9023,9137,9027,9125,9124,9123,9122,9026,9141,9061,9081,9080,9126,9001,9051,9114,9041,9039,8992,9000,8321,9031,8241,8975,9009,6232,9165,8983,9008,9007,6208,9145,9003,9144,7437,9025,7770,8323,8160,6960,9004,9129,9060,5375,9127,9022,8986,8893,8469,8984,9028,8982,9157,8981,8462,8495,8913,8600,6737,8972,8987,9018,7589,8240,8460,8467,6963,8609,8522,8468,9002,4640,5329,8995,8943,6961,9110,3855,8994,6968,9105,7386,8610,8991,8500,8717,9167,8940,8968,8084,8939,8461,8892,8966,6854,5336,7729,6955,8466,9059,8936,8950,8888,8559,9055,4667,6959,9049,8912,8463,5760,8942,8911,8566,8315,8453,5831,8465,8428,6261,8970,8339,8969,5149,4849,8318,8314,6694,8231,8937,7442,6169,7381,8250,8886,8242,9019,6853,8564,8567,8945,8884,7391,8529,8978,8880,7813,8427,9079,3432,5431,5422,7422,7384,2101,7857,9156,8341,8985,8454,8527,8226,8429,8261,6240,8505,8433,8235,8976,8352,8526,6706,8478,7428,8432,8322,8222,2609,7383,8528,5817,9103,4678,9102,8464,8520,8228,8955,6284,3918,8232,8338,8271,7814,8264,8504,7585,8237,7650,6888,7923,8230,8336,8430,7588,8239,8973,3989,8938,5332,8247,4205,5191,7586,7323,6200,8473,8862,7436,8233,6883,7576,5816,7446,7649,6732,7430,8217,7444,8498,6864,8023,7811,8227,8214,7619,7438,8420,6887,5182,8481,8213,8332,8885,7011,6958,8479,8386,8441,8493,7447,7573,7870,8272,7427,8438,8497,7816,7815,7429,8423,3254,7783,8417,7620,7644,8298,6692,7899,6691,7581,7441,8234,8440,8898,5293,8381,7390,7400,7379,6733,7443,7389,7410,7490,7435,6668,8840,3952,3362,7452,8488,6941,5824,7572,3561,8941,7578,8216,8282,7591,6926,8424,7419,8515,7440,7025,7426,7423,3844,7776,8401,5811,8220,5174,7491,4001,4898,8219,8489,2608,7875,8509,7414,4922,8487,3881,8494,7380,2463,5384,6866,7445,6040,5330,2464,7624,6972,6942,7829,6983,6688,7425,9020,6829,8485,7022,8496,5584,6667,6646,8431,8357,7577,4612,7817,7672,7584,7660,7774,7768,4920,5178,7641,7642,4745,8218,7812,8477,6818,8516,7417,9142,6886,8236,7021,7871,7777,8262,8474,6923,4774,6919,7434,6816,7388,7026,7118,8391,7403,7775)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 9352 THEN (num*6)+1 WHEN 9380 THEN (num*6)+2 WHEN 7897 THEN (num*6)+3 WHEN 7226 THEN (num*6)+4 WHEN 5326 THEN (num*6)+5 WHEN 8452 THEN (num*6)+6 WHEN 2104 THEN (num*6)+7 WHEN 7898 THEN (num*6)+8 WHEN 8960 THEN (num*6)+9 WHEN 7887 THEN (num*6)+10 WHEN 6962 THEN (num*6)+11 WHEN 8319 THEN (num*6)+12 WHEN 4632 THEN (num*6)+13 WHEN 9150 THEN (num*6)+14 WHEN 9146 THEN (num*6)+15 WHEN 7892 THEN (num*6)+16 WHEN 7895 THEN (num*6)+17 WHEN 5950 THEN (num*6)+18 WHEN 9119 THEN (num*6)+19 WHEN 9151 THEN (num*6)+20 WHEN 9092 THEN (num*6)+21 WHEN 9062 THEN (num*6)+22 WHEN 9148 THEN (num*6)+23 WHEN 9132 THEN (num*6)+24 WHEN 9440 THEN (num*6)+25 WHEN 9502 THEN (num*6)+26 WHEN 9501 THEN (num*6)+27 WHEN 9500 THEN (num*6)+28 WHEN 9497 THEN (num*6)+29 WHEN 9496 THEN (num*6)+30 WHEN 9417 THEN (num*6)+31 WHEN 9483 THEN (num*6)+32 WHEN 9426 THEN (num*6)+33 WHEN 9418 THEN (num*6)+34 WHEN 9416 THEN (num*6)+35 WHEN 9089 THEN (num*6)+36 WHEN 9408 THEN (num*6)+37 WHEN 9326 THEN (num*6)+38 WHEN 9298 THEN (num*6)+39 WHEN 9242 THEN (num*6)+40 WHEN 9090 THEN (num*6)+41 WHEN 9199 THEN (num*6)+42 WHEN 9198 THEN (num*6)+43 WHEN 9197 THEN (num*6)+44 WHEN 9134 THEN (num*6)+45 WHEN 9131 THEN (num*6)+46 WHEN 9012 THEN (num*6)+47 WHEN 9128 THEN (num*6)+48 WHEN 9176 THEN (num*6)+49 WHEN 9160 THEN (num*6)+50 WHEN 9033 THEN (num*6)+51 WHEN 9153 THEN (num*6)+52 WHEN 9149 THEN (num*6)+53 WHEN 9024 THEN (num*6)+54 WHEN 9023 THEN (num*6)+55 WHEN 9137 THEN (num*6)+56 WHEN 9027 THEN (num*6)+57 WHEN 9125 THEN (num*6)+58 WHEN 9124 THEN (num*6)+59 WHEN 9123 THEN (num*6)+60 WHEN 9122 THEN (num*6)+61 WHEN 9026 THEN (num*6)+62 WHEN 9141 THEN (num*6)+63 WHEN 9061 THEN (num*6)+64 WHEN 9081 THEN (num*6)+65 WHEN 9080 THEN (num*6)+66 WHEN 9126 THEN (num*6)+67 WHEN 9001 THEN (num*6)+68 WHEN 9051 THEN (num*6)+69 WHEN 9114 THEN (num*6)+70 WHEN 9041 THEN (num*6)+71 WHEN 9039 THEN (num*6)+72 WHEN 8992 THEN (num*6)+73 WHEN 9000 THEN (num*6)+74 WHEN 8321 THEN (num*6)+75 WHEN 9031 THEN (num*6)+76 WHEN 8241 THEN (num*6)+77 WHEN 8975 THEN (num*6)+78 WHEN 9009 THEN (num*6)+79 WHEN 6232 THEN (num*6)+80 WHEN 9165 THEN (num*6)+81 WHEN 8983 THEN (num*6)+82 WHEN 9008 THEN (num*6)+83 WHEN 9007 THEN (num*6)+84 WHEN 6208 THEN (num*6)+85 WHEN 9145 THEN (num*6)+86 WHEN 9003 THEN (num*6)+87 WHEN 9144 THEN (num*6)+88 WHEN 7437 THEN (num*6)+89 WHEN 9025 THEN (num*6)+90 WHEN 7770 THEN (num*6)+91 WHEN 8323 THEN (num*6)+92 WHEN 8160 THEN (num*6)+93 WHEN 6960 THEN (num*6)+94 WHEN 9004 THEN (num*6)+95 WHEN 9129 THEN (num*6)+96 WHEN 9060 THEN (num*6)+97 WHEN 5375 THEN (num*6)+98 WHEN 9127 THEN (num*6)+99 WHEN 9022 THEN (num*6)+100 WHEN 8986 THEN (num*6)+101 WHEN 8893 THEN (num*6)+102 WHEN 8469 THEN (num*6)+103 WHEN 8984 THEN (num*6)+104 WHEN 9028 THEN (num*6)+105 WHEN 8982 THEN (num*6)+106 WHEN 9157 THEN (num*6)+107 WHEN 8981 THEN (num*6)+108 WHEN 8462 THEN (num*6)+109 WHEN 8495 THEN (num*6)+110 WHEN 8913 THEN (num*6)+111 WHEN 8600 THEN (num*6)+112 WHEN 6737 THEN (num*6)+113 WHEN 8972 THEN (num*6)+114 WHEN 8987 THEN (num*6)+115 WHEN 9018 THEN (num*6)+116 WHEN 7589 THEN (num*6)+117 WHEN 8240 THEN (num*6)+118 WHEN 8460 THEN (num*6)+119 WHEN 8467 THEN (num*6)+120 WHEN 6963 THEN (num*6)+121 WHEN 8609 THEN (num*6)+122 WHEN 8522 THEN (num*6)+123 WHEN 8468 THEN (num*6)+124 WHEN 9002 THEN (num*6)+125 WHEN 4640 THEN (num*6)+126 WHEN 5329 THEN (num*6)+127 WHEN 8995 THEN (num*6)+128 WHEN 8943 THEN (num*6)+129 WHEN 6961 THEN (num*6)+130 WHEN 9110 THEN (num*6)+131 WHEN 3855 THEN (num*6)+132 WHEN 8994 THEN (num*6)+133 WHEN 6968 THEN (num*6)+134 WHEN 9105 THEN (num*6)+135 WHEN 7386 THEN (num*6)+136 WHEN 8610 THEN (num*6)+137 WHEN 8991 THEN (num*6)+138 WHEN 8500 THEN (num*6)+139 WHEN 8717 THEN (num*6)+140 WHEN 9167 THEN (num*6)+141 WHEN 8940 THEN (num*6)+142 WHEN 8968 THEN (num*6)+143 WHEN 8084 THEN (num*6)+144 WHEN 8939 THEN (num*6)+145 WHEN 8461 THEN (num*6)+146 WHEN 8892 THEN (num*6)+147 WHEN 8966 THEN (num*6)+148 WHEN 6854 THEN (num*6)+149 WHEN 5336 THEN (num*6)+150 WHEN 7729 THEN (num*6)+151 WHEN 6955 THEN (num*6)+152 WHEN 8466 THEN (num*6)+153 WHEN 9059 THEN (num*6)+154 WHEN 8936 THEN (num*6)+155 WHEN 8950 THEN (num*6)+156 WHEN 8888 THEN (num*6)+157 WHEN 8559 THEN (num*6)+158 WHEN 9055 THEN (num*6)+159 WHEN 4667 THEN (num*6)+160 WHEN 6959 THEN (num*6)+161 WHEN 9049 THEN (num*6)+162 WHEN 8912 THEN (num*6)+163 WHEN 8463 THEN (num*6)+164 WHEN 5760 THEN (num*6)+165 WHEN 8942 THEN (num*6)+166 WHEN 8911 THEN (num*6)+167 WHEN 8566 THEN (num*6)+168 WHEN 8315 THEN (num*6)+169 WHEN 8453 THEN (num*6)+170 WHEN 5831 THEN (num*6)+171 WHEN 8465 THEN (num*6)+172 WHEN 8428 THEN (num*6)+173 WHEN 6261 THEN (num*6)+174 WHEN 8970 THEN (num*6)+175 WHEN 8339 THEN (num*6)+176 WHEN 8969 THEN (num*6)+177 WHEN 5149 THEN (num*6)+178 WHEN 4849 THEN (num*6)+179 WHEN 8318 THEN (num*6)+180 WHEN 8314 THEN (num*6)+181 WHEN 6694 THEN (num*6)+182 WHEN 8231 THEN (num*6)+183 WHEN 8937 THEN (num*6)+184 WHEN 7442 THEN (num*6)+185 WHEN 6169 THEN (num*6)+186 WHEN 7381 THEN (num*6)+187 WHEN 8250 THEN (num*6)+188 WHEN 8886 THEN (num*6)+189 WHEN 8242 THEN (num*6)+190 WHEN 9019 THEN (num*6)+191 WHEN 6853 THEN (num*6)+192 WHEN 8564 THEN (num*6)+193 WHEN 8567 THEN (num*6)+194 WHEN 8945 THEN (num*6)+195 WHEN 8884 THEN (num*6)+196 WHEN 7391 THEN (num*6)+197 WHEN 8529 THEN (num*6)+198 WHEN 8978 THEN (num*6)+199 WHEN 8880 THEN (num*6)+200 WHEN 7813 THEN (num*6)+201 WHEN 8427 THEN (num*6)+202 WHEN 9079 THEN (num*6)+203 WHEN 3432 THEN (num*6)+204 WHEN 5431 THEN (num*6)+205 WHEN 5422 THEN (num*6)+206 WHEN 7422 THEN (num*6)+207 WHEN 7384 THEN (num*6)+208 WHEN 2101 THEN (num*6)+209 WHEN 7857 THEN (num*6)+210 WHEN 9156 THEN (num*6)+211 WHEN 8341 THEN (num*6)+212 WHEN 8985 THEN (num*6)+213 WHEN 8454 THEN (num*6)+214 WHEN 8527 THEN (num*6)+215 WHEN 8226 THEN (num*6)+216 WHEN 8429 THEN (num*6)+217 WHEN 8261 THEN (num*6)+218 WHEN 6240 THEN (num*6)+219 WHEN 8505 THEN (num*6)+220 WHEN 8433 THEN (num*6)+221 WHEN 8235 THEN (num*6)+222 WHEN 8976 THEN (num*6)+223 WHEN 8352 THEN (num*6)+224 WHEN 8526 THEN (num*6)+225 WHEN 6706 THEN (num*6)+226 WHEN 8478 THEN (num*6)+227 WHEN 7428 THEN (num*6)+228 WHEN 8432 THEN (num*6)+229 WHEN 8322 THEN (num*6)+230 WHEN 8222 THEN (num*6)+231 WHEN 2609 THEN (num*6)+232 WHEN 7383 THEN (num*6)+233 WHEN 8528 THEN (num*6)+234 WHEN 5817 THEN (num*6)+235 WHEN 9103 THEN (num*6)+236 WHEN 4678 THEN (num*6)+237 WHEN 9102 THEN (num*6)+238 WHEN 8464 THEN (num*6)+239 WHEN 8520 THEN (num*6)+240 WHEN 8228 THEN (num*6)+241 WHEN 8955 THEN (num*6)+242 WHEN 6284 THEN (num*6)+243 WHEN 3918 THEN (num*6)+244 WHEN 8232 THEN (num*6)+245 WHEN 8338 THEN (num*6)+246 WHEN 8271 THEN (num*6)+247 WHEN 7814 THEN (num*6)+248 WHEN 8264 THEN (num*6)+249 WHEN 8504 THEN (num*6)+250 WHEN 7585 THEN (num*6)+251 WHEN 8237 THEN (num*6)+252 WHEN 7650 THEN (num*6)+253 WHEN 6888 THEN (num*6)+254 WHEN 7923 THEN (num*6)+255 WHEN 8230 THEN (num*6)+256 WHEN 8336 THEN (num*6)+257 WHEN 8430 THEN (num*6)+258 WHEN 7588 THEN (num*6)+259 WHEN 8239 THEN (num*6)+260 WHEN 8973 THEN (num*6)+261 WHEN 3989 THEN (num*6)+262 WHEN 8938 THEN (num*6)+263 WHEN 5332 THEN (num*6)+264 WHEN 8247 THEN (num*6)+265 WHEN 4205 THEN (num*6)+266 WHEN 5191 THEN (num*6)+267 WHEN 7586 THEN (num*6)+268 WHEN 7323 THEN (num*6)+269 WHEN 6200 THEN (num*6)+270 WHEN 8473 THEN (num*6)+271 WHEN 8862 THEN (num*6)+272 WHEN 7436 THEN (num*6)+273 WHEN 8233 THEN (num*6)+274 WHEN 6883 THEN (num*6)+275 WHEN 7576 THEN (num*6)+276 WHEN 5816 THEN (num*6)+277 WHEN 7446 THEN (num*6)+278 WHEN 7649 THEN (num*6)+279 WHEN 6732 THEN (num*6)+280 WHEN 7430 THEN (num*6)+281 WHEN 8217 THEN (num*6)+282 WHEN 7444 THEN (num*6)+283 WHEN 8498 THEN (num*6)+284 WHEN 6864 THEN (num*6)+285 WHEN 8023 THEN (num*6)+286 WHEN 7811 THEN (num*6)+287 WHEN 8227 THEN (num*6)+288 WHEN 8214 THEN (num*6)+289 WHEN 7619 THEN (num*6)+290 WHEN 7438 THEN (num*6)+291 WHEN 8420 THEN (num*6)+292 WHEN 6887 THEN (num*6)+293 WHEN 5182 THEN (num*6)+294 WHEN 8481 THEN (num*6)+295 WHEN 8213 THEN (num*6)+296 WHEN 8332 THEN (num*6)+297 WHEN 8885 THEN (num*6)+298 WHEN 7011 THEN (num*6)+299 WHEN 6958 THEN (num*6)+300 WHEN 8479 THEN (num*6)+301 WHEN 8386 THEN (num*6)+302 WHEN 8441 THEN (num*6)+303 WHEN 8493 THEN (num*6)+304 WHEN 7447 THEN (num*6)+305 WHEN 7573 THEN (num*6)+306 WHEN 7870 THEN (num*6)+307 WHEN 8272 THEN (num*6)+308 WHEN 7427 THEN (num*6)+309 WHEN 8438 THEN (num*6)+310 WHEN 8497 THEN (num*6)+311 WHEN 7816 THEN (num*6)+312 WHEN 7815 THEN (num*6)+313 WHEN 7429 THEN (num*6)+314 WHEN 8423 THEN (num*6)+315 WHEN 3254 THEN (num*6)+316 WHEN 7783 THEN (num*6)+317 WHEN 8417 THEN (num*6)+318 WHEN 7620 THEN (num*6)+319 WHEN 7644 THEN (num*6)+320 WHEN 8298 THEN (num*6)+321 WHEN 6692 THEN (num*6)+322 WHEN 7899 THEN (num*6)+323 WHEN 6691 THEN (num*6)+324 WHEN 7581 THEN (num*6)+325 WHEN 7441 THEN (num*6)+326 WHEN 8234 THEN (num*6)+327 WHEN 8440 THEN (num*6)+328 WHEN 8898 THEN (num*6)+329 WHEN 5293 THEN (num*6)+330 WHEN 8381 THEN (num*6)+331 WHEN 7390 THEN (num*6)+332 WHEN 7400 THEN (num*6)+333 WHEN 7379 THEN (num*6)+334 WHEN 6733 THEN (num*6)+335 WHEN 7443 THEN (num*6)+336 WHEN 7389 THEN (num*6)+337 WHEN 7410 THEN (num*6)+338 WHEN 7490 THEN (num*6)+339 WHEN 7435 THEN (num*6)+340 WHEN 6668 THEN (num*6)+341 WHEN 8840 THEN (num*6)+342 WHEN 3952 THEN (num*6)+343 WHEN 3362 THEN (num*6)+344 WHEN 7452 THEN (num*6)+345 WHEN 8488 THEN (num*6)+346 WHEN 6941 THEN (num*6)+347 WHEN 5824 THEN (num*6)+348 WHEN 7572 THEN (num*6)+349 WHEN 3561 THEN (num*6)+350 WHEN 8941 THEN (num*6)+351 WHEN 7578 THEN (num*6)+352 WHEN 8216 THEN (num*6)+353 WHEN 8282 THEN (num*6)+354 WHEN 7591 THEN (num*6)+355 WHEN 6926 THEN (num*6)+356 WHEN 8424 THEN (num*6)+357 WHEN 7419 THEN (num*6)+358 WHEN 8515 THEN (num*6)+359 WHEN 7440 THEN (num*6)+360 WHEN 7025 THEN (num*6)+361 WHEN 7426 THEN (num*6)+362 WHEN 7423 THEN (num*6)+363 WHEN 3844 THEN (num*6)+364 WHEN 7776 THEN (num*6)+365 WHEN 8401 THEN (num*6)+366 WHEN 5811 THEN (num*6)+367 WHEN 8220 THEN (num*6)+368 WHEN 5174 THEN (num*6)+369 WHEN 7491 THEN (num*6)+370 WHEN 4001 THEN (num*6)+371 WHEN 4898 THEN (num*6)+372 WHEN 8219 THEN (num*6)+373 WHEN 8489 THEN (num*6)+374 WHEN 2608 THEN (num*6)+375 WHEN 7875 THEN (num*6)+376 WHEN 8509 THEN (num*6)+377 WHEN 7414 THEN (num*6)+378 WHEN 4922 THEN (num*6)+379 WHEN 8487 THEN (num*6)+380 WHEN 3881 THEN (num*6)+381 WHEN 8494 THEN (num*6)+382 WHEN 7380 THEN (num*6)+383 WHEN 2463 THEN (num*6)+384 WHEN 5384 THEN (num*6)+385 WHEN 6866 THEN (num*6)+386 WHEN 7445 THEN (num*6)+387 WHEN 6040 THEN (num*6)+388 WHEN 5330 THEN (num*6)+389 WHEN 2464 THEN (num*6)+390 WHEN 7624 THEN (num*6)+391 WHEN 6972 THEN (num*6)+392 WHEN 6942 THEN (num*6)+393 WHEN 7829 THEN (num*6)+394 WHEN 6983 THEN (num*6)+395 WHEN 6688 THEN (num*6)+396 WHEN 7425 THEN (num*6)+397 WHEN 9020 THEN (num*6)+398 WHEN 6829 THEN (num*6)+399 WHEN 8485 THEN (num*6)+400 WHEN 7022 THEN (num*6)+401 WHEN 8496 THEN (num*6)+402 WHEN 5584 THEN (num*6)+403 WHEN 6667 THEN (num*6)+404 WHEN 6646 THEN (num*6)+405 WHEN 8431 THEN (num*6)+406 WHEN 8357 THEN (num*6)+407 WHEN 7577 THEN (num*6)+408 WHEN 4612 THEN (num*6)+409 WHEN 7817 THEN (num*6)+410 WHEN 7672 THEN (num*6)+411 WHEN 7584 THEN (num*6)+412 WHEN 7660 THEN (num*6)+413 WHEN 7774 THEN (num*6)+414 WHEN 7768 THEN (num*6)+415 WHEN 4920 THEN (num*6)+416 WHEN 5178 THEN (num*6)+417 WHEN 7641 THEN (num*6)+418 WHEN 7642 THEN (num*6)+419 WHEN 4745 THEN (num*6)+420 WHEN 8218 THEN (num*6)+421 WHEN 7812 THEN (num*6)+422 WHEN 8477 THEN (num*6)+423 WHEN 6818 THEN (num*6)+424 WHEN 8516 THEN (num*6)+425 WHEN 7417 THEN (num*6)+426 WHEN 9142 THEN (num*6)+427 WHEN 6886 THEN (num*6)+428 WHEN 8236 THEN (num*6)+429 WHEN 7021 THEN (num*6)+430 WHEN 7871 THEN (num*6)+431 WHEN 7777 THEN (num*6)+432 WHEN 8262 THEN (num*6)+433 WHEN 8474 THEN (num*6)+434 WHEN 6923 THEN (num*6)+435 WHEN 4774 THEN (num*6)+436 WHEN 6919 THEN (num*6)+437 WHEN 7434 THEN (num*6)+438 WHEN 6816 THEN (num*6)+439 WHEN 7388 THEN (num*6)+440 WHEN 7026 THEN (num*6)+441 WHEN 7118 THEN (num*6)+442 WHEN 8391 THEN (num*6)+443 WHEN 7403 THEN (num*6)+444 WHEN 7775 THEN (num*6)+445 END,numErr153a