SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk txt,prix,promo,prixo,CASE WHEN isable!=0 THEN photo WHEN wi1!=3 AND photo1_3!="" THEN photo1_3 WHEN wi1!=1 AND photo1_2!="" THEN photo1_2 ELSE photo END 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,7943,8019,9520,9423,5094,9389,9450,6601,9422,6503,9409,5133,9301,1814,7377,3196,9204,5108,9202,5132,7947,6599,8016,9016,8569,6461,6612,8875,8879,9116,8876,7951,8848,7398,8047,7216,8719,8853,8725,6000,8781,8125,6013,8721,8773,6143,8652,8144,6403,8589,8612,7562,7306,7935,4423,4422,6602,8018,3610,7239,8046,6502,7538,7571,3023,7235,7355,7413,7539,7307,7550,5997,8017,8783,8871,8808,8072,7203,7378,7552,8095,7520,4491,3008,6633,7253,7546)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7943 THEN (num*3)+1 WHEN 8019 THEN (num*3)+2 WHEN 9520 THEN (num*3)+3 WHEN 9423 THEN (num*3)+4 WHEN 5094 THEN (num*3)+5 WHEN 9389 THEN (num*3)+6 WHEN 9450 THEN (num*3)+7 WHEN 6601 THEN (num*3)+8 WHEN 9422 THEN (num*3)+9 WHEN 6503 THEN (num*3)+10 WHEN 9409 THEN (num*3)+11 WHEN 5133 THEN (num*3)+12 WHEN 9301 THEN (num*3)+13 WHEN 1814 THEN (num*3)+14 WHEN 7377 THEN (num*3)+15 WHEN 3196 THEN (num*3)+16 WHEN 9204 THEN (num*3)+17 WHEN 5108 THEN (num*3)+18 WHEN 9202 THEN (num*3)+19 WHEN 5132 THEN (num*3)+20 WHEN 7947 THEN (num*3)+21 WHEN 6599 THEN (num*3)+22 WHEN 8016 THEN (num*3)+23 WHEN 9016 THEN (num*3)+24 WHEN 8569 THEN (num*3)+25 WHEN 6461 THEN (num*3)+26 WHEN 6612 THEN (num*3)+27 WHEN 8875 THEN (num*3)+28 WHEN 8879 THEN (num*3)+29 WHEN 9116 THEN (num*3)+30 WHEN 8876 THEN (num*3)+31 WHEN 7951 THEN (num*3)+32 WHEN 8848 THEN (num*3)+33 WHEN 7398 THEN (num*3)+34 WHEN 8047 THEN (num*3)+35 WHEN 7216 THEN (num*3)+36 WHEN 8719 THEN (num*3)+37 WHEN 8853 THEN (num*3)+38 WHEN 8725 THEN (num*3)+39 WHEN 6000 THEN (num*3)+40 WHEN 8781 THEN (num*3)+41 WHEN 8125 THEN (num*3)+42 WHEN 6013 THEN (num*3)+43 WHEN 8721 THEN (num*3)+44 WHEN 8773 THEN (num*3)+45 WHEN 6143 THEN (num*3)+46 WHEN 8652 THEN (num*3)+47 WHEN 8144 THEN (num*3)+48 WHEN 6403 THEN (num*3)+49 WHEN 8589 THEN (num*3)+50 WHEN 8612 THEN (num*3)+51 WHEN 7562 THEN (num*3)+52 WHEN 7306 THEN (num*3)+53 WHEN 7935 THEN (num*3)+54 WHEN 4423 THEN (num*3)+55 WHEN 4422 THEN (num*3)+56 WHEN 6602 THEN (num*3)+57 WHEN 8018 THEN (num*3)+58 WHEN 3610 THEN (num*3)+59 WHEN 7239 THEN (num*3)+60 WHEN 8046 THEN (num*3)+61 WHEN 6502 THEN (num*3)+62 WHEN 7538 THEN (num*3)+63 WHEN 7571 THEN (num*3)+64 WHEN 3023 THEN (num*3)+65 WHEN 7235 THEN (num*3)+66 WHEN 7355 THEN (num*3)+67 WHEN 7413 THEN (num*3)+68 WHEN 7539 THEN (num*3)+69 WHEN 7307 THEN (num*3)+70 WHEN 7550 THEN (num*3)+71 WHEN 5997 THEN (num*3)+72 WHEN 8017 THEN (num*3)+73 WHEN 8783 THEN (num*3)+74 WHEN 8871 THEN (num*3)+75 WHEN 8808 THEN (num*3)+76 WHEN 8072 THEN (num*3)+77 WHEN 7203 THEN (num*3)+78 WHEN 7378 THEN (num*3)+79 WHEN 7552 THEN (num*3)+80 WHEN 8095 THEN (num*3)+81 WHEN 7520 THEN (num*3)+82 WHEN 4491 THEN (num*3)+83 WHEN 3008 THEN (num*3)+84 WHEN 6633 THEN (num*3)+85 WHEN 7253 THEN (num*3)+86 WHEN 7546 THEN (num*3)+87 END,numErr153a