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(10962734,10861387,10861797,10950708,10869293,10869294,10869295,7201519,10858730,7201698,10858760,10858781,10858813,10858819,10858997,10858998,10858999,7202458,7202463,7202471,10857167,10865416,10865417,10865418,8626973,8627055,8627056,8910472,8627086,8835116,10863128,10863712,8909130,7199402,7199403,10101580,10856754,10856947,10856957,10623322,10623416,7196556,10853723,10853725,10854071,10854072,10854075,10854272,10854273,10854274,10854275,10854276,10854281,10854282,10854283,10854284,7197842,10617016,10617041,10617137,10852519,10852520,10852521,10852527,10617510,3232878,10951733,10951734,10951735,10951736,3230571,10615320,10615321,10615322,10615504,10615536,9217090,9217091,9217092,9217093,10850822,10850823,9217215,9217217,10850881,10850882,10850883,9217260,10615945,10426272,10426403,10616479,10616576,10616852,10616956,10616957,10616958,10616959,10611022,10611025,10614338,10614488,10122049,10122050,10122051,10614570,10611820,10611859,10611860,10611895,10611896,10611897,10612089,10612181,10612384,8851652,8851771,8851772,8851801,8851925,10612998,10612999,8852326,8852327,8852523,10610474,10610483,8852735,8852859,8852860,8852885,9169435,9911667,9911668,9169465,10117690,10117800,10118214,10118346,10118354,8850040,8850168,8551746,9912744,8850611,9168370,9910583,10116725,10415646,10416677,10418708,10418709,10418710,10420103,10469931,9167639,10466244,10466245,10466248,9167726,10468502,10468504,10468513,10628315,10884696,10877477,10877478,10882532,7001393,10627719,10161803,10625487,10602140,10580339,10580340,10606921,10604373,10604374,10604430,10604431,10604480,10604494,10604529,10604591,10604608,10604642,10604679,10604680,10604709,10498230,10498260,10421497,10421498,10421499,10498476,10508521,10505583,10507816,10507823,10507890,10413270,10413285,10413286,10413314,10413319,10413342,10413363,10413368,10413502,10413503,10413504,10411670,10409742,10409744,10409870,10409871,10409876,10411982,10410027,10410028,10410029,10410030,10410031,10410035,10410036,10410037,10410038,10408085,10410619,10408760,10408982,10408983,10408984,10408991,10415083) 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>