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(10962620,10962621,10962622,10962623,10962624,10962625,10962626,10962627,10962628,10962629,10962630,10962631,10962632,10962633,10962634,10962638,10962639,10962640,10962641,10962642,10962643,10962644,10962645,10939644,10943460,10962743,10963046,10963047,10963048,10963049,10963050,10963051,10963052,10963053,10963054,10963056,10963057,10963058,10963076,10963077,10963078,10963079,10963080,10963082,10963083,10963084,10963085,10963086,10963087,10963088,10963121,10963122,10963123,10963124,10963125,10963126,10963127,10963128,10963129,10963130,10963131,10963132,10963133,10963134,10963135,10963136,10963219,10963220,10963221,10963261,10963263,10963264,10963288,10963289,10963296,10963298,10963299,10963300,10963301,10963334,10963335,10963336,10963337,10963356,10963357,10963358,10963383,10963386,10963387,10963388,10963389,10963390,10963391,10963392,10963394,10963395,10963396,10963397,10963458,10963459,10963460,10963461,10963462,10963463,10963464,4971054,10963567,10963652,10963659,10963660,4968275,4968276,4968277,4968278,4968279,7074203,7074204,7074205,7074206,7074207,7074208,7066281,10437208,7074373,7066759,7066760,7066761,7066762,7066763,7066764,7066839,7066840,7066842,7066843,7066845,7066851,7066853,7066860,7066864,7066865,7066866,7066867,7066882,7066883,7066889,7066890,7066891,10938707,10938791,10961916,10961926,10961927,10938981,7075507,10962400,10962434,10962436,10962449,10962452,10962470,10939409,10962471,10962472,10962473,10962474,10962476,10962516,10962549,10962551,10962555,10962564,10962581,10962582,10962583,10962584,10962585,10962586,10962587,10962600,10962601,10962606,10962607,10962608,10962609,10962610,10962612,10962613,10962614,10962615,10962616,10962617,10962618,10962619,7072075,7072077,7072078,7072079,7072082,7072083,7072084,7072085,10931634,10931637,10931638,10931640,7064589,7064596,7064597,10960403,10932090,8065931,10932442,7073185,7065353,10942601,8064778,7071899,10940855,3655838,3655839,3655898,10944780,7069482,11047650,10941390,10941615,10941847,10941858,8073098,8073099,8073100,8073101,8073102,8073103,8073104,8073105,8073106,8073264,8073265,8073266,8073267,8073268,8073269,8073270,8073271,8073272,8073273,11048464,8073341,8073342,8073343,11048562,8073407,8073408,8073409,11048623,10958452,10958453,10618146,10618148,10618149,10618150,10618151,10618152,10618153,10618155,10618156,10618158,10618299,10618302,10618619,10618622,10618642,10618717,10618719,10618721,10618723,10618729,10618730,10618731,10618732,10618795,10618861,10618862,10618966,10618967,10618976,10618977,10618978,8070859,10624604,10624605,10922550,10922551,10922552,10922556,10922557,10922558,10922559,10922560,10922561,10922562,10922583,10922584,10622237,10622238,10622239,10622256,10617572,10954527,10954528,10954529,10954530,10954531,10954532,10954533,10954589,10954590,10954591,10954592,10954595,10954596,10954597,10954598,10954599,10614998,8570194,8570195,8570196,8570197,10615437,10615438,10930651,10616050,10616052,10953126,8862683,10610070,10610071,10610109,10610110,10610175,10610176,10610177,10610178,10610180,10610181,10610182,10610287,10610491,10610547,10610553,10564866,10564867,10564946,10564947,10564959,10565017,10565018,8863728,10515116,10517244,10517245,10517246,10517247,10517248,10517249,10517250,10517251,10517252,10517253,10517254,10517255,10517258,10517261,10517262,10517263,10517264,10517265,10517266,10517270,10517271,10517277,10517278,10515280,10515281,10515282,10517282,10517283,10517284,10517285,10517286,10517289,10517290,10517291,10517292,10517293,10517294,10517295,10517296,10517297,10517298,10517299,10517306,10517307,10517308,10515312,10517313,10515313,10517314,10517315,10517316,10517320,10517324,10517326,10515328,10515329,10515352,10515354,10515355,10515356,10515357,10515358,10515359,10515360,10515361,10515362,10515363,10515364,10515417,10515418,10515419,10515436,10515440,10515441,10515442,10515443,10515444,10515445,10515447,10515448,10515449,10515450,10515451,10515452,10515453,10515454,10515455,10515456,10515457,10515458,10515517,10515518,10515519,10517537,10517538,10517539,10517540,10515608,10517620,10517621,10517670,10513916,10513988,10514042,10514043,10514044,10514045,10514046,10514047,10514048,10514049,10514050,10514051,10514052,10514053,10514054,10514055,10514056,10514058,10514059,10514060,10514061,10514062,10514063,10514064,10514065,10514066,10514067,10514068,10514069,10514070,10514071,10514072,10514073,10514074,10514077,10514083,10514084,10514085,10514086,10514087,10514090,10514095,10514107,10514119,10514120,10514121,10514122,10514123,10514124,10514125,10514126,10514127,10514128,10514141,10514142,10514143,10514144,10514155,10516157,10514158,10514159,10516164,10514171,10516175,10516176,10516188,10514212,10514218,10514219,10514220,10514227,10514229,10514230,10514262,10514263,10514266,10514271,10514272,10514275,10514279,10514282,10514283,10514287,10514288,10514290,10514302,10514303,10514316,10514326,10514327,10514328,10514329,10514330,10514333,10514334,10514340,10514341,10514342,10514357,10514358,10514359,10514363,10514365,10514492,10516525,10512530,10514542,10514543,10514545,10514546,10514549,10514550,10514551,10514552,10514553,10514562,10514570,10514586,10514587,10514588,10514589,10514590,10514591,10514592,10514593,10514605,10514606,10514607,10514608,10514609,10514610,10514615,10514616,10514617,10514618,10514619,10514620,10514621,10514622,10514623,10514624,10514625,10514626,10514627,10514628,10514629,10514630,10514631,10514632,10514633,10514634,10514635,10514637,10514639,10514641,10514642,10514643,10514645,10514646,10514648,10514649,10514650,10514651,10514652,10514653,10514654,10514655,10516655,10514656,10516656,10514657,10516657,10514658,10516658,10514659,10516659,10514660,10516660,10514661,10516661,10514662,10516662,10514663,10514664,10516664,10514665,10516665,10516666,10514666,10514667,10516667,10514668,10516668,10514669,10516669,10514670,10516670,10514671,10516671,10514672,10516672,10516673,10516674,10516675,10516677,10516678,10516679,10516680,10516681,10516700,10516701,10516702,10516703,10516713,10514714,10516714,10516715,10516716,10516717,10516718,10516719,10516720,10516721,10516722,10516723,10516724,10516725,10516726,10516727,10516728,10516729,10516730,10516731,10516732,10516733,10516734,10514735,10516735,10516736,10514736,10514737,10516737,10514738,10516738,10516739,10516740,10516741,10516742,10516743,10516744,10516745,10516746,10516747,10516748,10516749,10516750,10516751,10516752,10516753,10516754,10516755,10516756,10516757,10514782,10514783,10516783,10514784,10516784,10514785,10516785,10514786,10516786,10514787,10516787,10514788,10514789,10514790,10514791,10514792,10514793,10514794,10514795,10514796,10514797,10514798,10514799,10516801,10514802,10516802,10514803,10516803,10514804,10516804,10514805,10514806,10516806,10514807,10514808,10514809,10516809,10514810,10516810,10514811,10514812,10514813,10514814,10514815,10514819,10514820,10514821,10514822,10514823,10514824,10514825,10514827,10514828,10514829,10514830,10514831,10514832,10514833,10514834,10514835,10514836,10514837,10514838,10514839,10514840,10514841,10514842,10514843,10514844,10514845,10514846,10514847,10514848,10514849,10514850,10514851,10514852,10514853,10514854,10514855,10514856,10514857,10514858,10514859,10514860,10514861,10514862,10514863,10514864,10514865,10514866,10514867,10514868,10514869,10514870,10514871,10514872,10514873,10514874,10514875,10514876,10514877,10514878,10514879,10514880,10514881,10514882,10514883,10514884,10514885,10514886,10514887,10514888,10514889,10514890,10514891,10514892,10514893,10514894,10514895,10514896,10514897,10514898,10512903,10514905,10514906,10514907,10516908,10514908,10516909,10514909,10516910,10514910,10516911,10514911,10516912,10516913,10516914,10516915,10516916,10514918,10514919,10514920,10516928,10516929,10516930,10516931,10516932,10514932,10516933,10514933,10516934,10516935,10514935,10516936,10514936,10516937,10514937,10516938,10516939,10516940,10516941,10516942,10516943,10516944,10516945,10516946,10516947,10516948,10516949,10516950,10516951,10516952,10516955,10514975,10514977,10514978,10514981,10514985,10514986,10514987,10514988,10514989,10515006,10515007,10515008,10515009,10515010,10515024,10515025,10515026,10515027,10515028,10515029,10515030,10515031,10515032,10515033,10515034,10515035,10515036,10515037,10515038,10515039,10515040,10515041,10515042,10515068,10515069,10515076,10515077,10515078,10515079,10515080,10515081,10515085,10515086,10515103,10515105,10515106,10515107,10515108,10515109,10515110,10420150,10420151,10420152,10420154,10420155,10420156,10420159,10420164,10420165,10420166,10420169,10420170,10420171,10417171,10420173,10420174,10420177,10420182,10420184,10420190,10420191,10420195,10420196,10420198,10420200,10420202,10420203,10420205,10420208,10420209,10420212,10420215,10468063,10468064,10468065,10468066,10468067,10468068,10468069,10468070,10468071,10468072,10468073,10468074,10468075,4972506,10464561,10628177,10627334,10627337,10627342) 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'