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(4970685,3229008,3229130,3229131,3229285,8583524,8583525,10950747,10950748,7066178,10963878,8575581,8575582,8575583,8575584,8575733,8575734,8575735,3230230,10844713,8067942,10930095,7201309,7201366,7201432,7201624,7201727,7201728,7201729,7201730,7201775,7201776,7201777,7201778,7201779,7201780,7201781,7201782,10960305,7201905,7201906,7201959,7201974,7201977,10960474,8065853,7202127,7202132,7202133,7202136,7202161,7202165,7202168,7202171,7202196,10843709,7202205,7202209,7202210,7202259,7202265,7202266,7202285,7202319,7202329,5654651,11000014,11000015,11000016,11000017,11000018,11000019,11000020,11000021,11000022,11000024,11000025,11000028,11000029,11000034,11000035,11000036,11000037,11000038,11000039,11000040,11000041,11000042,11000043,11000044,11000045,11000046,11000048,11000064,11000082,11000083,11000084,11000093,11000094,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,10844198,7202692,7202693,7202694,7202695,7202696,7202697,7202698,7065457,9794578,9794579,9794580,9794592,7202769,9794594,3237391,3237392,8834762,8834763,10959088,10985141,7200901,10102834,10102901,10100083,10944447,7198360,7198361,7198362,7198363,7198364,7198365,7198366,7198367,7198368,7198369,7198370,7198371,7198372,7198373,7198374,7198375,7198376,7198377,7198378,7198379,7198380,7198381,7198382,7198383,7198384,7198385,7198386,7198387,7198388,7198389,7198390,7198391,7198392,7198393,7198394,7198395,8908289,8908290,7198679,8615274,7198688,7198695,7198696,7198697,7198698,7198702,7198703,8908517,7198710,7198711,7198712,7198714,7198716,7198719,7198721,7198722,7198723,7198726,7198731,7198736,7198744,7198745,7198747,7198760,7198764,11009407,11009408,11009409,11009410,11009411,7199158,7199471,7199508,10101534,7199844,7200030,7200091,7200094,7200111,7200115,7200120,7200127,7200128,7200129,7196291,7196524,7196525,7196533,11007196,11007197,8906888,10838801,10838834,3234552,3234553,3234660,3234661,3234662,3234663,3234664,8907434,8907435,8907461,8907462,8907463,8907464,8907465,3234860,3235053,10619864,10619865,10619866,10619885,10619886,10619889,3232382,8541668,10617333,10617334,10617335,10617340,10617344,10954002,10954003,10954004,10617349,10617350,10617351,10617352,10617353,10617355,10617361,10617363,10617364,10617365,10617367,10617368,10617369,10617370,10617372,10617373,10617374,10617375,10617376,10617377,10617380,10617381,10617382,10617384,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617401,10617404,10617405,10617407,10617408,10617409,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617424,10617425,10617428,10617429,10617432,10617433,10617435,10617437,10617439,10617440,10617441,10617442,10617443,10617444,10617445,10617446,10617447,10617451,10617453,3232910,3232913,3232914,3232915,8905662,8905663,8542254,10951651,10951652,10951653,10951654,10620117,10620118,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10951828,10847971,10615363,10615389,10425911,10425937,10615710,10426193,10615896,8540418,10426338,10426339,10426340,10616044,10616045,8540543,8540612,8540613,8540631,8540633,8611342,8611390,10616644,8904798,10616888,10610966,10610967,10610969,10610971,10610975,10610976,10610977,10610978,10610980,10610982,10610984,10610985,10610996,10614048,10565319,10614203,6669828,7059861,10614376,10611423,10611441,10614495,10614496,10614499,10614501,10614503,10614504,10614505,10559744,10611603,10611804,10611856,9214215,9214216,6666259,10612104,10612105,10612106,10612107,10612191,10612192,10612194,10612201,10612268,10609285,10612294,10609313,10612320,10612321,10609369,10612909,10612916,10612931,10612935,10612936,10612937,10612938,10612939,10612940,10612941,10612942,10612943,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,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,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10613127,10613144,10613337,10613350,10613369,10613391,10613392,10613393,10558592,10558596,10610480,10610481,10613513,10613514,10613515,10613524,10613525,10613750,10613760,10610901,6677466,6677467,6677468,10610958,6673506,9169318,6673552,6673563,7055541,7055546,9169428,10515280,10515281,10515282,6673685,6673686,6673687,6673688,6673689,6673690,10117682,6673692,10117683,6673693,10117684,6673694,6673695,6673696,6673697,6673698,6673699,6673700,6673738,9169586,10117792,10515423,9169638,10117974,10515609,10515610,10515611,10515612,10515613,10118016,10517681,9169936,9169944,9169945,9169946,9169948,9169953,9169954,9169955,9169964,9169965,6674175,10118171,6674249,6674256,6674276,6674278,6674280,6674281,6674308,6674309,6674310,6674311,6674312,6674313,6674326,6674327,6674328,6674329,6674330,6674331,10118391,10118392,10514037,10514038,10514090,10514091,10514092,10514093,10516142,10516160,10516161,10516162,10516163,10516171,10516172,10516173,10516174,10516175,10516176,10118606,10118607,10118676,10514364,10514388,10514389,10514390,10514402,10514405,10514406,10514407,10514410,10512530,8552226,8552227,10512852,10514964,10514965,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,6672521,9192336,9192346,10419306,6672592,10415325,10415342,10419349,10419350,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10419370,9168453,10417424,6672725,10419470,10419497,9168669,6672896,6672897,6672898,6672899,6672900,6672901,9168709,9168710,10417633,9168817,6673064,6673082,6673085,6673086,6673087,6673088,6673089,10418807,10418808,10418809,10418810,10418812,10418813,10418814,10418817,10418820,10418821,10418822,10418823,10418824,10418825,10418827,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,6673122,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418856,10418859,10418860,10418861,10418863,9169071,10117317,9169275,10471171,10469245,10123006,8550036,8550037,8550038,10469573,8550263,8916794,9167779,10468551,9168103,6668177,10888487,10888552,10888553,10889019,10889020,10889021,10889052,10884075,10884078,10884080,10884081,10884082,10884083,10884084,10884085,10884088,10884089,10884094,10884097,10889775,10884799,10884800,10890104,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890127,10890128,10890129,10890130,10890131,10890132,10890134,10890141,10890143,10890144,10890145,10890146,10890147,10890149,10890150,10890151,10890156,10890157,10890158,10890159,10890160,10890161,10890162,10890163,10885167,10890173,10890174,10890175,10880207,10880208,10880209,10885212,10885213,10885313,10885347,10885348,10885349,10885350,10885465,10885468,10885469,10887486,10632014,10627319,10627321,10883403,10161705,10161868,10886058,10886059,10886060,10162249,10886250,10626143,10626144,10626145,10886878,10886910,10886918,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,10167992,10887052,10887171,10626724,10626725,10882284,10882359,10887460,10887461,10887464,10887465,10583441,10598535,10598867,10590278,10590279,10590280,10590308,10590309,10590310,10590311,10644383,10590996,10582561,10588641,10525323,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529385,10529386,10529387,10529388,10529389,10529390,10529391,10529392,10529393,10529394,10529395,10529396,10529397,10529398,10529399,10529409,10529410,10529411,10529412,10529413,10529423,10529862,10529863,10528350,10542423,10542424,10542440,10542441,10542453,10534567,10534570,10534571,10534572,10534573,10534574,10534575,10534576,10534577,10534578,10534579,10534580,10534581,10534582,10534583,10534584,10534585,10534586,10534587,10534588,10534589,10534590,10534591,10534592,10534593,10534595,10534596,10534597,10542602,10542603,10542654,10527020,10543041,10543042,10498250,10498251,10498252,10498367,10498499,10486191,10476375) 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'