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(10870208,10870209,10870210,10870211,10870212,10870213,10870214,10870215,10843061,10843062,10843063,10843064,11048930,10941894,10941895,7070807,10968231,10992636,10992637,10992638,10992639,10992640,10992641,10992642,10992643,10992644,10992645,10992646,10992647,10992648,10992649,10992650,10992651,10992652,10992653,10992654,10992655,10992656,10992657,10992658,10992659,10992660,10992661,10992662,10992663,10992664,10992665,10992666,10992667,10992668,10992669,8570018,3654756,10122162,10122163,7057480,7057481,7057482,7057483,7057484,9186411,9186412,9186413,9186414,9186415,9186416,9186417,9186418,9186419,9186420,9186421,9186422,9186423,9186424,9186425,9186426,9186427,9186428,9186429,9186430,9186431,9186432,9186433,9186434,9186435,10903722,10903723,10903724,10903725,10903726,10903727,10903728,10531673,10531674,10531675,10531676,10531677,10531678,10531679,10531680,10531681,10531682,10531683,10531684,10531685,10531686,10531687,10531688,10531689,10531690,10531691,10531692,10531693,10531694,10531695,10531696,10531697,10531698,10531699,10531700,10531701,10531702,10531703,10531704,10531705,10531706,10531707,10531708,10531709,10531710,10531711,10531712,10531713,10531714,10531715,10531716,10531717,10531718,10531719,10531720,10531721,10531722,10531723,10531724,10531725,10531726,10531727,10531728,10531729,10531730,10531731,10531732,10531733,10531734,10531735,10531736,10531737,10531738,10531739,10531740,10531741,10531742,10531743,10531744,10531745,10531746,10531747,10531748,10531749,10531750,10531751,10531752,10531753,10531754,10531755,10531756,10531757,10531758,10531759,10531760,10531761,10531762,10531763,10531764,10531765,10531766,10531767,10531768,10531769,10531770,10531771,10531772,10531773,10531774,10531775,10531776,10531777,10531778,10531779,10531780,10531781,10531782,10422029,10422030,10422031,10422032) 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>