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(10939571,10939572,10939573,10939574,10939576,10939577,10939580,10939584,10939585,10939586,10939592,10939602,10939612,10939615,10939616,10939630,10939631,10939642,10939643,10939646,10939647,10939648,10939649,10939650,10939810,10939903,10940106,10940107,10940166,10940167,10940169,10940182,10940186,10940191,10940195,10940199,4970903,4970925,10940337,4970988,10940403,10940430,10940440,4971066,4971067,10940495,10940496,10940497,10940512,10940516,10940517,10940520,10940523,10940529,10940535,10940536,10940551,10940555,10940558,8067071,4968370,8067157,8067522,8067584,8067599,8067600,8067601,8067602,8067613,8067618,8067620,8067622,8067636,8067655,8067790,4969139,4969140,10938707,10938708,10938709,10938787,10938788,10938828,10939039,10939398,10939456,8065145,8065583,8065797,8065928,8065932,8065933,8065934,8065935,8065936,8066122,8066165,8066190,8066455,8066456,8066457,8066558,8066559,8066560,8066575,8066576,8066577,8066578,8066579,8066580,8066659,8066660,8066661,8066662,8066663,8066664,8066665,8066666,8066667,8066668,8066669,8072552,8072553,8072584,8072585,8072698,8072699,8072700,8072701,8072702,8073445,8073447,8073449,8073450,8073479,10623057,10623058,10623059,10623062,10623190,10623487,10623503,10623582,10623881,10624288,10624321,10624819,10624820,10624821,10624822,10624823,10624824,10624825,10624826,10624841,10621982,10622059,10622084,10622085,10622086,10622087,10622193,10622194,10622260,10622261,10622263,10622270,10622273,10622276,10622277,10622290,10622292,10622296,10622304,10622322,10622335,10622343,10622361,10622362,10622364,10622371,10622375,10622378,10622379,10622380,10622381,10622382,10622383,10622399,10622409,10622411,10622417,10622427,10622429,10622430,10622433,10622439,10622457,10622458,10622506,10622518,10622522,10622524,10622527,10622528,10622548,10622549,10622734,10622747,10622748,10622749,10622813,10622814,10620083,10620208,10620323,10620324,10620325,10620328,10620329,10620358,10621134,10621368,10621369,10621370,10621422,10621423,10621432,10621433,10621434,10621440,10621441,10621442,10621443,10621448,10621453,10621454,10621497,10621502,10621503,10621504,10621511,10621512,10621524,10621534,10621610,10621611,10621612,10621613,10621614,10621615,10621616,10621617,10621618,10621619,10621627,10621628,10621629,10621630,10621635,10621636,10621638,10621639,10621641,10621644,10621647,10621667,10621686,10621695,10621712,10621717,10621719,10621958,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10565192,10565193,10565329,10565330,10565349,10566087,10563546,10563553,10563554,10563555,10563586,10563626,10563649,10563650,10563651,10563652,10563653,10563654,10563657,10563690,10563698,10563700,10563733,10563734,10563735,10563736,10563737,10563738,10563739,10563740,10563745,10563746,10563747,10563748,10563750,10563752,10563753,10563754,10563755,10563756,10563757,10563758,10563759,10563762,10563763,10563764,10563765,10563766,10563767,10563768,10563769,10563770,10563771,10563772,10563773,10563774,10563775,10563777,10563779,10563780,10563781,10563782,10563783,10563784,10563785,10563788,10563797,10563814,10563815,10563816,10563817,10563818,10563819,10563820,10563821,10563834,10563835,10563843,10563844,10563845,10563846,10563867,10563868,10563869,10563870,10563871,10563872,10563873,10563885,10563886,10563887,10563888,10563889,10563905,10563906,10563907,10563908,10563909,10563920,10563921,10563922,10563926,10563956,10563984,10563985,10563986,10563987,10563990,10563992,10563993,10563994,10563995,10563996,10563997,10563998,10563999,10564004,10564013,10564014,10564015,10564016,10564017,10564018,10564019,10564020,10564021,10564022,10564023,10564024,10564025,10564026,10564039,10564042,10564043,10564049,10564050,10564051,10564061,10564062,10564063,10564064,10564065,10564066,10564067,10564068,10564069,10564070,10564071,10564072,10564074,10564075,10564076,10564077,10564078,10564079,10564080,10564081,10564082,10564084,10564085,10564086,10564087,10564088,10564089,10564090,10564091,10564092,10564093,10564094,10564095,10564096,10564097,10564098,10564099,10564100,10564101,10564102,10564118,10564119,10564120,10564121,10564123,10564124,10564126,10564127,10564129,10564143,10564144,10564145,10564152,10564153,10564154,10564201,10564202,10564203,10564204,10564212,10564213,10564236,10564237,10564238,10564239,10564240,10564241,10564242,10564243,10564244,10564245,10564246,10564247,10564248,10564249,10564250,10564251,10564252,10564301,10564302,10564303,10564304,10564305,10564306,10564307,10564308,10564309,10564310,10564347,10564348,10564349,10564350,10564351,10564352,10564353,10564354,10564355,10564356,10564357,10564358,10564359,10564360,10564361,10564362,10564363,10564364,10564365,10564366,10564367,10564368,10564369,10564370,10564371,10564372,10564373,10564374,10564375,10564398,10564399,10564400,10564401,10564402,10564403,10564404,10564405,10564406,10564407,10564408,10564415,10564416,10564417,10564418,10564419,10564420,10564421,10564422,10564423,10564424,10564425,10564427,10564433,10564442,10564443,10564447,10564989,10564990,10564991,10564992,10564993,10564994,10517112,10517113,10517114,10517115,10517116,10517118,10517119,10517120,10517121,10517122,10517123,10517124,10517125,10517126,10517127,10517128,10517129,10517130,10517131,10517132,10517133,10517134,10517135,10517136,10517137,10517138,10517139,10517140,10517142,10517143,10517144,10517145,10517146,10517147,10517148,10517151,10517152,10517153,10517154,10517155,10517156,10517157,10517158,10517159,10517160,10517161,10517162,10517163,10517164,10517165,10517166,10517167,10517168,10517169,10517172,10517173,10517174,10517175,10517176,10517177,10517178,10517179,10517180,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,10517215,10517216,10517217,10517218,10517219,10517230,10517238,10517239,10517240,10517241,10517243,10517244,10517245,10517247,10517248,10517249,10517250,10517251,10517254,10517256,10517258,10517259,10517261,10517262,10517263,10517264,10517265,10517266,10517271,10517272,10517273,10517274,10517275,10517276,10517279,10517282,10517283,10517284,10517286,10517290,10517291,10517292,10517293,10517296,10517297,10517315,10517316,10517326,10517345,10517398,10517399,10517408,10517409,10517410,10517411,10517412,10517413,10517420,10517421,10517497,10517550,10517551,10517563,10517593,10517594,10517595,10517596,10517597,10517598,10517599,10517600,10517601,10517602,10517603,10517604,10517605,10517606,10517620,10517650,10517651,10517652,10517653,10517654,10517655,10517680,10517681,10517682,10517683,10517684,10517820,10517821,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,10419422,10419425,10419426,10419607,10419614,10419632,10419633,10419637,10419666,10419667,10419730,10419889,10419910,10419920,10419928,10419969,10420137,10420141,10420142,10420143,10420144,10420148,10420159,10420177,10420202,10420205,10471029,10471179,10471182,10471192,10471210,10471211,10471212,10471213,10471214,10471215,10471216,10471217,10471218,10471219,10471220,10471221,10471222,10471223,10471224,10471225,10471226,10471227,10471230,10471231,10471232,10471233,10471234,10471235,10471236,10471237,10471239,10471240,10471241,10471242,10471244,10471265,10471336,10471566,10471573,10471574,10471578,10471579,10471580,10471583,10471584,10471586,10471587,10471588,10471592,10471594,10471595,10471599,10471600,10471605,10471608,10471609,10471615,10471618,10471619,10471622,10471624,10471630,10471632,10471633,10471634,10471635,10471636,10471637,10471638,10471639,10471640,10471641,10471642,10471643,10471644,10471645,10471646,10471647,10471648,10471649,10471650,10471656,10471657,10471660,10471661,10471663,10471664,10471665,10471670,10471671,10471673,10471675,10471676,10471680,10471683,10471692,10471700,10471701,10471703,10471705,10471706,10471707,10471710,10471716,10471719,10471721,10471723,10471724,10471728,10471729,10471730,10471731,10471732,10471733,10471734,10471735,10471739,10471743,10471744,10471747,10471749,10471753,10471754,10471755,10471756,10471757,10471761,10471762,10471763,10471766,10471768,10471770,10471771,10471773,10471774,10471775,10471783,10471784,10471785,10471788,10471790,10471794,10471795,10471798,10471801,10471819,10471821,10471834,10471855,10471857,10471864,10469974,10469975,10469976,10469977,10469981,10469983,10469989,10469997,10469998,10469999,10470000,10470032,10470033,10470034,10470035,10470045,10470049,10470053,10470054,10470055,10470056,10470057,10470147,10470237,10470312,10470313,10470314,10470315,10470316,10470317,10470318,10470319,10470320,10470321,10470322,10470323,10470324,10470325,10470326,10470327,10470328,10470329,10470330,10470331,10470332,10470333,10470334,10470335,10470336,10470337,10470338,10470339,10470340,10470341,10470342,10470343,10470344,10470397,10470493,10470494,10470495,10470513,10470595,10470799,10470800,10470801) 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'