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(10208487,10208488,10208489,10208490,10208491,10208492,10208493,10208494,10208495,10208496,10208497,10208498,10208499,10208500,10208501,10208502,10208503,10208504,10208505,10208506,10208507,10208508,10208509,10208510,10208511,10208512,10208513,10208514,10208515,10208516,10208517,10208518,10208519,10208520,10208521,10208522,10208523,10208524,10208525,10208526,10208527,10208528,10208529,10208530,10208531,10208532,10208533,10208534,10208535,10208536,10208537,10208538,10208539,10208540,10208541,10208542,10208543,10208544,10208545,10208546,10208547,10208548,10208549,10208550,10208551,10208552,10208553,10208554,10208555,10208556,10208557,10208558,10208559,10208560,10208561,10208562,10208563,10208564,10208565,10208566,10207933,10207934,10207935,10207936,10207937,10207938,10207939,10207940,10207941,10207942,10207943,10207944,10207945,10207946,10207947,10207948,10207949,10207950,10207951,10207952,10207953,10207954,10207955,10207956,10207957,10207958,10207959,10207960,10207961,10207962,10207963,10207964,10207965,10207966,10207967,10207968,10207969,10207970,10207971,10207972,10207973,10207974,10207975,10207976,10207977,10207978,10207979,10207980,10207981,10207982,10207983,10207984,10207985,10207986,10207987,10207988,10207989,10207990,10207991,10207992,10207993,10207994,10207995,10207996,10207997,10207998,10207999,10208000,10208001,10208002,10208003,10208004,10208005,10208006,10208007,10208008,10208009,10208010,10208011,10208012,10208013,10208014,10208015,10208016,10208017,10208018,10208019,10208020,10208021,10208022,10208023,10208024,10208025,10208026,10208027,10208028,10208029,10208030,10208031,10208032,10208033,10208034,10208035,10208036,10208037,10208038,10208039,10208040,10208041,10208042,10208043,10208044,10208045,10208046,10208047,10208048,10208049,10208050,10208051,10208052,10208053,10208054,10208055,10208056,10208057,10208058,10208059,10208060,10208061,10208062,10208063,10208064,10208065,10208066,10208067,10208068,10208069,10208070,10208071,10208072,10208073,10208074,10208075,10208076,10208077,10208078,10208079,10208080,10208081,10208082,10208083,10208084,10208085,10208086,10208087,10208088,10208089,10208090,10208091,10208092,10208093,10208094,10208095,10208096,10208097,10208098,10208099,10208100,10208101,10208102,10208103,10208104,10208105,10208106,10208107,10208108,10208109,10208110,10208111,10208112,10208113,10208114,10208115,10208116,10208117,10208118,10208119,10208120,10208121,10208122,10208123,10208124,10208125,10208126,10208127,10208128,10208129,10208130,10208131,10208132,10208133,10208134,10208135,10208136,10208137,10208138,10208139,10208140,10208141,10208142,10208143,10208144,10208145,10208146,10208147,10208148,10208149,10208150,10208151,10208152,10208153,10208154,10208155,10208156,10208157,10208158,10208159,10208160,10208161,10208162,10208163,10208164,10208165,10208166,10208167,10208168,10208169,10208170,10208171,10208172,10208173,10208174,10208175,10208176,10208177,10208178,10208179,10208180,10208181,10208182,10208183,10208184,10208185,10208186,10208187,10208188,10208189,10208190,10208191,10208192,10208193,10208194,10208195,10208196,10208197,10208198,10208199,10208200,10208201,10208202,10208203,10208204,10208205,10208206,10208207,10208208,10208209,10208210,10208211,10208212,10208213,10208214,10208215,10208216,10208217,10208218,10208219,10208220,10208221,10208222,10208223,10208224,10208225,10208226,10208227,10208228,10208229,10208230,10208231,10208232,10208233,10208234,10208235,10208236,10208237,10208238,10208239,10208240,10208241,10208242,10208243,10208244,10208245,10208246,10208247,10208248,10208249,10208250,10208251,10208252,10208253,10208254,10208255,10208256,10208257,10208258,10208259,10208260,10208261,10208262,10208263,10208264,10208265,10208266,10208267,10208268,10208269,10208270,10208271,10208272,10208273,10208274,10208275,10208276,10208277,10208278,10208279,10208280,10208281,10208282,10208283,10208284,10208285,10208286,10208287,10208288,10208289,10208290,10208291,10208292,10208293,10208294,10208295,10208296,10208297,10208298,10208299,10208300,10208301,10208302,10208303,10208304,10208305,10208306,10208307,10208308,10208309,10208310,10208311,10208312,10208313,10208314,10208315,10208316,10208317,10208318,10208319,10208320,10208321,10208322,10208323,10208324,10208325,10208326,10208327,10208328,10208329,10208330,10208331,10208332,10208333,10208334,10208335,10208336,10208337,10208338,10208339,10208340,10208341,10208342,10208343,10208344,10208345,10208346,10208347,10208348,10208349,10208350,10208351,10208352,10208353,10208354,10208355,10208356,10208357,10208358,10208359,10208360,10208361,10208362,10208363,10208364,10208365,10208366,10208367,10208368,10208369,10208370,10208371,10208372,10208373,10208374,10208375,10208376,10208377,10208378,10208379,10208380,10208381,10208382,10208383,10208384,10208385,10208386,10208387,10208388,10208389,10208390,10208391,10208392,10208393,10208394,10208395,10208396,10208397,10208398,10208399,10208400,10208401,10208402,10208403,10208404,10208405,10208406,10208407,10208408,10208409,10208410,10208411,10208412,10208413,10208414,10208415,10208416,10208417,10208418,10208419,10208420,10208421,10208422,10208423,10208424,10208425,10208426,10208427,10208428,10208429,10208430,10208431,10208432,10208433,10208434,10208435,10208436,10208437,10208438,10208439,10208440,10208441,10208442,10208443,10208444,10208445,10208446,10208447,10208448,10208449,10208450,10208451,10208452,10208453,10208454,10208455,10208456,10208457,10208458,10208459,10208460,10208461,10208462,10208463,10208464,10208465,10208466,10208467,10208468,10208469,10208470,10208471,10208472,10208473,10208474,10208475,10208476,10208477,10208478,10208479,10208480,10208481,10208482,10208483,10208484,10208485,10208486,8579447,8579448,8579449,8579450,8579451,8579452,8579453,8579454,8579455,8579456,8579457,8579458,8579459,8579460,10620321,10620322,10620323,10620324,10620325,10620326,7056221,7056222,7056223,7056224,7056225,9176841,9176842,9176843,9176844,9176845,9176846,9176847,9176848,9176849,9176850,9176851,9176852,9176853,9176854,9176855,9176856,9176857,9176858,9176859,9176860,9176861,9176862,9176863,9176864,9176865,9176866,9176867,9176868,9176869,9176870,9176871,9176872,9176873,9176874,9176875,9176876,9176877,9176878,9176879,9176880,9176881,9176882,9176883,9176884,9176885,9176886,4971646,4971647,8863172,8863173,8863174,10166529,10166530,10166531,10166532,10166533,10166534,10166535,10166536,10166537,10166538,10166539,10166540,10166541,10166542,10166543,10166544,10166545,10166546,10166547,10166548,10166549,10166550,10166551,10166552,10166553,10166554,10166555,10166556,10166557,10166558,10166559,10166560,10166561,10166562,10166563,10166564,10166565,10166566,10166567,10166568,10166569,10166570,10166571,10166572,10166573,10166574,10166575,10166576,10166577,10166578,10166579,10166580,10166581,10166582,10166583,10166584,10166585,10166586,10166587,10166588,10166589,10166590,10166591,10166592,10166593,10166594,10166595,10166596,10166597,10166598,10166599,10166600,10166601,10166602,10166603,10166604,10166605,10166606,10166607,10166608,10166609,10166610,10166611,10166612,10166613,10166614,10166615,10166616,10166617,10166618,10166619,10166620,10166621,10166622,10166623,10166624,10166625,10166626,10166627,10166628,10166629,10166630,10166631,10166632,10166633,10166634,10166635,10166636,10166637,10166638,10166639,10166640,10166641,10166642,10166643,10166644,10166645,10166646,10166647,10166648,10166649,10166650,10166651,10166652,10166653,10166654,10166655,10166656,10166657,10166658,10166659,10166660,10166661,10166662,10166663,10166664,10166665,10166666,10166667,10166668,10166669,10166670,10166671,10166672,10166673,10166674,10166675,10166676,10166677,10166678,10166679,10166680,10166681,10166682,10166683,10166684,10166685,10166686,10166687,10166688,10166689,10166690,10166691,10166692,10166693,10166694,10166695,10166696,10166697,10166698,10166699,10166700,10166701,10166702,10166703,10166704,10166705,10166706,10166707,10166708,10166709,10166710,10166711,10166712,10166713,10166714,10166715,10166716,10166717,10166718,10166719,10166720,10166721,10166722,10166723,10166724,10166725,10166726,10166727,10166728,10166729,10166730,10166731,10166732,10166733,10166734,10166735,10166736,10166737,10166738,10166739,10166740,10166741,10166742,10166743,10166744,10166745,10166746,10166747,10166748,10166749,10166750,10166751,10166752,10166753,10166754,10166755,10166756,10166757,10166758,10166759,10166760,10166761,10166762,10166763,10166764,10166765,10166766,10166767,10166768,10166769,10166770,10166771,10166772,10166773,10166774,10166775,10166776,10166777,10166778,10166779,10166780,10166781,10166782,10166783,10166784,10166785,10166786,10166787,10166788,10166789,10166790,10166791,10166792,10166793,10166794,10166795,10166796,10166797,10166798,10166799,10166800,10166801,10166802,10166803,10166804,10166805,10478218,10478219,10478220,10478221,10478222,10478223,10478224,10478225,10478226,10478227,10478228,10478229,10478230) 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'