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,8068882,8068883,8068884,8068892,10939633,10939650,10943458,10943459,10939724,10939748,4970666,10940170,10940193,10940194,10940197,10940288,10940289,10940290,10940291,10940411,4971060,10940516,10940517,10940524,8066885,8066888,8066899,8066900,8066914,8066917,8066946,8066959,8066978,8067208,4968616,8067353,8067354,8067355,10437251,10437252,8067376,4968654,4968655,4968656,4968657,4968658,4968659,4968660,4968661,4968662,4968663,8067510,8067614,8067641,8067645,8067651,8067656,8067657,8067659,8067660,8067661,8067662,8067663,8067673,8067674,8067701,8067702,8067703,8067704,8067705,8067706,8067714,8067715,10437611,8067740,10437624,10437625,10437629,10437630,10938494,10938495,10938496,10938497,10938498,10437792,10437793,8067909,8067978,8067979,8067980,8067985,8067986,8067987,8068014,8068015,8068058,8068059,8068060,8068061,8068062,8068080,8068124,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068259,8068260,8068261,4969615,8068262,4969616,4969617,4969618,8068277,8068278,8068279,8068325,8068326,8068327,8068328,8068351,8068352,8068389,8068390,8068391,8068392,8068393,8068394,8068404,8068405,8068444,8068445,8068446,8068454,10939201,8068476,8068517,8068518,8068547,8068548,8068549,8068550,8068551,8068586,8068587,8068588,8068589,8068590,8068604,8068607,8068627,8068628,8068646,8068651,8068664,8068671,8068682,8068690,8068698,8068707,8068725,8068728,8068737,8068738,8068739,8068747,8068763,8068767,8068768,8068769,8068770,8068771,8068772,8065222,8065223,10931637,10931641,10931772,10932210,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,10932364,10932365,10932366,10932367,10932368,8066020,8066022,8066023,8066121,8066180,8066203,8066227,8066264,8066265,8066266,8066267,8066334,8066335,8066336,8066342,8066357,8066358,8066361,8066375,8066376,8066412,8066413,8066414,8066415,8066416,8066426,8066427,8066428,8066478,8066479,8066480,8066481,8066490,8066517,8066518,8066519,8066550,8066551,8066552,8066553,8066554,8066562,8066564,8066567,8066568,8066569,8066570,8066571,8066581,10932957,10932959,10932961,8066598,8066599,8066600,8066640,8066641,8066642,8066643,8066644,8066671,10933045,10933046,8066681,8066685,8066686,8066687,8066688,8066689,8066704,8066705,8066706,8066707,8066708,8066709,8066710,8066711,8066726,8066727,8066728,8066729,8066731,8066732,8066733,8066795,8066805,8066806,8066822,8066823,8066824,8066825,8066826,8066842,8066843,8066855,8066856,8066857,8066871,8066872,8066873,8064008,8064009,8064010,10942812,10942828,10942829,10942854,10942890,10942897,10942903,10942904,10942921,10942922,10942923,10942929,10942932,10942938,10942962,10942969,10942985,10942986,10942987,10942988,10942989,10942990,10942991,10942992,10942993,10942994,10942995,10942996,10942997,10942998,10942999,10943000,10943001,10943002,10943003,10943006,10943007,10943045,10943048,10943052,10943053,10943054,10943079,10943088,10943089,10943328,8970235,8970236,8970237,10931203,10931204,3655508,3655509,3655510,3655511,3655552,3655567,3655642,3655689,3655690,3655692,3655693,3655694,3655695,3655696,3655697,3655698,3655699,3655700,10940825,10940900,3656214,3656265,8072432,8072473,8072497,8072498,8072499,8072509,8072510,8072524,8072525,8072526,3656452,3656461,3656462,3656473,3656479,3656482,3656483,8072708,8072709,8072710,8072711,8072712,3656594,3656638,3656660,3656694,3656695,10941747,10942068,10942155,10942188,10942189,10942190,10942260,10942269,10923484,10923485,10923486,10923487,10923488,10923489,10923490,10923491,10923492,10923493,10923514,10918517,10918518,10923521,10923522,10923523,10923524,10923525,10923526,10923527,10923547,10923568,10923569,10923570,10923580,10918612,10918702,10923742,10923743,10923744,10923745,10923746,10923747,10923748,10923749,10923750,10923751,10923752,10923753,10923754,10923830,10923831,10923832,10923833,10923834,10923835,10623325,10923836,10923887,10923888,10923889,10923890,10923891,10923892,10923893,10923894,10923895,10918904,10918905,10918906,10918907,10918908,10918909,10918910,10623419,10923980,10924063,10924064,10924065,10924066,10924067,10924148,10924149,10924150,10924151,10924152,10924153,10924154,10924155,10924156,10924157,10924158,10924159,10924230,10924255,10924266,10919284,10919285,10919286,10919287,10919288,10919289,10924295,10924296,10924302,10924307,10924308,10924318,10924319,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,10919592,10919593,10919594,10919595,10919596,10919597,10919598,10919599,10919600,10919607,10919608,10919609,10919610,10919611,10919612,10919613,10919914,10919915,10920161,10920162,10624804,10917503,10917504,10917505,10622104,10622105,10622125,10917756,10622274,10622380,10622399,10917958,10917959,10917960,10918034,10918035,10622715,10918342,10918343,10918344,10918345,10918346,10918353,10622903,10620218,10620244,10620245,10620246,10620247,10620248,10620249,10620250,10620251,10620301,10915835,10915836,10915837,10915838,10915839,10915840,10915841,10620339,10620388,10620404,10620426,10620874,10620875,10620876,10621121,10621122,10621137,10621145,10621150,10621153,10621243,10621262,10621307,10621308,10621309,10621335,10621357,10621358,10621384,10621385,10621389,10621397,10621398,10621399,10621414,10621415,10621416,10621417,10621418,10621419,10621457,10621466,10621467,10621468,10621476,10621486,10621487,10621488,10621493,10621507,10621512,10621544,10621567,10621619,10917152,10621659,10621660,10621673,10621707,10621708,10621709,10621719,10621725,10621733,10621744,10611461,10611462,10611463,10611464,10565614,10611465,10565615,10611466,10565616,10611467,10565617,10611468,10565618,10611469,10565619,10611470,10565620,10611471,10565621,10611472,10565622,10611473,10565623,10611474,10565624,10611475,10611476,10611477,10611478,10611672,10611673,10611721,10611941,10609834,10610005,10610015,10610040,10610048,10610729,10610730,10610731,10610850,10610954,10555466,10555467,10555468,10555469,10555470,10555471,10555472,10555473,10555474,10555475,10555985,10555986,10555987,10555988,10555989,10555990,10555991,10555992,10555993,10555994,10555995,10555996,10556023,10556024,10556025,10556026,10415226,10415227,10415947,10415957,10415975,10416096,10463006,10463009,10463045,10463047,10463048,10463049,10463050,10463051,10463052,10463057,10463058,10463431,10463433,10463436,10463437,10471487,10463648,10463649,10463650,10463651,10463652,10463653,10463654,10463655,10463656,10463657,10463658,10463659,10463660,10463661,10463662,10463663,10463664,10463665,10463666,10463667,10463668,10463669,10463670,10463671,10463672,10463673,10463674,10463675,10463731,10463741,10463781,10463791,10463794,10463800,10463801,10463807,10463808,10463809,10469994,10469995,10469996,8563375,8563384,8563388,8563389,8563392,10470074,10470121,10470122,10470123,10470124,10470125,8563460,10470240,10470322,10470389,10470393,10462415,10462428,10470498,10470506,10462527,10462528,10462532,10462533,10470669,10462730,10462731,10462733,10462734,10462735,10462736,10462737,10462738) 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'