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(7067915,10211170,10211171,10211172,10211173,10211174,10211175,7068141,7076148,7076149,10224421,10224422,7068253,7068254,7068255,7068256,7068257,7068258,7068259,7068260,10198669,10237764,10237812,10237813,7074108,7066144,7074251,10251785,10251786,10251979,10251980,10251981,10251982,7066851,7066914,7074938,7074983,7067227,7075292,10236576,7067398,7075431,7075432,8068600,8068601,10197926,10197927,10197928,10197929,7067738,10195134,6000226,10234325,10234345,10234346,10234347,7072281,10247558,10931771,10931773,7072599,7072600,10208866,10221871,10208886,10208897,10208898,7072799,10235153,10235154,10235159,10235160,10209174,10235280,10209405,10209708,7073626,7070893,7070894,7070895,7070896,7070897,10207147,10207148,10207149,10207150,10233170,10207422,8861114,10207502,10207547,10207548,10207549,10246553,7071325,10207867,10207868,10207869,7071696,10244054,10244055,10244056,10244057,10244058,10244059,10244060,10244061,10244062,10244063,10244064,10244065,10244066,10244067,10244068,10244069,10244070,10244071,10244072,10244073,10244074,10244075,10244076,10244077,10244078,10244079,10244080,10244081,10244082,10244083,10244084,10244085,10244086,10244087,10244088,10244089,10244090,10244091,10244092,10244093,10244094,10244095,10244096,10244097,10244098,10244099,10244100,10244101,10244102,10244103,10244104,10244105,10244106,10244107,10244108,10244109,10244110,10244111,10244112,10244113,10244114,10244115,10244116,10244117,10244118,10244119,10244120,10244121,10244122,10244123,10244124,10244125,10244126,10244127,10244128,10244129,10244130,10244131,10244132,10244133,10244134,10244135,10244136,10244137,10244138,10244139,10244140,10244141,10244142,10244143,10244144,10244145,10244146,10244147,10244148,10244149,10244150,10244151,10244152,10244153,10244154,10244155,10244156,10244157,10244158,10244159,10244160,10244161,10244162,10244163,10244164,10244165,10244166,10244167,10244168,10244169,10244170,10244171,10244172,10244173,10244174,10244175,10244176,10244177,10244178,10244179,10244180,10244181,10244182,10244183,10244184,10244185,10244186,10244187,10244188,10244189,10244190,10244191,10244192,10244193,10244194,10244195,10244196,10244197,10244198,10244199,10244200,10244201,10244202,10244203,10244204,10244205,10244206,10244207,10244208,10244209,10244210,10244211,10244212,10244213,10244214,10244215,10244216,10244217,10244218,10244219,10244220,10244221,10244222,10244223,10244224,10244225,10244226,10244227,10244228,10244229,10244230,10244231,10244232,10244233,10244234,10244235,10244236,10244237,10244238,10244239,10244240,10244241,10244242,10244243,10244244,10244245,10244246,10244247,10244248,10244249,10244250,10244251,10244252,10244253,10244254,10244255,10244256,10244257,10244258,10244259,10244260,10244261,10244262,10244263,10244264,10244265,10244266,10244267,10244268,10244269,10244270,10244271,10244272,10244273,10244274,10244275,10244276,10244277,10244278,10244279,10244280,10244281,10244282,10244283,10244284,10244285,10244286,10244287,10244288,10244289,10244290,10244291,10244292,10244293,10244294,10244295,10244296,10244297,10244298,10244299,10244300,10244301,10244302,10244303,10244304,10244305,10244306,10244307,10244308,10244309,10244310,10244311,10244312,10244313,10244314,10244315,10244316,10244317,10244318,10244319,10244320,10244321,10244322,10244323,10244324,10244325,10244326,10244327,10244328,10244329,10244330,10244331,10244332,10244333,10244334,10244335,10244336,10244337,10244338,10244339,10244340,10244341,10244342,10244343,10244344,10244345,10244346,10244347,10244348,10244349,10244350,10244351,10244352,10244353,10244354,10244355,10244356,10244357,10244358,10244359,10244360,10244361,10244362,10244363,10244364,10244365,10244366,10244367,10244368,10244369,10244370,10244371,10244372,10244373,10205482,10205483,10205484,10205485,10205486,10205487,10205488,10205489,10205490,10205491,10205492,10205493,10205494,10205495,10205496,10205497,10205498,7069319,7069320,7069321,7069322,7069323,7069324,7069325,7069326,7069327,7069328,7069329,7069458,7069459,7069460,7069461,10941355,7070099,10206427,10206428,10232448,10232449,10232450,10232451,10232452,10232458,10206470,10232546,10232547,10232548,10232549,10232550,10232551,10232552,10232553,10232554,10206641,10206771,10206772,10206773,10206774,10206775,10206844,10206845,10206846,7070625,10942417,8860618,8860641,8860648,8860649,10618041,10190135,10618265,10618266,10618267,10618268,10618269,10618270,10618271,10618272,10618273,10618274,10618275,10618276,10618826,10618827,10203932,10203933,10203934,10203935,10216936,8070808,8070827,8070835,8070849,10617031,10927957,10617522,10215739,10215740,10215741,10215742,10215743,10215744,10215745,10215746,10215747,10215748,10215749,10215750,10215751,10215752,10215753,10215754,10215755,10215756,10215757,10215758,10215759,10215760,10215761,10215762,10215763,10215764,10215765,10622813,10622814,10622894,10622898,10925504,10920556,10920598,10920599,10920635,10920749,10920750,10920751,10620356,10925879,10620419,10200775,10615684,10921209,10921210,10921233,10921234,10615803,10615859,10615866,10615871,10921405,10615906,10615943,10921479,10921480,10921481,10921547,10921569,10921570,10621070,10921596,10930950,10921720,10921721,10921722,10921723,10921724,10188307,10188325,10188326,10921748,10921758,10921759,10921895,10621422,10621423,10188641,10227660,10188661,10188662,10188663,10922100,10922101,10922102,10922191,10922194,10922195,10201836,10201931,10201932,10927436,10562342,10562343,10562344,10562345,10562346,10562347,10614260,10614316,10614414,10559623,9173891,8864453,8864454,8864455,8864456,9166139,9166140,10611991,10611992,10611993,9171350,10612030,10612031,10612032,10612035,10612036,7057701,9171660,10612348,9171699,10557529,10557530,10563537,10563538,10563539,10612489,7058374,10612873,10612990,10613066,10613100,7058657,7058677,7058715,7058722,7058723,7058724,9172569,8863145,10613292,10613305,7058823,10558579,9172912,10613722,10613736,8863796,10515129,9169437,10513401,9169700,10513574,10513575,9169823,10515679,10513823,10513824,10515832,10513905,10513906,10513946,10513947,10512145,10512146,10512157,9170626,9170886,10516826,10516827,10516828,10516829,9171023,9171024,10518909,10518910,9168304,9168305,9168308,10418252,9168393,9160470,9160471,9160472,10416424,10416425,10416426,10417508,10419596,10419600,7054874,10418676,10418709,10418816,10416962,10420057,10417091,10417101,10418114,10417115,10417119,10417120,10417183,4971333,4971464,4971506,4971640,6666969,10467562,4972135,4972136,4972137,4972138,4972139,4972140,4972141,4972142,4972143,4972144,4972145,4972146,4972147,4972148,4972149,4972150,4972151,4972152,4972153,4972154,10469913,10469915,10469917,10469922,10469923,10469924,10469943,10469946,10467981,10467982,10468016,10468041,10466252,10470278,10468349,10468355,10468367,10470373,9167799,10470384,6667879,10470474,10470477,10470478,10470489,10470588,10470592,6668119,10628086,10628087,10628088,10628089,10628090,10628091,10628092,10628093,10628094,10628095,10628096,10628097,10628098,10628099,10628100,10628101,10628102,10628103,10628104,10164776,10164816,10164817,10164983,10165164,10165165,10165166,10165167,10165679,10165680,10155747,10155748,10155749,10155837,10155838,10155839,10155840,10155841,10629525,10629604,10629752,10629823,10629884,10166412,10632015,10627280,10627293,10163926,10164214,10164215,10164444,10164445,10630226,10162178,10162404,10162405,10163240,10571390,10568598,10568599,10568600,10568601,10568602,10568603,10571761,10577762,10574883,10574884,10574885,10578044,10575107,10566114,10566115,10566116,10566117,10566118,10566119,10566120,10566121,10566122,10575132,10575133,10575134,10572297,10572298,10572299,10575387,10575413,10575535,10575674,10575675,10575752,10575801,10569837,10569838,10570069,10570070,10570078,10570269,10576364,10570436,10573550,10573551,10573552,10573553,10573554,10573555,10573556,10573557,10573558,10573559,10573560,10573561,10573562,10573563,10573564,10573565,10573566,10573567,10573568,10573569,10573570,10573571,10573572,10573573,10573574,10573575,10573576,10573577,10573578,10573579,10573580,10573581,10573582,10573583,10573584,10573585,10573586,10573587,10573588,10573589,10573590,10573591,10573592,10573593,10573594,10573595,10573596,10573597,10573598,10573599,10573600,10573601,10576674,10571043,10571044,10571045,10523140,10521187,10521188,10521189,10525311,10525312,10521330,10521343,10521344,10523364,10523365,10523366,10521673,10521674,10521680,10521716,10523728,10521746,10521850,10521885,10521886,10522081,10522100,10522320,10522321,10522334,10522340,10522375,10522376,10522379,10520790,10520795,10520880,10526919,10526920,10526921,10526922,10526923,10526924,10526925,10526926,10526927,10526928,10526929,10521026,10523049,10523050,10523051,10523060,10523061,10420384,10422549,10423586,10420849,10423923,10423926,10421108,10421109,10423152,10477310,10477948,10474004,10474018,10474026,10474030,10474065,10474068,10474069,10478248,10476458,10478554) 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'