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(4970157,4970158,4970159,4970161,4970162,4970167,4970168,4970174,4970175,4970177,4970178,4970179,4970180,4970181,4970182,4970183,4970188,4970193,4970194,4970195,4970196,4970197,4970198,4970200,4970204,4970207,4970211,4970212,4970217,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,4970228,4970229,4970283,4970319,4970320,4970322,4970361,4970362,4970363,4970388,4970390,4970392,4970407,4970467,4970468,4970482,4970483,4970484,4970485,4970486,4970494,4970502,4970504,4970505,4970506,4970507,4970528,4970529,4970530,4970533,4970534,4970555,4970561,4970581,4970584,4970624,4970642,4970643,4970644,4970675,4970676,4970684,4970693,4970719,4970720,4970735,4970782,4970783,4970813,4970814,4970815,4970845,4970848,4970863,4970873,4970874,4970888,4970890,4970893,4970895,4970896,4970897,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970910,4970911,4970912,4970914,4970915,4970921,4970922,4970925,4970928,4970940,4970941,4970942,4970943,4970944,4970946,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971010,4971011,4971012,4971035,4971052,4971064,4971065,4971074,4971077,4971081,4971082,4971086,4971087,4971088,4971098,4971104,4971105,4971119,4971125,4971149,4968189,4968212,4968216,4968268,4968304,4968314,4968335,4968353,4968356,4968361,4968362,4968414,4968415,4968417,4968418,4968436,4968460,4968478,4968481,4968483,4968484,4968499,4968501,4968502,4968503,4968505,4968508,4968510,4968512,4968514,4968535,4968562,4968571,4968597,4968598,4968599,4968606,4968633,4968640,4968641,4968650,4968670,4968684,4968685,4968750,4968772,4968779,4968780,4968782,4968792,4968793,4968808,4968815,4968824,4968836,4968839,4968840,4968841,4968850,4968888,4968919,4968923,4968924,4968945,4968946,4968950,4968972,4969004,4969005,4969006,4969028,4969046,4969057,4969060,4969075,4969076,4969077,4969078,4969079,4969080,4969081,4969082,4969083,4969084,4969085,4969086,4969087,4969088,4969089,4969090,4969091,4969092,4969093,4969094,4969095,4969096,4969097,4969098,4969099,4969100,4969101,4969125,4969131,4969158,4969175,4969179,4969185,4969186,4969209,4969211,4969216,4969218,4969219,4969221,4969222,4969223,4969224,4969225,4969240,4969251,4969252,4969254,4969255,4969256,4969257,4969258,4969263,4969264,4969266,4969267,4969269,4969272,4969274,4969275,4969276,4969277,4969280,4969281,4969284,4969285,4969286,4969288,4969290,4969291,4969292,4969293,4969294,4969295,4969296,4969297,4969299,4969303,4969305,4969306,4969310,4969311,4969312,4969319,4969320,4969321,4969322,4969324,4969325,4969326,4969327,4969330,4969331,4969334,4969340,4969341,4969344,4969345,4969346,4969347,4969348,4969354,4969356,4969357,4969358,4969359,4969360,4969361,4969362,4969363,4969367,4969378,4969379,4969382,4969384,4969385,4969387,4969390,4969391,4969394,4969396,4969403,4969404,4969405,4969412,4969418,4969419,4969422,4969423,4969424,4969426,4969427,4969432,4969437,4969438,4969440,4969442,4969444,4969446,4969449,4969451,4969452,4969453,4969454,4969455,4969456,4969457,4969458,4969459,4969460,4969461,4969462,4969463,4969464,4969465,4969466,4969467,4969468,4969469,4969470,4969472,4969474,4969475,4969477,4969478,4969479,4969482,4969484,4969487,4969489,4969490,4969491,4969493,4969497,4969498,4969499,4969501,4969502,4969503,4969509,4969512,4969518,4969519,4969520,4969522,4969523,4969524,4969526,4969531,4969535,4969536,4969539,4969540,4969543,4969544,4969551,4969552,4969553,4969557,4969562,4969581,4969591,4969592,4969629,4969632,4969633,4969635,4969637,4969638,4969640,4969642,4969643,4969644,4969645,4969646,4969648,4969650,4969654,4969655,4969656,4969657,4969658,4969659,4969660,4969661,4969662,4969665,4969666,4969668,4969673,4969674,4969675,4969676,4969679,4969681,4969682,4969683,4969685,4969686,4969687,4969690,4969691,4969692,4969702,4969703,4969706,4969708,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969720,4969721,4969722,4969723,4969724,4969725,4969726,4969727,4969730,4969731,4969732,4969733,4969734,4969736,4969737,4969739,4969741,4969742,4969743,4969744,4969745,4969746,4969747,4969753,4969754,4969755,4969757,4969758,4969759,4969760,4969761,4969766,4969767,4969769,4969770,4969772,4969773,4969776,4969777,4969779,4969780,4969784,4969785,4969790,4969792,4969794,4969795,4969796,4969797,4969800,4969803,4969804,4969806,4969807,4969808,4969809,4969810,4969811,4969812,4969813,4969814,4969816,4969818,4969819,4969820,4969822,4969824,4969825,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969838,4969839,4969840,4969845,4969846,4969847,4969848,4969849,4969850,4969851,4969852,4969853,4969857,4969861,4969862,4969863,4969868,4969874,4969878,4969879,4969881,4969886,4969888,4969889,4969894,4969895,4969897,4969898,4969902,4969907,4969910,4969915,4969918,4969922,4969923,4969924,4969925,4969926,4969928,4969932,4969934,4969935,4969936,4969940,4969945,4969951,4969953,4969954,4969955,4969957,4969958,4969965,4969966,4969967,4969968,4969970,4969981,4969985,4969990,4969992,4969994,4969995,4969996,4969997,4969999,4970002,4970003,4970007,4970008,4970009,4970011,4970015,4970023,4970026,4970027,4970029,4970030,4970032,4970034,4970035,4970036,4970038,4970039,4970041,4970044,4970045,4970047,4970052,4970059,4970062,4970066,4970068,4970069,4970070,4970080,4970083,4970085,4970086,4970089,4970091,4970094,4970099,4970102,4970108,4970112,4970113,4970121,4970122,4970124,4970125,4970127,4970130,4970131,4970132,4970133,4970134,4970135,4970136,4970138,4970142,4970144,4970145,4970146,4970147,4970148,4970149,4970151,8074897,8074898,8074899,8074900,8074901,8074940,8074941,8074942,8074943,8074944,8074945,8075218,8075219,4967050,4967051,4967077,4967080,4967136,4967149,4967154,4967155,4967157,4967160,4967161,4967163,4967167,4967169,4967170,4967172,4967173,4967175,4967176,4967177,4967179,4967181,4967182,4967183,4967184,4967185,4967187,4967188,4967192,4967199,4967200,4967201,4967202,4967203,4967204,4967206,4967207,4967210,4967212,4967213,4967214,4967216,4967218,4967222,4967223,4967224,4967228,4967230,4967231,4967232,4967234,4967237,4967239,4967240,4967241,4967242,4967245,4967246,4967247,4967249,4967250,4967251,4967252,4967255,4967256,4967258,4967260,4967262,4967264,4967267,4967268,4967270,4967272,4967275,4967278,4967279,4967283,4967284,4967286,4967287,4967290,4967291,4967292,4967296,4967298,4967303,4967305,4967306,4967307,4967308,4967310,4967312,4967317,4967319,4967320,4967321,4967323,4967325,4967326,4967327,4967328,4967332,4967333,4967334,4967337,4967338,4967345,4967351,4967352,4967353,4967354,4967355,4967356,4967357,4967359,4967360,4967361,4967362,4967363,4967365,4967366,4967367,4967368,4967369,4967370,4967374,4967377,4967380,4967381,4967383,4967387,4967388,4967390,4967391,4967395,4967397,4967398,4967402,4967403,4967404,4967407,4967408,4967411,4967413,4967416,4967417,4967418,4967419,4967423,4967430,4967432,4967435,4967446,4967447,4967474,4967476,4967477,4967479,4967582,4967584,4967586,4967603,4967604,4967606,4967616,4967631,4967632,4967668,4967669,4967670,4967681,4967682,4967683,4967696,4967697,4967698,4967699,4967728,4967729,4967748,4967749,4967751,4967763,4967772,4967774,4967775,4967780,4967781,4967852,4967862,4967901,4967954,4967955,4967956,4967957,4968038,4968069,4968070,4968125,4968128,4968130,8074253,8074254,8074255,8074256,8074257,8074258,8074301,8074302,8074303,8074304,8074305,8074306,8074353,8074354,8074355,8074356,8074357,8074358,8074359,8074403,8074404,8074405,8074406,8074407,8074408,8074409,8074410,8074450,8074451,8074452,8074453,8074454,8074494,8074495,8074496,8074497,8074498,8071670,8071671,8071672,8071673,8071674,8071675,8071676,8071677,8071678,8071679,8071680,8071681,8071682,8071683,8071684,8071685,8071686,8071687,8071688,8071689,8071690,8071691,8071692,8071693,8071694,8071695,8071696,8071697,8071698,8071699,8071700,8071701,8071702,8071703,8071704,8071705,8071706,8071707) 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'