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(10950749,7066247,10862717,3229979,10860575,10860576,10860577,8630259,8630260,8630261,8630262,8630299,7201605,7201607,8595258,8595259,10859156,10859157,10859158,10859159,10859160,8065850,7202439,7200382,7200383,7200384,7200385,7200386,7200387,7200388,7200389,7200390,7200581,10865834,10865835,10865836,10865837,10865838,10865839,10865840,10865841,10865842,10865843,10865844,10865845,10865846,10865847,10865848,10865849,10865850,10865851,10865852,10865853,10865854,10865855,10865856,10865857,10865858,10865859,10865860,10865861,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,10865995,10865996,10865997,10101504,7199651,7199652,7199653,7199654,7199655,7199656,7199657,7199658,7199659,7199660,7199661,7199662,7199663,7199664,7199665,10101576,10101577,10101578,10101579,11048488,10865141,10865142,10865143,10865144,10865145,10865146,10865147,10865148,10865149,10865150,10865151,10865152,10865153,10865154,10865155,10865156,3923641,8906564,8906565,8906566,8906795,8906796,8906797,8906798,10838928,10615139,10615147,10615378,3581891,10615551,10615556,10615941,10615942,10615943,10615944,10615945,10615946,10615947,10615948,10615949,10615950,10615951,10615952,10615953,10615954,10615955,10615956,10615957,10426414,10426415,10426416,10426417,10426418,10426419,10426420,10426446,10426447,8611448,10616776,10616777,10616778,10616779,10616780,10616781,10616782,10616783,10616784,10616785,10616786,10616787,10616788,10616789,10616790,10616791,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,10616897,10616898,10714177,10714195,10714196,10614463,10614464,10559708,10559710,10614588,8851705,10609965,8852528,8852529,8852530,8852531,8852532,8852533,8852534,8852535,8852536,8852537,8852538,8852713,8852714,8852715,8852716,8852717,9169561,9169671,9169672,9169673,9911917,9169812,9169813,9169814,9169815,9169816,9169817,9169818,9169819,9169820,9169821,9169887,9169918,6674195,10118224,6674268,6674269,6674270,6674271,6674272,6674273,6674274,6674275,6674276,6674277,6674278,6674279,6674280,6674281,6674282,6674283,6674284,6674285,6674286,6674287,10118503,10118504,10118581,10118582,10118583,10118584,10118585,10118586,10118587,10118588,10118589,10118590,8552225,9913187,9913222,9913223,9913256,9913257,9913258,9913259,9913260,9913261,9913262,9913263,9913264,9913265,9913266,9913267,9913268,9913269,9913270,9913271,9913272,9913273,9913274,9913275,10416320,10418455,10418456,10418457,10418458,10418459,10418460,10418461,10418462,10418463,10418464,10418465,10418466,10418467,10418468,10418469,10418470,10418471,10418472,10418473,10418474,10418475,10418476,10419008,10419009,10419010,10419011,10419012,10419013,10419014,10419015,10419016,10419017,10419018,10419019,10419020,10419021,10419022,10419023,10419024,10419025,10419026,10419027,10419028,10419029,10419030,10419031,10419032,10419033,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,10471096,10471097,10471098,10471099,10471100,10471101,10471102,10471103,8550019,10469567,8550240,8550241,976578,976579,10470681,10470682,10470683,10470684,10470685,10470686,10470687,10470688,10470689,10470690,10470691,10470692,10888610,10888612,10628155,10628156,10888980,10888981,10888982,10888983,10888984,10888985,10888986,10888987,10888988,10888989,10888990,10888991,10888992,10888993,10888994,10888995,10888996,10889548,10889634,10889635,10889636,10889637,10889638,10889639,10889640,10889641,10889642,10889643,10889644,10889645,10889646,10889647,10889648,10889649,10889650,10889651,10889652,10889653,10889654,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,10883020,10883021,10883022,10883023,10883024,10883259,10608061,10527948,10527949,10508137,10508138,10508139,10508140,10508141,10508142,10508143,10508144,10508145,10508146,10508147,10508148,10508149,10508150,10508151,10508152,10508153,10508154,10508155,10508156,10508157,10508158,10508528,10508529,10507811,10508066,10508067,10508068,10508069,10508070,10508071,10508072,10508073,10508074,10508075,10508076,10508077,10508078,10508079,10508080,10508081,10508082,10508083,10508084,10413645,10413646,10413647,10413648,10413649,10413650) 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'