SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=1 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND volume!=4  AND produit IN(0,6763,6109,8843,9307,6610,6106,9314,6520,9456,9308,9494,9455,9511,9509,9454,9506,9491,9505,9504,9502,9527,9528,9501,9523,9503,9500,9510,9492,6611,9507,9497,5322,9316,9498,9315,5744,9499,5745,6598,9496,5966,9495,1811,3827,2104,6612,1318,7944,6108,5109,9017,7450,1809,7448,9014,6132,4632,5111,7942,6232,6459,7374,5336,6597,4650,4640,1814,8606,6609,6749,5985,5132,7202,5133,5108,3952,8568,7452,7110,6124,4922,2107,2464,6133,8132)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 6763 THEN (num*3)+1 WHEN 6109 THEN (num*3)+2 WHEN 8843 THEN (num*3)+3 WHEN 9307 THEN (num*3)+4 WHEN 6610 THEN (num*3)+5 WHEN 6106 THEN (num*3)+6 WHEN 9314 THEN (num*3)+7 WHEN 6520 THEN (num*3)+8 WHEN 9456 THEN (num*3)+9 WHEN 9308 THEN (num*3)+10 WHEN 9494 THEN (num*3)+11 WHEN 9455 THEN (num*3)+12 WHEN 9511 THEN (num*3)+13 WHEN 9509 THEN (num*3)+14 WHEN 9454 THEN (num*3)+15 WHEN 9506 THEN (num*3)+16 WHEN 9491 THEN (num*3)+17 WHEN 9505 THEN (num*3)+18 WHEN 9504 THEN (num*3)+19 WHEN 9502 THEN (num*3)+20 WHEN 9527 THEN (num*3)+21 WHEN 9528 THEN (num*3)+22 WHEN 9501 THEN (num*3)+23 WHEN 9523 THEN (num*3)+24 WHEN 9503 THEN (num*3)+25 WHEN 9500 THEN (num*3)+26 WHEN 9510 THEN (num*3)+27 WHEN 9492 THEN (num*3)+28 WHEN 6611 THEN (num*3)+29 WHEN 9507 THEN (num*3)+30 WHEN 9497 THEN (num*3)+31 WHEN 5322 THEN (num*3)+32 WHEN 9316 THEN (num*3)+33 WHEN 9498 THEN (num*3)+34 WHEN 9315 THEN (num*3)+35 WHEN 5744 THEN (num*3)+36 WHEN 9499 THEN (num*3)+37 WHEN 5745 THEN (num*3)+38 WHEN 6598 THEN (num*3)+39 WHEN 9496 THEN (num*3)+40 WHEN 5966 THEN (num*3)+41 WHEN 9495 THEN (num*3)+42 WHEN 1811 THEN (num*3)+43 WHEN 3827 THEN (num*3)+44 WHEN 2104 THEN (num*3)+45 WHEN 6612 THEN (num*3)+46 WHEN 1318 THEN (num*3)+47 WHEN 7944 THEN (num*3)+48 WHEN 6108 THEN (num*3)+49 WHEN 5109 THEN (num*3)+50 WHEN 9017 THEN (num*3)+51 WHEN 7450 THEN (num*3)+52 WHEN 1809 THEN (num*3)+53 WHEN 7448 THEN (num*3)+54 WHEN 9014 THEN (num*3)+55 WHEN 6132 THEN (num*3)+56 WHEN 4632 THEN (num*3)+57 WHEN 5111 THEN (num*3)+58 WHEN 7942 THEN (num*3)+59 WHEN 6232 THEN (num*3)+60 WHEN 6459 THEN (num*3)+61 WHEN 7374 THEN (num*3)+62 WHEN 5336 THEN (num*3)+63 WHEN 6597 THEN (num*3)+64 WHEN 4650 THEN (num*3)+65 WHEN 4640 THEN (num*3)+66 WHEN 1814 THEN (num*3)+67 WHEN 8606 THEN (num*3)+68 WHEN 6609 THEN (num*3)+69 WHEN 6749 THEN (num*3)+70 WHEN 5985 THEN (num*3)+71 WHEN 5132 THEN (num*3)+72 WHEN 7202 THEN (num*3)+73 WHEN 5133 THEN (num*3)+74 WHEN 5108 THEN (num*3)+75 WHEN 3952 THEN (num*3)+76 WHEN 8568 THEN (num*3)+77 WHEN 7452 THEN (num*3)+78 WHEN 7110 THEN (num*3)+79 WHEN 6124 THEN (num*3)+80 WHEN 4922 THEN (num*3)+81 WHEN 2107 THEN (num*3)+82 WHEN 2464 THEN (num*3)+83 WHEN 6133 THEN (num*3)+84 WHEN 8132 THEN (num*3)+85 END,numErr153a