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,8882,1844,8606,8599,4650,2356,4652,4561,6007,8365,8924,1840,5091,8327,9328,9508,8933,9091,9095,7048,8935,9277,9267,8931,5898,9447,9412,8919,1809,8900,8926,8918,7835,4653,5135,5408,5407,7062,6734,7861,5473,2598,3129,8370,7712,7764,6020,8883,5140,7736,1812,8366,8398,5307,8392,8641,8375,7131,8405,7063,4042,3007,5009,5306,7858,7705,5470,6773,2839,7637,7603,7593,7569,4041,4036,2838,4834,4045,2837,5896,4043,6006,4037,3123,6001,4563,3126,3122,3124,3188,6018,7049,8403,7056,7744,3179,6875,4587,3998,3446,7634,7636,8404,6876,3190)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%'ORDER BY CASE produit WHEN 8882 THEN (num*4)+1 WHEN 1844 THEN (num*4)+2 WHEN 8606 THEN (num*4)+3 WHEN 8599 THEN (num*4)+4 WHEN 4650 THEN (num*4)+5 WHEN 2356 THEN (num*4)+6 WHEN 4652 THEN (num*4)+7 WHEN 4561 THEN (num*4)+8 WHEN 6007 THEN (num*4)+9 WHEN 8365 THEN (num*4)+10 WHEN 8924 THEN (num*4)+11 WHEN 1840 THEN (num*4)+12 WHEN 5091 THEN (num*4)+13 WHEN 8327 THEN (num*4)+14 WHEN 9328 THEN (num*4)+15 WHEN 9508 THEN (num*4)+16 WHEN 8933 THEN (num*4)+17 WHEN 9091 THEN (num*4)+18 WHEN 9095 THEN (num*4)+19 WHEN 7048 THEN (num*4)+20 WHEN 8935 THEN (num*4)+21 WHEN 9277 THEN (num*4)+22 WHEN 9267 THEN (num*4)+23 WHEN 8931 THEN (num*4)+24 WHEN 5898 THEN (num*4)+25 WHEN 9447 THEN (num*4)+26 WHEN 9412 THEN (num*4)+27 WHEN 8919 THEN (num*4)+28 WHEN 1809 THEN (num*4)+29 WHEN 8900 THEN (num*4)+30 WHEN 8926 THEN (num*4)+31 WHEN 8918 THEN (num*4)+32 WHEN 7835 THEN (num*4)+33 WHEN 4653 THEN (num*4)+34 WHEN 5135 THEN (num*4)+35 WHEN 5408 THEN (num*4)+36 WHEN 5407 THEN (num*4)+37 WHEN 7062 THEN (num*4)+38 WHEN 6734 THEN (num*4)+39 WHEN 7861 THEN (num*4)+40 WHEN 5473 THEN (num*4)+41 WHEN 2598 THEN (num*4)+42 WHEN 3129 THEN (num*4)+43 WHEN 8370 THEN (num*4)+44 WHEN 7712 THEN (num*4)+45 WHEN 7764 THEN (num*4)+46 WHEN 6020 THEN (num*4)+47 WHEN 8883 THEN (num*4)+48 WHEN 5140 THEN (num*4)+49 WHEN 7736 THEN (num*4)+50 WHEN 1812 THEN (num*4)+51 WHEN 8366 THEN (num*4)+52 WHEN 8398 THEN (num*4)+53 WHEN 5307 THEN (num*4)+54 WHEN 8392 THEN (num*4)+55 WHEN 8641 THEN (num*4)+56 WHEN 8375 THEN (num*4)+57 WHEN 7131 THEN (num*4)+58 WHEN 8405 THEN (num*4)+59 WHEN 7063 THEN (num*4)+60 WHEN 4042 THEN (num*4)+61 WHEN 3007 THEN (num*4)+62 WHEN 5009 THEN (num*4)+63 WHEN 5306 THEN (num*4)+64 WHEN 7858 THEN (num*4)+65 WHEN 7705 THEN (num*4)+66 WHEN 5470 THEN (num*4)+67 WHEN 6773 THEN (num*4)+68 WHEN 2839 THEN (num*4)+69 WHEN 7637 THEN (num*4)+70 WHEN 7603 THEN (num*4)+71 WHEN 7593 THEN (num*4)+72 WHEN 7569 THEN (num*4)+73 WHEN 4041 THEN (num*4)+74 WHEN 4036 THEN (num*4)+75 WHEN 2838 THEN (num*4)+76 WHEN 4834 THEN (num*4)+77 WHEN 4045 THEN (num*4)+78 WHEN 2837 THEN (num*4)+79 WHEN 5896 THEN (num*4)+80 WHEN 4043 THEN (num*4)+81 WHEN 6006 THEN (num*4)+82 WHEN 4037 THEN (num*4)+83 WHEN 3123 THEN (num*4)+84 WHEN 6001 THEN (num*4)+85 WHEN 4563 THEN (num*4)+86 WHEN 3126 THEN (num*4)+87 WHEN 3122 THEN (num*4)+88 WHEN 3124 THEN (num*4)+89 WHEN 3188 THEN (num*4)+90 WHEN 6018 THEN (num*4)+91 WHEN 7049 THEN (num*4)+92 WHEN 8403 THEN (num*4)+93 WHEN 7056 THEN (num*4)+94 WHEN 7744 THEN (num*4)+95 WHEN 3179 THEN (num*4)+96 WHEN 6875 THEN (num*4)+97 WHEN 4587 THEN (num*4)+98 WHEN 3998 THEN (num*4)+99 WHEN 3446 THEN (num*4)+100 WHEN 7634 THEN (num*4)+101 WHEN 7636 THEN (num*4)+102 WHEN 8404 THEN (num*4)+103 WHEN 6876 THEN (num*4)+104 WHEN 3190 THEN (num*4)+105 END,numErr153a