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 volume!=4  AND produit IN(0,9238,8845,8763,7448,6880,8160,6959,7387,8949,9124,9166,9147,9089,8974,9079,9061,8975,9141,9050,9153,9078,9098,9049,9104,8968,8990,9055,8909,9132,9033,9051,8241,6964,8976,9125,8985,9122,3027,8973,9324,6694,6881,9056,9159,8889,9288,8340,9052,8970,9157,7381,8339,6853,8495,9310,9242,9357,9248,8984,5816,1294,9247,9393,7866,5831,9399,8529,8484,9331,9022,9380,9402,9059,9081,9372,9114,9156,9349,3846,9337,9137,9392,8428,9080,9226,9373,9347,9258,9354,9326,5182,9053,3004,9325,9272,9250,9058,8997,589,9311,9243,9492,9487,8972,9485,9473,9459,9444,9443,9441,9439,8991,8427,9433,8999,9431,8983,9047,7386,9379,8323,9378,9188,9048,9377,9376,9375,6966,8248,9371,9370,9023,2991,9368,8851,9367,3432,9041,9356,9353,9352,8937,8429,8898,9338,8497,8950,8852,8418,8757,2461,9296,9273,8942,8432,7428,8430,8888,8969,9197,9195,9194,9191,9190,8818,9184,8768,8734,6487,9182,6384,9180,7813,8886,8700,8982,8433,8473,7590,7658,8481,8274,8738,8727,8163,8839,7411,7960,8887,8749,8873,8858,8723,8724,8787,8754,7331,8740,7329,8748,8733,7952,8755,8654,8000,8743,3170,8683,6306,8079,8231,8753,4368,8498,8750,8076,7976,8608,8772,8610,2462,6490,8171,8739,6498,8084,8844,8644,8508,8603,8600,7875,7619,3163,7978,8426,8625,8602,8170,8658,8520,1818,8695,8023,6513,7265,4456,8702,7270,6733,4000,8655,7985,8619,8152,7953,2606,8238,7274,7259,8863,8092,7583,7271,8785,8494,8835,6344,4426,6484,7138,7768,8131,8103,8836,8273,8837,3649,7425,8087,8489,7966,8862,8760,7643,8784,2602,8088,7572,7417,9142,9099,9020,2003,8515,3844,7426,8941,7168,8838,7403,8169,8509,8759,8833,6160,6954,6238,1289,8786,5924,8758,4774,7871,8089)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%'ORDER BY CASE produit WHEN 9238 THEN (num*6)+1 WHEN 8845 THEN (num*6)+2 WHEN 8763 THEN (num*6)+3 WHEN 7448 THEN (num*6)+4 WHEN 6880 THEN (num*6)+5 WHEN 8160 THEN (num*6)+6 WHEN 6959 THEN (num*6)+7 WHEN 7387 THEN (num*6)+8 WHEN 8949 THEN (num*6)+9 WHEN 9124 THEN (num*6)+10 WHEN 9166 THEN (num*6)+11 WHEN 9147 THEN (num*6)+12 WHEN 9089 THEN (num*6)+13 WHEN 8974 THEN (num*6)+14 WHEN 9079 THEN (num*6)+15 WHEN 9061 THEN (num*6)+16 WHEN 8975 THEN (num*6)+17 WHEN 9141 THEN (num*6)+18 WHEN 9050 THEN (num*6)+19 WHEN 9153 THEN (num*6)+20 WHEN 9078 THEN (num*6)+21 WHEN 9098 THEN (num*6)+22 WHEN 9049 THEN (num*6)+23 WHEN 9104 THEN (num*6)+24 WHEN 8968 THEN (num*6)+25 WHEN 8990 THEN (num*6)+26 WHEN 9055 THEN (num*6)+27 WHEN 8909 THEN (num*6)+28 WHEN 9132 THEN (num*6)+29 WHEN 9033 THEN (num*6)+30 WHEN 9051 THEN (num*6)+31 WHEN 8241 THEN (num*6)+32 WHEN 6964 THEN (num*6)+33 WHEN 8976 THEN (num*6)+34 WHEN 9125 THEN (num*6)+35 WHEN 8985 THEN (num*6)+36 WHEN 9122 THEN (num*6)+37 WHEN 3027 THEN (num*6)+38 WHEN 8973 THEN (num*6)+39 WHEN 9324 THEN (num*6)+40 WHEN 6694 THEN (num*6)+41 WHEN 6881 THEN (num*6)+42 WHEN 9056 THEN (num*6)+43 WHEN 9159 THEN (num*6)+44 WHEN 8889 THEN (num*6)+45 WHEN 9288 THEN (num*6)+46 WHEN 8340 THEN (num*6)+47 WHEN 9052 THEN (num*6)+48 WHEN 8970 THEN (num*6)+49 WHEN 9157 THEN (num*6)+50 WHEN 7381 THEN (num*6)+51 WHEN 8339 THEN (num*6)+52 WHEN 6853 THEN (num*6)+53 WHEN 8495 THEN (num*6)+54 WHEN 9310 THEN (num*6)+55 WHEN 9242 THEN (num*6)+56 WHEN 9357 THEN (num*6)+57 WHEN 9248 THEN (num*6)+58 WHEN 8984 THEN (num*6)+59 WHEN 5816 THEN (num*6)+60 WHEN 1294 THEN (num*6)+61 WHEN 9247 THEN (num*6)+62 WHEN 9393 THEN (num*6)+63 WHEN 7866 THEN (num*6)+64 WHEN 5831 THEN (num*6)+65 WHEN 9399 THEN (num*6)+66 WHEN 8529 THEN (num*6)+67 WHEN 8484 THEN (num*6)+68 WHEN 9331 THEN (num*6)+69 WHEN 9022 THEN (num*6)+70 WHEN 9380 THEN (num*6)+71 WHEN 9402 THEN (num*6)+72 WHEN 9059 THEN (num*6)+73 WHEN 9081 THEN (num*6)+74 WHEN 9372 THEN (num*6)+75 WHEN 9114 THEN (num*6)+76 WHEN 9156 THEN (num*6)+77 WHEN 9349 THEN (num*6)+78 WHEN 3846 THEN (num*6)+79 WHEN 9337 THEN (num*6)+80 WHEN 9137 THEN (num*6)+81 WHEN 9392 THEN (num*6)+82 WHEN 8428 THEN (num*6)+83 WHEN 9080 THEN (num*6)+84 WHEN 9226 THEN (num*6)+85 WHEN 9373 THEN (num*6)+86 WHEN 9347 THEN (num*6)+87 WHEN 9258 THEN (num*6)+88 WHEN 9354 THEN (num*6)+89 WHEN 9326 THEN (num*6)+90 WHEN 5182 THEN (num*6)+91 WHEN 9053 THEN (num*6)+92 WHEN 3004 THEN (num*6)+93 WHEN 9325 THEN (num*6)+94 WHEN 9272 THEN (num*6)+95 WHEN 9250 THEN (num*6)+96 WHEN 9058 THEN (num*6)+97 WHEN 8997 THEN (num*6)+98 WHEN 589 THEN (num*6)+99 WHEN 9311 THEN (num*6)+100 WHEN 9243 THEN (num*6)+101 WHEN 9492 THEN (num*6)+102 WHEN 9487 THEN (num*6)+103 WHEN 8972 THEN (num*6)+104 WHEN 9485 THEN (num*6)+105 WHEN 9473 THEN (num*6)+106 WHEN 9459 THEN (num*6)+107 WHEN 9444 THEN (num*6)+108 WHEN 9443 THEN (num*6)+109 WHEN 9441 THEN (num*6)+110 WHEN 9439 THEN (num*6)+111 WHEN 8991 THEN (num*6)+112 WHEN 8427 THEN (num*6)+113 WHEN 9433 THEN (num*6)+114 WHEN 8999 THEN (num*6)+115 WHEN 9431 THEN (num*6)+116 WHEN 8983 THEN (num*6)+117 WHEN 9047 THEN (num*6)+118 WHEN 7386 THEN (num*6)+119 WHEN 9379 THEN (num*6)+120 WHEN 8323 THEN (num*6)+121 WHEN 9378 THEN (num*6)+122 WHEN 9188 THEN (num*6)+123 WHEN 9048 THEN (num*6)+124 WHEN 9377 THEN (num*6)+125 WHEN 9376 THEN (num*6)+126 WHEN 9375 THEN (num*6)+127 WHEN 6966 THEN (num*6)+128 WHEN 8248 THEN (num*6)+129 WHEN 9371 THEN (num*6)+130 WHEN 9370 THEN (num*6)+131 WHEN 9023 THEN (num*6)+132 WHEN 2991 THEN (num*6)+133 WHEN 9368 THEN (num*6)+134 WHEN 8851 THEN (num*6)+135 WHEN 9367 THEN (num*6)+136 WHEN 3432 THEN (num*6)+137 WHEN 9041 THEN (num*6)+138 WHEN 9356 THEN (num*6)+139 WHEN 9353 THEN (num*6)+140 WHEN 9352 THEN (num*6)+141 WHEN 8937 THEN (num*6)+142 WHEN 8429 THEN (num*6)+143 WHEN 8898 THEN (num*6)+144 WHEN 9338 THEN (num*6)+145 WHEN 8497 THEN (num*6)+146 WHEN 8950 THEN (num*6)+147 WHEN 8852 THEN (num*6)+148 WHEN 8418 THEN (num*6)+149 WHEN 8757 THEN (num*6)+150 WHEN 2461 THEN (num*6)+151 WHEN 9296 THEN (num*6)+152 WHEN 9273 THEN (num*6)+153 WHEN 8942 THEN (num*6)+154 WHEN 8432 THEN (num*6)+155 WHEN 7428 THEN (num*6)+156 WHEN 8430 THEN (num*6)+157 WHEN 8888 THEN (num*6)+158 WHEN 8969 THEN (num*6)+159 WHEN 9197 THEN (num*6)+160 WHEN 9195 THEN (num*6)+161 WHEN 9194 THEN (num*6)+162 WHEN 9191 THEN (num*6)+163 WHEN 9190 THEN (num*6)+164 WHEN 8818 THEN (num*6)+165 WHEN 9184 THEN (num*6)+166 WHEN 8768 THEN (num*6)+167 WHEN 8734 THEN (num*6)+168 WHEN 6487 THEN (num*6)+169 WHEN 9182 THEN (num*6)+170 WHEN 6384 THEN (num*6)+171 WHEN 9180 THEN (num*6)+172 WHEN 7813 THEN (num*6)+173 WHEN 8886 THEN (num*6)+174 WHEN 8700 THEN (num*6)+175 WHEN 8982 THEN (num*6)+176 WHEN 8433 THEN (num*6)+177 WHEN 8473 THEN (num*6)+178 WHEN 7590 THEN (num*6)+179 WHEN 7658 THEN (num*6)+180 WHEN 8481 THEN (num*6)+181 WHEN 8274 THEN (num*6)+182 WHEN 8738 THEN (num*6)+183 WHEN 8727 THEN (num*6)+184 WHEN 8163 THEN (num*6)+185 WHEN 8839 THEN (num*6)+186 WHEN 7411 THEN (num*6)+187 WHEN 7960 THEN (num*6)+188 WHEN 8887 THEN (num*6)+189 WHEN 8749 THEN (num*6)+190 WHEN 8873 THEN (num*6)+191 WHEN 8858 THEN (num*6)+192 WHEN 8723 THEN (num*6)+193 WHEN 8724 THEN (num*6)+194 WHEN 8787 THEN (num*6)+195 WHEN 8754 THEN (num*6)+196 WHEN 7331 THEN (num*6)+197 WHEN 8740 THEN (num*6)+198 WHEN 7329 THEN (num*6)+199 WHEN 8748 THEN (num*6)+200 WHEN 8733 THEN (num*6)+201 WHEN 7952 THEN (num*6)+202 WHEN 8755 THEN (num*6)+203 WHEN 8654 THEN (num*6)+204 WHEN 8000 THEN (num*6)+205 WHEN 8743 THEN (num*6)+206 WHEN 3170 THEN (num*6)+207 WHEN 8683 THEN (num*6)+208 WHEN 6306 THEN (num*6)+209 WHEN 8079 THEN (num*6)+210 WHEN 8231 THEN (num*6)+211 WHEN 8753 THEN (num*6)+212 WHEN 4368 THEN (num*6)+213 WHEN 8498 THEN (num*6)+214 WHEN 8750 THEN (num*6)+215 WHEN 8076 THEN (num*6)+216 WHEN 7976 THEN (num*6)+217 WHEN 8608 THEN (num*6)+218 WHEN 8772 THEN (num*6)+219 WHEN 8610 THEN (num*6)+220 WHEN 2462 THEN (num*6)+221 WHEN 6490 THEN (num*6)+222 WHEN 8171 THEN (num*6)+223 WHEN 8739 THEN (num*6)+224 WHEN 6498 THEN (num*6)+225 WHEN 8084 THEN (num*6)+226 WHEN 8844 THEN (num*6)+227 WHEN 8644 THEN (num*6)+228 WHEN 8508 THEN (num*6)+229 WHEN 8603 THEN (num*6)+230 WHEN 8600 THEN (num*6)+231 WHEN 7875 THEN (num*6)+232 WHEN 7619 THEN (num*6)+233 WHEN 3163 THEN (num*6)+234 WHEN 7978 THEN (num*6)+235 WHEN 8426 THEN (num*6)+236 WHEN 8625 THEN (num*6)+237 WHEN 8602 THEN (num*6)+238 WHEN 8170 THEN (num*6)+239 WHEN 8658 THEN (num*6)+240 WHEN 8520 THEN (num*6)+241 WHEN 1818 THEN (num*6)+242 WHEN 8695 THEN (num*6)+243 WHEN 8023 THEN (num*6)+244 WHEN 6513 THEN (num*6)+245 WHEN 7265 THEN (num*6)+246 WHEN 4456 THEN (num*6)+247 WHEN 8702 THEN (num*6)+248 WHEN 7270 THEN (num*6)+249 WHEN 6733 THEN (num*6)+250 WHEN 4000 THEN (num*6)+251 WHEN 8655 THEN (num*6)+252 WHEN 7985 THEN (num*6)+253 WHEN 8619 THEN (num*6)+254 WHEN 8152 THEN (num*6)+255 WHEN 7953 THEN (num*6)+256 WHEN 2606 THEN (num*6)+257 WHEN 8238 THEN (num*6)+258 WHEN 7274 THEN (num*6)+259 WHEN 7259 THEN (num*6)+260 WHEN 8863 THEN (num*6)+261 WHEN 8092 THEN (num*6)+262 WHEN 7583 THEN (num*6)+263 WHEN 7271 THEN (num*6)+264 WHEN 8785 THEN (num*6)+265 WHEN 8494 THEN (num*6)+266 WHEN 8835 THEN (num*6)+267 WHEN 6344 THEN (num*6)+268 WHEN 4426 THEN (num*6)+269 WHEN 6484 THEN (num*6)+270 WHEN 7138 THEN (num*6)+271 WHEN 7768 THEN (num*6)+272 WHEN 8131 THEN (num*6)+273 WHEN 8103 THEN (num*6)+274 WHEN 8836 THEN (num*6)+275 WHEN 8273 THEN (num*6)+276 WHEN 8837 THEN (num*6)+277 WHEN 3649 THEN (num*6)+278 WHEN 7425 THEN (num*6)+279 WHEN 8087 THEN (num*6)+280 WHEN 8489 THEN (num*6)+281 WHEN 7966 THEN (num*6)+282 WHEN 8862 THEN (num*6)+283 WHEN 8760 THEN (num*6)+284 WHEN 7643 THEN (num*6)+285 WHEN 8784 THEN (num*6)+286 WHEN 2602 THEN (num*6)+287 WHEN 8088 THEN (num*6)+288 WHEN 7572 THEN (num*6)+289 WHEN 7417 THEN (num*6)+290 WHEN 9142 THEN (num*6)+291 WHEN 9099 THEN (num*6)+292 WHEN 9020 THEN (num*6)+293 WHEN 2003 THEN (num*6)+294 WHEN 8515 THEN (num*6)+295 WHEN 3844 THEN (num*6)+296 WHEN 7426 THEN (num*6)+297 WHEN 8941 THEN (num*6)+298 WHEN 7168 THEN (num*6)+299 WHEN 8838 THEN (num*6)+300 WHEN 7403 THEN (num*6)+301 WHEN 8169 THEN (num*6)+302 WHEN 8509 THEN (num*6)+303 WHEN 8759 THEN (num*6)+304 WHEN 8833 THEN (num*6)+305 WHEN 6160 THEN (num*6)+306 WHEN 6954 THEN (num*6)+307 WHEN 6238 THEN (num*6)+308 WHEN 1289 THEN (num*6)+309 WHEN 8786 THEN (num*6)+310 WHEN 5924 THEN (num*6)+311 WHEN 8758 THEN (num*6)+312 WHEN 4774 THEN (num*6)+313 WHEN 7871 THEN (num*6)+314 WHEN 8089 THEN (num*6)+315 END,numErr153a