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 site=4 AND produit NOT IN( ) AND ( id=15667 OR id=6657 OR id=6647 OR id=12046 OR id=11631 OR id=12983 OR id=16838 OR id=16643 OR id=15654 OR id=15642 OR id=15417 OR id=15727 OR id=15762 OR id=15489 OR id=14864 OR id=14665 OR id=14398 OR id=14253 OR id=14254 OR id=14179 OR id=13530 OR id=13932 OR id=13936 OR id=12627 OR id=12512 OR id=12497 OR id=11630 OR id=11625 OR id=11620 OR id=11658 OR id=5672 )ORDER BY CASE id WHEN 15667 THEN 0 WHEN 6657 THEN 1 WHEN 6647 THEN 2 WHEN 12046 THEN 3 WHEN 11631 THEN 4 WHEN 12983 THEN 5 WHEN 16838 THEN 6 WHEN 16643 THEN 7 WHEN 15654 THEN 8 WHEN 15642 THEN 9 WHEN 15417 THEN 10 WHEN 15727 THEN 11 WHEN 15762 THEN 12 WHEN 15489 THEN 13 WHEN 14864 THEN 14 WHEN 14665 THEN 15 WHEN 14398 THEN 16 WHEN 14253 THEN 17 WHEN 14254 THEN 18 WHEN 14179 THEN 19 WHEN 13530 THEN 20 WHEN 13932 THEN 21 WHEN 13936 THEN 22 WHEN 12627 THEN 23 WHEN 12512 THEN 24 WHEN 12497 THEN 25 WHEN 11630 THEN 26 WHEN 11625 THEN 27 WHEN 11620 THEN 28 WHEN 11658 THEN 29 WHEN 5672 THEN 30 END,numErr153a