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(4970670,4970671,4970672,4970704,4970718,4970724,4970738,4970744,4970782,4970783,4970852,4970858,4970859,4970860,4971034,4971035,4971036,4971037,4971038,4971039,4971040,4971041,4971042,4971043,4971044,4971045,4971046,4971047,4971048,4971049,4971050,4971051,4971052,4971053,4971054,4971055,4971056,4971057,4971058,4971059,4971060,4971061,4971062,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971070,4971071,4971072,4968255,4968256,4968257,4968258,4968259,4968260,4968261,4968262,4968263,4968264,4968265,4968266,4968267,4968268,4968269,4968270,4968271,4968272,4968273,4968274,4968275,4968276,4968277,4968278,4968279,4968280,4968281,4968282,4968283,4968284,4968285,4968286,4968287,4968288,4968289,4968290,4968291,4968292,4968293,4968294,4968295,4968296,4968297,4968298,4968299,4968300,4968301,4968302,4968303,4968304,4968305,4968306,4968307,4968308,4968309,4969381,8075273,8075274,8075276,8075281,8075283,8075307,8075308,8075309,8075310,8075311,8075312,8075313,8075314,8075315,8075316,8075317,8075318,8075319,8075320,8075332,8075333,8075334,8075335,8075336,8075346,8075351,8075353,8075354,8075356,8075358,8075360,8075361,8075362,8075363,8075366,8075368,8075370,8075372,8075374,8075376,8075381,8075383,8075385,8075386,8075391,8075395,8075397,8075400,8075401,8075402,8075403,8075407,8075411,8075413,8075414,8075416,8075418,8075420,8075421,8075423,8075424,8075425,8075426,8075427,8075429,8075431,8075433,8075434,8075436,8075443,8075446,8075448,8075453,8075454,8075461,8075463,8075464,8075465,8075470,8075472,8075473,8075474,8075475,8075476,8075477,8075481,8075486,8075492,8075494,8075496,8075497,8075499,8075500,8075501,8075504,8075505,8075508,8075509,8075510,8075512,8075517,8075519,8075521,8075523,8075524,8075527,8075528,8075533,8075535,8075537,8073001,8073002,8073016,8073017,8073018,8073019,8073020,8073022,8073024,8073029,8073030,8073031,8073036,8073038,8073039,8073041,8073043,8073045,8073049,8073098,8073099,8073100,8073101,8073107,8073108,8073109,8073113,8073114,8073115,8073116,8073121,8073122,8073123,8073124,8073125,8073126,8073127,8073137,8073138,8073139,8073140,8073141,8073142,8073150,8073151,8073152,8073153,8073157,8073158,8073159,8073160,8073165,8073166,8073167,8073168,8073169,8073170,8073182,8073183,8073184,8073190,8073191,8073192,8073196,8073197,8073198,8073199,8073204,8073205,8073206,8073207,8073208,8073217,8073218,8073219,8073220,8073221,8073222,8073229,8073230,8073231,8073235,8073236,8073237,8073238,8073239,8073244,8073245,8073246,8073247,8073248,8073249,8073250,8073264,8073265,8073266,8073267,8073268,8073274,8073275,8073276,8073280,8073281,8073282,8073287,8073288,8073289,8073290,8073291,8073298,8073299,8073300,8073301,8073302,8073311,8073312,8073313,8073317,8073318,8073319,8073320,8073325,8073326,8073327,8073328,8073329,8073330,8073331,8073332,8073333,8073334,8073341,8073342,8073343,8073344,8073345,8073346,8073348,8073349,8073350,8073352,8073353,8073354,8073355,8073359,8073360,8073361,8073362,8073363,8073364,8073365,8073366,8073367,8073368,8073370,8073371,8073372,8073373,8073374,8073375,8073376,8073377,8073378,8073379,8073380,8073381,8073382,8073383,8073384,8073385,8073386,8073387,8073389,8073390,8073391,8073392,8073394,8073395,8073396,8073397,8073398,8073399,8073400,8073402,8073403,8073404,8073405,8073407,8073408,8073409,8073410,8073411,8073412,8073413,8073414,8073415,8073417,8073418,8073419,8073422,8073423,8073424,8073425,8073426,8073427,8073428,8073429,8073430,8073432,8073433,8073434,8073435,8073436,10623057,10623058,10623059,10623062,10623065,10623170,10623493,10623582,10624412,10624558,10624559,10624604,10622018,10622087,10622099,10622100,10622122,10622193,10622194,10622202,10622203,10622204,10622205,10622206,10622207,10622208,10622209,10622210,10622211,10622212,10622213,10622214,10622215,10622216,10622217,10622218,10622219,10622220,10622221,10622222,10622223,10622224,10622225,10622226,10622227,10622228,10622229,10622230,10622231,10622232,10622233,10622234,10622235,10622236,10622237,10622238,10622239,10622240,10622241,10622242,10622243,10622244,10622245,10622246,10622247,10622248,10622249,10622250,10622251,10622252,10622253,10622254,10622255,10622256,10622257,10622258,10622259,10622260,10622261,10622262,10622263,10622264,10622265,10622266,10622267,10622268,10622269,10622270,10622271,10622272,10622273,10622274,10622275,10622276,10622277,10622278,10622279,10622280,10622281,10622282,10622283,10622284,10622285,10622286,10622287,10622288,10622289,10622290,10622291,10622292,10622293,10622294,10622295,10622296,10622297,10622298,10622299,10622300,10622301,10622302,10622303,10622304,10622305,10622306,10622307,10622308,10622309,10622310,10622311,10622312,10622313,10622314,10622315,10622316,10622317,10622318,10622319,10622320,10622321,10622322,10622323,10622324,10622325,10622326,10622327,10622328,10622329,10622330,10622331,10622332,10622333,10622334,10622335,10622336,10622337,10622338,10622339,10622340,10622341,10622342,10622343,10622344,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622360,10622361,10622362,10622363,10622364,10622365,10622366,10622367,10622368,10622369,10622370,10622371,10622372,10622373,10622374,10622375,10622376,10622377,10622378,10622379,10622380,10622381,10622382,10622383,10622384,10622385,10622386,10622387,10622388,10622389,10622390,10622391,10622392,10622393,10622394,10622395,10622396,10622397,10622398,10622399,10622400,10622401,10622402,10622403,10622404,10622405,10622406,10622407,10622408,10622409,10622410,10622411,10622412,10622413,10622414,10622415,10622416,10622417,10622418,10622419,10622420,10622421,10622422,10622423,10622424,10622425,10622426,10622427,10622428,10622429,10622430,10622431,10622432,10622433,10622434,10622435,10622436,10622437,10622438,10622439,10622440,10622441,10622442,10622443,10622444,10622445,10622446,10622447,10622448,10622449,10622450,10622451,10622452,10622453,10622454,10622455,10622456,10622457,10622458,10622459,10622460,10622461,10622462,10622463,10622464,10622465,10622466,10622467,10622468,10622469,10622470,10622471,10622472,10622473,10622474,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622486,10622487,10622488,10622489,10622490,10622491,10622492,10622493,10622494,10622495,10622496,10622497,10622498,10622499,10622500,10622501,10622502,10622503,10622504,10622505,10622506,10622507,10622508,10622509,10622510,10622511,10622512,10622513,10622514,10622515,10622516,10622517,10622518,10622519,10622520,10622521,10622522,10622523,10622524,10622525,10622526,10622527,10622528,10622529,10622530,10622531,10622532,10622533,10622534,10622535,10622536,10622537,10622538,10622539,10622540,10622541,10622542,10622543,10622544,10622545,10622546,10622547,10622548,10622549,10622550,10622551,10622552,10622553,10622554,10622555,10622556,10622557,10622558,10622559,10622560,10622561,10622608,10622609,10622610,10622612,10622618,10622619,10622867,10622924,10619981,10619987,10620069,10620117,10620118,10620171,10620172,10620175,10620188,10620208,10620218,10620444,10620465,10620565,10620585,10620595,10620598,10620603,10620604,10620623,10620662,10620677,10620678,10620679,10620924,10620984,10620985,10620986,10620987,10620995,10620997,10620998,10620999,10621000,10621001,10621034,10621627,10621628,10621629,10621630,10621631,10621632,10621633,10621634,10621635,10621636,10621637,10621638,10621639,10621640,10621641,10621642,10621644,10621645,10621663,10621666,10621667,10621669,10621686,10565112,10565113,10565114,10565115,10565116,10565117,10565118,10565119,10565120,10565121,10565122,10565123,10565124,10565194,10563119,10563120,10563121,10563122,10563123,10563124,10563125,10563126,10563127,10563128,10563129,10563130,10563131,10563132,10563134,10563135,10563172,10563173,10563174,10563175,10563214,10563215,10563316,10563317,10563318,10563319,10563320,10563321,10563352,10563353,10563354,10563355,10563370,10563371,10563372,10563373,10563374,10563375,10563376,10563377,10563378,10563379,10563380,10563381,10563382,10563383,10563385,10563386,10563387,10563388,10563389,10563390,10563391,10563392,10563552,10564129,10564496,10564497,10564498,10564499,10564502,10564503,10564504,10564505,10564506,10564614,10564615,10564616,10564617,10564618,10564619,10564620,10564621,10564622,10564627,10564628,10564629,10564630,10564631,10564632,10564633,10564634,10564635,10564636,10564645,10564646,10564647,10564648,10564649,10564650,10564651,10564652,10564653,10564654,10564655,10564656,10564657,10564658,10564659,10564661,10564662,10564680,10564681,10564682,10564683,10564684,10564685,10564686) 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'