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(10929586,10929587,10929588,10929589,10929590,10929591,10929592,10929593,10929594,10929595,10929596,10929597,10929598,10929599,10984620,10984621,10984622,10984623,10984624,10984625,10984626,10984627,10984628,10984629,10984630,10984631,10984632,10984633,10984634,10984635,10984636,10984637,10984638,10984639,10984640,10984641,10984642,10984643,10984644,10984645,10984646,10984647,10984648,10984649,10984650,10984651,10984652,10984653,10984654,10984655,10984656,10984657,10984658,10984659,10984660,10984661,10984662,10984663,10984664,10984665,10984666,10984667,10984668,10984669,10984670,10984671,10984672,10984673,10984674,10984675,10984676,10984677,10984678,10984679,10984680,10984681,10984682,10984683,10984684,10984685,10984686,10984687,10984688,10984689,10984690,10984691,10984692,10984693,10984694,10984695,10984696,10984697,10984698,10984699,10984700,10984701,10984702,10984703,10984704,10984705,10984706,10984707,10984708,10984709,10984710,10984711,10984712,10984713,10984714,10984715,10984716,10984717,10984718,10984719,10984720,10984721,10984722,10984723,10984724,10984725,10984726,10984727,10984728,10984729,10984730,10984731,10984732,10984733,10984734,10984735,10984736,10984737,10984738,10984739,10984740,10984741,10984742,10984743,10984744,10984745,10984746,10984747,10984748,10984749,10984750,10984751,10984752,10984753,10984754,10984755,10984756,10984757,10984758,10984759,10984760,7071350,10102541,10841294,11048720,10984617,10984618,10984619,8907583,8907584,10622125,10622126,8853620,8853621,9181903,9181904,9181905,9181906,9181907,9181908,9181909,9181910,9181911,9181912,9181913,9181914,9181915,9181916,9181917,9181918,9181919,9181920,9181921,9181922,9181923,9181924,9181925,9181926,9181927,9181928,9181929,9181930,9181931,9181932,9181933,9181934,9181935,9181936,9181937,9181938,9181939,9181940,9181941,9181942,9181943,9181944,9181945,9181946,9181947,9181948,9181949,9181950,9181951,9181952,9181953,9181954,9181955,10120588,990168,990169,7057089,7057090,7057091,7057092,7057093,7057094,7057095,8855131,8550713,8550714,8550715,8550716,4972504,9191691,10898732,8594175,8594176,8594177,10170677,10170678,10170679,10899858,10899859,10899860,10899861,10899862,10899863,10899864,10899865,10899866,10899867,10899868,10899869,10899870,10899871,10899872,10899873,10899874,10524779,10480932,10480933,10480934,10480935,10480936,10483326,10483327,10481852,10481853,10481854,10481855,10481856,10481857,10481858,10481859,10481860,10481861,10481862,10481863,10481864,10481865,10481866,10481867,10481868,10481869,10481870,10481871,10481872,10481873,10481874,10481875,10481876,10481877,10481878,10481879,10481880,10481881,10481882,10481883,10481884,10714968) 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>