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(10939597,4970248,10939714,10943565,10943681,10943893,10943897,10943922,10943942,10943986,10943991,10943999,10944000,10940347,10944158,10944263,10940512,8066943,4968197,4968198,10933341,8066981,10933362,8067031,10933480,4968352,4968353,4968354,4968355,4968356,10437112,8067253,8067254,8067364,8067442,8067459,4968776,4968870,4968871,4968872,4968873,4968874,10437513,8067723,8067724,8067725,8067778,10437775,4969218,4969219,4969220,4969221,4969222,4969223,4969224,4969225,4969251,10938780,10938781,10938782,10938937,10938938,10938939,10938940,10938941,10938942,10938943,10938944,10939029,10939089,10939174,4970028,10931440,10931448,10931541,10931694,8075275,10931896,8075326,8075490,8075515,8065823,8065830,10932350,10932351,10932364,8066008,8066009,4967318,10932655,10932784,10932816,10932819,10932820,10932821,10932822,10932823,4967812,8066583,10932959,8066755,8066797,10942580,10942705,10943202,10943214,10943215,10943229,10943230,10943317,10943326,10943327,8064737,10943385,10943404,10943409,10943410,10943411,10943412,10943413,10943414,8064788,8970219,8064885,8064886,8064887,8064888,3655605,3655676,3655678,3655679,3655680,3655690,3655781,10940870,10940871,3655877,3655908,3655979,3655996,3656062,3656063,3656077,3656113,3656162,10941361,10941362,10941363,10941364,10941365,10941366,10941367,10941368,10941369,8072595,8072596,8072597,8072598,8072599,10941583,10941689,3656643,10941790,10941798,10941800,3656748,3656749,3656750,3656751,10941827,10941828,10941829,3656800,3656801,3656802,10941885,10941894,10941895,8073034,8073081,8073185,8073186,8073187,8073188,8073189,8073193,8073194,8073195,8073200,8073201,8073202,8073203,8073211,8073212,8073213,8073214,8073215,10942171,3657126,3657148,3657149,3657161,3657162,3657163,3657164,3657165,3657169,3657170,3657171,3657188,3657189,3657190,3657193,3657194,3657205,3657251,3657252,3657254,8073475,11049670,10942532,10623252,10623256,10623257,10919005,10623504,10623582,10623801,10623970,10624235,10919848,10624691,10624709,10624716,10624720,10624722,10624728,10622082,10622152,10622404,10622777,10622946,10920641,10620132,10920686,10620208,10915786,10915787,10915788,10915789,10915790,10915791,10915792,10620398,10620470,10620541,10620568,10620582,10921626,10921744,10921997,10921998,10921999,10922000,10922001,10922002,10621629,10922307,10922324,10922333,10922334,10922339,10922455,10611025,10614031,10611159,10611160,10614167,10611184,10611186,10611188,10611229,10614281,10614309,10614332,10614333,10611450,10611451,10611505,10614566,10614567,10565719,10565720,10565721,10565722,10565723,10565724,10565725,10565726,10565727,10565728,10565729,10565730,10565731,10565732,10565733,10565734,10565735,10565736,10565737,10565738,10565739,10565740,10565741,10565742,10565743,10565744,10565745,10565746,10565747,10565748,10565749,10565750,10565751,10565752,10565753,10565754,10565755,10565756,10565757,10565758,10565759,10565760,10565761,10565762,10565763,10565764,10565765,10565766,10565767,10565768,10565769,10565770,10565771,10614641,10611686,10611687,10611688,10614716,10611745,10611746,10611780,10614784,10565940,10565941,10565942,10614814,10614858,10614859,10566071,10566072,10611989,10612026,10563242,10612093,10563243,10563244,10563245,10563246,10563247,10612098,10563248,10563249,10563250,10563251,10563252,10612135,10612168,10563324,10563357,10563358,10563359,10563360,10563361,10563362,10563363,10563364,10563365,10563366,10563367,10563368,10563369,10563385,10563386,10563387,10563388,10612238,10563389,10563390,10563391,10612279,10612290,10609309,10563471,10612338,10612380,10612381,10609381,10612383,10609390,10612401,10612408,10612409,10612410,10612445,10612505,10609506,10609507,10609508,10609509,10609577,10609590,10563762,10563763,10563764,10563765,10563766,10563767,10563768,10563769,10563770,10563771,10563772,10563773,10563774,10609628,10563786,10563787,10609772,10564072,10612929,10564123,10613034,10613055,10610068,10613075,10613081,10610115,10613119,10613166,10610167,10610168,10613225,10613294,10613296,10613299,10610358,10610416,10564609,10564623,10613491,10564644,10564664,10564665,10613515,10564666,10613517,10613574,10613583,10613584,10613621,10613623,10610629,10610639,10564864,10564898,10564899,10564900,10564901,10564910,10564918,10564920,10564922,10564923,10564924,10564925,10564926,10564936,10564937,10564938,10564939,10564940,10564941,10564943,10564992,10564993,10610918,10610926,10610959,10517256,10517550,10517822,10517823,10517824,10517825,10517862,10517863,10517864,10517865,10517866,10517913,10517914,10517915,10517916,10517917,10517918,10517919,10517920,10517921,10517922,10517923,10517924,10517925,10517958,10517959,10517960,10517961,10517962,10517963,10517964,10517965,10517977,10517978,10517979,10517980,10517981,10517982,10517983,10517984,10517993,10517994,10517995,10517996,10517997,10518026,10518027,10518142,10518145,10518146,10518156,10518157,10518158,10518159,10518160,10518161,10518162,10518163,10518164,10518165,10518166,10518167,10518168,10518169,10518170,10518171,10518172,10518173,10518174,10518175,10518176,10518177,10518178,10518179,10518180,10518181,10518182,10518183,10518184,10518185,10518186,10518187,10518188,10518189,10518190,10518191,10518192,10518193,10518194,10518195,10518196,10518197,10518198,10518199,10518200,10518201,10518202,10518203,10518204,10518205,10518206,10518207,10518208,10518209,10518210,10518211,10518212,10518213,10518214,10518215,10518216,10518217,10518218,10518219,10518220,10518221,10518222,10518223,10518224,10518225,10518226,10518227,10518228,10518229,10518230,10518231,10518232,10518233,10518234,10518235,10518236,10518237,10518238,10518239,10518240,10518241,10518242,10518243,10518244,10518245,10518246,10518247,10518248,10518249,10518250,10518251,10518252,10518253,10518254,10518255,10518256,10518257,10518258,10518259,10518260,10518261,10518262,10518263,10518264,10518265,10518266,10518267,10518268,10518269,10518270,10518271,10518272,10518273,10518274,10518275,10518276,10518277,10518278,10518279,10518280,10518281,10518282,10518283,10518284,10518285,10518286,10518287,10518288,10518289,10518290,10518291,10518292,10518293,10518294,10518295,10518296,10518297,10518298,10518299,10518300,10518301,10518302,10518303,10518337,10518338,10518339,10518340,10518341,10518342,10518343,10518344,10518345,10518346,10518347,10518348,10518349,10518350,10518351,10518352,10518353,10518354,10518355,10518356,10518357,10518358,10518359,10518360,10518361,10518362,10518363,10518364,10518365,10518366,10518367,10518368,10518369,10518370,10518371,10518372,10518373,10518374,10518375,10518376,10518377,10518378,10518379,10518380,10518381,10518382,10518383,10518384,10518385,10518386,10518387,10518388,10518389,10518390,10518391,10518392,10518393,10518394,10518395,10518396,10518397,10518398,10518399,10518400,10518401,10518402,10518403,10518404,10518405,10518406,10518407,10518408,10518409,10518410,10518411,10518421,10518422,10518423,10518426,10518427,10518428,10518429,10518430,10518431,10518432,10518433,10518434,10518435,10518436,10518437,10518438,10518453,10518454,10518455,10518456,10518457,10518458,10518459,10518460,10518461,10518462,10518463,10518464,10518465,10518466,10518467,10518468,10518469,10518470,10518471,10518472,10518473,10518474,10518475,10518476,10518477,10518489,10518490,10518491,10518492,10518493,10518494,10518495,10518496,10518497,10518498,10518499,10518500,10518501,10518502,10518503,10512504,10518504,10518505,10518506,10518507,10518508,10518509,10518510,10518511,10518512,10518513,10518514,10518515,10518516,10518517,10518518,10518519,10518520,10518521,10518522,10512572,10512573,10512574,10512575,10518577,10518578,10518579,10518580,10518581,10518582,10518585,10518586,10518587,10518588,10518589,10518590,10518591,10518595,10518596,10518597,10518601,10518602,10512661,10512662,10512753,10512786,10512788,10512919,10512920,10512921,10512922,10512923,10512949,10512950,10512951,10419227,10419228,10419229,10419231,10419233,10419234,10419283,10419297,10416300,10416301,10419303,10416304,10419322,10416323,10419323,10419324,10416329,10419329,10415351,10416375,10416376,10416377,10416378,10416379,10416380,10415388,10415412,10415413,10415424,10419428,10419429,10416446,10416447,10416450,10416455,10416461,10416470,10415473,10419499,10415501,10419501,10415502,10419506,10415510,10415511,10419511,10415512,10419517,10419529,10419530,10419537,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419558,10419559,10419560,10419561,10419583,10419595,10416645,10415648,10415649,10415650,10415651,10419656,10416657,10419657,10419658,10419659,10419660,10415687,10419760,10419773,10419774,10419775,10419776,10415855,10415874,10419874,10415888,10416009,10420038,10420100,10420112,10420115,10420120,10420123,10420125,10420129,10416189,10416204,10416205,10471128,10463301,10463358,10471482,10471497,10471688,10471713,8563311,8563532,8563533,8563579,8563590,10462307,10462793,10462866) 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'