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,6504,1839,1840,8020,2356,6505,8523,3777,7521,6506,6850,8434,5316,8448,5315,5321,6603,7184,7841,6565,5511,3789,7005,6564,8435,5343,8436,7473,6508,6566,5409,5436,7210)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 6504 THEN (num*2)+1 WHEN 1839 THEN (num*2)+2 WHEN 1840 THEN (num*2)+3 WHEN 8020 THEN (num*2)+4 WHEN 2356 THEN (num*2)+5 WHEN 6505 THEN (num*2)+6 WHEN 8523 THEN (num*2)+7 WHEN 3777 THEN (num*2)+8 WHEN 7521 THEN (num*2)+9 WHEN 6506 THEN (num*2)+10 WHEN 6850 THEN (num*2)+11 WHEN 8434 THEN (num*2)+12 WHEN 5316 THEN (num*2)+13 WHEN 8448 THEN (num*2)+14 WHEN 5315 THEN (num*2)+15 WHEN 5321 THEN (num*2)+16 WHEN 6603 THEN (num*2)+17 WHEN 7184 THEN (num*2)+18 WHEN 7841 THEN (num*2)+19 WHEN 6565 THEN (num*2)+20 WHEN 5511 THEN (num*2)+21 WHEN 3789 THEN (num*2)+22 WHEN 7005 THEN (num*2)+23 WHEN 6564 THEN (num*2)+24 WHEN 8435 THEN (num*2)+25 WHEN 5343 THEN (num*2)+26 WHEN 8436 THEN (num*2)+27 WHEN 7473 THEN (num*2)+28 WHEN 6508 THEN (num*2)+29 WHEN 6566 THEN (num*2)+30 WHEN 5409 THEN (num*2)+31 WHEN 5436 THEN (num*2)+32 WHEN 7210 THEN (num*2)+33 END,numErr153a