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(8574288,10870629,8574522,8621182,7068398,11041321,10862126,8583434,10868274,10868275,10868276,10868277,10868278,10868279,10868280,10868281,10868282,10868283,9215710,9215711,9215712,9215713,9215714,10950747,10950748,10868455,10849502,10849504,9215876,9215877,9215878,8631878,8631883,8631901,8631902,8631924,8631925,8631926,8631957,8631974,8631975,8632020,8632021,8632022,8632023,8632060,8632061,8632062,8632063,8632084,8632092,8632093,10862737,8632100,8632101,8632113,10862834,10862835,10990291,10869181,10869182,10869183,10869185,10869187,10869189,10869192,8629712,8629713,10860413,10860414,8629829,10860472,8629830,10860746,10860747,10860748,10860749,10860750,10860751,10860752,8561413,8630453,8630454,8630455,8627828,10842980,7201608,7201614,7064386,8628048,8628076,8628089,8628090,8628096,8628102,8628103,10866816,10866817,8595175,10866827,10960354,10867016,10986448,10986474,10843580,7202129,7202130,7202137,7202139,10104034,7202162,8066171,7202493,7202494,7202495,10960948,11000021,11000022,10867700,8629092,10932804,9794589,10859904,10859905,10859906,10859907,10859911,10859912,10859913,7065834,10857260,3237402,10102294,8626847,8626849,8626876,8626877,8626878,8626879,8626880,8626881,8626882,8626883,8626884,8626885,8626886,8626887,8626888,8626889,8626890,8626891,8626901,10857654,8910460,8910461,10857917,10857924,10857929,10858035,10858036,10858174,10858175,7198383,10855548,8908406,10863677,10863678,10863679,10863680,10863681,10863682,10863683,10863684,10863685,10863686,10863687,10863688,7198697,7198710,7198711,7198743,10863864,10863865,10863866,10863867,10863891,11047587,10996415,8625397,8564862,8565241,8626186,8626449,8626450,8626451,8626452,8626453,7200121,10997562,10997564,10838514,10838521,10838547,10838548,10838549,10838550,10838551,8906889,10838821,10838978,8907500,8907501,7197714,7197717,7197722,3234902,3234918,3234942,3234950,3234952,7197799,7197806,7197807,8907640,8907658,8907673,10995358,10995366,10995367,10995373,10995376,10995377,10995378,8614603,8614604,11047464,11047465,11047466,11047467,11047477,11047478,10619836,8624512,10619900,3925290,8624569,11044847,11044848,11044849,11044850,10852523,10617326,8905383,8905384,10617370,10617371,10617384,3232835,10617449,10617450,7156042,8612482,8905717,10837565,10837567,10614998,10620189,10620190,10620191,10620192,10620193,10620194,10620202,8632892,3230669,10848003,3230670,3230671,3230887,10426193,10952581,10426402,10931016,10952891,8904333,8904358,8634308,8634338,8634339,10922262,10922263,10922289,3232183,8634458,3232240,3232247,3232256,3232289,3232312,3232315,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,8853300,10614221,9173722,8853587,8853604,8853605,8853738,10611835,10611913,10611916,10611917,10611931,10611933,10611934,10611935,8851657,7017946,10609971,7017966,7017986,9188363,9188381,9188395,9188396,10610097,10613334,9188687,9188811,9188812,9188813,8852820,8852823,10610739,8567663,10613853,10613854,10613855,10613856,10613857,10613858,10613859,8853027,8853093,8853094,8853095,8853096,8853097,9911522,7015151,7015152,7015153,7015154,7015155,7015156,7015157,7015158,7015159,7015160,7015161,7015162,10515377,7015290,7015310,7015330,9185833,9912268,9912424,9912425,9912437,9912438,8850148,9912816,9913362,10417296,10417297,10417298,10417300,10417331,10416397,10416398,10416405,4973379,10419478,10419681,10419682,10419693,10419724,10419899,10419900,10417113,10417115,10417117,10417118,10417127,10417134,10417142,10417146,10417158,10417160,10122597,10471171,8549880,8549896,4971855,4971856,7020662,8550265,9175299,10465877,8550627,8550629,8855351,976532,9168100,10883585,10883623,10908682,10898732,10893988,10884080,10884081,10910023,10171186,10905187,10905192,10176230,10885350,10632041,10887553,10887554,10632045,10632311,10632312,10632313,10153995,10883069,10883398,10883429,10895752,10886179,10886180,10886181,10886182,10886183,10886184,10886185,10886186,10886187,10886188,10886189,10886190,10886191,10886192,10886193,10631437,10631438,10188045,10887196,10882357,10602164,10602166,10602169,10602170,10602172,10643539,10643541,10598574,10598581,10598809,10643872,10602695,10602708,10598859,10606799,10606800,10585351,10591362,10579822,10422280,10421398,10421399,10421400,10421402,10421404,10421409,10420425,10420873,10420874,10420875,10420876,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10420999,10425035,10483072,10483079,10483088,10483107,10483108,10483109,10483110,10483111,10486565,10414300,10414301,10414302,10414303,10414307,10414308,10414309,10412502,10412508,10412513,10412514,10414520,10414693,10410712,10414719,10412742,10412743,10412744,10414969,10414970,10408986,10407086,10407088,10478845) 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'