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(10939618,11001744,7068072,7076123,7076129,10861462,10448130,10870710,10448383,10861836,10861837,10448469,10940507,10846544,7065833,10868247,10950607,10950885,8631922,8631923,4968623,8631955,8631956,10849659,7066375,10847129,10951003,7066378,7066379,7066381,10849713,10871812,8632193,8632195,8622408,10437560,8622460,8632279,10964447,7066766,10850060,8837331,3227259,3227262,8067903,8629582,8629583,8629584,8837460,10938791,8629745,8629787,8629809,8629821,8629822,8629823,8629824,10860470,10860599,10860697,11001097,11001098,7067452,10929847,7075578,8630247,8630315,10860964,10858114,10858115,10858121,10858123,10858124,10858131,10858132,10858133,10858134,10858135,10858139,10858141,10858142,10858143,10858165,10858174,10858175,10858187,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8911036,8627629,8627634,11011911,8559173,8559386,8911508,10866804,10866816,10866817,10866818,10866827,10866837,10866838,10866840,10866843,10866844,10866847,10866850,10866871,10866872,10866873,7064587,10866874,7064592,8559576,8559577,7064736,7064761,10960474,8559749,8559750,8559751,8559752,7202066,10843577,10843578,7202071,10843579,10986516,10103986,7064863,8065953,8065956,7064911,7064912,10843716,7064977,10843732,7064984,7064985,7064986,8628660,10859528,8836824,10844217,8596159,8629251,8837098,8629268,8629269,8629270,10859921,8629286,10859941,10859956,10859967,10859978,10859979,10859990,8626515,10857163,10857164,3237363,10857235,10942715,10942743,11036718,8860980,10942799,10942804,10942812,10942817,10865404,10865406,10865411,10857466,3927590,10943044,10865627,8626997,10943113,7071514,8910575,7071523,7071524,4430186,10857915,10857938,10857947,10857965,10858000,10858003,8627362,8558674,10858019,10858020,10858024,8627384,10858028,10858032,10858033,10858034,10858035,10858036,10858044,10858045,10858069,10858070,10858071,10858074,10858075,10858076,10858087,10858090,10858092,10858098,10839624,10944411,8555891,8624700,8624748,10944733,8624877,8624878,8624879,8624883,8624885,8624897,8624902,8624904,8624921,8624922,10855602,10863634,10863635,10840149,7198678,7198696,7198697,8908520,7198713,7198717,7198723,7198739,7198752,7198759,7069606,10941391,3926187,10856221,10856222,10856223,10856224,10856225,10856228,10856229,10856230,10856231,10856232,10856234,10856235,10856236,10856238,8615798,8615800,8909075,8909076,8909078,8909080,8909081,3236570,10941948,10941961,10101410,7070342,10101518,10942147,8557446,8626329,8626330,8626331,8626332,10837649,10853232,10853233,10853234,3233411,3233426,11045724,11045725,3923448,10853393,10853394,10853492,8613073,7196524,10853637,10853642,3924148,10838514,10838521,8554717,10838525,10968462,3234368,3234371,3234373,10838816,10838969,7197655,10624632,10624633,3234941,7197769,7197771,3234947,3234975,3234976,3234979,10619894,10619905,10855057,10855091,8634464,3232243,10953509,10953511,3232250,3232255,8634485,3232259,8634486,3232261,8634494,3232268,8634495,8634498,3232272,8634499,3232273,3232276,8634506,8634507,3232280,3232281,3232282,3232284,3232285,8634512,3232286,8634513,8634516,3232290,8634521,3232298,8634527,8634531,3232306,8634533,8634534,3232308,8634535,8634536,8634537,8634538,3232312,8634539,3232313,8634540,8552906,3232411,3232413,3232426,3232439,3232458,3232464,3232466,3232467,3232468,3232477,8541573,10852362,10852363,10852364,10852365,11044798,11044801,11044802,11044805,11044807,11044808,11044809,11044810,11044811,10617366,10617367,10617368,10617370,10852524,10922895,10852572,11045018,10852642,10852643,3923007,3923072,3923092,3233157,8632461,8632542,8632575,10990760,10990761,8570117,10615341,10615342,10964891,10964892,10848007,8610133,8610174,8610176,8610179,8610180,10850648,10850687,8633068,10850716,8570413,8570444,8633151,8633154,8610362,8633183,10848386,10848408,10848409,8610498,8610500,8633340,10930720,8610643,10426193,10616016,8540446,10952582,10426339,10616210,10616211,10616219,10616220,8540588,10616228,10616229,10616248,10616252,10616253,10616258,10616267,10616268,10616287,10616295,10616298,10616302,10616303,10616311,10616323,10616324,10616329,10616341,10616342,10616348,10616350,10616351,10616353,3231643,10616375,8904297,10616387,10616389,10616393,10616394,10616395,10616397,10616400,10616401,10616407,10616410,10616411,10616412,10616416,10616423,10616430,10616431,10616440,10616441,10616443,10616453,3231796,3231799,3231800,3232020,10927265,10927266,3232067,3232068,3232074,8634343,3232152,3232153,3232169,3232172,3232183,3232195,3232198,3232199,8634453,8634454,8634458,10613985,9189355,9189356,9189357,10614038,10614039,10614040,8853233,7059757,9173716,9173718,9173721,9173726,9173729,9173739,9173743,8864279,10611423,8853604,8864323,3655014,10614497,9174072,10611913,10611917,10611921,10611931,10611935,10611940,10612013,9211541,9211548,9211550,9211553,10609313,8862481,10609839,3653392,8566690,9188248,10612939,9196358,7058534,8862959,10613116,3653906,10561524,8852578,8852607,8852632,9212837,10613736,9173114,9197198,9197260,9197275,9161475,6673694,9161492,8592648,7055723,4974543,9161894,9161896,8849890,8849891,8849910,8849911,8850060,9186541,3651961,9178825,10518666,10518684,10518689,10518701,10518704,7057197,3652290,9913357,8848153,4973308,10419495,10415576,10419668,10415680,10419681,10419682,10419684,10419693,10418704,10418707,10419708,10419709,10419711,10419714,10419715,10419718,10419721,10419753,10419754,10419755,10419756,10418857,10419897,9911184,9169078,9169079,7055299,9193213,10417141,10417142,9193221,8568858,8568859,8568921,8568922,10463003,10122643,10122644,10463030,10463032,10471171,4971471,4971473,10467220,6666650,8549957,10469382,10463400,9166826,9166828,9166855,9199084,10463730,10463740,10463754,10465768,10465776,9167233,6667234,8563251,976376,976377,976378,8917337,9207724,10466304,976583,10462402,10462727,10466846,10466853,10628177,10889162,10889172,10889201,10889202,10889210,10889213,10889224,10889226,10890148,10176279,10176288,10176315,10887474,10887477,10632162,10632165,10632311,10632313,10184032,10184033,10883137,10883138,10627775,10883358,10883359,10176498,10905819,10905820,10905821,10162081,10172176,10891323,10891324,10891325,10891326,10891327,10886589,10172749,10886803,10886804,10886805,10886806,10886807,10886808,10886809,10886810,10886811,10886812,10886813,10886814,10881971,10173121,10892162,10892165,10892177,10892182,10892209,10892218,10892222,10892227,10163475,10887463,10568115,10568126,10568127,10568313,10580368,10601397,10601401,10598861,10646959,10647184,10590270,10590271,10590277,10590283,10590289,10590302,10590303,10590306,10606260,10644482,10647571,10603777,10654342,10582588,10649021,10551153,10551158,10529374,10529383,10529386,10529397,10529419,10527841,10519993,10532142,10532145,10532148,10546226,10532261,10548567,10548571,10530572,10530573,10499120,10499122,10422348,10420629,10420848,10498758,10424871,10507876,10507901,10507071,10407299,8562284,10411312,10411313,10411314,10411315,10411316,10411317,10411318,10411319,10411320,10411321,10411322,10411323,10411325,10409427,10407494,8562502,8562503,10409550,10409551,8562608,10409665,10486503,10407947,10496616,10407971,10411979,10411980,10413984,10496904,10496907,10410270,10496941,10414317,10496989,10414344,10414350,10414363,10478019,10414371,10414372,10414386,10412500,10412522,10412533,10412552,10412586,10412589,10493253,10412603,10412604,10412608,10412612,10412616,10412617,10412625,10493300,10412648,10412649,10412650,10412653,10412654,10412655,10412666,10412669,10412671,10412678,10412692,10412693,10412695,10412696,10412703,10412704,10412705,10412706,10412707,10412710,10412712,10412713,10412729,10412742,10412743,10412744,10412758,10410768,10408988,10409025) 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'