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(4970230,4970231,4970234,4970235,4970236,4970237,4970238,4970239,4970240,4970241,4970242,4970243,4970244,4970307,4970308,4970309,4970310,4970323,4970400,4970401,4970402,4970607,4970608,4970645,4970647,4970649,4970652,4970653,4970655,4970656,4970658,4970666,4970667,4970668,4970669,4970677,4970679,4970680,4970684,4970690,4970691,4970699,4970701,4970708,4970709,4970721,4970738,4970742,4970750,4970757,4970758,4970767,4970771,4970775,4970784,4970805,4970806,4970830,4970831,4970832,4970833,4970834,4970853,4970854,4970855,4970856,4970857,4970858,4970859,4970860,4970861,4970862,4970863,4970864,4970865,4970866,4970867,4970868,4970869,4970870,4970871,4970872,4970873,4970874,4970875,4970876,4970877,4970878,4970879,4970880,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970891,4970892,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970938,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970972,4970973,4970974,4970975,4970976,4970977,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971020,4971022,4971023,4971026,4971027,4971028,4971029,4971030,4971031,4971032,4971033,4971037,4971050,4971053,4971054,4971055,4971060,4971068,4971072,4971128,4971137,4971138,4971139,4971140,4971141,4971142,4971143,4971146,4971150,4968177,4968178,4968193,4968194,4968248,4968249,4968275,4968276,4968277,4968278,4968279,4968280,4968281,4968282,4968283,4968284,4968285,4968286,4968287,4968288,4968289,4968290,4968291,4968292,4968293,4968294,4968295,4968296,4968306,4968307,4968308,4968309,4968315,4968316,4968317,4968318,4968319,4968320,4968321,4968322,4968323,4968324,4968325,4968326,4968327,4968328,4968329,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968340,4968410,4968411,4968412,4968413,4968595,4968596,4968607,4968608,4968609,4968610,4968611,4968612,4968615,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968630,4968632,4968633,4968644,4968647,4968654,4968661,4968662,4968663,4968664,4968665,4968666,4968667,4968676,4968677,4968678,4968680,4968698,4968744,4968771,4968772,4968773,4968774,4968789,4968790,4968846,4968847,4968848,4968849,4968850,4968851,4968852,4968853,4968854,4968855,4968856,4968857,4968858,4969184,4969246,4969247,4969248,4969252,4969253,4969254,4969255,4969256,4969282,4969283,4969284,4969285,4969286,4969287,4969288,4969296,4969300,4969301,4969302,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,4969382,4969383,4969384,4969385,4969386,4969402,4969407,4969410,4969439,4969440,4969505,4969506,4969507,4969508,4969589,4969590,4969592,4969593,4969597,4969599,4969602,4969606,4969607,4969608,4969665,4969666,4969667,4969673,4969674,4969675,4969676,4969677,4969678,4969802,4969803,4969804,4969805,4969806,4969807,4969830,4969831,4969832,4969833,4969834,4969835,4969966,4969967,4970013,4970014,4970015,4970016,4970017,4970018,4970019,4970020,4970021,4970137,4970138,4970139,4970140,8074684,8074685,8074686,8074687,8074688,8074727,8074728,8074729,8074730,8074731,8074772,8074773,8074774,8074775,8074776,8074814,8074815,8074816,8074817,8074818,8074856,8074857,8074858,8074859,8074860,8074902,8074903,8074904,8074905,8074906,8074946,8074947,8074948,8074949,8074950,8074990,8074991,8074992,8074993,8074994,8075034,8075035,8075036,8075037,8075038,8075039,8075080,8075081,8075082,8075083,8075084,8075085,8075128,8075129,8075130,8075131,8075132,8075171,8075172,8075173,8075174,8075175,8075214,8075215,8075216,8075217,8075226,8075229,8075230,8075266,8075272,8075287,8075289,8075307,8075308,8075309,8075310,8075311,8075312,8075489,4967027,4967030,4967031,4967032,4967034,4967035,4967036,4967037,4967038,4967039,4967040,4967041,4967042,4967043,4967044,4967045,4967046,4967047,4967048,4967049,4967050,4967051,4967052,4967053,4967054,4967055,4967056,4967057,4967058,4967059,4967060,4967063,4967064,4967065,4967066,4967067,4967068,4967069,4967070,4967071,4967072,4967073,4967074,4967075,4967076,4967077,4967078,4967079,4967080,4967081,4967082,4967083,4967084,4967085,4967086,4967087,4967088,4967089,4967090,4967091,4967092,4967093,4967094,4967095,4967096,4967097,4967098,4967099,4967100,4967101,4967102,4967103,4967104,4967105,4967106,4967107,4967108,4967109,4967110,4967111,4967112,4967113,4967114,4967115,4967116,4967117,4967118,4967119,4967120,4967121,4967122,4967123,4967124,4967125,4967126,4967127,4967128,4967129,4967130,4967131,4967132,4967133,4967134,4967135,4967136,4967137,4967138,4967139,4967140,4967141,4967142,4967143,4967144,4967145,4967146,4967147,4967150,4967151,4967152,4967155,4967156,4967157,4967158,4967161,4967164,4967165,4967167,4967168,4967169,4967174,4967175,4967176,4967177,4967178,4967186,4967187,4967189,4967200,4967202,4967205,4967214,4967215,4967216,4967217,4967218,4967219,4967220,4967221,4967222,4967223,4967224,4967226,4967228,4967235,4967236,4967237,4967238,4967239,4967240,4967241,4967242,4967243,4967244,4967245,4967246,4967247,4967254,4967257,4967258,4967265,4967266,4967267,4967268,4967269,4967273,4967274,4967276,4967277,4967278,4967279,4967280,4967281,4967282,4967296,4967297,4967300,4967304,4967305,4967308,4967309,4967310,4967311,4967312,4967313,4967314,4967315,4967316,4967324,4967332,4967341,4967347,4967348,4967355,4967356,4967357,4967369,4967370,4967371,4967372,4967373,4967374,4967376,4967377,4967378,4967379,4967380,4967381,4967382,4967383,4967384,4967385,4967386,4967387,4967393,4967399,4967401,4967402,4967403,4967404,4967405,4967406,4967407,4967409,4967413,4967414,4967415,4967416,4967425,4967426,4967427,4967430,4967431,4967434,4967435,4967436,4967437,4967438,4967439,4967441,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967452,4967454,4967455,4967456,4967457,4967460,4967461,4967462,4967463,4967464,4967465,4967466,4967468,4967473,4967480,4967491,4967499,4967503,4967507,4967510,4967511,4967514,4967515,4967516,4967517,4967518,4967519,4967521,4967522,4967523,4967525,4967529,4967530,4967531,4967533,4967535,4967536,4967537,4967538,4967539,4967540,4967541,4967542,4967543,4967544,4967545,4967547,4967549,4967550,4967551,4967552,4967553,4967556,4967559,4967560,4967562,4967566,4967567,4967568,4967569,4967570,4967577,4967578,4967585,4967595,4967598,4967600,4967601,4967602,4967609,4967612,4967618,4967619,4967620,4967621,4967622,4967623,4967624,4967625,4967626,4967627,4967628,4967629,4967630,4967631,4967632,4967633,4967634,4967635,4967636,4967637,4967638,4967639,4967640,4967641,4967642,4967643,4967644,4967645,4967646,4967647,4967648,4967649,4967650,4967653,4967659,4967660,4967661,4967662,4967663,4967664,4967665,4967672,4967673,4967675,4967679,4967685,4967686,4967687,4967688,4967689,4967690,4967691,4967692,4967693,4967694,4967695,4967703,4967704,4967705,4967709,4967710,4967711,4967712,4967713,4967714,4967720,4967726,4967727,4967728,4967734,4967737,4967739,4967740,4967741,4967743,4967744,4967745,4967746,4967747,4967752,4967753,4967754,4967756,4967757,4967758,4967759,4967760,4967761,4967767,4967768,4967769,4967770,4967783,4967786,4967788,4967792,4967794,4967795,4967796,4967797,4967799,4967800,4967802,4967803,4967805,4967806,4967808,4967809,4967810,4967818,4967819,4967820,4967821,4967822,4967823,4967824,4967825,4967826,4967827,4967828,4967829,4967830,4967831,4967832,4967833,4967834,4967835,4967836,4967837,4967838,4967839,4967840,4967841,4967842,4967843,4967844,4967849,4967850,4967851,4967856,4967857,4967859,4967860,4967863,4967865,4967866,4967867,4967868,4967869,4967872,4967873) 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'