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 produit IN(0,7556,7545,8738,7493,6109,6106,9201,9376,9439,9377,9012,9324,9408,9102,9526,9487,9141,9483,9482,9481,9480,9446,9440,9438,9437,9119,9018,9436,9146,9435,9358,9434,9433,9432,9347,9431,9325,9394,9378,9079,9375,9132,9229,9355,9299,9348,9081,9269,9345,9280,9019,9300,9274,9228,9289,8898,9242,9080,9283,9282,9257,9226,9271,9270,9233,9236,9235,9234,9232,9231,9009,9227,8947,9196,9188,9187,9186,9181,8834,8845,8462,8873,8846,8469,8468,8839,8844,8467,8829,8830,8763,8828,8460,8465,8799,8792,8466,8741,8461,7383,8463,8780,8772,6732,8770,5431,8386,8771,2991,2461,8559,7011,8752,8736,7770,8753,8750,8566,8733,5191,7771,8742,8564,8730,3621,8473,7450,8729,8261,8163,7386,8709,8567,8683,8674,6883,7322,8707,6958,6384,8076,6737,8671,7875,8669,8601,6302,7329,6291,8614,8642,8655,7457,5040,3680,8138,8651,6390,8080,7952,7330,7268,7449,7971,8578,8581,3769,8611,8592,7137,8573,8123,8602,8583,7991,8579,8576,7989,4497,8137,7993,8577,7167,7363,8122,8136,8582,7323,7978,8575,7372,8584,8591,7997,7996,7270,8135,7371,7396,7276,6383,8045,7135,7325,8117,8574,7972,8863,8769,2463,6344,6022,8142,3881,8826,8837,7271,8785,8053,7979,8759,6311,7274,6052,7494,7281,8509,9020,2464,7641,3561,6382,8825,8833,8862,8835,8836,8758,8580,8838,7776,4920,9103,9142,8786,8784,8381,8760,7774,7775,7777,4922,7803,4898)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%63%'ORDER BY CASE produit WHEN 7556 THEN (num*6)+1 WHEN 7545 THEN (num*6)+2 WHEN 8738 THEN (num*6)+3 WHEN 7493 THEN (num*6)+4 WHEN 6109 THEN (num*6)+5 WHEN 6106 THEN (num*6)+6 WHEN 9201 THEN (num*6)+7 WHEN 9376 THEN (num*6)+8 WHEN 9439 THEN (num*6)+9 WHEN 9377 THEN (num*6)+10 WHEN 9012 THEN (num*6)+11 WHEN 9324 THEN (num*6)+12 WHEN 9408 THEN (num*6)+13 WHEN 9102 THEN (num*6)+14 WHEN 9526 THEN (num*6)+15 WHEN 9487 THEN (num*6)+16 WHEN 9141 THEN (num*6)+17 WHEN 9483 THEN (num*6)+18 WHEN 9482 THEN (num*6)+19 WHEN 9481 THEN (num*6)+20 WHEN 9480 THEN (num*6)+21 WHEN 9446 THEN (num*6)+22 WHEN 9440 THEN (num*6)+23 WHEN 9438 THEN (num*6)+24 WHEN 9437 THEN (num*6)+25 WHEN 9119 THEN (num*6)+26 WHEN 9018 THEN (num*6)+27 WHEN 9436 THEN (num*6)+28 WHEN 9146 THEN (num*6)+29 WHEN 9435 THEN (num*6)+30 WHEN 9358 THEN (num*6)+31 WHEN 9434 THEN (num*6)+32 WHEN 9433 THEN (num*6)+33 WHEN 9432 THEN (num*6)+34 WHEN 9347 THEN (num*6)+35 WHEN 9431 THEN (num*6)+36 WHEN 9325 THEN (num*6)+37 WHEN 9394 THEN (num*6)+38 WHEN 9378 THEN (num*6)+39 WHEN 9079 THEN (num*6)+40 WHEN 9375 THEN (num*6)+41 WHEN 9132 THEN (num*6)+42 WHEN 9229 THEN (num*6)+43 WHEN 9355 THEN (num*6)+44 WHEN 9299 THEN (num*6)+45 WHEN 9348 THEN (num*6)+46 WHEN 9081 THEN (num*6)+47 WHEN 9269 THEN (num*6)+48 WHEN 9345 THEN (num*6)+49 WHEN 9280 THEN (num*6)+50 WHEN 9019 THEN (num*6)+51 WHEN 9300 THEN (num*6)+52 WHEN 9274 THEN (num*6)+53 WHEN 9228 THEN (num*6)+54 WHEN 9289 THEN (num*6)+55 WHEN 8898 THEN (num*6)+56 WHEN 9242 THEN (num*6)+57 WHEN 9080 THEN (num*6)+58 WHEN 9283 THEN (num*6)+59 WHEN 9282 THEN (num*6)+60 WHEN 9257 THEN (num*6)+61 WHEN 9226 THEN (num*6)+62 WHEN 9271 THEN (num*6)+63 WHEN 9270 THEN (num*6)+64 WHEN 9233 THEN (num*6)+65 WHEN 9236 THEN (num*6)+66 WHEN 9235 THEN (num*6)+67 WHEN 9234 THEN (num*6)+68 WHEN 9232 THEN (num*6)+69 WHEN 9231 THEN (num*6)+70 WHEN 9009 THEN (num*6)+71 WHEN 9227 THEN (num*6)+72 WHEN 8947 THEN (num*6)+73 WHEN 9196 THEN (num*6)+74 WHEN 9188 THEN (num*6)+75 WHEN 9187 THEN (num*6)+76 WHEN 9186 THEN (num*6)+77 WHEN 9181 THEN (num*6)+78 WHEN 8834 THEN (num*6)+79 WHEN 8845 THEN (num*6)+80 WHEN 8462 THEN (num*6)+81 WHEN 8873 THEN (num*6)+82 WHEN 8846 THEN (num*6)+83 WHEN 8469 THEN (num*6)+84 WHEN 8468 THEN (num*6)+85 WHEN 8839 THEN (num*6)+86 WHEN 8844 THEN (num*6)+87 WHEN 8467 THEN (num*6)+88 WHEN 8829 THEN (num*6)+89 WHEN 8830 THEN (num*6)+90 WHEN 8763 THEN (num*6)+91 WHEN 8828 THEN (num*6)+92 WHEN 8460 THEN (num*6)+93 WHEN 8465 THEN (num*6)+94 WHEN 8799 THEN (num*6)+95 WHEN 8792 THEN (num*6)+96 WHEN 8466 THEN (num*6)+97 WHEN 8741 THEN (num*6)+98 WHEN 8461 THEN (num*6)+99 WHEN 7383 THEN (num*6)+100 WHEN 8463 THEN (num*6)+101 WHEN 8780 THEN (num*6)+102 WHEN 8772 THEN (num*6)+103 WHEN 6732 THEN (num*6)+104 WHEN 8770 THEN (num*6)+105 WHEN 5431 THEN (num*6)+106 WHEN 8386 THEN (num*6)+107 WHEN 8771 THEN (num*6)+108 WHEN 2991 THEN (num*6)+109 WHEN 2461 THEN (num*6)+110 WHEN 8559 THEN (num*6)+111 WHEN 7011 THEN (num*6)+112 WHEN 8752 THEN (num*6)+113 WHEN 8736 THEN (num*6)+114 WHEN 7770 THEN (num*6)+115 WHEN 8753 THEN (num*6)+116 WHEN 8750 THEN (num*6)+117 WHEN 8566 THEN (num*6)+118 WHEN 8733 THEN (num*6)+119 WHEN 5191 THEN (num*6)+120 WHEN 7771 THEN (num*6)+121 WHEN 8742 THEN (num*6)+122 WHEN 8564 THEN (num*6)+123 WHEN 8730 THEN (num*6)+124 WHEN 3621 THEN (num*6)+125 WHEN 8473 THEN (num*6)+126 WHEN 7450 THEN (num*6)+127 WHEN 8729 THEN (num*6)+128 WHEN 8261 THEN (num*6)+129 WHEN 8163 THEN (num*6)+130 WHEN 7386 THEN (num*6)+131 WHEN 8709 THEN (num*6)+132 WHEN 8567 THEN (num*6)+133 WHEN 8683 THEN (num*6)+134 WHEN 8674 THEN (num*6)+135 WHEN 6883 THEN (num*6)+136 WHEN 7322 THEN (num*6)+137 WHEN 8707 THEN (num*6)+138 WHEN 6958 THEN (num*6)+139 WHEN 6384 THEN (num*6)+140 WHEN 8076 THEN (num*6)+141 WHEN 6737 THEN (num*6)+142 WHEN 8671 THEN (num*6)+143 WHEN 7875 THEN (num*6)+144 WHEN 8669 THEN (num*6)+145 WHEN 8601 THEN (num*6)+146 WHEN 6302 THEN (num*6)+147 WHEN 7329 THEN (num*6)+148 WHEN 6291 THEN (num*6)+149 WHEN 8614 THEN (num*6)+150 WHEN 8642 THEN (num*6)+151 WHEN 8655 THEN (num*6)+152 WHEN 7457 THEN (num*6)+153 WHEN 5040 THEN (num*6)+154 WHEN 3680 THEN (num*6)+155 WHEN 8138 THEN (num*6)+156 WHEN 8651 THEN (num*6)+157 WHEN 6390 THEN (num*6)+158 WHEN 8080 THEN (num*6)+159 WHEN 7952 THEN (num*6)+160 WHEN 7330 THEN (num*6)+161 WHEN 7268 THEN (num*6)+162 WHEN 7449 THEN (num*6)+163 WHEN 7971 THEN (num*6)+164 WHEN 8578 THEN (num*6)+165 WHEN 8581 THEN (num*6)+166 WHEN 3769 THEN (num*6)+167 WHEN 8611 THEN (num*6)+168 WHEN 8592 THEN (num*6)+169 WHEN 7137 THEN (num*6)+170 WHEN 8573 THEN (num*6)+171 WHEN 8123 THEN (num*6)+172 WHEN 8602 THEN (num*6)+173 WHEN 8583 THEN (num*6)+174 WHEN 7991 THEN (num*6)+175 WHEN 8579 THEN (num*6)+176 WHEN 8576 THEN (num*6)+177 WHEN 7989 THEN (num*6)+178 WHEN 4497 THEN (num*6)+179 WHEN 8137 THEN (num*6)+180 WHEN 7993 THEN (num*6)+181 WHEN 8577 THEN (num*6)+182 WHEN 7167 THEN (num*6)+183 WHEN 7363 THEN (num*6)+184 WHEN 8122 THEN (num*6)+185 WHEN 8136 THEN (num*6)+186 WHEN 8582 THEN (num*6)+187 WHEN 7323 THEN (num*6)+188 WHEN 7978 THEN (num*6)+189 WHEN 8575 THEN (num*6)+190 WHEN 7372 THEN (num*6)+191 WHEN 8584 THEN (num*6)+192 WHEN 8591 THEN (num*6)+193 WHEN 7997 THEN (num*6)+194 WHEN 7996 THEN (num*6)+195 WHEN 7270 THEN (num*6)+196 WHEN 8135 THEN (num*6)+197 WHEN 7371 THEN (num*6)+198 WHEN 7396 THEN (num*6)+199 WHEN 7276 THEN (num*6)+200 WHEN 6383 THEN (num*6)+201 WHEN 8045 THEN (num*6)+202 WHEN 7135 THEN (num*6)+203 WHEN 7325 THEN (num*6)+204 WHEN 8117 THEN (num*6)+205 WHEN 8574 THEN (num*6)+206 WHEN 7972 THEN (num*6)+207 WHEN 8863 THEN (num*6)+208 WHEN 8769 THEN (num*6)+209 WHEN 2463 THEN (num*6)+210 WHEN 6344 THEN (num*6)+211 WHEN 6022 THEN (num*6)+212 WHEN 8142 THEN (num*6)+213 WHEN 3881 THEN (num*6)+214 WHEN 8826 THEN (num*6)+215 WHEN 8837 THEN (num*6)+216 WHEN 7271 THEN (num*6)+217 WHEN 8785 THEN (num*6)+218 WHEN 8053 THEN (num*6)+219 WHEN 7979 THEN (num*6)+220 WHEN 8759 THEN (num*6)+221 WHEN 6311 THEN (num*6)+222 WHEN 7274 THEN (num*6)+223 WHEN 6052 THEN (num*6)+224 WHEN 7494 THEN (num*6)+225 WHEN 7281 THEN (num*6)+226 WHEN 8509 THEN (num*6)+227 WHEN 9020 THEN (num*6)+228 WHEN 2464 THEN (num*6)+229 WHEN 7641 THEN (num*6)+230 WHEN 3561 THEN (num*6)+231 WHEN 6382 THEN (num*6)+232 WHEN 8825 THEN (num*6)+233 WHEN 8833 THEN (num*6)+234 WHEN 8862 THEN (num*6)+235 WHEN 8835 THEN (num*6)+236 WHEN 8836 THEN (num*6)+237 WHEN 8758 THEN (num*6)+238 WHEN 8580 THEN (num*6)+239 WHEN 8838 THEN (num*6)+240 WHEN 7776 THEN (num*6)+241 WHEN 4920 THEN (num*6)+242 WHEN 9103 THEN (num*6)+243 WHEN 9142 THEN (num*6)+244 WHEN 8786 THEN (num*6)+245 WHEN 8784 THEN (num*6)+246 WHEN 8381 THEN (num*6)+247 WHEN 8760 THEN (num*6)+248 WHEN 7774 THEN (num*6)+249 WHEN 7775 THEN (num*6)+250 WHEN 7777 THEN (num*6)+251 WHEN 4922 THEN (num*6)+252 WHEN 7803 THEN (num*6)+253 WHEN 4898 THEN (num*6)+254 END,numErr153a