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(10861402,10861475,10861476,10861477,8631123,8631124,10861785,3229101,3229102,10950677,10950679,10862666,10862667,10862668,10862669,10862670,10862671,10862672,10862673,10862674,10862675,10862676,10862677,10862678,10862679,10862680,10862681,10862682,10862683,10862684,10862685,10862686,10862687,8575659,10858341,7201311,7201312,7201646,8065850,8628643,9794573,7202762,7202763,7200389,7200390,7200660,7200668,7200673,7200698,7200711,7200715,7200717,7200718,7200719,10865862,10865863,10865864,10865865,10865866,10865867,10865868,10865869,10865870,10865871,10865872,10865873,10865874,10865875,10865876,10865877,10865878,10865879,10865880,10865881,10865882,10865883,10865884,10865885,10865886,10865887,10865888,10865889,10865890,10865891,10865892,10865893,10865894,10865895,10865896,10865897,10865898,10865899,10865900,10865901,10865902,10865903,10865904,10865905,10865906,10865907,10865908,10865909,10865910,10865911,10865912,10865913,10865914,10865915,10865916,10865917,10865918,10865919,10865920,10865921,10865922,10865923,10865924,10865925,3238184,7198183,10863249,10863250,10863251,10863252,10863253,10863254,10863255,10863256,10863257,10863258,10863259,10863260,10863261,10863262,10863263,10863264,10863265,10863266,10863267,10863268,10863269,8908472,10863979,10856180,7199162,7199163,7199164,7199165,7199166,7199167,7199360,7199361,7199362,7199363,7199404,10101541,10856988,10856989,10856990,10856991,10856992,10856993,10856994,3923483,7196378,3923598,8906797,8906798,8624260,8905468,8905853,8905940,8905941,8905942,10615038,10615039,10615040,10615041,10615042,10615043,10615044,10615045,10615046,10615047,10615048,10615049,10615050,10615051,10615052,10615053,10615054,10615055,10615056,10615057,10615058,10615059,10615060,10615061,10615062,10615063,10615064,10615065,10615066,10615067,10615068,10615069,10615070,10615071,10615072,10615073,10615074,10615075,10615076,10615077,10615078,10615079,10615080,10615081,10615082,10615819,10426447,8611448,10616792,10616793,10616794,10616795,10616796,10616797,10616798,10616799,10616800,10616801,10616802,10616803,10616804,10616805,10616806,10616807,10616808,10616809,10616810,10616811,10616812,10616813,10616814,10616815,10616816,10616817,10616818,10616819,10616820,10616821,10616822,10616823,10616824,10616825,10616826,10616827,10616828,10616829,10616830,10616831,10616832,10616833,10616834,10616835,10616836,10616837,10616838,10714175,10614412,10614413,10614414,10611757,10611779,10612220,10612294,8851511,8851515,10612417,10612418,10612419,10612420,10612421,10612422,10612423,10612424,10612425,10609825,8852147,8852148,10613073,10613074,8852311,8852312,8852328,6673519,9169406,9169407,9169408,9169409,9169410,9169411,9169412,9169413,9169414,9169415,6673804,6673805,6673806,9169814,9169815,9169816,9169817,9169818,9169819,9169820,9912121,10118210,6674269,6674270,6674271,6674272,6674273,6674274,6674275,6674276,6674277,6674278,6674279,6674280,6674281,6674282,6674283,6674284,6674285,6674286,6674287,10118303,10118304,10118305,10118306,10118307,9912356,9912357,9912358,10118584,10118585,10118586,10118587,10118588,10118589,10118590,9912762,9912948,9912949,9912950,8850579,8552225,9913258,9913259,9913260,9913261,9913262,9913263,9913264,9913265,9913266,9913267,9913268,9913269,9913270,9913271,9913272,9913273,9913274,9913275,10416285,10416286,10416287,10416288,10416289,10416290,10416291,10416292,10416293,10416294,10416295,10416296,10416297,10416298,10416299,10416300,10416301,10415343,10417385,10415386,10416489,10415635,10417644,10416780,10416781,10416782,10416783,10416784,10416785,10416786,10416787,10416788,10416789,10416790,10416791,10416792,10416793,10416794,10416795,10416796,10419034,10419035,10419036,10419037,10419038,10419039,10419040,10419041,10419042,10419043,10419044,10419045,10419046,10419047,10419048,10419049,10419050,10419051,10419052,10419053,10419054,10419055,10419056,10419057,10419058,10419059,10419060,10419061,10419062,10419063,10419064,10419065,10419066,10419067,10419068,10419069,10419070,10419071,10419072,10419073,10419074,10419075,10419076,10419077,10419078,10419079,10419080,10419081,10419082,10419083,10419084,10419085,10419086,10419087,10419088,10419089,10419090,10419091,10419092,10419093,10419094,10419095,10419096,10471099,10471100,10471101,10471102,10471103,10469552,10469553,10469554,8550145,8550146,8550147,8550148,8550149,8550150,8550254,10469894,10469895,10469896,10469897,10469898,10469899,10469900,10469901,976578,976579,10468668,10468669,10889059,10884339,10884340,10884341,10884342,10884343,10884344,10884345,10884346,10884347,10884348,10884631,10889655,10889656,10889657,10889658,10889659,10889660,10889661,10889662,10889663,10889664,10889665,10889666,10889667,10889668,10889669,10889670,10889671,10889672,10889673,10889674,10889675,10889676,10889677,10889678,10889679,10889680,10889681,10889682,10889683,10889684,10889685,10889686,10889687,10889688,10889689,10889690,10889691,10889692,10889693,10889694,10889695,10889696,10889901,10885017,10875050,10885206,10885207,10885208,10885209,10885210,10885211,10153849,10887935,10887936,10887937,10887938,10887939,10887940,10887941,10887942,10887943,10887944,10887945,10887946,10887947,10887948,10887949,10887950,10887951,10887952,10887953,10887954,10887955,10887956,10887957,10888014,10888015,10888016,10888017,10888018,10888019,10883434,10161938,10161939,10162149,10162150,10162151,10162152,10162153,10162154,10887346,10602401,10521879,10521880,10508350,10411844,10411845,10411846,10411847,10411848,10411849,10411850,10411851,10412875) 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'