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(8630690,8630743,8630744,8630745,8630746,8630747,8630748,8630816,8630874,8630875,8630876,8630877,8630878,8630879,8630880,8630881,8630884,8630892,8630894,8630997,10448242,8631120,8631255,8631256,8631257,8631258,8631259,8631260,8631261,8631262,8631263,8631264,8631265,8631266,8631267,8631268,8631269,8631270,8631271,8631272,8631273,8631274,8631298,8631299,8631300,8631301,8631303,8631304,8631305,8631306,8631307,8631309,8631310,8631311,8631312,8631313,8631315,8631316,8631317,8631318,8631319,8631321,8631322,8631323,8631324,8631325,8631327,8631328,8631329,8631330,8631331,8631333,8631334,8631335,8631336,8631337,8631339,8631340,8631341,8631342,8631343,8631345,8631480,8631481,8631482,8631483,8631484,4971081,8631590,8631622,8631623,8631624,8631625,8631626,8631629,8631631,8631632,8631633,8631634,8631635,8631644,8631645,8631646,8631647,8631648,8631649,8631650,8631653,8631654,8631655,8631656,8631673,8631743,8631749,8631751,8631752,8631754,8631755,8631757,8631765,10847216,8632196,8632197,8632198,8632199,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,8632237,8632238,8632240,8632241,8632242,8632243,8632244,8632245,8632246,8632247,8632248,8632249,8632250,8632251,8632252,8632253,8632254,8632255,8632256,8632257,8632258,8632259,8632260,8632261,8632262,8632263,8632264,8632265,8632266,8632267,8632361,8632362,8632363,8632366,8632367,8632369,8632371,8632373,8632375,8632377,8632378,8632379,8632385,8632386,8632387,8632388,8632389,8632390,8632392,8632393,8632394,8632395,8632396,8632397,8632398,8632399,8632410,8632420,8632424,8632425,8632426,8632428,8632429,8632440,8632444,8632448,8632498,8632499,8632507,8632508,8632509,8632510,8632511,8632512,8632513,8632514,8632515,8632516,8632517,8632518,8632519,8632520,8632521,8632522,8632523,8632524,8632525,8632526,8632527,8632528,8632537,8632538,8632544,8632545,8632546,8632547,8632548,8632549,8632550,8632551,8632552,8632553,8632554,8632557,8632558,8632561,8632562,8632563,8632564,8632565,8632566,8632567,8632568,8632569,8632570,8632571,8632572,8632573,8632574,8629596,8629599,8629612,8629624,8629625,8629627,8629629,8629630,8629712,8629752,8629753,8629870,8629873,8629927,8629965,8629966,8629967,8629968,8629970,8629973,8629975,8629977,8629978,8629981,8629982,8629998,8630001,8630003,8630007,8630008,8630012,8630014,8630017,8630018,8630021,8630023,8630027,8630028,8630029,8630030,8630134,8630135,8630139,8630141,8630142,8630143,8630144,8630145,8630147,8630148,8630150,8630153,8630154,8630155,8630157,8630160,8630163,8630166,8630168,8630169,8630171,8630178,8630180,8630182,8630184,8630237,8630239,8630273,8630282,8630283,8630284,8630286,8630395,8630396,8630400,8630442,8630447,8630448,8630449,8630450,8630451,8630452,8630482,8630483,8630484,8630485,8630486,8630487,8630489,8630490,8630491,8630500,8630502,8630504,8630505,8630506,8630508,8630509,8630510,8627581,8627582,8627583,8627596,8627704,8627705,8627707,8627708,8627709,8627710,8627711,8627712,8627713,8627714,8627715,8627716,8627717,8627718,8627719,8627720,8627721,8627722,8627723,8627724,8627725,8627726,8627727,8627791,8627792,8627793,7064168,8627919,8627920,8627922,8627931,8627933,10103440,8627991,8627993,8627995,8627997,8627999,8628001,8628002,8628003,8628005,8628007,8628041,8628042,8628043,8628044,8628045,8628046,8628047,8628048,8628049,8628050,8628051,8628053,8628055,8628056,8628057,8628058,8628059,8628060,8628061,8628062,8628063,8628064,8628065,8628066,8628067,8628068,8628069,8628070,8628083,8628084,8628085,8628086,8628087,8628088,8628089,8628090,8628091,8628092,8628093,8628094,8628095,8628101,8628171,7201775,7201776,7201777,7201778,7201779,7201780,3899035,7201781,7201782,8628183,8628184,8628185,8628186,8628187,8628188,8628189,7201789,8628190,7201790,7201791,7201792,7201793,7201794,7201795,7201796,7201797,7201798,7201799,7201800,7201801,8628202,7201802,8628203,7201803,8628204,7201804,8628205,7201805,8628206,7201806,7201807,7201808,8628209,7201809,7201810,7201811,8628212,7201812,8628213,7201813,7201814,7201815,7201816,7201817,7201818,7201819,7201820,8628221,7201821,7201822,7201823,7201824,7201825,7201826,7201827,7201828,7201829,7201830,7201831,7201832,7201833,7201834,7201835,7201836,7201837,7201838,7201839,8628254,8628255,8628256,8628260,8628264,8628274,8628275,8628276,8628277,8628278,8628279,8628280,8628281,8628282,8628283,8628284,8628285,8628319,8628337,8628344,3899204,8628351,8628352,7202077,7202104,8572096,10843709,7202209,7202210,8628626,8628627,8628632,8628634,8628636,8628643,8628644,8628645,8628652,8628653,7202258,7202259,7202265,7202266,8628669,8628672,8628674,8628675,8628679,8628681,8628684,8628685,8628688,8628690,8628698,8628700,8628702,8628703,8628704,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,8628721,7202322,8628722,7202323,8628723,7202324,7202325,7202326,7202327,7202328,7202329,8628729,8628730,8628737,8628738,8628793,8628794,8628814,8628815,8628816,8628817,8628819,8628821,8628823,8628824,8628825,8628826,8628828,8628830,8628832,8628833,8628834,8628835,8628842,8628843,8628844,8628846,8628848,8628850,8628852,8628854,8628856,8628858,8628860,8628862,8628864,8628866,8628868,8628870,8628872,8628889,8628890,8628891,8628892,8628893,8628894,8628896,8628897,8628898,8628899,8628900,8628901,8628905,8628906,8628907,8628908,8628909,10104393,8628910,10104394,10104395,10104396,10104397,8628914,10104398,8628915,8628916,8628917,8628918,8628919,8628920,8628921,8628922,8628923,8628924,8628925,8628926,8628927,8628928,8628929,8628930,8628931,8628950,8628952,8628954,8628957,8628959,8628961,8628963,8628965,8628967,8628969,8628971,8628973,8628975,8628977,8628979,8628981,8628983,8628985,8628987,8628989,8628991,11000110,10844185,10844186,10844187,10844188,10844189,7202683,10844190,7202684,8629095,7202695,8629096,8629099,10844239,10844261,8629220,8629221,8629222,8629227,8629228,8629229,8629230,8629231,8629232,8629249,8629258,8629324,8629325,8629332,8629333,8629336,8629337,8629392,8629393,8629394,8629395,8629396,8629397,8629398,8629399,8629400,8629433,8629434,8629435,8629436,8629437,8629465,8629466,8629490,8629491,8629492,8616857,8616858,8626771,8626818,8626819,8626820,10997861,8626914,8627007,8627013,8627027,8627050,8627052,8627054,8627055,8627056,8627057,8627058,8627059,8627060,8627061,8627064,8627065,8627066,8627068,8627072,8627073,8627074,8627075,8627082,8627083,8627084,8627085,8627088,8627089,8627090,8627091,8627093,8627094,8627095,8627096,8627098,8627099,8627101,8627103,8627106,8627107,8627108,8627109,8627110,8627112,8627113,8627115,8627117,8627119,8627120,8627121,8627125,8627126,8627129,8627132,8627133,8627134,8627137,8627138,8627141,8627142,8627143,8627146,8627147,8627148,8627150,8627151,8627154,8627155,8627156,8627159,8627160,8627161,8627163,8627164,8627167,8627168,8627169,8627172,8627173,8627174,8627176,8627177,8627180,8627181,7071537,8627184,8627185,8627186,8627188,8627189,8627192,8627193,8627194,8627197,8627198,8627199,8627202,8627203,8627204,8627206,8627207,10842319,10842320,8627314,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8627370,8627372,3655849,3655890,7069592,8073172,10101591,8073210,8073294,10102026,7196307,7196316,7196317,7196337,7196508,7196512,7196516,7196523,7196526,7196527,7196528,10838077,3233760,7196890,7196891,7196892,10839202,10839637,10617171,8542215,10615229,10951941,10952141,10952142,10991312,10616033,10621034,10616542,10616543,10616544,10616553,7059524,6665751,10611891,10611892,10613149,10613172,10118342,9186900,10512780,6666650,6667350,10626300,10631794,10631795,10601174,10584083,10584113,10584114,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529385,10529386,10529387,10529388,10529389,10529390,10529391,10529392,10529393,10529394,10529395,10529396,10529397,10529400,10529401,10529402,10529403,10529404,10529405,10529406,10529407,10529408,10529409,10529412,10529413,10529414,10529415,10529416,10529417,10529418,10529419,10529420,10529421,10529424,10529425,10541445,10541446,10541447,10541448,10540883,10422819,10422823,10494384) 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'