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(4970411,4970412,4970413,4970414,4970415,4970416,4970666,4970674,4970706,4970715,4970716,4970717,4970718,4970738,4970741,4970765,4970766,4970782,4970835,4970856,4970872,4970904,4970960,4970962,4970971,4970998,4971000,4971002,4971006,4971011,4971015,4971018,4971024,4971027,4971056,4971058,4971060,4971065,4971122,4971143,4968152,4968153,4968155,4968159,4968161,4968164,4968173,4968180,4968184,4968185,4968191,4968194,4968195,4968196,4968197,4968198,4968200,4968204,4968208,4968209,4968210,4968218,4968219,4968221,4968222,4968223,4968224,4968225,4968226,4968227,4968228,4968229,4968230,4968231,4968232,4968233,4968235,4968236,4968237,4968238,4968241,4968247,4968248,4968249,4968250,4968251,4968252,4968253,4968255,4968256,4968257,4968258,4968259,4968260,4968261,4968262,4968263,4968264,4968265,4968266,4968267,4968273,4968275,4968285,4968297,4968298,4968299,4968300,4968301,4968302,4968303,4968315,4968316,4968317,4968318,4968319,4968320,4968321,4968322,4968323,4968324,4968325,4968326,4968327,4968328,4968329,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968341,4968342,4968343,4968344,4968345,4968346,4968347,4968348,4968349,4968350,4968351,4968352,4968353,4968354,4968355,4968356,4968357,4968358,4968359,4968360,4968361,4968362,4968363,4968364,4968365,4968366,4968367,4968368,4968369,4968370,4968371,4968372,4968373,4968374,4968375,4968376,4968377,4968378,4968379,4968380,4968381,4968382,4968383,4968384,4968385,4968386,4968387,4968388,4968389,4968390,4968391,4968392,4968393,4968394,4968395,4968396,4968397,4968398,4968399,4968400,4968401,4968402,4968403,4968404,4968405,4968406,4968407,4968408,4968409,4968410,4968411,4968412,4968413,4968420,4968422,4968428,4968429,4968430,4968431,4968432,4968434,4968444,4968445,4968446,4968447,4968448,4968449,4968450,4968451,4968452,4968461,4968462,4968463,4968464,4968465,4968466,4968467,4968468,4968469,4968470,4968471,4968472,4968473,4968474,4968475,4968476,4968477,4968481,4968482,4968491,4968495,4968496,4968497,4968498,4968501,4968507,4968511,4968516,4968519,4968524,4968528,4968540,4968542,4968551,4968552,4968553,4968554,4968555,4968556,4968557,4968567,4968568,4968569,4968570,4968584,4968602,4968603,4968605,4968607,4968616,4968617,4968618,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968628,4968629,4968630,4968631,4968632,4968633,4968635,4968636,4968637,4968638,4968639,4968640,4968641,4968642,4968643,4968644,4968647,4968648,4968649,4968650,4968651,4968654,4968655,4968656,4968657,4968658,4968659,4968660,4968661,4968662,4968663,4968664,4968665,4968666,4968667,4968668,4968669,4968670,4968671,4968678,4968679,4968680,4968688,4968690,4968696,4968701,4968710,4968715,4968718,4968724,4968725,4968726,4968727,4968728,4968742,4968744,4968760,4968761,4968762,4968763,4968764,4968765,4968766,4968767,4968768,4968769,4968770,4968771,4968772,4968773,4968774,4968775,4968776,4968777,4968778,4968779,4968780,4968781,4968782,4968783,4968784,4968785,4968786,4968787,4968788,4968790,4968795,4968803,4968806,4968807,4968814,4968815,4968816,4968817,4968818,4968819,4968820,4968821,4968822,4968826,4968832,4968834,4968835,4968836,4968838,4968846,4968847,4968848,4968849,4968855,4968856,4968857,4968859,4968860,4968861,4968862,4968863,4968864,4968865,4968866,4968867,4968868,4968869,4968870,4968871,4968872,4968873,4968874,4968875,4968876,4968877,4968878,4968879,4968880,4968881,4968882,4968883,4968884,4968885,4968886,4968887,4968889,4968890,4968895,4968898,4968902,4968903,4968904,4968905,4968906,4968907,4968908,4968909,4968910,4968911,4968912,4968913,4968914,4968915,4968916,4968917,4968918,4968920,4968923,4968924,4968926,4968927,4968928,4968929,4968930,4968931,4968932,4968933,4968934,4968935,4968936,4968937,4968938,4968939,4968942,4968945,4968946,4968949,4968956,4968965,4968968,4968969,4968975,4968977,4968978,4968988,4968991,4968996,4968997,4968998,4968999,4969000,4969001,4969003,4969007,4969008,4969009,4969010,4969011,4969012,4969013,4969017,4969022,4969023,4969026,4969029,4969030,4969033,4969036,4969037,4969047,4969051,4969052,4969053,4969054,4969055,4969056,4969057,4969058,4969059,4969060,4969061,4969062,4969063,4969064,4969065,4969066,4969067,4969068,4969069,4969070,4969071,4969072,4969073,4969074,4969076,4969081,4969091,4969096,4969098,4969101,4969102,4969108,4969115,4969119,4969121,4969124,4969125,4969126,4969127,4969128,4969129,4969135,4969136,4969137,4969138,4969139,4969140,4969141,4969142,4969143,4969144,4969145,4969146,4969147,4969148,4969149,4969150,4969151,4969152,4969155,4969156,4969157,4969159,4969160,4969161,4969163,4969169,4969171,4969177,4969178,4969179,4969189,4969190,4969191,4969192,4969194,4969196,4969197,4969200,4969201,4969202,4969203,4969204,4969205,4969206,4969210,4969215,4969216,4969217,4969218,4969219,4969220,4969221,4969222,4969223,4969224,4969225,4969226,4969227,4969228,4969229,4969230,4969231,4969232,4969233,4969234,4969235,4969236,4969238,4969243,4969248,4969249,4969250,4969251,4969330,4969348,4969509,4969510,4969511,4969512,4969528,4969533,4969534,4969535,4969536,4969537,4969542,4969608,4969609,4969610,4969611,4969612,4969613,4969614,4969615,4969616,4969617,4969618,4969623,4969626,4969672,4969979,4969980,8075128,8075129,8075130,8075131,8075132,8075133,8075134,8075135,8075136,8075137,8075138,8075139,8075140,8075141,8075142,8075143,8075144,8075145,8075146,8075147,8075148,8075149,8075150,8075151,8075152,8075153,8075154,8075155,8075156,8075157,8075158,8075159,8075160,8075161,8075162,8075163,8075164,8075165,8075166,8075167,8075168,8075169,8075170,8075171,8075172,8075173,8075174,8075175,8075176,8075177,8075178,8075179,8075180,8075181,8075182,8075183,8075184,8075185,8075186,8075187,8075188,8075189,8075190,8075191,8075192,8075193,8075194,8075195,8075196,8075197,8075198,8075199,8075200,8075201,8075202,8075203,8075204,8075205,8075206,8075207,8075208,8075209,8075210,8075211,8075212,8075213,8075217,8075288,8075541,8075544,4967030,4967031,4967112,4967113,4967114,4967115,4967116,4967117,4967118,4967119,4967120,4967121,4967122,4967123,4967124,4967125,4967126,4967127,4967128,4967129,4967130,4967131,4967132,4967133,4967134,4967135,4967136,4967137,4967138,4967139,4967140,4967143,4967145,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967599,4967890,4967891,4967892,4967893,4967895,4968029,4968032,4968033,4968034,4968035,4968036,4968056,4968060,4968061,4968062,4968063,4968064,4968065,4968066,4968067,4968068,4968069,4968070,4968071,4968072,4968073,4968076,4968117,4968122,4968123,4968124,4968125,4968126,4968127,4968128,4968129,4968130,4968131,4968132,4968133,4968134,4968135,4968139,4968147,4968150,4968151,8073670,8073671,8073672,8073673,8073674,8073675,8073676,8073677,8073678,8073679,8073680,8073681,8073682,8073683,8073684,8073685,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073696,8073697,8073698,8073699,8073700,8073701,8073702,8073703,8073704,8073705,8073706,8073707,8073708,8073709,8073710,8073711,8073712,8073713,8073714,8073715,8073716,8073717,8073718,8073719,8073720,8073721,8073722,8073723,8073724,8073725,8073726,8073727,8073728,8073729,8073730,8073731,8073732,8073733,8073734,8073735,8073736,8073737,8073738,8073739,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073749,8073750,8073751,8073752,8073753,8073754,8073755,8073756,8073757,8073758,8073759,8073760,8073761,8073762,8073763,8073764,8073765,8073766,8073767,8073768,8073769,8073770,8073771,8073772,8073773,8073774,8073775,8073776,8073777,8073778,8073779,8073780,8073781,8073782,8073783,8073784,8073785,8073786,8073787,8073788,8073789,8073790,8073791,8073792,8073793,8073794,8073795,8073796,8073797,8073798,8073799,8073800,8073801,8073802,8073803,8073804,8073805,8073806,8073807,8073808,8073809,8073810,8073811,8073812,8073813,8073814,8073815,8073816,8073817,8073818,8073819,8073820,8073821,8073822,8073823,8073824,8073825,8073826,8073827,8073828,8073829,8073830,8073831,8073832,8073833,8073834,8073835,8073836,8073837,8073838,8073839,8073840,8073841,8073842,8073843,8073844,8073845,8073846) 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'