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