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,9166,9097,9151,9054,9176,9147,9028,9100,9165,9148,8974,9090,9150,2104,9124,9167,9089,8968,9026,9128,8909,9106,9153,9022,9157,9132,9129,9159,9078,6879,9127,8993,9101,9050,2609,9126,9049,9123,9102,9104,9154,9007,4632,8978,9038,9004,8452,9018,6968,9069,8453,6964,9119,8972,3855,9081,6880,4640,9418,6961,8955,9061,9033,9057,9000,6963,8975,8893,9141,8891,9055,8989,9125,9098,9002,9079,4849,7865,5760,9027,8913,2610,9060,8945,9241,8990,7489,9003,8889,9047,8997,8243,9149,7892,8241,6962,9059,9080,8939,6959,8912,9056,9152,8495,7888,9133,6208,8949,9146,9012,8314,9138,8339,3027,9416,8985,9408,8994,6881,4264,9023,8970,9156,8242,8240,8943,8888,9025,9052,8983,6706,8987,9053,9024,8976,8316,6232,8938,7867,8973,8995,1823,8886,8892,7381,9048,5149,6853,6854,7471,9229,9114,5375,9137,8340,9160,7770,8465,8386,6732,9051,6169,7866,8937,7576,5336,7893,8999,8984,8992,8991,6694,8315,8529,8911,8454,8982,9019,9122,8464,8341,8456,7894,8338,8885,8942,5329,9058,9032,7923,7887,8884,8880,5431,6263,7391,8250,6966,8428,7422,8462,7816,5816,6960,9039,9041,8248,8432,2101,8484,9008,5817,8969,8981,8323,3028,8840,8343,8528,8418,8322,5831,8429,8950,8887,9031,5182,8473,9009,1294,8947,7420,7599,7384,8352,7589,8414,8427,5422,589,8986,8268,6967,8936,8230,7386,8497,3846,8508,8420,8480,8275,8213,4622,7811,7814,8493,8488,7585,8223,3004,8504,8898,8225,6487,8318,6737,7387,8940,3432,5191,8469,7619,8520,8417,8430,8468,4667,8261,7813,7644,8467,8466,8214,7586,8739,8272,8463,7432,7857,8332,7606,8460,6240,8239,8298,6200,8246,8231,8470,8438,8227,8525,8498,7649,8437,6490,8499,7815,8228,8478,7590,8247,8461,7400,8233,8217,8336,8271,7411,7428,8433,7598,7011,8440,8232,3952,8276,8441,6261,7650,8479,8500,6687,7658,8526,7389,8235,8226,8527,8664,3254,8510,7587,7573,8274,5175,7379,7588,7385,7633,7632,7490,7620,6982,7875,8237,7390,8335,4000,8229,8423,8481,7410,6733,8234,6749,6691,7828,7581,8337,9103,7829,8215,3362,6692,8381,8516,8009,5759,8391,8425,4920,7388,3561,6786,7672,8216,8485,7903,7774,8401,7583,8487,7642,5384,8515,7026,8357,7491,8477,5924,9099,8941,7577,6885,7021,2602,6688,8334,4745,8282,5178,7624,7426,8422,4612,8424,6829,7776,5824,2003,7025,7643,7414)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%56%'ORDER BY CASE produit WHEN 9166 THEN (num*6)+1 WHEN 9097 THEN (num*6)+2 WHEN 9151 THEN (num*6)+3 WHEN 9054 THEN (num*6)+4 WHEN 9176 THEN (num*6)+5 WHEN 9147 THEN (num*6)+6 WHEN 9028 THEN (num*6)+7 WHEN 9100 THEN (num*6)+8 WHEN 9165 THEN (num*6)+9 WHEN 9148 THEN (num*6)+10 WHEN 8974 THEN (num*6)+11 WHEN 9090 THEN (num*6)+12 WHEN 9150 THEN (num*6)+13 WHEN 2104 THEN (num*6)+14 WHEN 9124 THEN (num*6)+15 WHEN 9167 THEN (num*6)+16 WHEN 9089 THEN (num*6)+17 WHEN 8968 THEN (num*6)+18 WHEN 9026 THEN (num*6)+19 WHEN 9128 THEN (num*6)+20 WHEN 8909 THEN (num*6)+21 WHEN 9106 THEN (num*6)+22 WHEN 9153 THEN (num*6)+23 WHEN 9022 THEN (num*6)+24 WHEN 9157 THEN (num*6)+25 WHEN 9132 THEN (num*6)+26 WHEN 9129 THEN (num*6)+27 WHEN 9159 THEN (num*6)+28 WHEN 9078 THEN (num*6)+29 WHEN 6879 THEN (num*6)+30 WHEN 9127 THEN (num*6)+31 WHEN 8993 THEN (num*6)+32 WHEN 9101 THEN (num*6)+33 WHEN 9050 THEN (num*6)+34 WHEN 2609 THEN (num*6)+35 WHEN 9126 THEN (num*6)+36 WHEN 9049 THEN (num*6)+37 WHEN 9123 THEN (num*6)+38 WHEN 9102 THEN (num*6)+39 WHEN 9104 THEN (num*6)+40 WHEN 9154 THEN (num*6)+41 WHEN 9007 THEN (num*6)+42 WHEN 4632 THEN (num*6)+43 WHEN 8978 THEN (num*6)+44 WHEN 9038 THEN (num*6)+45 WHEN 9004 THEN (num*6)+46 WHEN 8452 THEN (num*6)+47 WHEN 9018 THEN (num*6)+48 WHEN 6968 THEN (num*6)+49 WHEN 9069 THEN (num*6)+50 WHEN 8453 THEN (num*6)+51 WHEN 6964 THEN (num*6)+52 WHEN 9119 THEN (num*6)+53 WHEN 8972 THEN (num*6)+54 WHEN 3855 THEN (num*6)+55 WHEN 9081 THEN (num*6)+56 WHEN 6880 THEN (num*6)+57 WHEN 4640 THEN (num*6)+58 WHEN 9418 THEN (num*6)+59 WHEN 6961 THEN (num*6)+60 WHEN 8955 THEN (num*6)+61 WHEN 9061 THEN (num*6)+62 WHEN 9033 THEN (num*6)+63 WHEN 9057 THEN (num*6)+64 WHEN 9000 THEN (num*6)+65 WHEN 6963 THEN (num*6)+66 WHEN 8975 THEN (num*6)+67 WHEN 8893 THEN (num*6)+68 WHEN 9141 THEN (num*6)+69 WHEN 8891 THEN (num*6)+70 WHEN 9055 THEN (num*6)+71 WHEN 8989 THEN (num*6)+72 WHEN 9125 THEN (num*6)+73 WHEN 9098 THEN (num*6)+74 WHEN 9002 THEN (num*6)+75 WHEN 9079 THEN (num*6)+76 WHEN 4849 THEN (num*6)+77 WHEN 7865 THEN (num*6)+78 WHEN 5760 THEN (num*6)+79 WHEN 9027 THEN (num*6)+80 WHEN 8913 THEN (num*6)+81 WHEN 2610 THEN (num*6)+82 WHEN 9060 THEN (num*6)+83 WHEN 8945 THEN (num*6)+84 WHEN 9241 THEN (num*6)+85 WHEN 8990 THEN (num*6)+86 WHEN 7489 THEN (num*6)+87 WHEN 9003 THEN (num*6)+88 WHEN 8889 THEN (num*6)+89 WHEN 9047 THEN (num*6)+90 WHEN 8997 THEN (num*6)+91 WHEN 8243 THEN (num*6)+92 WHEN 9149 THEN (num*6)+93 WHEN 7892 THEN (num*6)+94 WHEN 8241 THEN (num*6)+95 WHEN 6962 THEN (num*6)+96 WHEN 9059 THEN (num*6)+97 WHEN 9080 THEN (num*6)+98 WHEN 8939 THEN (num*6)+99 WHEN 6959 THEN (num*6)+100 WHEN 8912 THEN (num*6)+101 WHEN 9056 THEN (num*6)+102 WHEN 9152 THEN (num*6)+103 WHEN 8495 THEN (num*6)+104 WHEN 7888 THEN (num*6)+105 WHEN 9133 THEN (num*6)+106 WHEN 6208 THEN (num*6)+107 WHEN 8949 THEN (num*6)+108 WHEN 9146 THEN (num*6)+109 WHEN 9012 THEN (num*6)+110 WHEN 8314 THEN (num*6)+111 WHEN 9138 THEN (num*6)+112 WHEN 8339 THEN (num*6)+113 WHEN 3027 THEN (num*6)+114 WHEN 9416 THEN (num*6)+115 WHEN 8985 THEN (num*6)+116 WHEN 9408 THEN (num*6)+117 WHEN 8994 THEN (num*6)+118 WHEN 6881 THEN (num*6)+119 WHEN 4264 THEN (num*6)+120 WHEN 9023 THEN (num*6)+121 WHEN 8970 THEN (num*6)+122 WHEN 9156 THEN (num*6)+123 WHEN 8242 THEN (num*6)+124 WHEN 8240 THEN (num*6)+125 WHEN 8943 THEN (num*6)+126 WHEN 8888 THEN (num*6)+127 WHEN 9025 THEN (num*6)+128 WHEN 9052 THEN (num*6)+129 WHEN 8983 THEN (num*6)+130 WHEN 6706 THEN (num*6)+131 WHEN 8987 THEN (num*6)+132 WHEN 9053 THEN (num*6)+133 WHEN 9024 THEN (num*6)+134 WHEN 8976 THEN (num*6)+135 WHEN 8316 THEN (num*6)+136 WHEN 6232 THEN (num*6)+137 WHEN 8938 THEN (num*6)+138 WHEN 7867 THEN (num*6)+139 WHEN 8973 THEN (num*6)+140 WHEN 8995 THEN (num*6)+141 WHEN 1823 THEN (num*6)+142 WHEN 8886 THEN (num*6)+143 WHEN 8892 THEN (num*6)+144 WHEN 7381 THEN (num*6)+145 WHEN 9048 THEN (num*6)+146 WHEN 5149 THEN (num*6)+147 WHEN 6853 THEN (num*6)+148 WHEN 6854 THEN (num*6)+149 WHEN 7471 THEN (num*6)+150 WHEN 9229 THEN (num*6)+151 WHEN 9114 THEN (num*6)+152 WHEN 5375 THEN (num*6)+153 WHEN 9137 THEN (num*6)+154 WHEN 8340 THEN (num*6)+155 WHEN 9160 THEN (num*6)+156 WHEN 7770 THEN (num*6)+157 WHEN 8465 THEN (num*6)+158 WHEN 8386 THEN (num*6)+159 WHEN 6732 THEN (num*6)+160 WHEN 9051 THEN (num*6)+161 WHEN 6169 THEN (num*6)+162 WHEN 7866 THEN (num*6)+163 WHEN 8937 THEN (num*6)+164 WHEN 7576 THEN (num*6)+165 WHEN 5336 THEN (num*6)+166 WHEN 7893 THEN (num*6)+167 WHEN 8999 THEN (num*6)+168 WHEN 8984 THEN (num*6)+169 WHEN 8992 THEN (num*6)+170 WHEN 8991 THEN (num*6)+171 WHEN 6694 THEN (num*6)+172 WHEN 8315 THEN (num*6)+173 WHEN 8529 THEN (num*6)+174 WHEN 8911 THEN (num*6)+175 WHEN 8454 THEN (num*6)+176 WHEN 8982 THEN (num*6)+177 WHEN 9019 THEN (num*6)+178 WHEN 9122 THEN (num*6)+179 WHEN 8464 THEN (num*6)+180 WHEN 8341 THEN (num*6)+181 WHEN 8456 THEN (num*6)+182 WHEN 7894 THEN (num*6)+183 WHEN 8338 THEN (num*6)+184 WHEN 8885 THEN (num*6)+185 WHEN 8942 THEN (num*6)+186 WHEN 5329 THEN (num*6)+187 WHEN 9058 THEN (num*6)+188 WHEN 9032 THEN (num*6)+189 WHEN 7923 THEN (num*6)+190 WHEN 7887 THEN (num*6)+191 WHEN 8884 THEN (num*6)+192 WHEN 8880 THEN (num*6)+193 WHEN 5431 THEN (num*6)+194 WHEN 6263 THEN (num*6)+195 WHEN 7391 THEN (num*6)+196 WHEN 8250 THEN (num*6)+197 WHEN 6966 THEN (num*6)+198 WHEN 8428 THEN (num*6)+199 WHEN 7422 THEN (num*6)+200 WHEN 8462 THEN (num*6)+201 WHEN 7816 THEN (num*6)+202 WHEN 5816 THEN (num*6)+203 WHEN 6960 THEN (num*6)+204 WHEN 9039 THEN (num*6)+205 WHEN 9041 THEN (num*6)+206 WHEN 8248 THEN (num*6)+207 WHEN 8432 THEN (num*6)+208 WHEN 2101 THEN (num*6)+209 WHEN 8484 THEN (num*6)+210 WHEN 9008 THEN (num*6)+211 WHEN 5817 THEN (num*6)+212 WHEN 8969 THEN (num*6)+213 WHEN 8981 THEN (num*6)+214 WHEN 8323 THEN (num*6)+215 WHEN 3028 THEN (num*6)+216 WHEN 8840 THEN (num*6)+217 WHEN 8343 THEN (num*6)+218 WHEN 8528 THEN (num*6)+219 WHEN 8418 THEN (num*6)+220 WHEN 8322 THEN (num*6)+221 WHEN 5831 THEN (num*6)+222 WHEN 8429 THEN (num*6)+223 WHEN 8950 THEN (num*6)+224 WHEN 8887 THEN (num*6)+225 WHEN 9031 THEN (num*6)+226 WHEN 5182 THEN (num*6)+227 WHEN 8473 THEN (num*6)+228 WHEN 9009 THEN (num*6)+229 WHEN 1294 THEN (num*6)+230 WHEN 8947 THEN (num*6)+231 WHEN 7420 THEN (num*6)+232 WHEN 7599 THEN (num*6)+233 WHEN 7384 THEN (num*6)+234 WHEN 8352 THEN (num*6)+235 WHEN 7589 THEN (num*6)+236 WHEN 8414 THEN (num*6)+237 WHEN 8427 THEN (num*6)+238 WHEN 5422 THEN (num*6)+239 WHEN 589 THEN (num*6)+240 WHEN 8986 THEN (num*6)+241 WHEN 8268 THEN (num*6)+242 WHEN 6967 THEN (num*6)+243 WHEN 8936 THEN (num*6)+244 WHEN 8230 THEN (num*6)+245 WHEN 7386 THEN (num*6)+246 WHEN 8497 THEN (num*6)+247 WHEN 3846 THEN (num*6)+248 WHEN 8508 THEN (num*6)+249 WHEN 8420 THEN (num*6)+250 WHEN 8480 THEN (num*6)+251 WHEN 8275 THEN (num*6)+252 WHEN 8213 THEN (num*6)+253 WHEN 4622 THEN (num*6)+254 WHEN 7811 THEN (num*6)+255 WHEN 7814 THEN (num*6)+256 WHEN 8493 THEN (num*6)+257 WHEN 8488 THEN (num*6)+258 WHEN 7585 THEN (num*6)+259 WHEN 8223 THEN (num*6)+260 WHEN 3004 THEN (num*6)+261 WHEN 8504 THEN (num*6)+262 WHEN 8898 THEN (num*6)+263 WHEN 8225 THEN (num*6)+264 WHEN 6487 THEN (num*6)+265 WHEN 8318 THEN (num*6)+266 WHEN 6737 THEN (num*6)+267 WHEN 7387 THEN (num*6)+268 WHEN 8940 THEN (num*6)+269 WHEN 3432 THEN (num*6)+270 WHEN 5191 THEN (num*6)+271 WHEN 8469 THEN (num*6)+272 WHEN 7619 THEN (num*6)+273 WHEN 8520 THEN (num*6)+274 WHEN 8417 THEN (num*6)+275 WHEN 8430 THEN (num*6)+276 WHEN 8468 THEN (num*6)+277 WHEN 4667 THEN (num*6)+278 WHEN 8261 THEN (num*6)+279 WHEN 7813 THEN (num*6)+280 WHEN 7644 THEN (num*6)+281 WHEN 8467 THEN (num*6)+282 WHEN 8466 THEN (num*6)+283 WHEN 8214 THEN (num*6)+284 WHEN 7586 THEN (num*6)+285 WHEN 8739 THEN (num*6)+286 WHEN 8272 THEN (num*6)+287 WHEN 8463 THEN (num*6)+288 WHEN 7432 THEN (num*6)+289 WHEN 7857 THEN (num*6)+290 WHEN 8332 THEN (num*6)+291 WHEN 7606 THEN (num*6)+292 WHEN 8460 THEN (num*6)+293 WHEN 6240 THEN (num*6)+294 WHEN 8239 THEN (num*6)+295 WHEN 8298 THEN (num*6)+296 WHEN 6200 THEN (num*6)+297 WHEN 8246 THEN (num*6)+298 WHEN 8231 THEN (num*6)+299 WHEN 8470 THEN (num*6)+300 WHEN 8438 THEN (num*6)+301 WHEN 8227 THEN (num*6)+302 WHEN 8525 THEN (num*6)+303 WHEN 8498 THEN (num*6)+304 WHEN 7649 THEN (num*6)+305 WHEN 8437 THEN (num*6)+306 WHEN 6490 THEN (num*6)+307 WHEN 8499 THEN (num*6)+308 WHEN 7815 THEN (num*6)+309 WHEN 8228 THEN (num*6)+310 WHEN 8478 THEN (num*6)+311 WHEN 7590 THEN (num*6)+312 WHEN 8247 THEN (num*6)+313 WHEN 8461 THEN (num*6)+314 WHEN 7400 THEN (num*6)+315 WHEN 8233 THEN (num*6)+316 WHEN 8217 THEN (num*6)+317 WHEN 8336 THEN (num*6)+318 WHEN 8271 THEN (num*6)+319 WHEN 7411 THEN (num*6)+320 WHEN 7428 THEN (num*6)+321 WHEN 8433 THEN (num*6)+322 WHEN 7598 THEN (num*6)+323 WHEN 7011 THEN (num*6)+324 WHEN 8440 THEN (num*6)+325 WHEN 8232 THEN (num*6)+326 WHEN 3952 THEN (num*6)+327 WHEN 8276 THEN (num*6)+328 WHEN 8441 THEN (num*6)+329 WHEN 6261 THEN (num*6)+330 WHEN 7650 THEN (num*6)+331 WHEN 8479 THEN (num*6)+332 WHEN 8500 THEN (num*6)+333 WHEN 6687 THEN (num*6)+334 WHEN 7658 THEN (num*6)+335 WHEN 8526 THEN (num*6)+336 WHEN 7389 THEN (num*6)+337 WHEN 8235 THEN (num*6)+338 WHEN 8226 THEN (num*6)+339 WHEN 8527 THEN (num*6)+340 WHEN 8664 THEN (num*6)+341 WHEN 3254 THEN (num*6)+342 WHEN 8510 THEN (num*6)+343 WHEN 7587 THEN (num*6)+344 WHEN 7573 THEN (num*6)+345 WHEN 8274 THEN (num*6)+346 WHEN 5175 THEN (num*6)+347 WHEN 7379 THEN (num*6)+348 WHEN 7588 THEN (num*6)+349 WHEN 7385 THEN (num*6)+350 WHEN 7633 THEN (num*6)+351 WHEN 7632 THEN (num*6)+352 WHEN 7490 THEN (num*6)+353 WHEN 7620 THEN (num*6)+354 WHEN 6982 THEN (num*6)+355 WHEN 7875 THEN (num*6)+356 WHEN 8237 THEN (num*6)+357 WHEN 7390 THEN (num*6)+358 WHEN 8335 THEN (num*6)+359 WHEN 4000 THEN (num*6)+360 WHEN 8229 THEN (num*6)+361 WHEN 8423 THEN (num*6)+362 WHEN 8481 THEN (num*6)+363 WHEN 7410 THEN (num*6)+364 WHEN 6733 THEN (num*6)+365 WHEN 8234 THEN (num*6)+366 WHEN 6749 THEN (num*6)+367 WHEN 6691 THEN (num*6)+368 WHEN 7828 THEN (num*6)+369 WHEN 7581 THEN (num*6)+370 WHEN 8337 THEN (num*6)+371 WHEN 9103 THEN (num*6)+372 WHEN 7829 THEN (num*6)+373 WHEN 8215 THEN (num*6)+374 WHEN 3362 THEN (num*6)+375 WHEN 6692 THEN (num*6)+376 WHEN 8381 THEN (num*6)+377 WHEN 8516 THEN (num*6)+378 WHEN 8009 THEN (num*6)+379 WHEN 5759 THEN (num*6)+380 WHEN 8391 THEN (num*6)+381 WHEN 8425 THEN (num*6)+382 WHEN 4920 THEN (num*6)+383 WHEN 7388 THEN (num*6)+384 WHEN 3561 THEN (num*6)+385 WHEN 6786 THEN (num*6)+386 WHEN 7672 THEN (num*6)+387 WHEN 8216 THEN (num*6)+388 WHEN 8485 THEN (num*6)+389 WHEN 7903 THEN (num*6)+390 WHEN 7774 THEN (num*6)+391 WHEN 8401 THEN (num*6)+392 WHEN 7583 THEN (num*6)+393 WHEN 8487 THEN (num*6)+394 WHEN 7642 THEN (num*6)+395 WHEN 5384 THEN (num*6)+396 WHEN 8515 THEN (num*6)+397 WHEN 7026 THEN (num*6)+398 WHEN 8357 THEN (num*6)+399 WHEN 7491 THEN (num*6)+400 WHEN 8477 THEN (num*6)+401 WHEN 5924 THEN (num*6)+402 WHEN 9099 THEN (num*6)+403 WHEN 8941 THEN (num*6)+404 WHEN 7577 THEN (num*6)+405 WHEN 6885 THEN (num*6)+406 WHEN 7021 THEN (num*6)+407 WHEN 2602 THEN (num*6)+408 WHEN 6688 THEN (num*6)+409 WHEN 8334 THEN (num*6)+410 WHEN 4745 THEN (num*6)+411 WHEN 8282 THEN (num*6)+412 WHEN 5178 THEN (num*6)+413 WHEN 7624 THEN (num*6)+414 WHEN 7426 THEN (num*6)+415 WHEN 8422 THEN (num*6)+416 WHEN 4612 THEN (num*6)+417 WHEN 8424 THEN (num*6)+418 WHEN 6829 THEN (num*6)+419 WHEN 7776 THEN (num*6)+420 WHEN 5824 THEN (num*6)+421 WHEN 2003 THEN (num*6)+422 WHEN 7025 THEN (num*6)+423 WHEN 7643 THEN (num*6)+424 WHEN 7414 THEN (num*6)+425 END,numErr153a