SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_it 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,7462,7459,9404,6899,9525,9369,8483,9366,6655,9270,7868,9365,7469,9268,7918,9278,6443,9275,9276,9289,9230,7743,7456,7492,7800,4149,7664,7742,6253,6252,6449,7741,8380,7457,7212,6454)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7462 THEN (num*2)+1 WHEN 7459 THEN (num*2)+2 WHEN 9404 THEN (num*2)+3 WHEN 6899 THEN (num*2)+4 WHEN 9525 THEN (num*2)+5 WHEN 9369 THEN (num*2)+6 WHEN 8483 THEN (num*2)+7 WHEN 9366 THEN (num*2)+8 WHEN 6655 THEN (num*2)+9 WHEN 9270 THEN (num*2)+10 WHEN 7868 THEN (num*2)+11 WHEN 9365 THEN (num*2)+12 WHEN 7469 THEN (num*2)+13 WHEN 9268 THEN (num*2)+14 WHEN 7918 THEN (num*2)+15 WHEN 9278 THEN (num*2)+16 WHEN 6443 THEN (num*2)+17 WHEN 9275 THEN (num*2)+18 WHEN 9276 THEN (num*2)+19 WHEN 9289 THEN (num*2)+20 WHEN 9230 THEN (num*2)+21 WHEN 7743 THEN (num*2)+22 WHEN 7456 THEN (num*2)+23 WHEN 7492 THEN (num*2)+24 WHEN 7800 THEN (num*2)+25 WHEN 4149 THEN (num*2)+26 WHEN 7664 THEN (num*2)+27 WHEN 7742 THEN (num*2)+28 WHEN 6253 THEN (num*2)+29 WHEN 6252 THEN (num*2)+30 WHEN 6449 THEN (num*2)+31 WHEN 7741 THEN (num*2)+32 WHEN 8380 THEN (num*2)+33 WHEN 7457 THEN (num*2)+34 WHEN 7212 THEN (num*2)+35 WHEN 6454 THEN (num*2)+36 END,numErr153a