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(10943426,10939643,10943493,10939742,10939746,10939757,4970400,4970401,4970402,4970403,4970404,4970405,4970406,4970407,4970408,4970409,10939882,10939905,10939906,10939907,10939908,10939910,4970675,10940136,10940145,10940146,10940220,10940221,10940222,10940223,10940283,10940287,10940297,10940402,4971037,4971143,8066998,8067028,4968319,4968330,4968331,4968332,4968333,4968334,4968413,8067255,8067256,8067257,8067292,10437271,8067524,8067527,10437559,8067757,8067927,8067931,8067942,8067951,10938794,10938832,10938842,10938881,10939439,8065088,8065089,10931548,10931689,10931826,10931836,8065514,8065515,8065516,10931901,10931902,10931903,10931904,10931905,10931906,8075333,8075334,8075335,8075336,8065692,8065693,8065694,8065695,8065696,8065791,8065853,8065955,8065957,8066170,8066171,4967460,10932785,10932797,10932798,10932799,10932800,10932801,10932802,10932803,10932804,10932805,10932819,10932820,10932821,10932823,10932826,10932827,10932917,10932956,10932957,10932958,10932959,10932960,10932976,10932977,10932979,10933000,10942600,10942633,10943257,8064656,8970239,8071713,8071714,8071715,8071716,8071717,8071778,8071779,8071780,8071781,8071782,8071843,8071844,8071845,8071846,8071847,8071908,8071909,8071910,8071911,8071912,8071973,8071974,8071975,8071976,8071977,8072038,8072039,8072040,8072041,8072042,8072103,8072104,8072105,8072106,8072107,8072168,8072169,8072170,8072171,8072172,10941038,10941045,10941055,10941056,10941057,10941058,10941060,10941061,8072233,8072234,8072235,8072236,8072237,10941265,10941389,3656396,10941688,10941689,10941691,10941693,10941695,10941696,10941697,10941698,10941699,10941713,10941716,10941719,10941724,10941725,10941738,10941752,10941753,10941755,10941756,10941757,10941758,10941759,10941762,10941763,10941766,10941767,10941769,10941770,10941773,10941774,10941782,10941809,10941838,10941849,10941948,10941984,3656987,3656993,10942201,10623064,10623092,10623093,10623113,10623114,10623115,10623165,10623166,10623167,10623177,10623258,10623259,10623260,10623481,10623482,10623495,10623507,10623660,10623661,10623662,10623707,10623708,10623709,10623710,10623711,10623712,10623713,10623714,10623715,10623719,10623720,10623723,10623724,10623725,10623731,10623732,10623733,10623734,10623735,10623736,10623737,10623738,10623739,10623768,10623769,10623770,10623805,10624121,10624548,10624555,10624627,10624632,10624633,10922496,10922497,10922498,10922515,10922518,10922520,10622146,10622269,10922899,10622428,10622460,10622714,10622811,10622812,10622813,10622814,10622815,10622816,10622817,10620076,10620084,10620090,10620091,10620183,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620208,10620301,10620302,10620303,10620309,10620310,10620311,10620312,10620313,10620330,10620331,10620336,10620427,10620559,10620717,10620764,10620765,10620766,10620767,10620768,10620769,10620770,10620771,10620772,10620773,10620774,10620775,10620776,10620777,10620893,10620894,10620920,10922076,10621566,10922077,10922133,10922134,10922217,10922256,10922257,10922258,10922259,10922260,10922261,10922262,10922263,10922282,10922285,10922286,10922287,10922288,10922289,10922304,10922305,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10610963,10610964,10610965,10610966,10610967,10610969,10610975,10610977,10565127,10610978,10610984,10610985,10610988,10610989,10610995,10610996,10610997,10610999,10565155,10565158,10614009,10611025,10614054,10565266,10565267,10565268,10565269,10565270,10565278,10565279,10565280,10565281,10565319,10565324,10565325,10565326,10565327,10614220,10614221,10611252,10611253,10614263,10614264,10611365,10611375,10611376,10611381,10611396,10611399,10611406,10611407,10611408,10611411,10611416,10611417,10611422,10611426,10611428,10611432,10611434,10611436,10611437,10611442,10611443,10611444,10611445,10611449,10611452,10611457,10611466,10611469,10614476,10611486,10614495,10611496,10614497,10614498,10614499,10614501,10614502,10614503,10611509,10611519,10611542,10611544,10611570,10611581,10611583,10611598,10611659,10611666,10611676,10611778,10611782,10611812,10611830,10611831,10611833,10611835,10611856,10611891,10611892,10611909,10611910,10611912,10611913,10611914,10611915,10611916,10611917,10611919,10611920,10611921,10611922,10611926,10611927,10611929,10611930,10611931,10611933,10611934,10611935,10611936,10611937,10611939,10611941,10611949,10611950,10611951,10609100,10609313,10609354,10609355,10609356,10609366,10609707,10609839,10609844,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609947,10609971,10609988,10610015,10610030,10610044,10610046,10610060,10610061,10610063,10610064,10610065,10610097,10610126,10610233,10610304,10610310,10610311,10610312,10610333,10610479,10610481,10610482,10610666,10610697,10610729,10610730,10610739,10610775,10610777,10564992,10564993,10610890,10610913,10610914,10610917,10610947,10610954,10610958,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517220,10517221,10517225,10517670,10517681,10517789,10517790,10517791,10517792,10517793,10517794,10517795,10517796,10517797,10517798,10517799,10517801,10517802,10517803,10517804,10517805,10517806,10517807,10517808,10518102,10518103,10518104,10518105,10518106,10518107,10518111,10518570,10518671,10518674,10518681,10518682,10518683,10518684,10518685,10518686,10518688,10518696,10518707,10415366,10415367,10419370,10415372,10415373,10415374,10415375,10415376,10419453,10419457,10419468,10419469,10419470,10419471,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10419491,10419492,10419493,10419496,10419497,10419498,10419499,10419500,10419509,10419510,10419515,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419530,10419532,10419533,10419534,10419535,10419568,10415595,10415597,10415598,10415599,10415600,10415601,10415614,10419669,10419670,10419671,10419672,10415676,10419677,10419678,10415678,10419681,10419682,10419688,10419693,10419694,10419695,10419703,10419704,10419707,10419710,10419711,10419712,10419716,10419717,10419720,10419722,10419723,10419724,10419725,10419726,10419727,10419730,10419731,10415732,10419733,10415733,10419735,10415735,10419738,10419739,10419740,10419741,10419742,10419744,10419748,10419749,10419750,10419751,10419752,10419753,10419754,10419755,10419756,10415791,10415792,10415793,10415794,10415795,10415796,10415797,10419813,10419814,10419815,10415815,10419816,10415816,10419817,10419819,10419820,10419821,10419822,10419825,10419828,10419830,10415830,10415831,10415832,10415833,10419839,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10415873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,10419888,10419889,10419890,10419894,10419895,10419896,10419899,10419900,10419905,10419906,10419966,10420014,10420017,10420037,10420041,10420042,10420046,10420052,10420053,10420084,10420085,10420088,10420091,10420095,10420096,10420102,10420103,10420111,10420113,10420118,10420126,10420216,10420218,10462939,10462940,10463003,10463004,10463008,10463030,10463032,10463033,10463042,10463060,10471171,10471175,10463315,10463399,10463400,10463401,10463430,10463587,10463588,10463589,10463590,10463591,10463592,10463593,10463594,10463595,10463596,10463648,10463649,10463650,10463651,10463652,10463653,10463655,10463656,10463657,10463658,10463660,10463661,10463663,10463664,10463665,10463670,10463671,10463673,10463674,10463675,10463678,10463694,10463728,10463729,10463730,10463738,10463739,10463740,10463753,10463760,10463761,10463762,10463772,10463773,10463774,10463775,10463784,10463785,10463786,10463787,10463797,10463798,10463799,10463805,10463806,10463825,10463826,10463828,10463829,10463832,10463833,8563204,8563299,8563362,10470089,10462293,10462298,10462300,10462310,10462311,10462312,10462313,10462314,10462315,10462316,10462317,10462318,10462319,10462320,10462324,10462335,10462336,10462337,10462397,10462398,10462400,10462401,10462402,10462403,10462404,10462405,10462407,10462408,10462426,10462430,10462431,10462438,10462452,10462453,10462459,10462460,10462461,10462464,10462465,10462466,10462467,10462474,10462475,10462476,10462477,10462485,10462486,10462487,10462488,10462489,10462490,10462491,10462492,10462493,10462494,10462498,10462508,10462509,10462510,10462512,10462513,10462514,10462521,10462522,10462523,10462524,10462537,10462538,10462539,10462545,10462546,10462581,10462582,10462583,10462585,10462586,10462587,10462589,10462590,10462596,10462597,10462598,10462600,10462603,10462607,10462610,10462612,10462617,10462618,10462619,10462620,10462621,10462625,10462627,10462628,10462629,10462630,10470721,10470722,10462726,10462727,10462756) 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'