SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk txt,prix,promo,prixo, 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,6476,7863,1840,2356,8809,6850,8870,8807,6474,6375,6376,9364,8916,9360,6497,7864,6473,8921,7474,8926,6495,8899,8869,5136,7004,6475,6496,9096,8638,8635,8324,8326,7521,8637,7184,7133,8627,8631,8364,8167,8630,8363,8446,7210,7862,7890,7667,7677,7680,7668,6773,7357,7152,6493,7753,6499,6286,8636,7825,5696)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 6476 THEN (num*3)+1 WHEN 7863 THEN (num*3)+2 WHEN 1840 THEN (num*3)+3 WHEN 2356 THEN (num*3)+4 WHEN 8809 THEN (num*3)+5 WHEN 6850 THEN (num*3)+6 WHEN 8870 THEN (num*3)+7 WHEN 8807 THEN (num*3)+8 WHEN 6474 THEN (num*3)+9 WHEN 6375 THEN (num*3)+10 WHEN 6376 THEN (num*3)+11 WHEN 9364 THEN (num*3)+12 WHEN 8916 THEN (num*3)+13 WHEN 9360 THEN (num*3)+14 WHEN 6497 THEN (num*3)+15 WHEN 7864 THEN (num*3)+16 WHEN 6473 THEN (num*3)+17 WHEN 8921 THEN (num*3)+18 WHEN 7474 THEN (num*3)+19 WHEN 8926 THEN (num*3)+20 WHEN 6495 THEN (num*3)+21 WHEN 8899 THEN (num*3)+22 WHEN 8869 THEN (num*3)+23 WHEN 5136 THEN (num*3)+24 WHEN 7004 THEN (num*3)+25 WHEN 6475 THEN (num*3)+26 WHEN 6496 THEN (num*3)+27 WHEN 9096 THEN (num*3)+28 WHEN 8638 THEN (num*3)+29 WHEN 8635 THEN (num*3)+30 WHEN 8324 THEN (num*3)+31 WHEN 8326 THEN (num*3)+32 WHEN 7521 THEN (num*3)+33 WHEN 8637 THEN (num*3)+34 WHEN 7184 THEN (num*3)+35 WHEN 7133 THEN (num*3)+36 WHEN 8627 THEN (num*3)+37 WHEN 8631 THEN (num*3)+38 WHEN 8364 THEN (num*3)+39 WHEN 8167 THEN (num*3)+40 WHEN 8630 THEN (num*3)+41 WHEN 8363 THEN (num*3)+42 WHEN 8446 THEN (num*3)+43 WHEN 7210 THEN (num*3)+44 WHEN 7862 THEN (num*3)+45 WHEN 7890 THEN (num*3)+46 WHEN 7667 THEN (num*3)+47 WHEN 7677 THEN (num*3)+48 WHEN 7680 THEN (num*3)+49 WHEN 7668 THEN (num*3)+50 WHEN 6773 THEN (num*3)+51 WHEN 7357 THEN (num*3)+52 WHEN 7152 THEN (num*3)+53 WHEN 6493 THEN (num*3)+54 WHEN 7753 THEN (num*3)+55 WHEN 6499 THEN (num*3)+56 WHEN 6286 THEN (num*3)+57 WHEN 8636 THEN (num*3)+58 WHEN 7825 THEN (num*3)+59 WHEN 5696 THEN (num*3)+60 END,numErr153a