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(10939566,8068843,8068869,8068870,8068871,8068872,8068889,8068890,8068891,10939650,10943450,4970702,10944076,10944077,10944078,10944079,4970994,4971026,4971027,4971060,10933309,10933323,10933330,8067070,10437194,10437268,10437325,8067482,8067488,4968761,4968762,4968763,4968764,4968765,4968766,8067528,4968767,8067529,4968768,8067530,4968769,4968770,8067531,8067532,4968771,4968772,8067533,4968773,4968774,8067535,8067536,4968775,4968776,4968777,4968778,4968779,8067540,4968780,4968781,4968782,8067544,4968783,4968784,4968785,4968786,8067549,8067551,8067574,8067589,8067590,8067656,8067657,8067658,8067659,8067660,8067661,8067662,8067672,10437571,10437624,8067906,10938909,10938910,10938911,10938912,4969606,4969607,4969608,4969609,4969610,4969611,4969612,4969613,4969614,10939199,10939200,10939418,8068813,10931531,10931536,10931548,8065208,8065209,8065210,8065211,8065212,8065213,8065214,8065215,8065216,8065217,8065218,8065219,8065220,8065221,10932038,4967105,10932589,8066441,10932830,10932852,10932854,10932857,10932867,10932869,10932870,10932871,10932872,10932873,10932874,10932875,10932876,10932887,10932888,10932891,10932905,10932908,10932909,10932911,10932912,10932913,10932914,10932917,10932918,10932919,10932921,10932922,10932925,10932928,10932942,10932943,10932944,10932945,10932946,10932948,10932949,10932950,10932951,10932953,10932954,10932956,10932958,10932960,10932961,10932971,10932972,10932973,10932976,10932978,10932993,10933038,10933041,10933043,10933050,10933059,10933060,10933061,4967930,10933087,10942769,10942770,10942771,10942772,10942773,10942774,10942780,10942790,10942791,10942792,10942793,10942897,10942898,10942899,10942963,10942964,10942965,10942966,10942967,10942968,10942969,10942970,10942971,10942972,10942973,10942974,10942975,10942976,10942977,10942978,10942979,10942980,10942981,10942982,10942983,10942984,10942988,10942989,10942990,10942991,10942992,10942993,10942994,10942995,10942996,10942997,10942998,10942999,10943000,10943001,10943002,10943003,10943109,10943110,10943121,10943249,10943291,8970209,8970235,8970236,8970237,8064868,10941286,10941287,10941288,10941289,10941290,10941291,10941292,10941293,3656375,3656376,3656478,3656479,3656504,3656516,3656544,8073545,8073547,8073548,8073549,8073550,8073551,11049749,11049750,11049751,10923487,10923488,10918535,10918604,10918605,10918606,10918607,10918608,10918609,10918610,10918611,10918659,10918660,10918737,10918815,10918816,10918875,10918903,10919195,10924281,10924282,10924283,10924284,10924285,10924286,10924287,10924291,10924292,10924293,10924294,10924307,10924308,10924309,10924310,10924311,10924312,10924313,10924314,10924315,10924316,10924317,10924318,10924319,10924320,10924321,10924322,10924323,10924324,10924325,10924326,10924327,10924328,10924329,10924330,10924331,10924332,10924333,10924334,10924335,10924336,10924337,10924338,10924339,10924340,10924341,10924342,10924343,10924344,10924345,10924346,10924347,10924348,10924349,10924350,10924351,10924352,10924353,10924354,10924355,10924356,10924357,10924358,10924359,10924360,10924361,10924362,10924363,10924364,10924365,10924366,10924367,10924368,10924369,10924370,10924371,10924372,10924373,10924374,10924375,10924376,10924377,10924378,10924379,10924380,10924381,10924382,10924383,10924384,10924385,10924386,10924387,10924388,10924389,10924390,10924391,10924392,10924393,10924394,10924395,10924396,10924397,10924398,10924399,10924400,10924401,10924402,10924403,10924404,10924405,10924406,10924407,10924408,10924409,10924410,10924411,10924412,10924413,10924414,10924415,10924416,10924417,10924418,10924419,10924420,10924421,10924422,10924423,10924424,10924425,10924426,10924427,10924428,10924429,10924430,10924431,10924432,10924433,10924434,10924435,10924436,10924437,10924438,10924439,10924440,10924441,10924442,10924443,10924444,10924445,10924446,10924447,10924448,10924449,10924450,10924451,10924452,10924453,10924454,10924455,10924456,10924457,10924458,10924459,10924460,10924461,10924462,10924463,10924464,10924465,10924466,10924467,10924468,10924469,10924470,10924471,10924472,10924473,10924474,10924475,10924476,10924477,10924478,10924479,10924480,10924481,10924482,10924483,10924484,10924485,10924486,10924487,10924488,10924489,10924490,10924491,10924492,10924493,10924494,10924495,10924496,10924497,10924498,10924499,10924500,10924501,10924502,10924503,10924504,10924505,10924506,10924507,10924508,10924509,10924510,10924511,10924512,10924513,10924514,10924515,10924516,10924517,10924518,10924519,10924520,10924521,10924522,10924523,10924524,10924525,10924526,10924527,10924528,10924529,10924530,10924531,10924532,10924533,10924534,10924535,10924536,10924537,10924538,10924539,10919539,10924540,10924541,10924542,10924543,10924544,10924545,10924546,10924547,10924548,10924549,10924550,10924551,10924552,10924553,10924554,10924555,10924556,10924557,10924558,10924559,10924560,10924561,10924562,10924563,10924564,10924565,10924566,10924567,10924568,10924569,10924570,10924571,10924572,10924573,10924574,10919837,10919849,10919909,10919910,10919911,10919912,10919913,10920023,10920123,10624633,10920150,10920151,10920152,10920153,10920154,10920155,10920156,10920157,10920158,10920159,10920160,10920161,10624668,10624669,10624670,10624671,10624672,10624673,10624674,10624675,10624676,10624677,10624678,10624679,10624680,10624681,10624682,10624683,10624684,10624685,10624686,10624687,10624688,10624689,10624690,10624691,10624692,10624693,10624694,10624695,10925367,10624857,10925368,10624858,10925369,10624859,10925370,10624860,10624889,10624890,10624891,10922474,10922477,10922486,10922489,10922496,10922497,10922498,10917500,10917501,10917502,10917506,10922515,10622017,10622029,10622030,10622031,10622042,10622055,10922617,10922644,10922647,10922652,10922655,10922656,10922662,10922665,10922680,10922685,10922686,10922687,10922688,10922689,10922690,10917752,10917753,10917754,10917755,10917756,10917757,10917758,10917759,10917760,10917761,10917956,10917957,10917959,10917960,10918008,10918009,10918032,10918033,10923114,10923117,10923118,10923119,10923121,10923122,10923124,10923145,10923149,10923152,10923154,10923157,10923158,10923162,10923163,10923166,10923167,10923168,10923170,10923172,10923173,10923177,10923178,10923179,10923180,10923181,10918185,10923189,10923194,10923195,10923197,10923202,10923203,10923268,10918354,10923415,10923416,10923417,10622950,10620121,10915731,10915732,10915733,10620238,10915800,10915801,10915802,10915803,10915804,10915805,10915806,10915807,10915808,10915809,10915810,10915811,10915812,10915813,10915814,10915815,10915816,10915817,10915818,10915819,10915820,10915821,10915822,10915823,10915824,10915825,10915826,10915827,10915828,10915829,10915830,10915831,10915832,10915833,10915834,10915835,10915842,10915843,10915844,10915845,10915846,10915847,10915848,10915849,10915850,10915851,10915852,10915853,10621359,10917040,10917041,10917134,10917135,10917136,10917137,10917138,10917139,10917140,10917141,10917142,10917143,10917144,10917145,10917146,10917147,10917148,10917149,10917150,10917151,10917153,10917154,10917155,10917412,10917413,10610963,10610965,10610969,10610970,10610971,10610980,10565138,10610992,10565153,10611249,10611396,10611399,10611400,10611403,10611414,10611426,10611427,10611428,10611429,10611430,10611433,10611437,10611439,10611441,10611443,10611459,10611469,10611472,10611477,10611479,10611480,10611483,10611485,10611487,10611488,10611489,10611490,10611494,10611495,10611496,10611497,10611498,10611499,10611502,10611503,10611504,10611506,10611508,10611509,10611510,10611531,10611532,10611550,10611551,10565707,10565708,10611562,10611564,10611565,10611583,10611591,10611599,10611603,10611604,10611608,10611609,10611610,10611620,10611621,10611625,10611626,10611637,10611638,10611663,10611664,10611665,10611666,10611675,10611676,10611677,10611856,10611878,10609268,10609592,10609782,10610038,10610041,10610175,10610176,10610177,10610178,10610180,10610181,10610182,10610200,10610203,10610211,10610213,10610220,10610221,10610222,10610223,10610224,10610243,10610645,10610664,10610668,10610669,10610675,10610701,10610756,10610786,10610834,10610844,10610847,10610848,10610849,10610856,10610860,10610863,10610868,10610872,10610903,10610931,10610942,10610960,10610961,10517244,10517245,10517246,10517247,10517248,10517249,10517250,10517251,10517252,10517253,10517254,10517255,10517256,10517257,10517258,10517259,10517260,10419266,10419296,10419297,10419298,10419319,10415416,10415418,10415424,10415427,10415438,10415439,10415444,10419482,10415484,10415485,10419491,10419569,10415580,10419631,10415694,10419777,10415917,10419921,10415929,10415933,10415937,10415939,10415940,10415943,10415958,10415993,10416011,10416012,10416013,10416014,10416015,10416016,10416017,10416018,10416031,10416108,10471587,10463748,10463796,10471828,10471850,10471874,8563248,8563385,8563386,8563387,8563388,8563389,8563390,8563391,8563392,8563545,8563546,10462325,10462330,10462429,10462511) 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'