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(7076001,7076002,10447895,10448157,10940006,10940007,10940008,8574847,10963480,10963481,4971148,8066913,10459507,8066914,8066915,8066916,8066917,8066918,8066919,8066920,10459608,10459616,10459624,10459632,8583610,8067303,10437295,10437352,10951298,10951321,10951322,3230154,7066783,7066815,10460392,10929563,10930128,8068753,8068754,8068755,8068756,8068757,8068758,8068759,8068760,8068761,8068762,8068763,8068764,8068765,8068766,8068767,8068768,8068769,8068770,8068771,8068772,10842815,10842816,8835701,8835702,8835703,8835704,8835705,8835706,8835707,8835708,8835709,8835710,8835711,8835712,8835713,8835714,8835715,8835716,8835717,8835718,8835719,8835720,8835721,8835722,10843105,10843106,8618223,10973111,10973112,10973113,10973114,10973115,10973116,10973117,10973118,10973119,10973120,10973121,10973122,10973123,10973124,10973125,10973126,10973127,10973128,10973129,10973130,10973131,10973132,10973133,10973134,10973135,10973136,10973137,10973138,10973139,10973140,10973141,10973142,10973143,10973144,10973145,10973146,10973147,10973148,10973149,10973150,10973151,10973152,10973153,10973154,10973155,10973156,10973157,10973158,10973159,10973160,10973161,10973162,10973163,10973164,10973165,10973166,10931855,10843285,10103668,10931900,10843492,10843498,10932164,10999502,10999503,10999504,10999505,8836343,8618710,8618711,8618712,8618713,8618714,8618715,8618716,8618717,10932609,10932658,10932662,10932670,8836924,8836930,7073579,10844342,10844371,10933029,8066905,8066906,8066907,8066908,8066909,8066910,8066911,8066912,8616954,8616955,8834721,11049172,11049173,11037078,11037275,11037280,10102959,10102970,8835385,11008620,10940572,10940573,11008635,10940574,11008636,10940575,11008637,10940576,11008638,10940577,11008639,11008640,3655562,7069076,7069218,10944644,10995936,10995949,10995950,10995965,8564038,7198704,8072315,8615553,8615564,8072778,8072779,8072780,8072781,8072782,10101378,8616152,8616153,8616154,8565064,10942120,10942121,11010222,11010223,11010234,11010256,11010257,11010265,11010266,11010267,11010279,11010280,10997515,10954691,10954779,10954847,4936932,8613142,4937067,4937079,3233778,4937091,3233788,3233792,3233793,3233794,4937103,10968579,10618970,10618971,8613919,4938053,8907476,3234840,3234841,3234842,3234843,8071167,8071322,8071334,8071340,8071350,8071362,3235054,4938482,4938483,4938484,4938485,4938486,3235201,11008615,11008616,11008617,11008618,11008619,10927573,8541758,10967052,10967053,10967054,10967055,10837262,10993423,8542260,8542261,8542262,10620419,10620420,10620421,10620422,10620423,10620424,10620425,10615828,10930773,10930861,10930890,10926885,11044078,11044079,8541008,8541011,10922210,10922211,10922212,10922213,10922214,10922215,10922216,10621746,10621747,10621748,10621749,10621750,8864229,8864273,10559790,10559791,10559792,10559793,9190234,9190235,8542602,9179841,9179842,9179843,9179844,9179845,9179846,9171898,9172155,9172156,9196482,9196483,9180659,9180660,9180661,9180662,9180663,9180664,9180665,9180666,9180667,9180668,9180669,9180670,9180671,9180672,9180673,9180674,9180675,9180676,9180677,9180678,9180679,9180680,9180681,9180682,9180683,9180684,9180685,9180686,9180687,9180688,9180689,9180690,9180691,9180692,9180693,9180694,9180695,9180696,9180697,9180698,9180699,9180700,9180701,9180702,9180703,9180704,9180705,9180706,9180707,9180708,9180709,9180710,9180711,9180712,9180713,9180714,9188714,9180715,9180716,9180717,9180718,9180719,9180720,9188720,9180721,9188721,9180722,9180723,9180724,9180725,9180726,9180727,9180728,9180729,9180730,9180731,9180732,9180733,9180734,9180735,9180736,9180737,9188738,9180738,9188739,9180739,9180740,9180741,9180742,9180743,9180744,9180745,9180746,9180747,9180748,9180749,9180750,9180751,9180752,9180753,9180754,9180755,9180756,9180757,9180758,9180759,9188759,9180760,9188760,9180761,9180762,9180763,9180764,9180765,9180766,9180767,9180768,9180769,9180770,9180771,9180772,9180773,9180774,9180775,9180776,9180777,9180778,9180779,9180780,9180781,9180782,9188783,9180783,9188784,9180784,9188785,9180785,9188786,9180786,9180787,9180788,9180789,9180790,9180791,9180792,9180793,9180794,9180795,9180796,9180797,9180798,9180799,9180800,9180801,9180802,9188803,9180803,9188804,9180804,9188805,9180805,9180806,9180807,9180808,9180809,9180810,9180811,9180812,9180813,9180814,9180815,9180816,9180817,9180818,10564632,9180819,10564633,9180820,9180821,9180822,9180823,9180824,9180825,9180826,9180827,9180828,9180829,9180830,9180831,9180832,9180833,9180834,9180835,9180836,10564672,10564831,8863629,6677346,9197270,9197271,9197273,9185434,7056231,7056232,7056233,7056234,7056235,9162130,9162131,9162137,6674538,9186813,9210918,9210919,6672579,4973356,4973360,4973361,4973755,4973756,4973757,4973758,4973759,4973775,4973776,9176958,9176959,9176960,9176961,9176962,9176963,9176964,9176965,9176966,9176967,9176968,9176969,9176970,9176971,9176972,9176973,9176974,9176975,9176976,9176977,9176978,9176979,9176980,9176981,9198492,9198531,9174889,10123270,10123277,9183156,8550500,8550501,9167516,8550802,8917322,8917327,9167733,8917418,8917419,9191870,9191881,6667880,10628400,10169993,10169994,10169995,10169996,10169997,10169998,10169999,10170000,10170001,10170002,10170003,10170004,10170005,10170006,10170007,10170008,10170009,10170010,10170011,10170012,10170013,10170014,10170015,10170016,10170017,10170018,10170019,10170020,10170021,10170022,10170023,10170024,10170025,10170026,10170027,10170028,10170029,10170030,10170031,10170032,10170033,10170034,8594101,8594102,8594103,8594104,8594105,8594106,8594107,8594108,8594109,8594110,8594111,8594112,8594113,8594215,8594269,10175768,10894793,10894794,10894795,10894796,10894797,10894798,10894799,10894800,10894801,10175813,10894802,10175814,10894803,10894804,10894805,10894806,10894807,10894808,10894809,10894810,10894811,10894812,10894813,10894814,10894815,10894816,10894817,10894818,10894819,10894820,10894821,10894822,10894823,10894824,10894825,10894826,10894827,10894828,10894829,10894830,10894831,10894832,10894833,10894834,10894835,10894836,10894837,10894838,10894839,10894840,10894841,10894842,10894843,10894844,10894845,10894846,10894847,10894848,10894849,10894850,10894851,10894852,10894853,10894854,10894855,10894856,10894857,10894858,10894859,10894860,10894861,10894862,10894863,10894864,10894865,10894866,10894867,10894868,10894869,10894870,10894871,10155940,10156041,10156108,10186148,10885315,10158789,7000966,10158790,10173790,10173791,10158792,10173792,10158793,10173793,10173794,10173795,10173796,10173797,10173798,10173799,7001096,10627541,10174280,10174281,10174322,10174323,10174324,10174325,10167355,10167356,10167357,10167358,10172543,10172544,10172567,10172568,10172569,10172570,10172571,10172572,10172624,10172625,10172626,10172627,10172628,10172658,10172659,10172660,10172661,10172662,10172663,10172664,10949957,10950047,10626761,10626762,10626763,10626764,10626765,10626770,10626776,10173370,10649865,10649866,10649867,10649868,10649869,10537636,10537637,10537638,10537639,10537640,10537641,10537658,10537659,10537660,10537661,10537662,10537710,10537711,10537712,10537713,10537714,10537715,10537716,10537717,10537718,10537719,10542101,10542102,10542103,10542104,10542105,10524210,10524211,10524212,10524213,10524214,10524215,10524216,10524217,10524218,10524219,10524220,10524221,10524222,10524223,10524224,10524225,10524226,10524227,10524228,10524229,10524230,10524231,10524232,10524233,10524234,10524235,10524236,10524237,10524238,10524239,10524240,10524241,10524242,10524243,10524244,10524245,10524246,10524247,10524248,10524249,10524250,10524251,10524252,10524253,10524254,10524255,10524256,10524257,10524258,10524259,10524260,10524261,10524262,10524263,10524264,10524265,10524266,10524267,10524268,10524269,10534339,10534340,10534341,10534342,10534343,10523043,10523044,10523045,10523046,10523047,10523048,10523049,10523050,10523051,10523052,10523053,10523054,10422300,10422649,10422758,10422759,10423066,10480940,10480941,10480942,10490054,10473081,10490111,10490112,10490154,10490155,10473332,10473333,10473334,10496338,10473340,10473351,10473409,10473410,10473416,10473417,10473447,10473448,10473457,10473528,10473529,10496534,10496591,10473962,10478243,10478244,10478245,10478246,10478247,10478248,10478249,10478250,10478251,10478252,10478253,10478254,10478255,10478256,10478257,10478258,10478259,10478260,10478261,10478262,10478263,10478264,10478265,10478266,10478267,10478268,10478269,10478270,10478271,10478272,10489335,10489336,10489337,10489338,10489339,10489352,10489353,10489354,10489355,10489364,10489365,10489366,10489367,10489368,10489396,10489413,10487438,10487439,10489521,10489792,10472823,10472847) 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'