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,5950,7299,9257,9395,9449,7991,9340,9228,9241,9274,9330,9293,9265,9475,9332,9498,9245,9491,9313,9255,9486,9254,9481,9461,8878,9460,9440,9359,9292,8850,9271,3621,9246,6109,3168,8861,6108,8827,8846,8752,8828,7493,7987,8829,8080,8123,7993,7989,8742,7992,8830,8771,7323,8614,7296,8792,8707,8796,7293,8778,8145,8122,8770,8613,8119,8673,7325,7276,8641,7291,7396,7314,7312,7986,7283,7494,8049,7227,7984,8795,7272,6866,7335)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%'ORDER BY CASE produit WHEN 5950 THEN (num*3)+1 WHEN 7299 THEN (num*3)+2 WHEN 9257 THEN (num*3)+3 WHEN 9395 THEN (num*3)+4 WHEN 9449 THEN (num*3)+5 WHEN 7991 THEN (num*3)+6 WHEN 9340 THEN (num*3)+7 WHEN 9228 THEN (num*3)+8 WHEN 9241 THEN (num*3)+9 WHEN 9274 THEN (num*3)+10 WHEN 9330 THEN (num*3)+11 WHEN 9293 THEN (num*3)+12 WHEN 9265 THEN (num*3)+13 WHEN 9475 THEN (num*3)+14 WHEN 9332 THEN (num*3)+15 WHEN 9498 THEN (num*3)+16 WHEN 9245 THEN (num*3)+17 WHEN 9491 THEN (num*3)+18 WHEN 9313 THEN (num*3)+19 WHEN 9255 THEN (num*3)+20 WHEN 9486 THEN (num*3)+21 WHEN 9254 THEN (num*3)+22 WHEN 9481 THEN (num*3)+23 WHEN 9461 THEN (num*3)+24 WHEN 8878 THEN (num*3)+25 WHEN 9460 THEN (num*3)+26 WHEN 9440 THEN (num*3)+27 WHEN 9359 THEN (num*3)+28 WHEN 9292 THEN (num*3)+29 WHEN 8850 THEN (num*3)+30 WHEN 9271 THEN (num*3)+31 WHEN 3621 THEN (num*3)+32 WHEN 9246 THEN (num*3)+33 WHEN 6109 THEN (num*3)+34 WHEN 3168 THEN (num*3)+35 WHEN 8861 THEN (num*3)+36 WHEN 6108 THEN (num*3)+37 WHEN 8827 THEN (num*3)+38 WHEN 8846 THEN (num*3)+39 WHEN 8752 THEN (num*3)+40 WHEN 8828 THEN (num*3)+41 WHEN 7493 THEN (num*3)+42 WHEN 7987 THEN (num*3)+43 WHEN 8829 THEN (num*3)+44 WHEN 8080 THEN (num*3)+45 WHEN 8123 THEN (num*3)+46 WHEN 7993 THEN (num*3)+47 WHEN 7989 THEN (num*3)+48 WHEN 8742 THEN (num*3)+49 WHEN 7992 THEN (num*3)+50 WHEN 8830 THEN (num*3)+51 WHEN 8771 THEN (num*3)+52 WHEN 7323 THEN (num*3)+53 WHEN 8614 THEN (num*3)+54 WHEN 7296 THEN (num*3)+55 WHEN 8792 THEN (num*3)+56 WHEN 8707 THEN (num*3)+57 WHEN 8796 THEN (num*3)+58 WHEN 7293 THEN (num*3)+59 WHEN 8778 THEN (num*3)+60 WHEN 8145 THEN (num*3)+61 WHEN 8122 THEN (num*3)+62 WHEN 8770 THEN (num*3)+63 WHEN 8613 THEN (num*3)+64 WHEN 8119 THEN (num*3)+65 WHEN 8673 THEN (num*3)+66 WHEN 7325 THEN (num*3)+67 WHEN 7276 THEN (num*3)+68 WHEN 8641 THEN (num*3)+69 WHEN 7291 THEN (num*3)+70 WHEN 7396 THEN (num*3)+71 WHEN 7314 THEN (num*3)+72 WHEN 7312 THEN (num*3)+73 WHEN 7986 THEN (num*3)+74 WHEN 7283 THEN (num*3)+75 WHEN 7494 THEN (num*3)+76 WHEN 8049 THEN (num*3)+77 WHEN 7227 THEN (num*3)+78 WHEN 7984 THEN (num*3)+79 WHEN 8795 THEN (num*3)+80 WHEN 7272 THEN (num*3)+81 WHEN 6866 THEN (num*3)+82 WHEN 7335 THEN (num*3)+83 END,numErr153a