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(8574075,8838422,7068189,8621036,8621037,7068249,7068250,10846038,8621147,7068323,10940114,7068674,8574934,7068761,10846614,8067197,7074292,8067650,7074585,10977343,10977344,10977345,10977346,7066722,10977449,11039573,11039575,8067908,11000611,7075145,11039986,11040019,10929607,8573668,11001279,8617779,10972630,8911126,11037786,10972796,11037923,7072257,8911346,7072337,7072352,10973053,7064404,7072430,7072442,8595093,11038213,11038214,11038223,11038262,7072653,7072690,3899238,7072742,11038494,11038495,11038514,7072846,7072847,7072872,11038634,11038751,8836641,8066302,11039256,10974347,10974348,10974349,10974350,10974351,10974352,10961412,8557898,8557902,8557908,8616830,3927422,7071083,8558040,8558041,8558065,8558073,8558082,8558107,8558134,10102321,10942947,10943058,10102547,10102757,10969589,8908003,8908004,10969781,10969899,7069266,7069330,11022300,10970347,11022713,10971111,7070465,8616311,10942319,8616537,11023395,10942448,10997489,10997490,10853148,10923610,10923812,10923815,10923861,10923863,11032904,10923940,8906471,8906472,8906473,8906474,10924324,7197043,7197046,7197050,7197051,7197129,3924351,10924752,10924763,11033866,10924850,11034064,11034067,10925086,10925090,10925091,10925092,10925093,11034127,11034128,11034129,7158051,7158052,10839269,11021265,10839334,11021270,11034322,11034323,8555597,8907721,10925357,10925358,8614579,10925427,10922633,11005708,10922696,10922699,3232475,3232476,8578247,8578499,8578603,10923107,10923112,10923173,8578868,10918446,8576109,10920840,10925871,10620412,10620413,8570291,10921026,10921027,10921028,8570350,10620660,10921171,10921373,10921376,10426151,10426152,10426153,10978511,10978512,10978513,10978514,10978515,10978516,11030538,11030550,10921663,10921664,10978799,10978802,10921849,10426633,10616460,10616461,8904396,3231769,3231801,3231802,11031093,10426778,10426784,11005108,10621735,10953461,8853157,8853158,8853239,8568173,8853579,10611656,10611657,10611658,10611659,10611660,10611661,9206201,10611969,9195412,10557243,10557244,9195476,9195520,9203630,10119828,8851482,8851483,8851484,8851485,8851486,8851487,8851488,8851489,8851490,8851491,8851492,8851493,8851495,8851496,8851497,8851498,8851499,8851500,8851501,8851502,8851503,8851504,8851505,8851506,8851507,8851509,8851510,8851511,8851512,8851513,8851514,8851515,8851516,8851517,8851518,8851519,8851520,8851521,8851522,8851523,8851524,8851525,8851526,8851527,8851528,8851529,8851530,8851531,8851532,8851533,8851534,8851535,8851536,8851537,8851538,8851539,8851540,9195852,9203921,9203925,7058191,9914234,7058201,7058210,8566563,10563914,10563915,10610041,9914648,8852322,10564391,10564400,10564401,7058852,7058865,8863369,3654074,3654075,3654076,10613624,10613625,10613631,10613632,7059241,7059457,10555195,10555204,8849262,8849263,8849265,8849266,8849267,8849268,7015117,9193802,9193803,10555728,10555731,4974782,9177977,9177978,9177979,9177992,9177993,9177994,8849828,8849869,9202078,9178086,7056255,10555917,10118383,9178431,9178539,10556404,8850482,10512801,10512806,8848187,8848188,8848189,8848190,10124713,10124714,9192544,9192686,10124946,9176775,6673024,6673051,9200877,9192926,9192980,9193053,9193077,8848902,8848903,8848904,8848905,8848906,10428588,9206324,10467105,10467106,10467108,10467110,10467111,10467112,10467114,8569044,10467122,9206545,10467123,10467124,10467125,10467127,10467128,10467132,10467141,10467144,10467145,10122781,4971518,8549898,8549899,8549900,8549901,8549902,10469598,10469608,10469614,10123405,8855036,4972085,10470036,10470037,10470038,10470039,8847328,10468118,10468187,8847604,8847605,8847606,10908530,10628032,10628064,10628081,10883653,10883654,10883825,10883829,10883836,10164889,10909018,10909192,10909308,10180366,10180368,10899430,10884489,10904604,10899735,10180794,10165815,10889831,10629555,10186402,10186403,10186478,10627000,10888135,10888235,10888237,10888238,10888270,10908427,10908428,10908429,10908433,10166592,10166645,10186777,10890948,10890949,10630482,10162020,10167235,10167321,10167322,10167430,10182431,10182432,10182433,10167440,10167441,10896460,10896461,10896462,10631036,10949443,10182715,10896922,10182935,10168076,10183108,10183110,10907417,10907419,10602064,10602065,10602069,10602165,10602166,10602195,10602672,10602673,10568848,10602721,10602731,10653042,10580991,10580997,10581004,10581162,10581206,10575334,10581345,10578365,10578366,10578367,10578484,10578485,10581579,10581621,10581622,10581675,10581677,10581678,10581679,10581681,10581684,10581718,10581719,10581720,10581721,10581722,10581723,10578775,10578776,10581793,10603699,10581876,10581943,10578953,10579545,10601428,10601429,10601430,10601661,10601662,10591944,10591945,10577070,10549238,10549239,10549240,10549263,10523265,10523266,10553371,10553375,10553379,10549383,10553384,10549386,10549494,10549495,10549537,10529664,10535708,10535715,10527808,10551827,10551828,10551829,10551830,10551833,10551835,10550364,10550365,10554374,10540760,10548781,10528816,10552910,10552920,10552930,10493968,10493969,10480999,10481010,10481034,10481035,10481036,10479231,10479232,10481462,10494509,10494510,10479553,10479554,10481566,10479767,10479786,10494862,10479869,10479870,10479871,10479872,10494892,10477931,10497029,10497196,10480259,10480260,10478552,10487631,10487687) 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'