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(10870374,8594627,8574331,9214874,7076283,9215004,9215005,10861755,10951114,10977234,10977235,10977236,10977237,10977238,10977239,10977240,10977241,10977242,10977243,10977244,10977245,10977246,10977247,10977248,10977249,10977250,10977251,10977252,10977253,10862901,10863042,8629772,8629773,8629798,8629799,10961950,10845395,10988346,10962418,10962419,10962420,10962421,10962492,10962493,10962494,10962495,10962496,10962497,7067842,9214582,8617782,8617783,8594863,10843024,10843025,8836260,3899382,7202187,8560562,8560563,3227172,11048944,7071224,7071225,7071226,7071240,3927827,10102851,3925427,3925436,3925494,8624906,8615116,8615117,8615118,8615119,10941339,10941345,10941346,10941347,10941348,10941349,10941350,7070081,10840834,7070105,11035917,8626148,8626153,8626154,8626160,8626161,10841270,10841271,8626167,8626172,8626175,8612779,8612780,8612781,10993771,10993772,10993773,10993774,10993775,10993776,10993777,10993778,3233591,8554196,10618280,3234348,11046798,11046851,11046857,11046858,10617005,10852273,10617066,8611888,8541565,8611889,8541566,8541663,8541664,8541803,10852701,10928333,8612652,8542361,8632617,10990672,10990673,10990674,10990675,10990676,10850828,10848400,10991475,10991567,10991568,10952750,10992292,10992293,10992294,10992295,10992296,10992297,10992298,10992299,10992300,10992301,10992302,10992303,10992304,10992305,10992306,10992307,10992308,10992309,10992310,10992311,10992312,10992313,10992314,10992315,10992316,10992317,10992318,10992319,10992320,10992321,10992322,10992323,10992324,10992325,10992326,10992327,10992328,10992411,8541273,8541274,8541281,8541282,8541318,8541335,3654746,7019411,7019412,7019413,7019414,7019415,7019416,7019417,7019418,7019419,7019420,10611518,7019517,7019518,7019519,7019520,7019521,7019522,7019523,7019524,9214025,10122303,7019771,7019772,7019773,7019774,7019775,7019776,7019777,7019778,7019779,7019780,7019781,7019782,7019783,7019784,7019785,7019786,7019787,7019788,10609420,9171923,10120290,10120291,10120292,10609944,10609945,9172355,9212407,9196555,9196588,9196595,9196624,10613302,9188960,6677276,8567716,10610891,10121429,10125500,7014983,7014984,7014985,7014986,7014987,7014988,7014989,7014990,10515212,10515213,10515214,10515227,10515228,10515242,9169438,9185591,9209615,9193786,7056037,9177895,9177896,10126098,9186049,9186050,9186051,9186052,9186053,9186054,9194361,7024292,7024293,7024294,7024295,7024296,7024297,7024298,7024299,7024300,7024451,7024583,7024584,7024585,7024586,7024587,7024588,7024589,7024590,7024642,7024643,7024644,7024645,7024646,7024647,7024648,7024649,9171000,9171001,9176417,10416470,6672808,7054920,8865082,6666561,6666562,6666594,6666595,7020335,7020336,7020337,7020338,7020339,7020340,7020341,7020342,7020343,7020344,7020345,7020346,7020347,7020348,8854857,9160259,10627980,10627981,8593576,10903669,10903885,10903886,10903887,10903888,10903889,10903890,10903891,10174994,10170141,10170142,10170143,10170144,10170145,10170146,10170147,10170148,10170149,10170150,10170151,10170152,10170153,10170154,10170155,10170156,10170157,10170158,10170159,10170160,10170161,10170162,10170163,10170164,10170165,10170166,10170167,10170168,10170169,10170170,10170171,10170172,10170173,10170174,10170175,10170176,10170177,10170178,10170179,10170180,10170181,10170182,10170183,10170184,10170185,10170186,10170187,10170188,10170189,10170190,10170191,10170192,10170193,10170194,10170195,10170196,10170197,10170198,10170199,10170200,10170245,10170246,10170247,10170248,10170249,10170250,10170251,10170252,10170253,10170254,10170255,10170256,10170257,10170258,10170259,10170282,10170362,10170363,10170364,10170365,10170366,10170367,10170368,10170369,10170370,10170371,10170372,10170373,10170374,10170375,10170376,10170377,10170378,10170379,10170484,10170485,10170486,10170487,10170488,10170489,10170490,10170491,10170492,10170493,10170494,10170495,10170496,10170497,10170498,10170499,10170500,10170501,10170502,10170503,10170504,10170505,10170506,10170507,10170508,10170509,10170510,10170511,10170512,10170513,10170514,10170515,10170516,10170517,10170518,10170519,10170520,10170644,10170645,10170646,10170647,10170648,10170696,10884989,10172096,10172213,10172214,10172243,10626258,10626259,10162807,10162808,10162809,10162810,10162811,10162839,10586621,10602727,10590886,10590948,10590949,10590950,10590951,10590952,10590953,10590954,10590955,10590956,10590957,10590958,10590959,10590960,10590961,10590962,10590963,10590964,10590965,10590966,10590967,10590968,10590969,10590970,10590971,10590972,10651422,10651435,10586089,10586090,10601106,10601107,10601108,10523327,10533354,10533355,10533356,10533357,10533358,10533359,10533360,10533361,10533362,10533363,10533364,10533365,10533366,10533367,10533368,10531423,10531424,10531425,10531426,10531427,10531428,10531429,10531430,10551645,10523656,10523657,10533840,10530146,10530147,10532201,10532202,10532203,10532204,10532205,10522224,10532385,10530689,10530690,10530691,10528728,10528780,10528781,10528782,10542798,10542799,10542800,10532809,10532810,10532811,10528842,10528843,10528844,10538847,10528861,10528862,10528863,10540884,10538887,10550967,10550968,10531024,10531025,10506574,10506575,10506576,10508816,10508817,10508818,10508822,10422124,10480902) 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'