SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=2 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,9238,8845,8763,7448,6880,8160,6959,7387,8949,9124,9324,9371,9380,9367,9288,2461,2991,9226,9368,9354,6384,9311,9242,9247,8787,9485,9433,9487,9431,9439,9459,9473,9444,9443,9402,9441,9393,7329,8727,7952,8163,8772,7331,8757,8079,8768,9399,9392,9379,8818,9377,9376,9375,9373,9372,9370,9337,8851,9357,9356,9353,9352,8750,7976,9349,8683,9347,9338,9331,3170,9326,9325,9296,9273,4368,9272,9258,9250,8608,9243,9153,9089,8734,9191,9147,9190,9188,8733,9184,6306,9104,9182,9180,9310,8000,9378,8171,9125,9122,8610,9141,9051,9098,8603,8600,9078,8873,8755,9132,7960,9248,9137,8084,8748,9033,8738,8654,8984,9052,8862,8990,9114,9048,8968,9041,8241,9061,8644,8426,8975,9166,6498,8982,8888,8887,8972,9023,8754,8602,8909,8340,3004,6964,9056,1294,8619,8889,8970,3163,9047,7978,8886,6694,2462,8339,9050,8700,8950,8999,8997,9081,8942,9080,8991,5831,8937,9049,8858,8983,7381,3846,8974,9053,8740,9055,8323,9159,9157,6853,9079,8529,8702,8969,8743,8784,8170,589,8695,8839,8985,8076,8976,8495,7411,3432,9059,8427,6966,8753,8231,8248,8852,9022,7866,8655,7386,7428,3027,8973,8723,8429,8428,8274,6487,8484,8432,8023,6881,8724,9156,8430,1818,6513,8508,7590,9058,7813,5816,6490,8520,8433,7985,5182,8498,8481,8739,2602,4000,7658,8418,7619,8898,8473,8497,8625,7270,6733,7265,9099,2003,8515,7426,8941,7643,7168,8169,8786,5924,8152,7875,8238,7583,8844,6484,8837)  AND beret=0 AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )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 9324 THEN (num*6)+11 WHEN 9371 THEN (num*6)+12 WHEN 9380 THEN (num*6)+13 WHEN 9367 THEN (num*6)+14 WHEN 9288 THEN (num*6)+15 WHEN 2461 THEN (num*6)+16 WHEN 2991 THEN (num*6)+17 WHEN 9226 THEN (num*6)+18 WHEN 9368 THEN (num*6)+19 WHEN 9354 THEN (num*6)+20 WHEN 6384 THEN (num*6)+21 WHEN 9311 THEN (num*6)+22 WHEN 9242 THEN (num*6)+23 WHEN 9247 THEN (num*6)+24 WHEN 8787 THEN (num*6)+25 WHEN 9485 THEN (num*6)+26 WHEN 9433 THEN (num*6)+27 WHEN 9487 THEN (num*6)+28 WHEN 9431 THEN (num*6)+29 WHEN 9439 THEN (num*6)+30 WHEN 9459 THEN (num*6)+31 WHEN 9473 THEN (num*6)+32 WHEN 9444 THEN (num*6)+33 WHEN 9443 THEN (num*6)+34 WHEN 9402 THEN (num*6)+35 WHEN 9441 THEN (num*6)+36 WHEN 9393 THEN (num*6)+37 WHEN 7329 THEN (num*6)+38 WHEN 8727 THEN (num*6)+39 WHEN 7952 THEN (num*6)+40 WHEN 8163 THEN (num*6)+41 WHEN 8772 THEN (num*6)+42 WHEN 7331 THEN (num*6)+43 WHEN 8757 THEN (num*6)+44 WHEN 8079 THEN (num*6)+45 WHEN 8768 THEN (num*6)+46 WHEN 9399 THEN (num*6)+47 WHEN 9392 THEN (num*6)+48 WHEN 9379 THEN (num*6)+49 WHEN 8818 THEN (num*6)+50 WHEN 9377 THEN (num*6)+51 WHEN 9376 THEN (num*6)+52 WHEN 9375 THEN (num*6)+53 WHEN 9373 THEN (num*6)+54 WHEN 9372 THEN (num*6)+55 WHEN 9370 THEN (num*6)+56 WHEN 9337 THEN (num*6)+57 WHEN 8851 THEN (num*6)+58 WHEN 9357 THEN (num*6)+59 WHEN 9356 THEN (num*6)+60 WHEN 9353 THEN (num*6)+61 WHEN 9352 THEN (num*6)+62 WHEN 8750 THEN (num*6)+63 WHEN 7976 THEN (num*6)+64 WHEN 9349 THEN (num*6)+65 WHEN 8683 THEN (num*6)+66 WHEN 9347 THEN (num*6)+67 WHEN 9338 THEN (num*6)+68 WHEN 9331 THEN (num*6)+69 WHEN 3170 THEN (num*6)+70 WHEN 9326 THEN (num*6)+71 WHEN 9325 THEN (num*6)+72 WHEN 9296 THEN (num*6)+73 WHEN 9273 THEN (num*6)+74 WHEN 4368 THEN (num*6)+75 WHEN 9272 THEN (num*6)+76 WHEN 9258 THEN (num*6)+77 WHEN 9250 THEN (num*6)+78 WHEN 8608 THEN (num*6)+79 WHEN 9243 THEN (num*6)+80 WHEN 9153 THEN (num*6)+81 WHEN 9089 THEN (num*6)+82 WHEN 8734 THEN (num*6)+83 WHEN 9191 THEN (num*6)+84 WHEN 9147 THEN (num*6)+85 WHEN 9190 THEN (num*6)+86 WHEN 9188 THEN (num*6)+87 WHEN 8733 THEN (num*6)+88 WHEN 9184 THEN (num*6)+89 WHEN 6306 THEN (num*6)+90 WHEN 9104 THEN (num*6)+91 WHEN 9182 THEN (num*6)+92 WHEN 9180 THEN (num*6)+93 WHEN 9310 THEN (num*6)+94 WHEN 8000 THEN (num*6)+95 WHEN 9378 THEN (num*6)+96 WHEN 8171 THEN (num*6)+97 WHEN 9125 THEN (num*6)+98 WHEN 9122 THEN (num*6)+99 WHEN 8610 THEN (num*6)+100 WHEN 9141 THEN (num*6)+101 WHEN 9051 THEN (num*6)+102 WHEN 9098 THEN (num*6)+103 WHEN 8603 THEN (num*6)+104 WHEN 8600 THEN (num*6)+105 WHEN 9078 THEN (num*6)+106 WHEN 8873 THEN (num*6)+107 WHEN 8755 THEN (num*6)+108 WHEN 9132 THEN (num*6)+109 WHEN 7960 THEN (num*6)+110 WHEN 9248 THEN (num*6)+111 WHEN 9137 THEN (num*6)+112 WHEN 8084 THEN (num*6)+113 WHEN 8748 THEN (num*6)+114 WHEN 9033 THEN (num*6)+115 WHEN 8738 THEN (num*6)+116 WHEN 8654 THEN (num*6)+117 WHEN 8984 THEN (num*6)+118 WHEN 9052 THEN (num*6)+119 WHEN 8862 THEN (num*6)+120 WHEN 8990 THEN (num*6)+121 WHEN 9114 THEN (num*6)+122 WHEN 9048 THEN (num*6)+123 WHEN 8968 THEN (num*6)+124 WHEN 9041 THEN (num*6)+125 WHEN 8241 THEN (num*6)+126 WHEN 9061 THEN (num*6)+127 WHEN 8644 THEN (num*6)+128 WHEN 8426 THEN (num*6)+129 WHEN 8975 THEN (num*6)+130 WHEN 9166 THEN (num*6)+131 WHEN 6498 THEN (num*6)+132 WHEN 8982 THEN (num*6)+133 WHEN 8888 THEN (num*6)+134 WHEN 8887 THEN (num*6)+135 WHEN 8972 THEN (num*6)+136 WHEN 9023 THEN (num*6)+137 WHEN 8754 THEN (num*6)+138 WHEN 8602 THEN (num*6)+139 WHEN 8909 THEN (num*6)+140 WHEN 8340 THEN (num*6)+141 WHEN 3004 THEN (num*6)+142 WHEN 6964 THEN (num*6)+143 WHEN 9056 THEN (num*6)+144 WHEN 1294 THEN (num*6)+145 WHEN 8619 THEN (num*6)+146 WHEN 8889 THEN (num*6)+147 WHEN 8970 THEN (num*6)+148 WHEN 3163 THEN (num*6)+149 WHEN 9047 THEN (num*6)+150 WHEN 7978 THEN (num*6)+151 WHEN 8886 THEN (num*6)+152 WHEN 6694 THEN (num*6)+153 WHEN 2462 THEN (num*6)+154 WHEN 8339 THEN (num*6)+155 WHEN 9050 THEN (num*6)+156 WHEN 8700 THEN (num*6)+157 WHEN 8950 THEN (num*6)+158 WHEN 8999 THEN (num*6)+159 WHEN 8997 THEN (num*6)+160 WHEN 9081 THEN (num*6)+161 WHEN 8942 THEN (num*6)+162 WHEN 9080 THEN (num*6)+163 WHEN 8991 THEN (num*6)+164 WHEN 5831 THEN (num*6)+165 WHEN 8937 THEN (num*6)+166 WHEN 9049 THEN (num*6)+167 WHEN 8858 THEN (num*6)+168 WHEN 8983 THEN (num*6)+169 WHEN 7381 THEN (num*6)+170 WHEN 3846 THEN (num*6)+171 WHEN 8974 THEN (num*6)+172 WHEN 9053 THEN (num*6)+173 WHEN 8740 THEN (num*6)+174 WHEN 9055 THEN (num*6)+175 WHEN 8323 THEN (num*6)+176 WHEN 9159 THEN (num*6)+177 WHEN 9157 THEN (num*6)+178 WHEN 6853 THEN (num*6)+179 WHEN 9079 THEN (num*6)+180 WHEN 8529 THEN (num*6)+181 WHEN 8702 THEN (num*6)+182 WHEN 8969 THEN (num*6)+183 WHEN 8743 THEN (num*6)+184 WHEN 8784 THEN (num*6)+185 WHEN 8170 THEN (num*6)+186 WHEN 589 THEN (num*6)+187 WHEN 8695 THEN (num*6)+188 WHEN 8839 THEN (num*6)+189 WHEN 8985 THEN (num*6)+190 WHEN 8076 THEN (num*6)+191 WHEN 8976 THEN (num*6)+192 WHEN 8495 THEN (num*6)+193 WHEN 7411 THEN (num*6)+194 WHEN 3432 THEN (num*6)+195 WHEN 9059 THEN (num*6)+196 WHEN 8427 THEN (num*6)+197 WHEN 6966 THEN (num*6)+198 WHEN 8753 THEN (num*6)+199 WHEN 8231 THEN (num*6)+200 WHEN 8248 THEN (num*6)+201 WHEN 8852 THEN (num*6)+202 WHEN 9022 THEN (num*6)+203 WHEN 7866 THEN (num*6)+204 WHEN 8655 THEN (num*6)+205 WHEN 7386 THEN (num*6)+206 WHEN 7428 THEN (num*6)+207 WHEN 3027 THEN (num*6)+208 WHEN 8973 THEN (num*6)+209 WHEN 8723 THEN (num*6)+210 WHEN 8429 THEN (num*6)+211 WHEN 8428 THEN (num*6)+212 WHEN 8274 THEN (num*6)+213 WHEN 6487 THEN (num*6)+214 WHEN 8484 THEN (num*6)+215 WHEN 8432 THEN (num*6)+216 WHEN 8023 THEN (num*6)+217 WHEN 6881 THEN (num*6)+218 WHEN 8724 THEN (num*6)+219 WHEN 9156 THEN (num*6)+220 WHEN 8430 THEN (num*6)+221 WHEN 1818 THEN (num*6)+222 WHEN 6513 THEN (num*6)+223 WHEN 8508 THEN (num*6)+224 WHEN 7590 THEN (num*6)+225 WHEN 9058 THEN (num*6)+226 WHEN 7813 THEN (num*6)+227 WHEN 5816 THEN (num*6)+228 WHEN 6490 THEN (num*6)+229 WHEN 8520 THEN (num*6)+230 WHEN 8433 THEN (num*6)+231 WHEN 7985 THEN (num*6)+232 WHEN 5182 THEN (num*6)+233 WHEN 8498 THEN (num*6)+234 WHEN 8481 THEN (num*6)+235 WHEN 8739 THEN (num*6)+236 WHEN 2602 THEN (num*6)+237 WHEN 4000 THEN (num*6)+238 WHEN 7658 THEN (num*6)+239 WHEN 8418 THEN (num*6)+240 WHEN 7619 THEN (num*6)+241 WHEN 8898 THEN (num*6)+242 WHEN 8473 THEN (num*6)+243 WHEN 8497 THEN (num*6)+244 WHEN 8625 THEN (num*6)+245 WHEN 7270 THEN (num*6)+246 WHEN 6733 THEN (num*6)+247 WHEN 7265 THEN (num*6)+248 WHEN 9099 THEN (num*6)+249 WHEN 2003 THEN (num*6)+250 WHEN 8515 THEN (num*6)+251 WHEN 7426 THEN (num*6)+252 WHEN 8941 THEN (num*6)+253 WHEN 7643 THEN (num*6)+254 WHEN 7168 THEN (num*6)+255 WHEN 8169 THEN (num*6)+256 WHEN 8786 THEN (num*6)+257 WHEN 5924 THEN (num*6)+258 WHEN 8152 THEN (num*6)+259 WHEN 7875 THEN (num*6)+260 WHEN 8238 THEN (num*6)+261 WHEN 7583 THEN (num*6)+262 WHEN 8844 THEN (num*6)+263 WHEN 6484 THEN (num*6)+264 WHEN 8837 THEN (num*6)+265 END,numErr153a