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(4970450,8595084,8595085,10865549,10865550,10865551,10865552,7198677,7198678,10856554,10856555,10856556,10856557,10856558,10856559,10856560,10856561,10856562,10856563,10856564,10856565,10856566,10856567,10856568,10856569,10856570,10856571,10856572,10856573,10856574,10856575,10856576,10856577,10856578,10856579,10856580,10856581,10856582,10856583,10856584,10856585,10856586,10856587,10856588,10856589,10856590,10856591,10856592,10856593,10856594,10856595,10856596,10856597,10856598,10856599,10856600,10856601,10856602,10856603,10856604,10856605,10856606,10856607,10856608,10856609,10856610,10856611,10856612,10856613,10856614,10856615,10856616,10856617,10856618,10856619,10856620,10856621,10856622,10856623,10856624,10856625,10856626,10856627,10856628,10856629,10856630,10856631,10856632,10856633,10856634,10856635,10856636,10856637,10856638,10856639,10856640,10856641,10856642,10856643,10856644,10856645,10856646,10856647,10856648,10856649,10856650,10856651,10856652,10856653,10856654,10856655,10856656,10856657,10856658,10856659,10856660,10856661,10856662,10856663,10856664,10856665,10856666,10856667,10856668,10856669,10856670,10856671,10856672,10856673,10856674,10856675,10856676,10856677,10856678,10856679,10856680,10856681,10856682,10856683,10856684,10856685,10856686,10856687,10856688,10856689,10856690,10856691,10856692,10856693,10856694,10856695,10856696,10856697,10856698,10856699,10856700,10856701,10856702,10856703,10856704,10856705,10856706,10856707,10856708,10856709,10856710,10856711,10856712,10856713,10856714,10856715,10856716,10856717,10856718,10856719,10856720,10856721,10856722,10856723,10856724,10856725,10856726,10856727,10856728,10856729,10856730,10856731,10856732,8624340,8624341,8624342,8624343,8624344,10611193,10611194,10611195,9912106,9912107,9912108,9912109,9912110,9912111,9912112,9912113,6673074,8549995,8550812,9168165,10884294,10884295,10884296,10884297,10884298,10884299,10884300,10884301,10411581,10411582,10411583,10411584,10411585,10411586,10411587,10411588,10411589,10411590,10411591,10411592,10411593,10411594,10411595,10411596,10411597,10411598,10411599,10411600,10411601,10411602,10411603,10411604,10411605,10411606,10411607,10411608,10411609,10411610,10411611,10411612,10411613,10411614,10411615,10411616,10411617,10411618,10411619,10411620,10411621,10411622,10411623,10411624,10411625,10411626,10411627,10411628,10411629,10411630,10411631,10411632,10411633,10411634,10411635,10411636,10411637,10411638,10411639,10411640,10411641,10411642,10411643,10411644,10411645,10411646,10411647,10411648,10411649,10411650,10411651) 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>