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