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(7067818,10198077,10198078,10198079,10198080,10198083,8068895,7076013,10263519,10263520,10263521,10263522,10263523,7068366,10198667,10944084,10944085,8569709,8836763,8836764,7065870,7065871,8836875,7065872,7065873,8836889,8836890,7073965,7074045,10199419,10199420,10199421,10199422,10199423,10199424,10199425,7066254,7074294,10437244,10238629,10238630,10437405,8837463,8837464,8837465,10437441,10437458,10437459,10437460,10437461,10437462,10437463,10437464,10437465,10437466,10437467,10437468,10212785,10212786,8573254,10212787,7074668,10225931,10225932,10277993,10437745,10249068,10249069,10249070,10249071,10249072,10249073,10249074,10249075,10249076,10249077,10249078,10249079,10249080,10249081,10249082,10249083,10249084,10249085,7074850,7074851,7066887,8067908,7066988,7067007,7075024,8835254,4969625,4969626,4969627,8910890,7067393,8835420,8835421,10262680,8068462,8068463,7067663,7067664,10236910,7067679,7067680,10249919,10249920,7067684,10249930,10249931,10197942,10197943,10197944,10197945,10197946,10197947,10197948,10197949,10197950,10197951,10197952,10275998,10195154,10195155,10195156,10195157,10195158,10195159,8564323,8564324,8564325,10260560,7064519,7064520,7064521,7064522,7064523,7064524,10273853,10932300,10932301,10932302,10932303,10932304,10932318,10932330,10932331,10932332,10932333,10932334,8565126,8909561,10274215,10274216,10274217,10932443,10932444,10932454,10932455,10932456,10932457,10274259,10932473,10932511,10932512,10932513,10932514,10932515,10932516,10932517,10196322,10274335,7073229,8910012,8910013,8910014,8910015,8910016,7073498,7073499,7073507,10248812,10248813,10248814,10248815,10248816,10248817,10248818,10248819,10248820,10248821,10248822,10248823,10248849,10248850,10248851,10248852,10248853,10248854,10248902,10262043,10942546,10272141,10194239,7071227,10246512,8861186,8861187,10246585,10246684,10207759,10283078,10283079,10283080,10283109,10283110,10283141,10283142,10944769,10283633,10283634,10283635,10283636,10283637,10283638,10283639,10283640,10283641,10244915,10244916,8072728,8072729,8072730,8072731,8072732,10245243,8073002,10258450,10258451,10258526,10258599,10245601,10232753,10232754,10232755,10232756,10232757,10942283,10245882,10190163,10190164,10190184,10190185,10433058,10433059,10203212,10203213,10623329,10623423,10281831,10924289,10618904,10618905,10618906,10618907,10618908,10618909,10618910,10618911,10269004,10618912,10618913,10269005,10618914,10204009,10619077,10217190,10217191,10217192,10217193,10217194,10217195,10217196,10217197,10217198,10217199,10217200,10217201,10217202,10217203,10217204,10217205,10217206,10217207,10217208,10217209,10217210,10217211,10217212,10217213,10217214,10217215,10217216,10217217,10217218,10217219,10217220,10217221,10217222,10217223,10217224,10256234,10256235,10256236,10256237,10256238,10256239,10256240,10256241,10256242,10282445,10269662,10269663,10269664,10269665,10269666,10624823,10922483,10927572,10280461,10280462,10280463,10280464,10280465,10280466,10280467,10922903,10922904,10922905,10922906,10922907,10922908,10922909,10922910,10922911,10622408,10622409,10622410,10254522,10254523,10215625,10215626,10215627,10215628,10215629,10432542,10432663,10189812,10202848,10202849,10928269,10190013,10242021,10203022,10281036,10281037,10432905,10213132,10213134,10620123,8570034,8570035,8570036,8838192,8838212,10265552,10265553,10265554,10265555,10265556,10925984,10925985,10252572,10252573,10239861,10279010,10615984,10930967,10930968,10253264,10253265,10188312,10621371,10621372,10214483,10214484,10921923,10621575,10621576,10621577,10621578,10621579,10616699,10922210,10616700,10922211,10922212,10922213,10922360,10431826,10253981,10431887,10565156,9205436,7059726,7059727,9189653,9173837,10562682,10562683,9197873,9197874,9197875,9197883,9197884,10562738,10562739,10562740,10562741,10562742,10562743,10562744,10562745,10562746,10562747,10562748,9197998,9197999,9198000,9198001,9198002,9198003,9198004,9198005,9190208,9166243,9166244,9166245,9166246,9166247,9166248,9166249,10563152,10563153,10563154,10563155,10563156,10563157,10563158,10563159,10612159,10612160,9179592,10563420,10563421,10563422,8862165,8862166,10612326,9211878,9211900,9211901,10612633,9188037,9188038,9172038,9188039,9188040,9188041,7058320,10612843,9212212,9172240,9172241,9172242,9172243,9212336,9196397,9196398,9196399,9196400,9196401,9196402,9196403,9196404,9196432,9196433,10558326,10558327,10558328,10558329,10558330,10558331,10558332,10558333,10558334,10558335,10558336,10558337,10558338,10558339,10558340,10558341,10558342,10558343,10558344,10558345,10558346,10558347,10558348,10558349,10558350,10558351,10558352,10558353,10558354,10558355,10558356,10558357,10558358,10558374,10558375,10558376,10558377,10558378,10558379,10558380,10558381,10558382,10558383,10558384,10558385,10558386,10558387,10558388,10558389,10558390,10558391,10558392,10558393,10558394,10558395,10558396,10558397,10558398,10558399,7058801,7058810,9172649,8863284,9188850,9196932,8863469,8863470,8863471,9205002,9189014,9189015,9189078,10515117,10515118,9177311,9169329,4974199,9193347,4974200,9193348,4974201,9177591,4974485,4974486,9201689,9201690,9185799,10515615,10515616,10515617,10515618,10515619,10515620,10515621,10515622,10515623,10515624,10515625,10515626,10515627,10515628,9185820,9170030,9202163,9202289,10514109,10514110,10514111,10514112,10514113,10514114,10514115,10514116,7056491,7056492,7056823,7056824,7056825,10516636,10516637,10516638,10516639,10516640,9202963,9202964,9202965,9202966,9202967,9202968,9202969,9202970,9202971,9179050,9179051,9179052,9179053,9179054,9179055,9179056,9179057,9171197,9211198,9171243,10417365,4973434,4973435,4973436,10416518,10417534,10416554,4973512,4973513,4973514,4973649,4973650,4973651,4973661,4973662,4973674,9200871,9200872,4973737,4973738,4973739,4973740,4973915,4973916,4973917,9169264,9201292,9201293,8864988,9182471,9182472,9174534,9174535,9174536,8916386,8916387,6666864,6666865,6666866,10467447,10467448,10467449,8916795,10469750,4972105,9191310,9191311,8917025,6667417,6667418,6667419,6667420,6667421,6667451,10464039,9175464,8917113,6667475,9167541,9175543,8917191,6667727,9167899,8917582,8917592,10466525,10466526,10466527,10466528,10466529,10466530,6667955,9175972,6668162,6668180,9176197,10184533,10184534,10184535,10169576,10169577,10174943,10174946,10174964,10160014,10160015,10160016,10160017,10160018,10160019,10628583,10175209,10175210,10175211,10175212,10175213,10175214,10175215,10175216,10175217,10175218,10175219,10175220,10175221,10175222,10175251,10175252,10175253,10175254,10175255,10175256,10175257,10175258,10175259,10175260,10175261,10175262,10175263,10175264,10175265,10175266,10175267,10175268,10175339,10175340,10175341,10175342,10175343,10175344,10175345,10175346,10175347,10175348,10175349,10175350,10947899,10947900,10166455,10166456,10173486,10173487,10173488,10173489,10173490,10173491,10173492,10173493,10168671,10168672,10168673,10168674,10168675,10168676,10168677,10168678,10627354,10183926,10183927,10163937,10183959,10164053,10164054,10627551,10184186,10184187,10184188,10184197,10184260,10627948,10630061,10630102,10630114,10162022,10177179,10177221,10177222,10172359,10172360,10172388,10177455,10162836,10162837,10162838,10162839,10162840,10162841,10178223,10178224,10178225,10178226,10178227,10178228,10178229,10178230,10178231,10586361,10586362,10586363,10586364,10586365,10586366,10586367,10586368,10586369,10586370,10586371,10586372,10586373,10586374,10586375,10586376,10586377,10586378,10586379,10586380,10583460,10583461,10583462,10583463,10583464,10583465,10583466,10583467,10571471,10571472,10571473,10571474,10571475,10571666,10586774,10586775,10586776,10586777,10586778,10586779,10586780,10586781,10586782,10586783,10586784,10586785,10571926,10568953,10584365,10584366,10584367,10584368,10569566,10569567,10569568,10569569,10569746,10569747,10575850,10575851,10575852,10591013,10591014,10585054,10591456,10591457,10591458,10570653,10570654,10570655,10570656,10570657,10588702,10588703,10588704,10579730,10523235,10523236,10527258,10527259,10527260,10527318,10521845,10521846,10523846,10521847,10519850,10519851,10536687,10536688,10520820,10523075,10423264,10424464,10420490,10423693,10421040,10423129,10472936,10472937,10472938,10472939,10472940,10472941,10472942,10472968,10472984,10473157,10473158,10473159,10473188,10473189,10473190,10473191,10477290,10477293,10477294,10473692,10473850,10473851,10473852,10473853,10473854,10473855,10473856,10473857,10473858,10473867,10473869,10473870,10473871,10473872,10473873,10473874,10473925,10474035,10489234,10474273,10474274,10480431,10480432,10480433,10480434,10480435,10480436,10480437,10480438,10480439,10480440,10480441,10480442,10480443,10480444,10480445,10480446,10472534,10472535,10489643,10489644,10489645,10489646,10489647,10482857) 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'