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(4970738,8569474,3229206,8583523,8583524,8583525,10950747,10950748,7066265,3230230,8573335,8573336,8573337,7201071,7201200,7201201,7201253,7201319,7201354,7201368,7201631,7201844,7201901,7201905,7201906,8911755,7201959,7201976,7201977,10960474,7202127,7202132,7202133,7202136,7202161,7202165,7202168,7202171,7202196,7202205,7202209,7202210,7202211,7202212,7202213,7202214,7202257,7202285,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,7202439,5654606,5654620,5654621,5654670,7202585,5654683,7202597,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202695,7202696,7202697,7202698,9794589,9794594,3227094,3227207,3237391,3237392,8910056,8910100,8910106,7200507,7200508,7200509,8834762,8834763,7200548,7200607,7200608,8910444,7200778,7200779,7200780,8910600,8910601,8910602,8910603,7200817,7200901,10100083,8615017,7198678,7198679,7198680,7198681,7198683,7198684,7198685,7198688,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198709,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198727,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198757,7198759,7198760,7198762,7198763,7198764,7198765,7198766,7198769,7198770,7198772,7198784,7199135,8564678,7199449,10941948,7199480,7199881,7200030,10837649,8613064,7196523,11045965,7196526,7196528,11045975,11045977,11045983,7196890,7196891,7196892,8906900,7197239,10838801,10838965,10838966,10838967,10838968,10838969,10838970,10838971,10838972,10838973,10838974,10838975,10838976,10838977,10838978,10838979,10838980,10838981,10838982,10838983,10838984,10838985,10838986,10838987,10838988,10838989,10838990,10838991,10838992,10838993,10838994,10838995,3234730,8907461,8907462,8907463,8907464,8907465,7197843,7197846,7197849,7197850,10619875,3232382,10622266,10622267,11044807,11044808,11044809,11044810,11044811,11044812,11044813,10992856,10617332,8905260,10617377,10617384,10617403,10617404,10617405,10617409,10617417,10617422,10617423,10617428,10617429,10617430,10617431,10617432,10617433,10617434,10617435,10617438,10617442,10617443,10617445,10617451,10617452,10617453,10617512,3232913,3232914,3232915,3232917,8542165,8905717,8905718,8905719,8905720,8905721,8905735,8542251,8542252,8542253,8542254,10425390,10425393,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10425552,10425575,10615363,10425582,10848007,10615710,10615721,10615722,10426204,10616006,10616044,10616045,8540446,10426340,8540612,8540613,8540631,10616644,8611342,8611466,8611467,8904798,10616888,10616906,10610964,10610984,10610985,10610994,10614048,6669828,6669829,6669830,6669831,6669918,10614376,10611422,10611423,10611434,10611441,10611442,10611476,10611477,10614495,10614496,10614497,10614498,10611499,10614499,10614501,10614503,10614504,10614505,10611551,10611603,10611605,10611623,10611647,10611648,10611778,10611856,6666259,8549450,10609035,10609036,10612062,10612063,10612064,10609099,10609100,9187452,9187453,9211551,9211556,9211557,9211560,9211561,9211567,10609285,10612292,10612293,10612295,10609355,10609706,10612916,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,10612959,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,10609988,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,9172407,10613136,9172535,9172536,9172537,9172538,10613235,10613306,10613337,10610337,10613350,10613353,10613354,10613527,10613528,10613529,10613695,10613729,10613732,10613733,10613736,10613737,10613738,10613739,10613740,10613750,10610901,9169318,7055541,7055546,9169428,6673636,9169520,6673738,9169669,9169695,10117974,9169951,9169952,9169953,9169956,9169957,9169958,9169959,9169960,9169961,9169962,9169963,9169964,6674249,9170074,6674326,6674327,6674328,6674329,6674330,6674331,6674332,10514037,10514038,10118606,10118607,10118608,10118609,10118610,9186540,9186541,8552191,8552192,8552193,8552194,8552227,6672514,6672515,10416362,10416363,6672683,10419468,10419470,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,9168710,9168870,6673081,10418807,10418808,10418809,10418810,10417811,10418812,10417812,10418813,10418814,10417814,10417816,10418817,10417818,10417820,10418820,6673105,10418821,10417822,10418822,10418823,10417824,10418824,10418825,10417826,10418827,10417828,10417830,10418830,10418831,10418832,10417832,10418833,10417834,10418834,10418835,10418836,10418837,10417837,10418838,10417839,10418839,10418840,10418841,10417841,10418842,10418843,10417843,10418844,10418845,10417845,10418846,10418847,10417847,10418848,10418849,10417849,10418850,10417850,10418851,10418852,9168930,10417852,10418853,9168931,10418854,9168932,10417854,10417856,10418856,10417858,9168937,10418859,9168938,10417860,10418860,9168939,10418861,9168940,10417862,9168941,10418863,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,10417881,10417883,10417885,10417887,10417889,9168969,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,9169136,10471173,10469277,10469278,10467327,8550018,10467558,10469573,8550266,9167397,9167398,9167399,9167400,6671809,6671903,6671917,10468324,10468325,10468326,9167770,9167779,9167782,9167792,10468551,9168101,10470721,10470722,9168216,10883562,10888565,10888566,10883585,10883586,10883589,10883590,10883591,10883592,10883593,10883596,10883622,10883623,10883626,10883630,10883664,10889052,10894377,10889451,10884652,10884653,10889707,10884764,10889775,10889776,10889777,10874953,10874954,10885001,10885074,10890104,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890132,10890141,10890144,10890145,10890146,10890147,10890148,10890149,10890154,10890155,10890158,10890160,10890161,10890162,10890163,10890164,10890165,10890166,10890167,10890168,10890173,10890174,10890175,10880304,10880305,10880306,10880307,10885313,10880325,10880326,10885465,10885468,10885469,10887483,10887484,10887485,10887486,10631994,10632010,10632011,10632012,10632013,10632018,7000826,7000845,10882675,10627405,10883044,10883143,10883393,10630039,10885733,10885852,10885853,10885854,10885855,10885856,10885956,10885957,10885958,10885959,10162052,10886057,10886058,10886059,10886060,10886062,10886063,10162113,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,10882007,10882008,10882009,10882010,10887022,10887023,10887024,10882132,10882133,10882134,10882135,10882149,10882150,10882151,10882152,10882153,10882154,10877181,10887241,10887242,10887243,10887247,10882284,10882356,10882357,10882358,10882396,10887460,10887461,10887464,10887465,10601338,10601339,10601340,10601341,10601342,10590270,10590276,10590285,10590286,10590287,10590288,10590289,10590299,10590300,10590301,10590302,10590303,10590304,10590305,10590306,10590310,10590311,10647527,10647535,10647649,10647650,10647703,10541444,10541446,10541447,10541448,10521871,10521872,10521873,10532142,10532143,10532144,10532145,10532146,10532147,10532148,10532149,10532150,10532151,10532152,10532153,10532154,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10421498,10421505,10421538,10421540,10420717,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10498758,10506819,10506824,10424940,10424941,10424965,10424966,10424967,10425050,10425051,10425052,10425053,10425054,10425055,10425056,10425057,10407369) 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'