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(4970273,4970274,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970314,4970315,4970316,4970317,4970318,4970321,4970323,4970324,4970325,4970331,4970332,4970335,4970336,4970337,4970338,4970340,4970350,4970357,4970361,4970362,4970363,4970366,4970367,4970368,4970369,4970373,4970381,4970383,4970384,4970385,4970386,4970391,4970398,4970399,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970639,4970640,4970641,4970652,4970653,4970654,4970655,4970656,4970657,4970658,4970677,4970682,4970699,4970702,4970729,4970741,4970742,4970755,4970759,4970771,4970775,4970785,4970797,4970878,4970892,4970953,4970995,4971007,4971008,4971022,4971023,4971046,4971047,4971048,4971059,4971073,4971074,4971075,4971076,4971096,4971103,4971138,4971139,4971140,4971141,4971142,4971146,4968152,4968157,4968160,4968162,4968165,4968166,4968167,4968179,4968193,4968194,4968218,4968248,4968249,4968250,4968251,4968252,4968253,4968340,4968360,4968363,4968412,4968701,4968702,4968703,4968704,4968705,4968706,4968707,4968708,4968709,4968710,4968711,4968712,4968713,4968714,4968715,4968785,4968812,4968813,4968844,4968925,4968985,4968986,4968987,4968988,4969177,4969185,4969186,4969187,4969188,4969285,4969286,4969287,4969288,4969305,4969307,4969309,4969317,4969324,4969325,4969327,4969328,4969329,4969335,4969336,4969343,4969625,4969626,4969627,4969644,4969645,4969646,4969647,4969704,4969705,4969706,4969707,4969708,4969709,4969970,4969971,4969972,4969973,4969974,4969975,4969976,4969977,4969978,4970043,4970044,4970045,4970046,4970047,4970048,4970049,8074684,8074685,8074686,8074687,8074688,8074689,8074690,8074691,8074692,8074693,8074694,8074695,8074696,8074697,8074698,8074699,8074700,8074701,8074702,8074703,8074704,8074705,8074727,8074728,8074729,8074730,8074731,8074732,8074733,8074734,8074735,8074736,8074737,8074738,8074739,8074740,8074741,8074742,8074743,8074744,8074745,8074746,8074747,8074946,8074947,8074948,8074949,8074950,8074951,8074952,8074953,8074954,8074955,8074956,8074957,8074958,8074959,8074960,8074961,8074962,8074963,8074964,8074965,8074966,8074967,8074968,8074969,8074970,8074971,8074972,8074973,8074974,8074975,8074976,8074977,8074978,8074979,8074980,8074981,8074982,8074983,8074984,8074985,8074986,8074987,8074988,8074989,8074990,8074991,8074992,8074993,8074994,8074995,8074996,8074997,8074998,8074999,8075000,8075001,8075002,8075003,8075004,8075005,8075006,8075007,8075008,8075009,8075010,8075011,8075012,8075013,8075014,8075015,8075016,8075017,8075018,8075019,8075020,8075021,8075022,8075023,8075024,8075025,8075026,8075027,8075028,8075029,8075030,8075031,8075032,8075033,8075235,8075236,8075237,8075238,8075239,8075240,8075241,8075242,8075243,8075264,8075265,8075289,8075337,8075338,8075342,8075343,8075344,8075345,8075346,8075347,8075348,8075349,8075350,8075351,8075352,8075353,8075354,8075355,8075356,8075357,8075358,8075359,8075360,8075361,8075362,8075363,8075364,8075365,8075366,8075367,8075368,8075369,8075488,8075491,8075492,8075493,8075533,8075538,4967028,4967033,4967036,4967037,4967038,4967039,4967040,4967041,4967104,4967430,4967431,4967435,4967436,4967516,4967517,4967518,4967519,4967522,4967523,4967529,4967530,4967531,4967533,4967644,4967645,4967840,4967841,4967842,4967843,4967844,4967845,4967846,4967847,4967848,4967849,4967850,4967851,4967852,4967853,4967854,4967855,4967856,4967857,4967858,4967859,4967860,4967861,4967996,4968136,4968137,4968138,4968139,4968140,4968141,4968142,4968143,4968144,4968145,4968146,4968147,4968148,4968149,8072163,8072164,8072165,8072166,8072167,8072168,8072169,8072170,8072171,8072172,8072173,8072174,8072175,8072176,8072177,8072178,8072179,8072180,8072181,8072182,8072183,8072184,8072185,8072186,8072187,8072188,8072189,8072190,8072191,8072192,8072193,8072194,8072195,8072196,8072197,8072198,8072199,8072200,8072201,8072202,8072203,8072204,8072205,8072206,8072207,8072208,8072209,8072210,8072211,8072212,8072213,8072214,8072215,8072216,8072217,8072218,8072219,8072220,8072221,8072222,8072223,8072224,8072225,8072226,8072227,8072318,8072319,8072320,8072321,8072322,8072360,8072366,8072388,8072394,8072409,8072419,8072440,8072441,8072452,8072467,8072468,8072567,8072568,8072569,8072570,8072571,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072693,8072694,8072695,8072696,8072697,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072748,8072749,8072750,8072751,8072752,8072768,8072769,8072770,8072771,8072772,8072773,8072774,8072775,8072776,8072777,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072928,8072932,8072933,8072997,8073039,8073040,8073041,8073042,8073043,8073052,8073053,8073059,8073448,8073491,8073505,8073506,8073507,8073508,8073509,8073510,8073511,8073517,8073518,8073519,8073520,8073533,8073537,8073542,8073543,10622962,10622965,10622993,10622994,10622995,10623016,10623017,10623018,10623019,10623020,10623021,10623037,10623040,10623041,10623043,10623096,10623099,10623102,10623103,10623113,10623114,10623115,10623245,10623257,10623299,10623308,10623318,10623368,10623412,10623459,10623479,10623491,10623492,10623493,10623503,10623612,10623654,10623700,10623715,10623716,10623717,10623729,10623735,10623770,10623790,10623791,10623792,10623793,10623794,10623795,10623796,10623797,10623798,10623799,10623800,10623802,10623803,10623804,10623806,10623859,10623874,10623880,10623887,10623888,10623889,10623890,10623891,10623892,10623893,10623894,10623895,10623896,10623897,10623898,10623899,10623900,10623901,10623902,10623903,10623904,10623905,10623906,10623907,10623919,10623926,10623927,10624091,10624092,10624093,10624094,10624095,10624096,10624097,10624098,10624099,10624100,10624101,10624102,10624103,10624119,10624121,10624135,10624136,10624137,10624138,10624139,10624140,10624141,10624142,10624143,10624144,10624145,10624146,10624147,10624148,10624149,10624150,10624151,10624152,10624153,10624154,10624155,10624156,10624157,10624169,10624170,10624171,10624172,10624173,10624174,10624175,10624193,10624260,10624266,10624267,10624268,10624325,10624404,10624405,10624406,10624407,10624408,10624409,10624410,10624427,10624507,10624558,10624559,10624566,10624585,10624587,10624588,10624589,10624590,10624591,10624592,10624593,10624594,10624595,10624596,10624597,10624598,10624599,10624600,10624601,10624823,10624874,10624883,10624884,10624906,10624959,10621966,10621975,10621977,10621978,10621979,10621980,10621983,10621985,10621987,10621988,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622014,10622037,10622038,10622039,10622040,10622041,10622042,10622048,10622049,10622050,10622051,10622052,10622054,10622055,10622060,10622070,10622071,10622084,10622085,10622091,10622092,10622093,10622094,10622097,10622098,10622100,10622106,10622107,10622108,10622109,10622110,10622122,10622123,10622124,10622125,10622126,10622131,10622133,10622134,10622148,10622149,10622173,10622174,10622175,10622176,10622177,10622178,10622180,10622181,10622182,10622183,10622184,10622185,10622196,10622265,10622267,10622280,10622281,10622318,10622324,10622332,10622333,10622360,10622361,10622362,10622363,10622364,10622365,10622366,10622367,10622368,10622409,10622427,10622429,10622443,10622444,10622451,10622465,10622469,10622471,10622472,10622473,10622477,10622479,10622485,10622486,10622487,10622503,10622512,10622515,10622520,10622525,10622526,10622532,10622534,10622538,10622539,10622571,10622868,10622869,10622870,10622889,10622890,10622898,10622916,10622920,10622961,10619965,10619980,10620006,10620007,10620008,10620009,10620020,10620021,10620022,10620023,10620024,10620025,10620026,10620027,10620028,10620029,10620030,10620031,10620032,10620033,10620055,10620072,10620073,10620080,10620096,10620097,10620145,10620146,10620147,10620181,10620182,10620183,10620219,10620237,10620257,10620261,10620267,10620269,10620303,10620314,10620315,10620316,10620343,10620344,10620355,10620356,10620359,10620364,10620365,10620366,10620367,10620368,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620385,10620391,10620395,10620396,10620404,10620407,10620411,10620412,10620413) 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'