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,7647,7868,7462,7459,3479,6899,7873,6655,9365,9084,9366,8483,9369,6723,6259,9278,8362,5190,7492,9289,9525,6443,4149,7469,9230,6680,7919,6932,7664,9270,8385,7800,7673,7743,6944,9268,6716,9276,7918,9275,7830,4143,9404,7917,7592,4626,9107,8372,8371,7856,6255,6253,8358,4147,8383,8384,9086,8258,7763,8256,4250,8378,8380,8311,8447,8254,7916,7920,8416,8255,6256,8415,7927,8377,8355,8345,8361,7767,7741,3463,9083,8253,7771,8421,7212,6947,8260,1288,7778,8344,8379,8356,8351,8349,9082,8346,9161,8348,8967,6938,6858,1281,8347,8359,6713,7732,7456,6449,7826,4257,6454,7742,8396,8450,8353,7023,7733,7621,7594,7661,7926,7457,7597,8442,6709,6894,4146,7889,6922,9136,8312,7803,7925,7622,6258,7662,7801,7748,7747,8350,5937)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7647 THEN (num*6)+1 WHEN 7868 THEN (num*6)+2 WHEN 7462 THEN (num*6)+3 WHEN 7459 THEN (num*6)+4 WHEN 3479 THEN (num*6)+5 WHEN 6899 THEN (num*6)+6 WHEN 7873 THEN (num*6)+7 WHEN 6655 THEN (num*6)+8 WHEN 9365 THEN (num*6)+9 WHEN 9084 THEN (num*6)+10 WHEN 9366 THEN (num*6)+11 WHEN 8483 THEN (num*6)+12 WHEN 9369 THEN (num*6)+13 WHEN 6723 THEN (num*6)+14 WHEN 6259 THEN (num*6)+15 WHEN 9278 THEN (num*6)+16 WHEN 8362 THEN (num*6)+17 WHEN 5190 THEN (num*6)+18 WHEN 7492 THEN (num*6)+19 WHEN 9289 THEN (num*6)+20 WHEN 9525 THEN (num*6)+21 WHEN 6443 THEN (num*6)+22 WHEN 4149 THEN (num*6)+23 WHEN 7469 THEN (num*6)+24 WHEN 9230 THEN (num*6)+25 WHEN 6680 THEN (num*6)+26 WHEN 7919 THEN (num*6)+27 WHEN 6932 THEN (num*6)+28 WHEN 7664 THEN (num*6)+29 WHEN 9270 THEN (num*6)+30 WHEN 8385 THEN (num*6)+31 WHEN 7800 THEN (num*6)+32 WHEN 7673 THEN (num*6)+33 WHEN 7743 THEN (num*6)+34 WHEN 6944 THEN (num*6)+35 WHEN 9268 THEN (num*6)+36 WHEN 6716 THEN (num*6)+37 WHEN 9276 THEN (num*6)+38 WHEN 7918 THEN (num*6)+39 WHEN 9275 THEN (num*6)+40 WHEN 7830 THEN (num*6)+41 WHEN 4143 THEN (num*6)+42 WHEN 9404 THEN (num*6)+43 WHEN 7917 THEN (num*6)+44 WHEN 7592 THEN (num*6)+45 WHEN 4626 THEN (num*6)+46 WHEN 9107 THEN (num*6)+47 WHEN 8372 THEN (num*6)+48 WHEN 8371 THEN (num*6)+49 WHEN 7856 THEN (num*6)+50 WHEN 6255 THEN (num*6)+51 WHEN 6253 THEN (num*6)+52 WHEN 8358 THEN (num*6)+53 WHEN 4147 THEN (num*6)+54 WHEN 8383 THEN (num*6)+55 WHEN 8384 THEN (num*6)+56 WHEN 9086 THEN (num*6)+57 WHEN 8258 THEN (num*6)+58 WHEN 7763 THEN (num*6)+59 WHEN 8256 THEN (num*6)+60 WHEN 4250 THEN (num*6)+61 WHEN 8378 THEN (num*6)+62 WHEN 8380 THEN (num*6)+63 WHEN 8311 THEN (num*6)+64 WHEN 8447 THEN (num*6)+65 WHEN 8254 THEN (num*6)+66 WHEN 7916 THEN (num*6)+67 WHEN 7920 THEN (num*6)+68 WHEN 8416 THEN (num*6)+69 WHEN 8255 THEN (num*6)+70 WHEN 6256 THEN (num*6)+71 WHEN 8415 THEN (num*6)+72 WHEN 7927 THEN (num*6)+73 WHEN 8377 THEN (num*6)+74 WHEN 8355 THEN (num*6)+75 WHEN 8345 THEN (num*6)+76 WHEN 8361 THEN (num*6)+77 WHEN 7767 THEN (num*6)+78 WHEN 7741 THEN (num*6)+79 WHEN 3463 THEN (num*6)+80 WHEN 9083 THEN (num*6)+81 WHEN 8253 THEN (num*6)+82 WHEN 7771 THEN (num*6)+83 WHEN 8421 THEN (num*6)+84 WHEN 7212 THEN (num*6)+85 WHEN 6947 THEN (num*6)+86 WHEN 8260 THEN (num*6)+87 WHEN 1288 THEN (num*6)+88 WHEN 7778 THEN (num*6)+89 WHEN 8344 THEN (num*6)+90 WHEN 8379 THEN (num*6)+91 WHEN 8356 THEN (num*6)+92 WHEN 8351 THEN (num*6)+93 WHEN 8349 THEN (num*6)+94 WHEN 9082 THEN (num*6)+95 WHEN 8346 THEN (num*6)+96 WHEN 9161 THEN (num*6)+97 WHEN 8348 THEN (num*6)+98 WHEN 8967 THEN (num*6)+99 WHEN 6938 THEN (num*6)+100 WHEN 6858 THEN (num*6)+101 WHEN 1281 THEN (num*6)+102 WHEN 8347 THEN (num*6)+103 WHEN 8359 THEN (num*6)+104 WHEN 6713 THEN (num*6)+105 WHEN 7732 THEN (num*6)+106 WHEN 7456 THEN (num*6)+107 WHEN 6449 THEN (num*6)+108 WHEN 7826 THEN (num*6)+109 WHEN 4257 THEN (num*6)+110 WHEN 6454 THEN (num*6)+111 WHEN 7742 THEN (num*6)+112 WHEN 8396 THEN (num*6)+113 WHEN 8450 THEN (num*6)+114 WHEN 8353 THEN (num*6)+115 WHEN 7023 THEN (num*6)+116 WHEN 7733 THEN (num*6)+117 WHEN 7621 THEN (num*6)+118 WHEN 7594 THEN (num*6)+119 WHEN 7661 THEN (num*6)+120 WHEN 7926 THEN (num*6)+121 WHEN 7457 THEN (num*6)+122 WHEN 7597 THEN (num*6)+123 WHEN 8442 THEN (num*6)+124 WHEN 6709 THEN (num*6)+125 WHEN 6894 THEN (num*6)+126 WHEN 4146 THEN (num*6)+127 WHEN 7889 THEN (num*6)+128 WHEN 6922 THEN (num*6)+129 WHEN 9136 THEN (num*6)+130 WHEN 8312 THEN (num*6)+131 WHEN 7803 THEN (num*6)+132 WHEN 7925 THEN (num*6)+133 WHEN 7622 THEN (num*6)+134 WHEN 6258 THEN (num*6)+135 WHEN 7662 THEN (num*6)+136 WHEN 7801 THEN (num*6)+137 WHEN 7748 THEN (num*6)+138 WHEN 7747 THEN (num*6)+139 WHEN 8350 THEN (num*6)+140 WHEN 5937 THEN (num*6)+141 END,numErr153a