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(8630789,10861437,10861438,8630873,8630890,8583490,10950701,10950702,7066181,10862926,10862929,10862947,10862948,10862949,10862950,10862951,10862952,10862954,10862955,10862956,10862957,10862958,10862959,10862960,10862961,10862962,10862963,10862964,10862965,10862966,10862968,10862969,8632496,10929242,10939399,10939400,10939401,10939402,10861184,10861185,10861186,10861187,10861188,8595067,8595099,3899093,10859526,10859527,5654599,11049794,10857797,10857798,10857799,10857800,10857801,10857802,10857803,10857804,10857805,10857806,10857807,10857808,10857809,10857810,10857811,10857812,10857813,10857814,10857815,10857816,10857817,10857818,10857819,10857820,10857821,10857822,10857823,10857824,10857825,10857826,10857827,10857828,10857829,10857830,10857831,10857832,10857833,10857834,10857835,10857836,10857837,10857838,10857839,10857840,10857841,7201022,7201023,7201024,7201025,7201026,8627530,8627531,8627532,8627533,8627534,8627535,8627536,8627537,8627538,8627539,8627540,8627541,8627542,8627543,8627544,8627545,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627554,8627555,8627556,8627557,8627558,8627559,8627560,8627561,8627562,8627563,8627564,8627565,8627566,8627567,8627568,8627569,8627570,8627571,8627572,8627573,8624611,8909073,8909074,10856515,11048452,3923490,8554339,10854285,7197409,7197410,7197411,7197412,3234729,8905344,8905345,8905346,8905347,8905348,8905349,8905350,3232874,3232886,8632830,8632831,8632832,8632833,8632834,8632835,8632836,8632837,8611336,8611337,8552639,8552692,8552693,8552694,8552695,8552696,10614255,10614256,10614257,10614258,10614259,10614260,10614261,10614262,10614263,10614264,10611342,10714158,10611698,10611880,10611881,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611891,10611892,10611893,10611894,10611895,10611896,10611897,10611898,10611899,10611900,10611901,10611902,10611903,10611904,10611905,10611906,10611907,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611918,10611919,10611920,6666255,10611921,10611922,10611923,10611924,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611936,10611937,10611938,10611939,10611940,10611941,10611942,10611943,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,10611976,10611983,10611997,10611999,10612000,10612001,10612002,10612003,10612004,8851468,8851647,8851648,8851649,8851650,8851651,8851652,8851653,8851654,8851655,8851656,8566702,8852117,8852118,8852119,8852120,10613168,10610296,10610297,10610298,7055492,7055493,7055494,10117654,6673720,6673721,9911926,9911927,10118183,10118184,10118185,9912713,9912714,9912715,9912716,9912717,9912718,9912719,9912720,9912721,8850762,8850865,8850872,9168358,9168359,9168360,9168361,9168362,10415373,10415374,6672697,6672698,6672699,10416496,10416514,10416515,10416516,10416517,10416518,10416519,10416520,10416521,10416522,10416523,10416524,10416525,10416526,10416527,10416528,10416529,10416531,10416532,6665140,3963320,10467813,8550564,10468376,10468377,10468378,10468379,10468380,10468381,10468382,10468383,10468384,10468385,10468386,10468387,10468388,10468389,10468390,10468391,10468392,10468393,10468394,10468395,10468396,10468397,10468398,10468399,10468400,10468401,10468402,10468403,10468404,10468405,10468406,10468407,10468408,10468409,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,10427651,10628321,10884681,10884682,10884683,10884684,10884685,10890032,10627771,10883320,10883321,10883322,10883323,10900846,10161955,10897076,10887129,10887130,10887131,10887132,10647477,10604028,10604692,10601752,10507657,10507861,10507862,10507863,10507864,10507865,10507866,10507867,10507868,10507869,10507870,10507871,10507872,10507873,10507874,10507875,10507876,10507877,10507878,10507879,10507880,10507881,10507882,10507883,10507884,10507885,10507886,10411551,10413982,10413983,10410039,10412390,10412391,10412392,10412393,10412394,10412395,10412396,10412397,10412398,10412399,10412400,10412401,10412402,10412403,10412404,10412405,10412406,10412407,10412408,10412409,10412410,10412411,10412412,10412413,10412414,10412415,10412416,10412417,10412418,10412419,10412420,10412421,10412422,10412423,10412424,10412425,10412426,10412427,10412428,10412429,10412430,10415164,10415165,10415166,10415167,10415168) 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'