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,9024,6968,8319,7489,6962,9176,9152,9127,9090,9089,9022,9149,9122,9025,6961,8243,9178,8242,9153,8241,8316,8250,9124,8341,9028,8240,8314,6959,9126,8447,9123,8340,8321,9125,9026,8323,8400,8843,6960,8339,9076,7391,8815,8814,6882,8812,8342,9027,7885,7428,8248,8757,6966,9023,6874,8810,8741,6967,7886,8811,8524,7429,6283,7447,9075,8813,7400,7322,7390,7449,6880,7323,8736,7493,7410,7025,6881,7383,8738,8768,7490,6873,8529,7381,7452,8343,7534,5920,7567,7558,8528,7386,7325,7416,7423,8315,7486,8740,6864,7569,8756,8318,7379,7435,8457,7330,8459,7446,7930,8322,7484,8733,8754,6871,7443,7533,7538,7389,7488,6317,6868,7536,7539,7434,7494,7403,7537,7417,6876,7026,7487,6875,7426,6867,7491,7380,8399,7440,7425)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%62%'ORDER BY CASE produit WHEN 9024 THEN (num*6)+1 WHEN 6968 THEN (num*6)+2 WHEN 8319 THEN (num*6)+3 WHEN 7489 THEN (num*6)+4 WHEN 6962 THEN (num*6)+5 WHEN 9176 THEN (num*6)+6 WHEN 9152 THEN (num*6)+7 WHEN 9127 THEN (num*6)+8 WHEN 9090 THEN (num*6)+9 WHEN 9089 THEN (num*6)+10 WHEN 9022 THEN (num*6)+11 WHEN 9149 THEN (num*6)+12 WHEN 9122 THEN (num*6)+13 WHEN 9025 THEN (num*6)+14 WHEN 6961 THEN (num*6)+15 WHEN 8243 THEN (num*6)+16 WHEN 9178 THEN (num*6)+17 WHEN 8242 THEN (num*6)+18 WHEN 9153 THEN (num*6)+19 WHEN 8241 THEN (num*6)+20 WHEN 8316 THEN (num*6)+21 WHEN 8250 THEN (num*6)+22 WHEN 9124 THEN (num*6)+23 WHEN 8341 THEN (num*6)+24 WHEN 9028 THEN (num*6)+25 WHEN 8240 THEN (num*6)+26 WHEN 8314 THEN (num*6)+27 WHEN 6959 THEN (num*6)+28 WHEN 9126 THEN (num*6)+29 WHEN 8447 THEN (num*6)+30 WHEN 9123 THEN (num*6)+31 WHEN 8340 THEN (num*6)+32 WHEN 8321 THEN (num*6)+33 WHEN 9125 THEN (num*6)+34 WHEN 9026 THEN (num*6)+35 WHEN 8323 THEN (num*6)+36 WHEN 8400 THEN (num*6)+37 WHEN 8843 THEN (num*6)+38 WHEN 6960 THEN (num*6)+39 WHEN 8339 THEN (num*6)+40 WHEN 9076 THEN (num*6)+41 WHEN 7391 THEN (num*6)+42 WHEN 8815 THEN (num*6)+43 WHEN 8814 THEN (num*6)+44 WHEN 6882 THEN (num*6)+45 WHEN 8812 THEN (num*6)+46 WHEN 8342 THEN (num*6)+47 WHEN 9027 THEN (num*6)+48 WHEN 7885 THEN (num*6)+49 WHEN 7428 THEN (num*6)+50 WHEN 8248 THEN (num*6)+51 WHEN 8757 THEN (num*6)+52 WHEN 6966 THEN (num*6)+53 WHEN 9023 THEN (num*6)+54 WHEN 6874 THEN (num*6)+55 WHEN 8810 THEN (num*6)+56 WHEN 8741 THEN (num*6)+57 WHEN 6967 THEN (num*6)+58 WHEN 7886 THEN (num*6)+59 WHEN 8811 THEN (num*6)+60 WHEN 8524 THEN (num*6)+61 WHEN 7429 THEN (num*6)+62 WHEN 6283 THEN (num*6)+63 WHEN 7447 THEN (num*6)+64 WHEN 9075 THEN (num*6)+65 WHEN 8813 THEN (num*6)+66 WHEN 7400 THEN (num*6)+67 WHEN 7322 THEN (num*6)+68 WHEN 7390 THEN (num*6)+69 WHEN 7449 THEN (num*6)+70 WHEN 6880 THEN (num*6)+71 WHEN 7323 THEN (num*6)+72 WHEN 8736 THEN (num*6)+73 WHEN 7493 THEN (num*6)+74 WHEN 7410 THEN (num*6)+75 WHEN 7025 THEN (num*6)+76 WHEN 6881 THEN (num*6)+77 WHEN 7383 THEN (num*6)+78 WHEN 8738 THEN (num*6)+79 WHEN 8768 THEN (num*6)+80 WHEN 7490 THEN (num*6)+81 WHEN 6873 THEN (num*6)+82 WHEN 8529 THEN (num*6)+83 WHEN 7381 THEN (num*6)+84 WHEN 7452 THEN (num*6)+85 WHEN 8343 THEN (num*6)+86 WHEN 7534 THEN (num*6)+87 WHEN 5920 THEN (num*6)+88 WHEN 7567 THEN (num*6)+89 WHEN 7558 THEN (num*6)+90 WHEN 8528 THEN (num*6)+91 WHEN 7386 THEN (num*6)+92 WHEN 7325 THEN (num*6)+93 WHEN 7416 THEN (num*6)+94 WHEN 7423 THEN (num*6)+95 WHEN 8315 THEN (num*6)+96 WHEN 7486 THEN (num*6)+97 WHEN 8740 THEN (num*6)+98 WHEN 6864 THEN (num*6)+99 WHEN 7569 THEN (num*6)+100 WHEN 8756 THEN (num*6)+101 WHEN 8318 THEN (num*6)+102 WHEN 7379 THEN (num*6)+103 WHEN 7435 THEN (num*6)+104 WHEN 8457 THEN (num*6)+105 WHEN 7330 THEN (num*6)+106 WHEN 8459 THEN (num*6)+107 WHEN 7446 THEN (num*6)+108 WHEN 7930 THEN (num*6)+109 WHEN 8322 THEN (num*6)+110 WHEN 7484 THEN (num*6)+111 WHEN 8733 THEN (num*6)+112 WHEN 8754 THEN (num*6)+113 WHEN 6871 THEN (num*6)+114 WHEN 7443 THEN (num*6)+115 WHEN 7533 THEN (num*6)+116 WHEN 7538 THEN (num*6)+117 WHEN 7389 THEN (num*6)+118 WHEN 7488 THEN (num*6)+119 WHEN 6317 THEN (num*6)+120 WHEN 6868 THEN (num*6)+121 WHEN 7536 THEN (num*6)+122 WHEN 7539 THEN (num*6)+123 WHEN 7434 THEN (num*6)+124 WHEN 7494 THEN (num*6)+125 WHEN 7403 THEN (num*6)+126 WHEN 7537 THEN (num*6)+127 WHEN 7417 THEN (num*6)+128 WHEN 6876 THEN (num*6)+129 WHEN 7026 THEN (num*6)+130 WHEN 7487 THEN (num*6)+131 WHEN 6875 THEN (num*6)+132 WHEN 7426 THEN (num*6)+133 WHEN 6867 THEN (num*6)+134 WHEN 7491 THEN (num*6)+135 WHEN 7380 THEN (num*6)+136 WHEN 8399 THEN (num*6)+137 WHEN 7440 THEN (num*6)+138 WHEN 7425 THEN (num*6)+139 END,numErr153a