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(10528537,10697011,10503903,10503904,10503905,10503906,10503907,10503908,10503909,10503910,10503911,10503912,10503913,10503914,10503915,10503916,10503917,10503918,10503919,10503920,10503921,10503922,10503923,10503924,10503925,10503926,10503927,10503928,10503929,10503930,10503931,10503932,10503933,10503934,10503935,10503936,10503937,10503938,10503939,10503940,10503941,10503942,10503943,10503944,10503945,10503946,10503947,10503948,10503949,10503950,10503951,10503952,10503953,10503954,10503955,10503956,10503957,10503958,10503959,10503960,10503961,10503962,10503963,10503964,10503965,10503966,10503967,10503968,10503969,10503970,10503971,10503972,10503973,10503974,10503975,10503976,10503977,10503978,10503979,10503980,10503981,10565197,10565198,10565199,10565200,10565201,10565202,10565203,10565204,10565205,10565206,10565207,10565208,10565209,10565210,10565211,10565212,10565213,10565214,10565215,10565216,10565217,10565218,10565219,10565220,10565221,10565222,10565223,10565224,10565225,10565226,10565227,10565228,10565229,10565230,10565231,10565232,10565233,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565243,10565244,10565245,10565246,10565247,10565248,10565249,10565250,10565251,10565252,10565253,10565254,10565255,10565256,10565257,10565258,10565259,10851618,10851619,10851620,10851621,10851622,10851623,10851624,10851625,10851626,10851627,10851628,10851629,10852630,10852631,10664035,10664036,10664037,10664038,10664039,10664040,10664041,10664042,10664043,10664044,10664045,10664046,10664047,10664048,10664049,10664050,10664051,10664052,10664053,8860155,8860156,8904700,10249969,10249970,10249971,10249972,10249973,10249974,10249975,10249976,10249977,10249978,10249979,10249980,10249981,10249982,10249983,10249984,10408482,10408483,10408484,10408485,10408486,10408487,10408488,10408489,10408490,10408491,10408492,10409060,10409061,8559047,8559048,8559049,8559050,8559051,8559052,8559053,8559054,8559055,8559056,8559057,10192465,10192466,10192467,10192468,10192469,3228303,3228304,3228305,9220017,9220018,9220019,9220020,9220021,9220022,9220023,9220024,9220025,9220026,9220027,9220028,9198971,9198972,9198973,9198974,9198975,9198976,9198977,9198978,9198979,9198980,9198981,9164463,9164464,9164465,9164466,9164467,9164468,9164469,9164470,9164471,9164472,9164473,9164474,9164475,9164476,9164477,9164478,9164479,9164480,9164481,9164482,9164483,9164484,9164485,9164486,9164487,9164488,9164489,9164490,9164491,10073684,10073685,10116423,10100850,10100851,10100852,10100853,10100854,10100855,8610651,8834492,8834493,8542661) 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>