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,7800,7664,7927,7873,8447,6716)  AND produit NOT IN( ) AND ( id=11664 OR id=14677 OR id=16842 OR id=16836 OR id=16651 OR id=16648 OR id=15764 OR id=15716 OR id=15653 OR id=15696 OR id=15639 OR id=14931 OR id=14647 OR id=14397 OR id=11654 OR id=11645 OR id=11651 OR id=3939 )ORDER BY CASE produit WHEN 7800 THEN (num*0.2)+1 WHEN 7664 THEN (num*0.2)+2 WHEN 7927 THEN (num*0.2)+3 WHEN 7873 THEN (num*0.2)+4 WHEN 8447 THEN (num*0.2)+5 WHEN 6716 THEN (num*0.2)+6 END,numErr153a