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(4970152,4970153,4970154,4970155,4970156,4970157,4970158,4970159,4970160,4970161,4970162,4970163,4970164,4970165,4970166,4970167,4970168,4970169,4970170,4970171,4970172,4970173,4970174,4970175,4970176,4970177,4970178,4970179,4970180,10939559,4970181,4970182,4970183,4970184,4970185,4970186,4970187,4970188,4970189,4970190,4970191,4970192,10939648,10940179,4970921,4970969,8066895,8066904,8066905,8066906,8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067490,8067491,8067492,8067493,8067494,8067495,8067496,8067497,8067498,8067499,8067500,8067501,8067502,8067503,8067504,8067505,8067506,8067507,8067508,8067509,8067510,8067511,8067512,8067513,8067514,8067515,8067516,8067544,8067615,8067620,8067646,8067662,8067675,8067716,10938513,10938514,10938515,10938516,10938517,10938518,10938519,10938520,10938521,10938522,10938523,10938524,10938525,10938526,10938527,10938528,10938529,10938530,10938531,10938532,10938533,10938534,10938535,10938536,10938537,10938538,10938539,10938540,10938541,10938542,10938543,10938544,4969294,4969295,4969296,4969297,10939217,10939218,10939219,10939220,10939221,10939222,10939223,10939224,10939225,10939226,10939227,10939228,10939229,10939230,10939231,10939232,10939233,10939234,10939235,10939236,10939237,10939238,10939239,4969860,10939240,4969861,10939241,4969862,4969863,10939242,4969864,10939243,4969865,10939244,4969866,10939245,10939246,4969867,4969868,10939247,10939248,4969869,10939249,4969870,10939250,4969871,4969872,10939251,10939252,4969873,4969874,10939253,10939254,4969875,4969876,10939255,10939256,4969877,4969878,10939257,10939258,4969879,10939259,4969880,10939260,4969881,10939261,4969882,4969883,4969884,4969885,4969886,4969887,4969888,4969889,4969890,4969891,4969892,4969893,4969894,4969895,4969896,4969897,4969898,4969899,4969900,4969901,4969902,4969903,4969904,4969905,4969906,4969907,4969908,4969909,4969910,4969911,4969912,4969913,4969914,4969915,4969916,4969917,4969918,4969919,4969920,4969921,4969922,4969923,4969924,4969925,4969926,4969927,4969928,4969929,4969930,4969931,4969932,4969933,4969934,4969935,4969936,4969937,4969938,4969939,4969940,4969941,4969942,4969943,4969944,4969945,4969946,4969947,4969948,4969949,4969950,4969951,4969952,4969953,4969954,4969955,4969956,4969957,4969958,4969959,4969960,4969961,4969962,4969963,4969964,4969965,4969966,4969967,4969968,4969969,4969970,4969971,4969972,4969973,4969974,4969975,4969976,4969977,4969978,4969979,4969980,4969981,4969982,4969983,4969984,4969985,4969986,4969987,4969988,4969989,4969990,4969991,4969992,4969993,4969994,4969995,4969996,4969997,4969998,4969999,4970000,4970001,4970002,4970003,4970004,4970005,4970006,4970007,4970008,4970009,4970010,4970011,4970012,4970013,4970014,4970015,4970016,4970017,4970018,4970019,4970020,4970021,4970022,4970023,4970024,4970025,4970026,4970027,4970028,4970029,4970030,4970031,4970032,4970033,4970034,4970035,4970036,4970037,4970038,4970039,4970040,4970041,4970042,4970043,4970044,4970045,4970046,4970047,4970048,4970049,4970050,4970051,4970052,4970053,4970054,4970055,4970056,4970057,4970058,4970059,4970060,4970061,4970062,4970063,4970064,4970065,4970066,4970067,4970068,4970069,4970070,4970071,4970072,4970073,4970074,4970075,4970076,4970077,4970078,10939458,4970079,10939459,4970080,10939460,4970081,10939461,4970082,4970083,4970084,4970085,4970086,4970087,4970088,4970089,4970090,4970091,4970092,4970093,4970094,4970095,4970096,4970097,4970098,4970099,4970100,4970101,4970102,4970103,4970104,4970105,4970106,4970107,4970108,4970109,4970110,4970111,4970112,4970113,4970114,4970115,4970116,4970117,4970118,4970119,4970120,4970121,4970122,4970123,4970124,4970125,4970126,4970127,4970128,4970129,4970130,4970131,4970132,4970133,4970134,4970135,4970136,4970137,4970138,4970139,4970140,4970141,4970142,4970143,4970144,4970145,4970146,4970147,4970148,4970149,4970150,4970151,8065300,8065301,8065302,8065303,8065304,8065305,8065306,8065307,8065308,8065309,8065310,8065311,8065312,8065313,8065314,8065315,8065316,8065317,8065318,8065319,8065320,8065321,8065322,8065323,8065324,8065325,8065326,8065327,8065328,8065329,8065330,8065331,8065332,8065333,8065334,8065335,8065336,8065337,8065338,8065339,8065340,8065341,8065342,8065343,8065344,8065345,8065346,8065347,8065348,8065349,8065350,8065351,8065352,8065353,8065354,8065355,8065356,8065357,8065358,8065359,8065360,8065361,8065362,8065363,8065364,8065365,8065366,8065367,8065368,8065369,8065370,8065371,8065372,8065373,8065374,8065375,8065376,8065377,8065378,8065379,8065380,8065381,8065382,8065383,8065384,8065385,8065386,8065387,8065388,8065389,8065390,8065391,8065392,8065393,8065394,8065395,8065396,8065397,8065398,8065399,8065400,8065401,8065402,8065403,8065404,8065405,8065406,8065407,8065408,8065409,8065410,8065411,8065412,8065413,8065414,8065415,8065416,8065417,8065418,8065419,8065420,8065421,8065422,8065423,8065424,8065425,8065426,8065427,8065428,8065429,8065430,8065431,8065432,8065433,8065434,8065435,8065436,8065437,8065438,8065439,8065440,8065441,8065442,8065443,8065444,8065445,8065446,8065447,8065448,8065449,8065450,8065451,8065452,8065453,8065454,8065455,8065456,8065457,8065458,8065459,8065460,8065461,8075247,8065462,8065463,8075248,8065464,8065465,8065466,8065467,8065468,8065469,8065470,8065471,8065472,8065473,8065794,8065812,4967167,4967168,4967169,4967170,4967171,4967172,4967173,4967174,4967175,4967176,4967177,4967178,4967179,4967180,4967181,4967182,4967183,4967184,4967185,4967186,4967187,4967188,4967189,4967190,4967191,4967192,4967193,4967194,4967195,4967196,4967197,4967198,4967199,4967200,4967201,4967202,4967203,4967204,4967205,4967206,4967207,4967208,4967209,4967210,4967211,4967212,4967213,4967214,4967215,4967216,4967217,4967218,4967219,4967220,4967221,4967222,4967223,4967224,4967225,4967226,4967227,4967228,4967229,4967230,4967231,4967232,4967233,4967234,4967235,4967236,4967237,4967238,4967239,4967240,4967241,4967242,4967243,4967244,4967245,4967246,4967247,4967248,4967249,4967250,4967251,4967252,4967253,4967254,4967255,4967256,4967257,4967258,4967259,4967260,4967261,4967262,4967263,4967264,4967265,4967266,8066000,4967267,4967268,4967269,4967270,4967271,4967272,4967273,4967274,4967275,4967276,4967277,4967278,4967279,4967280,4967281,4967282,4967283,4967284,4967285,4967286,4967287,4967288,4967289,4967290,4967291,4967292,4967293,4967294,4967295,4967296,4967297,4967298,4967299,4967300,4967301,4967302,4967303,4967304,4967305,4967306,4967307,4967308,4967309,4967310,4967311,4967312,4967313,4967314,4967315,4967316,4967317,4967318,4967319,4967320,4967321,4967322,4967323,4967324,4967325,4967326,4967327,4967328,4967329,4967330,8066181,8066219,8066220,8066221,8066233,8066234,8066235,8066249,8066250,8066251,8066261,8066262,8066271,8066280,8066281,8066282,8066289,8066306,8066307,8066312,8066313,8066314,8066319,8066322,8066347,8066348,8066363,8066364,8066365,8066366,8066381,8066401,8066402,8066431,8066433,8066434,8066435,8066436,8066475,8066476,8066477,8066489,8066502,8066503,8066504,8066505,8066506,8066512,8066513,8066514,8066515,8066516,8066529,8066530,8066531,8066532,8066533,8066534,8066535,8066572,8066601,8066602,8066615,8066617,8066645,8066646,8066647,8066648,8066649,8066673,8066674,8066675,8066736,8066737,8066738,8072873,8072874,8072875,8072876,8072877,8072878,8072879,8072880,10623306,10623337,10623431,10623959,10622406,10622431,10622909,10620106,10620371,10621247,10621248,10621249,10621250,10621258,10621259,10621284,10621288,10621289,10621290,10621295,10621312,10621313,10621324,10621356,10621376,10621377,10621378,10621379,10621390,10621391,10621392,10621393,10621394,10621395,10621406,10621407,10621408,10621409,10621426,10621450,10621469,10621470,10621508,10621531,10621532,10621533,10621568,10621574,10621590,10621591,10621592,10621602,10621621,10621622,10621623,10621624,10621625,10621634,10621661,10621662,10621667,10621674,10621677,10621678,10621679,10621680,10621685,10621699,10621710,10621711,10621728,10621746,10621747,10517112,10517113,10517114,10517115,10517116,10518643,10419467,10419705,10419958,10419959,10419960,10419961,10419962,10419963,10419964,10420065,10471496,10469928,10470009,10470010,10470011,10470112,10470129,10470130,10470325,10470400,10470403,10470518,10470524,10470671) 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'