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(10250146,10250149,10263213,10263214,10263215,10263216,10263217,10263251,10263252,10263253,8836035,7068138,10250387,10250388,8836288,10224525,10224526,10224564,7076353,8836439,10237766,10237767,10237768,8836729,8836730,8836731,8836732,8836733,8836734,8836735,8836736,8836737,8836738,8836739,8836740,8836741,8836742,8836743,8836744,8836745,8836746,8836747,8836748,8836749,8836750,8836751,8836752,8836960,10277240,10277241,7074112,7074113,10277469,7074252,10199505,10199506,10277515,10277516,10277517,8837409,8837410,10264845,8837625,8837701,8837757,10252046,10252047,10252048,10197114,10197115,10197116,10197121,10197122,10197123,7074910,10197158,8910524,7074988,7074989,10262322,10262323,10262324,10262325,10262326,8835203,10262461,10262462,10262463,10262464,8835363,8910959,8910995,7075499,10262829,10234267,10234268,10234269,10234270,10234348,10234349,10234350,10260369,10260370,10260371,10260388,10234402,7072194,8909142,8909143,7072594,7072605,7072606,7072805,7072806,7072857,7072900,7072901,10235176,10235178,10209184,10261216,10261217,10261218,7073015,10235286,10235287,10209313,10209408,10235450,10222567,10209651,10261917,10261958,10261960,10261961,10207181,10207182,10207183,10285277,10272367,10272368,10272369,10272398,10259462,10259463,10259464,10259465,10259466,10259467,10272489,10272490,10207554,10207882,10943418,7071704,10244074,10244130,10244133,10270146,10270147,10270148,10270149,10205288,10270502,10270503,10205609,10205610,10205611,10205612,10205613,10205614,10205615,10205616,10205617,10205618,10205619,10205620,10205621,10205622,10205623,10205624,10205625,10205626,10270659,10270775,10270776,10244854,10244884,10244886,10245012,10245024,10245052,10271241,10271242,10232267,10271295,10271296,10271297,10271298,10271299,10271300,10271301,7070078,10206488,10271517,10271518,10271519,10271520,10271521,10271522,10271523,10271524,10271525,10245551,10232570,10232571,10258589,10258590,10258632,10232652,10232653,10258691,10258692,10232718,10232719,10284771,10284784,10206855,10206856,10206857,10206858,10284904,10284905,10258922,10284922,10284923,10245945,10245946,10245947,10245948,10271948,10271949,10245949,10245950,10271950,10245951,10271951,10245952,10271952,10245953,10271953,10245954,10271954,10245955,10271955,10245956,10245957,10245958,10245959,10245960,10245961,10245962,10245963,10258963,10258964,10245964,10245965,10258965,10245966,10245967,10245968,10245969,10245970,10245971,10245972,10245973,10245974,10245975,10284975,10245976,10245977,10284978,10245978,10245979,10245980,10245981,10245982,10942459,10245983,10245984,10245985,10245986,10245987,10245988,10245989,10245990,10245991,10245992,10245993,10245994,10245995,10245996,10245997,10245998,10245999,10246000,10246001,10246002,10246003,10246004,10246005,10246006,10246007,10246008,10246009,10246010,10246011,10246012,10246013,10246014,10246015,10246016,10246017,10246018,10246019,10246020,10246021,10246022,10246023,10246024,10246025,10246026,10246027,10246028,10246029,10246030,10246031,10246032,10246033,10246034,10246035,10246036,10246037,10246038,10246039,10246040,10246041,10246042,10246043,10246044,10246045,10246046,10246047,10246048,10246049,10246050,10246051,10246052,10246053,10246054,10246055,10246056,10246057,10242153,10242154,10242155,10242156,10242157,10242158,10242159,10268301,10268349,10242389,10255404,10623493,10255867,10255868,10242924,10268943,10268944,10268945,10268946,10619033,10619034,10619035,10619036,10619037,10619038,10619039,10619040,10269202,10269203,10269266,10269267,10269270,10243358,10243393,10243394,10269594,10269597,10269598,10243871,10243872,10243874,10243875,10244020,10617044,10267202,10202209,10202210,10617125,10241281,10267354,10267355,10267356,10267357,10267358,10267370,10267371,10267372,10267373,10267374,10267375,10241469,10202644,10241675,10241676,10241677,10241678,10241679,10241680,10241681,10241682,10241882,10920559,10265212,10265213,10265214,10920653,10920654,10920655,10265239,10265240,10265241,10265242,10265243,10265244,10265245,8570022,10252408,10252409,10252410,10252411,10920876,10252486,10252487,10920982,10921054,10921055,10921078,10921079,10921080,10921081,10921082,10252868,10615829,10620863,10615878,10253004,10253005,10921571,10921572,10240181,10240182,10253236,10253237,10253238,10921676,10240273,10921737,10921738,10921755,10921756,10921757,10253437,10253438,10253439,10201607,10240646,10240647,10240648,10240649,10253667,10253672,10240897,10279901,10279902,10279903,10279904,10240964,10240965,10201987,10201988,10201989,10201990,10559392,9190002,9174131,9166142,9166143,9166147,9166148,9190151,9190184,9203322,9195437,9195438,9203453,9203454,9203455,9203480,9187482,10612194,9195627,9195628,9195629,9195630,9195709,9195710,9187794,9187795,9187797,9203807,9187985,9203999,9204000,9204001,9196035,10612745,9204120,9204121,9204122,9188122,7058290,9188125,9196161,9196162,9196163,9204210,9204214,9188258,10612937,10612938,9204373,10613083,10613110,9204496,9204535,7058719,7058720,7058721,7058725,9204575,9204584,9196767,10558613,9172965,9189135,8863804,9193371,9193385,9193386,9193444,9193544,7055760,9193606,9193708,7055889,9193739,4974650,4974651,4974652,9201825,7056109,10515823,9194052,9194053,9194054,9194055,9194090,9194091,9194092,10513953,9202241,9202243,10516059,10516060,9202421,9194476,9202543,9202544,9202545,9202576,9202577,9194594,9194595,9194596,9170633,9170634,9186816,9202827,9202828,9202829,9202830,9202831,9202832,9202833,9202834,9202835,9194847,9194848,9194849,9194850,9194851,9194852,9194853,9194854,9194855,9194856,9171025,9171026,10517001,10517002,9203251,9203252,9203253,9203254,9203289,9160373,9200458,9176466,9184516,10419458,9184555,9176603,9176604,9176605,9176619,9176692,9176711,9176892,9177207,6666463,4971338,10471181,10467439,6666974,10469590,10469605,9191251,9191252,9191253,9191254,9191255,9175326,9175354,10469984,10469985,9175618,9175619,10470382,9175827,10470486,10470491,6667978,9200010,9200260,10164507,10164508,10164509,10164510,10164511,10164512,10164513,10164514,10164515,10174875,10174876,10174877,10174878,10174879,10174880,10174881,10174882,10174883,10174884,10174885,10179886,10174886,10174887,10174888,10174889,10174890,10174891,10174892,10174893,10174894,10174895,10174896,10179959,10179988,10179989,10165007,10180048,10180049,10165057,10180127,10180128,10180129,10165200,10165201,10165202,10165203,10165204,10180538,10180539,10180540,10180541,10180542,10165554,10165555,10165690,10165858,10170868,10180879,10180880,10180881,10180882,10180926,10180927,10180928,10629581,10629609,10181169,10181210,10181211,10181212,10629690,10181213,10181430,10181431,10629914,10629915,10629916,10629917,10181473,10181474,10183565,10183566,10183604,10183605,10183606,10183607,10183608,10183720,10183746,10168767,10168768,10168769,10168770,10163801,10627294,10163969,10164235,10184299,10184300,10184301,10174448,10181734,10181735,10181736,10181737,10166858,10181963,10181964,10166979,10166980,10166981,10182003,10182004,10167005,10182032,10182033,10167084,10182173,10182201,10182202,10167281,10167308,10172313,10172314,10182343,10182364,10177433,10177438,10182461,10182470,10162543,10182570,10182604,10182605,10182606,10626111,10182796,10182797,10172868,10172869,10172899,10182972,10177973,10177978,10177979,10177980,10177981,10183055,10183071,10183136,10163275,10183301,10183315,10183316,10183404,10183475,10183476,10571418,10577444,10574625,10586626,10574626,10568637,10568638,10568639,10580672,10580673,10571732,10571733,10574759,10574793,10574816,10574817,10574818,10574819,10571821,10571822,10571823,10571824,10571825,10571826,10577852,10577853,10577854,10577855,10577856,10577857,10577858,10577859,10577860,10577861,10577862,10578065,10578066,10578067,10578068,10584107,10584108,10584109,10584110,10575120,10575164,10575165,10575166,10572266,10572267,10572268,10572269,10572270,10572271,10572272,10572273,10572306,10575368,10575422,10575423,10575424,10575425,10575426,10575427,10575428,10575429,10575430,10575431,10578436,10578437,10578438,10569500,10569501,10566534,10566535,10572537,10569539,10569540,10569541,10569542,10575548,10575549,10575550,10575551,10584565,10575757,10575827,10581883,10569886,10569887,10569888,10584918,10584919,10584920,10573012,10570084,10570085,10579089,10579090,10579091,10579092,10579093,10579094,10579095,10579096,10570103,10576174,10570288,10579433,10570557,10570558,10570559,10570560,10579601,10579602,10588686,10573686,10573687,10571082,10571083,10521268,10525326,10529679,10529680,10529681,10522036,10522037,10528564,10528565,10528566,10522624,10534635,10534636,10528696,10534891,10534892,10534893,10534894,10526903,10526904,10526905,10526906,10526907,10526908,10526909,10526935,10526936,10527094,10527095,10527096,10529099,10420399,10477276,10477277,10477325,10477388,10473612,10477955,10477956,10478120,10478121,10480153,10480154,10480155,10476298,10478555,10476604) 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'