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,4970232,4970233,4970234,4970235,4970236,4970237,4970238,4970239,4970240,4970241,4970242,4970243,4970244,4970245,4970246,4970247,4970248,4970249,4970250,4970251,4970252,4970253,4970254,4970265,4970266,4970267,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970314,4970315,4970316,4970317,4970318,4970323,4970324,4970331,4970332,4970335,4970336,4970337,4970338,4970357,4970361,4970362,4970363,4970366,4970367,4970368,4970369,4970383,4970384,4970385,4970386,4970405,4970406,4970407,4970408,4970429,4970430,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970450,4970508,4970509,4970510,4970511,4970512,4970513,4970612,4970613,4970614,4970615,4970616,4970617,4970618,4970619,4970620,4970621,4970622,4970623,4970624,4970625,4970626,4970646,4970647,4970648,4970649,4970666,4970667,4970668,4970669,4970684,4970687,4970688,4970702,4970711,4970713,4970716,4970724,4970725,4970726,4970727,4970728,4970729,4970732,4970733,4970734,4970739,4970745,4970758,4970759,4970783,4970798,4970807,4970808,4970809,4970811,4970812,4970853,4970854,4970855,4970856,4970857,4970859,4970860,4970861,4970875,4970876,4970877,4970885,4970886,4970887,4970888,4970889,4970900,4970908,4970909,4970910,4970912,4970914,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970940,4970948,4970951,4970954,4970959,4970960,4970961,4970964,4970966,4970968,4970973,4970974,4970975,4970989,4970993,4971019,4971020,4971021,4971030,4971031,4971032,4971033,4971043,4971044,4971045,4971057,4971060,4971061,4971062,4971128,4971143,4971151,4968169,4968170,4968171,4968316,4968317,4968323,4968333,4968334,4968410,4968411,4968412,4968413,4968414,4968415,4968416,4968417,4968418,4968419,4968420,4968421,4968422,4968423,4968424,4968425,4968426,4968427,4968607,4968608,4968609,4968610,4968611,4968612,4968613,4968614,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968630,4968632,4968636,4968637,4968647,4968664,4968665,4968666,4968667,4968678,4968679,4968680,4968691,4968692,4968693,4968694,4968695,4968696,4968697,4968702,4968703,4968789,4968790,4968846,4968847,4968848,4968859,4968861,4968862,4969102,4969132,4969133,4969162,4969247,4969248,4969260,4969270,4969282,4969283,4969284,4969320,4969321,4969397,4969398,4969399,4969400,4969401,4969402,4969403,4969404,4969405,4969406,4969407,4969408,4969409,4969410,4969411,4969412,4969413,4969414,4969421,4969422,4969423,4969424,4969425,4969443,4969444,4969445,4969447,4969448,4969554,4969555,4969556,4969557,4969558,4969559,4969560,4969561,4969571,4969572,4969573,4969586,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,4969602,4969603,4969604,4969605,4969637,4969638,4969642,4969643,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969912,4969913,4970034,4970035,4970036,4970037,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8075218,8075219,8075220,8075221,8075222,8075225,8075232,8075237,8075238,8075239,8075261,8075262,8075288,8075316,8075317,8075318,8075319,8075321,8075485,8075490,8075539,8075542,4967032,4967035,4967042,4967043,4967044,4967046,4967047,4967068,4967091,4967092,4967093,4967096,4967103,4967109,4967110,4967111,4967122,4967129,4967139,4967144,4967145,4967146,4967162,4967163,4967183,4967184,4967185,4967186,4967187,4967192,4967193,4967212,4967213,4967229,4967249,4967255,4967256,4967257,4967258,4967259,4967302,4967303,4967304,4967320,4967331,4967332,4967333,4967334,4967335,4967336,4967337,4967338,4967339,4967340,4967341,4967342,4967343,4967344,4967345,4967346,4967347,4967348,4967349,4967350,4967351,4967352,4967353,4967354,4967355,4967356,4967357,4967358,4967359,4967360,4967361,4967362,4967363,4967364,4967365,4967366,4967367,4967368,4967369,4967370,4967371,4967372,4967373,4967374,4967375,4967376,4967377,4967378,4967379,4967380,4967381,4967382,4967383,4967384,4967385,4967386,4967387,4967388,4967389,4967390,4967391,4967392,4967393,4967394,4967395,4967396,4967397,4967398,4967399,4967400,4967401,4967402,4967403,4967404,4967405,4967406,4967407,4967408,4967409,4967410,4967411,4967412,4967413,4967414,4967415,4967416,4967417,4967418,4967419,4967420,4967421,4967422,4967423,4967427,4967428,4967429,4967430,4967437,4967438,4967439,4967440,4967441,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967451,4967452,4967453,4967454,4967455,4967456,4967457,4967458,4967459,4967460,4967461,4967462,4967463,4967464,4967465,4967466,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967474,4967475,4967476,4967477,4967478,4967479,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967497,4967498,4967499,4967500,4967501,4967502,4967503,4967504,4967505,4967506,4967507,4967508,4967509,4967510,4967511,4967512,4967513,4967514,4967515,4967523,4967546,4967547,4967548,4967557,4967558,4967559,4967560,4967574,4967588,4967589,4967610,4967611,4967612,4967613,4967614,4967634,4967635,4967636,4967637,4967638,4967639,4967674,4967675,4967676,4967685,4967706,4967707,4967708,4967717,4967719,4967721,4967751,4967754,4967755,4967756,4967757,4967758,4967759,4967760,4967761,4967762,4967763,4967764,4967765,4967766,4967767,4967768,4967769,4967774,4967775,4967776,4967777,4967778,4967779,4967780,4967781,4967782,4967783,4967784,4967785,4967786,4967787,4967788,4967789,4967790,4967791,4967792,4967793,4967794,4967795,4967796,4967797,4967798,4967799,4967800,4967801,4967802,4967803,4967804,4967805,4967806,4967807,4967808,4967809,4967810,4967811,4967812,4967813,4967814,4967815,4967816,4967817,4967818,4967826,4967829,4967841,4967844,4967854,4967855,4967869,4967870,4967871,4967872,4967883,4967884,4967906,4967907,4967908,4967909,4967910,4967911,4967912,4967913,4967914,4967915,4967916,4967917,4967918,4967919,4967920,4967921,4967922,4967923,4967924,4967925,4967926,4967927,4967928,4967929,4967930,4967937,4967938,4967939,4967940,4967947,4967980,4967982,4967985,4967992,4967993,4967994,4967995,4968008,4968014,4968021,4968022,4968023,4968024,4968025,4968026,4968039,4968040,4968041,4968042,8073681,8073682,8073683,8073684,8073685,8073735,8073736,8073737,8073738,8073739,8073787,8073788,8073789,8073790,8073791,8073836,8073837,8073838,8073839,8073840,8073855,8073856,8073857,8073858,8073859,8073860,8073861,8073862,8073863,8073864,8073865,8073866,8073867,8073868,8073869,8073870,8073871,8073872,8073873,8073874,8073875,8073876,8073877,8073878,8073879,8073880,8073881,8073882,8073883,8073884,8073885,8073886,8073887,8073888,8073889,8073890,8073891,8073892,8073893,8073894,8073895,8073896,8073897,8073898,8073899,8073900,8073901,8073902,8073903,8073904,8073905,8073906,8073907,8073908,8073909,8073910,8073911,8073912,8073913,8073914,8073915,8073916,8073917,8073918,8073919,8073920,8073921,8073922,8073923,8073924,8073925,8073926,8073927,8073928,8073929,8073930,8073931,8073932,8073933,8073934,8073935,8073936,8073937,8073938,8073939,8073940,8073941,8073942,8073943,8073944,8073945,8073946,8073974,8073975,8073976,8073977,8073978,8074020,8074021,8074022,8074023,8074024,8074212,8074213,8074214,8074215,8074216,8074217,8074218,8074219,8074220,8074221,8074222,8074223,8074224,8074225,8074226,8074227,8074228,8074229,8074230,8074231,8074232,8074233,8074234,8074235,8074236,8074237,8074238,8074239,8074240,8074241,8074242,8074243,8074244,8074245,8074246,8074247,8074248,8074249,8074250,8074251,8074252,8074253,8074254,8074255,8074256,8074257,8074258,8074259,8074260,8074261,8074262,8074263,8074264,8074265,8074266,8074267,8074268,8074269,8074270,8074271,8074272,8074273,8074274,8074275,8074276,8074277,8074278,8074279,8074280,8074281,8074282,8074283,8074284,8074285,8074286,8074287,8074288,8074289,8074290,8074291,8074292,8074293,8074294,8074295,8074296,8074297,8074298,8074299,8074300,8074301,8074302,8074303,8074304,8074305,8074306,8074499,8074500,8074501,8074502,8074503,8074504,8074505,8074506,8074507,8074508,8074509,8074510,8074511,8074512,8074513) 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'