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,7731,9284,7139,8572,4432,8582,9236,5649,9281,8706,3002,8656,9287,8643,9290,8581,8583,5535,8642,9286,6291,9299,7268,8576,9282,6296,6390,7267,9283,7726,8578,8579,8573,8577,5537,7142,8584,9406,9345,9343,9300,9285,8574,7725,9235,9234,9233,8303,9232,8575,9231,8302,7204,7724,7727,8475,8571,6642,7264,7263,7261,7260,8580,8259,7262,7728)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7731 THEN (num*3)+1 WHEN 9284 THEN (num*3)+2 WHEN 7139 THEN (num*3)+3 WHEN 8572 THEN (num*3)+4 WHEN 4432 THEN (num*3)+5 WHEN 8582 THEN (num*3)+6 WHEN 9236 THEN (num*3)+7 WHEN 5649 THEN (num*3)+8 WHEN 9281 THEN (num*3)+9 WHEN 8706 THEN (num*3)+10 WHEN 3002 THEN (num*3)+11 WHEN 8656 THEN (num*3)+12 WHEN 9287 THEN (num*3)+13 WHEN 8643 THEN (num*3)+14 WHEN 9290 THEN (num*3)+15 WHEN 8581 THEN (num*3)+16 WHEN 8583 THEN (num*3)+17 WHEN 5535 THEN (num*3)+18 WHEN 8642 THEN (num*3)+19 WHEN 9286 THEN (num*3)+20 WHEN 6291 THEN (num*3)+21 WHEN 9299 THEN (num*3)+22 WHEN 7268 THEN (num*3)+23 WHEN 8576 THEN (num*3)+24 WHEN 9282 THEN (num*3)+25 WHEN 6296 THEN (num*3)+26 WHEN 6390 THEN (num*3)+27 WHEN 7267 THEN (num*3)+28 WHEN 9283 THEN (num*3)+29 WHEN 7726 THEN (num*3)+30 WHEN 8578 THEN (num*3)+31 WHEN 8579 THEN (num*3)+32 WHEN 8573 THEN (num*3)+33 WHEN 8577 THEN (num*3)+34 WHEN 5537 THEN (num*3)+35 WHEN 7142 THEN (num*3)+36 WHEN 8584 THEN (num*3)+37 WHEN 9406 THEN (num*3)+38 WHEN 9345 THEN (num*3)+39 WHEN 9343 THEN (num*3)+40 WHEN 9300 THEN (num*3)+41 WHEN 9285 THEN (num*3)+42 WHEN 8574 THEN (num*3)+43 WHEN 7725 THEN (num*3)+44 WHEN 9235 THEN (num*3)+45 WHEN 9234 THEN (num*3)+46 WHEN 9233 THEN (num*3)+47 WHEN 8303 THEN (num*3)+48 WHEN 9232 THEN (num*3)+49 WHEN 8575 THEN (num*3)+50 WHEN 9231 THEN (num*3)+51 WHEN 8302 THEN (num*3)+52 WHEN 7204 THEN (num*3)+53 WHEN 7724 THEN (num*3)+54 WHEN 7727 THEN (num*3)+55 WHEN 8475 THEN (num*3)+56 WHEN 8571 THEN (num*3)+57 WHEN 6642 THEN (num*3)+58 WHEN 7264 THEN (num*3)+59 WHEN 7263 THEN (num*3)+60 WHEN 7261 THEN (num*3)+61 WHEN 7260 THEN (num*3)+62 WHEN 8580 THEN (num*3)+63 WHEN 8259 THEN (num*3)+64 WHEN 7262 THEN (num*3)+65 WHEN 7728 THEN (num*3)+66 END,numErr153a