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(7201605,7201607,7201683,7201727,7201728,7201729,7201741,7201742,8628169,8628170,7201775,7201776,7201777,7201778,7201779,7201780,7201781,7201782,8628230,8628247,7201861,8628265,8628294,8628295,7076128,7201905,7201906,8628339,8628340,8628341,8628342,7201959,7201977,8628633,8628641,8628654,7202259,8628662,8628665,7202265,8628666,7202266,8628667,8628668,8628669,8628678,8628680,7202285,8628699,8628713,8628718,8628719,5654617,5654627,7202688,7202691,7202692,7202697,8629097,8629098,8629100,7065936,9794578,9794579,9794580,8629164,8629166,9794592,7202769,9794594,8629173,8629174,8629177,8629178,8629188,8629250,8629264,8629340,8629341,8629429,8629430,8629434,8629435,3227207,8629621,3227401,8629705,8573312,8573335,8573336,8573337,8627051,8627053,8627059,8627060,8627061,8067931,8627237,8627238,8627253,8627283,8627310,8627312,8627313,7201319,7201366,7201367,7201415,8627821,7201453,7067801,8625022,8625025,8625042,8625045,8625055,8625056,8625057,8625058,8625059,7198678,7198695,7198696,7198698,7198700,7198701,7198702,7198703,7198704,8908517,7198720,7198721,7198722,7198725,7198728,7198729,7198730,7198731,7198744,7198745,7198747,7198765,7198769,7198783,7198784,7198785,8625240,8625241,8625242,8625243,8625244,8625245,8625246,8625247,8625248,8625249,8625282,8625283,8625284,8625373,10221592,7199130,8625534,8625535,7199135,8625538,8625539,8625540,8625541,8625551,8625552,8625555,8625556,8625557,8625558,8625559,8625560,8625562,8625564,8625565,8625567,8625568,8625615,7199571,7199575,10101492,10101534,10196489,7200105,7200106,7200107,7200108,7200109,7200110,7200123,7200124,7200125,7200126,3237402,7200233,7200468,7200469,7200470,8907409,7197602,7197795,7197797,7197798,10194264,7197813,7197814,7197815,7197816,7197817,7197818,7197819,7197820,10246590,10246591,7198386,7198394,8908289,8908290,10194999,10944447,3232899,3232900,3232901,3232902,3232903,3232909,3232910,8905662,8905663,8905665,8905711,8905720,8905721,8905735,7196378,7196890,7196891,7196892,7197051,8613644,8906883,8906884,7197075,8906890,8906892,7197103,7197239,7197288,8860418,7197289,8860419,8860420,10838970,10838976,3234660,10838994,10838995,3234661,3234730,7197589,10425910,10425937,8540418,10426339,8540631,8611238,8611374,8611391,8611455,8611456,8611457,8611458,8611459,8611460,8611461,8611462,8611463,8611464,8611465,8611466,8611467,8611468,10427106,3232382,8541668,8905221,8905248,8905251,8905259,8905260,8905261,8905262,8905263,10619887,8575733,8575734,8575735,10617171,10622268,10617322,10617325,10617326,10617330,10617333,10617334,10617335,10617336,10617337,10617338,10617340,10617341,10617342,10617343,10617344,10617346,10617356,10617357,10617358,10617359,10617360,10622360,10617361,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617369,10617370,10617371,10617375,10617376,10617379,10617380,10617384,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617406,10617407,10617408,10617418,10617419,10617420,10617424,10617425,10617426,10617427,10617430,10617436,10617439,10617440,10617444,10617445,10617446,10617447,10617449,10617450,10617452,10617457,10617458,10425358,10425552,10425555,10620117,10620118,10615167,10620200,10620201,10620202,10615229,10615343,10615344,10615710,10615822,10615823,10615824,8574513,10616006,3228956,3228957,3229008,3229077,3229078,10188386,3229171,10616644,10431607,8583522,10614048,10714020,10614220,6669823,10614376,10714203,10614415,10614416,10614503,10614504,10614505,10614593,10559744,8549450,10612191,10612268,10612294,10612381,7017822,7017823,7017826,7017827,7017830,7017831,7017840,7017841,7017842,7017843,7017856,7017857,7017870,7017871,7017872,7017873,7017886,7017887,10612916,7017936,10612938,7017937,10612939,7017938,7017939,7017940,10612942,7017941,10612943,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,9196366,9196371,9196372,9196373,10613081,10613082,10613235,10613369,10613391,10613392,10613393,10613394,10613406,10613421,10613431,10613432,10613434,10558596,10613504,10613505,10613513,10613514,10613525,10613527,10613531,10613695,10613737,10613738,10613750,6673563,6673576,9169370,9169378,10117580,9169395,9169396,9169428,6673636,9169453,7015120,7015121,7015122,7015123,7015124,7015125,7015126,7015127,7015128,7015129,7015130,7015131,7015132,7015133,7015134,7015135,7015136,7015137,7015138,7015139,7015140,7015141,6673694,7015142,7015143,7015144,7015145,9161492,7015146,7015147,7015148,7015149,7015150,7015151,7015152,7015153,7015154,7015155,7015156,7015157,7015158,7015159,7015160,7015161,7015162,7015163,7015164,7015165,7015166,7015167,7015168,7015169,7015170,7015171,7015172,7015173,7015174,6673803,6673808,10117817,9169638,9169748,10125985,9169939,9169940,9169941,9169944,9169947,9169949,9169950,9169952,9169953,9169954,9169956,9169957,9169958,9169959,9169960,9169961,9169962,9169963,6674198,6674247,6674281,6674331,10118369,10118370,8551565,10118606,10118607,10118679,8552192,8552193,8552194,8552226,6672524,6672525,6672527,10419256,9168366,10419306,10419307,9168403,10419349,10419350,10416357,6672652,6672653,6672655,6672661,6672662,6672664,6672669,6672670,6672673,6672675,6672680,6672684,6672686,6672697,6672698,10417424,6672716,6672725,6672727,10419472,10419474,10419475,10419476,10419477,10419478,10419479,10416481,10419481,10419482,10419483,10419484,10419486,10419488,10419490,10419492,10419501,10419502,10419503,10419505,10419506,10419507,10419508,10419511,10419512,10419513,10419514,10419516,10419517,10419518,10419519,10419520,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10417531,10419532,10417532,10417533,10419533,10419534,10417534,10419535,10417535,10419536,10116818,10419537,6672885,10417633,9168817,6673067,6673081,6673100,6673122,6673124,6673125,9168930,9168931,9168932,9168937,9168938,9168939,9168940,9168941,10117317,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10418141,10417141,10418142,10417142,10418143,10417143,10418144,10417144,10418145,10417145,10418146,10417146,10417147,10417148,9169233,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,10419168,10419170,10419174,10419177,10471171,10471172,10471173,10471174,10471175,8550018,8550037,8550038,8550263,8550264,8550265,8550267,10467821,9167792,9167953,9167993,9168101,10470721,10470722,10888487,10888524,10883625,10883626,10883631,10893804,10888839,10888840,10888841,10889019,10889020,10889021,10884075,10884078,10884079,10884080,10884081,10884082,10884083,10884084,10884085,10884088,10884089,10884420,10884421,10884698,10155731,10884950,10885060,10890126,10890129,10890130,10890132,10890137,10890138,10890139,10890140,10890141,10890142,10890143,10890144,10890145,10890150,10890151,10890152,10890153,10890156,10890160,10890161,10890162,10890163,10890164,10890169,10890170,10890172,10890255,10890256,10890257,10890258,10890259,10885313,10885347,10885348,10885349,10885350,10885465,10885468,10885469,10632012,10627319,10627775,10883407,10883413,10883416,10630042,10885751,10161868,10885956,10885958,10885959,10886058,10886059,10886060,10886061,10162177,10886250,10881491,10187507,10881537,10876751,10886878,10886910,10886918,10887052,10887072,10882082,10887096,10887097,10882127,10882145,10887352,10887469,10647518,10647704,10582561,10579772,10579773,10579774,10579775,10579776,10579777,10579778,10579779,10579780,10579781,10545356,10545357,10545358,10545371,10545372,10545373,10541444,10542440,10527020,10505583,10506823,10506825,10425050,10425051,10425052,10425053,10425054,10425055,10425056,10425057,10407925,10408025,10408159,10487111,10408820,10408823,10408824) 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'