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(8068895,7076013,10939750,10939890,10939891,7068366,11015157,11015158,10976327,10976328,10976329,10989333,10989334,10944084,10944085,10963356,10963357,10963358,10963359,10963360,10963361,10963362,8569709,11041484,10976649,7073965,10976651,7074045,8067221,7066254,10950890,7074294,10950951,10437244,8067377,8067378,8067379,8067380,8067388,10437405,10437441,10437458,10437459,10437460,10437461,10437462,10437463,10437464,10437465,10437466,10437467,10437468,7074668,7074850,7074851,7066887,10437745,8837463,8837464,8837465,7066988,7067007,8067908,7075024,11013730,11013731,10961944,10961945,10961946,10961947,10961948,10961949,10961950,10961951,10961952,10961953,10961954,10962077,7067393,10962078,10962079,10962080,10962086,4969625,4969626,4969627,11001185,8068462,8068463,7067663,7067664,7067679,7067680,7067684,8838192,8838212,10939376,10939377,10939384,11040500,7067818,10962569,11014592,11027614,11027615,11027616,11027617,11027618,10998701,8065227,8065228,8065229,8065230,8065231,8065232,11025145,11025146,11025147,11025148,11025149,7064519,7064520,7064521,7064522,7064523,7064524,10960337,8065783,8065784,8065785,8065786,8065787,8065788,8065789,8065790,8065791,10932300,10932301,10932302,10932303,10932304,10932318,10932330,10932331,10932332,10932333,10932334,11038777,10932443,10932444,10932454,10932455,10932456,10932457,10932473,10932511,10932512,10932513,10932514,10932515,10932516,10932517,8066180,8066181,7073229,8836763,8836764,11013029,11013030,8836875,8836889,8836890,11000089,11000090,8066458,7073498,7073499,7073507,7065870,7065871,7065872,7065873,11036636,7071227,11049205,11049206,11036991,11036992,11036993,11037034,11024038,11037105,10959246,10959247,10959248,10959249,10959250,10959251,8064660,8064661,8835254,8835420,8835421,11021841,11035023,10944769,8564323,8564324,8564325,11009413,11009414,11009415,11009416,11009417,11009418,11009419,11009420,11009421,11009444,11009445,11009446,11009447,11009448,11009449,11009496,11009661,11009662,11009663,11009664,11009665,11009666,11009667,11009668,11009669,11009670,11009671,11009672,11009673,11009674,11009675,11009676,11009677,8072728,11009678,8072729,8072730,8072731,8072732,8073002,8565126,10971285,10942283,10958353,11023362,11010555,11010556,10942546,10980633,10980634,10980635,10980636,10980637,10980638,10980639,10980640,10980641,10980642,10980643,11019644,10980644,10980645,11019645,10980646,10980647,10980648,10980649,10980650,10980651,10980652,10980653,10980654,10980655,10980656,10980657,10980658,10980659,10980660,10980661,10980662,10980663,10980664,10980665,10980666,10980667,10980668,10980669,10980670,10980671,11019731,11045759,11045760,11045761,11045762,10918623,11019819,10623329,10623423,11007119,11007190,11007319,10924289,10618904,10618905,10618906,10618907,10618908,10618909,10618910,10618911,10618912,10618913,10618914,10619077,10994858,10994859,10994860,10994861,10994862,10919933,10919934,10920181,10920182,10624823,10922483,11044663,10917526,10917527,10966701,10927572,11031720,11031721,10966885,10966886,11005905,10953922,10922903,10922904,10922905,10922906,10922907,10922908,10922909,10922910,10922911,10622408,10622409,10622410,10954109,10917984,11045212,11045213,11045214,11045243,10954256,10954257,11006263,11045273,11045274,10954278,10954279,10928269,11032490,11032491,11032492,11032493,11032494,11032495,11006543,10967614,8570034,8570035,8570036,10620123,11042783,11042784,10977880,10977881,11017063,11017064,11017065,11017066,11017067,11017068,11017069,11017070,11017071,11017072,11017073,11017074,11017075,10915933,10915934,10915935,10915936,10915937,10915938,10915939,10915940,10915941,10915942,10915943,10915944,10915945,10915946,10915947,10915948,10925984,10925985,10615984,10930967,10930968,10952756,10621371,10621372,10979046,10921923,10621575,10621576,10621577,10621578,10621579,10917172,10917173,10917174,10616699,10616700,10922210,10922211,10922212,10922213,10922360,10966528,10966529,11005579,11005580,10565156,7059726,7059727,10611233,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,10609288,10609289,10609290,10609291,8862165,8862166,10612326,10612633,9188037,9188038,9172038,9188039,9188040,9188041,7058320,10612843,9172240,9172241,9172242,9172243,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,10610303,7058810,9172649,8863284,9188850,10610565,9196932,8863469,8863470,8863471,9189014,9189015,10610694,9189078,10515117,10515118,9177311,9169329,4974199,9193347,4974200,4974201,9193348,9177591,4974485,4974486,9185799,10515615,10515616,10515617,10515618,10515619,10515620,10515621,10515622,10515623,10515624,10515625,10515626,10515627,10515628,9185820,9170030,10514109,10514110,10514111,10514112,10514113,10514114,10514115,10514116,7056491,7056492,7056823,7056824,7056825,10516636,10516637,10516638,10516639,10516640,9179050,9179051,9179052,9179053,9179054,9179055,9179056,9179057,9171197,9171243,10417365,4973434,4973435,4973436,10416518,10417534,10416554,4973512,4973513,4973514,10415600,10415601,10415630,4973649,4973650,4973651,4973661,10415731,4973662,10415741,4973674,4973737,4973738,4973739,4973740,10415903,10415904,10415905,10415906,10415907,10415908,4973915,4973916,4973917,9169264,8864988,9182471,9182472,9174534,9174535,9174536,8916386,8916387,6666864,6666865,6666866,10467447,10467448,10467449,8916795,10469750,4972105,10463840,10463841,10463842,10463843,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,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,10166455,10166456,10173486,10173487,10173488,10173489,10173490,10173491,10173492,10173493,10168671,10168672,10168673,10168674,10168675,10168676,10168677,10168678,10627354,10163937,10164053,10164054,10627551,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,10585054,10570653,10570654,10570655,10570656,10570657,10579730,10523235,10523236,10527258,10527259,10527260,10527318,10521845,10523846,10521846,10521847,10519850,10519851,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,10474273,10474274,10480431,10480432,10480433,10480434,10480435,10480436,10480437,10480438,10480439,10480440,10480441,10480442,10480443,10480444,10480445,10480446,10472534,10472535,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'