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(10939598,11014713,4970273,4970274,4970275,4970276,4970277,4970278,4970279,4970280,4970281,4970282,4970283,4970284,4970285,4970286,4970287,4970288,4970289,4970290,4970291,11001811,11014832,7068188,11001915,7068277,7068278,10939966,7068360,11002104,11002105,11002106,4970669,10940112,11015307,11015308,11015309,11002341,11002342,11002343,11002344,11002345,11002346,11002347,11002354,11002355,4970934,10944180,10944181,10944182,10944183,10944184,10944185,10944186,8569753,10963501,10963509,11015517,11002531,11002535,11002536,11002537,10976538,11002538,11002539,10976539,8569879,11002671,11002672,11002686,11002687,7074020,7074100,11002845,11002851,11002852,7074178,7074179,7074189,11002955,11003062,10437308,8067514,11003241,11003265,11003413,10990483,10990484,11003535,11003542,11003543,11003544,11003545,11003546,7074966,7074967,7074970,7066995,8067893,8067894,10961697,10961698,10961699,10961700,7075019,10961795,10961796,10961797,10961798,10961799,10961835,10987918,10987920,10987921,10987953,10987954,10987955,10987973,10987997,10988048,10988063,10988076,11014098,11014099,11014100,11014101,11014114,10988257,10962321,10962322,10962323,10962324,10939287,10939288,10939289,10939290,10962432,10962433,11001466,11001467,11014474,10962516,11001550,11001561,11001562,11001563,6000292,10972749,10985768,10972832,10972833,10959857,7064291,7064401,10986093,10986094,10973140,10986184,10986185,10986186,10986187,10986188,10986189,10986190,7072513,7072515,11012210,8065518,8065519,8065520,8065521,8065522,8065523,10931893,10931894,8065524,10931895,10931896,10931897,10931898,10931899,7072642,7072644,7072687,7072838,7072839,11012734,11012735,11012736,11012737,11012738,10932819,10932826,7065497,7065498,11013185,11013186,11013187,11013188,11013189,10932957,10932958,10961351,10961352,10961353,10933051,10933052,11013407,11013408,11013409,10997782,10971848,7071214,11049148,8064516,10985254,10985255,10985261,10985264,10985265,10985308,10985309,10985310,10985364,10985405,7071754,7071804,10985524,10985525,10985526,10985527,10985528,10959591,10959592,10959593,10959594,10959595,10959596,10959597,10959598,10959599,10959600,10959601,10959602,10959603,10959604,10959605,10959606,10959607,10959614,10959615,7069010,10940901,10970057,10970173,10970198,10970222,10970275,10970446,10970447,10970448,10970449,11009523,11009524,10983785,10983786,10983787,10983788,10983789,10983790,10983791,10983792,10983793,10983794,10983795,10983796,10983797,10983798,10983799,10983800,10983801,10970810,10970811,10970812,10970822,10997012,10971107,10971108,11048340,11048341,11048342,10942073,10997142,10997143,10997144,10997145,10997146,10971261,10997262,10997263,10997270,10997346,10997347,10997348,10997363,10997389,10971436,10971437,11048664,11006636,11006637,10918561,10918562,10918563,10918564,10918565,10918566,11006771,10618122,10618123,11006802,10918684,10918711,10918712,11006866,10918726,11006982,11006983,11006984,10623362,10623454,10981113,10981114,10981115,10981116,10981117,10981118,10981119,10981120,10981121,10981122,10981123,10981124,10981125,10981126,10981127,10981128,10981129,10981130,10981131,10981132,10981133,10981134,10981135,10981136,10981137,10981138,10981139,10981140,10981141,10981142,10981143,10981144,10981145,10981146,10981147,10981148,10981149,10981150,10981151,10981152,10981153,10981154,10981155,10981156,10981157,10981158,10981159,10981160,10981161,10981162,10981163,10981164,10981165,10981166,10981167,10981168,10981169,10981170,10981171,10981172,10981173,10981174,10981175,10981176,10981177,10981178,10981179,10981180,10981181,10981182,10981183,10981184,10981185,10981186,10981187,10981188,10981189,10981190,10981191,10981192,10981193,10981194,10981195,10981196,10981197,10981198,10981199,10981200,10981201,10981202,10981203,10981204,10981205,10981206,10981207,10981208,10981209,10981210,10981211,10981212,10981213,10981214,10981215,10981216,10981217,10981218,10981219,10981220,10981221,10981222,10981223,10981224,10981225,10981226,10981227,10981228,10981229,10981230,10981231,10919083,10919084,10981232,10919085,10981233,10919086,10919087,10919088,10919089,10919090,10919091,10919377,10919378,10919379,10919380,10919381,10919382,10919398,10968576,10994618,10994619,10968620,10994728,10994729,10994730,10994737,10994738,10994739,10994774,10919728,10919729,10919730,10919744,10919745,10919746,10994944,10919932,10995083,10995084,10995085,10969492,10969493,10969494,10969495,10969496,10969497,10969498,10969499,10969500,10969501,10969502,10969503,10969504,10969505,10920361,10969544,10969545,10969546,10969547,10969548,10969549,10969550,10624959,10624960,11005623,11005624,11005629,10922487,10922488,10922489,10927492,11005704,11005705,10917597,10917598,10917599,10917600,10917601,10917602,10917603,10917604,11005775,10953951,10917838,10917839,10917840,10917841,10617500,10918081,11006351,11006352,11006353,10918229,10918230,10918231,10918232,10918425,10622916,10918426,10622920,11003628,10925501,10925502,10920525,10920526,10920527,11003797,10920716,11003897,10964948,10920825,10920826,10920829,11003991,10620364,11004031,11004032,11004033,10920897,10920898,10920899,10921015,10921016,10921017,11004230,11004236,11004238,10921142,10921143,10921144,10921145,10620669,10930606,10926262,11004413,11004424,11004426,11004428,11004429,11004430,10921302,11004492,10930765,11004494,10615836,11004588,11004589,11004594,10921447,10921448,11004597,11004598,11004599,11004600,10916549,10916550,10916551,10916552,10916553,10916554,10926555,10916555,10916556,10991737,10991738,10921631,11004976,11004977,11004978,11004979,11004980,11004981,11005007,11005008,10926896,11005098,10621627,10621628,10621629,10621630,10621631,10621632,10621633,10621634,10621635,10621636,10621637,10621638,10621639,10621640,10621641,10621642,10621643,10621644,10621645,10621646,10621647,10621648,11005403,11005404,11005405,11005406,11005407,11005431,11005432,11005433,10610994,10559220,10559221,10559222,10559230,10559231,9181425,10614236,10611365,10614641,10562891,10562892,10562893,10562894,8864740,8864746,8862274,8862275,8862276,8862277,8862278,8862279,8862280,8862281,10557582,10557583,10557584,10612538,7058177,10612705,10612856,9172393,9172399,7058709,8863139,9172908,10610742,10610743,10610744,9173264,4974245,9169402,4974379,7055849,4974554,9169719,4974606,7056093,7056094,10513756,10517812,10517815,10517816,10517817,10517818,10517819,10515837,10515838,10515839,10515840,10515841,10515842,10515843,10555902,7056262,7056263,7056331,7056497,7056498,10556152,10556153,10556154,10556155,2809260,2809261,9171165,9171195,9176495,9176505,9176635,9176728,10418776,9168951,7055339,7055340,7055341,10466954,10466955,4971331,9166531,9166532,9166533,9166534,9166535,9166536,9166537,9166538,9166539,9166540,9166541,9166542,9166543,9166552,4971441,4971568,4971569,4971570,10469536,10471555,10471556,10469583,10469596,10470028,9167643,6667745,10470416,10470419,10470541,10470543,10470673,8917856,10466826,10466827,10466828,10466829,10466830,10466831,10466832,10466833,10466834,10466835,10466836,10466837,10164691,10164692,10628236,10159938,10159939,10159940,10165113,10165114,10165290,10165291,10165299,10165300,10165340,10160790,10160791,10160792,10160793,10160794,10160795,10160796,10165797,10160797,10165798,10160798,10165799,10160799,10165800,10160800,10165801,10160801,10165802,10160802,10160803,10160804,10160805,10160806,10160807,10160808,10160809,10160810,10160811,10160812,10160813,10160814,10160815,10160816,10160817,10160818,10629530,10629536,10166150,10166205,10166206,10166207,10629803,10629844,10630095,10630105,10161919,10626375,10163324,10574165,10574166,10574167,10571168,10574168,10574169,10574170,10574171,10574172,10574173,10574174,10574175,10574176,10574177,10574178,10574179,10574180,10574181,10574182,10577254,10577255,10577256,10571268,10571269,10571270,10571271,10571573,10571587,10577650,10577651,10577652,10577653,10577654,10571679,10568797,10568798,10568799,10568807,10568808,10568809,10568810,10574829,10568931,10568960,10577977,10577978,10577979,10577980,10577981,10577982,10577983,10577984,10577985,10577986,10577987,10577988,10577989,10577990,10577991,10568992,10577992,10577993,10577994,10577995,10575031,10575032,10575033,10575040,10575041,10575042,10575043,10575044,10575045,10572069,10572070,10572097,10572098,10572099,10572100,10572101,10572102,10572103,10572104,10572110,10572111,10572112,10572113,10572114,10572387,10569462,10569463,10569464,10569465,10569466,10569467,10569468,10569469,10569470,10569471,10569472,10569473,10569474,10575719,10572781,10575930,10575988,10576028,10576029,10576030,10576031,10573160,10573161,10573162,10573163,10573164,10570205,10570206,10570207,10570208,10573306,10573307,10573308,10573309,10573310,10576873,10570903,10570904,10570905,10570906,10570907,10570908,10570909,10570910,10577029,10522610,10522611,10526914,10423269,10423270,10423271,10423272,10423118,10423147,10477982,10478146,10478147,10478254,10474286,10474287,10474288) 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'