SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,8449,7558,7543,9413,7731,7382,9284,9201,8867,9374,7139,8031,7961,6804,7921,8572,9131,4432,8799,8582,9236,5649,9281,8706,3002,7556,9515,9514,9513,9512,8656,7545,9287,8643,9290,9175,8581,8342,8522,8583,7542,5535,7554,8642,9286,6291,9299,7268,7541,8576,7544,9282,6296,6390,7267,6492,9283,7726,9457,9456,9455,8578,7368,7226,9454,9453,8579,9452,9001,6859,9451,9445,8573,8577,8711,8960,7897,5537,8959,7142,6491,8584,9406,7922,9345,9343,9092,9300,7220,7416,9285,8574,9015,7898,6318,7725,9200,9235,9234,9233,8303,8660,7895,9062,6553,8447,8039,5326,9232,8575,9231,7366,7515,8037,6204,4678,8034,8397,3989,8321,8038,6562,7363,7282,8302,7364,8962,9134,7204,8040,8476,4205,7424,7555,7896,8004,7361,6317,6955,7437,7362,6096,7446,8029,8222,7495,7436,7430,7383,7365,7729,7444,7372,3918,7438,6727,8083,8264,5332,7782,7447,7442,7302,5325,8078,6958,7783,7367,7519,6407,7371,7441,7427,7781,7429,7373,7435,7233,6650,7443,6668,7419,6818,7724,7440,8033,6181,6926,7423,6314,7434,6582,7017,7979,7660,7727,8475,8710,8714,8571,6642,9088,5827,6667,8112,7392,7264,6326,6627,6671,7659,7263,6942,6983,8713,6175,6082,6919,6816,7445,5330,6646,6941,8106,6332,6581,7730,7526,7261,8132,7260,6311,6592,7504,8151,7230,7499,7498,7963,7870,8580,6101,7809,8431,8159,6797,6800,8259,8712,7962,8716,6301,8175,6595,6313,6441,6458,8715,8035,7262,7211,7510,8105,7728,6558)  AND produit NOT IN( ) AND ( id=1508817594 OR id=17593 OR id=17589 OR id=17578 OR id=1474717437 OR id=17206 OR id=17374 OR id=14108 OR id=14119 OR id=17335 OR id=8480 OR id=17159 OR id=16069 OR id=17144 OR id=17141 OR id=17189 OR id=17163 OR id=14484 OR id=11208 OR id=11978 OR id=11759 OR id=15099 OR id=16070 OR id=16485 OR id=17201 OR id=17675 OR id=17677 OR id=17676 OR id=17668 OR id=17672 OR id=17225 OR id=17137 OR id=17429 OR id=17424 OR id=17561 OR id=17559 OR id=17554 OR id=17553 OR id=17552 OR id=17473 OR id=17551 OR id=17541 OR id=17541 OR id=17540 OR id=17539 OR id=17538 OR id=17536 OR id=17510 OR id=17501 OR id=17500 OR id=17496 OR id=17490 OR id=17486 OR id=17482 OR id=17480 OR id=17479 OR id=17478 OR id=17474 OR id=17476 OR id=17469 OR id=17472 OR id=17467 OR id=17447 OR id=17464 OR id=17446 OR id=17422 OR id=17419 OR id=17417 OR id=17415 OR id=17175 OR id=17410 OR id=17406 OR id=17384 OR id=17383 OR id=17337 OR id=17382 OR id=17378 OR id=17223 OR id=17377 OR id=17348 OR id=17345 OR id=17343 OR id=17332 OR id=16445 OR id=17330 OR id=17324 OR id=17317 OR id=17316 OR id=16452 OR id=17287 OR id=16093 OR id=17286 OR id=17284 OR id=17282 OR id=17257 OR id=16464 OR id=17256 OR id=17244 OR id=17255 OR id=17351 OR id=17142 OR id=16981 OR id=17254 OR id=16423 OR id=17212 OR id=17229 OR id=17183 OR id=17161 OR id=17280 OR id=17177 OR id=17174 OR id=17170 OR id=17162 OR id=17085 OR id=17081 OR id=17074 OR id=17061 OR id=17059 OR id=17058 OR id=16173 OR id=17056 OR id=16348 OR id=16486 OR id=17157 OR id=16982 OR id=16451 OR id=17124 OR id=16970 OR id=16782 OR id=16120 OR id=16781 OR id=16780 OR id=16935 OR id=16779 OR id=16922 OR id=16853 OR id=16849 OR id=16721 OR id=16444 OR id=16762 OR id=11238 OR id=16761 OR id=16281 OR id=15528 OR id=16751 OR id=16679 OR id=16278 OR id=16426 OR id=16676 OR id=16786 OR id=16693 OR id=11223 OR id=16654 OR id=16468 OR id=15410 OR id=16329 OR id=11229 OR id=16675 OR id=13916 OR id=15009 OR id=16169 OR id=16694 OR id=16453 OR id=16511 OR id=16691 OR id=16684 OR id=16968 OR id=15172 OR id=16600 OR id=16964 OR id=15294 OR id=16680 OR id=16587 OR id=13681 OR id=16664 OR id=16116 OR id=11853 OR id=10310 OR id=16832 OR id=16656 OR id=16505 OR id=14087 OR id=16254 OR id=16411 OR id=16208 OR id=10947 OR id=15401 OR id=16530 OR id=16727 OR id=16154 OR id=15398 OR id=16080 OR id=16306 OR id=16075 OR id=16074 OR id=9893 OR id=16073 OR id=15838 OR id=16109 OR id=16265 OR id=13713 OR id=16067 OR id=16101 OR id=15814 OR id=15782 OR id=16091 OR id=14089 OR id=14128 OR id=12126 OR id=13644 OR id=13515 OR id=14373 OR id=15506 OR id=15006 OR id=15091 OR id=4960 OR id=15177 OR id=15227 OR id=16765 OR id=12166 OR id=16728 OR id=15840 OR id=13045 OR id=16713 OR id=16287 OR id=14110 OR id=16282 OR id=16682 OR id=16466 OR id=7499 OR id=16662 OR id=16629 OR id=13727 OR id=11984 OR id=15312 OR id=15292 OR id=14982 OR id=15231 OR id=15203 OR id=11981 OR id=15018 OR id=15293 OR id=14876 OR id=16189 OR id=16543 OR id=16174 OR id=16831 OR id=16785 OR id=12566 OR id=15870 OR id=16102 OR id=15388 OR id=13838 OR id=16285 OR id=12106 OR id=11797 OR id=15007 OR id=9813 OR id=10931 OR id=15144 OR id=15583 OR id=14194 OR id=13896 OR id=16089 OR id=15579 OR id=15391 OR id=16052 OR id=16659 OR id=16050 OR id=16038 OR id=12853 OR id=13203 OR id=13875 OR id=15546 OR id=13887 OR id=13030 OR id=11669 OR id=15698 OR id=15797 OR id=15874 OR id=16014 OR id=15910 OR id=15752 OR id=15947 OR id=15873 OR id=15832 OR id=15825 OR id=15835 OR id=16032 OR id=15756 OR id=16465 OR id=16520 OR id=15921 OR id=15369 OR id=4879 OR id=10315 OR id=15580 OR id=10324 OR id=15455 OR id=13839 OR id=12889 OR id=15571 OR id=16437 OR id=16872 OR id=15012 OR id=12013 OR id=14126 OR id=12009 OR id=11230 OR id=12122 OR id=13411 OR id=11967 OR id=15969 OR id=14187 OR id=15929 OR id=10481 OR id=14557 OR id=13907 OR id=15876 OR id=15754 OR id=15456 OR id=15829 OR id=15452 OR id=15378 OR id=16308 OR id=16269 OR id=16232 OR id=16627 OR id=12682 OR id=11575 OR id=14224 OR id=14180 OR id=15539 OR id=15802 OR id=13703 OR id=15254 OR id=14129 OR id=16119 OR id=16118 OR id=16496 OR id=16470 OR id=16455 OR id=10440 OR id=13834 OR id=15376 OR id=13894 OR id=12599 OR id=15404 OR id=15037 OR id=15893 OR id=13903 OR id=16421 OR id=11779 OR id=13455 OR id=13736 OR id=15079 OR id=15084 OR id=16261 OR id=15723 OR id=15808 OR id=15775 OR id=12718 OR id=9633 OR id=15859 OR id=13912 OR id=13044 OR id=16519 OR id=12834 OR id=14543 OR id=14223 OR id=15366 OR id=12487 OR id=15877 OR id=13715 OR id=13779 OR id=15252 OR id=15176 OR id=13686 OR id=12872 OR id=15394 OR id=13908 OR id=15663 OR id=13997 OR id=15863 OR id=13828 OR id=15671 OR id=16130 OR id=13922 OR id=15861 OR id=15899 OR id=13847 OR id=14562 OR id=11705 OR id=14195 OR id=12747 OR id=11923 OR id=14260 OR id=11547 OR id=14374 OR id=14240 OR id=15432 OR id=8065 OR id=14871 OR id=12840 OR id=15116 OR id=11450 OR id=12965 OR id=14235 OR id=14707 OR id=15817 OR id=14156 OR id=13986 OR id=13862 OR id=14481 OR id=12481 OR id=12715 OR id=15686 OR id=16044 OR id=11474 OR id=16960 OR id=14722 OR id=8056 OR id=14164 OR id=12432 OR id=15770 OR id=13738 OR id=15962 OR id=14940 OR id=15357 OR id=15358 OR id=15361 OR id=15362 OR id=12864 OR id=14370 OR id=14363 OR id=15367 OR id=14028 OR id=16063 OR id=13799 OR id=15001 OR id=16076 OR id=15178 OR id=15865 OR id=15266 OR id=15875 OR id=15182 OR id=15181 OR id=15278 OR id=15306 OR id=15287 OR id=15111 OR id=15900 OR id=15016 OR id=13801 OR id=16106 OR id=12274 OR id=15768 OR id=11821 OR id=16430 OR id=16435 OR id=11980 OR id=13575 OR id=16345 OR id=12110 OR id=15424 OR id=16467 OR id=13651 OR id=16422 OR id=13660 OR id=13650 OR id=13649 OR id=13647 OR id=13640 OR id=13634 OR id=13587 OR id=13528 OR id=10952 OR id=12234 OR id=12238 OR id=11839 OR id=11757 OR id=16309 OR id=11215 OR id=16343 )ORDER BY CASE produit WHEN 8449 THEN (num*0.2)+1 WHEN 7558 THEN (num*0.2)+2 WHEN 7543 THEN (num*0.2)+3 WHEN 9413 THEN (num*0.2)+4 WHEN 7731 THEN (num*0.2)+5 WHEN 7382 THEN (num*0.2)+6 WHEN 9284 THEN (num*0.2)+7 WHEN 9201 THEN (num*0.2)+8 WHEN 8867 THEN (num*0.2)+9 WHEN 9374 THEN (num*0.2)+10 WHEN 7139 THEN (num*0.2)+11 WHEN 8031 THEN (num*0.2)+12 WHEN 7961 THEN (num*0.2)+13 WHEN 6804 THEN (num*0.2)+14 WHEN 7921 THEN (num*0.2)+15 WHEN 8572 THEN (num*0.2)+16 WHEN 9131 THEN (num*0.2)+17 WHEN 4432 THEN (num*0.2)+18 WHEN 8799 THEN (num*0.2)+19 WHEN 8582 THEN (num*0.2)+20 WHEN 9236 THEN (num*0.2)+21 WHEN 5649 THEN (num*0.2)+22 WHEN 9281 THEN (num*0.2)+23 WHEN 8706 THEN (num*0.2)+24 WHEN 3002 THEN (num*0.2)+25 WHEN 7556 THEN (num*0.2)+26 WHEN 9515 THEN (num*0.2)+27 WHEN 9514 THEN (num*0.2)+28 WHEN 9513 THEN (num*0.2)+29 WHEN 9512 THEN (num*0.2)+30 WHEN 8656 THEN (num*0.2)+31 WHEN 7545 THEN (num*0.2)+32 WHEN 9287 THEN (num*0.2)+33 WHEN 8643 THEN (num*0.2)+34 WHEN 9290 THEN (num*0.2)+35 WHEN 9175 THEN (num*0.2)+36 WHEN 8581 THEN (num*0.2)+37 WHEN 8342 THEN (num*0.2)+38 WHEN 8522 THEN (num*0.2)+39 WHEN 8583 THEN (num*0.2)+40 WHEN 7542 THEN (num*0.2)+41 WHEN 5535 THEN (num*0.2)+42 WHEN 7554 THEN (num*0.2)+43 WHEN 8642 THEN (num*0.2)+44 WHEN 9286 THEN (num*0.2)+45 WHEN 6291 THEN (num*0.2)+46 WHEN 9299 THEN (num*0.2)+47 WHEN 7268 THEN (num*0.2)+48 WHEN 7541 THEN (num*0.2)+49 WHEN 8576 THEN (num*0.2)+50 WHEN 7544 THEN (num*0.2)+51 WHEN 9282 THEN (num*0.2)+52 WHEN 6296 THEN (num*0.2)+53 WHEN 6390 THEN (num*0.2)+54 WHEN 7267 THEN (num*0.2)+55 WHEN 6492 THEN (num*0.2)+56 WHEN 9283 THEN (num*0.2)+57 WHEN 7726 THEN (num*0.2)+58 WHEN 9457 THEN (num*0.2)+59 WHEN 9456 THEN (num*0.2)+60 WHEN 9455 THEN (num*0.2)+61 WHEN 8578 THEN (num*0.2)+62 WHEN 7368 THEN (num*0.2)+63 WHEN 7226 THEN (num*0.2)+64 WHEN 9454 THEN (num*0.2)+65 WHEN 9453 THEN (num*0.2)+66 WHEN 8579 THEN (num*0.2)+67 WHEN 9452 THEN (num*0.2)+68 WHEN 9001 THEN (num*0.2)+69 WHEN 6859 THEN (num*0.2)+70 WHEN 9451 THEN (num*0.2)+71 WHEN 9445 THEN (num*0.2)+72 WHEN 8573 THEN (num*0.2)+73 WHEN 8577 THEN (num*0.2)+74 WHEN 8711 THEN (num*0.2)+75 WHEN 8960 THEN (num*0.2)+76 WHEN 7897 THEN (num*0.2)+77 WHEN 5537 THEN (num*0.2)+78 WHEN 8959 THEN (num*0.2)+79 WHEN 7142 THEN (num*0.2)+80 WHEN 6491 THEN (num*0.2)+81 WHEN 8584 THEN (num*0.2)+82 WHEN 9406 THEN (num*0.2)+83 WHEN 7922 THEN (num*0.2)+84 WHEN 9345 THEN (num*0.2)+85 WHEN 9343 THEN (num*0.2)+86 WHEN 9092 THEN (num*0.2)+87 WHEN 9300 THEN (num*0.2)+88 WHEN 7220 THEN (num*0.2)+89 WHEN 7416 THEN (num*0.2)+90 WHEN 9285 THEN (num*0.2)+91 WHEN 8574 THEN (num*0.2)+92 WHEN 9015 THEN (num*0.2)+93 WHEN 7898 THEN (num*0.2)+94 WHEN 6318 THEN (num*0.2)+95 WHEN 7725 THEN (num*0.2)+96 WHEN 9200 THEN (num*0.2)+97 WHEN 9235 THEN (num*0.2)+98 WHEN 9234 THEN (num*0.2)+99 WHEN 9233 THEN (num*0.2)+100 WHEN 8303 THEN (num*0.2)+101 WHEN 8660 THEN (num*0.2)+102 WHEN 7895 THEN (num*0.2)+103 WHEN 9062 THEN (num*0.2)+104 WHEN 6553 THEN (num*0.2)+105 WHEN 8447 THEN (num*0.2)+106 WHEN 8039 THEN (num*0.2)+107 WHEN 5326 THEN (num*0.2)+108 WHEN 9232 THEN (num*0.2)+109 WHEN 8575 THEN (num*0.2)+110 WHEN 9231 THEN (num*0.2)+111 WHEN 7366 THEN (num*0.2)+112 WHEN 7515 THEN (num*0.2)+113 WHEN 8037 THEN (num*0.2)+114 WHEN 6204 THEN (num*0.2)+115 WHEN 4678 THEN (num*0.2)+116 WHEN 8034 THEN (num*0.2)+117 WHEN 8397 THEN (num*0.2)+118 WHEN 3989 THEN (num*0.2)+119 WHEN 8321 THEN (num*0.2)+120 WHEN 8038 THEN (num*0.2)+121 WHEN 6562 THEN (num*0.2)+122 WHEN 7363 THEN (num*0.2)+123 WHEN 7282 THEN (num*0.2)+124 WHEN 8302 THEN (num*0.2)+125 WHEN 7364 THEN (num*0.2)+126 WHEN 8962 THEN (num*0.2)+127 WHEN 9134 THEN (num*0.2)+128 WHEN 7204 THEN (num*0.2)+129 WHEN 8040 THEN (num*0.2)+130 WHEN 8476 THEN (num*0.2)+131 WHEN 4205 THEN (num*0.2)+132 WHEN 7424 THEN (num*0.2)+133 WHEN 7555 THEN (num*0.2)+134 WHEN 7896 THEN (num*0.2)+135 WHEN 8004 THEN (num*0.2)+136 WHEN 7361 THEN (num*0.2)+137 WHEN 6317 THEN (num*0.2)+138 WHEN 6955 THEN (num*0.2)+139 WHEN 7437 THEN (num*0.2)+140 WHEN 7362 THEN (num*0.2)+141 WHEN 6096 THEN (num*0.2)+142 WHEN 7446 THEN (num*0.2)+143 WHEN 8029 THEN (num*0.2)+144 WHEN 8222 THEN (num*0.2)+145 WHEN 7495 THEN (num*0.2)+146 WHEN 7436 THEN (num*0.2)+147 WHEN 7430 THEN (num*0.2)+148 WHEN 7383 THEN (num*0.2)+149 WHEN 7365 THEN (num*0.2)+150 WHEN 7729 THEN (num*0.2)+151 WHEN 7444 THEN (num*0.2)+152 WHEN 7372 THEN (num*0.2)+153 WHEN 3918 THEN (num*0.2)+154 WHEN 7438 THEN (num*0.2)+155 WHEN 6727 THEN (num*0.2)+156 WHEN 8083 THEN (num*0.2)+157 WHEN 8264 THEN (num*0.2)+158 WHEN 5332 THEN (num*0.2)+159 WHEN 7782 THEN (num*0.2)+160 WHEN 7447 THEN (num*0.2)+161 WHEN 7442 THEN (num*0.2)+162 WHEN 7302 THEN (num*0.2)+163 WHEN 5325 THEN (num*0.2)+164 WHEN 8078 THEN (num*0.2)+165 WHEN 6958 THEN (num*0.2)+166 WHEN 7783 THEN (num*0.2)+167 WHEN 7367 THEN (num*0.2)+168 WHEN 7519 THEN (num*0.2)+169 WHEN 6407 THEN (num*0.2)+170 WHEN 7371 THEN (num*0.2)+171 WHEN 7441 THEN (num*0.2)+172 WHEN 7427 THEN (num*0.2)+173 WHEN 7781 THEN (num*0.2)+174 WHEN 7429 THEN (num*0.2)+175 WHEN 7373 THEN (num*0.2)+176 WHEN 7435 THEN (num*0.2)+177 WHEN 7233 THEN (num*0.2)+178 WHEN 6650 THEN (num*0.2)+179 WHEN 7443 THEN (num*0.2)+180 WHEN 6668 THEN (num*0.2)+181 WHEN 7419 THEN (num*0.2)+182 WHEN 6818 THEN (num*0.2)+183 WHEN 7724 THEN (num*0.2)+184 WHEN 7440 THEN (num*0.2)+185 WHEN 8033 THEN (num*0.2)+186 WHEN 6181 THEN (num*0.2)+187 WHEN 6926 THEN (num*0.2)+188 WHEN 7423 THEN (num*0.2)+189 WHEN 6314 THEN (num*0.2)+190 WHEN 7434 THEN (num*0.2)+191 WHEN 6582 THEN (num*0.2)+192 WHEN 7017 THEN (num*0.2)+193 WHEN 7979 THEN (num*0.2)+194 WHEN 7660 THEN (num*0.2)+195 WHEN 7727 THEN (num*0.2)+196 WHEN 8475 THEN (num*0.2)+197 WHEN 8710 THEN (num*0.2)+198 WHEN 8714 THEN (num*0.2)+199 WHEN 8571 THEN (num*0.2)+200 WHEN 6642 THEN (num*0.2)+201 WHEN 9088 THEN (num*0.2)+202 WHEN 5827 THEN (num*0.2)+203 WHEN 6667 THEN (num*0.2)+204 WHEN 8112 THEN (num*0.2)+205 WHEN 7392 THEN (num*0.2)+206 WHEN 7264 THEN (num*0.2)+207 WHEN 6326 THEN (num*0.2)+208 WHEN 6627 THEN (num*0.2)+209 WHEN 6671 THEN (num*0.2)+210 WHEN 7659 THEN (num*0.2)+211 WHEN 7263 THEN (num*0.2)+212 WHEN 6942 THEN (num*0.2)+213 WHEN 6983 THEN (num*0.2)+214 WHEN 8713 THEN (num*0.2)+215 WHEN 6175 THEN (num*0.2)+216 WHEN 6082 THEN (num*0.2)+217 WHEN 6919 THEN (num*0.2)+218 WHEN 6816 THEN (num*0.2)+219 WHEN 7445 THEN (num*0.2)+220 WHEN 5330 THEN (num*0.2)+221 WHEN 6646 THEN (num*0.2)+222 WHEN 6941 THEN (num*0.2)+223 WHEN 8106 THEN (num*0.2)+224 WHEN 6332 THEN (num*0.2)+225 WHEN 6581 THEN (num*0.2)+226 WHEN 7730 THEN (num*0.2)+227 WHEN 7526 THEN (num*0.2)+228 WHEN 7261 THEN (num*0.2)+229 WHEN 8132 THEN (num*0.2)+230 WHEN 7260 THEN (num*0.2)+231 WHEN 6311 THEN (num*0.2)+232 WHEN 6592 THEN (num*0.2)+233 WHEN 7504 THEN (num*0.2)+234 WHEN 8151 THEN (num*0.2)+235 WHEN 7230 THEN (num*0.2)+236 WHEN 7499 THEN (num*0.2)+237 WHEN 7498 THEN (num*0.2)+238 WHEN 7963 THEN (num*0.2)+239 WHEN 7870 THEN (num*0.2)+240 WHEN 8580 THEN (num*0.2)+241 WHEN 6101 THEN (num*0.2)+242 WHEN 7809 THEN (num*0.2)+243 WHEN 8431 THEN (num*0.2)+244 WHEN 8159 THEN (num*0.2)+245 WHEN 6797 THEN (num*0.2)+246 WHEN 6800 THEN (num*0.2)+247 WHEN 8259 THEN (num*0.2)+248 WHEN 8712 THEN (num*0.2)+249 WHEN 7962 THEN (num*0.2)+250 WHEN 8716 THEN (num*0.2)+251 WHEN 6301 THEN (num*0.2)+252 WHEN 8175 THEN (num*0.2)+253 WHEN 6595 THEN (num*0.2)+254 WHEN 6313 THEN (num*0.2)+255 WHEN 6441 THEN (num*0.2)+256 WHEN 6458 THEN (num*0.2)+257 WHEN 8715 THEN (num*0.2)+258 WHEN 8035 THEN (num*0.2)+259 WHEN 7262 THEN (num*0.2)+260 WHEN 7211 THEN (num*0.2)+261 WHEN 7510 THEN (num*0.2)+262 WHEN 8105 THEN (num*0.2)+263 WHEN 7728 THEN (num*0.2)+264 WHEN 6558 THEN (num*0.2)+265 END,numErr153a