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(8067469,8067470,8067471,8067472,8067473,8067474,8067475,8067476,8067477,8067478,8067479,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,8067509,8067510,8067511,8067512,8067513,8067514,8067515,8067516,8075306,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,10918472,10918473,10918474,10918475,10918476,10918477,10918478,10918479,10918480,10918481,10918482,10918483,10918484,10918485,10918486,10918487,10918488,10918489,10918490,10918491,10918492,10918493,10918494,10918495,10918496,10918497,10918498,10918499,10918500,10918501,10918502,10918503,10918504,10918505,10918506,10918507,10918508,10918509,10918510,10918511,10918512,10918513,10918514,10918515,10918516,10918517,10918518,10918519,10918520,10918521,10918522,10918523,10918524,10918525,10918526,10918527,10918528,10918529,10918530,10918531,10918532,10918533,10918534,10918535,10918536,10918537,10918538,10918539,10918540,10918541,10918542,10918543,10918544,10918545,10918546,10918547,10918548,10918549,10918550,10918551,10918552,10918553,10918554,10918555,10918556,10918557,10918558,10918559,10918560,10918561,10918562,10918563,10918564,10918565,10918566,10918567,10918568,10918569,10918570,10918571,10918572,10918573,10918574,10918575,10918576,10918577,10918578,10918579,10918580,10918581,10918582,10918583,10918584,10918585,10918586,10918587,10918588,10918589,10918590,10918591,10918592,10918593,10918594,10918595,10918596,10918597,10918598,10918599,10918600,10918601,10918602,10918603,10918604,10918605,10918606,10918607,10918608,10918609,10918610,10918611,10918612,10918613,10918614,10918615,10918616,10918617,10918618,10918619,10918620,10918621,10918622,10918623,10918624,10918625,10918626,10918627,10918628,10918629,10918630,10918631,10918632,10918633,10918634,10918635,10918636,10918637,10918638,10918639,10918640,10918641,10918642,10918643,10918644,10918645,10918646,10918647,10918648,10918649,10918650,10918651,10918652,10918653,10918654,10918655,10918656,10918657,10918658,10918659,10918660,10918661,10918662,10918663,10918664,10918665,10918666,10918667,10918668,10918669,10918670,10918671,10918672,10918673,10918674,10918675,10918676,10918677,10918678,10918679,10918680,10918681,10918682,10918683,10918684,10918685,10918686,10918687,10918688,10918689,10918690,10918691,10918692,10918693,10918694,10918695,10918696,10918697,10918698,10918699,10918700,10918701,10918702,10918703,10918704,10918705,10918706,10918707,10918708,10918709,10918710,10918711,10918712,10918713,10918714,10918715,10918716,10918717,10918718,10918719,10918720,10918721,10918722,10918723,10918724,10918725,10918726,10918727,10918728,10918729,10918730,10918731,10918732,10918733,10918734,10918735,10918736,10918737,10918738,10918739,10918740,10918741,10918742,10918743,10918744,10918745,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,10419509,10420062) 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'