SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,8809,8870,8842,8807,9290,7954,6504,9391,9411,6376,8167,9309,7863,6474,9322,9410,9409,9035,8166,9284,9363,6375,9360,3171,1839,3140,9520,9510,9476,6497,9421,9305,6473,9286,8732,8915,7474,8895,7328,9171,9281,8788,9206,9362,3609,9287,7473,7531,9336,6476,9285,8704,9036,8954,8875,9279,8841,8814,9339,9164,8812,6495,8176,9222,7945,7482,8920,7928,9044,9442,8869,9179,1840,5541,8811,9037,8868,8929,2356,8926,8867,8917,8691,8684,5030,8775,7929,8971,9143,6601,8789,8813,3191,5031,6602,6503,1811,8637,9095,8599,8443,8699,7947,6362,8706,9067,5542,8744,8899,6349,8908,4429,5987,3002,6597,5004,6412,6461,6505,5473,6502,7486,7864,1294,8765,8631,8630,7764,5316,8597,8635,5140,6564,8697,6609,7184,8126,8449,4432,6565,7564,7712,8822,8324,8326,2610,7133,9096,8627,8632,8168,5306,8246,7956,8633,8588,8638,4155,7303,6604,8302,7236,7411,8766,7632,8604,7460,6475,7471,8731,8435,7222,8003,7819,8400,7464,8229,6496,7890,8698,7930,7224,8693,8640,7663,8076,7677,6508,7861,7787,4663,7550,7538,7250,8686,8639,7995,8436,7807,7862,7964,7894,3023,7251,8010,6974,7458,7828,7463,7351,7468,7413,7247,7669,4597,7398,5436,7233,7668,6773,7000,7259,4287,6217,7730,7152,6493,7249,6499,7540,7717,7610,7959,7248,7245,7617,5834,7612,7288,6705,7753,7825,8257,4266,5565,7788,6286,7639,4158,7716,7138)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 8809 THEN (num*6)+1 WHEN 8870 THEN (num*6)+2 WHEN 8842 THEN (num*6)+3 WHEN 8807 THEN (num*6)+4 WHEN 9290 THEN (num*6)+5 WHEN 7954 THEN (num*6)+6 WHEN 6504 THEN (num*6)+7 WHEN 9391 THEN (num*6)+8 WHEN 9411 THEN (num*6)+9 WHEN 6376 THEN (num*6)+10 WHEN 8167 THEN (num*6)+11 WHEN 9309 THEN (num*6)+12 WHEN 7863 THEN (num*6)+13 WHEN 6474 THEN (num*6)+14 WHEN 9322 THEN (num*6)+15 WHEN 9410 THEN (num*6)+16 WHEN 9409 THEN (num*6)+17 WHEN 9035 THEN (num*6)+18 WHEN 8166 THEN (num*6)+19 WHEN 9284 THEN (num*6)+20 WHEN 9363 THEN (num*6)+21 WHEN 6375 THEN (num*6)+22 WHEN 9360 THEN (num*6)+23 WHEN 3171 THEN (num*6)+24 WHEN 1839 THEN (num*6)+25 WHEN 3140 THEN (num*6)+26 WHEN 9520 THEN (num*6)+27 WHEN 9510 THEN (num*6)+28 WHEN 9476 THEN (num*6)+29 WHEN 6497 THEN (num*6)+30 WHEN 9421 THEN (num*6)+31 WHEN 9305 THEN (num*6)+32 WHEN 6473 THEN (num*6)+33 WHEN 9286 THEN (num*6)+34 WHEN 8732 THEN (num*6)+35 WHEN 8915 THEN (num*6)+36 WHEN 7474 THEN (num*6)+37 WHEN 8895 THEN (num*6)+38 WHEN 7328 THEN (num*6)+39 WHEN 9171 THEN (num*6)+40 WHEN 9281 THEN (num*6)+41 WHEN 8788 THEN (num*6)+42 WHEN 9206 THEN (num*6)+43 WHEN 9362 THEN (num*6)+44 WHEN 3609 THEN (num*6)+45 WHEN 9287 THEN (num*6)+46 WHEN 7473 THEN (num*6)+47 WHEN 7531 THEN (num*6)+48 WHEN 9336 THEN (num*6)+49 WHEN 6476 THEN (num*6)+50 WHEN 9285 THEN (num*6)+51 WHEN 8704 THEN (num*6)+52 WHEN 9036 THEN (num*6)+53 WHEN 8954 THEN (num*6)+54 WHEN 8875 THEN (num*6)+55 WHEN 9279 THEN (num*6)+56 WHEN 8841 THEN (num*6)+57 WHEN 8814 THEN (num*6)+58 WHEN 9339 THEN (num*6)+59 WHEN 9164 THEN (num*6)+60 WHEN 8812 THEN (num*6)+61 WHEN 6495 THEN (num*6)+62 WHEN 8176 THEN (num*6)+63 WHEN 9222 THEN (num*6)+64 WHEN 7945 THEN (num*6)+65 WHEN 7482 THEN (num*6)+66 WHEN 8920 THEN (num*6)+67 WHEN 7928 THEN (num*6)+68 WHEN 9044 THEN (num*6)+69 WHEN 9442 THEN (num*6)+70 WHEN 8869 THEN (num*6)+71 WHEN 9179 THEN (num*6)+72 WHEN 1840 THEN (num*6)+73 WHEN 5541 THEN (num*6)+74 WHEN 8811 THEN (num*6)+75 WHEN 9037 THEN (num*6)+76 WHEN 8868 THEN (num*6)+77 WHEN 8929 THEN (num*6)+78 WHEN 2356 THEN (num*6)+79 WHEN 8926 THEN (num*6)+80 WHEN 8867 THEN (num*6)+81 WHEN 8917 THEN (num*6)+82 WHEN 8691 THEN (num*6)+83 WHEN 8684 THEN (num*6)+84 WHEN 5030 THEN (num*6)+85 WHEN 8775 THEN (num*6)+86 WHEN 7929 THEN (num*6)+87 WHEN 8971 THEN (num*6)+88 WHEN 9143 THEN (num*6)+89 WHEN 6601 THEN (num*6)+90 WHEN 8789 THEN (num*6)+91 WHEN 8813 THEN (num*6)+92 WHEN 3191 THEN (num*6)+93 WHEN 5031 THEN (num*6)+94 WHEN 6602 THEN (num*6)+95 WHEN 6503 THEN (num*6)+96 WHEN 1811 THEN (num*6)+97 WHEN 8637 THEN (num*6)+98 WHEN 9095 THEN (num*6)+99 WHEN 8599 THEN (num*6)+100 WHEN 8443 THEN (num*6)+101 WHEN 8699 THEN (num*6)+102 WHEN 7947 THEN (num*6)+103 WHEN 6362 THEN (num*6)+104 WHEN 8706 THEN (num*6)+105 WHEN 9067 THEN (num*6)+106 WHEN 5542 THEN (num*6)+107 WHEN 8744 THEN (num*6)+108 WHEN 8899 THEN (num*6)+109 WHEN 6349 THEN (num*6)+110 WHEN 8908 THEN (num*6)+111 WHEN 4429 THEN (num*6)+112 WHEN 5987 THEN (num*6)+113 WHEN 3002 THEN (num*6)+114 WHEN 6597 THEN (num*6)+115 WHEN 5004 THEN (num*6)+116 WHEN 6412 THEN (num*6)+117 WHEN 6461 THEN (num*6)+118 WHEN 6505 THEN (num*6)+119 WHEN 5473 THEN (num*6)+120 WHEN 6502 THEN (num*6)+121 WHEN 7486 THEN (num*6)+122 WHEN 7864 THEN (num*6)+123 WHEN 1294 THEN (num*6)+124 WHEN 8765 THEN (num*6)+125 WHEN 8631 THEN (num*6)+126 WHEN 8630 THEN (num*6)+127 WHEN 7764 THEN (num*6)+128 WHEN 5316 THEN (num*6)+129 WHEN 8597 THEN (num*6)+130 WHEN 8635 THEN (num*6)+131 WHEN 5140 THEN (num*6)+132 WHEN 6564 THEN (num*6)+133 WHEN 8697 THEN (num*6)+134 WHEN 6609 THEN (num*6)+135 WHEN 7184 THEN (num*6)+136 WHEN 8126 THEN (num*6)+137 WHEN 8449 THEN (num*6)+138 WHEN 4432 THEN (num*6)+139 WHEN 6565 THEN (num*6)+140 WHEN 7564 THEN (num*6)+141 WHEN 7712 THEN (num*6)+142 WHEN 8822 THEN (num*6)+143 WHEN 8324 THEN (num*6)+144 WHEN 8326 THEN (num*6)+145 WHEN 2610 THEN (num*6)+146 WHEN 7133 THEN (num*6)+147 WHEN 9096 THEN (num*6)+148 WHEN 8627 THEN (num*6)+149 WHEN 8632 THEN (num*6)+150 WHEN 8168 THEN (num*6)+151 WHEN 5306 THEN (num*6)+152 WHEN 8246 THEN (num*6)+153 WHEN 7956 THEN (num*6)+154 WHEN 8633 THEN (num*6)+155 WHEN 8588 THEN (num*6)+156 WHEN 8638 THEN (num*6)+157 WHEN 4155 THEN (num*6)+158 WHEN 7303 THEN (num*6)+159 WHEN 6604 THEN (num*6)+160 WHEN 8302 THEN (num*6)+161 WHEN 7236 THEN (num*6)+162 WHEN 7411 THEN (num*6)+163 WHEN 8766 THEN (num*6)+164 WHEN 7632 THEN (num*6)+165 WHEN 8604 THEN (num*6)+166 WHEN 7460 THEN (num*6)+167 WHEN 6475 THEN (num*6)+168 WHEN 7471 THEN (num*6)+169 WHEN 8731 THEN (num*6)+170 WHEN 8435 THEN (num*6)+171 WHEN 7222 THEN (num*6)+172 WHEN 8003 THEN (num*6)+173 WHEN 7819 THEN (num*6)+174 WHEN 8400 THEN (num*6)+175 WHEN 7464 THEN (num*6)+176 WHEN 8229 THEN (num*6)+177 WHEN 6496 THEN (num*6)+178 WHEN 7890 THEN (num*6)+179 WHEN 8698 THEN (num*6)+180 WHEN 7930 THEN (num*6)+181 WHEN 7224 THEN (num*6)+182 WHEN 8693 THEN (num*6)+183 WHEN 8640 THEN (num*6)+184 WHEN 7663 THEN (num*6)+185 WHEN 8076 THEN (num*6)+186 WHEN 7677 THEN (num*6)+187 WHEN 6508 THEN (num*6)+188 WHEN 7861 THEN (num*6)+189 WHEN 7787 THEN (num*6)+190 WHEN 4663 THEN (num*6)+191 WHEN 7550 THEN (num*6)+192 WHEN 7538 THEN (num*6)+193 WHEN 7250 THEN (num*6)+194 WHEN 8686 THEN (num*6)+195 WHEN 8639 THEN (num*6)+196 WHEN 7995 THEN (num*6)+197 WHEN 8436 THEN (num*6)+198 WHEN 7807 THEN (num*6)+199 WHEN 7862 THEN (num*6)+200 WHEN 7964 THEN (num*6)+201 WHEN 7894 THEN (num*6)+202 WHEN 3023 THEN (num*6)+203 WHEN 7251 THEN (num*6)+204 WHEN 8010 THEN (num*6)+205 WHEN 6974 THEN (num*6)+206 WHEN 7458 THEN (num*6)+207 WHEN 7828 THEN (num*6)+208 WHEN 7463 THEN (num*6)+209 WHEN 7351 THEN (num*6)+210 WHEN 7468 THEN (num*6)+211 WHEN 7413 THEN (num*6)+212 WHEN 7247 THEN (num*6)+213 WHEN 7669 THEN (num*6)+214 WHEN 4597 THEN (num*6)+215 WHEN 7398 THEN (num*6)+216 WHEN 5436 THEN (num*6)+217 WHEN 7233 THEN (num*6)+218 WHEN 7668 THEN (num*6)+219 WHEN 6773 THEN (num*6)+220 WHEN 7000 THEN (num*6)+221 WHEN 7259 THEN (num*6)+222 WHEN 4287 THEN (num*6)+223 WHEN 6217 THEN (num*6)+224 WHEN 7730 THEN (num*6)+225 WHEN 7152 THEN (num*6)+226 WHEN 6493 THEN (num*6)+227 WHEN 7249 THEN (num*6)+228 WHEN 6499 THEN (num*6)+229 WHEN 7540 THEN (num*6)+230 WHEN 7717 THEN (num*6)+231 WHEN 7610 THEN (num*6)+232 WHEN 7959 THEN (num*6)+233 WHEN 7248 THEN (num*6)+234 WHEN 7245 THEN (num*6)+235 WHEN 7617 THEN (num*6)+236 WHEN 5834 THEN (num*6)+237 WHEN 7612 THEN (num*6)+238 WHEN 7288 THEN (num*6)+239 WHEN 6705 THEN (num*6)+240 WHEN 7753 THEN (num*6)+241 WHEN 7825 THEN (num*6)+242 WHEN 8257 THEN (num*6)+243 WHEN 4266 THEN (num*6)+244 WHEN 5565 THEN (num*6)+245 WHEN 7788 THEN (num*6)+246 WHEN 6286 THEN (num*6)+247 WHEN 7639 THEN (num*6)+248 WHEN 4158 THEN (num*6)+249 WHEN 7716 THEN (num*6)+250 WHEN 7138 THEN (num*6)+251 END,numErr153a