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(8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067490,8067491,8067492,8067493,8067494,8067495,8067496,8067497,8067498,8067499,8067500,8067501,8067502,8067503,8067504,8067505,8067506,8067507,8067508,8067510,8067512,8067513,8067514,8067515,8067516,10918746,10918747,10918748,10918749,10918750,10918751,10918752,10918753,10918754,10918755,10918756,10918757,10918758,10918759,10918760,10918761,10918762,10918763,10918764,10918765,10918766,10918767,10918768,10918769,10918770,10918771,10918772,10918773,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10918783,10918784,10918785,10918786,10918787,10918788,10918789,10918790,10918791,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10918801,10918802,10918803,10918804,10918805,10918806,10918807,10918808,10918809,10918810,10918811,10918812,10918813,10918814,10918815,10918816,10918817,10918818,10918819,10918820,10918821,10918822,10918823,10918824,10918825,10918826,10918827,10918828,10918829,10918830,10918831,10918832,10918833,10918834,10918835,10918836,10918837,10918838,10918839,10918840,10918841,10918842,10918843,10918844,10918845,10918846,10918847,10918848,10918849,10918850,10918851,10918852,10918853,10918854,10918855,10918856,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,10918867,10918868,10918869,10918870,10918871,10918872,10918873,10918874,10918875,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10918884,10918885,10918886,10918887,10918888,10918889,10918890,10918891,10918892,10918893,10918894,10918895,10918896,10918897,10918898,10918899,10918900,10918901,10918902,10918903,10918904,10918905,10918906,10918907,10918908,10918909,10918910,10918911,10918912,10918913,10918914,10918915,10918916,10918917,10918918,10918919,10918920,10918921,10918922,10918923,10918924,10918925,10918926,10918927,10918928,10918929,10918930,10918931,10918932,10918933,10918934,10918935,10918936,10918937,10918938,10918939,10918940,10918941,10918942,10918943,10918944,10918945,10918946,10918947,10918948,10918949,10918950,10918951,10918952,10918953,10918954,10918955,10918956,10918957,10918958,10918959,10918960,10918961,10918962,10918963,10918964,10918965,10918966,10918967,10918968,10918969,10918970,10918971,10918972,10918973,10918974,10918975,10918976,10918977,10918978,10918979,10918980,10918981,10918982,10918983,10918984,10918985,10918986,10918987,10918988,10918989,10918990,10918991,10918992,10918993,10918994,10918995,10918996,10918997,10918998,10918999,10919000,10919001,10919002,10919003,10919004,10919005,10919006,10919007,10919008,10919009,10919010,10919011,10919012,10919013,10919014,10919015,10919016,10919017,10919018,10919019,10919020,10919021,10919022,10919023,10919024,10919025,10919026,10919027,10919028,10919029,10919030,10919031,10919032,10919033,10919034,10919035,10919036,10919037,10919038,10919039,10919040,10919041,10919042,10919043,10919044,10919045,10919046,10919047,10919048,10919049,10919050,10919051,10919052,10919053,10919054,10919055,10919056,10919057,10919058,10919059,10919060,10919061,10919062,10919063,10919064,10919065,10919066,10919067,10919068,10919069,10919070,10919071,10919072,10919073,10919074,10919075,10919076,10919077,10919078,10919079,10919080,10919081,10919082,10919083,10919084,10919085,10919086,10919087,10919088,10919089,10919090,10919091,10919092,10919093,10919094,10919095,10919096,10919097,10919098,10919099,10919100,10919101,10919102,10919103,10919104,10919105,10919106,10919107,10919108,10919109,10919110,10919111,10919112,10919113,10919114,10919115,10919116,10919117,10919118,10919119,10919120,10919121,10919122,10919123,10919124,10919125,10919126,10919127,10919128,10919129,10919130,10919131,10919132,10919133,10919134,10919135,10919136,10919137,10919138,10919139,10919140,10919141,10919142,10919143,10919144,10919145,10919146,10919147,10919148,10919149,10919150,10919151,10919152,10919153,10919154,10919155,10919156,10919157,10919158,10919159,10919160,10919161,10919162,10919163,10919164,10919165,10919166,10919167,10919168,10919169,10919170,10919171,10919172,10919173,10919174,10919175,10919176,10919177,10919178,10919179,10919180,10919181,10919182,10919183,10919184,10919185,10919186,10919187,10919188,10919189,10919190,10919191,10919192,10919193,10919194,10919195,10919196,10919197,10919198,10919199,10919200,10919201,10919202,10919203,10919204,10919205,10919206,10919207,10919208,10919209,10919210,10919211,10919212,10919213,10919214,10919215,10919216,10919217,10919218,10919219,10919220,10919221,10919222,10919223,10919224,10919225,10919226,10919227,10919228,10919229,10919230,10919231,10919232,10919233,10919234,10919235,10919236,10919237,10919238,10919239,10919240,10919241,10919242,10919243,10919244,10919245,10919246,10919247,10919248,10919249,10919250,10919251,10919252,10919253,10919254,10919255,10919256,10919257,10919258,10919259,10919260,10919261,10919262,10919263,10919264,10919265,10919266,10919267,10919268,10919269,10919270,10919271,10919272,10919273,10919274,10919275,10919276,10919277,10919278,10919279,10919280,10919281,10919282,10919283,10919284,10919285,10919286,10919287,10919288,10919289,10919290,10919291,10919292,10919293,10919294,10919295,10919296,10919297,10919298,10919299,10919300,10919301,10919302,10919303,10919304,10919305,10919306,10919307,10919308,10919309,10919310,10919311,10919312,10919313,10919314,10919315,10919316,10919317,10919318,10919319,10919320,10919321,10919322,10919323,10919324,10919325,10919326,10919327,10919328,10919329,10919330,10919331,10919332,10919333,10919334,10919335,10919336,10919337,10919338,10919339,10919340,10919341,10919342,10919343,10919344,10919345,10919346,10919347,10919348,10919349,10919350,10919351,10919352,10919353,10919354,10919355,10919356,10919357,10919358,10919359,10919360,10919361,10919362,10919363,10919364,10919365,10919366,10919367,10919368,10919369,10919370,10919371,10919372,10919373,10919374,10919375,10919376,10919377,10919378,10919379,10919380,10919381,10919382,10919383,10919384,10919385,10919386,10919387,10919388,10919389,10919390,10919391,10919392,10919393,10919394,10919395,10919396,10919397,10919398,10919399,10919400,10919401,10919402,10919403,10919404,10919405,10919406,10919407,10919408,10919409,10919410,10919411,10919412,10919413,10919414,10919415,10919416,10919417,10919418,10919419,10919420,10919421,10919422,10919423,10919424,10919425,10919426,10919427,10919428,10919429,10919430,10919431,10919432,10919433,10919434,10919435,10919436,10919437,10919438,10919439,10919440,10919441,10919442,10919443,10919444,10919445,10919446,10919447,10919448,10919449,10919450,10919451,10919452,10919453,10919454,10919455,10919456,10919457,10919458,10919459,10919460,10919461,10919462,10919463,10919464,10919465,10919466,10919467,10919468,10919469,10919470,10919471,10919472,10919473,10919474,10919475,10919476,10919477,10919478,10919479,10919480,10919481,10919482,10919483,10919485,10919486,10919487,10919491,10919494,10919495,10919496,10919497,10919498,10919499,10919502,10919504,10919507,10919508,10919509,10919511,10919512,10919517,10919518,10919521,10919525,10919527,10919528,10919529,10919530,10919531,10919532,10919533,10919534,10919535,10919536,10919537,10919538,10919539,10919540,10919541,10919542,10919543,10919544,10919545,10919546,10919547,10919548,10919551,10919552,10919553,10919555,10919556,10919557,10919558,10919559,10919562,10919563,10919564,10919567,10919568,10919571,10919572,10919573,10919576,10919577,10919580,10919581,10919583,10919584,10919585,10919586,10919590,10919591,10919592,10919593,10919594,10919595,10919596,10919597,10919598,10919599,10919600,10919601,10919602,10919603,10919604,10919605,10919606,10919607,10919608,10919609,10919610,10919611,10919612,10919613,10919614,10919615,10919616,10919617,10919618,10919619,10919620,10919621,10919622,10919623,10919624,10919625,10919626,10919627,10919628,10919629,10919630,10919631,10919632,10919633,10919634,10919635,10919636,10919637,10919638,10919639,10919640,10919641,10919642,10919643,10919644,10919645,10919646,10919647,10919648,10919649,10919650,10919651,10919655,10919656,10919657,10919659,10919660,10919661,10919662,10919666,10919668,10919669,10919670,10919671,10919672,10919673,10919674,10919675,10919678,10919679,10919680,10919681,10919684,10919685,10919686,10919687,10919688,10919689,10919691,10919692,10919694,10919696,10919697,10919698,10919704,10919705,10919706,10919707,10919708,10919709,10919710,10919711,10919712,10919713,10919715,10919716,10919717,10919718,10919719,10919720,10919722,10919723,10919724,10919726,10919730,10919735,10919737,10919741,10919742,10919744,10919745,10919746,10919747,10919748,10919749,10919750,10919755,10919756,10919757,10919761,10919762,10919763,10919764,10919765,10919766,10919767,10919768,10919769,10919770,10919771,10919772,10919773,10919775,10919776,10919780,10919781,10919784,10919785,10919787,10919788,10919789,10919790,10919791,10919792,10919793,10919794,10919795,10919796,10919797,10919798) 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'