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(10848645,10848691,10848696,10873753,10873757,10873762,10873767,10873769,10873775,10873776,10873780,10873791,10873796,10873797,10873806,10862014,10862122,10862355,10862357,10862359,10862361,10849512,10849543,10849846,10849868,10863024,10863025,10863026,10863027,10863028,10863029,10863030,10863031,10863032,10863033,10863034,10863035,10863036,10863037,10863038,10863039,10863040,10863041,10863042,10863043,10863044,10863045,10863046,10863047,10863048,10863049,10863050,10863051,10863075,8632498,8632499,8632578,10861079,10861080,10861081,10861082,10861105,10861106,10861166,10861191,10861197,7201213,7201215,7201216,7201217,7201218,7201219,7201220,7201221,7201222,10866270,10866271,10866272,10866273,10866274,10866275,10858311,10858316,10866318,10858320,10858321,10858326,10858331,10858336,7201319,7201320,10866368,10866369,10866370,7201399,7201400,10866479,10866480,10866484,10866563,10866564,10866565,10866567,10866568,10866571,10866573,10866575,10866577,10866579,10866580,10866588,10866597,10866698,10866700,10866747,10866751,10866758,10866767,10866771,10866776,10866787,10866789,10866790,10866791,10866793,10866797,10866798,10866799,10866800,10866801,10866802,10858827,10858850,10858851,10866969,10866973,7202049,10859169,7202129,7202130,7202137,7202139,7202140,7202162,7202200,7202208,7202234,7202317,7202328,8628812,8628813,7202693,7202694,7202768,7200454,7200455,10857580,10857584,10857586,10857587,10857589,10857590,10857591,10857592,7200587,7200644,8627127,8627128,8627129,8627135,8627136,8627137,8627138,8627144,8627145,8627146,8627147,8627148,8627157,8627158,8627159,8627160,8627161,8627170,8627171,8627172,8627173,8627174,8627182,8627183,8627184,8627185,8627186,8627190,8627191,8627192,8627193,8627194,8627200,8627201,8627202,8627203,8627204,8627208,8627209,8627210,10857865,10857869,10857873,10857877,7200917,10866135,10866146,10866180,10866181,10863283,10863284,10863285,10855306,10863494,10863495,10863496,10863497,10863498,10863499,10863500,10863501,10863502,10863510,10863513,10863514,10855516,10855517,10855518,10855519,10855610,10855611,10855612,10855613,10855614,10855616,3235763,10855751,8625163,10863837,10863873,10856302,7199391,7199410,7199543,7199546,10856848,10856853,10856856,10856860,10856872,10856881,10856887,10856889,10856894,10856898,10856902,10856903,10857121,10857125,10865176,10865179,10865181,10865182,10865183,10865192,10853335,10853358,3923606,10853526,10853535,10618281,10853544,10853551,10853558,10853569,10853578,10853585,10853592,10853600,10853606,10853614,10853623,10853629,10854367,7197417,7197418,8624257,7197900,7197908,8624439,10852258,10852263,10852265,10852269,10617017,10852524,10852572,10852641,10852666,10852676,10852682,10852690,10853141,10615202,10850480,10850679,10850841,10850845,8634191,10851975,10851976,10852191,10852195,10852205,10852207,10852212,10852214,10852218,10614259,10612082,10612083,10609770,10612772,10612809,10612907,10612912,10612914,9220284,10610315,10610316,10610317,10610318,10610319,10610320,10610335,10610336,10610337,10610338,9911548,9911937,9911943,9911947,9911948,9911949,9911950,9911951,9169851,9912944,9913314,10419260,10417287,10419293,10419294,10417310,10419357,10419358,10419359,10419360,10419361,10419362,10419364,6672702,6672704,10419437,10419438,10419474,10419477,10419481,10418489,10418493,10418495,10418496,10418497,10418503,10418504,10419569,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10419603,10416604,10416605,10416606,10419607,10416607,10416608,10419614,10419623,10419627,10416628,10419633,10419642,10419647,10419651,10419653,10419654,10419655,10419661,10419662,10419663,10419664,10419665,10419666,10416811,10416812,10416813,10415839,10418877,10417025,10417026,10416027,10417027,10417028,10416029,10417029,10417030,10416031,10417031,10417032,10417033,10416033,10417034,10417043,10417044,10417048,10417049,7055454,9167958,10890049,10890050,10890052,10890084,10890219,10890221,10890245,10627712,10883358,10883359,10883378,10883392,10883396,10883397,10883398,10424392,10424396,10424403,10424404,10424408,10424418,10424423,10424426,10424434,10409350,10407369,10411382,10413383,10413384,10409501,10409653,10411760,10411765,10411768,10411772,10411785,10411792,10411798,10411800,10411804,10411809,10411810,10486535,10486545,10486549,10486554,10411955,10411959,10408058,10408062,10412203,10412206,10412210,10412212,10412213,10412215,10412216,10412217,10412218,10412428,10412448,10412452,10412456,10412460,10412464,10408652,10408653,10410682,10410683,10410684,10410685,10410774,10410775,10410776,10410777,10410779,10412845,10412850,10412854,10412855,10412860,10412865,10412870,10406906,10406958,10406963,10408988,10409025,10409084,10409088,10415091,10415092,10415093,10415094,10415095,10407096,10415111,10415112,10407129) 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>