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,8578,7282,9283,8039,6296,9345,9343,5535,9300,9299,5537,8031,9515,9514,9513,9512,7961,6804,9455,9454,9453,9282,9452,9236,9235,9234,8581,9233,7515,9232,9231,8711,8656,8643,8642,8584,8583,8580,8579,9200,8577,8576,8575,8574,8572,7725,8037,8034,7204,8038,8033,7139,6562,7268,8040,6291,7731,7142,8029,5649,7302,7261,8713,8712,7264,8710,8582,6558,7263,6642,8112,6797,7728,7727,8715,7262,8714,8716,6581,7724,6800,6627,6592,8175,6326,8106,8132,8571,6582,7726,7809,6595,8035,7504,7260,7962)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 8578 THEN (num*4)+1 WHEN 7282 THEN (num*4)+2 WHEN 9283 THEN (num*4)+3 WHEN 8039 THEN (num*4)+4 WHEN 6296 THEN (num*4)+5 WHEN 9345 THEN (num*4)+6 WHEN 9343 THEN (num*4)+7 WHEN 5535 THEN (num*4)+8 WHEN 9300 THEN (num*4)+9 WHEN 9299 THEN (num*4)+10 WHEN 5537 THEN (num*4)+11 WHEN 8031 THEN (num*4)+12 WHEN 9515 THEN (num*4)+13 WHEN 9514 THEN (num*4)+14 WHEN 9513 THEN (num*4)+15 WHEN 9512 THEN (num*4)+16 WHEN 7961 THEN (num*4)+17 WHEN 6804 THEN (num*4)+18 WHEN 9455 THEN (num*4)+19 WHEN 9454 THEN (num*4)+20 WHEN 9453 THEN (num*4)+21 WHEN 9282 THEN (num*4)+22 WHEN 9452 THEN (num*4)+23 WHEN 9236 THEN (num*4)+24 WHEN 9235 THEN (num*4)+25 WHEN 9234 THEN (num*4)+26 WHEN 8581 THEN (num*4)+27 WHEN 9233 THEN (num*4)+28 WHEN 7515 THEN (num*4)+29 WHEN 9232 THEN (num*4)+30 WHEN 9231 THEN (num*4)+31 WHEN 8711 THEN (num*4)+32 WHEN 8656 THEN (num*4)+33 WHEN 8643 THEN (num*4)+34 WHEN 8642 THEN (num*4)+35 WHEN 8584 THEN (num*4)+36 WHEN 8583 THEN (num*4)+37 WHEN 8580 THEN (num*4)+38 WHEN 8579 THEN (num*4)+39 WHEN 9200 THEN (num*4)+40 WHEN 8577 THEN (num*4)+41 WHEN 8576 THEN (num*4)+42 WHEN 8575 THEN (num*4)+43 WHEN 8574 THEN (num*4)+44 WHEN 8572 THEN (num*4)+45 WHEN 7725 THEN (num*4)+46 WHEN 8037 THEN (num*4)+47 WHEN 8034 THEN (num*4)+48 WHEN 7204 THEN (num*4)+49 WHEN 8038 THEN (num*4)+50 WHEN 8033 THEN (num*4)+51 WHEN 7139 THEN (num*4)+52 WHEN 6562 THEN (num*4)+53 WHEN 7268 THEN (num*4)+54 WHEN 8040 THEN (num*4)+55 WHEN 6291 THEN (num*4)+56 WHEN 7731 THEN (num*4)+57 WHEN 7142 THEN (num*4)+58 WHEN 8029 THEN (num*4)+59 WHEN 5649 THEN (num*4)+60 WHEN 7302 THEN (num*4)+61 WHEN 7261 THEN (num*4)+62 WHEN 8713 THEN (num*4)+63 WHEN 8712 THEN (num*4)+64 WHEN 7264 THEN (num*4)+65 WHEN 8710 THEN (num*4)+66 WHEN 8582 THEN (num*4)+67 WHEN 6558 THEN (num*4)+68 WHEN 7263 THEN (num*4)+69 WHEN 6642 THEN (num*4)+70 WHEN 8112 THEN (num*4)+71 WHEN 6797 THEN (num*4)+72 WHEN 7728 THEN (num*4)+73 WHEN 7727 THEN (num*4)+74 WHEN 8715 THEN (num*4)+75 WHEN 7262 THEN (num*4)+76 WHEN 8714 THEN (num*4)+77 WHEN 8716 THEN (num*4)+78 WHEN 6581 THEN (num*4)+79 WHEN 7724 THEN (num*4)+80 WHEN 6800 THEN (num*4)+81 WHEN 6627 THEN (num*4)+82 WHEN 6592 THEN (num*4)+83 WHEN 8175 THEN (num*4)+84 WHEN 6326 THEN (num*4)+85 WHEN 8106 THEN (num*4)+86 WHEN 8132 THEN (num*4)+87 WHEN 8571 THEN (num*4)+88 WHEN 6582 THEN (num*4)+89 WHEN 7726 THEN (num*4)+90 WHEN 7809 THEN (num*4)+91 WHEN 6595 THEN (num*4)+92 WHEN 8035 THEN (num*4)+93 WHEN 7504 THEN (num*4)+94 WHEN 7260 THEN (num*4)+95 WHEN 7962 THEN (num*4)+96 END,numErr153a