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(8630660,8630911,8630915,10939905,8631051,8631064,8631092,8631094,8631095,8631096,8631098,8631099,8631100,8631119,8631122,3228956,3228960,8631277,8631304,8631305,8631306,8631307,8631308,8631309,8631316,8631317,8631318,8631319,8631320,8631321,8631328,8631329,8631330,8631331,8631332,8631333,8631334,8631335,8631336,8631337,8631338,8631339,8631340,8631341,8631342,8631343,8631344,8631345,8631471,8631480,8631481,8631482,8583329,8631510,3229285,8631526,8631535,8631585,8575150,8631624,8583487,8583488,10950669,8631919,7066276,10950963,8632190,8632272,10951366,8609602,8576045,8629679,8629716,8629717,8629810,10844946,8629866,8629869,8629870,8629871,8629873,8629874,8629884,8629886,8629888,8629892,8629894,8629896,8629899,3227669,3227670,8629900,8629901,8629902,8629903,8629906,8629909,8629910,8629911,8629913,7067271,8629918,8629920,8629935,8629936,8629937,8629938,8629941,8629942,8629943,8629945,8629946,8629948,8629951,8629960,8629961,8630035,8630038,8630040,8630042,8630045,8630046,8630056,8630058,8630063,8630064,8630073,8630075,8630077,8630079,8630080,8630082,8630083,8630086,8630087,8630088,8630092,8630094,8630097,8630099,8630102,8630113,8630178,8630179,8630199,8630318,8630328,8630332,8630333,11001373,11001374,8630338,8630350,8630351,8630353,8630356,8630359,8630364,8630365,8630368,8630369,8630374,8630384,10962455,7075912,7201454,8835895,10960403,10960417,10103986,3899586,7202367,7202445,7202446,5654538,10999913,10999914,10999915,7202524,10999974,10999975,5654676,5654777,5654778,10928881,3227260,3227261,8837358,7200763,8835027,10985228,10985229,10985230,8910650,8835315,6000194,7201157,6000195,7201159,10103045,10944385,7198380,10995822,7198678,7198679,8908518,7198722,7198737,7198738,7198742,7198748,7198750,7198772,11035922,8616224,8616225,11048460,11048653,10101891,10984534,10984535,10984536,10984544,10984545,10984546,10984547,10984548,10984549,10984550,10984551,10984552,10984553,10984554,10984555,11010576,10984592,10984593,10984594,10984595,10984596,3233400,3233401,3233402,3233417,3233427,3233430,3233431,8612932,10967800,10967801,10967802,7196376,11045973,11045990,11046090,10955218,10968422,8613574,11046615,11046616,3234357,3234361,3234362,3234363,3234366,3234367,3234368,3234372,10838820,10619193,10619229,11046901,10838982,8907294,8907295,8907296,3234665,3234666,3234680,11046955,11046961,11046962,11046996,11046997,3234731,3234740,11047009,10619352,10619353,11047027,11047040,11047041,8907461,8907462,7197666,8907481,7197697,7197735,7197738,7197740,7197741,3234935,3234936,3234937,3234938,7197773,7197774,7197775,7197776,3234959,3234966,8907616,11047253,11047269,8907682,8907708,7197899,7197900,7197901,7197902,7197903,7197904,7197905,8907881,10619898,10619899,3232390,3232391,3232392,3232393,3232394,3232395,10966670,10966671,10966672,8541521,8541574,8541575,11044791,11044797,11044798,11044799,8905213,8541669,8905215,8541714,11044920,10622264,10622265,10622266,10622267,10622268,10617340,10617347,10617348,10617356,10617357,10617358,10617359,10617360,10617361,10617363,10617364,10617365,10617369,10617375,10617376,11045038,10617385,10617386,10617387,10617388,10617389,10617393,10617394,10617395,10617396,10617397,10617398,10617403,10617404,10617405,10617418,10617419,10617420,10617421,10617422,10617427,10617431,11045090,10617434,10617435,10617438,10954113,10954114,8612469,10993372,8609834,10425388,10425391,10425551,10425578,11042899,10425580,10425583,10425584,11042923,11042924,11042925,11042926,11042927,11042928,10848001,10848002,10848003,11042938,10620301,10620303,3230772,3230773,11043197,11043198,11043199,11043200,10930733,10930737,10615822,8540377,8540378,10615896,8540449,10991657,10616006,8540588,8904222,8904403,3231766,3231808,3231809,3231810,3231811,10616426,8611260,3231852,3231853,3231854,3231855,3231856,3231857,3231858,3231859,3231894,3231895,3231896,3231897,3231898,3231899,3231945,3231946,3231947,3231971,3231972,3231973,3232011,3232014,3232015,10922133,3232016,10922134,3232017,3232018,3232019,3232020,3232021,3232022,3232027,3232028,3232041,3232042,8611460,3232067,3232074,3232075,3232171,3232177,3232196,3232197,3232199,3232238,3232241,3232283,3232287,3232290,3232299,3232300,3232301,3232310,3232314,3232315,3232325,3232327,10562118,10562119,10562120,10562121,10562122,10562123,10610999,7019059,7019060,10565220,7019061,7019062,7019063,7019064,7019065,7019066,7019067,7019068,7019069,7019070,7019071,7019072,7019073,7019093,7019094,7019095,7019096,7019097,7019098,7019099,7019100,7019101,7019102,7019103,7019104,7019105,7019106,7019107,7019108,7019109,7019110,7019111,10611396,10611428,9181888,9181889,9181890,9181898,9181899,9173984,9173985,9173986,9173987,10611782,6666210,6666211,6666212,6666213,6666214,6666215,10611909,10611910,10611912,10611914,10611915,10611919,10611920,10611921,10611922,10611925,10611926,10611927,10611929,10611930,10611936,10611937,10611939,10611941,10612022,10612064,10612086,10119699,10119700,10119701,9211553,9211555,9211562,10612381,7017673,7017674,7017675,7017676,10557971,10557972,10612942,10612959,9212312,9212313,10609986,9196362,10613089,9172491,10610312,9204757,9172891,10613737,10613738,6673534,10117529,9209426,9209427,9161492,9185608,10117817,9185626,9209628,9185757,10125966,9185850,7056039,9169945,9209949,10126159,9186049,9186050,6674307,6674328,9162145,9162146,9162147,9162148,10118451,10118606,10118607,9178492,9186782,9178825,9178826,8552227,9171078,9171080,10516930,10516934,10516935,10119373,10416255,10416256,9160334,9168366,9168367,9168394,10416364,10416365,10416366,6672784,6672830,6672885,9168710,10418676,10419676,10419679,10419681,10419682,10419688,10418689,10419694,9168774,10419707,10418708,10419719,10419720,10419722,10419723,10419724,7014456,10419725,7014457,10419726,10419727,10419728,10419729,10419730,10419731,10419732,10419733,6673017,10419734,10419736,10419737,10419738,10419739,10419740,10419741,10419742,10419743,10419744,10419745,10418806,10417811,10417816,6673105,10417834,10417852,10417870,6673159,10417887,6673174,10419891,10419895,10419896,10419899,10419904,10419905,10417905,10419907,6673196,10417921,10417925,10417930,10417934,10417938,9209072,9209073,6673293,6673301,10420017,6673304,10420036,10420046,10417053,10420053,10417054,10417055,10420055,10420056,10417079,10417096,10417097,10417098,10417099,10417100,10418147,10418150,10417152,10417153,9161295,10463004,6670729,10122731,10122832,10122833,8549890,8916426,10463399,7020736,7020737,7020738,7020739,7020740,7020741,7020742,7020743,7020744,7020745,7020746,8550266,10463762,10465766,10465769,9207302,10465909,8917096,10466308,10462403,10462407,10462426,9175853,9192026,9192065,9192122,9192123,9192124,9192125,9192126,9192127,9192131,9192209,9192216,10466848,9160272,10883587,10883594,10883624,10883625,10883626,10883659,10883664,10893736,10893737,10893738,10893739,10893756,10884086,10884087,10894377,10894380,10884466,10889776,10884793,10155853,10890134,10890140,10890152,10890157,10890158,10887483,10163532,10163533,10163534,10632040,10632047,10632048,10632049,10632050,10883042,10883045,10888362,10886069,10891309,10626124,10891910,10631455,10631456,10882141,10887226,10892437,10568112,10568113,10568114,10568115,10601338,10601339,10601340,10601341,10601342,10590275,10590279,10590280,10590309,10599386,10590484,10590485,10590486,10590487,10590488,10590489,10590490,10590491,10648494,10582569,10588642,10588643,10588644,10588645,10588646,10588647,10588648,10588649,10588650,10588651,10588652,10588653,10588654,10591922,10568110,10568111,10539113,10539114,10539115,10539120,10541444,10539805,10539806,10539809,10521871,10521872,10530125,10528185,10528186,10528187,10528188,10528189,10528190,10528191,10522309,10522310,10522311,10522312,10522313,10522314,10522315,10522316,10522317,10538343,10538344,10522404,10522459,10522460,10522461,10522466,10522467,10522468,10544522,10524777,10520901,10520904,10520905,10520909,10539065,10539066,10539088,10539089,10539090,10539091,10539092,10539093,10539109,10425325,10425332,10422374,10422378,10422380,10421401,10422403,10421403,10422404,10422405,10421406,10421408,10422526,10422527,10422529,10422536,10422537,10422543,10422585,10422595,10422596,10422599,10420753,10421757,10421758,10421759,10421760,10421761,10421762,10422817,10422820,10498744,10424883,10424885,10424887,10424889,10423919,10423920,10423922,10422993,10423006,10425029,10425083,10425084,10422218,10407235,10407328,10407332,10407347,10407349,10407583,10407778,10407782,10486561,10407926,10407944,10407958,10408192,10408193,10478007,10478023,10478033,10497037,10493253,10493254,10408751,10476457,10406872,10406874,10406876,10406878,10406986) 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'