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(10447815,10447826,8574351,8838683,8838689,8838696,8574551,8574552,8574553,8574579,8569880,8569881,8569884,7074102,7074130,7074137,8575633,8067505,8067659,8067660,10497744,10497764,10497765,7066997,10497814,10497815,10497816,10497817,10497818,10497819,10497820,10497821,10497841,10497842,10497843,10497859,10497884,10497897,8068001,8068002,8068032,8068033,8068034,8068035,8068042,8068043,10497949,8068044,10497950,8068050,8068086,10498021,10498046,10498047,8837756,10498073,10498074,10498075,10498076,10498093,8837789,8837790,8837791,8068211,8837820,8068222,8068223,8068237,8068238,10498149,10498150,8068266,8068282,8068283,10498198,8068293,8068294,10498199,8068374,8837992,8068407,8068408,8838036,8068530,8068531,8068532,8068617,8068625,8068640,8068641,8835572,8835573,8911299,10973115,7072436,7072579,7072603,8836237,8836287,7072800,10103948,8065797,7072947,7072961,7073068,8066254,8066274,8066275,8066283,8066296,8066309,8066339,8066343,8066344,8066359,8066360,10932773,8066429,8066430,8066511,8066610,8066611,8066612,8066634,8066635,8066636,8066668,8066717,8066718,10497560,10497601,10497633,10497634,10497635,10497652,10497653,10497660,10497661,10497670,10497673,10497677,11049109,10942931,10942944,10943315,7071772,7071773,8970220,8910990,8910991,8910992,7068937,7068981,8564782,8564783,8909136,8564791,8564796,8564797,8909166,8909273,10941913,10941956,8909500,8909501,8909502,8909534,8909756,7070741,10942429,8909888,10942458,10942473,11032749,8906144,10923636,8906172,10923653,11045801,10923654,10923655,10923656,10918764,10918765,10918766,8906340,10923829,10923882,10923974,10923975,10923976,10923977,10924056,10924057,10924058,10924059,10919234,10919235,10924390,11007780,11007781,10924784,10924785,10924786,10924787,10924788,10924789,10924875,10924876,10924877,10924878,10924879,10919911,10919912,10925186,10925187,10925188,10925239,10925240,10992639,10992737,10992738,10992781,8905207,10922730,10992888,10992889,10922760,10993043,10993072,10993073,10917956,10917957,10993109,10993110,10993111,10993112,10918018,10617509,10993222,10993223,10993231,10993322,10993323,10918284,10993438,10918324,11006490,10993549,10993550,10993551,10920537,10920557,10915605,8570301,8570302,10920873,10920874,10921211,10921239,10991524,10991556,10921499,10921597,10921598,10921599,10921614,10921731,10921751,10921752,10621269,10621270,10621271,10621277,10621300,10621311,10621374,10992103,10992104,10917052,10621652,10621653,10621654,10616669,10621706,10992367,10992427,10992428,10992429,10992499,10614296,9189988,9206061,10614821,9203320,10612033,9195434,9195435,7057630,9195542,9187609,9195613,9195614,9195615,9195616,9195617,10557504,9195706,9187707,9203790,9203791,9203792,9203793,9203948,7058230,9196074,9204100,9204101,9204113,9204114,9204115,9204116,9204117,9204118,9188120,9188124,9204208,9204213,9196297,9204319,9204423,9212452,9212455,9212456,9212457,9212458,9212459,9204462,9204463,9204470,9204479,9204494,9204495,9204499,9204534,9204574,10564454,10613306,10613342,8863314,8863347,8863348,8863362,8863363,8863364,8863365,8863390,8863395,8863411,8863412,10613553,8863413,10613608,8863472,8863473,8863474,8863500,8863511,8863542,8863543,8863544,8863545,8863546,8863547,9189041,9189062,9189063,7059273,9185331,9193368,9193379,10555344,10555345,10555346,10555347,10555348,10555349,10555399,10555400,10555401,10555402,10555403,10555404,10555405,10555406,10555407,10555408,10555409,9193604,9193611,9169643,9193704,10517544,9193763,9193770,9201814,9193882,9201885,9201924,9201925,4974794,4974854,9186044,9202053,9202054,9186063,9194079,9194080,9194081,9202094,9202095,9186101,9202124,9186260,9194326,9194327,9194328,9194329,9186402,9186407,9202410,9202411,9202412,9202413,9202414,9186464,9186465,9194472,9194473,9186495,9186507,9202538,9202539,9202567,9202568,9186578,9194583,9194584,10556440,10556441,10556442,10556443,10556444,9202730,9202731,2809381,9194770,10556700,9195075,9195094,9195095,9195096,9195097,9195098,9203146,9203169,9203170,9203171,9203247,9203248,9203249,9203287,9200451,10417544,9192664,9200708,9200709,9192713,9192800,10417760,10417766,10417775,9192876,10417093,10417106,10417107,10417108,10418124,10418131,9206409,10463042,10463043,10463044,10463045,10463046,10463047,10463048,10463049,10463050,10463051,10463052,10463053,10463054,10463055,10463056,10463057,10463058,10463059,10463060,9206546,9206547,9190621,9190623,9190629,4972038,4972039,4972040,4972077,4972098,4972128,4972129,4972236,10467985,10468019,10468044,8563399,10468141,10470380,10470381,10470385,10470483,10470490,10470590,10470593,9192023,9200232,9176261,9200279,10174515,10174516,10628022,10169575,10628090,10169636,10169637,10169659,10169664,10169666,10169667,10169668,10169673,10179737,10179738,10174819,10179823,10179824,10169841,10169842,10169847,10169848,10169872,10169898,10179931,10180034,10180035,10180036,10180108,10180109,10180110,10180453,10180511,10180512,10180513,10180873,10180911,10629606,10629607,10181162,10629658,10181201,10181202,10629754,10629755,10629808,10629837,10181423,10629904,10186429,10181457,10168490,10168491,10168492,10168493,10168510,10168511,10168512,10168513,10168532,10168533,10168534,10168535,10183563,10168617,10168618,10168619,10168629,10168691,10168692,10168693,10168694,10183719,10168734,10168735,10168736,10183737,10183738,10183739,10183740,10183741,10183742,10183743,10168777,10168778,10627279,10183803,10168923,10168924,10168925,10168974,10169049,10169133,10169134,10169135,10169136,10169137,10169280,10630114,10186663,10186664,10630191,10181758,10181759,10181845,10181846,10181847,10181848,10630360,10181895,10630373,10181896,10630374,10181897,10630375,10181898,10181957,10181958,10181959,10181997,10182020,10182191,10182192,10630711,10182338,10182339,10177345,10182358,10182457,10182466,10631005,10631008,10631009,10182562,10177583,10177584,10182595,10626131,10182766,10182789,10182790,10177876,10182969,10182980,10182981,10167987,10183053,10183067,10626551,10626552,10183131,10183243,10183244,10168247,10168248,10168249,10168261,10168267,10168268,10168269,10168270,10183297,10183311,10168312,10168313,10168336,10168337,10168338,10168339,10168352,10168402,10183447,10183457,10168461,10168467,10168468,10168469,10168470,10168471,10183477,10183478,10183483,10577208,10577391,10577392,10577393,10577394,10577395,10577396,10577397,10577398,10577399,10577400,10577401,10577402,10571402,10577403,10571403,10577404,10571404,10577405,10571405,10577406,10577407,10577408,10577409,10577410,10574460,10574461,10574462,10586628,10577763,10577764,10574779,10571789,10571790,10571791,10577818,10578048,10578057,10578058,10575146,10575147,10575148,10575149,10575150,10578199,10578200,10578201,10569290,10569291,10569292,10569293,10578297,10578298,10578339,10578340,10575398,10578444,10578445,10578446,10578447,10578448,10572480,10572481,10572482,10572483,10569495,10569496,10569518,10569519,10569520,10569521,10575542,10581629,10581646,10581647,10581659,10581660,10581661,10581662,10581663,10581664,10569684,10569685,10569686,10569687,10569688,10578691,10569705,10569706,10569707,10569708,10569709,10569710,10569711,10569712,10569713,10581727,10581728,10569852,10578867,10578868,10578869,10578927,10572999,10573000,10573001,10570067,10570068,10570081,10570082,10570083,10570096,10570097,10576172,10576246,10576247,10576248,10576249,10576250,10576251,10576252,10576253,10570280,10576365,10576366,10579378,10579379,10579380,10579381,10579423,10579424,10570455,10570456,10570457,10573479,10573480,10573481,10573482,10573483,10573484,10573485,10573486,10573487,10573488,10573489,10573490,10573491,10573492,10570542,10570543,10570544,10570545,10570546,10591591,10591592,10591593,10591594,10591595,10573616,10573617,10573618,10573619,10573620,10573621,10573622,10591682,10576689,10576954,10535274,10535275,10531295,10535325,10525325,10527384,10531542,10531655,10531656,10531657,10523669,10529678,10529903,10529904,10531920,10535921,10531921,10535922,10535923,10535924,10531954,10531955,10529966,10529967,10529972,10529976,10529977,10532060,10532061,10532083,10532136,10532303,10532304,10532336,10532337,10530442,10530443,10532505,10532506,10532507,10532508,10532509,10532510,10532511,10532512,10532513,10532514,10532515,10534626,10534627,10534628,10536658,10530686,10532735,10532824,10534863,10534864,10534865,10532929,10532930,10532965,10533046,10533047,10423927,10422018,10422039,10422050,10421102,10422122,10487903,10487918,10488082,10479236,10479377,10479633,10479634,10479635,10479749,10479750,10479751,10479752,10479753,10479771,10479772,10479802,10479803,10479804,10479805,10479806,10479807,10479808,10479809,10479810,10479956,10479957,10479958,10479959,10479960,10480135,10480136,10480176,10480177,10480178,10480447,10487555,10487578,10487605,10487667,10487725,10487726,10487770,10487771) 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'