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(8575083,10950683,8595261,10865416,10865417,10865418,10865419,10865420,10865421,10865422,10865423,10865424,10865425,10865426,10865427,10865428,10865429,10865430,10865431,10865432,10865433,10865434,10865435,10865436,10865437,10865438,10865439,10865440,10865441,10865442,10865443,10855722,10855723,10855724,10855725,10855726,10855727,10855728,10855729,10855730,10855731,10855732,10855733,10855734,10855735,10855736,10855737,10856179,7199590,7199869,7199870,7199871,7199872,7199873,10865020,10865021,8906555,8906616,8906617,8906618,7197527,7197528,7197529,7197530,7197531,7197532,7197533,7197534,7197535,7197536,7197537,7197538,7197539,7197540,7197541,7197542,8905148,10617508,10426216,10426217,10615923,10616048,10616049,10616050,10616051,10616052,10616053,10616054,10616055,10616056,10616057,10616058,7155308,9165551,10614572,8862496,10610413,10610414,9169711,9169712,9169713,9169714,9169715,9169716,9169717,9169718,9169719,9169760,8850213,8850214,8850215,9168365,10418307,10418308,7014109,7014110,7014111,7014112,7014113,7014114,7014115,7014116,7014117,7014118,7014119,7014120,7014121,7014122,7014123,7014124,7014125,7014126,7014127,7014128,7014129,7014130,7014131,7014132,7014133,7014134,7014135,7014136,7014137,7014138,7014139,7014140,7014141,7014142,7014143,7014144,7014145,7014146,7014147,7014148,7014149,7014150,7014151,7014152,7014153,7014154,7014155,7014156,7014157,7014158,7014159,7014160,7014161,7014162,7014163,7014164,7014165,7014166,7014167,7014168,7014169,7014170,7014171,7014172,7014173,7014174,7014175,7014176,7014177,7014178,10418708,10418709,10418710,10418711,10418712,10418713,10418714,10418715,10418716,10418717,10418718,10418719,10418720,10418721,10418722,10418723,10418724,10418725,10418726,10418727,10418728,10418729,10418730,10418731,10418732,10418733,10468904,10468905,8569231,8550047,8550165,10467854,10467855,10467856,10467857,10467858,10467859,10467860,10467861,976573,10470799,10470800,10470801,10888950,10884214,10884215,10889234,10889235,10889236,10879927,10889957,10890242,7000854,10883467,10883468,10883469,10883470,10883471,10887429,10522577,10522578,10522579,10522580,10522581,10522582,10522583,10522584,10522585,10522586,10505557,10505558,10505559,10505560,10505561,10505562,10411277,10410878,10410879,10410880,10410881,10410882,10410883,10410884,10410885,10410886,10410887,10410888,10410889,10410890,10410891,10410892,10410893,10410894,10410895,10410896,10410897,10410898,10410899) 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>