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 produit IN(0,7854,8791,5138,7943,7935,5094,8919,7562,5108,8882,5407,6945,7947,8928,9389,8931,7874,8924,9301,7709,7004,8327,5427,7219,7068,9016,7734,6461,8612,7062,7712,8921,8398,7153,7130,7951,7737,8491,8325,8364,6755,8899,8370,8375,8883,7842,8324,7705,7735,8894,7851,5426,6143,5438,8363,8569,8589,7750,8326,8408,7306,7706,8367,7063,7744,5303,5468,5471)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 7854 THEN (num*3)+1 WHEN 8791 THEN (num*3)+2 WHEN 5138 THEN (num*3)+3 WHEN 7943 THEN (num*3)+4 WHEN 7935 THEN (num*3)+5 WHEN 5094 THEN (num*3)+6 WHEN 8919 THEN (num*3)+7 WHEN 7562 THEN (num*3)+8 WHEN 5108 THEN (num*3)+9 WHEN 8882 THEN (num*3)+10 WHEN 5407 THEN (num*3)+11 WHEN 6945 THEN (num*3)+12 WHEN 7947 THEN (num*3)+13 WHEN 8928 THEN (num*3)+14 WHEN 9389 THEN (num*3)+15 WHEN 8931 THEN (num*3)+16 WHEN 7874 THEN (num*3)+17 WHEN 8924 THEN (num*3)+18 WHEN 9301 THEN (num*3)+19 WHEN 7709 THEN (num*3)+20 WHEN 7004 THEN (num*3)+21 WHEN 8327 THEN (num*3)+22 WHEN 5427 THEN (num*3)+23 WHEN 7219 THEN (num*3)+24 WHEN 7068 THEN (num*3)+25 WHEN 9016 THEN (num*3)+26 WHEN 7734 THEN (num*3)+27 WHEN 6461 THEN (num*3)+28 WHEN 8612 THEN (num*3)+29 WHEN 7062 THEN (num*3)+30 WHEN 7712 THEN (num*3)+31 WHEN 8921 THEN (num*3)+32 WHEN 8398 THEN (num*3)+33 WHEN 7153 THEN (num*3)+34 WHEN 7130 THEN (num*3)+35 WHEN 7951 THEN (num*3)+36 WHEN 7737 THEN (num*3)+37 WHEN 8491 THEN (num*3)+38 WHEN 8325 THEN (num*3)+39 WHEN 8364 THEN (num*3)+40 WHEN 6755 THEN (num*3)+41 WHEN 8899 THEN (num*3)+42 WHEN 8370 THEN (num*3)+43 WHEN 8375 THEN (num*3)+44 WHEN 8883 THEN (num*3)+45 WHEN 7842 THEN (num*3)+46 WHEN 8324 THEN (num*3)+47 WHEN 7705 THEN (num*3)+48 WHEN 7735 THEN (num*3)+49 WHEN 8894 THEN (num*3)+50 WHEN 7851 THEN (num*3)+51 WHEN 5426 THEN (num*3)+52 WHEN 6143 THEN (num*3)+53 WHEN 5438 THEN (num*3)+54 WHEN 8363 THEN (num*3)+55 WHEN 8569 THEN (num*3)+56 WHEN 8589 THEN (num*3)+57 WHEN 7750 THEN (num*3)+58 WHEN 8326 THEN (num*3)+59 WHEN 8408 THEN (num*3)+60 WHEN 7306 THEN (num*3)+61 WHEN 7706 THEN (num*3)+62 WHEN 8367 THEN (num*3)+63 WHEN 7063 THEN (num*3)+64 WHEN 7744 THEN (num*3)+65 WHEN 5303 THEN (num*3)+66 WHEN 5468 THEN (num*3)+67 WHEN 5471 THEN (num*3)+68 END,numErr153a