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(11015301,11015302,11015303,10944117,10944136,10940549,10950604,10951294,8067885,8837920,8837938,8837966,4969793,4969930,8068630,8068669,8068692,8068702,8835521,8835522,8835584,8065767,10986508,4967567,8066590,8066638,8066659,8066696,8066702,8066717,8066752,8066757,8066771,8066772,8066773,8066791,8066794,8066796,8066818,8066819,8066852,8066854,11010666,10942738,10942739,8834656,8834664,8834665,8064381,8064382,8064383,8064434,8064469,8064473,10959260,10959299,10959301,10959344,10959357,10959362,10959464,10959482,8970210,6000190,10940568,11034649,11034655,11034656,11034657,11034658,11034659,11034680,11034681,11034693,7069017,7069018,11034707,11034733,11034734,7069056,7069061,11034761,11034762,11034763,11034764,11034765,11034766,11034767,11034768,11034769,11034770,11034771,11034772,11034773,11034774,11034775,11034776,11034777,11034778,11034804,8563835,8563842,11034959,11034960,11034971,8564335,11035367,11035368,11035369,8564395,11035370,3656274,11047617,11047618,8564494,10996773,8072914,11048334,8834188,11049764,10980623,10980629,10980630,10980688,11045712,10980728,10980889,10981092,10981119,10981124,10981236,10981237,10981375,10981376,11033572,11033573,11033581,11033583,11033594,11033595,11033596,11033597,11033598,11033599,11033600,11033601,11033602,11033603,11033604,11033605,11033606,11033607,11033608,11033609,11033610,11033611,11033612,11033613,11033614,11033615,11033616,11033617,11033618,11033619,11033620,11033621,11033622,11033623,11033624,11033625,11033626,11033633,11033682,11033740,11033741,11033742,11033743,11033744,11033745,11033746,11033747,11033748,11033749,11033750,11033751,11033752,11033753,11033754,11033755,11033756,11033757,11033758,11033759,11033760,11033761,11033762,11033763,11033764,11033765,11033766,11033767,11033768,11033769,11033770,11033771,11033772,11033870,11033995,11034004,11034035,11034074,11034088,11034190,11034191,11034243,11034294,11034324,11034338,11034406,11034425,11034426,11034427,11034428,11034429,11034430,11034431,11034432,11034433,11034434,11034435,11034436,11034437,11034438,11034439,11034440,11034441,11034442,11034443,11034444,11034445,11034446,11034447,11034448,11034449,11034450,11034451,11034452,11034453,11034454,11034467,11034475,11034480,11034518,11034543,11034554,11034569,10979626,10979636,10979638,10979668,10979733,10979737,10979738,10979745,10979765,10979774,10979776,10979795,10979799,10979810,10979826,11005830,10979830,11005831,10979849,10979851,10979854,10979893,10979934,10979936,10979947,10979953,10979955,11005956,11005957,10979970,10979971,10979972,10979994,10980021,10980031,10980035,10980095,10622466,10980135,10980149,10980211,10980212,10980309,10980424,10980480,10980490,10980492,10980495,10980519,10980537,10980540,10980544,10980560,10980567,11006568,11006569,10980570,10980585,10980589,10980601,10980616,10920760,10920761,10920762,10920763,10920764,10920765,10920766,10920767,10920768,10920769,10920770,10920771,10920772,10920773,10920774,10920775,10920776,10920777,10920778,10920779,10920878,10920879,10920880,10920881,10920972,10920990,10920995,10921011,10921208,10921262,10921263,10921264,10921265,10921266,10921267,10921268,10921269,10921270,10921271,10921272,10921273,10921274,10921275,10921276,10921288,10921304,10930763,10921412,10921413,10921414,10921415,10921416,10921417,10921418,10921419,10921420,10921421,10921422,10921423,10921424,10921425,10916449,10916450,10916451,10916453,10921500,10921501,10921502,10921503,10921504,10921505,10921506,10921507,10921508,10921509,10916533,10916534,10921534,10916536,10921683,11017901,10921942,10621465,10621466,10621476,10621515,10621540,10979206,10953279,10953309,10953310,10953323,10621722,10621723,10979402,10621747,10621748,10979411,10979416,10979423,10979426,10979429,10979432,10979445,10979449,10979458,10979459,10917327,10917328,10917329,10979479,10979506,10979509,9181417,9181421,9181423,9181424,8864210,9166032,6666233,6666254,9179341,9203367,9203405,9179505,9179530,9179560,9179561,9179610,10609306,9203710,9203832,9203867,9203999,9204212,9180238,7058752,8863589,8863629,9201769,9201852,7056519,7056530,7056584,2809118,7056702,2809250,7056830,7056831,2809388,2809391,2809407,8861703,9179207,8861748,9179295,9160299,9160989,9185008,9161012,9161028,9161053,9201083,9177187,9177188,9177189,9166321,9166384,9166435,9166506,9166507,10463109,10463118,10463133,10463153,10463163,9166823,9166824,4972135,4972252,6667559,6667560,6667561,6667562,6667563,9168007,10466609,10466696,10466700,10466717,10466719,10169491,10169496,10169552,10169558,10169573,10154695,10169703,10169720,10169735,10169736,10154742,10154748,10154766,10169779,10169780,10169785,10154791,10169799,10154804,10169831,10154843,10154859,10154882,10169883,10169884,10169885,10169886,10154887,10154908,10154915,10154939,10169943,10169944,10154982,10154985,10170000,10170003,10170015,10155017,10155033,10160047,10160152,10160167,10160173,10160189,10160208,10160224,10160234,10160318,10160340,10160362,10160407,10160427,10160442,10160477,10160540,10160576,10160612,10160651,10629682,10629689,10629711,10629725,10629782,10629794,10629814,10183541,10183543,10178774,10178779,10178829,10178832,10168833,10168834,10168840,10168841,10168842,10168843,10168868,10168871,10168912,10168913,10168914,10168915,10168916,10168936,10168937,10168938,10168950,10168967,10168968,10168969,10168970,10168996,10168997,10168998,10169025,10169026,10169027,10169028,10169050,10169056,10169057,10169102,10169138,10169139,10169140,10169141,10169142,10169143,10169144,10169145,10169146,10169147,10169148,10169149,10169150,10169151,10169152,10169153,10169154,10169155,10169156,10169157,10169158,10169159,10169179,10169190,10169218,10169224,10169248,10169249,10169250,10169251,10169252,10169253,10169262,10169270,10169303,10169310,10169316,10169334,10169368,10169369,10169370,10169371,10169372,10169373,10169376,10169398,10169427,10169452,10169453,10169454,10169455,10169456,10169457,10169458,10169459,10169460,10169473,10181987,10181990,10181998,10182010,10182014,10182017,10182023,10182024,10182035,10182037,10182038,10182039,10182040,10182041,10182042,10182043,10182044,10182045,10182046,10182047,10182048,10182049,10182050,10182051,10182052,10182053,10182054,10182055,10182056,10182057,10182058,10182059,10182060,10182061,10182062,10182063,10182064,10182081,10182084,10182093,10182102,10182120,10182132,10182152,10182154,10182158,10182204,10182205,10182206,10182207,10182208,10182209,10182210,10182211,10182212,10182213,10182214,10182215,10182216,10182217,10182218,10182219,10182220,10182221,10182222,10626927,10626928,10577142,10577152,10574159,10574160,10574161,10577165,10577191,10577223,10577257,10577258,10577290,10577297,10577302,10577459,10577484,10574654,10574655,10577712,10577716,10577717,10577718,10577751,10577867,10577873,10577876,10577877,10577878,10577879,10577880,10577881,10577882,10577883,10577884,10577885,10577886,10577887,10577888,10577889,10577890,10577891,10577892,10577893,10577894,10577895,10577896,10577897,10577898,10577899,10577900,10577901,10577902,10577903,10577904,10577905,10577906,10577907,10577908,10577909,10577910,10577911,10577912,10577913,10577914,10577915,10577916,10577917,10577918,10577919,10577920,10577921,10577922,10577923,10577924,10577925,10577926,10577927,10577928,10577929,10583937,10583941,10577944,10577974,10577976,10578030,10578039,10578184,10578238,10578247,10578248,10578254,10578255,10578256,10578257,10578258,10578259,10578260,10578261,10578262,10578277,10578280,10578305,10578306,10578307,10578308,10578309,10578310,10578311,10578312,10578313,10578314,10578315,10578316,10578317,10578318,10578319,10578320,10578342,10578343,10578344,10578345,10578346,10578347,10578348,10578349,10578350,10578351,10578352,10578353,10578354,10578377,10578378,10578379,10578381,10578403,10578422,10578425,10578439,10578452,10578453,10578454,10578455,10578458,10578545,10578559,10578987,10573300,10573304,10573305,10576597,10576599,10576712,10576713,10576714,10576715,10576716,10576717,10576718,10576719,10576720,10576721,10576722,10576723,10576724,10576725,10576726,10576727,10576728,10576729,10576730,10576731,10576732,10576733,10576734,10576735,10576736,10576737,10576738,10576739,10576740,10576741,10576742,10576743,10576744,10576745,10576746,10576747,10576748,10576749,10576750,10576751,10576752,10576753,10576754,10576755,10576756,10576757,10576758,10576759,10576760,10576761,10576762,10576763,10576764,10576765,10576766,10576767,10576768,10576769,10576782,10576796,10576840,10576841,10576879,10576881,10570895,10576917,10576918,10576919,10576941,10576950,10576958,10576967,10576968,10576969,10576970,10576971,10576972,10576973,10576974,10576975,10576976,10576977,10576978,10576979,10576980,10576981,10576982,10576983,10576984,10576985,10576986,10576987,10576999,10577001,10577043,10577086,10577087,10523748,10523790,10423595,10421130,10483323,10479992,10480047,10480049,10480133,10480141,10480149,10480152,10480314,10478373,10480505,10480506,10480543) 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'