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(10940510,10940511,10940512,10940513,10940514,10940515,10940516,10940517,10940518,8583777,8583778,8583779,8583780,8583781,8583782,8583783,10868635,10868636,10868637,10951284,10951285,10951286,10929528,8835557,8835558,8835559,8835560,8835561,8835562,8835563,8835564,8835565,8835566,8835567,8835568,8835569,8835570,8835571,8066564,8908022,8908026,8908027,8908028,8908029,8908030,8908031,8908032,8908033,8908034,8908035,8908036,8908037,8908038,8908039,8908040,8908041,7069027,7069028,7069029,7069030,7069031,7069032,7069033,8556006,8556028,8556029,8556030,8556031,10841429,10841430,10841431,10841432,10841433,10841434,10841435,10841436,10841437,10841438,10841439,10841440,10841441,10841442,10841443,10841444,10841445,10841446,10841447,10841448,10841449,10841450,10841451,10841452,10841453,10841454,10841455,10841456,10841457,10841458,10841459,10841460,10841461,10841462,10841463,10841464,10841465,10841466,10841467,10841468,10841469,10841470,10841471,10841472,10841473,10841474,10841475,10841476,10841477,10841478,10841479,10841480,10841481,10841482,10841483,10841484,10841485,10841486,10841487,10841488,10841489,10841490,10841491,10841492,10841493,10841494,10841495,10841496,10841497,10841498,10841499,10841500,10841501,10841502,10841503,10841504,10841505,10841506,10841507,10841508,10841509,10841510,10841511,10841512,10841513,10841514,10841515,10841516,10841517,10841518,10841519,10841520,10841521,10841522,10841523,10841524,8613814,8613815,8613816,8613817,8613818,3924474,3924475,3924476,3924477,3924478,3924479,3924480,3924481,3924482,3924483,3924484,3924485,3924486,3924487,3924488,3924489,3924490,3581990,10621432,10621433,10621434,10979204,10979205,10979206,10979207,10979208,10979209,10979210,10979211,10979212,10979213,10979214,10979215,10979216,10979217,10979218,10979219,10979220,10979221,10979222,10979223,10979224,10979225,10979226,10979227,10979228,10979229,10979230,10979231,10979232,10979233,10979234,10979235,10979236,10979237,10979238,10979239,10979240,10979241,10979242,10979243,10979244,10979245,10979246,10979247,10979248,10979249,10979250,10979251,10979252,10979253,10979254,10979255,10979256,10979257,10979258,10979259,10979260,10979261,10979262,10979263,10979264,10979265,10979266,10979267,10979268,10979269,10979270,10979271,10979272,10979273,10979274,10979275,10979276,10979277,10979278,10979279,10979280,10979281,10979282,10979283,10979284,10979285,10979286,10979287,10979288,10979289,10979290,10979291,10979292,10979293,10979294,10979295,10979296,10979297,10979298,10979299,10979300,10979301,10979302,10979303,10979304,10979305,10979306,10979307,10979308,10979309,10979310,10979311,10979312,10979313,10979314,10979315,10979316,10979317,10979318,10979319,10979320,10979321,10979322,10979323,10979324,10979325,10979326,10979327,10979328,10979329,10979330,10979331,10979332,10979333,10979334,10979335,10979336,10979337,10979338,10979339,10979340,10979341,10979342,10979343,10979344,10979345,10979346,10979347,10979348,10979349,10979350,10979351,10979352,10979353,10979354,10979355,10979356,10979357,10979358,10979359,10979360,10979361,10979362,10979363,10979364,10979365,10979366,10979367,10979368,10979369,10979370,10979371,10979372,10979373,10979374,10979375,10979376,10979377,10979378,10979379,10979380,10979381,10979382,10979383,10979384,10979385,10979386,10979387,10979388,10979389,10979390,10979391,10979392,10979393,10979394,10979395,10979396,10979397,10979398,10979399,3232195,8853404,8853405,8853406,8853407,8853408,9179299,9179300,9179301,9179302,9179303,9179304,9179305,9179306,9179307,9179308,9179309,9179310,9179311,9179312,9179313,9179314,9179315,9179316,9179317,9179318,9179319,9179320,9179321,9179322,9179323,9179324,9914457,9914458,9914459,10120486,10120487,10120488,10120489,10120490,10120491,10120492,10120493,10120494,10120495,10120496,10120497,10120498,10120499,8567262,8863588,8863589,8863590,8863591,8863592,8863593,8863594,8863595,8863596,8863597,8863598,8863599,8863600,8863601,8863602,8863603,8863604,8863605,8863606,8863607,8863608,8863609,8863610,8863611,8863612,8863613,8863614,8863615,8863616,8863617,8863618,8863619,7056507,7056508,7056509,7056510,7056511,7056512,7056513,7056514,7056515,7056516,7056517,7056518,7056519,7056520,7056521,7056522,7056523,7056524,7056525,7056526,7056527,7056528,7056529,7056530,7056531,7056532,7056533,7056534,7056535,7056536,7056537,7056538,7056539,7056540,7056541,7056542,7056543,7056544,7056545,7056546,7056547,7056548,7056549,7056550,7056551,7056552,7056553,7056554,7056555,7056556,7056557,7056558,7056559,7056560,7056561,7056562,7056563,7056564,7056565,7056566,7056567,7056568,7056569,2809396,2809397,2809398,9179212,9179213,9179214,9179215,9179216,9179217,9179218,9179219,9179220,9179221,9179222,9179223,9179224,9179225,9179226,9179227,9179228,9179229,9179230,9179231,9179232,9179233,9179234,9179235,9179236,9179237,9179238,9179239,9179240,9179241,9179242,9179243,9179244,9179245,9179246,9179247,9179248,9179249,9179250,9179251,9179252,9179253,9179254,9179255,9179256,9179257,9179258,9179259,9179260,9179261,9179262,9179263,9179264,9179265,9179266,9179267,9179268,9179269,9179270,9179271,9179272,9179273,9179274,9179275,9179276,9179277,9179278,9179279,9179280,9179281,9179282,9179283,9179284,9179285,9179286,9179287,9179288,9179289,9179290,9179291,9179292,9179293,9179294,9179295,9179296,9179297,9179298,6666975,6666976,3963408,3963409,3963410,3963411,4972208,4972209,4972210,4972211,4972212,4972213,4972214,4972215,4972216,4972217,4972218,4972219,4972220,4972221,4972222,4972223,4972224,4972225,8550528,4972226,4972227,4972228,4972229,4972230,4972231,8593920,8593921,8593922,8593923,8593924,8593925,10168838,10168839,10168840,10168841,10168842,10168843,10168844,10168845,10168846,10168847,10168848,10168849,10168850,10168851,10168852,10168853,10168854,10168855,10168856,10168857,10168858,10168859,10168860,10168861,10168862,10168863,10168864,10168865,10168866,10168867,10168868,10168869,10168870,10168871,10168872,10168873,10168874,10168875,10168876,10168877,10168878,10168879,10168880,10168881,10168882,10168883,10168884,10168885,10168886,10897923,10897924,10897925,10897926,10897927,10897928,10897929,10897930,10897931,10897932,10897933,10897934,10897935,10897936,10897937,10897938,10897939,10897940,10897941,10897942,10897943,10897944,10897945,10897946,10897947,10897948,10897949,10897950,10897951,10897952,10897953,10897954,10897955,10897956,10897957,10897958,10897959,10897960,10897961,10897962,10897963,10897964,10897965,10897966,10897967,10897968,10897969,10897970,10897971,10897972,10897973,10897974,10897975,10897976,10897977,10897978,10897979,10897980,10897981,10897982,10897983,10897984,10897985,10897986,10897987,10897988,10897989,10897990,10897991,10897992,10897993,10897994,10897995,10897996,10897997,10897998,10897999,10898000,10898001,10898002,10898003,10898004,10898005,10898006,10898007,10898008,10898009,10898010,10898011,10898012,10898013,10898014,10898015,10898016,10898017,10898018,10898019,10898020,10898021,10898022,10898023,10898024,10898025,10898026,10898027,10898028,10898029,10898030,10898031,10898032,10949414,10949415,10949416,10949417,10949418,10523749,10523750,10523751,10523752,10523753,10523754,10523755,10523756,10523757,10523758,10523759,10523760,10523761,10523762,10523763,10523764,10523765,10523766,10523767,10523768,10523769,10523770,10523771,10523772,10523773,10523774,10523775,10523776,10523777,10523778,10523779,10523780,10523781,10523782,10523783,10523784,10523785,10523786,10523787,10523788,10523789,10523790,10523791,10523792,10523793,10523794,10523795,10523796,10523797,10523798,10523799,10523800,10523801,10523802,10523803,10523804,10523805,10523806,10523807,10523808,10523809,10523810,10523811,10523812,10523813,10523814,10523815,10523816,10523817,10523818,10523819,10523820,10523821,10523822,10523823,10523824,10523825,10523826,10523827,10421121,10421122,10480024,10480025,10480026,10480027,10480028,10480048,10480049,10480050,10480051,10480052,10480053,10480054,10480055,10480056,10480057,10480058,10480059,10480060,10480061,10480062,10480063,10480064,10480065,10480066,10480067,10480068,10480069,10480070,10480071,10480072,10480073,10480074,10480075,10480076,10480077,10480078,10480079,10480080,10480081,10480082,10480083,10480084,10480085,10480086,10480087,10480088,10480089,10480090,10480091,10480092,10480093,10480094,10480095,10480096,10480097,10480098,10480099,10480100,10480101,10480102,10480103,10480104,10480105,10480106,10480107,10480108,10480109,10480110,10480111,10480112,10480113,10480114,10480115,10480116,10480117,10480118,10480119,10480120,10480121,10480122,10480123,10480124,10480125,10480126,10480127,10480128) 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'