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(11014527,10962571,11001596,11001597,7067915,10939810,7068141,7076148,7076149,7068253,7068254,7068255,7068256,7068257,7068258,7068259,7068260,11001965,10940010,10940011,11015037,10940167,11002169,11002170,11002171,11002172,11002173,11002439,11002576,11002731,11002732,11002733,7074108,7066144,8067228,8067229,11002898,7074251,11003006,11003098,10990267,11016291,11016292,11016293,11016294,11016295,11016296,11016297,11016298,11016299,11016300,11003330,11003465,11003466,11003467,11003468,10961508,7066851,11013596,11013597,11013598,7066914,7074938,7074983,10974714,10974715,10974716,10974717,10974718,10961741,10961742,10961743,10961744,10961745,10961757,10961758,10961759,11013812,11013813,11013814,10961853,10961854,7067227,10961928,10961929,10961930,10961931,10987938,10987939,7075292,7067398,7075431,7075432,11014193,11014194,11014195,11014196,11014197,8068600,8068601,10939424,11001418,11001419,7067738,6000226,10972708,10972944,7072281,10931771,10931773,11012182,10986226,10986227,10986228,10986229,7072599,7072600,11012293,10999335,11012370,11012371,10999382,10999383,7072799,10986561,10986562,8065993,11012835,8066558,8066559,8066560,7073626,10961421,10961480,7070893,7070894,7070895,7070896,7070897,8064007,8861114,7071325,10959223,7071696,10998386,10972401,10985413,10972421,10972432,10972433,10969923,10969924,10969925,10969979,10969980,7069319,7069320,7069321,7069322,7069323,7069324,7069325,7069326,7069327,7069328,7069329,7069458,7069459,7069460,7069461,10970176,10996247,10996263,10996264,10996265,10970304,10970305,10970306,10970307,10970308,10941355,10970377,10970378,10970379,10970678,10970679,10970680,10970681,7070099,10970954,10997004,10971034,10997044,10997045,10971079,10971080,10971081,10997186,10997187,7070625,10942417,10971393,10971394,10971395,8860618,10997420,10997421,8860641,8860648,8860649,11006575,10618041,10918607,10918608,10918609,10918610,10618265,10618266,10618267,10618268,10618269,10618270,10618271,10618272,10618273,10618274,10618275,10618276,10918818,10918819,11007159,10919223,10919224,10919225,10618826,10618827,10994551,10994552,10994553,10994554,10994555,10994556,10994557,10919538,10919540,10919541,10919542,10919543,10919544,10919545,10919546,10919547,10968611,8070808,10994650,10994651,10994652,10994653,10994654,10994655,10994656,8070827,10994657,10994658,10994659,8070835,8070849,10994761,10994794,10994812,10968981,10968982,10968983,10968984,10968985,10968986,10968987,10968988,10968989,10968990,10968991,10968992,10968993,10968994,10968995,10968996,10968997,11008178,11005500,11005501,11005502,11005503,11005504,11005505,11005506,11005507,11005508,11005509,11005510,11005511,11005512,11005513,11005514,11005515,11005516,11005517,11005518,11005519,11005520,11005521,11005522,11005523,11005524,11005525,11005526,11005527,11005528,11005529,11005530,11005531,11005532,11005533,11005534,11005535,11005536,11005537,11005538,11005539,11005540,11005541,11005542,11005543,11005544,11005545,11005546,11005547,11005548,11005549,11005550,11005551,11005552,11005553,11005554,11005555,11005556,11005557,11005558,11005559,11005560,11005561,11005562,11005563,11005564,11005565,11005566,11005567,11005568,11005569,10617031,11005570,11005571,11005572,11005573,11005574,11005575,11005576,11005577,11005578,11005579,11005580,11005581,11005582,11005583,11005584,11005585,11005586,11005587,11005588,11005589,11005590,11005591,11005592,11005593,11005594,11005595,11005596,11005597,11005598,11005599,11005600,11005601,11005602,11005603,11005604,11005605,11005606,11005607,11005608,11005609,11005610,11005611,11005612,11005613,11005614,11005615,11005616,11005617,11005618,11005619,11005620,11005621,11005622,11005623,11005624,11005625,11005626,11005627,11005628,11005629,11005630,11005631,11005632,11005633,11005634,11005635,11005636,11005637,11005638,11005639,11005640,11005641,11005642,11005643,11005644,11005645,11005646,11005647,11005648,11005649,11005650,11005651,11005652,11005653,11005654,11005655,11005656,11005657,11005658,11005659,11005677,11005678,10917689,10917696,10917697,10917698,11005739,11005740,10927957,10918007,10617522,10918117,10918136,10918137,10918308,10622813,10622814,11006428,11006429,10622894,10622898,10925504,10964557,11003580,10920556,10920598,10920599,11003654,10920635,11003772,10920749,10920750,10920751,11003821,11003822,10620356,10925879,10620419,11004009,11004010,11004048,11004049,11004050,11004130,11004131,11004132,11004133,11004134,11004135,11004136,11004137,11004138,11004139,10615684,10921209,10921210,10921233,10921234,10615803,10615859,10615866,10615871,10921405,10615906,10615943,10921479,10921480,10921481,10965513,10921547,10921569,10921570,10965601,10965602,10621070,10921596,10930950,10921720,10921721,10921722,10921723,10921724,10952753,10952764,10952765,10921748,10921758,10921759,10921895,10621422,10621423,10922100,10922101,10922102,10979162,10979163,10979164,10979165,10979166,10979167,10979168,10979169,10979170,10979171,10979172,10979173,10979174,10979175,10979176,10979177,10979178,10979179,10979180,10979181,10979182,10979183,10979184,10979185,10979186,10922191,10922194,10922195,10927436,10562342,10562343,10562344,10562345,10562346,10562347,10614260,10611267,10611279,10611294,10614316,10614414,10559623,9173891,8864453,8864454,8864455,8864456,10611775,9166139,9166140,10611991,10611992,10611993,9171350,10612030,10612031,10612032,10612035,10612036,7057701,9171660,10612348,9171699,10557529,10557530,10563537,10563538,10563539,10612489,10609730,10609731,10609732,10609757,7058374,10612873,10612990,10613066,10613100,10610120,7058657,7058677,7058715,7058722,7058723,7058724,9172569,8863145,10613292,10613305,7058823,10610367,10558579,9172912,10613722,10613736,10610833,10610834,8863796,10515129,9169437,10555305,10555306,10555307,10555308,10555309,10555310,10555311,10555312,10555313,10555314,10555315,10555383,10555384,10555385,10513401,9169700,10513574,10513575,9169823,10515679,10513823,10513824,10515832,10513905,10513906,10513946,10513947,10512145,10512146,10512157,9170626,10556673,10556674,10556675,9170886,10516826,10516827,10516828,10516829,9171023,9171024,10518909,10518910,9168304,9168305,9168308,10418252,9168393,9160470,9160471,9160472,10416424,10416425,10416426,10417508,10419596,10419600,7054874,10418676,10418709,10418816,10416962,10420057,10416061,10417091,10417101,10418114,10417115,10417119,10417120,10417183,4971333,4971464,4971506,4971640,6666969,10467562,4972135,4972136,4972137,4972138,4972139,4972140,4972141,4972142,4972143,4972144,4972145,4972146,4972147,4972148,4972149,4972150,4972151,4972152,4972153,4972154,10469913,10469915,10469917,10469922,10469923,10469924,10469943,10469946,10467981,10467982,10468016,10468041,10466252,10470278,10468349,10468355,10468367,10470373,9167799,10470384,6667879,10470474,10470477,10470478,10470489,10470588,10470592,6668119,10462728,10462729,10462730,10462731,10462732,10628086,10628087,10628088,10628089,10628090,10628091,10628092,10628093,10628094,10628095,10628096,10628097,10628098,10628099,10628100,10628101,10628102,10628103,10628104,10164776,10164816,10164817,10164983,10165164,10165165,10165166,10165167,10165679,10165680,10155747,10155748,10155749,10155837,10155838,10155839,10155840,10155841,10629525,10629604,10629752,10629823,10629884,10166412,10632015,10627280,10627293,10163926,10164214,10164215,10164444,10164445,10630226,10162178,10162404,10162405,10163240,10571390,10568598,10568599,10568600,10568601,10568602,10568603,10571761,10577762,10574883,10574884,10574885,10578044,10575107,10566114,10566115,10566116,10566117,10566118,10566119,10566120,10566121,10566122,10575132,10575133,10575134,10572297,10572298,10572299,10575387,10575413,10575535,10575674,10575675,10575752,10575801,10569837,10569838,10570069,10570070,10570078,10570269,10576364,10570436,10573550,10573551,10573552,10573553,10573554,10573555,10573556,10573557,10573558,10573559,10573560,10573561,10573562,10573563,10573564,10573565,10573566,10573567,10573568,10573569,10573570,10573571,10573572,10573573,10573574,10573575,10573576,10573577,10573578,10573579,10573580,10573581,10573582,10573583,10573584,10573585,10573586,10573587,10573588,10573589,10573590,10573591,10573592,10573593,10573594,10573595,10573596,10573597,10573598,10573599,10573600,10573601,10576674,10571043,10571044,10571045,10523140,10521187,10521188,10521189,10525311,10525312,10521330,10521343,10521344,10523364,10523365,10523366,10521673,10521674,10521680,10521716,10523728,10521746,10521850,10521885,10521886,10522081,10522100,10522320,10522321,10522334,10522340,10522375,10522376,10522379,10520790,10520795,10520880,10526919,10526920,10526921,10526922,10526923,10526924,10526925,10526926,10526927,10526928,10526929,10521026,10523049,10523050,10523051,10523060,10523061,10420384,10422549,10423586,10420849,10423923,10423926,10421108,10421109,10423152,10477310,10477948,10474004,10474018,10474026,10474030,10474065,10474068,10474069,10478248,10476458,10478554) 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'