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(10930225,10930254,10845765,10845766,10845767,10845894,4970552,4970560,10848632,10848633,10848634,10848635,10848636,10848637,10848638,10848639,8067426,8067440,8067441,8584020,8584037,10437547,10872297,10872313,10872390,10869622,10845571,10845572,10845612,10845671,10845672,10845673,10930196,6000232,6000264,6000287,6000289,11011704,11011705,11011706,11011707,11011708,11011709,11011710,11011711,11011712,11011713,11011754,11011755,11011784,11011785,11011786,11011787,11011788,11011789,8559120,8559122,11011885,11011886,8559168,11011912,11011913,11011914,8559244,8559254,8559255,8559256,8559289,11012042,11012043,11012044,11012045,11012046,11012047,11012048,11012049,11012050,8559330,8559331,8559387,8559388,8559445,10103828,10103830,10103831,10103865,10103873,10103882,10103893,10103899,10103920,3899466,3899468,3899470,3899479,8618948,8618949,8618950,8618951,8618955,8618961,8618962,8628805,8619014,8619026,8619079,8619083,8619110,7202601,7202602,7202603,8596116,8836969,8836973,8836984,8837009,7065561,7073671,7073693,7073695,7073770,7073808,7073851,7073902,10942639,10942648,10942651,10942673,10942691,10942692,10942693,10942709,11049292,11011279,11011280,11011281,11011282,11011283,11011329,11011330,11011331,11011332,11011333,11011334,11011335,11011346,11011409,11011410,11011411,11011412,11011413,11011414,11011415,11011416,11011417,11011418,11011419,10866097,6000105,6000115,6000117,6000149,6000164,6000200,10944790,3655963,3655964,3655965,3655966,3655967,3655982,3655983,3655984,3656007,3656008,3656009,3656010,3656016,3656017,3656018,3656019,3656020,3656021,3656022,3656096,3656097,3656098,3656117,3656118,3656119,3656120,3656121,3656126,3656127,3656128,3656129,3656130,3656131,3656132,3656133,3656134,3656135,3656136,3656157,3656158,3656159,3656176,8556755,3926932,3926933,3926943,3926948,3926949,8073463,8073480,8073487,7156544,10837903,10968243,10838940,10427324,10427325,10427326,10427327,10617332,8570207,8570249,10952245,3582188,10930799,9217595,10930915,9217654,9915704,10714426,8864560,8864562,8864563,8864605,8864642,8864643,8864653,8864679,8864710,8542663,8542686,10612959,7058519,7058520,7058526,7058527,7058532,7058571,7058598,7058599,7058600,7058601,7058602,7058607,8552474,10419237,976318,976325,976326,10428389,4974020,4974040,4974100,9161258,8854921,8854922,3963624,8550612,6473837,6473838,10123806,10123807,10123808,10123818,9199628,9199629,9199630,10123838,10123841,10123842,10123843,10123844,10123845,10123925,8550888,10123971,10123972,10123973,10124000,8917700,8917716,4972926,4972933,4972939,8917742,9176263,10888842,10154858,10888850,8594397,10628878,10628879,10628880,10628881,10628882,8594404,10628893,8594424,10628904,10628905,10628906,10628935,10628936,10629034,10629035,10629036,10629166,10629167,10629168,10629169,10629170,10629171,10629172,10629173,10629174,10629175,10629176,10170698,10629177,10629178,10629179,10629180,10629181,10629182,10629183,10629184,10629185,10629186,10629187,10629188,10629189,10629190,10629263,10629264,10629265,10629304,10629305,10629306,10629307,10629308,10629309,10629310,10166051,10912518,10912519,10912520,10912521,10912522,10178586,10159213,10176564,10176565,10176566,10176567,10176569,10176585,10176586,10176587,10176588,10176612,10176613,10176614,10176698,10176712,10176772,10176773,10176774,10176790,10176802,10176803,10176938,10176939,10176940,10176941,10176942,10176943,10176944,10176945,10176946,10177044,10177045,10177046,10177047,10177048,10177049,10948923,10948926,10948927,10177191,10177192,10177193,10177194,10177195,10177196,10177197,10177198,10177199,10177200,10901753,10911957,10911971,10911972,10911973,10911974,10911975,10911976,10911977,10911978,10911979,10912000,10912001,10912061,10912071,10912072,10912073,10912074,10912075,10912076,10912077,10912221,10950060,10882301,10912355,10912356,10882357,10912357,10882358,10912358,10912359,10912360,10912361,10912362,10912363,10912364,10912365,10912366,10912367,10912368,10912369,10912370,10912371,10912372,10912373,10912374,10912375,10912376,10912377,10912378,10912379,10882400,10882401,10882402,10882403,10568491,10568492,10652795,10652824,10567483,10567484,10567485,10567486,10567487,10567488,10567489,10567502,10567503,10567504,10567505,10567506,10567913,10567914,10568026,10568027,10568028,10568029,10568030,10568031,10568032,10568033,10568034,10568035,10568036,10568037,10568038,10568039,10568040,10568041,10568042,10568043,10568044,10568045,10568046,10568047,10423461,10423526,10421714,8563130,8563164,10493048,10493049,10493050,10493051,10493052,10493053,10493054,10493064,10493065,10493066,10493077,10493078,10493079,10493124,10493129,10493130,10493131,10493180,10493219,10493220,10493221,10493222,10493223,10715144,10715145,10715147,10715148,10406893,10406894,10406895,10406896,10406897,10406898,10406899,10406900,10482564) 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
ERROR: Unknown column 'p.products_specials' in 'order clause'