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(10939585,10939614,10939647,10939648,10939649,10975762,10975763,7076114,7076128,7068249,7068250,7068260,7076371,8569661,10963386,10963526,10944262,10963527,10963528,10963529,10963530,10963531,10963532,10963533,10963534,10963535,10963536,10963537,10963538,10963539,10963540,10963541,10963542,10963543,10963544,10963545,10963546,10963547,10963548,10963549,10963550,10963551,10963552,10963553,10963554,10963555,10963556,10963557,10963558,10963560,10963561,10963562,10963563,10963564,10963565,7065943,7074021,7066237,7074339,7074340,8067319,8067320,7074353,7074354,10437308,8067525,10964334,10964335,10964336,10964337,10964338,7066680,10437560,10437569,7074773,7074774,7074775,7074776,7066917,8067911,8067912,10961955,10961956,10961957,7075434,10962198,10962234,7067650,7067651,7067704,10939382,10962466,10962474,7075857,7075858,10962569,7075904,10962601,6000232,6000233,6000234,6000235,6000236,6000237,6000238,6000239,7064023,7072082,7072241,7072246,7072298,7064310,10960044,10960045,10960046,7072550,7064663,10960508,10960509,10960510,10960511,10960512,10960648,10960650,10960651,10960652,10960653,10960654,10960655,10960656,10960657,10960658,10960659,10960660,10960661,10960664,10960665,10960666,10960667,10960668,10960669,10960670,10960671,10960672,10960675,10960676,10960677,10960678,10960679,10960680,10960683,10960684,8066075,7073153,7073330,7073331,7065365,10932788,10932789,10932793,10932794,10932795,7073614,10932971,10932972,7065664,7073667,7073668,4968136,4968137,4968138,10942595,10942655,10942775,7071557,7071558,7071559,7071560,10972396,7069180,7069377,7069591,7069672,7069675,7069676,3656367,3656368,3656369,7070059,3656658,3656659,10941815,3656912,11048475,11048476,11048641,7070780,7070859,10967800,10967801,10967802,10967823,10967824,10967825,10967826,10928685,10928686,10928687,10928688,10928689,10928690,10928691,10928692,10928693,10928694,10928695,10623244,10623245,10623246,10618265,10618271,10618288,10618289,10618290,10618291,10618292,10618293,10623367,10623458,10623605,10623606,10619114,10619115,10619116,10619129,10619130,10619131,10619132,10619133,10619134,10619135,10619136,10619137,10619138,10619139,10619140,10619141,10619142,10619143,10619144,10619145,10619146,10619147,10619148,10619149,10619150,10619228,10619895,10617048,10617049,10617050,10617068,10617101,10617109,10617137,10966808,10966809,10966810,10617152,10966811,10966812,10617160,10966836,10966837,10617223,10917856,10917857,10622363,10622409,10617456,10622506,10622514,10622528,10928294,10622811,10622812,10622818,10622819,10620006,10620007,10620008,10620009,10615037,10615080,10620083,10620116,10615138,10964981,10964982,10615339,8570310,10615532,10615536,10615556,10965292,10965293,10965310,10965311,10965312,10965313,10926270,10615884,10615957,10615983,10615985,10930942,10621044,10621046,10621049,10916640,10916641,10916642,10916643,10916644,10916645,10916646,10916647,10916648,10916649,10965831,10965832,10965833,10965834,10965835,10965836,10965837,10965838,10965839,10965840,10965841,10965842,10965843,10965844,10926837,10966027,10966028,10966029,10966030,10966031,10966032,10966033,10966034,10966035,10966036,10966037,10966038,10966039,10966040,10966041,10966042,10966043,10966044,10966045,10966046,10966047,10966270,10966271,10966272,10966273,10966274,10966275,10966276,10966277,10966278,10966279,10966280,10966281,10966282,10966283,10966284,10966285,10966286,10966287,10966288,10966289,10966290,10966291,10966292,10966293,10966294,10966295,10616655,10922178,10927201,10927202,10927203,10927204,10922234,10922235,10922236,10922237,10922238,10922239,10922240,10922241,10922242,10922243,10922244,10922245,10922246,10922247,10922248,10922249,10922250,10953441,10616804,10922438,10922439,10565127,10565195,10562208,10562215,10614086,10614089,10562267,10562268,10562269,10614201,10614245,10614246,10614256,10611256,10614260,10614261,10614264,10614267,10614282,10611338,10614414,10562611,10562612,10614463,10562613,10614464,8864333,10559628,10559636,10559637,10559638,10559639,10559640,10559641,10559642,10559643,10559644,10559645,10559646,10559647,10559648,10559649,10559650,10559651,10559652,10614572,10614592,8864463,10611762,10611785,10611825,8864784,10611930,8864791,8864792,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,10611980,10611981,10611983,7057601,10612103,8861980,7057751,7057752,7057753,7057754,7057755,7057756,7057757,7057758,7057759,7057760,7057761,7057762,7057763,7057764,7057765,10612272,10612348,10612428,10612483,10612484,10612535,10612542,10612583,10612584,10612635,10612639,10612664,10612681,10612706,10612717,7058245,7058251,8862639,7058305,7058317,7058318,10612840,10612866,10612870,10612882,7058407,10612910,10609980,10564139,10564140,10564148,10564199,10610055,10558208,10558209,10558210,10558211,10558212,10558213,10613064,10558214,10558215,10558216,10558217,10558218,10558219,10558220,10558221,10558222,10558223,10558224,10558225,10558226,10558227,10558228,10558229,10558230,10558231,10558232,10558233,10558234,10558235,10558236,10558237,10558238,10558239,10558240,10558241,10558242,10558243,10558244,10558245,10558246,10558247,10558248,10558249,10558250,10558251,10558252,10558253,10558254,10558255,10558256,10558257,10558258,10558259,10558260,10613111,10558261,10558262,10558263,10558264,10558265,10558266,10558267,10558268,10558269,10558270,10558271,10558272,10558273,10558274,10558275,10558276,10558277,10613154,10610189,10613210,10613232,10613233,10613234,10613259,10610259,10613293,10613294,10613295,10613296,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,7058828,7058829,7058844,10613356,10613357,10613365,10613367,10613368,10610371,10610374,10558541,10558558,10558559,10558560,10558561,10610466,10610468,10610491,10610495,10610496,10561698,10561699,10561700,10562071,10562072,10517112,10517113,10517114,10517115,10517116,10515122,10515123,10515124,10517142,10517143,10517144,10517149,10517150,10517151,10517152,10517153,10511153,10517154,10511154,10517155,10511155,10517156,10517157,10517158,10517159,10517160,10517161,10517162,10517163,10517164,10517165,10517166,10517167,10517168,10517169,10517179,10517180,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,10517286,7055697,7055835,4974564,10517569,10517570,10515600,10513625,4974667,4974668,4974669,10515680,10515681,10513723,10513724,10513725,7056106,7056107,7056113,7056114,7056130,7056160,10517812,10517813,10517814,10513995,4975255,4975282,4975283,4975284,2809379,10512765,7057189,10517042,10517043,10517044,10517045,10517046,10517047,10517048,10517049,10517050,10517051,10517052,10517053,10517054,10517055,10517056,10517057,10517058,10517059,10517060,10517061,10517062,10517063,10517064,10517065,10517066,10517067,10517068,10517069,10517070,10517071,10517072,10517073,10517074,10517075,10517076,10517077,10517078,10517079,10517080,10517081,10517082,10517083,10517084,10517085,10517086,10517087,10517088,10517089,10517090,10517091,10517092,10517093,10517094,10517095,10517096,10517097,10517098,10517099,10517100,10517101,10517102,10517103,10517104,10517105,10517106,10517107,10517108,10517109,10517110,10517111,10418243,10418244,10418245,10418246,10418247,10419374,10419393,10416401,10416404,10416416,10416418,10417527,10417528,8918264,10416547,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10416604,10416605,10416606,10416607,10416608,10418781,10418981,10419012,10419021,10420200,10420201,10420202,8864901,4971351,10467104,8865116,8865119,10471543,10471544,8916773,8916815,10469768,10469851,8563203,10469912,10469916,10469919,10469921,10469949,10467997,10468012,8917091,8917094,10468033,10468056,10468106,8917238,8917239,10468350,10468357,10468362,10468410,10468411,10468412,10468413,10468414,10468415,10468416,10468417,10468418,10468419,10468420,10468421,10468423,8917494,10470650,8917794,8917855,10466856,10466857,10466858,10466859,10466860,10466861,10466862,10466863,10466864,10466865,10466866,10628020,10628162,10628489,10628525,10628526,10628537,10629700,10627288,10627291,10627323,10627772,10627790,10627791,10627792,10627793,10627918,10625372,10626130,10626498,10568385,10568386,10568387,10568388,10568389,10568390,10568391,10568392,10568393,10568394,10568395,10568396,10568397,10568398,10568399,10568400,10568401,10566597,10520302,10520303,10520316,10520317,10520318,10520319,10520320,10520321,10520322,10520323,10520324,10520325,10520326,10520327,10520328,10520329,10520330,10520331,10520332,10520333,10520334,10520335,10520336,10520337,10520759,10520765,10520781,10520797,10520919,10520945,10520946,10520948,10520949,10520950,10520951,10520952,10520953,10520954,10420311,10420312,10420412,10420416,10420524,10420525,10420528,10420533,10420534,10421197,10473632,10473694,10473695,10473696,10472532) 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'