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 produit IN(0,7556,7545,8738,7493,6109,6106,9201,9376,9439,9377,9348,9438,9436,9437,9435,9433,9434,9289,9242,9355,9394,9269,2461,9358,9347,9378,9526,9487,9325,9274,9271,9483,9482,9481,9257,9480,9446,9187,9440,9181,9432,9431,8834,9119,9375,9324,9282,8846,9146,9226,9012,9270,8844,9345,9300,9299,9229,9283,9227,9196,9188,9408,8873,9186,9236,9235,9234,8763,9233,9232,9231,9228,8736,8772,8780,9280,8845,8741,8750,3621,2991,9009,8829,8947,9132,8742,7450,8770,6384,8163,7137,7323,5040,7993,7449,3769,8730,7952,8733,6302,7329,8469,8671,9018,8709,8137,8462,8592,9141,8080,4497,7330,8460,9081,8828,7991,9080,8468,6291,8467,8123,8771,8830,8651,8674,8591,8611,7322,8642,8792,7268,8581,8461,8466,8559,8584,5431,8583,8574,8753,8463,8582,8578,7971,8573,8655,9019,6390,8465,7770,8566,8576,8579,8577,8575,8564,7363,8683,8138,8601,6737,8122,7386,8567,8261,9079,8602,8669,8839,7978,7771,8707,9102,8076,8136,7989,8729,8752,5191,7996,6883,8614,8799,7372,7383,6732,7325,3680,8386,8898,7135,6958,8473,7011,8045,7167,7457,6383,8117,7972,7276,7396,7371,8135,7270,7997,8825,8833,8862,8835,8836,8758,8580,8838,7776,6382,4920,9142,8786,8784,8381,8760,7875,7774,7775,7777,4922,7641,7803,9103,3561,7979,2464,8769,2463,6344,6022,8142,3881,8826,8837,8863,8785,8053,7271,8759,6311,7274,6052,7494,7281,8509,9020,4898)  AND produit NOT IN( ) AND ( id=15209 OR id=17227 OR id=16151 OR id=14121 OR id=17236 OR id=17235 OR id=17233 OR id=17155 OR id=17154 OR id=17283 OR id=17208 OR id=17407 OR id=17352 OR id=17356 OR id=17349 OR id=17238 OR id=17237 OR id=17260 OR id=17338 OR id=17273 OR id=17473 OR id=17558 OR id=17550 OR id=17533 OR id=17507 OR id=17506 OR id=17246 OR id=17491 OR id=17463 OR id=17245 OR id=17224 OR id=17220 OR id=16486 OR id=17202 OR id=17189 OR id=17177 OR id=17138 OR id=17054 OR id=16280 OR id=16949 OR id=17044 OR id=16152 OR id=16998 OR id=13818 OR id=15155 OR id=16072 OR id=16937 OR id=4938 OR id=16784 OR id=16698 OR id=15406 OR id=16940 OR id=16503 OR id=16065 OR id=16299 OR id=16150 OR id=13643 OR id=15008 OR id=13803 OR id=13919 OR id=11744 OR id=12126 OR id=4935 OR id=15098 OR id=10317 OR id=16168 OR id=16788 OR id=15231 OR id=16612 OR id=16057 OR id=15527 OR id=16052 OR id=14795 OR id=16049 OR id=13913 OR id=11795 OR id=13559 OR id=13664 OR id=16158 OR id=16037 OR id=16494 OR id=16032 OR id=15384 OR id=15823 OR id=14171 OR id=15698 OR id=16013 OR id=17013 OR id=15204 OR id=15375 OR id=14170 OR id=16231 OR id=15436 OR id=14166 OR id=15720 OR id=14643 OR id=6441 OR id=15896 OR id=16504 OR id=13722 OR id=15741 OR id=15765 OR id=14183 OR id=15355 OR id=15931 OR id=12890 OR id=15538 OR id=16262 OR id=13589 OR id=15568 OR id=15366 OR id=14483 OR id=12906 OR id=15449 OR id=14208 OR id=15877 OR id=15772 OR id=14577 OR id=13962 OR id=15304 OR id=13654 OR id=15774 OR id=5089 OR id=14178 OR id=12228 OR id=13506 OR id=12346 OR id=6446 OR id=12698 OR id=14372 OR id=9996 OR id=9995 OR id=11410 OR id=9951 OR id=12431 OR id=12259 OR id=14362 OR id=13239 OR id=13577 OR id=11970 OR id=15693 OR id=15958 OR id=15959 OR id=15858 OR id=15892 OR id=16251 OR id=15895 OR id=16433 OR id=16434 OR id=16630 OR id=16714 OR id=16969 OR id=16044 OR id=15927 OR id=15116 OR id=13633 OR id=15198 OR id=13524 OR id=14368 OR id=12866 OR id=15180 OR id=15382 OR id=15865 OR id=15423 OR id=15463 OR id=15570 OR id=15722 OR id=15817 )ORDER BY CASE produit WHEN 7556 THEN (num*0.2)+1 WHEN 7545 THEN (num*0.2)+2 WHEN 8738 THEN (num*0.2)+3 WHEN 7493 THEN (num*0.2)+4 WHEN 6109 THEN (num*0.2)+5 WHEN 6106 THEN (num*0.2)+6 WHEN 9201 THEN (num*0.2)+7 WHEN 9376 THEN (num*0.2)+8 WHEN 9439 THEN (num*0.2)+9 WHEN 9377 THEN (num*0.2)+10 WHEN 9348 THEN (num*0.2)+11 WHEN 9438 THEN (num*0.2)+12 WHEN 9436 THEN (num*0.2)+13 WHEN 9437 THEN (num*0.2)+14 WHEN 9435 THEN (num*0.2)+15 WHEN 9433 THEN (num*0.2)+16 WHEN 9434 THEN (num*0.2)+17 WHEN 9289 THEN (num*0.2)+18 WHEN 9242 THEN (num*0.2)+19 WHEN 9355 THEN (num*0.2)+20 WHEN 9394 THEN (num*0.2)+21 WHEN 9269 THEN (num*0.2)+22 WHEN 2461 THEN (num*0.2)+23 WHEN 9358 THEN (num*0.2)+24 WHEN 9347 THEN (num*0.2)+25 WHEN 9378 THEN (num*0.2)+26 WHEN 9526 THEN (num*0.2)+27 WHEN 9487 THEN (num*0.2)+28 WHEN 9325 THEN (num*0.2)+29 WHEN 9274 THEN (num*0.2)+30 WHEN 9271 THEN (num*0.2)+31 WHEN 9483 THEN (num*0.2)+32 WHEN 9482 THEN (num*0.2)+33 WHEN 9481 THEN (num*0.2)+34 WHEN 9257 THEN (num*0.2)+35 WHEN 9480 THEN (num*0.2)+36 WHEN 9446 THEN (num*0.2)+37 WHEN 9187 THEN (num*0.2)+38 WHEN 9440 THEN (num*0.2)+39 WHEN 9181 THEN (num*0.2)+40 WHEN 9432 THEN (num*0.2)+41 WHEN 9431 THEN (num*0.2)+42 WHEN 8834 THEN (num*0.2)+43 WHEN 9119 THEN (num*0.2)+44 WHEN 9375 THEN (num*0.2)+45 WHEN 9324 THEN (num*0.2)+46 WHEN 9282 THEN (num*0.2)+47 WHEN 8846 THEN (num*0.2)+48 WHEN 9146 THEN (num*0.2)+49 WHEN 9226 THEN (num*0.2)+50 WHEN 9012 THEN (num*0.2)+51 WHEN 9270 THEN (num*0.2)+52 WHEN 8844 THEN (num*0.2)+53 WHEN 9345 THEN (num*0.2)+54 WHEN 9300 THEN (num*0.2)+55 WHEN 9299 THEN (num*0.2)+56 WHEN 9229 THEN (num*0.2)+57 WHEN 9283 THEN (num*0.2)+58 WHEN 9227 THEN (num*0.2)+59 WHEN 9196 THEN (num*0.2)+60 WHEN 9188 THEN (num*0.2)+61 WHEN 9408 THEN (num*0.2)+62 WHEN 8873 THEN (num*0.2)+63 WHEN 9186 THEN (num*0.2)+64 WHEN 9236 THEN (num*0.2)+65 WHEN 9235 THEN (num*0.2)+66 WHEN 9234 THEN (num*0.2)+67 WHEN 8763 THEN (num*0.2)+68 WHEN 9233 THEN (num*0.2)+69 WHEN 9232 THEN (num*0.2)+70 WHEN 9231 THEN (num*0.2)+71 WHEN 9228 THEN (num*0.2)+72 WHEN 8736 THEN (num*0.2)+73 WHEN 8772 THEN (num*0.2)+74 WHEN 8780 THEN (num*0.2)+75 WHEN 9280 THEN (num*0.2)+76 WHEN 8845 THEN (num*0.2)+77 WHEN 8741 THEN (num*0.2)+78 WHEN 8750 THEN (num*0.2)+79 WHEN 3621 THEN (num*0.2)+80 WHEN 2991 THEN (num*0.2)+81 WHEN 9009 THEN (num*0.2)+82 WHEN 8829 THEN (num*0.2)+83 WHEN 8947 THEN (num*0.2)+84 WHEN 9132 THEN (num*0.2)+85 WHEN 8742 THEN (num*0.2)+86 WHEN 7450 THEN (num*0.2)+87 WHEN 8770 THEN (num*0.2)+88 WHEN 6384 THEN (num*0.2)+89 WHEN 8163 THEN (num*0.2)+90 WHEN 7137 THEN (num*0.2)+91 WHEN 7323 THEN (num*0.2)+92 WHEN 5040 THEN (num*0.2)+93 WHEN 7993 THEN (num*0.2)+94 WHEN 7449 THEN (num*0.2)+95 WHEN 3769 THEN (num*0.2)+96 WHEN 8730 THEN (num*0.2)+97 WHEN 7952 THEN (num*0.2)+98 WHEN 8733 THEN (num*0.2)+99 WHEN 6302 THEN (num*0.2)+100 WHEN 7329 THEN (num*0.2)+101 WHEN 8469 THEN (num*0.2)+102 WHEN 8671 THEN (num*0.2)+103 WHEN 9018 THEN (num*0.2)+104 WHEN 8709 THEN (num*0.2)+105 WHEN 8137 THEN (num*0.2)+106 WHEN 8462 THEN (num*0.2)+107 WHEN 8592 THEN (num*0.2)+108 WHEN 9141 THEN (num*0.2)+109 WHEN 8080 THEN (num*0.2)+110 WHEN 4497 THEN (num*0.2)+111 WHEN 7330 THEN (num*0.2)+112 WHEN 8460 THEN (num*0.2)+113 WHEN 9081 THEN (num*0.2)+114 WHEN 8828 THEN (num*0.2)+115 WHEN 7991 THEN (num*0.2)+116 WHEN 9080 THEN (num*0.2)+117 WHEN 8468 THEN (num*0.2)+118 WHEN 6291 THEN (num*0.2)+119 WHEN 8467 THEN (num*0.2)+120 WHEN 8123 THEN (num*0.2)+121 WHEN 8771 THEN (num*0.2)+122 WHEN 8830 THEN (num*0.2)+123 WHEN 8651 THEN (num*0.2)+124 WHEN 8674 THEN (num*0.2)+125 WHEN 8591 THEN (num*0.2)+126 WHEN 8611 THEN (num*0.2)+127 WHEN 7322 THEN (num*0.2)+128 WHEN 8642 THEN (num*0.2)+129 WHEN 8792 THEN (num*0.2)+130 WHEN 7268 THEN (num*0.2)+131 WHEN 8581 THEN (num*0.2)+132 WHEN 8461 THEN (num*0.2)+133 WHEN 8466 THEN (num*0.2)+134 WHEN 8559 THEN (num*0.2)+135 WHEN 8584 THEN (num*0.2)+136 WHEN 5431 THEN (num*0.2)+137 WHEN 8583 THEN (num*0.2)+138 WHEN 8574 THEN (num*0.2)+139 WHEN 8753 THEN (num*0.2)+140 WHEN 8463 THEN (num*0.2)+141 WHEN 8582 THEN (num*0.2)+142 WHEN 8578 THEN (num*0.2)+143 WHEN 7971 THEN (num*0.2)+144 WHEN 8573 THEN (num*0.2)+145 WHEN 8655 THEN (num*0.2)+146 WHEN 9019 THEN (num*0.2)+147 WHEN 6390 THEN (num*0.2)+148 WHEN 8465 THEN (num*0.2)+149 WHEN 7770 THEN (num*0.2)+150 WHEN 8566 THEN (num*0.2)+151 WHEN 8576 THEN (num*0.2)+152 WHEN 8579 THEN (num*0.2)+153 WHEN 8577 THEN (num*0.2)+154 WHEN 8575 THEN (num*0.2)+155 WHEN 8564 THEN (num*0.2)+156 WHEN 7363 THEN (num*0.2)+157 WHEN 8683 THEN (num*0.2)+158 WHEN 8138 THEN (num*0.2)+159 WHEN 8601 THEN (num*0.2)+160 WHEN 6737 THEN (num*0.2)+161 WHEN 8122 THEN (num*0.2)+162 WHEN 7386 THEN (num*0.2)+163 WHEN 8567 THEN (num*0.2)+164 WHEN 8261 THEN (num*0.2)+165 WHEN 9079 THEN (num*0.2)+166 WHEN 8602 THEN (num*0.2)+167 WHEN 8669 THEN (num*0.2)+168 WHEN 8839 THEN (num*0.2)+169 WHEN 7978 THEN (num*0.2)+170 WHEN 7771 THEN (num*0.2)+171 WHEN 8707 THEN (num*0.2)+172 WHEN 9102 THEN (num*0.2)+173 WHEN 8076 THEN (num*0.2)+174 WHEN 8136 THEN (num*0.2)+175 WHEN 7989 THEN (num*0.2)+176 WHEN 8729 THEN (num*0.2)+177 WHEN 8752 THEN (num*0.2)+178 WHEN 5191 THEN (num*0.2)+179 WHEN 7996 THEN (num*0.2)+180 WHEN 6883 THEN (num*0.2)+181 WHEN 8614 THEN (num*0.2)+182 WHEN 8799 THEN (num*0.2)+183 WHEN 7372 THEN (num*0.2)+184 WHEN 7383 THEN (num*0.2)+185 WHEN 6732 THEN (num*0.2)+186 WHEN 7325 THEN (num*0.2)+187 WHEN 3680 THEN (num*0.2)+188 WHEN 8386 THEN (num*0.2)+189 WHEN 8898 THEN (num*0.2)+190 WHEN 7135 THEN (num*0.2)+191 WHEN 6958 THEN (num*0.2)+192 WHEN 8473 THEN (num*0.2)+193 WHEN 7011 THEN (num*0.2)+194 WHEN 8045 THEN (num*0.2)+195 WHEN 7167 THEN (num*0.2)+196 WHEN 7457 THEN (num*0.2)+197 WHEN 6383 THEN (num*0.2)+198 WHEN 8117 THEN (num*0.2)+199 WHEN 7972 THEN (num*0.2)+200 WHEN 7276 THEN (num*0.2)+201 WHEN 7396 THEN (num*0.2)+202 WHEN 7371 THEN (num*0.2)+203 WHEN 8135 THEN (num*0.2)+204 WHEN 7270 THEN (num*0.2)+205 WHEN 7997 THEN (num*0.2)+206 WHEN 8825 THEN (num*0.2)+207 WHEN 8833 THEN (num*0.2)+208 WHEN 8862 THEN (num*0.2)+209 WHEN 8835 THEN (num*0.2)+210 WHEN 8836 THEN (num*0.2)+211 WHEN 8758 THEN (num*0.2)+212 WHEN 8580 THEN (num*0.2)+213 WHEN 8838 THEN (num*0.2)+214 WHEN 7776 THEN (num*0.2)+215 WHEN 6382 THEN (num*0.2)+216 WHEN 4920 THEN (num*0.2)+217 WHEN 9142 THEN (num*0.2)+218 WHEN 8786 THEN (num*0.2)+219 WHEN 8784 THEN (num*0.2)+220 WHEN 8381 THEN (num*0.2)+221 WHEN 8760 THEN (num*0.2)+222 WHEN 7875 THEN (num*0.2)+223 WHEN 7774 THEN (num*0.2)+224 WHEN 7775 THEN (num*0.2)+225 WHEN 7777 THEN (num*0.2)+226 WHEN 4922 THEN (num*0.2)+227 WHEN 7641 THEN (num*0.2)+228 WHEN 7803 THEN (num*0.2)+229 WHEN 9103 THEN (num*0.2)+230 WHEN 3561 THEN (num*0.2)+231 WHEN 7979 THEN (num*0.2)+232 WHEN 2464 THEN (num*0.2)+233 WHEN 8769 THEN (num*0.2)+234 WHEN 2463 THEN (num*0.2)+235 WHEN 6344 THEN (num*0.2)+236 WHEN 6022 THEN (num*0.2)+237 WHEN 8142 THEN (num*0.2)+238 WHEN 3881 THEN (num*0.2)+239 WHEN 8826 THEN (num*0.2)+240 WHEN 8837 THEN (num*0.2)+241 WHEN 8863 THEN (num*0.2)+242 WHEN 8785 THEN (num*0.2)+243 WHEN 8053 THEN (num*0.2)+244 WHEN 7271 THEN (num*0.2)+245 WHEN 8759 THEN (num*0.2)+246 WHEN 6311 THEN (num*0.2)+247 WHEN 7274 THEN (num*0.2)+248 WHEN 6052 THEN (num*0.2)+249 WHEN 7494 THEN (num*0.2)+250 WHEN 7281 THEN (num*0.2)+251 WHEN 8509 THEN (num*0.2)+252 WHEN 9020 THEN (num*0.2)+253 WHEN 4898 THEN (num*0.2)+254 END,numErr153a