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(4970152,4970155,4970163,4970165,4970166,4970169,4970170,4970171,4970172,4970173,4970181,4970182,4970184,4970189,4970190,4970191,4970192,4970202,4970203,4970215,4970232,4970236,4970239,4970240,4970249,4970251,4970253,4970254,4970256,4970263,4970266,4970272,4970274,4970277,4970280,4970284,4970289,4970292,4970294,4970297,4970306,4970308,4970312,4970327,4970334,4970343,4970346,4970349,4970353,4970359,4970364,4970365,4970372,4970378,4970380,4970381,4970387,4970398,4970403,4970404,4970411,4970412,4970413,4970416,4970420,4970422,4970426,4970427,4970428,4970431,4970432,4970437,4970440,4970442,4970446,4970470,4970473,4970481,4970485,4970493,4970499,4970512,4970519,4970538,4970544,4970546,4970568,4970573,4970577,4970578,4970592,4970599,4970602,4970611,4970620,4970635,4970649,4970650,4970654,4970659,4970666,4970696,4970697,4970699,4970702,4970717,4970718,4970722,4970723,4970760,4970764,4970765,4970766,4970776,4970789,4970790,4970791,4970792,4970805,4970807,4970810,4970816,4970817,4970820,4970827,4970828,4970832,4970837,4970851,4970852,4970854,4970855,4970856,4970857,4970871,4970872,4970880,4970903,4970920,4970936,4970937,4970938,4970946,4970947,4970948,4970971,4970976,4970977,4970980,4970993,4970996,4970997,4970998,4970999,4971000,4971001,4971002,4971003,4971004,4971009,4971010,4971011,4971012,4971013,4971014,4971015,4971016,4971017,4971018,4971024,4971025,4971026,4971038,4971039,4971040,4971054,4971055,4971056,4971057,4971058,4971097,4971099,4971100,4971101,4971103,4971106,4971115,4971118,4971122,4971123,4971124,4971140,4971143,4971145,4968152,4968153,4968154,4968155,4968156,4968157,4968158,4968159,4968160,4968161,4968162,4968163,4968164,4968166,4968171,4968172,4968174,4968175,4968176,4968177,4968178,4968179,4968180,4968181,4968182,4968183,4968184,4968185,4968186,4968190,4968191,4968192,4968193,4968194,4968195,4968196,4968197,4968199,4968200,4968201,4968205,4968206,4968207,4968208,4968209,4968210,4968214,4968218,4968219,4968220,4968223,4968224,4968225,4968226,4968227,4968228,4968229,4968230,4968231,4968232,4968233,4968235,4968237,4968239,4968241,4968242,4968244,4968245,4968246,4968247,4968248,4968249,4968250,4968251,4968252,4968253,4968254,4968255,4968256,4968258,4968259,4968262,4968263,4968271,4968273,4968274,4968275,4968276,4968278,4968279,4968280,4968281,4968283,4968284,4968285,4968286,4968287,4968289,4968290,4968291,4968293,4968294,4968295,4968296,4968297,4968298,4968299,4968300,4968301,4968302,4968303,4968304,4968305,4968307,4968308,4968309,4968310,4968312,4968313,4968314,4968315,4968316,4968317,4968319,4968320,4968321,4968322,4968323,4968325,4968326,4968328,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968341,4968342,4968344,4968345,4968346,4968347,4968348,4968349,4968350,4968351,4968352,4968353,4968354,4968355,4968357,4968358,4968360,4968363,4968364,4968365,4968367,4968374,4968378,4968379,4968381,4968383,4968385,4968386,4968387,4968390,4968391,4968392,4968393,4968394,4968396,4968398,4968399,4968400,4968402,4968403,4968404,4968405,4968406,4968407,4968408,4968416,4968418,4968419,4968420,4968421,4968422,4968423,4968424,4968425,4968426,4968427,4968428,4968430,4968431,4968434,4968435,4968437,4968438,4968439,4968440,4968441,4968442,4968446,4968447,4968448,4968450,4968451,4968453,4968454,4968455,4968457,4968458,4968459,4968460,4968461,4968462,4968463,4968464,4968465,4968466,4968467,4968468,4968469,4968470,4968471,4968472,4968473,4968474,4968477,4968478,4968479,4968480,4968482,4968485,4968486,4968487,4968488,4968491,4968493,4968494,4968495,4968496,4968497,4968498,4968499,4968500,4968504,4968506,4968507,4968509,4968511,4968512,4968513,4968515,4968516,4968518,4968519,4968521,4968522,4968523,4968524,4968525,4968528,4968530,4968531,4968532,4968534,4968540,4968541,4968542,4968543,4968544,4968545,4968548,4968549,4968551,4968555,4968556,4968557,4968559,4968560,4968561,4968565,4968566,4968567,4968568,4968569,4968570,4968571,4968572,4968573,4968574,4968575,4968576,4968577,4968578,4968579,4968580,4968581,4968582,4968583,4968584,4968585,4968586,4968587,4968588,4968589,4968590,4968591,4968592,4968593,4968594,4968595,4968596,4968597,4968598,4968599,4968600,4968601,4968603,4968604,4968607,4968608,4968610,4968611,4968616,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968632,4968634,4968635,4968636,4968637,4968638,4968639,4968643,4968644,4968648,4968649,4968650,4968653,4968654,4968655,4968656,4968657,4968658,4968659,4968660,4968661,4968662,4968663,4968665,4968667,4968668,4968669,4968671,4968674,4968675,4968676,4968677,4968678,4968679,4968680,4968684,4968686,4968687,4968688,4968689,4968690,4968693,4968694,4968695,4968697,4968698,4968699,4968700,4968701,4968703,4968704,4968705,4968708,4968709,4968713,4968714,4968715,4968716,4968717,4968718,4968719,4968722,4968723,4968724,4968725,4968726,4968729,4968730,4968731,4968732,4968733,4968734,4968735,4968736,4968737,4968738,4968739,4968740,4968741,4968742,4968743,4968744,4968745,4968746,4968747,4968748,4968749,4968750,4968751,4968752,4968753,4968754,4968755,4968756,4968757,4968758,4968759,4968760,4968763,4968765,4968766,4968767,4968770,4968771,4968774,4968778,4968781,4968782,4968783,4968785,4968786,4968787,4968789,4968790,4968794,4968795,4968796,4968797,4968798,4968799,4968800,4968802,4968803,4968804,4968805,4968809,4968810,4968811,4968812,4968813,4968817,4968819,4968820,4968821,4968822,4968823,4968825,4968826,4968832,4968833,4968834,4968835,4968836,4968837,4968838,4968839,4968840,4968842,4968849,4968851,4968852,4968853,4968854,4968855,4968857,4968859,4968861,4968862,4968864,4968865,4968867,4968868,4968869,4968870,4968871,4968872,4968873,4968874,4968876,4968877,4968878,4968879,4968880,4968881,4968882,4968883,4968884,4968885,4968887,4968889,4968890,4968892,4968895,4968896,4968899,4968900,4968903,4968904,4968905,4968906,4968907,4968908,4968909,4968910,4968911,4968912,4968913,4968915,4968916,4968917,4968918,4968920,4968921,4968922,4968923,4968925,4968926,4968927,4968928,4968931,4968932,4968934,4968935,4968936,4968937,4968938,4968940,4968941,4968942,4968943,4968945,4968946,4968947,4968949,4968951,4968955,4968956,4968957,4968958,4968960,4968961,4968963,4968964,4968965,4968966,4968967,4968968,4968969,4968970,4968971,4968973,4968974,4968975,4968976,4968977,4968978,4968979,4968980,4968981,4968982,4968983,4968984,4968985,4968986,4968987,4968988,4968989,4968990,4968991,4968992,4968993,4968994,4968995,4968996,4968997,4968998,4968999,4969002,4969003,4969004,4969005,4969006,4969007,4969009,4969010,4969011,4969012,4969013,4969014,4969015,4969016,4969017,4969020,4969027,4969028,4969029,4969030,4969031,4969033,4969034,4969035,4969036,4969037,4969040,4969042,4969043,4969044,4969045,4969046,4969047,4969048,4969049,4969050,4969051,4969053,4969054,4969055,4969059,4969061,4969062,4969063,4969066,4969071,4969072,4969073,4969074,4969076,4969077,4969078,4969079,4969080,4969081,4969082,4969083,4969084,4969085,4969086,4969087,4969088,4969090,4969091,4969092,4969093,4969094,4969095,4969096,4969098,4969099,4969100,4969101,4969102,4969103,4969104,4969105,4969106,4969107,4969108,4969110,4969111,4969112,4969113,4969114,4969115,4969116,4969117,4969118,4969119,4969120,4969121,4969122,4969123,4969124,4969125,4969126,4969127,4969128,4969129,4969130,4969131,4969132,4969133,4969134,4969135,4969136,4969137,4969138,4969139,4969140,4969141,4969142,4969143,4969144,4969145,4969146,4969147,4969148,4969149,4969150,4969151,4969152,4969153,4969154,4969155,4969156,4969157,4969158,4969159,4969160,4969161,4969162,4969163,4969164,4969165,4969166,4969167,4969168,4969169,4969170,4969171,4969172,4969173,4969174,4969175,4969176,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969184,4969187,4969188,4969189,4969190,4969191,4969193,4969194,4969195,4969196,4969197,4969198,4969201,4969204,4969205,4969207,4969210,4969212,4969213,4969214,4969215,4969217,4969218,4969220,4969228,4969229,4969230,4969231,4969232,4969233,4969234,4969235,4969236,4969237,4969238,4969239,4969245,4969247,4969248,4969249,4969250) 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'