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(4970759,4970760,3229173,3229174,8583566,8583567,8583569,10950757,10950758,7066227,7066228,7066229,7066230,7066231,7066232,7066233,7066234,7066235,7066236,7201453,7201661,7201741,7201746,7201747,7202638,7202639,7202640,7202641,7202642,7202643,7202644,7202645,7202646,7202647,7202648,7202649,7202650,7202651,7202663,7200181,7200182,7200183,7200184,7200185,7200186,7200187,7200188,7200189,7200190,7200191,7200192,7200193,7200194,7200195,7200196,7200197,7200198,7200199,7200200,8834756,8834757,8834758,8834759,8834760,10985136,8564677,8564680,7199232,7199591,7199592,7199593,7199594,7199595,7199596,10101573,11048485,7199881,7199882,7199883,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,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,3923647,3923648,3923649,3923650,3923651,3923652,3923653,3923654,3923655,3923656,3923657,3923658,8906556,8906626,8906627,8906628,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,10623736,10930630,10620791,10615925,10615926,10615927,10615928,10426408,10616088,10616089,10616090,10616091,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,8540604,10616119,8540605,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,8540632,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,10616193,10616194,10616195,8611322,7155309,10616894,10714185,10714189,10714190,10714191,10714192,10614587,8566531,8852527,8852550,8852551,8852552,8852553,8852554,8852555,8852556,8852557,8852558,8852559,8852560,8852561,8852562,8852563,8852564,8852565,8852566,8852567,8852568,8852569,8852570,8852571,8852690,10610956,10610957,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,9169985,9169986,9912283,9912284,9912285,9912286,10118360,10118526,10118527,10118528,10118529,10118530,10118531,10118532,10418310,10418311,10418312,10418313,10418314,10418315,10418757,10418758,10418759,10418760,10418761,10418762,10418763,10418764,10418765,10418766,10418767,10418768,10418769,10418770,10418771,10418772,10418773,10418774,10418775,10418776,10418777,10418778,10418779,10418780,10418781,10418782,10418783,10418784,10418785,10418786,10418787,10418788,10418789,10418790,10418791,10418792,10418793,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,9166808,8550104,10470813,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,10628157,10888951,10893979,10893980,10893981,10893982,10889264,10889265,10889266,10889267,10889268,10889269,10889270,10889271,10889272,10889273,10889274,10889275,10889276,10889277,10889278,10889279,10889280,10889281,10889282,10889283,10889284,10889285,10889286,10889287,10889288,10889289,10889290,10889291,10889292,10889293,10889294,10889295,10889296,10889297,10889298,10889299,10889300,10889301,10889302,10889303,10889304,10889305,10889306,10889307,10889308,10889309,10889310,10889311,10889312,10889313,10889314,10890414,10887549,7000858,7000859,7000860,7000861,7000862,7000863,7000864,10887972,10162202,10631235,10887430,10647601,10647675,10647676,10522598,10422590,10422591,10422592,10422593,10422598,10508498,10508499,10508500,10507618,10412472) 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'