SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,4678,8660,3918,9233,8706,9236,8656,3002,4432,9235,6390,9234,6291,7267,9232,5535,8643,9231,7268,6296,8476,7139,8581,8583,8573,7729,8578,8576,8642,7725,8579,8577,8582,8302,8303,8572,5649,8584,7142,7204,8575,5537,8574,6650,7870,7730,7260,7261,8580,7728,7262,8259,6646,8475,7727,8571,7724,6818,6642,7263,9088,7264,7726)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%61%'ORDER BY CASE produit WHEN 7731 THEN (num*3)+1 WHEN 4678 THEN (num*3)+2 WHEN 8660 THEN (num*3)+3 WHEN 3918 THEN (num*3)+4 WHEN 9233 THEN (num*3)+5 WHEN 8706 THEN (num*3)+6 WHEN 9236 THEN (num*3)+7 WHEN 8656 THEN (num*3)+8 WHEN 3002 THEN (num*3)+9 WHEN 4432 THEN (num*3)+10 WHEN 9235 THEN (num*3)+11 WHEN 6390 THEN (num*3)+12 WHEN 9234 THEN (num*3)+13 WHEN 6291 THEN (num*3)+14 WHEN 7267 THEN (num*3)+15 WHEN 9232 THEN (num*3)+16 WHEN 5535 THEN (num*3)+17 WHEN 8643 THEN (num*3)+18 WHEN 9231 THEN (num*3)+19 WHEN 7268 THEN (num*3)+20 WHEN 6296 THEN (num*3)+21 WHEN 8476 THEN (num*3)+22 WHEN 7139 THEN (num*3)+23 WHEN 8581 THEN (num*3)+24 WHEN 8583 THEN (num*3)+25 WHEN 8573 THEN (num*3)+26 WHEN 7729 THEN (num*3)+27 WHEN 8578 THEN (num*3)+28 WHEN 8576 THEN (num*3)+29 WHEN 8642 THEN (num*3)+30 WHEN 7725 THEN (num*3)+31 WHEN 8579 THEN (num*3)+32 WHEN 8577 THEN (num*3)+33 WHEN 8582 THEN (num*3)+34 WHEN 8302 THEN (num*3)+35 WHEN 8303 THEN (num*3)+36 WHEN 8572 THEN (num*3)+37 WHEN 5649 THEN (num*3)+38 WHEN 8584 THEN (num*3)+39 WHEN 7142 THEN (num*3)+40 WHEN 7204 THEN (num*3)+41 WHEN 8575 THEN (num*3)+42 WHEN 5537 THEN (num*3)+43 WHEN 8574 THEN (num*3)+44 WHEN 6650 THEN (num*3)+45 WHEN 7870 THEN (num*3)+46 WHEN 7730 THEN (num*3)+47 WHEN 7260 THEN (num*3)+48 WHEN 7261 THEN (num*3)+49 WHEN 8580 THEN (num*3)+50 WHEN 7728 THEN (num*3)+51 WHEN 7262 THEN (num*3)+52 WHEN 8259 THEN (num*3)+53 WHEN 6646 THEN (num*3)+54 WHEN 8475 THEN (num*3)+55 WHEN 7727 THEN (num*3)+56 WHEN 8571 THEN (num*3)+57 WHEN 7724 THEN (num*3)+58 WHEN 6818 THEN (num*3)+59 WHEN 6642 THEN (num*3)+60 WHEN 7263 THEN (num*3)+61 WHEN 9088 THEN (num*3)+62 WHEN 7264 THEN (num*3)+63 WHEN 7726 THEN (num*3)+64 END,numErr153a