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(7076128,10939913,7076290,7076334,7076335,7076353,8569674,7074005,10963887,10963888,10963889,10963890,10963891,10963892,10963893,10963894,10963895,10963896,7066275,10437211,10437255,4968645,10437337,10437338,7074496,7074497,7074498,7074499,7074500,7074501,7074502,7074503,7074504,7074505,7074506,7074507,7074508,7074509,7074510,7074511,7074512,7074555,7074556,10437447,10437448,10437449,7066600,8067588,10437480,10437481,10437482,10437483,10437484,7066639,7066640,7066726,7066728,10437589,8067719,8067720,8067721,7074758,7066775,7066776,7066777,7066813,7066829,7066830,7066939,7067025,7067026,7067027,7067051,7067052,7067053,7067054,7067055,7067056,7067453,10939384,10939439,7075904,7075928,7075929,7071959,8074772,8074773,8074774,8074775,8074776,8074777,8074778,8074779,8074780,8074781,8074782,8074783,8074784,8074785,8074786,8074787,8074788,8074789,8074790,8074791,8074792,8074793,8074794,8074795,8074796,8074797,8074798,8074799,8074800,8074801,8074802,8074803,8074804,8074805,8074806,8074807,8074808,8074809,8074810,8074811,8074812,8074813,8074814,8074815,8074816,8074817,8074818,8074819,8074820,8074821,8074822,8074823,8074824,8074825,8074826,8074827,8074828,8074829,8074830,8074831,8074832,8074833,8074834,8074835,8074836,8074837,8074838,8074839,8074840,8074841,8074842,8074843,8074844,8074845,8074846,8074847,8074848,8074849,8074850,8074851,8074852,8074853,8074854,8074855,7072178,7072180,7072181,7072182,7072184,7072236,7072271,7072272,10931663,10931698,10931699,10931700,10931701,7064589,7064596,7064597,10931991,7064715,7064721,7064722,7064723,10932202,10932307,10932308,10932309,10932310,10932311,10932312,10932313,10932314,10932315,8065945,10932316,8065946,8065947,10932317,8065965,8065984,10932449,8066082,10932464,7065143,7065151,7073301,7065416,7065437,7073636,10933126,10933127,11049046,11049047,11049048,11049049,7071214,10942889,10942890,7071539,10943321,10943322,10943326,6000072,6000073,6000074,6000075,6000076,6000077,6000078,6000079,6000080,7071852,7071853,7071854,10944374,10944375,10944895,10944896,10944897,10944898,3656413,3656414,3656444,10941765,10941817,10941822,10941830,10942179,10942180,11048532,11048572,11048582,11048668,7070829,7070830,7070831,7070832,7070833,7070834,7070835,7070836,7070840,7070846,10623350,10618365,10623444,10623507,10919059,10919060,10619251,10619252,10619253,10920294,10920295,10619841,10619842,10619843,10619893,10922610,10617130,10617131,10617136,10617148,10617149,10617158,10617161,10617164,10617196,10617197,10617247,10918073,10923108,10923109,10923110,10923111,10923112,10923113,10923114,10923115,10923116,10923117,10923118,10923119,10923120,10923121,10923122,10923123,10923124,10923125,10923126,10923127,10923128,10923129,10923130,10923131,10923132,10923133,10923134,10923135,10923136,10923137,10923138,10923139,10923140,10923141,10923142,10923143,10923144,10923145,10923146,10923147,10923148,10923149,10923150,10923151,10923152,10923153,10923154,10923155,10923156,10923157,10923158,10923159,10923160,10923161,10923162,10923163,10923164,10923165,10923166,10923167,10923168,10923169,10923170,10923171,10923172,10923173,10923174,10923175,10923176,10923177,10923178,10923179,10923180,10923181,10923182,10923183,10923184,10923185,10923186,10923187,10923188,10923189,10923190,10622681,10923191,10923192,10923193,10923194,10923195,10923196,10923197,10923198,10923199,10923200,10923201,10923202,10923203,10923204,10923205,10923206,10923207,10923208,10923209,10923210,10923211,10923212,10923213,10923214,10923215,10923216,10923217,10923218,10923219,10923220,10923221,10923222,10923223,10923224,10923225,10923226,10923227,10923228,10923229,10923230,10923231,10923232,10923233,10923234,10923235,10923236,10923237,10923238,10923239,10923240,10923241,10923242,10923243,10923244,10923245,10923246,10923247,10923248,10923249,10923250,10923251,10923252,10923253,10923254,10923255,10923256,10923257,10923258,10923259,10923260,10923261,10923262,10923263,10923264,10923265,10923266,10923267,10923268,10923269,10923270,10923271,10923272,10923273,10923274,10923275,10923276,10923277,10923278,10923279,10923280,10923281,10923282,10923283,10923284,10923285,10923286,10923287,10923288,10923289,10923290,10923291,10923292,10923293,10923294,10923295,10923296,10923297,10923298,10923299,10923300,10923301,10923302,10923303,10923304,10923305,10923306,10923307,10923308,10923309,10923310,10923311,10923312,10923313,10923314,10923315,10923316,10923317,10923318,10923319,10923320,10923321,10923322,10923323,10923324,10923325,10923326,10923327,10923328,10923329,10923330,10923331,10923332,10923333,10923334,10923335,10923336,10923337,10923338,10923339,10923340,10923341,10923342,10923343,10923344,10923345,10923346,10923347,10923348,10923349,10923350,10923351,10923352,10923353,10923354,10923355,10923356,10923357,10923358,10923359,10923360,10923361,10923362,10923363,10923364,10923365,10923366,10923367,10923368,10923369,10923370,10923371,10923372,10923373,10923374,10923375,10923376,10923377,10923378,10923379,10923380,10923381,10923382,10923383,10923384,10923385,10619973,10620052,10620114,10620128,10926061,10926062,10615555,10916410,10916411,10916412,10615949,10926894,10922214,10616794,10616795,10616842,10616906,10610969,10610971,10611036,10614085,10562707,10562708,10562709,10562710,10562711,10562712,10562713,10562714,10614595,10562752,10562753,10562754,10562755,10562756,10562757,10614731,10614746,10614811,10611812,10612069,10612270,10563473,10563474,10563475,10563476,10563477,10563478,10563479,10563480,10563481,10563482,10563483,10563484,10563485,10563486,10563487,10563488,10563489,10563490,10563491,10563492,10563493,10563494,10563495,10563496,10563497,10563498,10563499,10563500,10563501,10563502,10563503,10563504,10563505,10563506,10563507,10563508,10563509,10563510,10563511,10563512,10563513,10563514,10563515,10563516,10563517,10563518,10563519,10563520,10612380,10612407,10612430,10609443,10609444,10609707,10612747,10612748,10609990,10613091,10613173,10610174,10610175,10610176,10610177,10610180,10610181,10610182,10610193,10558360,10558361,10558362,10558363,10558364,10558365,10558608,10517279,10517280,10517281,10517547,10517548,10517549,10515794,10515795,10515796,10515797,10515798,10515799,10515800,10517800,10515801,10515802,10515803,10515804,10515805,10515806,10515807,10515808,10515809,10515810,10515811,10515812,10515813,10517823,10517824,10517825,10517826,10517827,10517828,10517829,10517830,10513831,10517831,10517832,10517833,10517834,10517835,10517836,10517837,10517838,10517839,10517840,10517841,10517842,10517843,10517844,10517845,10517846,10517847,10517848,10517849,10517850,10513851,10517851,10513852,10517852,10517853,10517854,10517855,10517856,10517857,10517858,10517859,10517860,10517861,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,10518304,10518305,10518306,10518307,10518308,10518309,10518310,10518311,10518312,10518313,10518314,10518315,10518316,10518317,10518318,10518319,10518320,10518321,10518322,10518323,10518324,10518325,10518326,10518327,10518328,10518329,10518330,10518331,10518332,10518333,10518334,10518335,10518336,10512663,10512664,10512665,10512666,10512667,10512668,10512669,10512670,10512671,10512672,10512673,10512674,10512675,10517012,10517013,10517014,10517015,10517016,10517017,10517018,10517019,10517025,10517026,10517027,10415308,10417476,10419816,10419817,10419818,10419820,10419822,10419825,10419826,10419827,10419830,10419831,10419839,10419840,10419843,10419848,10419849,10419850,10419908,10419909,10419910,10419911,10419912,10419913,10419924,10419925,10419932,10419933,10419934,10419935,10419936,10419937,10419938,10419945,10419946,10419947,10419948,10419949,10419950,10420145,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10469151,10471561,10469764,10469765,10469846,10469847,10467976,8563310,8563311,8563312,8563313,8563314,8563315,10467994,8563316,8563317,8563318,10468009,10468029,10468053,10468104,10468251,10466298,10466299,10466300,10466301,10466302) 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'