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