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