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(8630705,8630706,8630707,8630708,8630709,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,4970680,4970699,8631146,3228965,3228966,10989239,10989324,10989325,10989391,10989392,10950683,10950722,10950723,10950724,10950725,7066210,7066259,7066260,3229974,8575735,8575737,8575740,10990261,10990262,8632539,8632542,8632543,8632545,8632559,8632560,8632571,10938750,10929420,10939390,7201192,7201207,7201211,7201289,7201290,7201319,7201333,7201334,7201338,7201366,7201367,8627791,8627792,7201484,7201488,7201529,3238776,7201613,7201629,7201662,7201663,7201664,7201730,7201731,7201732,7201733,8628148,8628229,8628230,7201849,7201850,7201885,8836129,7201886,7201887,7201888,7201889,7201959,7201985,8065800,7202079,7202088,7202092,7202093,7202128,7202129,7202130,7202131,7202137,7202139,7202140,7202162,7202164,7202170,7202171,7202200,7202204,8628605,7202207,7202208,7202209,7202210,7202296,7202297,7202298,8628720,7202367,7202369,7202371,7202373,7202375,7202378,7202381,7202383,7202384,7202385,7202386,7202388,7202390,7202392,7202394,7202396,7202398,7202400,7202402,7202404,7202406,7202408,7202410,7202413,7202415,7202417,7202419,7202421,7202423,7202425,7202427,7202430,7202432,8628949,8628950,8628951,8628952,8628953,8628954,5654681,7202599,8629003,8629004,7202618,7202683,7202684,7202692,7202693,7202694,7202695,7202700,8629323,3227094,8629326,8629327,8629328,8629330,8629331,3227101,8629333,8629338,8629339,8629340,8629341,8629342,8629343,8629344,8629345,8629412,7200271,8910100,8626822,8626823,8626824,8626825,8626826,7200457,7200458,7200459,7200490,7200494,7200500,7200503,10958984,10958985,8626970,8626971,8626972,8626973,8626974,8626975,8626985,7200586,7200587,7200602,8627059,8627060,8627061,7200753,7200754,7200816,7200846,7200877,11037320,11037321,11037322,7200886,7201014,7201175,7198491,7198683,8908497,8908498,8908499,8908500,8908501,7198757,7198758,8625269,8625270,8625271,8625272,8625273,8625274,8625275,8625276,8625285,8625286,8625287,8625288,8625289,8625290,8625291,8625292,8625293,8625294,8625295,8625296,8625297,8625298,8625299,8625300,8625301,8625302,8625303,8625304,8625305,8625306,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,8625318,8625319,8625320,8625321,8625322,8625323,8625324,8625325,8625326,8625327,8625328,8625329,8625331,8625334,8625335,8625336,8625337,8625338,8625339,8625340,8625341,8625342,8625343,8625344,8625345,8625346,8625347,8625348,8625349,8625350,8625351,8625352,8625353,8625354,8625355,8625356,8625357,8625358,8625359,8625360,8625363,8625365,8625367,8625370,7199393,7199410,7199411,7199412,7199413,7199414,7199415,7199416,7199417,7199447,7199507,7199530,7199531,7199532,7199533,7199534,7199535,7199536,7199537,7199538,7199539,7199540,7199541,7199542,7199546,10101494,10101514,11048357,8073548,7196269,7196270,7196271,7196272,7196273,7196280,7196281,7196283,7196297,7196298,7196299,7196300,8612892,7196332,7196333,7196337,7196338,7196339,7196340,7196341,7196343,7196344,7196345,7196348,7196349,7196355,7196460,7196468,7196485,7196513,7196514,7196515,7196516,7196519,7196528,7196529,7196537,7196538,7196539,7196540,7196541,7196542,7196543,7196544,7196545,7196546,10618328,7196890,7197021,8906864,8906867,8906868,8906870,8906871,8906872,8906873,8906874,8906875,8906876,8906877,8906878,8906879,8906880,8906881,8906882,8906899,10838836,7197394,7197486,7197490,7197495,7197498,7197508,7197510,7197514,7197528,7197532,7197537,7197541,7197542,8907410,8907415,8907416,7197842,7197904,7197905,3235079,7197912,7197913,3235102,3232358,10927514,10617023,8905071,8905085,8905095,10617065,8905146,8905148,8905161,8905166,10617166,10617197,10617198,10617200,10617202,10617208,10617209,10617213,10617214,10617215,10617216,10617217,10617221,10617223,10617227,10617241,10617242,10617243,10617244,10617245,10617246,10617247,10617248,10617249,10617250,10617251,10617252,10617253,10617254,10617255,10617256,10617257,10617258,10617259,10617260,10617261,10617262,10617263,10617264,10617265,10617266,10617267,10617268,10617269,10617270,10617271,10617272,10617273,10617274,10617275,10617276,10617277,10617278,10617279,10617280,10617281,10617282,10617283,10617284,10617285,10617286,10617287,10617288,10617289,10617290,10617291,10617292,10617293,10617294,8905352,10617332,3232859,8905533,3232894,8905534,3232895,3232896,3232897,3232898,10954226,10954227,10954311,8905956,8905957,8905958,8905959,8905973,3233337,10615154,10615155,10615156,10615157,10615158,10615159,10615160,10615164,10615166,10620488,10615604,10615615,10615758,10615759,10615763,10615783,10615784,10615810,10615993,10615994,10615996,10615998,10616002,10616003,10426341,10616004,10616173,3231620,8611453,10616685,10616693,10611053,10611054,10611098,10614117,10611251,10614284,10614285,10611361,10611424,10614445,10611476,10611477,10611478,10611547,10614558,10611583,10611653,10611856,10614906,10614907,10611988,10611998,10609020,10612069,10612082,10612083,10612254,10609313,10609348,10609350,10609351,10609352,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609376,10609377,10609378,10609385,10609386,10609564,10609636,8862526,10609702,10612723,10612731,10612732,10612733,10612735,10612757,10612769,10609772,10612803,10612805,10612907,10612912,10612914,7017932,7017933,10612967,9196364,9196365,9196367,9196368,9196369,10613090,10613142,10613143,10610162,10610163,10613170,10613172,10613177,10613178,10613197,10610198,10610201,10613210,10610227,10610233,10610240,10613259,10613260,10613292,10610301,10610410,10610472,10613489,10613490,10610497,10610498,10610499,10613562,10610564,10610565,10610566,10610567,10613568,10613677,10610678,10613678,10610710,10610713,10613736,10613753,10613754,10610836,10613838,10610854,6673505,6673527,6673528,6673529,6673530,6673531,6673532,6673551,9193347,9193348,10117554,10117555,10117636,6673704,9169511,6673731,6673733,10117800,9161683,10118014,10118015,10118093,9169919,9169921,9169923,9169924,10118177,10118360,10118385,10118468,10118508,10118658,10118661,10118672,10419268,10419272,10419276,10419279,10419280,10419282,10417287,6672583,6672690,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,10419421,10419422,10419423,10419424,10419425,10419426,10419437,10419438,10415481,10418513,10418514,10418515,10418516,10418517,10418518,10418519,10418520,10418521,10418522,10418523,10418524,10418525,10418526,10124805,10418533,10418534,10418535,10418536,10418537,10418538,10418539,10418540,10418541,10419564,6672904,9168702,9168703,9168704,9168705,9168706,9168707,9168708,10419655,10419665,10419667,10419702,10416706,10417713,6673016,6673063,4974129,6673490,6673491,10117482,6673498,6673499,6673500,6673501,6673502,6673503,6673504,6670731,10469284,10469287,10469442,10467470,8550216,8550231,8550256,10467843,10467849,8550609,10115911,9167790,8551014,9167859,8551015,9167860,8551016,9167861,9167915,10468785,10468786,10468787,10468788,10468789,10468790,9168289,10184493,10184494,10184495,10883492,10184508,10883496,10184515,10184517,10883516,10883517,10184558,10184581,10184584,10184598,10184599,10184601,10888656,10888922,10883938,10883956,10889011,10884012,10889040,10889047,10889051,10884178,10884476,10889826,10890044,10890045,10890049,10890050,10890052,10890065,10890071,10890073,10890084,10890086,10890099,10890100,10890101,10890168,10885346,10885368,10887996,10883238,10883239,10883240,10883282,10883469,10883471,10885642,10885644,10885701,10161756,10161814,10161838,10161839,10885936,10885968,10886034,10162072,10886128,10886178,10886182,10886193,10162236,10886289,10630822,10630823,10630853,10886617,10163079,10163109,10163111,10887155,10887171,10882314,10882318,10950164,10887407,10580532,10647440,10647451,10647541,10647590,10647686,10588687,10521867,10521868,10424427,10407370,10490306,10486335,10486336,10486337,10486338,10486339,10486340,10486341,10473684,10490859,10490861,10490866,10490867,10490868,10490905,10490940,10490941,10490958,10490966,10490983,10490984,10481989,10481990,10481991,10481992,10481993,10481994,10481995,10481996,10491018,10491039,10491074,10491093,10491109,10491116,10491145,10489188,10489189,10489204,10489205,10474256,10474259,10474271,10474290,10474324,10474335,10474336,10474337,10474364,10474365,10474386,10474387,10474388,10474394,10474408,10474423,10474458,10474466,10474467,10474468,10474469,10408825,10474506,10474513,10474520,10487525,10472528,10474531,10474532,10472541,10472557,10474575,10472595,10472596,10472597,10472598,10409070) 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'