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=1 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,6944,7748,7801,8362,6922,6894,7925,6449,6258,9366,7918,6257,9084,9276,6716,6255,6252,7647,9369,9525,7846,7818,8350,6259,8483,9289,6899,9270,5937,9268,9136,8965,9278,9072,8211,9365,7873,6454,7830,8355,9230,9275,8344,9071,7673,8379,9087,8384,9070,7457,7212,4149,7920,9404,9085,9073,8416,8415,9107,8967,7664,8356,8377,9162,8447,9082,9161,9083,8966,8450,6256,4147,9086,4143,8953,4626,7826,8371,8312,8952,8372,8951,8395,8511,8421,8358,7917,8359,6251,8353,7916,8412,8383,7919,8378,8351,7763,8361,8396,7597,8349,8442,8394,7767,7592,8254,7024,6938,7926,4250,8512,8258,7778,7856,8393,8347,6862,7771,7594,6253,6858,7741,7743,8346,4146,8345,8260,8311,8256,7621,8253,8255,8380,8348,7732,7023,1288,6713,4257,7661,8044,6947,7900,6932,7662,7889,6680,7803,7747,7648,7868,7469,6723,6709,6443,7459,8385,7622)  AND produit NOT IN( ) AND ( id=15667 OR id=13950 OR id=12709 OR id=10915 OR id=14868 OR id=15733 OR id=15851 OR id=15881 OR id=15740 OR id=15735 OR id=16953 OR id=17670 OR id=16886 OR id=17428 OR id=17371 OR id=17368 OR id=17358 OR id=17367 OR id=17359 OR id=17242 OR id=17221 OR id=17209 OR id=16845 OR id=16884 OR id=16841 OR id=16834 OR id=16815 OR id=16642 OR id=16640 OR id=15725 OR id=15697 OR id=15493 OR id=15668 OR id=15666 OR id=15665 OR id=15661 OR id=15659 OR id=15655 OR id=15651 OR id=15638 OR id=15634 OR id=15618 OR id=15615 OR id=15611 OR id=15602 OR id=15600 OR id=15597 OR id=15595 OR id=15593 OR id=15588 OR id=15564 OR id=15428 OR id=15418 OR id=15523 OR id=15519 OR id=15491 OR id=14855 OR id=14581 OR id=14798 OR id=14666 OR id=14723 OR id=14570 OR id=14703 OR id=14679 OR id=14519 OR id=14225 OR id=14182 OR id=14269 OR id=13993 OR id=13927 OR id=12931 OR id=12523 OR id=12526 OR id=11635 OR id=12047 OR id=12056 OR id=11652 OR id=11661 OR id=11660 OR id=10897 OR id=8828 OR id=7480 OR id=1548 )ORDER BY CASE produit WHEN 6944 THEN (num*0.2)+1 WHEN 7748 THEN (num*0.2)+2 WHEN 7801 THEN (num*0.2)+3 WHEN 8362 THEN (num*0.2)+4 WHEN 6922 THEN (num*0.2)+5 WHEN 6894 THEN (num*0.2)+6 WHEN 7925 THEN (num*0.2)+7 WHEN 6449 THEN (num*0.2)+8 WHEN 6258 THEN (num*0.2)+9 WHEN 9366 THEN (num*0.2)+10 WHEN 7918 THEN (num*0.2)+11 WHEN 6257 THEN (num*0.2)+12 WHEN 9084 THEN (num*0.2)+13 WHEN 9276 THEN (num*0.2)+14 WHEN 6716 THEN (num*0.2)+15 WHEN 6255 THEN (num*0.2)+16 WHEN 6252 THEN (num*0.2)+17 WHEN 7647 THEN (num*0.2)+18 WHEN 9369 THEN (num*0.2)+19 WHEN 9525 THEN (num*0.2)+20 WHEN 7846 THEN (num*0.2)+21 WHEN 7818 THEN (num*0.2)+22 WHEN 8350 THEN (num*0.2)+23 WHEN 6259 THEN (num*0.2)+24 WHEN 8483 THEN (num*0.2)+25 WHEN 9289 THEN (num*0.2)+26 WHEN 6899 THEN (num*0.2)+27 WHEN 9270 THEN (num*0.2)+28 WHEN 5937 THEN (num*0.2)+29 WHEN 9268 THEN (num*0.2)+30 WHEN 9136 THEN (num*0.2)+31 WHEN 8965 THEN (num*0.2)+32 WHEN 9278 THEN (num*0.2)+33 WHEN 9072 THEN (num*0.2)+34 WHEN 8211 THEN (num*0.2)+35 WHEN 9365 THEN (num*0.2)+36 WHEN 7873 THEN (num*0.2)+37 WHEN 6454 THEN (num*0.2)+38 WHEN 7830 THEN (num*0.2)+39 WHEN 8355 THEN (num*0.2)+40 WHEN 9230 THEN (num*0.2)+41 WHEN 9275 THEN (num*0.2)+42 WHEN 8344 THEN (num*0.2)+43 WHEN 9071 THEN (num*0.2)+44 WHEN 7673 THEN (num*0.2)+45 WHEN 8379 THEN (num*0.2)+46 WHEN 9087 THEN (num*0.2)+47 WHEN 8384 THEN (num*0.2)+48 WHEN 9070 THEN (num*0.2)+49 WHEN 7457 THEN (num*0.2)+50 WHEN 7212 THEN (num*0.2)+51 WHEN 4149 THEN (num*0.2)+52 WHEN 7920 THEN (num*0.2)+53 WHEN 9404 THEN (num*0.2)+54 WHEN 9085 THEN (num*0.2)+55 WHEN 9073 THEN (num*0.2)+56 WHEN 8416 THEN (num*0.2)+57 WHEN 8415 THEN (num*0.2)+58 WHEN 9107 THEN (num*0.2)+59 WHEN 8967 THEN (num*0.2)+60 WHEN 7664 THEN (num*0.2)+61 WHEN 8356 THEN (num*0.2)+62 WHEN 8377 THEN (num*0.2)+63 WHEN 9162 THEN (num*0.2)+64 WHEN 8447 THEN (num*0.2)+65 WHEN 9082 THEN (num*0.2)+66 WHEN 9161 THEN (num*0.2)+67 WHEN 9083 THEN (num*0.2)+68 WHEN 8966 THEN (num*0.2)+69 WHEN 8450 THEN (num*0.2)+70 WHEN 6256 THEN (num*0.2)+71 WHEN 4147 THEN (num*0.2)+72 WHEN 9086 THEN (num*0.2)+73 WHEN 4143 THEN (num*0.2)+74 WHEN 8953 THEN (num*0.2)+75 WHEN 4626 THEN (num*0.2)+76 WHEN 7826 THEN (num*0.2)+77 WHEN 8371 THEN (num*0.2)+78 WHEN 8312 THEN (num*0.2)+79 WHEN 8952 THEN (num*0.2)+80 WHEN 8372 THEN (num*0.2)+81 WHEN 8951 THEN (num*0.2)+82 WHEN 8395 THEN (num*0.2)+83 WHEN 8511 THEN (num*0.2)+84 WHEN 8421 THEN (num*0.2)+85 WHEN 8358 THEN (num*0.2)+86 WHEN 7917 THEN (num*0.2)+87 WHEN 8359 THEN (num*0.2)+88 WHEN 6251 THEN (num*0.2)+89 WHEN 8353 THEN (num*0.2)+90 WHEN 7916 THEN (num*0.2)+91 WHEN 8412 THEN (num*0.2)+92 WHEN 8383 THEN (num*0.2)+93 WHEN 7919 THEN (num*0.2)+94 WHEN 8378 THEN (num*0.2)+95 WHEN 8351 THEN (num*0.2)+96 WHEN 7763 THEN (num*0.2)+97 WHEN 8361 THEN (num*0.2)+98 WHEN 8396 THEN (num*0.2)+99 WHEN 7597 THEN (num*0.2)+100 WHEN 8349 THEN (num*0.2)+101 WHEN 8442 THEN (num*0.2)+102 WHEN 8394 THEN (num*0.2)+103 WHEN 7767 THEN (num*0.2)+104 WHEN 7592 THEN (num*0.2)+105 WHEN 8254 THEN (num*0.2)+106 WHEN 7024 THEN (num*0.2)+107 WHEN 6938 THEN (num*0.2)+108 WHEN 7926 THEN (num*0.2)+109 WHEN 4250 THEN (num*0.2)+110 WHEN 8512 THEN (num*0.2)+111 WHEN 8258 THEN (num*0.2)+112 WHEN 7778 THEN (num*0.2)+113 WHEN 7856 THEN (num*0.2)+114 WHEN 8393 THEN (num*0.2)+115 WHEN 8347 THEN (num*0.2)+116 WHEN 6862 THEN (num*0.2)+117 WHEN 7771 THEN (num*0.2)+118 WHEN 7594 THEN (num*0.2)+119 WHEN 6253 THEN (num*0.2)+120 WHEN 6858 THEN (num*0.2)+121 WHEN 7741 THEN (num*0.2)+122 WHEN 7743 THEN (num*0.2)+123 WHEN 8346 THEN (num*0.2)+124 WHEN 4146 THEN (num*0.2)+125 WHEN 8345 THEN (num*0.2)+126 WHEN 8260 THEN (num*0.2)+127 WHEN 8311 THEN (num*0.2)+128 WHEN 8256 THEN (num*0.2)+129 WHEN 7621 THEN (num*0.2)+130 WHEN 8253 THEN (num*0.2)+131 WHEN 8255 THEN (num*0.2)+132 WHEN 8380 THEN (num*0.2)+133 WHEN 8348 THEN (num*0.2)+134 WHEN 7732 THEN (num*0.2)+135 WHEN 7023 THEN (num*0.2)+136 WHEN 1288 THEN (num*0.2)+137 WHEN 6713 THEN (num*0.2)+138 WHEN 4257 THEN (num*0.2)+139 WHEN 7661 THEN (num*0.2)+140 WHEN 8044 THEN (num*0.2)+141 WHEN 6947 THEN (num*0.2)+142 WHEN 7900 THEN (num*0.2)+143 WHEN 6932 THEN (num*0.2)+144 WHEN 7662 THEN (num*0.2)+145 WHEN 7889 THEN (num*0.2)+146 WHEN 6680 THEN (num*0.2)+147 WHEN 7803 THEN (num*0.2)+148 WHEN 7747 THEN (num*0.2)+149 WHEN 7648 THEN (num*0.2)+150 WHEN 7868 THEN (num*0.2)+151 WHEN 7469 THEN (num*0.2)+152 WHEN 6723 THEN (num*0.2)+153 WHEN 6709 THEN (num*0.2)+154 WHEN 6443 THEN (num*0.2)+155 WHEN 7459 THEN (num*0.2)+156 WHEN 8385 THEN (num*0.2)+157 WHEN 7622 THEN (num*0.2)+158 END,numErr153a