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 produit IN(0,8930,6847,5443,5433,9173,5438,9021,8407,5444,5439,7013,5409,5435,7159,7158,5440,7154,6996,5873,6249)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 8930 THEN (num*1)+1 WHEN 6847 THEN (num*1)+2 WHEN 5443 THEN (num*1)+3 WHEN 5433 THEN (num*1)+4 WHEN 9173 THEN (num*1)+5 WHEN 5438 THEN (num*1)+6 WHEN 9021 THEN (num*1)+7 WHEN 8407 THEN (num*1)+8 WHEN 5444 THEN (num*1)+9 WHEN 5439 THEN (num*1)+10 WHEN 7013 THEN (num*1)+11 WHEN 5409 THEN (num*1)+12 WHEN 5435 THEN (num*1)+13 WHEN 7159 THEN (num*1)+14 WHEN 7158 THEN (num*1)+15 WHEN 5440 THEN (num*1)+16 WHEN 7154 THEN (num*1)+17 WHEN 6996 THEN (num*1)+18 WHEN 5873 THEN (num*1)+19 WHEN 6249 THEN (num*1)+20 END,numErr153a