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(10939564,10939586,10939593,8068884,10939638,10939650,10943450,10943458,10943459,10939711,10939712,10939713,10939714,10939715,10939716,10939718,10939725,10939751,10939752,10939753,10939754,10939755,10939810,10943654,10943655,10943665,10939874,10939875,10943676,10939882,10939883,10939926,10940039,10940040,10940041,10940042,10940043,10940044,10943873,10943874,10943878,10943879,10943880,10943881,4970700,4970706,4970751,10940160,10940167,10940168,10940169,10940170,10940171,10940193,4970835,10944047,10944048,10944070,4970872,10944156,4970971,10940430,10940458,10940466,4971060,10944285,10944337,4971143,4968195,4968196,10933330,10933360,4968297,4968298,4968299,4968300,4968301,4968302,4968303,4968321,10933452,4968322,10933453,10933454,4968323,4968324,10933455,10933456,4968325,4968326,10933457,10933458,4968327,4968328,10933459,4968329,10933460,4968330,4968331,4968332,4968333,4968334,10933466,4968335,4968336,10933467,4968337,10933468,10933469,4968338,4968339,4968341,4968342,4968343,4968359,4968360,8067159,8067160,8067161,8067162,10437040,8067163,8067164,8067165,8067166,8067167,8067168,10437104,8067287,8067298,8067302,10437187,10437256,8067384,8067388,10437312,10437313,4968678,4968679,4968680,10437318,10437319,10437320,10437331,10437399,4968775,4968776,4968777,4968778,8067549,8067582,4968849,4968859,4968860,4968861,8067656,8067657,8067749,8067778,8067779,8067785,10437669,10938492,10938493,10938494,10938495,10938496,10938497,10938498,10437762,10437763,10437764,10437765,10437766,10437767,10437768,10437770,10437771,10437772,10437788,8067867,10938644,10938687,8067969,8067971,8067972,8067974,8067975,8067976,8067977,10938752,10938897,4969509,4969510,4969511,4969512,10938936,4969590,10939005,10939015,10939018,10939072,10939151,10939160,10939161,10939176,8068512,8068513,8068514,8068516,8068517,8068518,8068519,10939271,8068790,8068800,8068801,10931437,8065083,10931470,10931472,10931477,10931478,8065158,10931650,10931662,10931671,8075133,10931746,8075134,8075135,8075136,8075137,10931774,8075176,8075177,8075178,8075179,8075180,10931902,10932002,10932003,10932004,10932005,10932007,10932024,10932025,8065661,10932070,8075474,8075475,8075476,8075477,8075478,8075479,8075480,8075481,8075482,8075483,8075484,8075486,8075487,10932121,10932122,10932156,10932157,4967031,10932172,4967112,10932243,4967113,4967114,4967115,4967116,4967117,4967118,4967119,4967120,4967121,4967122,4967123,4967124,4967125,4967126,4967127,4967128,10932260,4967129,10932261,4967130,4967131,4967132,4967133,4967134,4967135,4967136,4967137,4967138,4967139,4967140,4967143,4967145,8065982,10932498,8066233,8066234,8066235,8066238,8066241,10932799,10932832,10932833,10932840,10932874,10932887,10932888,10932889,10932890,10932905,10932917,8066558,8066560,10932999,10933015,10933039,10933040,10933041,10933070,10933072,8073708,8073709,8073710,8073711,8073712,8073762,8073763,8073764,8073765,8064008,8073766,8064009,8064010,10942690,8073811,8073812,8073813,8073814,8073815,10942769,8064260,10942965,10942968,10942969,10943052,10943053,10943054,10943109,10943137,10943150,10943164,10943166,10943169,10943176,10943229,10943237,10943238,10943239,10943243,10943250,10943355,8064736,8970192,8064790,8064791,8064792,8064856,3655566,3655567,10940710,10940794,10940795,10940834,10940837,10940838,10940839,10940850,10940885,10940886,10940887,10940888,10941099,3656116,10941190,3656226,10941291,3656260,10941355,10941356,10941376,8072655,3656627,3656628,3656629,3656630,3656645,3656646,3656647,3656673,3656674,3656675,3656699,3656700,3656704,3656836,3656839,3656840,3656867,3656868,3656869,3656873,3656874,3656878,3656879,3656887,3656888,3656889,3656890,3656891,3656892,3656893,3656894,3656895,3656896,3656897,3656898,3656899,10942065,10942124,10942125,10942141,3657120,3657121,3657122,3657136,3657137,3657138,3657139,3657140,3657141,3657142,3657143,3657144,3657145,3657146,3657147,10942214,10942217,10942276,11049637,11049639,11049640,11049641,8073537,8073543,11049679,11049680,11049681,10942496,11049737,11049738,11049739,11049740,10942536,10942537,8073654,8073655,8073656,8073657,8073658,8073659,10918517,10918518,10918525,10918526,10918534,10918535,10923580,10923594,10923595,10923596,10918607,10918608,10918609,10918610,10918733,10918752,10918754,10918755,10918805,10918806,10918807,10918813,10918816,10918818,10623314,10923830,10623405,10623658,10919192,10919194,10623693,10623783,10623842,10623843,10623844,10623845,10623887,10623963,10623964,10919496,10919497,10919498,10919535,10919536,10919537,10919538,10919540,10919541,10919546,10919547,10624044,10624045,10624046,10624245,10919828,10919848,10919849,10919852,10919853,10920025,10920029,10624729,10624730,10622086,10622228,10622229,10622230,10622231,10622232,10917748,10917752,10917753,10917756,10917757,10917758,10917759,10917760,10917761,10917762,10917763,10917766,10622277,10622280,10622281,10622282,10622409,10622429,10917996,10918004,10918006,10622605,10622606,10622607,10622608,10622609,10622610,10622611,10622612,10622613,10622614,10622615,10622616,10622617,10622618,10622619,10622620,10622621,10622622,10622623,10622624,10622625,10918137,10622915,10915473,10620106,10620216,10620222,10620223,10620264,10620353,10620354,10620356,10620402,10620499,10620539,10620540,10620541,10620547,10620549,10620550,10620551,10620554,10620555,10620556,10620557,10620559,10620640,10620990,10620993,10621057,10621070,10621226,10621227,10621248,10621249,10621250,10621381,10621382,10621384,10621385,10621423,10917040,10917041,10917042,10917410,10917411,10917447,10610969,10610970,10565154,10611025,10611053,10611054,10611083,10611123,10611147,10611151,10611152,10611158,10611161,10611162,10611163,10565328,10611196,10611267,10611323,10611337,10611399,10611400,10611452,10611462,10611494,10611495,10611532,10565700,10611677,10565870,10565874,10611775,10565927,10611777,10611800,10611810,10611861,10611862,10566013,10611879,10609141,10609259,10563427,10609282,10609286,10609318,10609319,10609339,10609353,10609397,10609398,10563584,10563694,10563695,10563696,10563697,10563698,10563699,10563700,10609607,10609625,10609626,10609630,10563794,10563797,10563798,10563799,10563800,10563801,10563802,10563803,10563804,10563805,10563806,10563807,10563808,10563809,10563810,10563811,10563812,10563813,10563814,10563815,10563816,10563817,10563818,10563819,10563820,10563821,10563822,10609708,10609745,10563924,10563925,10563926,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563934,10563935,10563938,10563939,10563940,10563941,10609824,10609827,10609842,10609898,10564130,10564131,10564132,10609983,10564133,10564134,10564135,10564136,10564137,10564138,10564139,10564140,10564141,10564142,10564143,10564144,10564145,10610012,10610041,10610046,10610052,10610054,10610073,10610074,10610120,10564386,10564414,10610293,10564749,10564754,10610668,10610689,10610693,10610775,10610777,10610833,10610834,10610860,10610953,10610959,10517256,10517257,10517258,10517950,10517951,10517952,10517953,10517954,10517955,10517956,10517957,10518046,10518047,10518048,10518049,10518050,10518051,10518052,10518053,10518054,10518055,10518056,10518057,10518058,10518059,10518060,10518061,10518062,10518063,10518064,10518065,10518066,10518067,10518068,10518069,10518070,10518071,10518072,10518073,10518074,10556267,10556271,10556437,10556438,10518914,10518915,10518916,10518917,10518918,10518919,10518920,10518921,10518922,10518923,10518924,10518925,10518926,10518927,10518928,10518929,10518932,10518971,10557019,10419302,10415335,10415336,10415342,10415362,10419371,10419384,10419440,10419450,10419469,10419500,10415571,10419576,10419596,10419600,10415657,10415661,10415671,10415674,10415692,10419707,10419708,10419709,10415727,10415738,10415746,10415747,10415748,10415761,10415762,10415783,10415784,10415793,10415816,10419819,10419820,10415828,10415831,10419846,10419852,10415856,10415857,10415858,10415881,10415897,10415899,10415900,10415902,10415909,10415910,10415913,10419932,10419933,10419934,10419935,10419936,10419937,10419938,10419939,10419940,10419941,10419942,10419943,10419944,10415954,10415971,10415999,10416000,10416011,10416012,10416023,10416027,10416028,10420032,10420039,10420057,10416061,10420069,10416083,10416084,10420102,10420103,10420104,10420105,10420106,10420107,10416156,10416157,10420171,10420172,10462907,10463002,10471023,10463029,10471032,10471109,10471110,10471128,10463169,10471278,10471487,10471499,10471510,10471577,10469931,10469965,10469966,10469974,10469975,10469976,10469977,10470091,10470137,8563463,8563464,10470146,8563478,8563545,8563546,8563550,8563576,10470315,10470356,10470373,10470374,10470375,10462395,10462673,10462723,10470723,10462724,10462725,10470725,10462728,10462730,10462731,10462733,10470733,10462734,10462735,10462736,10462737,10462738,10462740,10462743,10462744,10462754,10462757) 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'