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 volume!=4  AND produit IN(0,9344,9424,6504,7947,9328,9329,8176,6377,9412,9409,9410,9411,9095,9301,6503,9523,9524,9522,9520,9519,9518,9517,9484,9479,9478,9477,9364,9476,9342,8790,5969,9448,8809,9450,9447,9442,9423,9422,9421,9420,9419,8019,9143,9334,9425,9305,9267,9277,9339,9116,9303,8708,9362,8895,9322,1814,1809,6601,8855,5133,8869,9361,9304,9363,9403,9398,9391,9390,8599,9389,9360,9388,9384,5094,9327,6602,8807,6474,9309,1811,7943,5132,3827,8872,8774,9206,9205,6132,9202,8842,8841,5108,9017,6376,9341,9336,8853,5542,3191,9014,3196,3140,8781,7217,8866,9016,8020,8877,8848,6362,5109,6604,8870,6599,6375,8820,5004,6506,8789,6142,8166,8875,8782,7484,5092,5985,7377,3007,8018,8879,6473,7303,5987,5009,7239,8562,8773,6004,6124,7954,6505,6610,8699,6597,4423,7216,6612,8721,3123,8958,8732,5111,8857,6603,8719,7951,6476,6146,5967,6461,6598,8859,8167,3609,5031,8854,5656,8788,6502,8691,8665,4422,8589,7238,6013,5920,8783,7523,4485,6564,7133,8697,7309,3124,8765,4563,6415,8569,7531,8612,8775,8696,3122,7486,5511,7946,7374,8718,3126,6171,8593,8725,8598,6001,6495,6412,6007,7488,7298,8822,7171,6565,6127,8047,4562,6035,6609,7944,7935,8570,8688,8016,6497,7297,8797,5966,8794,8635,5030,7300,7965,7474,8668,7981,3188,8126,8744,8143,7236,5541,6018,8604,8596,8684,3129,8585,8568,8722,8017,7536,7562,3610,6403,8624,8704,8645,6508,6000,8590,7950,6143,8606,7294,8634,8627,8633,8632,8766,6496,8747,8588,6151,8125,8698,7956,8731,8685,8703,8856,6607,8693,8001,6155,6140,8720,8630,8144,3657,8849,5093,8628,6020,7533,7936,6475,7550,7295,8663,7983,8013,7349,8640,8652,7964,8074,5991,7937,7538,7787,8631,6413,8687,8010,8128,7941,7460,7995,8046,3008,3094,7464,8124,3023,7234,8639,7250,8044,8002,8686,7355,8701,7241,7247,6361,7351,5645,7235,7289,7398,5989,8008,7468,7224,5997,7251,7458,7352,7463,7248,8808,7534,2363,7245,6417,7311,7318,7177,6499,4491,8653,7939,8075,7753,6501,3179,7243,6365,8162,6340,8025,8129,6493,7959,6396,7487,8100,6139,6352,8071,8120,6002,7166,8051,7539,7485,7249,6364,7378,7203,8072,1569,8694,7957,7288,8014,7319,5696,8623,8823,6613,5107,8077,6633,5738,7532,7537,7353,8871,7152,8095,7520,7357,7308,6509,8097,7540,7639,7788,7690,8629,7792,8055,7546,7253)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 9344 THEN (num*6)+1 WHEN 9424 THEN (num*6)+2 WHEN 6504 THEN (num*6)+3 WHEN 7947 THEN (num*6)+4 WHEN 9328 THEN (num*6)+5 WHEN 9329 THEN (num*6)+6 WHEN 8176 THEN (num*6)+7 WHEN 6377 THEN (num*6)+8 WHEN 9412 THEN (num*6)+9 WHEN 9409 THEN (num*6)+10 WHEN 9410 THEN (num*6)+11 WHEN 9411 THEN (num*6)+12 WHEN 9095 THEN (num*6)+13 WHEN 9301 THEN (num*6)+14 WHEN 6503 THEN (num*6)+15 WHEN 9523 THEN (num*6)+16 WHEN 9524 THEN (num*6)+17 WHEN 9522 THEN (num*6)+18 WHEN 9520 THEN (num*6)+19 WHEN 9519 THEN (num*6)+20 WHEN 9518 THEN (num*6)+21 WHEN 9517 THEN (num*6)+22 WHEN 9484 THEN (num*6)+23 WHEN 9479 THEN (num*6)+24 WHEN 9478 THEN (num*6)+25 WHEN 9477 THEN (num*6)+26 WHEN 9364 THEN (num*6)+27 WHEN 9476 THEN (num*6)+28 WHEN 9342 THEN (num*6)+29 WHEN 8790 THEN (num*6)+30 WHEN 5969 THEN (num*6)+31 WHEN 9448 THEN (num*6)+32 WHEN 8809 THEN (num*6)+33 WHEN 9450 THEN (num*6)+34 WHEN 9447 THEN (num*6)+35 WHEN 9442 THEN (num*6)+36 WHEN 9423 THEN (num*6)+37 WHEN 9422 THEN (num*6)+38 WHEN 9421 THEN (num*6)+39 WHEN 9420 THEN (num*6)+40 WHEN 9419 THEN (num*6)+41 WHEN 8019 THEN (num*6)+42 WHEN 9143 THEN (num*6)+43 WHEN 9334 THEN (num*6)+44 WHEN 9425 THEN (num*6)+45 WHEN 9305 THEN (num*6)+46 WHEN 9267 THEN (num*6)+47 WHEN 9277 THEN (num*6)+48 WHEN 9339 THEN (num*6)+49 WHEN 9116 THEN (num*6)+50 WHEN 9303 THEN (num*6)+51 WHEN 8708 THEN (num*6)+52 WHEN 9362 THEN (num*6)+53 WHEN 8895 THEN (num*6)+54 WHEN 9322 THEN (num*6)+55 WHEN 1814 THEN (num*6)+56 WHEN 1809 THEN (num*6)+57 WHEN 6601 THEN (num*6)+58 WHEN 8855 THEN (num*6)+59 WHEN 5133 THEN (num*6)+60 WHEN 8869 THEN (num*6)+61 WHEN 9361 THEN (num*6)+62 WHEN 9304 THEN (num*6)+63 WHEN 9363 THEN (num*6)+64 WHEN 9403 THEN (num*6)+65 WHEN 9398 THEN (num*6)+66 WHEN 9391 THEN (num*6)+67 WHEN 9390 THEN (num*6)+68 WHEN 8599 THEN (num*6)+69 WHEN 9389 THEN (num*6)+70 WHEN 9360 THEN (num*6)+71 WHEN 9388 THEN (num*6)+72 WHEN 9384 THEN (num*6)+73 WHEN 5094 THEN (num*6)+74 WHEN 9327 THEN (num*6)+75 WHEN 6602 THEN (num*6)+76 WHEN 8807 THEN (num*6)+77 WHEN 6474 THEN (num*6)+78 WHEN 9309 THEN (num*6)+79 WHEN 1811 THEN (num*6)+80 WHEN 7943 THEN (num*6)+81 WHEN 5132 THEN (num*6)+82 WHEN 3827 THEN (num*6)+83 WHEN 8872 THEN (num*6)+84 WHEN 8774 THEN (num*6)+85 WHEN 9206 THEN (num*6)+86 WHEN 9205 THEN (num*6)+87 WHEN 6132 THEN (num*6)+88 WHEN 9202 THEN (num*6)+89 WHEN 8842 THEN (num*6)+90 WHEN 8841 THEN (num*6)+91 WHEN 5108 THEN (num*6)+92 WHEN 9017 THEN (num*6)+93 WHEN 6376 THEN (num*6)+94 WHEN 9341 THEN (num*6)+95 WHEN 9336 THEN (num*6)+96 WHEN 8853 THEN (num*6)+97 WHEN 5542 THEN (num*6)+98 WHEN 3191 THEN (num*6)+99 WHEN 9014 THEN (num*6)+100 WHEN 3196 THEN (num*6)+101 WHEN 3140 THEN (num*6)+102 WHEN 8781 THEN (num*6)+103 WHEN 7217 THEN (num*6)+104 WHEN 8866 THEN (num*6)+105 WHEN 9016 THEN (num*6)+106 WHEN 8020 THEN (num*6)+107 WHEN 8877 THEN (num*6)+108 WHEN 8848 THEN (num*6)+109 WHEN 6362 THEN (num*6)+110 WHEN 5109 THEN (num*6)+111 WHEN 6604 THEN (num*6)+112 WHEN 8870 THEN (num*6)+113 WHEN 6599 THEN (num*6)+114 WHEN 6375 THEN (num*6)+115 WHEN 8820 THEN (num*6)+116 WHEN 5004 THEN (num*6)+117 WHEN 6506 THEN (num*6)+118 WHEN 8789 THEN (num*6)+119 WHEN 6142 THEN (num*6)+120 WHEN 8166 THEN (num*6)+121 WHEN 8875 THEN (num*6)+122 WHEN 8782 THEN (num*6)+123 WHEN 7484 THEN (num*6)+124 WHEN 5092 THEN (num*6)+125 WHEN 5985 THEN (num*6)+126 WHEN 7377 THEN (num*6)+127 WHEN 3007 THEN (num*6)+128 WHEN 8018 THEN (num*6)+129 WHEN 8879 THEN (num*6)+130 WHEN 6473 THEN (num*6)+131 WHEN 7303 THEN (num*6)+132 WHEN 5987 THEN (num*6)+133 WHEN 5009 THEN (num*6)+134 WHEN 7239 THEN (num*6)+135 WHEN 8562 THEN (num*6)+136 WHEN 8773 THEN (num*6)+137 WHEN 6004 THEN (num*6)+138 WHEN 6124 THEN (num*6)+139 WHEN 7954 THEN (num*6)+140 WHEN 6505 THEN (num*6)+141 WHEN 6610 THEN (num*6)+142 WHEN 8699 THEN (num*6)+143 WHEN 6597 THEN (num*6)+144 WHEN 4423 THEN (num*6)+145 WHEN 7216 THEN (num*6)+146 WHEN 6612 THEN (num*6)+147 WHEN 8721 THEN (num*6)+148 WHEN 3123 THEN (num*6)+149 WHEN 8958 THEN (num*6)+150 WHEN 8732 THEN (num*6)+151 WHEN 5111 THEN (num*6)+152 WHEN 8857 THEN (num*6)+153 WHEN 6603 THEN (num*6)+154 WHEN 8719 THEN (num*6)+155 WHEN 7951 THEN (num*6)+156 WHEN 6476 THEN (num*6)+157 WHEN 6146 THEN (num*6)+158 WHEN 5967 THEN (num*6)+159 WHEN 6461 THEN (num*6)+160 WHEN 6598 THEN (num*6)+161 WHEN 8859 THEN (num*6)+162 WHEN 8167 THEN (num*6)+163 WHEN 3609 THEN (num*6)+164 WHEN 5031 THEN (num*6)+165 WHEN 8854 THEN (num*6)+166 WHEN 5656 THEN (num*6)+167 WHEN 8788 THEN (num*6)+168 WHEN 6502 THEN (num*6)+169 WHEN 8691 THEN (num*6)+170 WHEN 8665 THEN (num*6)+171 WHEN 4422 THEN (num*6)+172 WHEN 8589 THEN (num*6)+173 WHEN 7238 THEN (num*6)+174 WHEN 6013 THEN (num*6)+175 WHEN 5920 THEN (num*6)+176 WHEN 8783 THEN (num*6)+177 WHEN 7523 THEN (num*6)+178 WHEN 4485 THEN (num*6)+179 WHEN 6564 THEN (num*6)+180 WHEN 7133 THEN (num*6)+181 WHEN 8697 THEN (num*6)+182 WHEN 7309 THEN (num*6)+183 WHEN 3124 THEN (num*6)+184 WHEN 8765 THEN (num*6)+185 WHEN 4563 THEN (num*6)+186 WHEN 6415 THEN (num*6)+187 WHEN 8569 THEN (num*6)+188 WHEN 7531 THEN (num*6)+189 WHEN 8612 THEN (num*6)+190 WHEN 8775 THEN (num*6)+191 WHEN 8696 THEN (num*6)+192 WHEN 3122 THEN (num*6)+193 WHEN 7486 THEN (num*6)+194 WHEN 5511 THEN (num*6)+195 WHEN 7946 THEN (num*6)+196 WHEN 7374 THEN (num*6)+197 WHEN 8718 THEN (num*6)+198 WHEN 3126 THEN (num*6)+199 WHEN 6171 THEN (num*6)+200 WHEN 8593 THEN (num*6)+201 WHEN 8725 THEN (num*6)+202 WHEN 8598 THEN (num*6)+203 WHEN 6001 THEN (num*6)+204 WHEN 6495 THEN (num*6)+205 WHEN 6412 THEN (num*6)+206 WHEN 6007 THEN (num*6)+207 WHEN 7488 THEN (num*6)+208 WHEN 7298 THEN (num*6)+209 WHEN 8822 THEN (num*6)+210 WHEN 7171 THEN (num*6)+211 WHEN 6565 THEN (num*6)+212 WHEN 6127 THEN (num*6)+213 WHEN 8047 THEN (num*6)+214 WHEN 4562 THEN (num*6)+215 WHEN 6035 THEN (num*6)+216 WHEN 6609 THEN (num*6)+217 WHEN 7944 THEN (num*6)+218 WHEN 7935 THEN (num*6)+219 WHEN 8570 THEN (num*6)+220 WHEN 8688 THEN (num*6)+221 WHEN 8016 THEN (num*6)+222 WHEN 6497 THEN (num*6)+223 WHEN 7297 THEN (num*6)+224 WHEN 8797 THEN (num*6)+225 WHEN 5966 THEN (num*6)+226 WHEN 8794 THEN (num*6)+227 WHEN 8635 THEN (num*6)+228 WHEN 5030 THEN (num*6)+229 WHEN 7300 THEN (num*6)+230 WHEN 7965 THEN (num*6)+231 WHEN 7474 THEN (num*6)+232 WHEN 8668 THEN (num*6)+233 WHEN 7981 THEN (num*6)+234 WHEN 3188 THEN (num*6)+235 WHEN 8126 THEN (num*6)+236 WHEN 8744 THEN (num*6)+237 WHEN 8143 THEN (num*6)+238 WHEN 7236 THEN (num*6)+239 WHEN 5541 THEN (num*6)+240 WHEN 6018 THEN (num*6)+241 WHEN 8604 THEN (num*6)+242 WHEN 8596 THEN (num*6)+243 WHEN 8684 THEN (num*6)+244 WHEN 3129 THEN (num*6)+245 WHEN 8585 THEN (num*6)+246 WHEN 8568 THEN (num*6)+247 WHEN 8722 THEN (num*6)+248 WHEN 8017 THEN (num*6)+249 WHEN 7536 THEN (num*6)+250 WHEN 7562 THEN (num*6)+251 WHEN 3610 THEN (num*6)+252 WHEN 6403 THEN (num*6)+253 WHEN 8624 THEN (num*6)+254 WHEN 8704 THEN (num*6)+255 WHEN 8645 THEN (num*6)+256 WHEN 6508 THEN (num*6)+257 WHEN 6000 THEN (num*6)+258 WHEN 8590 THEN (num*6)+259 WHEN 7950 THEN (num*6)+260 WHEN 6143 THEN (num*6)+261 WHEN 8606 THEN (num*6)+262 WHEN 7294 THEN (num*6)+263 WHEN 8634 THEN (num*6)+264 WHEN 8627 THEN (num*6)+265 WHEN 8633 THEN (num*6)+266 WHEN 8632 THEN (num*6)+267 WHEN 8766 THEN (num*6)+268 WHEN 6496 THEN (num*6)+269 WHEN 8747 THEN (num*6)+270 WHEN 8588 THEN (num*6)+271 WHEN 6151 THEN (num*6)+272 WHEN 8125 THEN (num*6)+273 WHEN 8698 THEN (num*6)+274 WHEN 7956 THEN (num*6)+275 WHEN 8731 THEN (num*6)+276 WHEN 8685 THEN (num*6)+277 WHEN 8703 THEN (num*6)+278 WHEN 8856 THEN (num*6)+279 WHEN 6607 THEN (num*6)+280 WHEN 8693 THEN (num*6)+281 WHEN 8001 THEN (num*6)+282 WHEN 6155 THEN (num*6)+283 WHEN 6140 THEN (num*6)+284 WHEN 8720 THEN (num*6)+285 WHEN 8630 THEN (num*6)+286 WHEN 8144 THEN (num*6)+287 WHEN 3657 THEN (num*6)+288 WHEN 8849 THEN (num*6)+289 WHEN 5093 THEN (num*6)+290 WHEN 8628 THEN (num*6)+291 WHEN 6020 THEN (num*6)+292 WHEN 7533 THEN (num*6)+293 WHEN 7936 THEN (num*6)+294 WHEN 6475 THEN (num*6)+295 WHEN 7550 THEN (num*6)+296 WHEN 7295 THEN (num*6)+297 WHEN 8663 THEN (num*6)+298 WHEN 7983 THEN (num*6)+299 WHEN 8013 THEN (num*6)+300 WHEN 7349 THEN (num*6)+301 WHEN 8640 THEN (num*6)+302 WHEN 8652 THEN (num*6)+303 WHEN 7964 THEN (num*6)+304 WHEN 8074 THEN (num*6)+305 WHEN 5991 THEN (num*6)+306 WHEN 7937 THEN (num*6)+307 WHEN 7538 THEN (num*6)+308 WHEN 7787 THEN (num*6)+309 WHEN 8631 THEN (num*6)+310 WHEN 6413 THEN (num*6)+311 WHEN 8687 THEN (num*6)+312 WHEN 8010 THEN (num*6)+313 WHEN 8128 THEN (num*6)+314 WHEN 7941 THEN (num*6)+315 WHEN 7460 THEN (num*6)+316 WHEN 7995 THEN (num*6)+317 WHEN 8046 THEN (num*6)+318 WHEN 3008 THEN (num*6)+319 WHEN 3094 THEN (num*6)+320 WHEN 7464 THEN (num*6)+321 WHEN 8124 THEN (num*6)+322 WHEN 3023 THEN (num*6)+323 WHEN 7234 THEN (num*6)+324 WHEN 8639 THEN (num*6)+325 WHEN 7250 THEN (num*6)+326 WHEN 8044 THEN (num*6)+327 WHEN 8002 THEN (num*6)+328 WHEN 8686 THEN (num*6)+329 WHEN 7355 THEN (num*6)+330 WHEN 8701 THEN (num*6)+331 WHEN 7241 THEN (num*6)+332 WHEN 7247 THEN (num*6)+333 WHEN 6361 THEN (num*6)+334 WHEN 7351 THEN (num*6)+335 WHEN 5645 THEN (num*6)+336 WHEN 7235 THEN (num*6)+337 WHEN 7289 THEN (num*6)+338 WHEN 7398 THEN (num*6)+339 WHEN 5989 THEN (num*6)+340 WHEN 8008 THEN (num*6)+341 WHEN 7468 THEN (num*6)+342 WHEN 7224 THEN (num*6)+343 WHEN 5997 THEN (num*6)+344 WHEN 7251 THEN (num*6)+345 WHEN 7458 THEN (num*6)+346 WHEN 7352 THEN (num*6)+347 WHEN 7463 THEN (num*6)+348 WHEN 7248 THEN (num*6)+349 WHEN 8808 THEN (num*6)+350 WHEN 7534 THEN (num*6)+351 WHEN 2363 THEN (num*6)+352 WHEN 7245 THEN (num*6)+353 WHEN 6417 THEN (num*6)+354 WHEN 7311 THEN (num*6)+355 WHEN 7318 THEN (num*6)+356 WHEN 7177 THEN (num*6)+357 WHEN 6499 THEN (num*6)+358 WHEN 4491 THEN (num*6)+359 WHEN 8653 THEN (num*6)+360 WHEN 7939 THEN (num*6)+361 WHEN 8075 THEN (num*6)+362 WHEN 7753 THEN (num*6)+363 WHEN 6501 THEN (num*6)+364 WHEN 3179 THEN (num*6)+365 WHEN 7243 THEN (num*6)+366 WHEN 6365 THEN (num*6)+367 WHEN 8162 THEN (num*6)+368 WHEN 6340 THEN (num*6)+369 WHEN 8025 THEN (num*6)+370 WHEN 8129 THEN (num*6)+371 WHEN 6493 THEN (num*6)+372 WHEN 7959 THEN (num*6)+373 WHEN 6396 THEN (num*6)+374 WHEN 7487 THEN (num*6)+375 WHEN 8100 THEN (num*6)+376 WHEN 6139 THEN (num*6)+377 WHEN 6352 THEN (num*6)+378 WHEN 8071 THEN (num*6)+379 WHEN 8120 THEN (num*6)+380 WHEN 6002 THEN (num*6)+381 WHEN 7166 THEN (num*6)+382 WHEN 8051 THEN (num*6)+383 WHEN 7539 THEN (num*6)+384 WHEN 7485 THEN (num*6)+385 WHEN 7249 THEN (num*6)+386 WHEN 6364 THEN (num*6)+387 WHEN 7378 THEN (num*6)+388 WHEN 7203 THEN (num*6)+389 WHEN 8072 THEN (num*6)+390 WHEN 1569 THEN (num*6)+391 WHEN 8694 THEN (num*6)+392 WHEN 7957 THEN (num*6)+393 WHEN 7288 THEN (num*6)+394 WHEN 8014 THEN (num*6)+395 WHEN 7319 THEN (num*6)+396 WHEN 5696 THEN (num*6)+397 WHEN 8623 THEN (num*6)+398 WHEN 8823 THEN (num*6)+399 WHEN 6613 THEN (num*6)+400 WHEN 5107 THEN (num*6)+401 WHEN 8077 THEN (num*6)+402 WHEN 6633 THEN (num*6)+403 WHEN 5738 THEN (num*6)+404 WHEN 7532 THEN (num*6)+405 WHEN 7537 THEN (num*6)+406 WHEN 7353 THEN (num*6)+407 WHEN 8871 THEN (num*6)+408 WHEN 7152 THEN (num*6)+409 WHEN 8095 THEN (num*6)+410 WHEN 7520 THEN (num*6)+411 WHEN 7357 THEN (num*6)+412 WHEN 7308 THEN (num*6)+413 WHEN 6509 THEN (num*6)+414 WHEN 8097 THEN (num*6)+415 WHEN 7540 THEN (num*6)+416 WHEN 7639 THEN (num*6)+417 WHEN 7788 THEN (num*6)+418 WHEN 7690 THEN (num*6)+419 WHEN 8629 THEN (num*6)+420 WHEN 7792 THEN (num*6)+421 WHEN 8055 THEN (num*6)+422 WHEN 7546 THEN (num*6)+423 WHEN 7253 THEN (num*6)+424 END,numErr153a