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(4970760,4970773,3229174,3229207,8583475,8583566,8583567,10950757,10950758,7066227,7066228,7066229,7066230,7066231,7066232,7066233,7066234,7066235,7066236,8632395,8632396,8632397,8632398,8632399,3227405,3227406,3227407,3227408,3227417,10939394,10939395,7201386,7201387,7201959,7200061,7200062,7200063,7200064,7200065,7200066,7200067,7200068,7200069,7200070,7200071,7200072,7200073,7200074,7200075,7200076,7200077,7200078,7200079,7200080,7200081,7200082,7200083,7200084,7200085,7200086,7200087,7200088,7200089,7200090,7200091,7200092,7200093,7200094,7200095,7200096,7200097,7200098,7200099,7200100,7200101,7200102,7200103,7200104,7200105,7200106,7200107,7200108,7200109,7200110,7200111,7200112,7200113,7200114,7200115,7200116,7200117,7200118,7200119,7200120,7200121,7200122,7200123,7200124,7200125,7200126,7200127,7200128,7200129,7200130,7200131,7200132,7200133,7200134,7200135,7200136,7200137,7200138,7200139,7200140,7200141,7200142,7200143,7200144,7200145,7200146,7200147,7200148,7200149,7200150,7200151,7200152,7200153,7200154,7200155,7200156,7200157,7200158,7200159,7200160,7200161,7200162,7200163,7200164,7200165,7200166,7200167,7200168,7200169,7200170,7200171,7200172,7200173,7200174,7200175,7200176,7200177,7200178,7200179,7200180,7200181,7200182,7200183,7200184,7200185,7200186,7200187,7200188,7200189,7200190,7200191,7200192,7200193,7200194,7200195,7200196,7200197,7200198,7200199,3237372,8834756,8834757,8834758,8834759,8834760,7200754,7200757,7198683,7199067,7199176,8564680,7199471,7199472,7199473,7199474,7199475,7199476,7199477,7199478,7199479,7199480,10101573,7199884,7199885,7199886,7199887,7199888,7199889,7199890,7199891,7199892,7199893,7199894,7199895,7199896,7199897,7199898,7199899,7199900,7199901,7199902,7199903,7199904,7199905,7199906,7199907,7199908,7199909,7199910,7199911,7199912,7199913,7199914,7199915,7199916,7199917,7199918,7199919,7199920,7199921,7199922,7199923,7199924,7199925,7199926,7199927,7199928,7199929,7199930,7199931,7199932,7199933,7199934,7199935,7199936,7199937,7199938,7199939,7199940,7199941,7199942,7199943,7199944,7199945,7199946,7199947,7199948,7199949,7199950,7199951,7199952,7199953,7199954,7199955,7199956,7199957,7199958,7199959,7199960,7199961,7199962,7199963,7199964,7199965,7199966,7199967,7199968,7199969,7199970,7199971,7199972,7199973,7199974,7199975,7199976,7199977,7199978,7199979,7199980,7199981,7199982,7199983,7199984,7199985,7199986,7199987,7199988,7199989,7199990,7199991,7199992,7199993,7199994,7199995,7199996,7199997,7199998,7199999,7200000,7200001,7200002,7200003,7200004,7200005,7200006,7200007,7200008,7200009,7200010,7200011,7200012,7200013,7200014,7200015,7200016,7200017,7200018,7200019,7200020,7200021,7200022,7200023,7200024,7200025,7200026,7200027,7200028,7200029,7200030,7200031,7200032,7200033,7200034,7200035,7200036,7200037,7200038,7200039,7200040,7200041,7200042,7200043,7200044,7200045,7200046,7200047,7200048,7200049,7200050,7200051,7200052,7200053,7200054,7200055,7200056,7200057,7200058,7200059,7200060,8906004,8906005,8906006,8906007,8906008,3923457,3923579,3923647,3923648,3923649,3923650,3923651,3923652,3923653,3923654,3923655,3923656,3923657,8906629,8906630,8906631,8906632,8906633,8906634,8906635,8906636,8906637,8906638,8906639,8906640,8906641,8906642,8906643,8906644,8906645,8906646,8906647,8906648,8906649,8906650,8906651,8906652,8906653,8906654,8906655,8906656,8906657,8906658,8906659,8906660,8906661,8906662,8906663,8906664,8906665,8906666,8906667,8906668,8906669,8906670,8906671,8906672,8906673,8906674,8906675,8906676,8906677,8906678,8906679,8906680,8906681,8906682,8906683,8906684,8906685,8906686,8906687,8906688,8906689,8906690,8906691,8906692,8906693,8906694,8906695,8906696,8906697,8906698,8906699,8906700,8906701,8906702,8906703,8906704,8906705,8906706,8906707,8906708,8906709,8906710,8906711,8906712,8906713,8906714,8906715,8906716,8906717,8906718,8906719,8906720,8906721,8906722,8906723,8906724,8906725,8906726,8906727,10838795,3234501,3234502,10838869,10838870,10838871,3234856,7197859,3232353,3232354,3232355,3232356,8905267,3232862,3230579,10615478,10615479,10615480,3231054,10930630,10426242,10426243,10616092,10616093,10616094,10616095,10616096,10616097,10616098,10616099,10616100,10616101,10616102,10616103,10616104,10616105,10616106,10616107,10616108,10616109,10616110,10616111,10616112,10616113,10616114,10616115,10616116,10616117,10616118,10616119,10616120,10616121,10616122,10616123,10616124,10616125,10616126,10616127,10616128,10616129,10616130,10616131,10616132,10616133,10616134,10616135,10616136,10616137,10616138,10616139,10616140,10616141,10616142,10616143,10616144,10616145,10616146,10616147,10616148,10616149,10616150,10616151,10616152,10616153,10616154,10616155,10616156,10616157,10616158,10616159,10616160,10616161,10616162,10616163,10616164,10616165,10616166,10616167,10616168,10616169,10616170,10616171,10616172,10616173,10616174,10616175,10616176,10616177,10616178,10616179,10616180,10616181,10616182,10616183,10616184,10616185,10616186,10616187,10616188,10616189,10616190,10616191,10616192,8540594,3231706,10616554,7155309,10611040,10611041,10611042,10611043,10611044,10611045,10611046,10611047,10611048,10611049,10611050,10611051,10611052,10611053,10611054,10611055,10611056,10611057,10611058,10611059,10611060,10611061,10611062,10611063,10611064,10611125,10614222,10614223,10614224,10614225,10614226,10614316,10714189,10714190,10714191,10714192,10611691,10612159,10612160,10612161,10609562,10609563,8862519,8852055,8852056,10610259,10610361,8852551,8852552,8852553,8852554,8852555,8852556,8852557,8852558,8852559,8852560,8852561,8852562,10610415,10117695,10117696,9169519,9169520,9169723,9169724,9169725,9169726,9169727,9169728,9169729,9169730,9169731,9169732,9169733,9169734,9169735,9169736,9169737,9169738,9169739,9169740,9169741,9169742,9169743,9169744,9169745,9169746,9169747,10118175,10118529,10118530,10118531,10118532,6672576,6672577,10415323,10419470,10417539,10416568,9169164,9169165,9169166,10117455,10117456,10470876,10470877,10470878,10470879,10470880,10470881,10470882,10470883,10470884,10470885,10470886,10470887,10470888,10470889,10470890,10470891,10470892,10470893,10470894,10470895,10470896,10470897,10470898,10470899,10470900,10470901,10470902,10470903,10470904,10470905,10470906,10470907,10470908,10470909,10470910,10470911,10470912,10470913,10470914,10470915,10470916,10470917,10470918,10470919,10470920,10470921,10470922,10470923,10470924,10470925,10470926,10470927,10470928,10470929,10470930,10470931,10470932,10470933,10470934,10470935,10470936,10470937,10470938,10470939,10470940,10470941,10470942,10470943,10470944,10470945,10470946,10470947,10470948,10470949,10470950,10470951,10470952,10470953,10470954,10470955,10470956,10470957,10470958,10470959,10470960,10470961,10470962,10470963,10470964,10470965,10470966,10470967,10470968,10470969,10470970,10470971,10470972,10470973,10470974,10470975,10470976,10470977,10470978,10470979,10470980,10470981,10470982,10470983,10470984,10470985,10470986,10470987,10470988,10470989,10470990,10470991,10470992,10470993,10470994,10470995,10470996,10470997,10470998,10470084,10470085,10470086,10470087,10470088,10470089,10470090,10468252,9167726,9168125,9168126,9168127,9168128,9168209,10470814,10470815,10470816,10470817,10470818,10470819,10470820,10470821,10470822,10470823,10470824,10470825,10470826,10470827,10470828,10470829,10470830,10470831,10470832,10470833,10470834,10470835,10470836,10470837,10470838,10470839,10470840,10470841,10470842,10470843,10470844,10470845,10470846,10470847,10470848,10470849,10470850,10470851,10470852,10470853,10470854,10470855,10470856,10470857,10470858,10470859,10470860,10470861,10470862,10470863,10470864,10470865,10470866,10470867,10470868,10470869,10470870,10470871,10470872,10470873,10470874,10470875,10888526,10888527,10888528,10888529,10884125,10884126,10884127,10884128,10884129,10884130,10884131,10884132,10884133,10884134,10889265,10889266,10889267,10889268,10889269,10889270,10889271,10889272,10889273,10889274,10889275,10889276,10889277,10889278,10889279,10889280,10889281,10889282,10889283,10889284,10889285,10889286,10889287,10889288,10884591,10882532,10882533,10882534,10882535,10882536,10882537,10882538,10882539,10882540,10632106,10632109,10632110,7000858,7000859,7000860,7000861,7000862,7000863,7000864,10887853,10161803,10161919,10162103,10162126,10162202,10647442,10647675,10647676,10507731,10507732,10507733,10507734,10507735,10409870,10409871,10409872,10409873,10409874,10409875,10409876) 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'