SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,8791,7712,8327,8366,7734,9171,8935,8928,5135,5138,7004,8491,7219,7062,5137,7854,6945,7068,5134,7735,8599,5091,8933,9120,5407,7874,5136,5427,8931,8367,8398,7736,8370,8364,7711,8924,9172,7710,5426,8324,8326,7737,8900,7842,8919,7705,7130,9224,7840,9017,5443,9222,8882,8921,8920,5444,8918,8793,9016,5438,7943,8589,7947,8612,7154,9015,5108,8926,8899,8923,5094,8922,9014,7217,8604,5092,8685,7110,8588,8894,8587,8883,7946,7309,7295,6461,5139,8597,7951,7940,4923,8595,7482,8590,8598,7477,8570,7955,7297,8593,5093,7709,7298,8596,7059,7008,8606,7010,7941,5140,6124,7303,8569,7153,7009,7311,6464,8586,7938,8392,7937,7048,7313,6171,7706,8365,8375,7061,8325,6755,7131,7950,8363,8408,8568,7063,5465,7851,7562,7750,5439,5437,7939,7294,7949,7475,7935,7565,7944,7936,7300,6151,7478,7218,7945,7476,7942,7564,6143,6145,7306,6606,6607,7183,6155,6140,5471,5738,7957,5107,6613,7290,6139,5303,5301,6040,7745,5468,7022,5299,7056,7744,7067,7066,7049,6038)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%'ORDER BY CASE produit WHEN 8791 THEN (num*6)+1 WHEN 7712 THEN (num*6)+2 WHEN 8327 THEN (num*6)+3 WHEN 8366 THEN (num*6)+4 WHEN 7734 THEN (num*6)+5 WHEN 9171 THEN (num*6)+6 WHEN 8935 THEN (num*6)+7 WHEN 8928 THEN (num*6)+8 WHEN 5135 THEN (num*6)+9 WHEN 5138 THEN (num*6)+10 WHEN 7004 THEN (num*6)+11 WHEN 8491 THEN (num*6)+12 WHEN 7219 THEN (num*6)+13 WHEN 7062 THEN (num*6)+14 WHEN 5137 THEN (num*6)+15 WHEN 7854 THEN (num*6)+16 WHEN 6945 THEN (num*6)+17 WHEN 7068 THEN (num*6)+18 WHEN 5134 THEN (num*6)+19 WHEN 7735 THEN (num*6)+20 WHEN 8599 THEN (num*6)+21 WHEN 5091 THEN (num*6)+22 WHEN 8933 THEN (num*6)+23 WHEN 9120 THEN (num*6)+24 WHEN 5407 THEN (num*6)+25 WHEN 7874 THEN (num*6)+26 WHEN 5136 THEN (num*6)+27 WHEN 5427 THEN (num*6)+28 WHEN 8931 THEN (num*6)+29 WHEN 8367 THEN (num*6)+30 WHEN 8398 THEN (num*6)+31 WHEN 7736 THEN (num*6)+32 WHEN 8370 THEN (num*6)+33 WHEN 8364 THEN (num*6)+34 WHEN 7711 THEN (num*6)+35 WHEN 8924 THEN (num*6)+36 WHEN 9172 THEN (num*6)+37 WHEN 7710 THEN (num*6)+38 WHEN 5426 THEN (num*6)+39 WHEN 8324 THEN (num*6)+40 WHEN 8326 THEN (num*6)+41 WHEN 7737 THEN (num*6)+42 WHEN 8900 THEN (num*6)+43 WHEN 7842 THEN (num*6)+44 WHEN 8919 THEN (num*6)+45 WHEN 7705 THEN (num*6)+46 WHEN 7130 THEN (num*6)+47 WHEN 9224 THEN (num*6)+48 WHEN 7840 THEN (num*6)+49 WHEN 9017 THEN (num*6)+50 WHEN 5443 THEN (num*6)+51 WHEN 9222 THEN (num*6)+52 WHEN 8882 THEN (num*6)+53 WHEN 8921 THEN (num*6)+54 WHEN 8920 THEN (num*6)+55 WHEN 5444 THEN (num*6)+56 WHEN 8918 THEN (num*6)+57 WHEN 8793 THEN (num*6)+58 WHEN 9016 THEN (num*6)+59 WHEN 5438 THEN (num*6)+60 WHEN 7943 THEN (num*6)+61 WHEN 8589 THEN (num*6)+62 WHEN 7947 THEN (num*6)+63 WHEN 8612 THEN (num*6)+64 WHEN 7154 THEN (num*6)+65 WHEN 9015 THEN (num*6)+66 WHEN 5108 THEN (num*6)+67 WHEN 8926 THEN (num*6)+68 WHEN 8899 THEN (num*6)+69 WHEN 8923 THEN (num*6)+70 WHEN 5094 THEN (num*6)+71 WHEN 8922 THEN (num*6)+72 WHEN 9014 THEN (num*6)+73 WHEN 7217 THEN (num*6)+74 WHEN 8604 THEN (num*6)+75 WHEN 5092 THEN (num*6)+76 WHEN 8685 THEN (num*6)+77 WHEN 7110 THEN (num*6)+78 WHEN 8588 THEN (num*6)+79 WHEN 8894 THEN (num*6)+80 WHEN 8587 THEN (num*6)+81 WHEN 8883 THEN (num*6)+82 WHEN 7946 THEN (num*6)+83 WHEN 7309 THEN (num*6)+84 WHEN 7295 THEN (num*6)+85 WHEN 6461 THEN (num*6)+86 WHEN 5139 THEN (num*6)+87 WHEN 8597 THEN (num*6)+88 WHEN 7951 THEN (num*6)+89 WHEN 7940 THEN (num*6)+90 WHEN 4923 THEN (num*6)+91 WHEN 8595 THEN (num*6)+92 WHEN 7482 THEN (num*6)+93 WHEN 8590 THEN (num*6)+94 WHEN 8598 THEN (num*6)+95 WHEN 7477 THEN (num*6)+96 WHEN 8570 THEN (num*6)+97 WHEN 7955 THEN (num*6)+98 WHEN 7297 THEN (num*6)+99 WHEN 8593 THEN (num*6)+100 WHEN 5093 THEN (num*6)+101 WHEN 7709 THEN (num*6)+102 WHEN 7298 THEN (num*6)+103 WHEN 8596 THEN (num*6)+104 WHEN 7059 THEN (num*6)+105 WHEN 7008 THEN (num*6)+106 WHEN 8606 THEN (num*6)+107 WHEN 7010 THEN (num*6)+108 WHEN 7941 THEN (num*6)+109 WHEN 5140 THEN (num*6)+110 WHEN 6124 THEN (num*6)+111 WHEN 7303 THEN (num*6)+112 WHEN 8569 THEN (num*6)+113 WHEN 7153 THEN (num*6)+114 WHEN 7009 THEN (num*6)+115 WHEN 7311 THEN (num*6)+116 WHEN 6464 THEN (num*6)+117 WHEN 8586 THEN (num*6)+118 WHEN 7938 THEN (num*6)+119 WHEN 8392 THEN (num*6)+120 WHEN 7937 THEN (num*6)+121 WHEN 7048 THEN (num*6)+122 WHEN 7313 THEN (num*6)+123 WHEN 6171 THEN (num*6)+124 WHEN 7706 THEN (num*6)+125 WHEN 8365 THEN (num*6)+126 WHEN 8375 THEN (num*6)+127 WHEN 7061 THEN (num*6)+128 WHEN 8325 THEN (num*6)+129 WHEN 6755 THEN (num*6)+130 WHEN 7131 THEN (num*6)+131 WHEN 7950 THEN (num*6)+132 WHEN 8363 THEN (num*6)+133 WHEN 8408 THEN (num*6)+134 WHEN 8568 THEN (num*6)+135 WHEN 7063 THEN (num*6)+136 WHEN 5465 THEN (num*6)+137 WHEN 7851 THEN (num*6)+138 WHEN 7562 THEN (num*6)+139 WHEN 7750 THEN (num*6)+140 WHEN 5439 THEN (num*6)+141 WHEN 5437 THEN (num*6)+142 WHEN 7939 THEN (num*6)+143 WHEN 7294 THEN (num*6)+144 WHEN 7949 THEN (num*6)+145 WHEN 7475 THEN (num*6)+146 WHEN 7935 THEN (num*6)+147 WHEN 7565 THEN (num*6)+148 WHEN 7944 THEN (num*6)+149 WHEN 7936 THEN (num*6)+150 WHEN 7300 THEN (num*6)+151 WHEN 6151 THEN (num*6)+152 WHEN 7478 THEN (num*6)+153 WHEN 7218 THEN (num*6)+154 WHEN 7945 THEN (num*6)+155 WHEN 7476 THEN (num*6)+156 WHEN 7942 THEN (num*6)+157 WHEN 7564 THEN (num*6)+158 WHEN 6143 THEN (num*6)+159 WHEN 6145 THEN (num*6)+160 WHEN 7306 THEN (num*6)+161 WHEN 6606 THEN (num*6)+162 WHEN 6607 THEN (num*6)+163 WHEN 7183 THEN (num*6)+164 WHEN 6155 THEN (num*6)+165 WHEN 6140 THEN (num*6)+166 WHEN 5471 THEN (num*6)+167 WHEN 5738 THEN (num*6)+168 WHEN 7957 THEN (num*6)+169 WHEN 5107 THEN (num*6)+170 WHEN 6613 THEN (num*6)+171 WHEN 7290 THEN (num*6)+172 WHEN 6139 THEN (num*6)+173 WHEN 5303 THEN (num*6)+174 WHEN 5301 THEN (num*6)+175 WHEN 6040 THEN (num*6)+176 WHEN 7745 THEN (num*6)+177 WHEN 5468 THEN (num*6)+178 WHEN 7022 THEN (num*6)+179 WHEN 5299 THEN (num*6)+180 WHEN 7056 THEN (num*6)+181 WHEN 7744 THEN (num*6)+182 WHEN 7067 THEN (num*6)+183 WHEN 7066 THEN (num*6)+184 WHEN 7049 THEN (num*6)+185 WHEN 6038 THEN (num*6)+186 END,numErr153a