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(10861598,10861599,10861600,10861601,10861602,10861604,10861606,10861699,3228909,3229134,8583521,8583522,10862617,10862618,10862619,10862620,10862621,10862622,8609594,10863076,10863077,10863078,10863079,10863080,8632519,8632526,8632527,10929251,10929253,8573262,8573298,10860454,10860557,10860684,10860685,10861030,10861049,10861050,10866535,10866545,10866546,10866547,7201520,7201521,7201522,7201523,7201524,7201525,7201664,7201963,7202581,7202596,8910056,10857385,10857392,10857393,10857394,10857395,10857396,10857397,7200466,7200467,7200584,10865707,10865708,10865781,10865791,10865848,8627468,8627477,8627481,8627482,8627483,8627484,8627485,8627486,8627487,8627488,8627489,8627490,8627499,8627500,8627504,8627505,8627506,8627513,8627514,8627525,8627526,8627527,10855616,7198651,7198680,10863842,10856038,10856039,10856040,10856041,10856042,10856137,10853752,10853767,10853770,10853771,10853780,10853793,10853865,10853888,10853894,10853900,10853904,10853935,10853938,10853940,10853942,10853943,10854055,8906860,10854107,10854123,10854124,10854162,10854410,10854449,10854450,10854451,10854453,10854454,10854455,10854458,10854459,10854460,10854463,10854464,10854465,10854469,10854473,10854474,10854475,10854479,10854480,10854481,10854483,10854484,10854485,10854488,10854489,10854490,10854494,10854495,10854496,10854500,10854501,10854502,10854506,10854507,10854508,10854529,10854531,10854532,10854535,10854536,10854537,10854539,10854540,10854541,10854545,10854546,10854547,10854551,10854552,10854553,10854574,10854575,10854581,10854587,10854588,10854594,10854595,10854596,10854604,10854610,10854617,10854621,10854622,10854623,10854627,10854628,10854629,10854633,10854634,10854635,10854639,10854640,10854641,10854645,10854646,10854647,10854649,10854650,10854651,10854655,10854656,10854657,10854666,10854674,10854675,10854678,10854679,10854680,10854686,8907458,10854695,10854696,8907466,8907467,8907468,10854699,8907469,8907470,10854701,8907471,10854702,8907472,8907473,8907474,10854706,10854707,10854708,10854712,10854718,10854719,10854720,10854726,10854727,10854728,10854735,10854736,10854737,10854743,10854744,10854745,10854747,10854748,10854749,10854753,10854754,10854757,10854758,10854762,10854763,10854766,10854767,10854768,10854771,10854774,10854778,10854782,10854783,10854787,10854788,10854789,10854791,10854792,10854793,10854795,10854796,10854797,10854800,10854801,10854802,10854810,10854838,10854839,10854843,10854844,10854848,10854849,10854850,10854856,10854860,10854861,10854862,10854866,10854891,10854892,8624251,10854893,8624252,10854895,8624254,10854896,10854897,8624255,10854899,10854900,10854901,10854904,10854905,10854906,10854909,10854910,10854911,10854989,8542165,8905931,8905932,8905933,10614977,10614978,10614979,10615867,10616619,10610990,10612320,10612321,8851572,8851573,8851574,8851575,10609838,8852289,8852290,8852291,8852292,8852293,8852294,8852295,8852296,8852297,8852298,8852314,10613158,10613166,10613170,10613171,10613208,10613225,8567072,8567073,8567079,10613258,10613318,10613319,10613565,10613703,10613704,10610850,10610952,9911548,6673558,9911585,9169388,9169389,9169390,9169391,10118097,10118126,10118127,10118128,6674185,10118263,10118290,10118291,10118292,8850094,8850110,10118519,8850411,9912900,10417293,9168385,10416629,10416630,10416631,10416632,10416633,9168841,9169195,9169196,9169197,9169198,9169199,9169200,9169201,9169202,9169203,9169204,9169205,10117484,9190618,8550130,10469882,10469883,10469884,10469885,10469886,10469887,10469888,10469889,10469890,10469891,10469892,10884998,10632040,10632041,10632042,10632043,10632044,10632045,10632046,10632047,10632048,10632049,10632050,10632051,10632052,10632053,10632054,10632055,10632056,10627316,10887874,10887875,10887876,10887877,10887878,10887879,10887880,10888339,10885697,10885959,10162044,10886164,10162239,10162240,10887202,10887203,10887204,10887205,10887206,10887207,10887208,10887209,10887210,10887211,10887212,10887213,10887214,10887215,10887216,10887217,10887218,10887219,10887220,10887221,10887222,10887223,10887224,10887225,10887226,10887227,10887228,10887229,10887230,10887231,10887232,10887233,10887234,10887235,10887236,10887237,10887238,10887239,10887240,10887241,10887242,10887243,10887244,10887245,10590192,10522122,10522123,10411252,10410019,10410779,10411185,10411186,10411187,10411188,10411189,10411190,10411191) 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'