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(8569510,8569511,4970769,4970770,4970771,4970772,7065939,7065940,7065941,7065942,7065979,7066008,7066056,7066057,7066058,7066059,7066060,7066061,7066062,10950688,7066176,7066178,7066190,7066251,7066252,7066253,7066254,7066255,7066256,7066257,7066260,10951125,8067924,8067925,8067932,8573242,8573333,10988441,10962453,10939440,10986173,8065836,8065851,10999973,8910080,8834761,10959114,10959115,10959117,8910588,8910589,8910598,11009412,11048372,11048453,11010509,11010510,11010511,11010512,10623478,10623479,10623768,8906807,8906808,8906809,8906810,8906811,8906812,8906813,8906814,8906815,8906816,8906817,8906818,8906819,8906820,8906821,8906822,8906823,8906824,8906825,8906826,8906827,8906828,8906829,8906830,8906831,8906832,11008076,11008186,11008187,11008188,10616962,10616963,10616964,10616965,10616966,10616967,10616968,10616969,10616970,10616971,10616972,10616973,10616974,10616975,10616976,10616977,10616978,10616979,10616980,10616981,10616982,10616983,10616984,10616985,10616986,10616987,10616988,10616989,10616990,10616991,10616992,10616993,10616994,10616995,10616996,10616997,10616998,10616999,10617000,10617001,10617002,10617003,10617004,10617005,10617006,10617007,10617008,10617009,10617010,10617011,10617012,10617013,10617014,10617015,10617016,10617017,10617018,10617019,10617020,10617021,10617022,10617023,10617024,10617123,10617154,10617162,10617163,10617169,10617170,10617209,10617455,10622460,10927992,10927993,10993272,10993273,10615032,10615033,10615091,10615267,10615333,10615334,10615335,10615439,10930633,10615711,10615820,10615823,10615896,10615967,10615971,10615972,10615979,10615980,10615986,10615987,10615988,10615989,10615990,10616030,10616046,10621051,10621052,10616465,10616466,10616467,10616468,10616485,10616509,10616510,10616548,10616684,10616699,10616700,10616707,10616733,10616734,10616735,10616790,10616866,10616899,10616900,10616911,10616912,10616913,10616914,10616915,10616916,10616917,10616918,10616919,10616920,10616921,10616922,10616923,10616924,10616925,10616926,10616927,10616928,10616929,10616930,10616931,10616932,10616933,10616934,10616935,10616936,10616937,10616938,10616939,10616940,10616941,10616942,10616943,10616944,10616945,10616946,10616947,10616948,10616949,10616950,10616951,10616952,10616953,10616954,10616955,10616956,10616957,10616958,10616959,10616960,10616961,10565144,10611037,10614050,10611053,10611054,10614064,10611117,10611119,10614163,9165554,9165555,10614221,10614272,10614273,10611299,10614309,10611318,10611319,10611376,10614472,10614473,10614474,10614475,10614476,10614477,10614478,10614479,10614480,10614481,10614482,10614483,10614484,10614485,10614486,10614487,10614488,10614489,10614490,10614491,10614492,10614493,10614538,10614552,10614553,10614554,10614589,10614663,10611682,10611764,10614819,10614857,9182280,10611979,10612040,10612042,10612046,10612047,7057605,10612104,10612105,10612106,10612107,10612108,10609239,10609266,10609267,10612275,10612276,10612277,10612278,10612279,10612280,10612281,10612282,10612283,10612284,10609285,10612285,10612286,10612287,10609355,10609369,10612384,8862493,7058143,8862499,7058144,7058145,7058146,7058147,7058148,7058149,7058150,8862568,8862569,8862570,8862571,8862572,8862573,8862574,8862575,8862576,8862577,10609719,10609723,10612725,10612736,10612737,10612746,10612755,10612757,10612763,10609764,10609765,10612765,10612766,10612767,10612771,10612782,10609838,10609845,10612883,10612907,10612912,10612914,10609972,10609973,10609974,10609975,10609976,10609977,10609978,10609979,10609980,10609981,10609982,10612982,10609990,10613026,10613056,10613128,10613129,10613130,10613131,10613132,10613133,9188597,10613305,10613355,10613369,10610428,10610429,10610430,10610431,10610432,10610433,10610434,10610435,10610436,10610437,10610438,10610439,10610440,10610441,10610442,10610443,10610444,10610445,10610446,10610447,10610448,10610449,10610450,10610451,10610452,10610453,10610454,10610455,10610456,10610457,10610458,10610459,10610460,10610461,10610462,10610463,10610464,10610465,10610466,10610467,10610468,10610469,10610470,10610471,10610472,10610473,10610474,10613475,10610475,10610476,10613547,10613562,10610719,10610720,10610721,10610722,10613727,10613728,10613729,10610836,10613844,10610951,10610953,10610958,10610959,7055495,9169474,10515290,10515291,10515292,10515293,10515294,10515295,10515296,10515297,10515298,10515299,10515300,10515301,10515302,10515303,10515304,7055659,7055660,7055661,7055662,7055663,7055664,7055665,7055666,7055667,7055668,7055669,9169690,9169845,9169846,9169847,9169848,9169849,9169850,9169851,9169852,9169853,9169854,9169855,9169856,9169857,9169858,9169859,9169860,9169861,9169862,9169863,9169864,9169865,9169866,9169867,9169868,9169869,9169870,9169871,9169872,9169873,9169874,9169875,9169876,9169877,9169878,9169879,9169880,9169881,9169882,9169883,9169884,9169885,9169886,9169887,9169888,10517809,10516142,10514670,10514671,10419221,10419222,10419223,10419224,10419225,10419226,10419227,10419228,10419229,10419230,10419231,10419232,10419233,10419234,10419235,10419236,10419237,10419238,10419239,10419240,10419241,10419242,10419243,10419244,10419245,10419246,10419247,10419248,10419249,10419250,10419251,10419252,10419253,10419254,10419255,10419256,10419257,10419258,10419259,10419260,10419261,10419262,10419263,10419264,10419265,10419266,10419267,10419268,10419269,10419270,10419271,10419272,10419273,10419274,10419275,10419276,10419277,10419278,10419279,10419280,10419281,10419282,10419283,10419284,10419285,10419286,10419287,10419288,10419289,10419290,10419291,10419292,10419293,10419294,10419295,10419296,10419297,10419298,10419299,10419300,10419301,10419302,10419303,10419304,10419305,10419306,10419307,10419308,10419309,10419310,10419311,10419312,10419313,10419314,10419315,10419316,9168394,10419317,10415317,10419318,10419319,10419320,10419321,10419322,10415322,10419323,10419324,10419325,10419326,10415326,10419327,10419328,10419329,10419330,10419331,10419332,10419333,10419334,10419335,10419336,10419337,10419338,10419339,10419340,10419341,10419342,10419343,10419344,10419345,10419346,10419347,10419348,10419349,10419350,10419351,10419352,10419353,10419354,10419355,10419356,10419357,10419358,10419359,10419360,10419361,10419362,10419363,10419397,9168491,10418486,10415515,10415516,10415517,10415518,10415519,10415520,10415521,10415522,10415523,10415524,10415525,10415526,10415527,10415528,10415529,10415530,10415531,10415532,9168731,10415675,10415676,10415677,10415678,10415679,10415680,10415681,10415682,9168801,9168802,9168803,9168804,9168805,10416730,10416732,10415783,10415784,10415785,10415786,10415787,10415788,9168965,9168966,9168967,9168968,10417003,10417004,10417005,10417006,10417007,10417008,10417009,10417010,10417011,10417012,10417013,10417014,10417015,10417016,10419164,9169265,9169266,10419188,9169267,10419189,9169268,10419190,9169269,10419191,10419192,10419193,10419194,10419195,10419196,10419197,10419198,10419199,10419200,10419201,10419202,10419203,10419204,10419205,10419206,10419207,10419208,10419209,10419210,10419211,10419212,10419213,10419214,10419215,10419216,10419217,10419218,10419219,10419220,10468913,10468914,10471130,10471131,10471132,10471133,10471134,10471135,10471136,10471137,10471138,10471139,10471140,10471141,10471142,10471143,10471144,10471145,10471146,10471147,10471148,10471149,10471150,10471151,10471152,10471153,10471154,10471155,10471156,10471157,10471158,10471159,10471160,10471161,10471162,10471163,10471164,10471165,10471166,10471167,10469568,10469569,10469570,10469571,8916797,10467864,10467865,10467866,10467867,10467868,10467869,10467870,10467871,10467872,10467873,10467874,10467875,10467876,10467877,10467878,10467879,10467880,10467881,10467882,10467883,10467884,10467885,10467886,10467887,10467888,10467889,9167858,9167948,9167952,9167982,9167983,9167984,9167985,9167986,9168098,10470721,10470722,9168216,10169901,10632010,10630023,10630024,10630025,10630027,10630028,10630031,10630032,10630035,10630036,10630037,10630038,10630041,10630093,10161819,10161957,10161958,10161962,10161964,10161978,10161979,10162112,10162119,10162227,10162228,10162229,10162230,10162231,10162232,10162233,10626710,10626711,10626720,10626724,10626725,10568431,10568432,10568433,10568434,10568435,10568436,10568437,10568438,10568439,10568440,10582553,10567702,10567703,10579836,10579837,10579838,10579839,10579840,10568007,10568008,10568009,10568010,10568011,10568012,10568013,10568014,10568015,10568016,10568017,10568018,10568019,10568020,10568021,10568022,10568023,10568024,10568025,10529137,10527824,10527825,10527826,10527827,10527848,10527849,10527850,10527851,10527852,10527853,10527854,10527855,10527856,10527857,10527858,10527859,10527860,10527861,10527862,10527863,10527864,10527865,10527866,10527867,10527868,10527869,10527870,10527871,10527872,10527873,10527874,10527875,10527876,10527877,10522404,10522469,10522470,10522472,10522572) 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'