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(7075979,10939797,7066129,10950774,7066281,10950908,7066485,10964461,10964462,10990510,8573350,11001078,11001199,11001200,11001202,11001203,11001204,11001205,11001209,7067544,7067545,10962452,10962516,10962574,10985831,7072299,7072300,10999052,10999053,10999054,10999055,10999056,10999057,10999058,10999059,10999060,10999061,10986293,10986302,10986303,10986304,10986305,10986330,10986331,10986353,10986354,10986355,10986356,10986357,10986358,10986359,10986360,10986361,10986386,10986387,10986388,10986389,10986390,10986391,10986392,10986393,10986394,10986395,10986396,10986397,10986398,10986399,10986400,10986401,10986402,10986403,10986404,10986405,10986406,10986407,10986408,10986409,10986410,10986411,10986412,10986413,10986414,10986415,10986416,10986417,10986418,10986419,10986420,10986421,10986422,10986423,10986424,10986425,10986426,10986432,10986433,10960433,10986434,10960434,10986435,10986436,10986437,10986438,10986439,10960439,10960440,10960456,10960466,10960467,10960468,10960469,10960470,10960471,10960568,10960569,10932234,10960608,10960621,10960622,10960623,10960625,10960626,10960632,10960639,10999680,10960688,10960800,7073174,10999934,10999946,10999947,10999948,10999949,10999950,10999951,10999952,10999957,10999958,10999959,10999968,10999969,10999973,10999976,10999991,11000066,11000067,11000068,11000069,11000070,11000071,11000072,11000195,11000197,11000210,7073614,10997806,7071132,10997817,10997818,10997819,10997820,10997821,10997822,10997823,10997824,10997825,10997826,7071142,10997829,10997832,10997833,10997835,10997836,10997838,10997839,7071245,7071246,7071262,7071263,11010969,7071296,7071312,8910418,10959117,8910607,7071557,7071558,7071559,7071560,11011262,8910693,10998452,10998453,10998454,10998465,10998466,10998471,10998472,10998473,10998474,10998475,10998492,10998500,10998514,7069643,11035925,11035926,10942099,11036213,11036218,11036240,10942185,10942186,10942188,10942189,10942193,11036280,11036281,11010447,7070846,7070847,7070848,10942491,10942508,11045781,11045834,10967860,10967861,10967891,10967892,10967893,10967894,11046090,11046615,11046616,11046617,11046618,11046761,11046762,10619213,11008051,10995304,10995305,11047353,11047372,11044767,11044768,11044769,11044770,11044773,11044774,11044928,10954020,10954021,10927983,10927984,10927985,10927988,10928103,8569913,8569914,10620108,10951826,10951827,10964887,10964888,10951915,10952040,10615941,10966526,10966527,10565125,10565126,7059596,7059597,9165542,9165543,9165557,7059793,9189656,9189657,9189658,9189659,9197660,9189660,9189661,9189662,9197872,9197903,10559728,10559729,10559750,10559751,10559752,9214046,10614730,10614731,9214137,9174194,9174197,9174198,9198244,9214249,9214257,9214258,9174261,9214278,9214282,9214283,9214284,9211340,9187456,9187457,9187460,9187528,9187540,9187548,9187551,9171590,9171591,9171593,7057760,7057761,7057762,7057763,7057764,7057765,10557516,9171727,10563546,7057938,7057948,10557652,10557653,10557719,10557720,7058144,7058145,7058146,7058147,7058148,7058149,7058150,9172175,9172176,9172181,9172183,9172184,9172185,9172186,9172187,9172188,9172189,9172190,9172191,9172192,9172193,9172194,9172195,9172212,9172214,9172215,9172216,9172218,9172219,9172238,9172239,9172240,9172242,9172243,9172244,9172247,9172248,9172315,9188328,9188333,9196339,9188345,9188350,9188351,9172409,9172410,9172411,9188412,9172412,9172413,9188413,9188427,9188428,9188429,9188430,9188431,9188437,9188446,9188447,9188448,9188458,9188459,9188460,9196460,9196467,10558289,10558290,10558291,10558303,10558304,9204787,9196801,9172803,9196806,9196807,9196820,9196821,9172879,9172880,9172883,9172884,9204977,9204982,9173070,9173071,9173072,9189088,10610794,7055534,9169435,10515318,9193505,10515319,10515320,10515321,7055722,9193599,10517673,10517674,10517675,10517676,10517677,10517678,10517679,9170041,9170044,9170051,9170052,9170053,9170054,9170055,9170056,9170057,9170058,9170059,9170060,9170061,9170062,9170081,9170082,9170083,9170084,9170086,9170087,9170088,9170089,9170090,9170091,9170092,9170093,9170094,9170095,9170096,9170097,9170098,9170099,9170100,9170101,9170102,9170103,9170104,10513970,10513971,10513972,10513973,10514024,9170245,9170246,9170247,9170248,9170249,9170250,9170251,9170252,9170253,9170254,9170255,9170256,9170663,9170684,9170685,7057160,7057161,9187198,9192316,9192318,9192330,9192332,9192333,9192335,9192338,9192339,9192340,9192341,9192344,9192359,9192388,9192389,9192413,9192417,9192418,9192423,9192424,9176434,10416402,10416403,10416404,9192595,9192627,8918328,8918329,9168718,9168951,10416962,9185123,9185128,9193201,9193202,9193203,9193206,9193207,9193209,9193210,9193219,9193220,9193221,9193222,9185235,9185236,9185237,9190645,9190647,9190648,9190653,9190654,9190663,9190666,9190667,9190668,9174670,9190671,9190674,9190675,9190678,9190687,9198905,9198991,9183001,9191010,9175011,9175012,9175013,9175035,9191077,9191078,9191101,9191144,9183144,9191148,8916801,9191162,9191163,9191164,9191169,8916817,9191170,9191171,9191180,9199184,9199185,9191202,9191203,9191204,9191211,9191212,8916862,8916863,9191217,9191218,9191221,9191224,9191228,9191229,9191231,9191236,9191237,9191238,9191240,9191265,10469914,9183337,10469915,10469916,10469943,9175454,9175455,9175457,9175458,9175460,9175461,9175462,9191493,8563548,8917360,8917361,8917388,9175776,9167952,9175970,9175971,9191982,9191983,9175997,9176000,9192015,9192016,9184070,9168106,9192121,9168157,9184177,9184178,9192199,9192200,9192205,9192206,9192207,9192208,9192213,9192233,9192249,9192252,9192257,9192258,9192262,9192267,9192281,9192282,9192283,9192284,9192287,10627634,10626641,10589776,10589777,10589778,10589779,10589780,10589781,10589782,10589783,10589784,10589785,10589786,10589787,10589788,10589789,10589790,10589791,10589792,10589793,10589794,10589795,10589796,10589797,10589906,10589907,10589908,10589909,10589910,10589911,10589912,10589913,10589914,10589915,10589916,10589917,10589918,10589919,10589920,10589921,10589922,10589923,10589924,10589925,10589926,10589927,10589928,10589929,10589930,10589931,10589934,10589935,10589936,10589937,10589938,10589939,10589940,10589941,10589942,10589943,10589944,10589945,10589946,10589947,10589948,10589949,10589950,10589951,10589952,10589953,10589954,10589955,10589956,10589957,10589958,10589959,10589960,10589961,10589962,10589963,10589964,10589965,10589966,10589967,10589968,10589969,10589974,10589975,10589976,10589977,10589978,10589979,10589980,10589981,10589982,10589983,10589984,10589985,10589986,10589987,10589988,10589989,10589990,10589991,10589992,10589993,10589994,10589995,10589996,10589997,10589998,10589999,10590000,10590001,10590003,10590004,10590005,10590006,10590007,10590008,10590009,10590010,10590011,10590012,10590013,10590014,10590015,10590016,10590017,10590018,10590019,10590020,10590021,10590022,10590023,10590024,10590025,10590026,10590027,10590028,10590029,10590030,10590031,10590032,10590033,10590034,10590035,10590036,10590037,10590043,10590044,10590045,10590046,10590047,10590048,10590049,10590050,10590051,10590052,10590053,10590054,10590055,10590056,10590057,10590058,10590059,10590060,10590061,10590062,10590063,10590064,10590065,10590066,10590067,10590068,10590069,10590070,10590071,10590072,10590073,10590074,10590075,10590076,10590077,10590078,10590079,10590080,10590081,10590082,10590083,10590084,10590085,10590086,10590087,10590088,10590089,10590090,10590091,10590093,10590094,10590095,10590097,10590098,10590099,10590100,10590101,10590102,10590103,10590104,10590105,10590106,10590107,10590108,10590110,10590111,10584140,10584141,10584374,10566669,10588168,10588169,10588170,10588171,10588172,10588173,10582475,10588566,10588567,10588688,10585812,10585813,10585814,10585815,10585816,10585817,10585818,10585819,10585820,10585821,10585822,10585823,10585824,10585825,10585826,10585827,10585828,10585829,10585830,10585831,10585832,10585833,10585834,10585835,10585836,10585837,10585838,10585839,10585840,10585841,10585842,10585843,10585844,10585845,10585846,10585847,10585848,10585849,10585850,10585851,10585852,10585853,10585854,10585855,10585856,10585857,10585858,10585859,10585860,10585861,10585862,10585863,10585864,10585865,10585869,10585870,10585871,10585872,10585875,10585877,10585878,10585879,10585882,10585883,10585884,10585885,10585886,10585887,10585888,10580053,10580054,10529153,10529400,10529401,10529402,10529403,10529404,10529405,10529406,10529407,10529408,10521568,10533947,10533948,10533949,10533950,10533951,10520085,10520086,10520087,10522487,10522488,10522489,10522490,10522726,10522727,10522906,10522907,10522908,10522909,10522910,10522911,10522912,10528956,10529066,10529067,10421483,10422586,10422587,10421796,10425076,10425077,10486047,10486048) 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'