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(10975651,8574261,10975769,10975786,10975787,10975788,10975789,10975790,10975791,10975792,10975793,10975794,10975795,10975796,10975797,10975798,10975799,10975800,10975801,10975802,10975803,10975804,10975805,10975806,10975807,10975808,10975809,10975819,10975820,10975821,10975822,10975823,10975824,10975825,7068159,7068161,7068162,7068163,10975849,7068228,7068239,7068240,7068242,7068262,7068279,7068280,7068282,7068293,7068294,7068295,7068296,7068297,7068298,7068299,7068300,7068301,7068302,7068303,7068304,7068305,7068306,7068307,7068308,10975992,7068309,10975993,7068310,10975994,7068311,10975995,10975996,7068312,10975997,7068313,7068314,7068315,7068316,7068317,7068318,7068319,7068320,7068321,7068322,7068323,7068324,7068325,7068330,7068331,7068334,7068336,7068337,7068338,7068339,7068340,7068341,7068342,7068365,7068366,7068370,7068371,10940152,10940154,10940159,10940165,10940172,10940175,10940186,10940187,10940188,10940189,10940190,10940191,10940197,10940198,10940199,10940200,10976271,10976272,10976273,10976274,10976275,10976276,10976277,10976278,10976279,10976280,10976281,8621455,10976327,10976328,10976329,10976344,10976347,10976366,10976367,10976368,8621563,8569758,10989664,10989665,10989666,10989667,10989668,10989669,10989670,10989671,10989672,10989673,10989674,10989675,10989676,10989677,10989678,10989679,10989680,10989681,10989682,10989683,10989684,10989685,10989686,10989687,10989688,10989689,10989690,10989691,10989692,10989693,10989694,10989695,10989696,10989697,10989698,10989699,10437409,7066575,7066576,7074596,7074635,7074639,7074668,7074695,7074700,7074704,7074723,7074800,7074801,7074811,7074974,10974668,7075024,10974719,10974720,10974721,10974728,10974729,10974730,10974731,10974858,10974859,10974860,10974861,10974862,10974863,10974864,10974865,10974866,10974867,10974868,10974869,10974870,10975028,10975029,10975030,10975031,10975032,10975033,10975034,10975035,10975036,10975037,10975038,10975039,10975040,10975041,10975042,10975043,10975044,10975045,10975046,10975047,10975048,10975049,10975050,10975051,10975052,10975053,10975054,10975055,10975056,10975057,10975058,10975059,10975060,10975061,10975062,10975063,10975064,10975065,10975066,10975067,10975068,10975069,10975070,10975071,10975072,10975073,10975074,10975075,10975076,10975077,10975078,10975079,10975080,10975148,10975149,10975150,10975151,10975152,10975153,10975154,10975155,10975156,10975157,10975158,10975159,10975160,10975161,10975162,10975163,10975164,10975165,10975166,10975167,10975168,10975169,10975170,10975171,10975172,10975173,10975174,10975175,10975176,10975177,10975178,10975179,10975180,10975181,10975182,10975183,10975184,10975185,10975186,10975187,10975188,10975189,10975190,10975191,10975192,10975193,10975194,10975195,10975196,10975197,10975198,10975199,10975200,10975201,10975202,10975203,10975204,10975205,10975206,10975207,10975208,10975209,10975210,10975211,10975212,10975213,10975214,10975215,10975216,10975217,10975218,10975219,10975220,10975221,10975222,10975223,10975224,10975225,10975226,10975227,10975228,10975229,10975230,10975231,10975232,10975233,10975234,10975235,10975236,10975237,10975238,10975239,10975240,10975241,10975242,10975243,10975244,10975245,10975246,10975247,10975248,10975249,10975250,10975251,10975252,10975253,10975254,10975255,10975256,10975257,10975258,10975259,10975260,10975261,10975262,10975263,10975264,10975265,10975266,10975267,10975268,10975269,10975270,10975271,10975272,11001273,10975273,10975274,11001274,10975275,11001275,11001276,10975276,10975277,10975278,10975279,11001279,10975280,10975281,10975282,10975283,10975284,10975285,10975286,10975287,10975288,10975289,10975290,10975291,10975292,10975293,10975294,10975295,10975296,10975297,10975298,10975299,10975300,10975301,10975302,10975303,10975304,10975305,10975306,10975307,10975308,10975309,10975310,10975311,10975312,10975313,10975314,10975315,10975316,10975317,10975318,10975319,10975320,10975321,10975322,10975323,10975324,10975325,10975326,10975327,10975328,10975329,10975330,10975331,10975332,10975333,10975334,10975335,10975336,10975337,10975338,10975339,10975340,10975341,10975342,10975343,10975344,10975345,10975346,10975347,10975348,10975349,10975350,10975351,10975352,10975353,10975354,10975355,10975356,7067673,10975357,10975358,10975359,10975360,10975361,10975362,10975363,10975364,10975365,10975366,10975367,10975368,10975369,10975370,10975371,10975372,10975373,10975374,10975375,10975376,10975377,10975378,10975379,10975380,10975381,10975382,10975383,10975384,10975385,10975386,10975387,10975388,10975389,10975390,10975391,10975392,10975393,10975394,10975395,10975413,10975435,10975445,10975446,10975447,10975448,10975449,10975450,10975451,10975452,10975453,10975454,10975461,10975462,10975463,10975464,10975465,10975466,10975467,10975468,10975469,10975470,10975471,10975472,10975473,10975474,10975475,10975476,10975477,10975478,10975479,10975480,10975481,10975482,10975483,10975484,10975485,10975486,10975487,10975488,10975489,10975490,10975491,10975492,10975493,10975494,10975495,10975496,10975497,10975498,10975499,10975500,10975501,10975502,10975503,10975504,10975510,10975567,10975568,10975569,7072311,10960101,10960102,10960103,8618820,10932343,10973729,10973730,10973731,10973732,10973733,10973734,10973735,10973736,10973737,10973738,10973739,10973740,10973741,10973742,10973743,10973744,10973745,10973746,10973747,10973748,10973749,10973750,10973751,10973752,10973753,10973754,10973755,10973756,10973757,10973758,10973759,10973760,10973761,10973762,10973763,10973764,10973765,10973766,10973767,10973768,10973769,10973770,10973771,10973772,10973773,10973774,10973775,10973776,10973777,10973778,10973779,10973780,10973781,10973782,10973783,10973784,10973785,8066166,7073231,10973995,10973996,10973997,10973998,10973999,10974000,10974001,10974002,10974003,10974004,10974005,10974006,10974007,10974008,10974009,10974010,10974011,10974012,10974013,10974014,10974015,10974016,10974017,10974018,10974019,10974020,10974021,10974022,10974023,10974024,10974025,10974026,7065352,7065676,7065677,7065678,7065679,7065680,7065681,7065682,7065683,7065684,7065685,7065686,7065687,7065688,7065689,7065690,10933075,10974485,10974486,10974487,10974488,10974489,10974490,10974491,10974492,7065878,10997872,8834801,8835410,8835411,8835412,8835413,8835415,8835420,8835421,8835423,8908065,8908205,7069402,7069403,7069404,8072427,10101300,10941809,10101346,10101725,8565309,11048669,11048670,11033542,11033543,8906929,11007615,11007616,11007617,11007618,11007619,11007620,11007621,11007728,11007729,11046804,11046845,11046859,10994881,4938165,8907721,8907725,11044876,10952012,10616005,10992241,9189497,10614238,9189648,9189652,9189741,9189748,6666081,6666082,6666083,6666084,6666085,6666086,6666087,6666088,6666150,6666151,9195874,8862421,8862422,8862423,8862424,7058340,9188212,9188225,10558302,9188489,9188562,9188563,9196584,9188589,9196714,9196715,8863258,8863259,9204766,9196816,9189028,9197033,9189048,9189163,9189164,10558989,10558990,10558991,10558992,10558993,9189268,9189284,9189292,9177311,10513128,10513129,10513130,9177325,9177326,9177327,9177328,9177329,10513142,10513158,10513159,10513169,10513210,10513230,10513254,10513255,10513271,10513310,10513317,9185591,9193598,10513713,7056272,7056291,7056292,7056293,9186894,9186898,10513096,10513106,10513107,10513108,8918055,9168762,7054979,10419917,10419918,10419919,10419920,10419921,10419922,10419923,9177276,10420200,10420201,10420202,9177285,9177286,9177287,9177288,9177289,9177290,9177291,9182338,9182339,10467203,9167024,9167025,9167026,9167027,9167028,9167029,9167030,9167031,9167032,9167033,9167034,9167035,9167036,9167037,9167038,8916697,10470125,9176135,9184178,8593429,10161624,10161625,10167419,10167420,10167502,10167503,10167509,10167510,10167511,10167522,10167523,10167525,10167526,10167527,10167528,10167535,10167545,10167546,10167547,10167549,10167550,10167551,10167552,10167554,10626205,10583862,10583873,10583874,10584558,10584560,10585895,10525142,10525143,10525144,10525145,10525146,10523148,10523149,10523150,10523151,10523152,10523153,10527179,10527180,10527181,10523183,10523184,10523185,10523186,10527188,10523196,10523197,10523198,10523199,10523200,10523201,10523202,10523203,10523204,10523205,10523206,10523207,10523208,10523209,10523210,10523211,10523212,10523213,10523217,10523218,10523219,10523220,10523221,10523222,10523224,10523235,10523236,10523256,10523257,10523258,10523259,10523260,10523261,10523262,10523263,10523264,10523265,10523266,10537426,10530139,10528149,10534220,10534221,10534222,10534223,10534385,10534386,10532404,10530751,10538877,10523067,10533102,10533106,10422028,10422047,10422090,10477813,10478696,10478697,10478702,10478707,10478708,10478709,10478710,10478711,10478717,10478718,10478722,10489723,10478736,10478752,10478753,10478754,10478757,10478758,10478759,10478760) 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'