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(8630683,8630684,8630690,8630691,8630698,8630699,8630700,8630701,8630702,8630703,8620893,8630704,8630715,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630734,8630735,8630736,8630737,8630738,8630740,8630743,8630744,8630745,8630747,8630748,8630786,8630816,8630849,8630854,8630855,8630867,8630868,8630872,8630890,8630901,8630902,8630903,8630906,8630907,8630908,8630958,8630959,8630963,8630965,8630967,8630970,8630972,8630973,8630974,8630976,8630977,8630987,8630993,8630994,8630995,8630996,8630997,8630998,8630999,8631001,8631002,8631003,8631004,8631005,8631007,8631009,8631010,8631011,8631013,8631024,8631025,8631026,8631027,8631029,8631030,8631031,8631032,8631033,8631034,8631035,8631036,8631037,8631038,8631039,8631040,8631041,8631042,8631043,8631044,8631045,8631046,8631047,8631048,8631049,8631050,8631051,8631052,8631053,8631054,8631055,8631056,8631057,8631058,8631059,8631060,8631061,8838952,8838953,8838954,8621399,8569647,8569731,8569732,8621680,10963674,10963750,10847129,10847216,7074632,10847549,11001140,11001141,7075498,10447545,7067697,11001383,7075778,7075779,7075783,10930065,8620714,7067893,7067894,7067895,7067896,7067897,7067898,7067899,7067900,7067901,7067902,7067903,7072073,7201319,7072074,10103208,10103209,10103255,7201377,10842900,10842901,10842902,10103288,7072249,7072259,7072263,10103440,7201632,7201633,7201634,7201692,7201693,7201694,7201695,7201696,7201697,7072467,7201730,7201769,7201770,7201771,7201772,7201773,7201774,7201775,7201776,7201777,7201778,7201779,7201780,7201781,3899035,7201782,7201783,7201784,7201785,7201786,7201787,7201788,7201789,7201790,7201791,7201792,7201793,7201794,7201795,7201796,7201797,7201798,7201799,7201800,7201801,7201802,7201803,7201804,7201805,7201806,7201807,7201808,7201809,7201810,7201811,7201812,7201813,7201814,7201815,7201816,7201817,7201818,7201819,7201820,7201821,7201822,7201823,7201824,7201825,7201826,7201827,7201828,7201829,7201830,7201831,7201832,7201833,7201834,7201835,7201836,7201837,7201838,7201839,3899204,8911926,3899414,10960604,10960605,10960606,10843715,10843716,10843717,10843723,10843726,10843732,10843733,10843734,10843743,10843745,10104129,3899509,8618846,3899510,8836561,8836562,3899574,8836574,10999785,10999786,10999787,10999788,10999789,10999790,10999791,10999801,10999802,7202364,10999803,7202365,10999804,10999807,10999808,10999809,10999810,10999811,10999812,10999813,8836618,10999814,10999815,10999816,10999817,10999818,10999819,10999820,10999821,10999822,10999823,7202439,7202444,7202445,7202446,7202447,10999886,7202448,10999887,7202449,10999888,7202450,10999889,7202451,10999890,7202452,10999891,10999892,7202453,10999893,7202454,7202455,10999894,10999895,7202456,7202457,10999896,7202458,10999897,7202459,10999898,7202460,7202461,7202462,7202463,7202464,7202465,7202466,7202467,7202468,7202469,7202470,7202471,7202472,7202473,7202474,7202475,7202476,7202477,7202478,7202479,7202480,7202481,7202482,7202483,7202484,7202485,7202486,7202487,7202488,7202489,7202490,7202491,7202492,7202493,7202494,7202495,7202496,7202497,7202498,7202499,7202500,7202501,7202502,7202503,7202504,7202505,7202506,7202507,7202508,7202509,7202510,7202511,7202512,7202513,7202514,7202515,7202516,7202517,7202518,7202519,7202520,7202521,7202522,7202523,7202524,7202585,7202586,10104538,10104591,10844274,10844275,3237362,3237363,3237382,3237391,3237392,3237393,10102105,3237394,3237395,3237396,10102108,3237398,8616854,10997857,10997858,10997859,10997860,10997861,7200456,7200458,7200582,7200583,7200584,7200585,8910444,8910445,8910446,8910447,8910448,8910449,8910450,8910451,8910452,8910453,8910454,8910455,8910456,8910457,8910458,8910459,8910460,8910461,8910462,8910463,8910464,8910465,7200906,7200907,7200908,10842548,10100074,10100075,10100080,10100081,10100082,10944411,10944412,10839810,10839811,3655849,10944725,10944726,10944727,10944728,10944729,10944730,10944731,10944732,10944733,10944734,10944735,10944736,3655890,7198697,7198699,7198711,7198714,7198716,7198719,7198728,7198742,7198743,7198762,7198768,7198772,7069592,8615697,8615706,8615707,10996791,10996792,10996793,10996794,10101297,10101516,8616236,8616237,8616238,10101551,8616299,8616300,10101606,10101699,10101937,10101999,10102026,7196276,7196337,10618183,3233648,7196507,7196516,7196528,10838115,7196890,7196891,7196892,10968420,10968421,10968455,10968456,10968458,10968459,10968460,10968461,10968462,10968463,10968464,10838999,10839202,3234892,10619874,10619875,10839624,10427301,10427302,10427303,10427304,10427305,10427306,10427307,10427308,10427309,10427310,10966794,8541668,10617209,10622533,11045209,11045210,10617573,10954361,10617804,8576142,10847754,10847755,3230436,8570093,8570094,8570095,8570096,8570097,8570098,8570099,8570100,8570101,8570102,8570103,8570104,8570105,8570106,8570108,8570109,8570110,8570111,8570112,8570113,8570114,8570115,8570116,8570117,8570118,8570119,8570120,8570121,8570122,8570123,8570124,8570125,10615334,10951941,10615352,10615356,10848115,10848117,10615471,10615472,10952101,10952102,10952142,10926113,10926176,10615674,10926285,11043453,10965520,10965521,8540631,8540701,8541017,10616542,10616543,10616544,8541159,8611706,10616955,10565150,7059680,10614257,10614269,10565478,9189727,9189728,10565646,10565647,10614548,10562851,10611821,8542607,8542608,10119663,10612319,7058247,7058248,7058249,7058250,7058251,10613127,9212498,9188678,9188686,9172701,9172705,10558592,6677026,9173037,10610913,10610914,10117679,7055724,10515422,10515423,7055836,9161857,7056052,10513728,10513729,7056099,7056100,10513952,10513961,10513994,10513997,10513998,10513999,10514028,10514031,10514032,10514033,10512780,10516789,10516792,10516928,10515060,10515061,10515062,10515063,10515064,10515065,10515066,9176360,9176361,9176363,9176364,9176379,9176380,9176381,4973244,9192398,7054861,7054936,9209102,9209103,9193162,9193163,7055445,10122730,6666613,9166867,10123175,10123176,9191120,9191127,9191128,9191129,9191193,9191194,9207302,9207303,9191534,6667868,6667876,9208031,9208032,9192139,9192140,9192141,9192142,9192143,9192144,9192172,9192185,9192194,9192195,9192196,10632189,10627405,10627667,10627711,10627712,10627713,10627714,10627715,10627716,10627717,10627718,10627719,10627720,10627721,10627722,10627723,10627724,10627725,10627726,10627727,10627728,10627729,10627730,10627731,10627732,10627733,10627734,10627735,10627736,10627737,10627738,10627739,10627740,10627741,10627742,10627743,10627744,10627745,10627746,10627747,10627748,10627749,10627750,10627751,10627752,10627753,10627754,10627755,10627756,10627757,10627758,10627759,10627760,10627761,10627762,10627763,10627764,10627765,10627766,10627767,10627768,10627769,10627770,10627771,10949080,10631058,10631232,10631233,10187807,10631412,10631413,10631414,10631415,10631416,10631417,10631418,10631419,10631420,10631421,10631422,10631423,10631424,10631425,10631426,10631427,10631428,10631429,10631430,10631431,10631432,10631433,10631434,10631435,10631436,10631437,10631438,10631439,10631440,10631441,10631442,10631443,10631444,10631445,10631446,10631447,10631448,10631449,10631450,10631451,10631452,10631453,10631454,10631455,10631456,10626720,10598520,10584248,10584249,10584254,10584255,10584256,10584257,10584261,10584262,10584263,10584536,10584592,10582561,10582562,10582563,10582564,10582565,10582566,10582567,10582568,10582569,10582570,10582571,10582572,10582573,10588641,10545123,10545124,10545125,10545126,10521150,10545204,10545205,10527205,10527206,10541365,10541366,10545390,10545391,10541443,10541444,10541445,10541446,10541447,10541448,10521600,10521601,10521602,10521603,10521604,10521605,10521606,10527741,10542077,10522252,10542423,10542424,10542440,10542441,10542453,10522493,10542514,10542515,10542516,10542526,10542527,10542528,10542602,10542603,10542654,10542753,10542795,10520811,10520815,10520817,10526866,10422595,10422596,10422597,10422598,10424883,10424884,10424885,10424886,10407228,10407229,10407232,10486951,10486952,10486953,10486954,10495007,10495008,10495009,10495010,10495011,10495012,10495013,10495014,10495015,10495016,10495017,10495018,10495019,10495020,10497381,10497382,10497383,10497384,10497385,10497386,10497387,10497388,10497389,10497390,10497391,10497392,10497393,10497394,10497395,10497396,10497397,10497398,10497399,10497400,10497401,10497402,10497403,10497404,10497405,10497406,10497407,10497408,10495482,10495483,10495484,10495485,10495486,10495487,10495488,10495489,10495490,10495491,10495492,10495493,10495494,10495495,10495496,10495497,10495498,10495499,10487786) 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'