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