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(10858876,10858885,10858886,10858899,10858906,7202036,8628612,7065984,10859920,10873225,10855886,10855887,10855888,10855889,10855890,10855891,10855892,10855893,10855894,10856064,8909142,8909160,7199663,7199664,7199896,10857634,7197626,7197676,7197677,7197702,7197942,7197943,7197944,7197945,7198014,7198046,8905543,8905751,8905893,10853145,10853146,10853147,10853148,7196193,8906013,7196235,7196237,7196245,3923412,7196403,7196404,10837930,10837931,8554291,8554307,8554332,8554367,8906565,7196929,7196991,7196995,10854060,7197042,7197043,7197044,7197045,7197046,7197047,7197048,7197049,7197050,7197051,7197058,7197059,7197071,7197094,7197096,7197129,7197439,7197582,10425940,10425941,10426012,10426014,10618294,10618295,10618297,10618300,10618301,10618304,10426152,10864519,10864537,10864553,10864568,10864586,10864603,8904790,10865141,10865147,8905200,10865635,10862658,10617162,10617163,10622525,10425487,8632837,10615331,8630665,10615926,10615927,10615947,10188365,10188375,10188376,10188377,10188378,10188379,10188380,10188381,10188382,10188383,10188384,10188385,10188386,10849077,10849341,10849372,10862424,10714020,10714120,6669870,6669919,10614719,10614720,10566083,10612009,8851660,10612536,10612575,10612596,10612653,7058250,10612899,10612974,9911537,9911770,9911771,9911772,9911773,9911774,9911775,9911776,9911777,9911778,10117796,10117844,9912004,9912005,9912006,9912804,9912818,9912841,9912842,7016417,7016418,7016419,7016420,9913224,9913276,8848140,8848158,8848163,9168353,10416279,10419397,10418456,10418461,6673025,6673056,10417830,10417849,10417866,6673158,10417883,10417901,10417919,10467240,8549913,8549917,10469665,10469666,10467743,976360,976361,976362,976445,10466247,10468359,10468408,9168009,8847997,8847999,8848004,8848005,8848008,8848012,8848020,8848022,8848023,8848029,8848030,8848031,8848032,8848035,8848038,8848039,8848040,8848041,8848042,8848043,8848044,8848047,8848051,8848053,8848054,8848070,8848093,8848096,8848097,8848100,8848101,8848102,8848103,8848104,9168280,8848105,10427660,10883609,10883617,10883625,10883643,10883653,10888986,10889548,10884823,10884837,10884848,10890028,10887642,10183897,10883392,10883398,10883474,10161662,10885718,10885720,10161958,10886000,10886028,10601964,10601969,10601970,10601971,10601972,10601973,10601981,10601983,10601984,10601985,10601986,10601988,10601989,10601990,10601991,10601997,10601998,10602003,10602004,10602005,10602006,10602010,10602015,10602018,10602021,10602035,10602036,10602037,10602047,10602048,10602049,10602050,10602051,10602052,10602058,10602059,10602065,10602071,10602077,10602080,10602088,10602093,10602102,10602103,10602104,10602105,10602106,10602110,10602112,10602113,10602114,10602115,10602116,10602117,10602118,10602119,10602120,10602121,10602122,10602124,10602127,10602128,10602129,10602131,10602135,10602136,10602137,10602138,10602140,10602141,10602143,10602144,10602145,10602146,10602147,10602148,10602149,10602150,10602151,10602152,10602153,10602154,10602155,10602156,10602157,10602158,10602159,10602160,10602162,10602163,10602164,10602165,10602166,10602167,10602169,10602170,10602172,10602179,10602180,10602181,10602182,10602183,10602184,10602185,10602186,10602187,10602188,10602189,10602191,10602192,10602193,10602194,10602195,10602196,10602197,10602198,10602199,10602200,10602201,10602202,10602203,10602204,10602208,10602209,10602210,10602211,10602213,10602218,10602228,10602229,10602234,10611344,10647469,10609274,10609737,10609738,10609739,10609946,10610018,10610019,10610268,10610293,10604423,10604424,10610492,10604647,10604676,10604677,10604679,10604680,10610681,10610682,10604702,10610727,10601732,10601735,10601736,10601740,10601741,10601742,10601752,10601756,10601757,10601758,10601759,10601760,10601761,10601763,10601764,10601766,10601768,10601780,10601787,10601789,10601793,10601795,10601797,10601799,10601801,10601804,10601805,10601806,10601807,10601809,10601810,10601812,10601814,10601815,10601827,10601829,10601831,10601832,10601839,10601860,10601862,10601863,10601868,10601869,10601870,10601871,10601872,10601873,10601879,10601880,10601890,10601891,10601892,10601893,10601894,10601895,10601898,10601899,10601900,10601902,10601903,10601904,10601905,10601906,10601909,10601910,10601911,10601917,10601923,10601924,10601926,10601927,10601929,10601930,10601932,10601946,10601947,10601948,10610950,10601955,10601956,10508383,10507656,10507663,10507664,10423925,10416063,10409351,10409352,10413407,10413415,10413416,10413424,10413427,10412247,10414316,10414818,10411029,10411030,10411031,10411032,10411033,10411034,10411035,10411207) 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'