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