SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,1205,9464,9466,9465,997,8064,8066,8065,8063,7877,994)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 1205 THEN (num*1)+1 WHEN 9464 THEN (num*1)+2 WHEN 9466 THEN (num*1)+3 WHEN 9465 THEN (num*1)+4 WHEN 997 THEN (num*1)+5 WHEN 8064 THEN (num*1)+6 WHEN 8066 THEN (num*1)+7 WHEN 8065 THEN (num*1)+8 WHEN 8063 THEN (num*1)+9 WHEN 7877 THEN (num*1)+10 WHEN 994 THEN (num*1)+11 END,numErr153a