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(11002086,11002087,11028209,11028210,11028211,11028212,11028213,11028214,11028215,11028216,11028217,11028218,11028219,11028220,11028221,11028222,11028223,11015228,11015251,11015252,11002314,11028330,11028331,11028332,11002334,11002335,11002336,10848945,10848946,11028348,11028349,11028350,11028351,11028352,11028353,11028354,11028355,11028356,11028357,11028358,11002501,11015516,11002521,11002522,11002523,11002524,11002663,11002668,11002953,11002954,11003055,8622299,8622300,8067476,8067493,11003235,11003299,11003403,11003530,11003531,11003532,11003533,11003619,11013663,11013672,10961785,10961786,10961787,10961788,10961834,11013844,11000992,11000993,11000994,11000995,11000996,11000997,11000998,11000999,11001000,11014372,8911061,8911095,10986004,10986047,11012225,11012654,11012679,11012680,11012681,11012682,11012683,11012684,11012686,11012687,8066002,11025722,11025723,11025724,11025725,11025726,11025727,11025728,11025729,11025730,11025835,11025836,11025837,11025838,11025839,11025840,11025841,11025842,11025843,11025869,11025870,11025871,11025872,11025873,11025874,11025875,11025876,11025877,11025878,11025879,11025880,11025881,11013153,11013155,11039248,11039249,11039308,11039310,11039344,11013379,11013386,11013387,8837249,8837250,11039445,11039446,11013508,11013510,10961550,11023727,11023731,11023935,11023936,11023937,11023938,11023939,11023940,11023941,3927750,11024063,10943259,11034739,11034796,11034867,11034868,11034869,11034870,11034912,11035033,11035081,11035082,11035083,11035094,11022095,11022096,11035120,11035121,11022128,11022129,11022130,11022131,11022132,11022133,11022134,11022135,11022136,11022137,11022138,11022139,11022153,11022154,11035270,11035293,11035295,11035304,10996341,11035373,11035412,11035413,10996578,11035784,11035785,11035786,10997132,10997133,11023181,11023194,10997257,11023339,11023340,7070688,10971430,10971431,10997458,11023467,3927221,11023583,10918643,7156650,7156655,10918681,11019838,11020028,11020030,11020310,11020311,11020312,11020313,11020314,11020315,11020316,11020317,11033485,10919369,10919370,11033575,11033576,11033648,7157626,10994842,11021053,11021054,11021080,11021081,11021082,11021083,11021088,11021089,11021090,11021091,11021092,11021093,11021094,11021095,11021096,11021097,11021098,11021099,11021100,11021101,11021102,11021103,11021104,11021105,11021106,11034121,11034123,11034361,11034362,11034363,11034364,11034365,10920299,10920300,10920301,10920302,10920306,11034507,11034508,11005731,11005767,11005769,11031805,11005816,11005939,11005940,8578586,8578587,8578588,11006118,11006119,11019123,11019124,11019125,11019126,11019127,11032141,11032142,11032143,11032144,11032159,11032167,11032168,8578662,11032169,8578663,11032170,11032171,11032172,11032173,11032174,10918067,8578974,11019543,11032590,11032591,11032592,11032612,11032613,11003620,10460548,11003735,11003736,10848091,10848092,11004029,11004072,8576689,11004217,11004218,11030227,11030228,11030229,11030230,11030231,11030296,11030297,11030298,3231054,11030326,11030327,11030328,11030329,11030330,11030331,11030332,11030333,10930638,11004402,11004403,11004404,11004405,10916305,10916306,10916307,10916308,10916309,11004491,11017566,11017567,11017568,11017569,11017570,11017571,11017572,10916425,11017573,10916426,10916427,11004577,11004584,8577085,11017714,11017715,11017716,11017717,11017718,11017719,11017720,11017721,11017722,11017740,11030784,11004964,11004965,11031054,11005097,8577628,8577743,11031340,11031341,11031342,11005363,10917279,11031492,11031500,11031501,11031502,10616901,11005605,11005606,11005607,11005615,11005616,11005617,10614206,7059750,9915963,6678006,9174139,9916435,10609717,6677376,8849176,9201355,8849194,8593027,9161963,9202331,9202896,9203008,9203009,9203010,9200360,6680819,8848503,9208892,9201076,6678734,6678735,6678767,6678769,6679468,10115592,6679663,10468093,6679981,6679982,6679985,9191969,10124388,10179555,10914506,10914847,10914848,10914849,10915151,10915152,10915218,10915219,10166256,10178729,10178730,10172066,10631880,10574122,10571147,10602003,10649374,10602197,10602210,10653052,10572031) 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>