SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,9151,6879,6109,4632,9148,9147,9150,2104,6964,9225,4640,6963,6208,7888,7892,1823,5329,6232,5336,7422,7471,7894,2101,7923,7893,7384,2461,5422,8735,7420,8734,6106,6108,7887,7387,7450,7328,7451,7448,7411,8737,7432,7329,7331,8171,2462,7385,8170,1818,7414,7388,8169,6341)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%'ORDER BY CASE produit WHEN 9151 THEN (num*2)+1 WHEN 6879 THEN (num*2)+2 WHEN 6109 THEN (num*2)+3 WHEN 4632 THEN (num*2)+4 WHEN 9148 THEN (num*2)+5 WHEN 9147 THEN (num*2)+6 WHEN 9150 THEN (num*2)+7 WHEN 2104 THEN (num*2)+8 WHEN 6964 THEN (num*2)+9 WHEN 9225 THEN (num*2)+10 WHEN 4640 THEN (num*2)+11 WHEN 6963 THEN (num*2)+12 WHEN 6208 THEN (num*2)+13 WHEN 7888 THEN (num*2)+14 WHEN 7892 THEN (num*2)+15 WHEN 1823 THEN (num*2)+16 WHEN 5329 THEN (num*2)+17 WHEN 6232 THEN (num*2)+18 WHEN 5336 THEN (num*2)+19 WHEN 7422 THEN (num*2)+20 WHEN 7471 THEN (num*2)+21 WHEN 7894 THEN (num*2)+22 WHEN 2101 THEN (num*2)+23 WHEN 7923 THEN (num*2)+24 WHEN 7893 THEN (num*2)+25 WHEN 7384 THEN (num*2)+26 WHEN 2461 THEN (num*2)+27 WHEN 5422 THEN (num*2)+28 WHEN 8735 THEN (num*2)+29 WHEN 7420 THEN (num*2)+30 WHEN 8734 THEN (num*2)+31 WHEN 6106 THEN (num*2)+32 WHEN 6108 THEN (num*2)+33 WHEN 7887 THEN (num*2)+34 WHEN 7387 THEN (num*2)+35 WHEN 7450 THEN (num*2)+36 WHEN 7328 THEN (num*2)+37 WHEN 7451 THEN (num*2)+38 WHEN 7448 THEN (num*2)+39 WHEN 7411 THEN (num*2)+40 WHEN 8737 THEN (num*2)+41 WHEN 7432 THEN (num*2)+42 WHEN 7329 THEN (num*2)+43 WHEN 7331 THEN (num*2)+44 WHEN 8171 THEN (num*2)+45 WHEN 2462 THEN (num*2)+46 WHEN 7385 THEN (num*2)+47 WHEN 8170 THEN (num*2)+48 WHEN 1818 THEN (num*2)+49 WHEN 7414 THEN (num*2)+50 WHEN 7388 THEN (num*2)+51 WHEN 8169 THEN (num*2)+52 WHEN 6341 THEN (num*2)+53 END,numErr153a