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,4970198,4970199,4970200,4970201,4970202,4970260,4970261,4970361,4970362,4970363,4970450,4970579,4970580,4970610,4970611,4970668,4970669,4970672,4970675,4970682,4970684,4970691,4970701,4970708,4970709,4970710,4970714,4970724,4970725,4970738,4970744,4970748,4970761,4970766,4970767,4970798,4970799,4970800,4970801,4970802,4970803,4970825,4970846,4970847,4970849,4970850,4970851,4970853,4970858,4970863,4970873,4970874,4970879,4970888,4970890,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970921,4970922,4970925,4970928,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,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970992,4970993,4970994,4970995,4971001,4971002,4971003,4971004,4971005,4971022,4971023,4971024,4971025,4971026,4971027,4971028,4971030,4971031,4971032,4971033,4971035,4971042,4971051,4971053,4971054,4971058,4971070,4971071,4971072,4971074,4971098,4971099,4971110,4971111,4971125,4971144,4971145,4971146,4971147,4971148,4971149,4971150,4971151,4968211,4968212,4968304,4968305,4968320,4968334,4968361,4968362,4968363,4968364,4968365,4968411,4968414,4968415,4968416,4968417,4968418,4968419,4968420,4968421,4968422,4968551,4968552,4968597,4968598,4968599,4968600,4968608,4968616,4968619,4968620,4968621,4968626,4968627,4968650,4968655,4968656,4968657,4968658,4968659,4968660,4968676,4968681,4968682,4968683,4968684,4968685,4968686,4968687,4968688,4968689,4968690,4968691,4968723,4968779,4968780,4968781,4968782,4968783,4968841,4968842,4968898,4968899,4968900,4968901,4968902,4968903,4968904,4968905,4968906,4968907,4968908,4968909,4968910,4968911,4968912,4968913,4968914,4968915,4968916,4968917,4968918,4968919,4968920,4968921,4968922,4968923,4968924,4968925,4969090,4969091,4969092,4969093,4969130,4969131,4969156,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969184,4969185,4969186,4969187,4969188,4969259,4969282,4969283,4969284,4969285,4969286,4969287,4969288,4969294,4969295,4969296,4969300,4969301,4969302,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,4969312,4969313,4969314,4969315,4969316,4969321,4969324,4969325,4969362,4969363,4969371,4969372,4969373,4969374,4969375,4969376,4969377,4969378,4969379,4969380,4969381,4969382,4969383,4969384,4969385,4969386,4969387,4969388,4969389,4969390,4969391,4969392,4969393,4969394,4969395,4969396,4969421,4969422,4969423,4969424,4969425,4969426,4969427,4969428,4969429,4969430,4969431,4969432,4969433,4969449,4969450,4969547,4969591,4969592,4969614,4969700,4969701,4969702,4969703,4969874,4969875,4969876,4969877,4969878,4969879,4969880,4969881,4969882,4969883,4969884,4969885,4969906,4969907,4969908,4969909,4969910,4969911,4969912,4969913,4969914,4969915,4969916,4969917,4969947,4969948,4969949,4969966,4969967,4969968,4969969,4969970,4969971,4969972,4969973,4969974,4969975,4969976,4969977,4969978,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,4970055,4970056,4970057,4970058,4970059,4970060,4970061,4970062,4970063,4970064,4970065,4970091,4970092,4970093,4970094,4970095,4970099,4970100,4970101,4970102,4970112,4970113,4970114,4970115,4970116,4970117,4970118,4970119,4970137,4970138,4970139,4970140,4970141,4970142,4970143,4970145,4970146,4970147,4970148,4970149,4970150,4970151,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8074694,8074695,8074696,8074697,8074698,8074737,8074738,8074739,8074740,8074741,8074782,8074783,8074784,8074785,8074786,8074824,8074825,8074826,8074827,8074828,8074856,8074857,8074858,8074859,8074860,8074861,8074862,8074863,8074864,8074865,8074866,8074867,8074868,8074869,8074870,8074871,8074872,8074873,8074874,8074875,8074876,8074902,8074903,8074904,8074905,8074906,8074907,8074908,8074909,8074910,8074911,8074912,8074913,8074914,8074915,8074916,8074917,8074918,8074919,8074920,8074921,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,8075046,8075047,8075048,8075049,8075050,8075092,8075093,8075094,8075095,8075096,8075097,8075138,8075139,8075140,8075141,8075142,8075181,8075182,8075183,8075184,8075185,8075218,8075219,8075227,8075228,8075229,8075230,8075231,8075235,8075236,8075258,8075288,8075312,8075344,8075345,8075358,8075364,8075365,8075521,8075522,8075533,4967027,4967028,4967030,4967031,4967034,4967048,4967049,4967050,4967051,4967052,4967053,4967054,4967077,4967078,4967079,4967080,4967081,4967099,4967100,4967101,4967102,4967106,4967107,4967108,4967136,4967141,4967142,4967143,4967144,4967148,4967149,4967150,4967151,4967152,4967153,4967154,4967155,4967156,4967157,4967158,4967159,4967160,4967161,4967162,4967163,4967164,4967165,4967166,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,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,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,4967424,4967425,4967426,4967427,4967428,4967429,4967430,4967431) 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'