QUERY: SELECT
	                  
            p.products_id,
            p.products_model,
            p.label_ids,
            p.main_category,
            p.products_ean,
            p.products_fsk18,
            p.products_quantity,
            p.products_quantity_min,
            p.products_quantity_step,
            p.products_price,
            p.products_price_small_opt,
            p.products_price_opt,
            p.products_purchase_price,
            p.small_opt_purchase_price,
            p.count_small_opt_purchase_price,
            p.count_opt_purchase_price,
            p.opt_purchase_price,
            p.postavshik,
            p.suplier_catalog_id,
            p.postavshik_comment,
            p.name_catalog_id,
            p.products_tax_class_id,
            p.products_image,
            p.products_vpe,
            p.products_vpe_status,
            p.products_vpe_value,
            p.products_currency,
            p.products_page_url,
            p.video,
            p.show_video,
            pd.products_short_description,
	        p.rev_total,
	        p.rev_rating,
            pd.products_name,
	                  p.products_ordered,
	                  pd.products_short_description,
	                  s.status,
	                  IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
	                  m.manufacturers_name,
	                  m.manufacturers_id FROM products  AS p 
	LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) 
	LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
	LEFT JOIN specials AS s on p.products_id = s.products_id
	LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id) 
	LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1  AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(10939910,8630960,8630967,8630976,8631080,8631122,3228957,9215855,10849713,8632194,8632196,10849868,10849869,10849870,10850147,8629905,3227739,3227740,3227741,7067445,8630203,7067767,10866540,10866542,10866805,10866806,10866810,10866822,10866866,10866873,10866874,10867208,7202477,7202478,10859933,8629548,8629549,8629550,8626964,8910446,7200639,7200640,7200641,7200642,7200643,8835030,10857968,10857969,10857970,10858003,10858006,10858007,10858008,10858060,10858061,10858062,10858072,10858073,10858074,10858075,10858076,10858077,10102945,10858108,10858109,10858115,10858184,7201155,3925351,8624787,8624930,8624931,8624932,10863582,10863583,8624948,8624949,8624963,8624975,8625019,8625022,8625023,8625030,8625031,8625032,8625040,8625041,8625042,8625135,8625136,8625140,8909106,8625700,8625701,10941849,8625937,8625938,8625939,8626015,8626016,8626017,8626018,8626019,8626020,8626323,8626324,3233411,3233412,3233413,3233420,8612934,8612935,8612936,10967838,10967839,10967840,10967841,10967842,10967843,10967844,10967845,10955114,10955115,10853772,3234097,3924139,3924140,3924142,3924143,3924144,3924145,3924146,3924147,3924148,10838537,8555254,8555268,3924778,8907482,11008167,11008168,3234950,3234951,3234952,3234960,3234961,3234962,3234963,3234968,3234969,10617367,10617368,10617370,10617371,10617377,10617390,10617391,10617392,10617399,10617400,10617401,10617402,10617406,10617407,10617408,10617424,8635062,10617804,8609891,3230814,11043189,11043190,11043191,11043192,3581898,3581899,3581900,3581904,3581905,3581906,3581907,3581908,3581909,8633223,3231639,3231640,3231641,3231642,3231643,3232160,3232161,3232162,3232177,3232239,3232242,8634487,8634488,8634489,3232285,3232288,3232289,3232294,3232295,3232296,8853223,8568058,10614495,10122209,10119722,10119723,10119724,10119725,10119726,10119727,10609988,9188396,10613831,9173229,7015133,7015134,7015135,7015136,7015137,7015138,7015139,7015140,7015492,7015493,7015494,7015495,7015496,7015497,9912423,9186564,9170743,9192604,10419669,10419670,10419675,10419688,10419747,10419755,10419756,8848848,9193120,10417110,10471171,10469573,7020827,7020828,7020829,7020830,7020831,7020832,7020833,7020834,7020835,7020836,7020891,7020892,7020893,7020894,7020895,7020896,7020897,7020898,7020899,7020900,7021081,7021082,7021083,7021084,7021085,7021086,7021087,7021088,7021089,7021090,8847541,8847542,9175880,9175881,9175882,9175883,9175884,9175885,9175886,9175887,9175888,9175889,9175890,10464800,10890139,10890141,10890142,10890143,10890144,10890145,10890151,10887546,10632042,10632043,10883044,10908338,10883403,10883404,10886133,10886134,10886135,10886136,10886137,10886138,10601399,10586453,10586454,10586455,10598560,10602722,10601436,10601693,10522352,10522353,10522354,10522355,10522356,10522357,10507785,10407369,10407370,10407552,10477385,10477386,10477387,10409758,10486951,10486952,10486953,10486954,10414328,10478012,10412555,10412556,10412557,10412589,10412592,10412593,10412638,10412639,10412640,10412641,10412651,10412652,10412653,10412654,10412655,10412656,10412687,10412692) GROUP BY p.products_id  ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END  asc ,p.products_specials desc<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>