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(10930095,11001744,10861428,10861429,10861438,10861439,10861440,8630924,8630925,10989095,10861699,10989096,3229077,8631600,9215665,9215666,9215707,9215708,9215709,9215711,9215712,9215713,9215714,10849376,10849383,10849384,10849387,9215858,10849659,8575554,10850062,10860325,8573267,8573268,8573269,10860453,8629877,10860534,10860732,10860742,10860743,10860751,8620482,10858168,10858169,10858170,7201195,7201196,7201200,7201293,7201294,8627707,8627710,8627712,10866362,8617921,3238523,3238525,10842953,10842986,10842999,10866535,10999125,10858760,10858761,8075333,8075334,8075335,8075336,7201736,10866818,7201844,8911721,8911744,8911775,8595719,8628787,7202459,7202460,5654682,5654683,8629257,8629261,8629413,10857140,7200128,8626896,8626900,8626901,10865588,10865589,10865613,10865614,8627010,7200637,8910461,8627089,8627090,8627107,8627120,8910600,8910601,8910602,10857918,10857919,10857920,10857928,7200911,7200913,10857966,10857967,10857989,8624699,8624700,8624701,7198388,10855451,10995911,10863564,10863565,10863584,10863585,10863586,10855655,10855656,10863672,10863673,10863674,10863675,10863676,7198681,7198727,7198728,7198742,8908753,8625349,8625350,8625351,8625363,8625365,8625367,8625370,8625520,8625521,8625522,8625523,8625524,10856191,8625628,8625629,8625630,10941717,10864306,3926474,8625932,8625933,8625934,8625935,7199545,10101534,8860420,8626292,8626296,8626297,8626299,8626306,8626307,8626316,8626329,10942455,8626396,8626397,8626398,8626444,8626445,8626446,8626447,8626448,10853106,8612968,10853485,11006989,10853642,10853773,7196891,3234104,3234105,3234112,3234116,3234117,3234118,3234119,3234120,3234121,8906886,7197259,10838990,8907503,3234905,3234917,8907612,7197813,7197819,8907685,8541459,8541470,3232407,8552966,3232457,8541595,8541596,11044791,11044797,11044798,11044799,11044800,11044801,11044802,8634779,8634781,8634783,8634786,8634791,8634792,8905221,8905249,8905250,10617339,8634845,8905262,10852571,10617434,10617435,10622460,8905383,8905384,8905385,10852621,10993400,10993419,8632637,8632638,8632639,10620208,10615229,10425551,10425556,10850507,10850508,10850509,10848001,10848002,10848003,10850648,8633189,10425944,10615823,10991719,8540610,8904329,10616426,8611461,8611463,8611468,10427127,8853224,10614499,8853738,8565891,10612106,10612107,9211539,9211553,10612292,10612293,10609313,8862394,10612937,10612938,7017945,7017965,9212322,9212323,7017985,10610060,10613096,9188681,10613736,10613811,10613815,10613823,10613824,10613825,10613826,10613827,10613828,10613829,10613830,10613840,10613841,10613842,10613843,10613857,8849378,10515422,7015289,9911860,9911862,7015309,7015329,9912021,10118147,10118148,10118149,9912193,9169998,10118214,6674327,9912463,10118607,9912641,9912642,6674709,6674710,9162587,9186780,8552193,8552198,9913354,9913360,9910628,10415367,10419370,10415374,10415375,10415376,4973308,10419530,8918275,10417633,10419684,10428147,4973746,8848722,10418820,10418841,10418842,8848815,10417111,10417112,10417158,10417159,10469338,8549957,8550015,9175258,10468235,8847529,8847998,8848087,8848088,8593548,10883570,10883571,10903593,10903596,10888637,10884078,10884079,10885072,10890131,10890163,10890255,10890256,10890257,10890258,10890259,10626963,7000889,7000890,10627319,10883081,10161705,10885958,10886070,10886076,10162091,10886097,10886108,10886109,10886110,10886111,10886112,10886113,10886114,10886115,10886116,10886131,10886132,10886148,10886160,10886173,10886174,10886175,10886176,10172193,10886192,10881486,10881487,10187807,10631420,10631421,10631438,10168073,10882133,10887227,10643545,10580512,10646621,10646622,10608654,10602732,10608857,10590268,10590278,10590289,10603684,10603696,10651651,10651652,10591759,10591760,10601694,10539116,10529861,10527957,10524418,10546510,10546511,10546512,10498867,10425038,10411285,10407299,10413314,10413315,10413316,10413317,10409665,10407819,10407820,10407821,10486564,10486568,10496937,10496984,10478013,10497040,10487109,10487110,10487111,10487112,10412503,10412504,10412505,10412512,10412553,10412554,10412575,10410627,10414662,10414738,10412738,10412739,10414814,10406982,10406989,10406990,10406993,10409024) 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'