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,7545,6599,3827,6504,2461,6109,1814,7543,9225,8735,5133,6132,5132,6601,6604,1809,6503,1811,6602,3191,5109,8734,5511,6610,3196,6612,5111,6108,6505,6603,6106,6565,7387,6506,7450,5987,6508,6004,6596,5656,7328,7522,8020,6502,7448,6597,5985,7451,7523,8737,8019,7556,8018,8016,6598,6611,7472,8017,7411,6564,7473,5967,7554,5966,5745,7541,7329,7331,7470,7210,6609,5994,6566,6001,8171,2462,7542,5744,7485,5991,6000,5989,5997,7544,5969,8170,1818,8010,7532,6633,7378,6647,6341,8169,6866)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%'ORDER BY CASE produit WHEN 7545 THEN (num*4)+1 WHEN 6599 THEN (num*4)+2 WHEN 3827 THEN (num*4)+3 WHEN 6504 THEN (num*4)+4 WHEN 2461 THEN (num*4)+5 WHEN 6109 THEN (num*4)+6 WHEN 1814 THEN (num*4)+7 WHEN 7543 THEN (num*4)+8 WHEN 9225 THEN (num*4)+9 WHEN 8735 THEN (num*4)+10 WHEN 5133 THEN (num*4)+11 WHEN 6132 THEN (num*4)+12 WHEN 5132 THEN (num*4)+13 WHEN 6601 THEN (num*4)+14 WHEN 6604 THEN (num*4)+15 WHEN 1809 THEN (num*4)+16 WHEN 6503 THEN (num*4)+17 WHEN 1811 THEN (num*4)+18 WHEN 6602 THEN (num*4)+19 WHEN 3191 THEN (num*4)+20 WHEN 5109 THEN (num*4)+21 WHEN 8734 THEN (num*4)+22 WHEN 5511 THEN (num*4)+23 WHEN 6610 THEN (num*4)+24 WHEN 3196 THEN (num*4)+25 WHEN 6612 THEN (num*4)+26 WHEN 5111 THEN (num*4)+27 WHEN 6108 THEN (num*4)+28 WHEN 6505 THEN (num*4)+29 WHEN 6603 THEN (num*4)+30 WHEN 6106 THEN (num*4)+31 WHEN 6565 THEN (num*4)+32 WHEN 7387 THEN (num*4)+33 WHEN 6506 THEN (num*4)+34 WHEN 7450 THEN (num*4)+35 WHEN 5987 THEN (num*4)+36 WHEN 6508 THEN (num*4)+37 WHEN 6004 THEN (num*4)+38 WHEN 6596 THEN (num*4)+39 WHEN 5656 THEN (num*4)+40 WHEN 7328 THEN (num*4)+41 WHEN 7522 THEN (num*4)+42 WHEN 8020 THEN (num*4)+43 WHEN 6502 THEN (num*4)+44 WHEN 7448 THEN (num*4)+45 WHEN 6597 THEN (num*4)+46 WHEN 5985 THEN (num*4)+47 WHEN 7451 THEN (num*4)+48 WHEN 7523 THEN (num*4)+49 WHEN 8737 THEN (num*4)+50 WHEN 8019 THEN (num*4)+51 WHEN 7556 THEN (num*4)+52 WHEN 8018 THEN (num*4)+53 WHEN 8016 THEN (num*4)+54 WHEN 6598 THEN (num*4)+55 WHEN 6611 THEN (num*4)+56 WHEN 7472 THEN (num*4)+57 WHEN 8017 THEN (num*4)+58 WHEN 7411 THEN (num*4)+59 WHEN 6564 THEN (num*4)+60 WHEN 7473 THEN (num*4)+61 WHEN 5967 THEN (num*4)+62 WHEN 7554 THEN (num*4)+63 WHEN 5966 THEN (num*4)+64 WHEN 5745 THEN (num*4)+65 WHEN 7541 THEN (num*4)+66 WHEN 7329 THEN (num*4)+67 WHEN 7331 THEN (num*4)+68 WHEN 7470 THEN (num*4)+69 WHEN 7210 THEN (num*4)+70 WHEN 6609 THEN (num*4)+71 WHEN 5994 THEN (num*4)+72 WHEN 6566 THEN (num*4)+73 WHEN 6001 THEN (num*4)+74 WHEN 8171 THEN (num*4)+75 WHEN 2462 THEN (num*4)+76 WHEN 7542 THEN (num*4)+77 WHEN 5744 THEN (num*4)+78 WHEN 7485 THEN (num*4)+79 WHEN 5991 THEN (num*4)+80 WHEN 6000 THEN (num*4)+81 WHEN 5989 THEN (num*4)+82 WHEN 5997 THEN (num*4)+83 WHEN 7544 THEN (num*4)+84 WHEN 5969 THEN (num*4)+85 WHEN 8170 THEN (num*4)+86 WHEN 1818 THEN (num*4)+87 WHEN 8010 THEN (num*4)+88 WHEN 7532 THEN (num*4)+89 WHEN 6633 THEN (num*4)+90 WHEN 7378 THEN (num*4)+91 WHEN 6647 THEN (num*4)+92 WHEN 6341 THEN (num*4)+93 WHEN 8169 THEN (num*4)+94 WHEN 6866 THEN (num*4)+95 END,numErr153a