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,9335,9396,7450,9461,9370,6106,5624,9376,9225,7328,9310,9297,9379,9242,9269,9331,9417,9258,9397,8834,9526,9499,9495,9487,9485,9483,9482,8736,9480,9427,9439,9433,9434,9438,9436,9437,9460,9338,9312,8674,9371,9372,9393,8734,8768,9380,9399,9324,9353,9325,9401,8727,9394,7451,9402,9367,7449,8754,9368,9192,3769,9227,6384,9250,8845,9266,7480,9378,8163,8755,9181,6302,2422,5040,4368,6408,8079,7330,9248,8865,8750,9472,9471,9459,9458,9435,6405,9432,9431,9428,9426,7137,9415,9414,9400,9381,8170,8864,9377,7971,9373,9375,9357,9355,9354,7150,9352,9351,9350,9349,9348,9326,8654,6406,8671,9296,8600,8027,9288,9247,9243,8171,9237,9199,9198,9197,9196,9195,9194,9193,9190,9189,9188,9187,9186,9185,6306,8858,9184,8861,9183,9182,8748,9180,8780,8763,8683,8772,8726,8873,7229,8647,8601,8695,8749,9244,8658,8874,8649,8655,8138,9291,8619,8042,8753,8617,8862,8622,8028,8615,8621,6422,8847,8618,8603,8602,8702,8777,8743,8609,8118,3680,7978,8611,8591,8076,6498,7985,8137,8839,8646,7258,4456,8626,6513,7222,8136,7135,8045,8724,7173,7996,5481,8739,8023,8723,6312,8135,8005,7972,6102,8117,6383,7997,7270,7202,6331,8863,7273,8089,8826,8844,8142,6344,7271,8785,8672,8835,8009,7138,7231,8085,6341,8837,7274,7336,8605,8836,6052,8169,7199,7998,8838,8758,6382,8784,8116,8224,8786,8011,8833,7844,8759,8760,7281)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 9335 THEN (num*6)+1 WHEN 9396 THEN (num*6)+2 WHEN 7450 THEN (num*6)+3 WHEN 9461 THEN (num*6)+4 WHEN 9370 THEN (num*6)+5 WHEN 6106 THEN (num*6)+6 WHEN 5624 THEN (num*6)+7 WHEN 9376 THEN (num*6)+8 WHEN 9225 THEN (num*6)+9 WHEN 7328 THEN (num*6)+10 WHEN 9310 THEN (num*6)+11 WHEN 9297 THEN (num*6)+12 WHEN 9379 THEN (num*6)+13 WHEN 9242 THEN (num*6)+14 WHEN 9269 THEN (num*6)+15 WHEN 9331 THEN (num*6)+16 WHEN 9417 THEN (num*6)+17 WHEN 9258 THEN (num*6)+18 WHEN 9397 THEN (num*6)+19 WHEN 8834 THEN (num*6)+20 WHEN 9526 THEN (num*6)+21 WHEN 9499 THEN (num*6)+22 WHEN 9495 THEN (num*6)+23 WHEN 9487 THEN (num*6)+24 WHEN 9485 THEN (num*6)+25 WHEN 9483 THEN (num*6)+26 WHEN 9482 THEN (num*6)+27 WHEN 8736 THEN (num*6)+28 WHEN 9480 THEN (num*6)+29 WHEN 9427 THEN (num*6)+30 WHEN 9439 THEN (num*6)+31 WHEN 9433 THEN (num*6)+32 WHEN 9434 THEN (num*6)+33 WHEN 9438 THEN (num*6)+34 WHEN 9436 THEN (num*6)+35 WHEN 9437 THEN (num*6)+36 WHEN 9460 THEN (num*6)+37 WHEN 9338 THEN (num*6)+38 WHEN 9312 THEN (num*6)+39 WHEN 8674 THEN (num*6)+40 WHEN 9371 THEN (num*6)+41 WHEN 9372 THEN (num*6)+42 WHEN 9393 THEN (num*6)+43 WHEN 8734 THEN (num*6)+44 WHEN 8768 THEN (num*6)+45 WHEN 9380 THEN (num*6)+46 WHEN 9399 THEN (num*6)+47 WHEN 9324 THEN (num*6)+48 WHEN 9353 THEN (num*6)+49 WHEN 9325 THEN (num*6)+50 WHEN 9401 THEN (num*6)+51 WHEN 8727 THEN (num*6)+52 WHEN 9394 THEN (num*6)+53 WHEN 7451 THEN (num*6)+54 WHEN 9402 THEN (num*6)+55 WHEN 9367 THEN (num*6)+56 WHEN 7449 THEN (num*6)+57 WHEN 8754 THEN (num*6)+58 WHEN 9368 THEN (num*6)+59 WHEN 9192 THEN (num*6)+60 WHEN 3769 THEN (num*6)+61 WHEN 9227 THEN (num*6)+62 WHEN 6384 THEN (num*6)+63 WHEN 9250 THEN (num*6)+64 WHEN 8845 THEN (num*6)+65 WHEN 9266 THEN (num*6)+66 WHEN 7480 THEN (num*6)+67 WHEN 9378 THEN (num*6)+68 WHEN 8163 THEN (num*6)+69 WHEN 8755 THEN (num*6)+70 WHEN 9181 THEN (num*6)+71 WHEN 6302 THEN (num*6)+72 WHEN 2422 THEN (num*6)+73 WHEN 5040 THEN (num*6)+74 WHEN 4368 THEN (num*6)+75 WHEN 6408 THEN (num*6)+76 WHEN 8079 THEN (num*6)+77 WHEN 7330 THEN (num*6)+78 WHEN 9248 THEN (num*6)+79 WHEN 8865 THEN (num*6)+80 WHEN 8750 THEN (num*6)+81 WHEN 9472 THEN (num*6)+82 WHEN 9471 THEN (num*6)+83 WHEN 9459 THEN (num*6)+84 WHEN 9458 THEN (num*6)+85 WHEN 9435 THEN (num*6)+86 WHEN 6405 THEN (num*6)+87 WHEN 9432 THEN (num*6)+88 WHEN 9431 THEN (num*6)+89 WHEN 9428 THEN (num*6)+90 WHEN 9426 THEN (num*6)+91 WHEN 7137 THEN (num*6)+92 WHEN 9415 THEN (num*6)+93 WHEN 9414 THEN (num*6)+94 WHEN 9400 THEN (num*6)+95 WHEN 9381 THEN (num*6)+96 WHEN 8170 THEN (num*6)+97 WHEN 8864 THEN (num*6)+98 WHEN 9377 THEN (num*6)+99 WHEN 7971 THEN (num*6)+100 WHEN 9373 THEN (num*6)+101 WHEN 9375 THEN (num*6)+102 WHEN 9357 THEN (num*6)+103 WHEN 9355 THEN (num*6)+104 WHEN 9354 THEN (num*6)+105 WHEN 7150 THEN (num*6)+106 WHEN 9352 THEN (num*6)+107 WHEN 9351 THEN (num*6)+108 WHEN 9350 THEN (num*6)+109 WHEN 9349 THEN (num*6)+110 WHEN 9348 THEN (num*6)+111 WHEN 9326 THEN (num*6)+112 WHEN 8654 THEN (num*6)+113 WHEN 6406 THEN (num*6)+114 WHEN 8671 THEN (num*6)+115 WHEN 9296 THEN (num*6)+116 WHEN 8600 THEN (num*6)+117 WHEN 8027 THEN (num*6)+118 WHEN 9288 THEN (num*6)+119 WHEN 9247 THEN (num*6)+120 WHEN 9243 THEN (num*6)+121 WHEN 8171 THEN (num*6)+122 WHEN 9237 THEN (num*6)+123 WHEN 9199 THEN (num*6)+124 WHEN 9198 THEN (num*6)+125 WHEN 9197 THEN (num*6)+126 WHEN 9196 THEN (num*6)+127 WHEN 9195 THEN (num*6)+128 WHEN 9194 THEN (num*6)+129 WHEN 9193 THEN (num*6)+130 WHEN 9190 THEN (num*6)+131 WHEN 9189 THEN (num*6)+132 WHEN 9188 THEN (num*6)+133 WHEN 9187 THEN (num*6)+134 WHEN 9186 THEN (num*6)+135 WHEN 9185 THEN (num*6)+136 WHEN 6306 THEN (num*6)+137 WHEN 8858 THEN (num*6)+138 WHEN 9184 THEN (num*6)+139 WHEN 8861 THEN (num*6)+140 WHEN 9183 THEN (num*6)+141 WHEN 9182 THEN (num*6)+142 WHEN 8748 THEN (num*6)+143 WHEN 9180 THEN (num*6)+144 WHEN 8780 THEN (num*6)+145 WHEN 8763 THEN (num*6)+146 WHEN 8683 THEN (num*6)+147 WHEN 8772 THEN (num*6)+148 WHEN 8726 THEN (num*6)+149 WHEN 8873 THEN (num*6)+150 WHEN 7229 THEN (num*6)+151 WHEN 8647 THEN (num*6)+152 WHEN 8601 THEN (num*6)+153 WHEN 8695 THEN (num*6)+154 WHEN 8749 THEN (num*6)+155 WHEN 9244 THEN (num*6)+156 WHEN 8658 THEN (num*6)+157 WHEN 8874 THEN (num*6)+158 WHEN 8649 THEN (num*6)+159 WHEN 8655 THEN (num*6)+160 WHEN 8138 THEN (num*6)+161 WHEN 9291 THEN (num*6)+162 WHEN 8619 THEN (num*6)+163 WHEN 8042 THEN (num*6)+164 WHEN 8753 THEN (num*6)+165 WHEN 8617 THEN (num*6)+166 WHEN 8862 THEN (num*6)+167 WHEN 8622 THEN (num*6)+168 WHEN 8028 THEN (num*6)+169 WHEN 8615 THEN (num*6)+170 WHEN 8621 THEN (num*6)+171 WHEN 6422 THEN (num*6)+172 WHEN 8847 THEN (num*6)+173 WHEN 8618 THEN (num*6)+174 WHEN 8603 THEN (num*6)+175 WHEN 8602 THEN (num*6)+176 WHEN 8702 THEN (num*6)+177 WHEN 8777 THEN (num*6)+178 WHEN 8743 THEN (num*6)+179 WHEN 8609 THEN (num*6)+180 WHEN 8118 THEN (num*6)+181 WHEN 3680 THEN (num*6)+182 WHEN 7978 THEN (num*6)+183 WHEN 8611 THEN (num*6)+184 WHEN 8591 THEN (num*6)+185 WHEN 8076 THEN (num*6)+186 WHEN 6498 THEN (num*6)+187 WHEN 7985 THEN (num*6)+188 WHEN 8137 THEN (num*6)+189 WHEN 8839 THEN (num*6)+190 WHEN 8646 THEN (num*6)+191 WHEN 7258 THEN (num*6)+192 WHEN 4456 THEN (num*6)+193 WHEN 8626 THEN (num*6)+194 WHEN 6513 THEN (num*6)+195 WHEN 7222 THEN (num*6)+196 WHEN 8136 THEN (num*6)+197 WHEN 7135 THEN (num*6)+198 WHEN 8045 THEN (num*6)+199 WHEN 8724 THEN (num*6)+200 WHEN 7173 THEN (num*6)+201 WHEN 7996 THEN (num*6)+202 WHEN 5481 THEN (num*6)+203 WHEN 8739 THEN (num*6)+204 WHEN 8023 THEN (num*6)+205 WHEN 8723 THEN (num*6)+206 WHEN 6312 THEN (num*6)+207 WHEN 8135 THEN (num*6)+208 WHEN 8005 THEN (num*6)+209 WHEN 7972 THEN (num*6)+210 WHEN 6102 THEN (num*6)+211 WHEN 8117 THEN (num*6)+212 WHEN 6383 THEN (num*6)+213 WHEN 7997 THEN (num*6)+214 WHEN 7270 THEN (num*6)+215 WHEN 7202 THEN (num*6)+216 WHEN 6331 THEN (num*6)+217 WHEN 8863 THEN (num*6)+218 WHEN 7273 THEN (num*6)+219 WHEN 8089 THEN (num*6)+220 WHEN 8826 THEN (num*6)+221 WHEN 8844 THEN (num*6)+222 WHEN 8142 THEN (num*6)+223 WHEN 6344 THEN (num*6)+224 WHEN 7271 THEN (num*6)+225 WHEN 8785 THEN (num*6)+226 WHEN 8672 THEN (num*6)+227 WHEN 8835 THEN (num*6)+228 WHEN 8009 THEN (num*6)+229 WHEN 7138 THEN (num*6)+230 WHEN 7231 THEN (num*6)+231 WHEN 8085 THEN (num*6)+232 WHEN 6341 THEN (num*6)+233 WHEN 8837 THEN (num*6)+234 WHEN 7274 THEN (num*6)+235 WHEN 7336 THEN (num*6)+236 WHEN 8605 THEN (num*6)+237 WHEN 8836 THEN (num*6)+238 WHEN 6052 THEN (num*6)+239 WHEN 8169 THEN (num*6)+240 WHEN 7199 THEN (num*6)+241 WHEN 7998 THEN (num*6)+242 WHEN 8838 THEN (num*6)+243 WHEN 8758 THEN (num*6)+244 WHEN 6382 THEN (num*6)+245 WHEN 8784 THEN (num*6)+246 WHEN 8116 THEN (num*6)+247 WHEN 8224 THEN (num*6)+248 WHEN 8786 THEN (num*6)+249 WHEN 8011 THEN (num*6)+250 WHEN 8833 THEN (num*6)+251 WHEN 7844 THEN (num*6)+252 WHEN 8759 THEN (num*6)+253 WHEN 8760 THEN (num*6)+254 WHEN 7281 THEN (num*6)+255 END,numErr153a