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(10862785,10862786,10862787,10858117,10858118,10858119,10931620,7201662,10858737,10858766,10858785,10858821,10859125,10859129,10859132,7202645,7200922,10855454,10863751,7198768,10864194,10856554,10101399,10856570,8557321,10617974,10623344,10623438,7196990,7196994,7196995,8907105,7197853,10854931,10854932,10617169,10617170,10852609,10852610,8905385,10850813,10615911,10615971,10615972,10615993,10426290,8540628,8540629,10616567,9218134,8904852,8904853,8904854,8904855,8904856,8904857,8904858,8904859,8904860,8904861,10614330,10614477,10614478,10614479,10614480,10614481,10614483,10614489,10612039,10612204,10612205,10612342,10612967,8852154,8852157,10610258,10610259,10610476,8852850,8852868,8852890,10610873,9911553,9911554,9911555,9169410,10117891,8849918,990492,8849976,8849977,8849978,8849979,8849980,8849981,8849982,10118387,8850185,8850186,8850187,8850351,6672520,6672521,6672522,6672523,9168359,10416348,10416349,10416350,10116888,10117323,10117324,10117325,10117326,10117327,10117328,10417215,10467255,10467256,10467257,10467258,10467259,9167331,9167332,9167333,9167334,9167335,9167336,9167337,9167338,9167339,9167340,9167341,9167342,9167343,9167677,10627721,10627771,10161668,10161669,10161670,10161671,10161672,10161673,10161674,10161675,10161676,10161677,10161678,10161679,10161680,10161681,10161682,10885988,10882055,10882056,10882057,10882058,10882059,10882060,10882061,10882062,10882063,10882064,10882065,10882066,10882067,10882068,10882069,10882070,10882071,10882072,10882073,10882074,10882075,10882076,10882077,10882078,10882079,10882080,10882081,10882082,10608030,10608637,10608638,10608639,10608640,10608641,10608642,10608643,10608644,10608645,10608646,10608647,10608648,10608649,10608650,10608651,10608652,10608653,10608654,10608655,10608656,10608657,10608658,10608659,10608660,10608661,10608662,10608663,10608664,10608665,10608666,10608667,10608668,10608669,10608670,10608671,10608672,10608673,10608674,10608675,10608676,10608677,10608678,10608679,10608680,10608681,10608682,10608683,10608684,10608685,10608686,10608687,10608688,10608689,10608690,10608691,10608692,10608693,10608694,10608695,10608696,10608697,10608698,10608699,10608700,10608701,10608702,10608703,10608704,10608705,10608706,10608707,10608708,10608709,10608710,10608711,10608712,10608713,10608714,10608715,10608716,10608717,10608718,10608719,10608720,10608721,10608722,10608723,10608724,10608725,10608726,10608727,10608728,10608729,10608730,10608731,10608732,10608733,10608734,10608735,10608736,10608737,10608738,10608739,10608740,10608741,10608742,10608743,10608744,10608745,10608746,10608747,10608748,10608749,10608750,10608751,10608752,10608753,10608754,10608755,10608756,10608757,10608758,10608759,10608760,10608761,10608762,10608763,10608764,10608765,10608766,10608767,10608768,10608769,10608770,10608771,10608772,10608773,10608774,10608775,10608776,10608777,10608778,10608779,10608780,10608781,10608782,10608783,10608784,10647206,10647207,10647208,10647209,10647210,10647211,10647212,10647213,10647214,10647215,10647216,10647217,10647218,10647219,10647220,10647221,10647222,10647223,10647224,10647225,10647226,10647227,10647228,10647229,10647230,10647353,10604026,10604180,10604645,10604647,10604677,10538380,10538381,10538382,10538383,10507817,10507818,10507922,10413278,10413296,10413297,10413316,10413327,10413346,10413370,10411581,10411589,10413624,10413628,10413631,10408040,10408041,10410630,10409052) 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>