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 volume!=4  AND produit IN(0,7815,7814,7812,7818,7819,7816,7813,7811,7820,7817)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7815 THEN (num*1)+1 WHEN 7814 THEN (num*1)+2 WHEN 7812 THEN (num*1)+3 WHEN 7818 THEN (num*1)+4 WHEN 7819 THEN (num*1)+5 WHEN 7816 THEN (num*1)+6 WHEN 7813 THEN (num*1)+7 WHEN 7811 THEN (num*1)+8 WHEN 7820 THEN (num*1)+9 WHEN 7817 THEN (num*1)+10 END,numErr153a