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(8574126,10873297,8561989,10861390,11001805,7068122,11001806,11001807,11001808,11001809,11001810,10458867,10458868,10458869,9215016,8631039,10950343,10874097,10950528,7065960,10862813,10862814,10862815,10862816,10862817,10862818,7066692,10850054,8609676,10847615,10951514,10847650,10847665,8067916,8573253,10929429,8561154,7075246,7067248,7067249,10987950,10987951,10987952,7067279,8837806,8837807,8837808,8837809,8837810,8837811,10447311,10447312,10447313,8573904,8573905,8573906,10988415,10861029,8573932,10866302,8065084,10103454,7201587,10866693,10973158,10858804,7072548,10973308,10999324,10960333,10103951,8559841,8618823,7202526,7073289,7073290,5654705,5654706,10844410,10974387,10859998,7200220,10942723,10865422,10865458,8617016,8617017,8617018,8617019,8617020,8617021,8617022,8617023,8617024,8617025,8617026,3927596,7200551,7200553,7200570,7200571,7200572,7200573,7200574,7200575,7200576,7200577,7200625,8558428,8558429,5999980,10969712,10969713,10969714,10969715,10969716,10969774,10969775,7069237,10970108,7198685,7198726,7198731,7198755,7198756,10970474,3926192,10970528,10970529,7199091,10970530,10970531,7199092,7199093,10970532,8072590,8072591,8072592,8072593,8072594,8072646,8072661,8072666,8072681,8072686,8072691,8072799,8072807,8072815,8072823,8072831,8072839,8072851,8072871,8072889,8072907,8072923,10840949,8072941,8072956,8072972,10841180,10971129,10971130,3236878,3236879,10971185,8557471,8557472,8557473,10958361,11049649,11049650,8557755,8557790,8557794,10942506,8557842,11032844,8613053,8613130,8613131,11033281,11033351,11033352,11033353,11033354,11033355,11033356,11033357,11033358,11033359,11033360,11033361,11033362,11033363,11033364,11033365,11033366,11033367,11033493,11033494,11033495,11033496,11033497,8555021,10838847,11033918,3234929,3234930,3234931,8555462,4938295,4938296,4938297,4938298,4938299,8555569,4938350,4938365,4938370,4938385,4938390,4938395,4938501,4938507,4938513,4938519,4938525,4938531,4938537,4938549,4938561,4938573,4938585,4938597,4938609,4938621,10616978,10836865,8541646,8611981,10622354,10622355,7155981,3922851,11006425,8553743,8553744,11006544,11006545,11006546,10850226,10850235,10850242,10850243,10920533,10850288,10920545,10920546,10850297,10850319,10850344,10850348,10951695,10850356,10460657,10460658,10460659,10460660,10460661,10920667,10920668,10460713,10920684,10920685,10460719,10920686,10460725,10460731,10460737,10460743,3230871,3230872,10426202,9218011,9218062,8577733,8552677,10852038,10616869,10927441,10927442,10614066,8567908,8567909,8567910,8567911,9165458,10562334,10559422,10559423,10559424,10559425,10559460,10559461,7019314,10614332,10614333,10122171,7019657,7019658,7019659,9198048,7019703,7019704,7019705,7019706,9174067,7019867,7019868,7019869,7019870,7019871,10614921,6666261,9913787,9914118,8851876,6676319,6676321,10612853,8852039,8862961,9915156,10610678,7018701,7018811,8853013,10125510,6673524,10117620,10117621,9911751,10117808,10117811,10117887,9169751,4974634,4974635,4974636,9209783,4974637,8849826,8849867,7023735,9178122,9186173,9186174,9186176,9186177,9186215,9186217,9210243,7023933,8551835,8551848,8850415,6674962,7024508,6675083,7024560,7024561,7024562,7024563,7024564,10512758,10512759,9913208,10119337,9913362,7024855,7024856,7024857,7024858,9208343,10416375,10416376,10416377,10416378,10416379,10416380,9176508,9910852,10419568,9176652,6680859,9176653,9176654,6680860,9176655,9168674,10418714,6673020,9184820,10418747,10117029,9911166,9177088,9193271,10416204,10416205,10117483,3962640,6666482,6666483,6666504,6666505,6666587,6666590,6666597,6666604,6666643,6666644,6666645,4971510,4971511,7020314,7020315,7020316,9198748,7020410,7020411,7020412,7020413,7020414,7020415,7020416,7020417,4971627,10469523,9198999,8550156,10463597,8550452,9167538,10115983,9207956,9207957,6668155,10164791,10164792,10164793,10164794,10164795,10164796,10164797,10164798,10164799,10164800,10908854,10908855,10164880,10164881,10164882,10888884,10159945,10175177,10175178,10894273,10165395,10165396,10894606,10170652,10170653,10894847,10894848,10894849,10165870,10165871,10165872,10879908,10879909,10165964,10165965,10165966,10165967,10165968,10910055,10156126,10156127,10166142,10166233,10166234,10166235,10168499,10168500,10168536,10168537,10168538,10168539,10168540,10168586,10168587,10168588,10168624,10168625,10168632,10168633,10168634,10168635,10168688,10882725,7000927,10168811,10887920,10888008,10888261,10174344,10885566,10895602,10166628,10885711,10625201,10166761,10171774,10166855,10166856,10885867,10166899,10166900,10181926,10181927,10181928,10181929,10181930,10181931,10181932,10181933,10181934,10181935,10181936,10181937,10181938,10181939,10181940,10181941,10181942,10166965,10177277,10167431,10167432,10167433,10167442,10167486,10876480,10167515,10167516,10167517,10167518,10167519,10167520,10168262,10168263,10168264,10168265,10168303,10168304,10168305,10168306,10168307,10168308,10168340,10168341,10168357,10168358,10168359,10168360,10168361,10168362,10168363,10168462,10168463,10168464,10168465,10168466,10586181,10586182,10649358,10652408,10649473,10605300,10605306,10602361,10602362,10583868,10583869,10583870,10598940,10584136,10599384,10599385,10647513,10590668,10590669,10590670,10590671,10644860,10651059,10651060,10651064,10651065,10651066,10651067,10651069,10606973,10567373,10567374,10604531,10604552,10604765,10521264,10525604,10529976,10529977,10546024,10546025,10546026,10546027,10546028,10522527,10522528,10522529,10550973,10550974,10550975,10550976,10550977,10550978,10550979,10550980,10550981,10550982,10550983,10550984,10550985,10550986,10550987,10550988,10550989,10550990,10550991,10550992,10550993,10523041,10529100,10424675,10423991,8562316,10413358,10407587,10407596,10407604,10407605,10407636,10407655,10407664,10407688,10407711,10407715,10407723,10485156,10485157,10478195,10478196,10408702,10478704,10478705,10478706,10478730,10478744,10478745,10478753,10478754) 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'