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,7748,8362,6894,6258,7918,6257,6716,6255,6252,7818,6259,9136,9072,7873,7830,8355,8379,4149,8416,8415,9107,7664,8356,9162,8447,9082,6256,4147,4143,4626,8371,8312,8372,8421,8358,7917,8359,6251,8353,7916,8383,8361,7767,8254,6938,4250,7778,7856,6253,4146,8260,8311,8256,8255,8380,6713,7889,6680,7803,7747,7648,8385)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7748 THEN (num*3)+1 WHEN 8362 THEN (num*3)+2 WHEN 6894 THEN (num*3)+3 WHEN 6258 THEN (num*3)+4 WHEN 7918 THEN (num*3)+5 WHEN 6257 THEN (num*3)+6 WHEN 6716 THEN (num*3)+7 WHEN 6255 THEN (num*3)+8 WHEN 6252 THEN (num*3)+9 WHEN 7818 THEN (num*3)+10 WHEN 6259 THEN (num*3)+11 WHEN 9136 THEN (num*3)+12 WHEN 9072 THEN (num*3)+13 WHEN 7873 THEN (num*3)+14 WHEN 7830 THEN (num*3)+15 WHEN 8355 THEN (num*3)+16 WHEN 8379 THEN (num*3)+17 WHEN 4149 THEN (num*3)+18 WHEN 8416 THEN (num*3)+19 WHEN 8415 THEN (num*3)+20 WHEN 9107 THEN (num*3)+21 WHEN 7664 THEN (num*3)+22 WHEN 8356 THEN (num*3)+23 WHEN 9162 THEN (num*3)+24 WHEN 8447 THEN (num*3)+25 WHEN 9082 THEN (num*3)+26 WHEN 6256 THEN (num*3)+27 WHEN 4147 THEN (num*3)+28 WHEN 4143 THEN (num*3)+29 WHEN 4626 THEN (num*3)+30 WHEN 8371 THEN (num*3)+31 WHEN 8312 THEN (num*3)+32 WHEN 8372 THEN (num*3)+33 WHEN 8421 THEN (num*3)+34 WHEN 8358 THEN (num*3)+35 WHEN 7917 THEN (num*3)+36 WHEN 8359 THEN (num*3)+37 WHEN 6251 THEN (num*3)+38 WHEN 8353 THEN (num*3)+39 WHEN 7916 THEN (num*3)+40 WHEN 8383 THEN (num*3)+41 WHEN 8361 THEN (num*3)+42 WHEN 7767 THEN (num*3)+43 WHEN 8254 THEN (num*3)+44 WHEN 6938 THEN (num*3)+45 WHEN 4250 THEN (num*3)+46 WHEN 7778 THEN (num*3)+47 WHEN 7856 THEN (num*3)+48 WHEN 6253 THEN (num*3)+49 WHEN 4146 THEN (num*3)+50 WHEN 8260 THEN (num*3)+51 WHEN 8311 THEN (num*3)+52 WHEN 8256 THEN (num*3)+53 WHEN 8255 THEN (num*3)+54 WHEN 8380 THEN (num*3)+55 WHEN 6713 THEN (num*3)+56 WHEN 7889 THEN (num*3)+57 WHEN 6680 THEN (num*3)+58 WHEN 7803 THEN (num*3)+59 WHEN 7747 THEN (num*3)+60 WHEN 7648 THEN (num*3)+61 WHEN 8385 THEN (num*3)+62 END,numErr153a