SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=1 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,7382,8342,7556,9092,9001,8959,9284,8960,4205,8447,7383,9131,9175,8321,8660,9406,9445,9287,7897,9413,9290,7898,9515,9514,9513,9512,9062,9281,9457,9453,9452,9451,9134,7429,5326,8449,9299,9374,7427,6859,7922,9345,9343,9300,9286,9285,9233,9283,9282,7781,9236,9235,9234,7896,9232,9231,9201,9200,7921,7495,8264,7895,9015,8799,8222,7444,8867,7543,6650,7545,8962,7729,3002,5325,7558,7226,8656,5535,7554,7544,8716,8710,3918,8711,8706,6204,6492,8576,7542,6727,6491,7302,7361,6318,4432,6958,8004,7366,8303,7783,8078,8577,6955,6291,8715,7541,8522,7424,6390,8643,5332,7782,6296,8397,8039,7363,5537,8584,8642,8029,7372,7365,7731,7371,7364,8112,7368,7367,7725,6317,8302,8083,8582,7282,7362,7204,8575,8037,7962,6804,8175,6407,8031,8034,7961,8712,8033,6642,7261,6082,7510,6314,8259,6301,8159,6441,6800,7963,6332,7730,5827,8106,7392,6311,8151,6592,5330,8713,7660,8105,8035,6458,7263,8475,7260,6313,6797,6926,6818,7434,6941,8714,7423,6942,6668,8580,7726,6096,7373,6671,7870,8431,9088,6101,6667,7659,8571,7727,7979,7262,7809,6983)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%63%'ORDER BY CASE produit WHEN 7382 THEN (num*6)+1 WHEN 8342 THEN (num*6)+2 WHEN 7556 THEN (num*6)+3 WHEN 9092 THEN (num*6)+4 WHEN 9001 THEN (num*6)+5 WHEN 8959 THEN (num*6)+6 WHEN 9284 THEN (num*6)+7 WHEN 8960 THEN (num*6)+8 WHEN 4205 THEN (num*6)+9 WHEN 8447 THEN (num*6)+10 WHEN 7383 THEN (num*6)+11 WHEN 9131 THEN (num*6)+12 WHEN 9175 THEN (num*6)+13 WHEN 8321 THEN (num*6)+14 WHEN 8660 THEN (num*6)+15 WHEN 9406 THEN (num*6)+16 WHEN 9445 THEN (num*6)+17 WHEN 9287 THEN (num*6)+18 WHEN 7897 THEN (num*6)+19 WHEN 9413 THEN (num*6)+20 WHEN 9290 THEN (num*6)+21 WHEN 7898 THEN (num*6)+22 WHEN 9515 THEN (num*6)+23 WHEN 9514 THEN (num*6)+24 WHEN 9513 THEN (num*6)+25 WHEN 9512 THEN (num*6)+26 WHEN 9062 THEN (num*6)+27 WHEN 9281 THEN (num*6)+28 WHEN 9457 THEN (num*6)+29 WHEN 9453 THEN (num*6)+30 WHEN 9452 THEN (num*6)+31 WHEN 9451 THEN (num*6)+32 WHEN 9134 THEN (num*6)+33 WHEN 7429 THEN (num*6)+34 WHEN 5326 THEN (num*6)+35 WHEN 8449 THEN (num*6)+36 WHEN 9299 THEN (num*6)+37 WHEN 9374 THEN (num*6)+38 WHEN 7427 THEN (num*6)+39 WHEN 6859 THEN (num*6)+40 WHEN 7922 THEN (num*6)+41 WHEN 9345 THEN (num*6)+42 WHEN 9343 THEN (num*6)+43 WHEN 9300 THEN (num*6)+44 WHEN 9286 THEN (num*6)+45 WHEN 9285 THEN (num*6)+46 WHEN 9233 THEN (num*6)+47 WHEN 9283 THEN (num*6)+48 WHEN 9282 THEN (num*6)+49 WHEN 7781 THEN (num*6)+50 WHEN 9236 THEN (num*6)+51 WHEN 9235 THEN (num*6)+52 WHEN 9234 THEN (num*6)+53 WHEN 7896 THEN (num*6)+54 WHEN 9232 THEN (num*6)+55 WHEN 9231 THEN (num*6)+56 WHEN 9201 THEN (num*6)+57 WHEN 9200 THEN (num*6)+58 WHEN 7921 THEN (num*6)+59 WHEN 7495 THEN (num*6)+60 WHEN 8264 THEN (num*6)+61 WHEN 7895 THEN (num*6)+62 WHEN 9015 THEN (num*6)+63 WHEN 8799 THEN (num*6)+64 WHEN 8222 THEN (num*6)+65 WHEN 7444 THEN (num*6)+66 WHEN 8867 THEN (num*6)+67 WHEN 7543 THEN (num*6)+68 WHEN 6650 THEN (num*6)+69 WHEN 7545 THEN (num*6)+70 WHEN 8962 THEN (num*6)+71 WHEN 7729 THEN (num*6)+72 WHEN 3002 THEN (num*6)+73 WHEN 5325 THEN (num*6)+74 WHEN 7558 THEN (num*6)+75 WHEN 7226 THEN (num*6)+76 WHEN 8656 THEN (num*6)+77 WHEN 5535 THEN (num*6)+78 WHEN 7554 THEN (num*6)+79 WHEN 7544 THEN (num*6)+80 WHEN 8716 THEN (num*6)+81 WHEN 8710 THEN (num*6)+82 WHEN 3918 THEN (num*6)+83 WHEN 8711 THEN (num*6)+84 WHEN 8706 THEN (num*6)+85 WHEN 6204 THEN (num*6)+86 WHEN 6492 THEN (num*6)+87 WHEN 8576 THEN (num*6)+88 WHEN 7542 THEN (num*6)+89 WHEN 6727 THEN (num*6)+90 WHEN 6491 THEN (num*6)+91 WHEN 7302 THEN (num*6)+92 WHEN 7361 THEN (num*6)+93 WHEN 6318 THEN (num*6)+94 WHEN 4432 THEN (num*6)+95 WHEN 6958 THEN (num*6)+96 WHEN 8004 THEN (num*6)+97 WHEN 7366 THEN (num*6)+98 WHEN 8303 THEN (num*6)+99 WHEN 7783 THEN (num*6)+100 WHEN 8078 THEN (num*6)+101 WHEN 8577 THEN (num*6)+102 WHEN 6955 THEN (num*6)+103 WHEN 6291 THEN (num*6)+104 WHEN 8715 THEN (num*6)+105 WHEN 7541 THEN (num*6)+106 WHEN 8522 THEN (num*6)+107 WHEN 7424 THEN (num*6)+108 WHEN 6390 THEN (num*6)+109 WHEN 8643 THEN (num*6)+110 WHEN 5332 THEN (num*6)+111 WHEN 7782 THEN (num*6)+112 WHEN 6296 THEN (num*6)+113 WHEN 8397 THEN (num*6)+114 WHEN 8039 THEN (num*6)+115 WHEN 7363 THEN (num*6)+116 WHEN 5537 THEN (num*6)+117 WHEN 8584 THEN (num*6)+118 WHEN 8642 THEN (num*6)+119 WHEN 8029 THEN (num*6)+120 WHEN 7372 THEN (num*6)+121 WHEN 7365 THEN (num*6)+122 WHEN 7731 THEN (num*6)+123 WHEN 7371 THEN (num*6)+124 WHEN 7364 THEN (num*6)+125 WHEN 8112 THEN (num*6)+126 WHEN 7368 THEN (num*6)+127 WHEN 7367 THEN (num*6)+128 WHEN 7725 THEN (num*6)+129 WHEN 6317 THEN (num*6)+130 WHEN 8302 THEN (num*6)+131 WHEN 8083 THEN (num*6)+132 WHEN 8582 THEN (num*6)+133 WHEN 7282 THEN (num*6)+134 WHEN 7362 THEN (num*6)+135 WHEN 7204 THEN (num*6)+136 WHEN 8575 THEN (num*6)+137 WHEN 8037 THEN (num*6)+138 WHEN 7962 THEN (num*6)+139 WHEN 6804 THEN (num*6)+140 WHEN 8175 THEN (num*6)+141 WHEN 6407 THEN (num*6)+142 WHEN 8031 THEN (num*6)+143 WHEN 8034 THEN (num*6)+144 WHEN 7961 THEN (num*6)+145 WHEN 8712 THEN (num*6)+146 WHEN 8033 THEN (num*6)+147 WHEN 6642 THEN (num*6)+148 WHEN 7261 THEN (num*6)+149 WHEN 6082 THEN (num*6)+150 WHEN 7510 THEN (num*6)+151 WHEN 6314 THEN (num*6)+152 WHEN 8259 THEN (num*6)+153 WHEN 6301 THEN (num*6)+154 WHEN 8159 THEN (num*6)+155 WHEN 6441 THEN (num*6)+156 WHEN 6800 THEN (num*6)+157 WHEN 7963 THEN (num*6)+158 WHEN 6332 THEN (num*6)+159 WHEN 7730 THEN (num*6)+160 WHEN 5827 THEN (num*6)+161 WHEN 8106 THEN (num*6)+162 WHEN 7392 THEN (num*6)+163 WHEN 6311 THEN (num*6)+164 WHEN 8151 THEN (num*6)+165 WHEN 6592 THEN (num*6)+166 WHEN 5330 THEN (num*6)+167 WHEN 8713 THEN (num*6)+168 WHEN 7660 THEN (num*6)+169 WHEN 8105 THEN (num*6)+170 WHEN 8035 THEN (num*6)+171 WHEN 6458 THEN (num*6)+172 WHEN 7263 THEN (num*6)+173 WHEN 8475 THEN (num*6)+174 WHEN 7260 THEN (num*6)+175 WHEN 6313 THEN (num*6)+176 WHEN 6797 THEN (num*6)+177 WHEN 6926 THEN (num*6)+178 WHEN 6818 THEN (num*6)+179 WHEN 7434 THEN (num*6)+180 WHEN 6941 THEN (num*6)+181 WHEN 8714 THEN (num*6)+182 WHEN 7423 THEN (num*6)+183 WHEN 6942 THEN (num*6)+184 WHEN 6668 THEN (num*6)+185 WHEN 8580 THEN (num*6)+186 WHEN 7726 THEN (num*6)+187 WHEN 6096 THEN (num*6)+188 WHEN 7373 THEN (num*6)+189 WHEN 6671 THEN (num*6)+190 WHEN 7870 THEN (num*6)+191 WHEN 8431 THEN (num*6)+192 WHEN 9088 THEN (num*6)+193 WHEN 6101 THEN (num*6)+194 WHEN 6667 THEN (num*6)+195 WHEN 7659 THEN (num*6)+196 WHEN 8571 THEN (num*6)+197 WHEN 7727 THEN (num*6)+198 WHEN 7979 THEN (num*6)+199 WHEN 7262 THEN (num*6)+200 WHEN 7809 THEN (num*6)+201 WHEN 6983 THEN (num*6)+202 END,numErr153a