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(8559354,7068121,10224430,10224431,10224432,7076250,7068357,7068358,8618931,8628899,8628900,8628901,8569704,8628905,8628906,8628907,7068759,8628955,10844123,7066124,7074192,10199502,10199503,10199504,7074268,8573024,10251597,10251598,8619808,10873296,10212751,10212752,10212804,10212809,10199809,10212810,8837682,8837683,8837799,8837800,8837801,8837802,8837803,8837804,8837805,8558310,8834903,7200824,7200825,7200826,8910826,8835373,10210627,10210628,8911112,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,7199077,7199078,7072554,7072555,10840853,10208889,10208918,3926607,10841153,10841154,10196188,10196189,3926972,10209376,10209377,10841424,8834237,8834239,3927526,8617002,8617003,8617004,8617005,8617006,8617007,8617008,8617009,8617010,8617011,8617012,8617013,8617014,8617015,10857509,8626950,7157897,10867648,7157928,7157929,7157939,8555415,7158055,3234933,8555461,7158058,7158059,10194244,10194245,10194256,8555511,4938349,4938364,4938369,10207356,8555594,4938384,4938389,4938394,4938500,4938506,4938512,4938518,4938524,4938530,4938536,4938548,4938560,4938572,4938584,4938596,4938608,10207596,4938620,8861293,10100070,10207663,10207664,3235444,7198347,3235616,10270396,10270397,10270398,10270399,10270400,10270401,10270402,10270403,10270404,10270405,10270406,10270407,10270408,10270409,10270410,10270411,10270412,10270413,10270414,10270415,10270416,10270417,10270418,10270419,10270420,10270421,10865999,10270422,10270423,10270424,10270425,10270426,10270427,8612731,10945027,7156713,10837942,3923590,8072645,8072660,8072665,7156895,8072680,8072685,8072690,8613265,8072798,8072806,8072814,8072822,10206211,10206212,8072830,8072838,8072850,8072870,8072888,10206273,10206274,10206275,8072906,8072922,10853889,8072940,8072955,8072971,3924179,3924380,3924385,3924387,10245757,10245758,10245762,10245878,10245879,10245880,10245881,10245882,10206994,10206995,10206996,8633198,3581932,10618277,10618279,10229393,10229394,3582140,10426252,10623570,3231486,10623814,10623815,10623816,10623817,10618863,3231726,10619022,10619023,10619024,10619025,10619026,10619027,10619028,7155072,8577730,8577731,8577732,10852068,8578077,10852222,8541472,7155823,7155824,7155825,10189084,10189192,10432114,10622304,10622351,10622352,10622353,10850053,9216483,8576050,3230298,10850225,10850234,10850271,10850272,10850296,10850305,10850308,10850311,10850312,10850318,10850333,10850342,10850343,10850347,10850355,10460712,10460718,10460724,10460730,10460736,10460742,3230681,10920532,10920541,10920542,10920543,10920544,10615055,10920658,10920659,10920660,10920661,10920662,10920663,10920664,10920665,10920666,8573901,8573902,8573903,8573931,10620401,10278808,10278809,10861395,10845866,10448031,10848677,8631037,8631038,8621581,10240478,10240479,10922117,10922118,10922119,8583690,10459819,8583720,10459820,10927438,10927439,10927440,7019177,9165550,6677785,10714100,6669843,10614317,9189742,6669952,9173939,6665992,7019651,7019652,7019653,7019654,7019655,7019656,7019859,7019860,7019861,7019862,7019863,7019864,7019865,7019866,6666238,9190269,9190270,6678490,9203347,6675639,9913786,8851548,6675940,9914068,6676123,6676124,8067654,6676320,10120322,10120326,10120328,10120329,10120341,10120342,10120348,10120350,10120351,10120352,8862834,8862950,8862951,9180435,7058743,3653848,10613360,10613404,9915031,10121051,7018810,7018930,7018931,7018932,9177304,9177309,9177316,9177320,10125582,9169398,8065095,10513344,10513345,10513346,10513347,10513348,10513349,10513350,10513351,10513352,10513353,10513354,10513355,10513356,10513357,10513358,10513359,10513360,10513361,10513362,10513363,10513364,10513365,10513366,10513367,10513368,10513369,10513370,10513371,10513372,9193598,9169677,9185679,9185689,9185690,9185691,9185692,4974633,10515597,10515598,8849823,8849824,8849825,7023734,7056389,7056393,7056396,7056400,7023932,7056455,7056456,7056458,7056459,7056460,9178367,10514444,10514445,6674956,6674957,6674960,6674961,6674962,9912966,9913045,7016517,7016518,7016519,7016520,7016521,7016522,7016523,6675075,7016524,6675076,7024558,7024559,9913207,9913210,9913322,8552449,6675405,6675406,6675407,6675408,6675409,6675410,6675411,6675412,6675413,6675414,6675415,6675416,6675417,6675418,6675419,6675420,6675421,8918057,9192473,10116695,10116723,10116724,10116728,10116730,7014248,7014249,9176651,6680858,7014318,7014319,9176666,9176736,10428238,9911270,9177208,6670688,6670689,6670690,7020306,7020307,7020308,7020309,7020310,4971509,7020311,7020312,7020313,9198747,6678961,4971625,4971626,8550162,10465753,8550411,9175281,8550468,8550485,9183567,9207640,9199685,10468360,10115982,10115992,9207954,9207955,9175957,9200016,9184266,10628016,10628017,10628112,10628113,10628114,10628246,10628247,10164784,10164785,10164786,10164787,10164788,10164789,10164790,10908852,10908853,10164879,10174897,10174898,10174899,10174900,10174901,10174902,10883947,10883948,10893996,10884059,10628828,10170383,10165393,10165394,10884487,10894530,10894531,10894687,10894756,10165859,10165860,10165861,10165862,10165863,10165864,10165865,10165866,10165867,10165868,10165869,10894861,10894862,10894863,10879870,10879885,10879907,10165961,10165962,10165963,10885029,10900059,10171300,10910291,10885297,7000926,10627281,10627282,10168967,10168968,10168969,10168970,10888004,10888007,10888294,10176584,10895620,10625169,10625181,10625187,10625189,10625193,10166844,10166853,10166854,10166898,10166909,10181920,10181921,10181922,10181923,10181924,10181925,10181984,10172232,10167269,10177276,10876588,10167630,10896621,10896622,10896645,10896646,10896647,10891680,10891681,10177931,10896953,10896962,10626876,10626877,10626890,10626891,10902401,10897469,10649472,10643546,10589618,10589619,10589620,10589621,10589622,10589623,10589894,10589895,10603219,10603222,10569444,10569445,10603586,10606746,10606823,10654045,10609842,10651056,10651058,10606923,10606927,10610012,10648718,10601527,10567717,10537475,10546062,10530276,10546489,10546490,10546496,10550935,10550936,10550937,10550938,10550939,10550940,10550941,10550942,10550943,10550944,10550945,10550946,10550947,10550948,10550949,10550950,10550951,10550952,10550953,10550954,10550955,10550956,10550957,10550958,10550959,10550960,10550961,10550962,10550963,10550964,10550965,10550966,10550967,10550968,10550969,10550970,10550971,10550972,10415340,10509290,10498316,10508339,10505583,10507775,10507842,10507843,10407488,10407586,10407595,10407603,10407635,10407654,10407663,10407674,10407677,10407680,10407681,10407687,10407701,10407710,10407714,10407722,10483520,10481654,10481655,10481656,10481657,10481658,10481659,10412193,10493089,10485152,10485154,10476296,10476297,10489440,10489441,10489442,10489443,10406942,10478726,10478728,10478729,10478752) 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'