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(10861383,10861413,8583566,8583567,7066227,7066228,7066229,7066232,8632395,8632396,8632397,8632398,8632399,10860277,3227405,3227406,3227407,3227408,8067906,3238530,3238531,3238534,7201386,7201387,10866612,7201746,7201959,7201963,7201970,8837126,7200181,7200182,7200184,7200185,7200186,7200187,7200188,7200189,7200190,7200191,7200194,7200195,3237372,10865497,10865498,10865499,10865500,10865501,10865502,10865503,10865504,10865510,10865511,10865512,10865513,10865515,10865516,10865517,10865518,10865520,10865521,8834756,10865652,10865763,7200754,10865956,7199059,7199067,10864204,10856245,10856246,10856247,10856248,10856249,10856250,10856251,10856252,7199210,10856257,8564680,10856258,7199232,10856347,10856348,7199471,7199472,7199473,7199479,7199480,10101523,10101567,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,7199925,7199926,7199927,7199928,7199938,7199941,7199946,7199953,7199959,7199974,7199975,7199976,7199977,7199978,7199979,7199980,7199981,7199982,7200016,7200017,7200021,7200023,7200025,7200032,7200035,7200036,7200037,7200038,7200039,7200040,7200041,7200042,7200043,7200046,7200057,7200062,7200066,7200068,7200070,7200075,7200078,7200079,7200080,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,7200176,7200177,7200179,7200180,8906005,8906006,3923457,3923648,3923650,3923651,3923655,8906629,8906630,8906631,8906632,8906633,8906634,8906635,8906636,8906637,8906638,8906639,8906640,8906644,8906645,8906647,8906648,8906650,8906651,8906652,8906654,8906656,8906658,8906659,8906661,8906662,8906664,8906665,8906671,8906677,8906678,8906679,8906680,8906681,8906682,8906683,8906684,8906690,8906691,8906692,8906693,8906694,8906696,8906697,8906698,8906699,8906700,8906701,8906702,8906703,8906704,8906705,8906707,8906711,8906712,8906713,8906714,8906715,8906717,8906718,8906719,8906720,8906721,8906722,8906723,8906725,8906727,8906804,10854073,10854074,10854075,10854076,10838795,3234501,3234502,3234856,7197859,3232354,3232355,3232356,8905267,3232862,3230579,10615287,8633195,8633196,8633197,8633198,8633199,10425934,3231054,10620750,10616092,10616093,10616094,10616095,10616096,10616097,10616098,10616099,10616100,10616103,10616105,10616109,10616110,10616111,10616112,10616115,10616118,10616119,10616120,10616121,10616122,10616123,10616124,10616126,10616127,10616129,10616130,10616131,10616132,10616134,10616136,10616137,10616141,10616142,10616143,10616147,10616148,10616149,10616151,10616152,10616153,10616154,10616155,10616156,10616160,10616161,10616163,10616165,10616168,10616169,10616171,10616173,10616177,10616178,10616179,10616181,10616182,10616189,10616190,3231706,8634103,8634105,8634106,8634109,10616805,3232353,10611040,10611041,10611042,10611043,10611044,10611045,10611046,10611047,10611048,10611049,10611050,10611051,10611052,10611053,10611054,10611056,10611057,10611060,10611061,10611062,10611063,10611064,10611125,10614222,10614316,10714190,10611691,10612161,10609562,10609563,8862519,8862574,8852056,10613232,10613233,10613234,10613274,10613275,10610361,8852551,8852552,8852553,8852554,8852558,8852559,8852560,8852561,8852563,8852567,8852568,10610415,9177364,9177366,9177367,9911596,9911668,9911669,9911670,9911671,9911672,10117695,10117696,9911788,9169723,9169727,9169729,9169734,9169741,9169742,9169743,9169746,9169747,9912071,9912188,9912189,10118529,10118589,9912944,9913044,9913208,9913209,9913364,10415323,10415354,10419470,10417539,6672906,10418880,10418975,10419095,10117455,10470883,10470888,10470895,10470899,10470903,10470904,10470905,10470906,10470907,10470908,10470912,10470917,10470925,10470926,10470931,10470937,10470938,10470939,10470940,10470941,10470942,10470943,10470944,10470945,10470946,10470947,10470949,10470953,10470959,10470960,10470961,10470962,10470967,10470972,10470976,10470977,10470978,10470979,10470980,10470981,10470982,10470983,10470984,10470987,10470988,10470989,10470990,10470991,10470992,10470994,10470995,8550158,10470085,10470087,10470089,10468252,10470666,10470667,10470668,9168125,10470814,10470815,10470816,10470817,10470818,10470819,10470820,10470821,10470822,10470823,10470824,10470825,10470826,10470827,10470828,10470829,10470830,10470831,10470832,10470833,10470846,10470848,10470851,10470853,10470854,10470860,10470861,10470866,10888526,10888529,10884126,10884128,10884129,10884130,10884132,10884133,10889265,10889266,10889267,10889268,10889269,10889271,10889279,10889282,10889285,10889286,10889287,10889542,10884591,10889669,10889670,10879912,10879913,10882532,10882533,10882534,10882538,10882540,10632106,10632109,7000858,7000862,10163717,10887972,10161803,10162202,10876807,10647442,10647641,10647675,10604619,10604620,10507732,10507733,10507734,10411333,10411334,10411335,10411336,10411337,10411338,10411339,10411340,10411341,10411342,10411344,10411345,10409872,10409873,10409874,10409875,10409876,10410904) 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'