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(11014762,11014763,10939713,11014775,10939714,10939715,10939716,11001793,10988881,10988882,10988893,11014900,10988922,10988932,10988933,10988934,10988945,11001965,11015024,11015025,11015028,11015029,11015032,11015033,11015035,11015036,11015037,4970684,7068600,10963493,11015670,11015700,11015715,11015723,11015724,11015728,11015729,11002731,11015738,7074277,8067374,8067448,7066581,7066582,7066583,11016280,11016297,11016298,11016306,11016313,11016321,7074690,7074691,7074693,7066745,7066867,10964558,10964559,4969252,7075187,7075188,7075189,7075190,7075191,7075192,7067227,10939382,7067778,7075832,11014526,11014527,11014528,11011854,11011855,11011856,7064218,10972905,7072229,8065210,8065219,11011936,11012008,11012047,10999125,10999127,10999128,10999129,10999130,10999133,10999135,10986212,10986226,10986227,10986228,10986248,10973348,11012361,11012363,10973364,10999671,10999672,10999673,10999674,10999676,10999677,10986773,10999796,10932729,10961099,10961100,10961101,10961102,10961103,10961104,10961105,10961106,7073450,7073451,10961137,10961138,10961139,10961141,10961142,10961143,10961144,10961147,10961149,10961150,10961233,7073626,10961311,10933039,10933040,10933070,11013457,10961500,10961508,10961516,7073843,11013563,7073885,7073888,7073889,7073890,11013583,11013596,11013597,11013598,11010766,11010767,11010768,11010769,11010770,11010771,11010772,11010773,10984774,11010774,11010775,10984776,10997874,10984950,10984951,10984952,10984953,10985050,10985051,10985052,10985053,11049279,11049386,5999942,5999978,5999979,5999980,5999981,10959393,11011414,10985449,11011450,11011451,11011487,11011538,6000198,10944384,3655793,7069319,7069323,7069324,7069325,10944882,10944883,10957159,3656055,10941131,3656083,10996247,7069645,11009336,11009337,11009338,11047604,10996414,10957503,8072654,3656630,11048313,10997186,11048405,10958210,10958211,10958212,10958213,10958214,10958215,10958216,10958217,10958218,10958219,10958220,10984338,7070743,10958566,10958569,11010605,10623041,10967763,10618106,10954793,10954794,10967895,10618265,10618271,10618273,10618274,10618275,10618276,10618282,10618284,10618287,10618288,10618289,10618290,10618294,10618298,10618300,10618301,10993963,10618321,10923840,10955180,10924066,10924070,10994271,10994286,11007327,10919196,11007371,10994372,11007372,10994402,10994403,10994404,10994405,10994406,10994407,10994408,10994409,10623833,10623834,10623835,10623836,10623837,10623838,10623839,10623840,10623860,10623872,10623873,10924402,10994551,11007695,11007702,11007703,10624098,10924645,10994795,10924654,10919837,10969003,10969015,10624663,10619894,11005629,10927481,11005632,11005633,11005639,11005643,11005652,11005659,11005664,11005665,11005666,11005668,11005670,11005671,11005672,11005673,11005674,11005675,11005676,11005677,11005678,11005679,11005694,10617037,10617041,11005714,11005715,11005716,11005717,11005735,10927606,11005758,11005762,11005763,10617177,10917689,10927707,10927708,10927709,10927710,10927711,11005860,11005861,10917752,11006052,10622409,11006180,11006181,11006184,10928098,10954295,10928227,10928228,11006432,11006433,11006434,11006454,11006457,10915472,10619999,10620000,10964743,11003821,10615200,10615202,8570164,10620303,10920850,8570314,10615389,11004108,10920970,11004149,11004158,11004159,11004160,11004161,11004162,11004163,11004164,11004165,11004166,11004167,11004168,11004169,11004170,11004171,11004172,11004173,11004174,11004175,11004176,11004177,11004178,11004179,11004180,11004181,11004182,11004183,11004184,11004185,11004186,11004187,11004188,11004189,11004190,11004191,11004192,11004193,11004194,11004195,11004196,11004197,11004198,11004199,11004200,11004201,11004202,11004203,11004204,11004205,11004206,11004207,11004208,11004209,11004210,11004211,11004212,11004213,11004214,11004215,11004216,11004217,11004218,11004219,11004220,11004221,11004222,11004223,11004224,11004225,11004226,11004227,11004228,10926080,11004229,11004230,11004231,11004232,11004233,10926085,11004234,10926086,11004235,10926087,11004236,11004237,11004238,11004239,11004240,11004241,10926093,11004242,11004243,11004244,11004245,11004246,11004247,11004248,11004249,11004250,11004251,11004252,11004253,11004254,11004266,11004267,11004269,11004270,11004275,11004276,11004292,11004296,11004322,11004334,10991341,10991342,10991348,10991352,10991353,10926254,11004414,10926280,10926281,10926282,10926283,10926284,11004439,11004461,11004468,11004469,11004471,11004472,10615818,11004486,11004487,11004490,11004494,11004496,11004497,11004498,11004499,11004501,11004503,11004513,11004514,10615859,10615860,11004539,11004544,11004545,11004548,11004563,11004564,11004580,11004595,11004629,11004639,11004640,11004641,11004642,11004643,11004644,11004645,11004646,11004647,11004648,11004649,11004650,11004651,11004652,11004653,11004654,11004655,11004656,11004657,11004658,11004659,11004660,11004661,11004662,11004663,11004664,11004665,11004666,11004667,11004668,11004669,11004670,11004671,11004672,11004673,11004674,11004675,11004676,11004677,11004678,11004679,11004680,11004681,11004682,11004683,11004684,11004685,11004686,11004687,11004688,11004689,11004690,11004691,11004692,11004693,11004694,11004695,11004696,11004697,11004698,11004699,11004700,11004701,11004702,10621060,10931014,10952759,10921763,10921767,10921768,10917012,10616510,10922195,10616701,10616895,10927437,10927446,10922457,10610990,10610995,9165380,9165381,9165418,9165419,10611120,10611121,10611162,10565328,10565329,10565330,10562334,10562413,10562414,10611279,10614282,10614316,10614414,8864300,10614464,10559623,9173899,9173900,8864455,8864456,8864457,10611598,8864561,10611702,10611707,8864619,10611775,10565929,6666138,6666139,6666140,6666141,8864668,8864776,10612086,10612134,10609187,10612204,10612205,10612311,10609350,10609351,10609352,10563700,10563795,10563796,10563813,10609730,9172077,10563924,10563925,10563936,10563937,7058408,9172249,9172250,8862827,8862828,7058493,10564141,10564142,10613036,10610041,10610055,10613068,8862951,10613100,10613101,7058606,10613356,10613357,10613371,10610697,10610780,10515119,10515120,4974266,4974267,4974322,10513386,10513401,4974643,9169823,9169871,7056140,10513823,10513824,9170011,4974921,4974926,10514015,10514031,10514032,10514033,4975159,10514129,10514130,10514133,10514158,10514159,10514160,4975216,2809105,10514415,10514416,10512585,10512586,10512587,10512588,10512589,10512590,10512591,10512592,10512593,10512594,10512595,10512596,10512597,10512598,10512599,10512600,10512601,10512602,10512603,10512604,10512605,10512606,10512607,10512608,10512609,10512610,10512611,10512612,10512613,10512614,10512615,10512616,10512617,10512618,10512847,9171051,9171078,9168353,9168415,9160486,9160517,4973514,4973517,4973557,10416709,9168847,4973704,10416780,10416781,10416798,9168992,4973897,10420061,8864868,8864869,8864873,8864900,6666470,4971353,4971381,8865148,10471457,9167281,10465910,8916990,6667442,6667474,10464066,10466252,4972706,9167965,10464634,9168070,8917721,6668123,10462723,10462724,10462725,10462741,10470809,9168282,10159532,10628086,10628087,10628088,10628089,10628090,10628091,10628092,10164777,10628311,10155111,10628799,10628801,10628910,10628925,10629236,10629237,10629238,10155842,10629358,10629359,10629360,10629361,10165923,10166168,10629710,10156288,10163497,10163498,10163499,10163502,10163712,10163713,10163714,10627280,10627322,10163886,10163927,10163928,10163929,10163930,10163931,10627724,10154331,10154348,10630047,10161604,10625927,10625942,10625943,10625944,10625955,10162769,10162770,10162771,10162772,10162773,10162774,10162775,10162776,10162777,10162778,10162779,10162780,10626267,10577360,10577389,10574876,10566113,10566114,10566115,10566116,10566117,10566198,10566199,10566200,10566201,10566202,10566203,10566204,10566205,10566206,10566207,10566208,10566209,10566210,10566211,10566212,10566213,10566214,10566215,10566216,10566217,10566218,10566219,10566220,10566221,10566222,10566223,10566224,10566225,10566226,10566227,10566228,10566229,10566230,10566231,10566232,10575414,10575415,10572472,10572473,10570262,10570270,10573396,10573397,10573552,10573553,10573554,10573555,10573556,10573602,10567687,10567688,10567692,10567693,10567695,10567697,10567698,10567699,10567700,10567701,10567702,10567703,10567704,10567705,10567707,10567708,10568090,10525165,10521180,10521187,10521188,10521189,10525206,10521654,10523728,10521746,10521885,10521886,10522100,10522366,10522370,10522375,10522554,10522555,10522598,10524632,10524633,10522898,10520909,10524923,10524924,10524925,10527085,10527086,10527087,10527088,10527089,10527090,10527091,10527092,10527093,10423226,10423234,10423239,10423536,10420572,10423627,10422671,10423962,10423999,10424000,10423205,10478162,10474248,10474249,10474250,10474251,10474252,10474253,10474254,10478401,10476549,10476550,10476551,10476552,10478554,10474649,10474650,10474651,10474652,10474653,10474654,10474655,10474656,10474657,10474712,10474713,10474714) 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'