SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,9076,6968,8447,8321,6882,6880,9176,9089,9090,9124,9127,9153,9028,9123,9152,9075,9126,9022,9026,9149,9125,9027,6961,8319,8243,8241,8812,7489,9025,9023,9122,8810,8314,6962,7383,6881,8815,8242,6959,8339,8814,8342,8240,7381,9024,8811,8316,8340,8813,6966,8315,8400,8323,8250,8248,7391,8341,8322,8529,7567,6960,7435,7930,7569,6967,7429,8318,6874,8528,7416,8343,5920,7447,7386,7446,6864,6873,8399,6875,7400,7428,7443,6876,7490,7389,7410,6871,7379,6868,7452,7390,7403,7491,7425,7026,7434,7025,7426,7417,7440,7423,7380)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%'ORDER BY CASE produit WHEN 9076 THEN (num*4)+1 WHEN 6968 THEN (num*4)+2 WHEN 8447 THEN (num*4)+3 WHEN 8321 THEN (num*4)+4 WHEN 6882 THEN (num*4)+5 WHEN 6880 THEN (num*4)+6 WHEN 9176 THEN (num*4)+7 WHEN 9089 THEN (num*4)+8 WHEN 9090 THEN (num*4)+9 WHEN 9124 THEN (num*4)+10 WHEN 9127 THEN (num*4)+11 WHEN 9153 THEN (num*4)+12 WHEN 9028 THEN (num*4)+13 WHEN 9123 THEN (num*4)+14 WHEN 9152 THEN (num*4)+15 WHEN 9075 THEN (num*4)+16 WHEN 9126 THEN (num*4)+17 WHEN 9022 THEN (num*4)+18 WHEN 9026 THEN (num*4)+19 WHEN 9149 THEN (num*4)+20 WHEN 9125 THEN (num*4)+21 WHEN 9027 THEN (num*4)+22 WHEN 6961 THEN (num*4)+23 WHEN 8319 THEN (num*4)+24 WHEN 8243 THEN (num*4)+25 WHEN 8241 THEN (num*4)+26 WHEN 8812 THEN (num*4)+27 WHEN 7489 THEN (num*4)+28 WHEN 9025 THEN (num*4)+29 WHEN 9023 THEN (num*4)+30 WHEN 9122 THEN (num*4)+31 WHEN 8810 THEN (num*4)+32 WHEN 8314 THEN (num*4)+33 WHEN 6962 THEN (num*4)+34 WHEN 7383 THEN (num*4)+35 WHEN 6881 THEN (num*4)+36 WHEN 8815 THEN (num*4)+37 WHEN 8242 THEN (num*4)+38 WHEN 6959 THEN (num*4)+39 WHEN 8339 THEN (num*4)+40 WHEN 8814 THEN (num*4)+41 WHEN 8342 THEN (num*4)+42 WHEN 8240 THEN (num*4)+43 WHEN 7381 THEN (num*4)+44 WHEN 9024 THEN (num*4)+45 WHEN 8811 THEN (num*4)+46 WHEN 8316 THEN (num*4)+47 WHEN 8340 THEN (num*4)+48 WHEN 8813 THEN (num*4)+49 WHEN 6966 THEN (num*4)+50 WHEN 8315 THEN (num*4)+51 WHEN 8400 THEN (num*4)+52 WHEN 8323 THEN (num*4)+53 WHEN 8250 THEN (num*4)+54 WHEN 8248 THEN (num*4)+55 WHEN 7391 THEN (num*4)+56 WHEN 8341 THEN (num*4)+57 WHEN 8322 THEN (num*4)+58 WHEN 8529 THEN (num*4)+59 WHEN 7567 THEN (num*4)+60 WHEN 6960 THEN (num*4)+61 WHEN 7435 THEN (num*4)+62 WHEN 7930 THEN (num*4)+63 WHEN 7569 THEN (num*4)+64 WHEN 6967 THEN (num*4)+65 WHEN 7429 THEN (num*4)+66 WHEN 8318 THEN (num*4)+67 WHEN 6874 THEN (num*4)+68 WHEN 8528 THEN (num*4)+69 WHEN 7416 THEN (num*4)+70 WHEN 8343 THEN (num*4)+71 WHEN 5920 THEN (num*4)+72 WHEN 7447 THEN (num*4)+73 WHEN 7386 THEN (num*4)+74 WHEN 7446 THEN (num*4)+75 WHEN 6864 THEN (num*4)+76 WHEN 6873 THEN (num*4)+77 WHEN 8399 THEN (num*4)+78 WHEN 6875 THEN (num*4)+79 WHEN 7400 THEN (num*4)+80 WHEN 7428 THEN (num*4)+81 WHEN 7443 THEN (num*4)+82 WHEN 6876 THEN (num*4)+83 WHEN 7490 THEN (num*4)+84 WHEN 7389 THEN (num*4)+85 WHEN 7410 THEN (num*4)+86 WHEN 6871 THEN (num*4)+87 WHEN 7379 THEN (num*4)+88 WHEN 6868 THEN (num*4)+89 WHEN 7452 THEN (num*4)+90 WHEN 7390 THEN (num*4)+91 WHEN 7403 THEN (num*4)+92 WHEN 7491 THEN (num*4)+93 WHEN 7425 THEN (num*4)+94 WHEN 7026 THEN (num*4)+95 WHEN 7434 THEN (num*4)+96 WHEN 7025 THEN (num*4)+97 WHEN 7426 THEN (num*4)+98 WHEN 7417 THEN (num*4)+99 WHEN 7440 THEN (num*4)+100 WHEN 7423 THEN (num*4)+101 WHEN 7380 THEN (num*4)+102 END,numErr153a