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(10211123,10211176,10211177,10211178,10211185,10211186,10211187,10211188,10211315,10211316,10211317,10211318,10211319,10211320,10211321,10211322,10211323,10211324,10211325,10211326,10211327,7068159,7068161,7068162,7068163,7068228,7068239,7068240,7068242,10211484,10211485,10211486,10211487,10211488,10211489,10211490,10211491,10211492,10211493,10211494,10211495,10211496,10211497,10211498,10211499,10211500,7068262,10211501,10211502,10211503,10211504,10211505,10211506,10211507,10211508,10211509,10211510,10211511,10211512,10211513,10211514,10211515,10211516,10211517,7068279,7068280,10211518,10211519,7068282,10211520,10211521,10211522,10211523,10211524,10211525,10211526,10211527,10211528,10211529,10211530,10211531,7068293,10211532,7068294,10211533,7068295,7068296,10211534,10211535,7068297,7068298,10211536,7068299,7068300,7068301,7068302,7068303,7068304,7068305,7068306,7068307,7068308,7068309,7068310,7068311,7068312,7068313,7068314,7068315,7068316,7068317,7068318,7068319,7068320,7068321,7068322,7068323,7068324,7068325,7068330,7068331,7068334,7068336,7068337,7068338,7068339,7068340,7068341,7068342,7068365,7068366,10211605,10211606,10211607,7068370,10211608,10211609,7068371,10211610,10211611,10211612,10211613,10211614,10211615,10211616,10211617,10211618,10211619,10211620,10211621,10211622,10211623,10211624,10211625,10211626,10211627,10211628,10211629,10211630,10211631,10211632,10211633,10211634,10211635,10211636,10211637,10211638,10211639,10211640,10211641,10211642,10211643,10211644,10211645,10211646,10211647,10211648,10211649,10211650,10211651,10211652,10211653,10211654,10211655,10211656,10211657,10211658,10211659,10211660,10211661,10211662,10211663,10211664,10211665,10211666,10211667,10211668,10211669,10211670,10211671,10211672,10211673,10211674,10211675,10211676,10211677,10211678,10211679,10211680,10211681,10211682,10211683,10211684,10211685,10211686,10211687,10211688,10211689,10211690,10211691,10211692,10211693,10211694,10211695,10211696,10211697,10211698,10211699,10211700,10211701,10211702,10211703,10211704,10211705,10211706,10211707,10211708,10211709,10211710,10211711,10211712,10211713,10211714,10211715,10211716,10211717,10211718,10211719,10211720,10211721,10211722,10211723,10211724,10211725,10211726,10211727,10211728,10211729,10211730,10211731,10211732,10211733,10211734,10211735,10211736,10211737,10211738,10211739,10211740,10211741,10211742,10211743,10211744,10211745,10211746,10211747,10211748,10211749,10211750,10211751,10211752,10211753,10211754,10211755,10211756,10211757,10211758,10211759,10211760,10211761,10211762,10211763,10211764,10211765,10211766,10211767,10211768,10211769,10211770,10211771,10211772,10211773,10211774,10211775,10211776,10211777,10211778,10211779,10211780,10211781,10211782,10211783,10211784,10211785,10211786,10211787,10211788,10211789,10211790,10211791,10211792,10211793,10211794,10211795,10211796,10211797,10211798,10211799,10211800,10211801,10211802,10211803,10211804,10211805,10211806,10211807,10211808,10211809,10211810,10211811,10211812,10211813,10211814,10211815,10211816,10211817,10211818,10211819,10211820,10211821,10211822,10211823,10211824,10211825,10211826,10211827,10211828,10211829,10211830,10211831,10211832,10211833,10211834,10211835,10211836,10211837,10211838,10211839,10211840,10211841,10211842,10211843,10211844,10211845,10211846,10211847,10211848,10211849,10211850,10211868,10211890,10211900,10211901,10211902,10211903,10211904,10211905,10211906,10211907,10211908,10211909,10211916,10211917,10211918,10211919,10211920,10211921,10211922,10211923,10211924,10211925,10211926,10211927,10211928,10211929,10211930,10211931,10211932,10211933,10211934,10211935,10211936,10211937,10211938,10211939,10211940,10211941,10211942,10211943,10211944,10211945,10211946,10211947,10211948,10211949,10211950,10211951,10211952,10211953,10211954,10211955,10211956,10211957,10211958,10211959,10211965,8569758,10212022,10212023,10212024,10212106,7065878,10212225,10212242,10212243,10212244,10212245,10212246,10212247,10212248,10212249,10212250,10212251,10212252,10212253,10212254,10212255,10212256,10212257,10212258,10212259,10212260,10212261,10212262,10212263,10212264,10212265,10212275,10212276,10212277,10212278,10212279,10212280,10212281,10212308,10212451,10212452,10212453,10212454,10212455,10212456,10437409,10212730,10212731,10212732,10212733,10212734,10212735,10212736,10212737,10212738,10212739,10212740,10212785,10212786,10212787,10212802,10212805,7066575,7066576,10212827,10212828,10212829,10212830,7074596,7074635,7074639,7074668,7074695,7074700,7074704,7074723,7074800,7074801,7074811,10210189,10210190,10210191,10210192,10210193,10210194,10210195,10210196,10210197,10210198,10210199,10210200,10210201,10210202,10210203,10210204,10210205,10210206,10210207,10210208,10210209,10210210,10210211,10210212,7074974,10210213,10210214,10210215,10210216,10210217,10210218,10210219,10210220,10210221,10210222,10210223,10210224,10210225,10210226,10210227,10210228,10210229,10210230,10210231,10210232,10210233,10210234,10210235,10210236,10210237,10210238,10210239,10210240,10210241,10210242,10210243,10210244,10210245,7075024,10210455,10210456,10210457,10210458,10210459,10210460,10210461,10210462,10210463,10210464,10210465,10210466,10210467,10210468,10210469,10210470,10210471,10210472,10210473,10210474,10210475,10210476,10210477,10210478,10210479,10210480,10210481,10210482,10210483,10210484,10210485,10210486,8835410,8835411,8835412,8835413,8835415,8835420,8835421,8835423,7067673,10210941,10210942,10210943,10210944,10210945,10210946,10210947,10210948,10247097,10247098,7072311,10196026,10196027,10196028,10196029,10196030,10196031,10196032,10196033,10196034,10196035,10196036,10932343,8565309,7073231,7065352,10933075,7065676,7065677,7065678,7065679,7065680,7065681,7065682,7065683,7065684,7065685,7065686,7065687,7065688,7065689,7065690,10235940,8834801,10246989,10246990,10246991,10246992,10246993,10246994,10246995,10270618,10270619,7069402,7069403,7069404,8072427,10941809,10232776,10284800,10284841,10284855,8860631,8860632,10229920,10282683,10226552,10226553,10226554,10226555,10226556,10226557,10226558,10226559,10226560,10226561,10226562,10226563,10226564,10226565,10226566,10226567,10226568,10226569,10226570,10226571,10226572,10226573,10226574,10226575,10226576,10226577,10226578,10226579,10226580,10226581,10226582,10226583,10226584,10226585,10226586,10226587,10226588,10226589,10226590,10226591,10226592,10226593,10226594,10226595,10226596,10226597,10226598,10226599,10226600,10226601,10226602,10226603,10226604,10226605,10226606,10226607,10226608,10226609,10226610,10226611,10226612,10226613,10226614,10226615,10226616,10226617,10226618,10226619,10226620,10226621,10239986,10239987,10239988,10239989,10239992,10616005,9189497,10614238,9189648,9189652,9189741,9189748,6666081,6666082,6666083,6666084,6666085,6666086,6666087,6666088,6666150,6666151,9195874,8862421,8862422,8862423,8862424,7058340,9188212,9188225,9188489,10558302,9188562,9188563,9196584,9188589,9196714,9196715,8863258,8863259,9204766,9196816,9189028,9197033,9189048,9189163,9189164,10558989,10558990,10558991,10558992,10558993,9189268,9189284,9189292,9177311,10513128,10513129,10513130,9177325,9177326,9177327,9177328,10513142,9177329,10513158,10513159,10513169,10513210,10513230,10513254,10513255,10513271,10513310,10513317,9185591,9193598,10513713,7056272,7056291,7056292,7056293,9186894,9186898,10513096,10513106,10513107,10513108,8918055,9168762,7054979,10419917,10419918,10419919,10419920,10419921,10419922,10419923,9177276,10420200,10420201,10420202,9177285,9177286,9177287,9177288,9177289,9177290,9177291,9182338,9182339,10467203,9167024,9167025,9167026,9167027,9167028,9167029,9167030,9167031,9167032,9167033,9167034,9167035,9167036,9167037,9167038,8916697,10470125,9176135,9184178,10161624,10161625,10167419,10167420,10167502,10167503,10167509,10167510,10167511,10167522,10167523,10167525,10167526,10167527,10167528,10167535,10167545,10167546,10167547,10167549,10167550,10167551,10167552,10167554,10626205,10583862,10583873,10583874,10584558,10584560,10585895,10525142,10525143,10525144,10525145,10525146,10523148,10523149,10523150,10523151,10523152,10523153,10527179,10527180,10527181,10523183,10523184,10523185,10523186,10527188,10523196,10523197,10523198,10523199,10523200,10523201,10523202,10523203,10523204,10523205,10523206,10523207,10523208,10523209,10523210,10523211,10523212,10523213,10523217,10523218,10523219,10523220,10523221,10523222,10523224,10523235,10523236,10523256,10523257,10523258,10523259,10523260,10523261,10523262,10523263,10523264,10523265,10523266,10530139,10528149,10532404,10530751,10523067,10533102,10533106,10422028,10422047,10422090,10477813,10478696,10478697,10478702,10478707,10478708,10478709,10478710,10478711,10478717,10478718,10478722,10478736,10478752,10478753,10478754,10478757,10478758,10478759,10478760) 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'