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(8630462,8630463,8630465,8630466,8630467,8630468,10930095,8630625,8630626,8630627,8630628,8630629,8630630,8630631,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,7076128,8630811,8630867,8630868,8574513,8630993,8631003,3228956,3228957,8631192,3229008,3229077,3229078,3229171,8631518,8631519,7065936,8631598,8631599,8631622,8631623,8631624,8631625,8631630,8631635,10950674,8583522,8575733,8575734,8575735,8632420,8067931,8629621,3227401,8629705,8573312,8573335,8573336,8573337,8630172,8630173,8630187,8630284,10939443,7067801,8630459,7201319,7201366,7201367,7201415,8627821,7201453,7201605,7201607,7201683,7201727,7201728,7201729,7201741,7201742,8628169,8628170,7201775,7201776,7201777,7201778,7201779,7201780,7201781,7201782,8628230,8628247,7201861,8628265,8628294,8628295,7201905,7201906,8628339,8628340,8628341,8628342,7201959,7201977,10960474,8628633,8628641,8628654,7202259,8628662,7202265,7202266,7202285,5654617,5654627,7202688,7202691,7202692,7202697,9794578,9794579,9794580,9794592,7202769,9794594,3227207,7200105,7200106,7200107,7200108,7200109,7200110,7200123,7200124,7200125,7200126,3237402,7200233,7200468,7200469,7200470,10959088,10985141,10944447,7198386,7198394,8908289,8908290,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,7199130,7199135,7199571,7199575,10101492,10101534,8860418,8860419,8860420,10958379,7196378,11007196,11007197,7196890,7196891,7196892,7197051,8613644,8906883,8906884,7197075,8906890,8906892,7197103,7197239,7197288,7197289,10838970,10838976,3234660,10838994,3234661,10838995,3234730,7197589,8907409,7197602,7197795,7197797,7197798,7197813,7197814,7197815,7197816,7197817,7197818,7197819,7197820,10619887,3232382,10617171,10622268,8541668,8905221,10617322,10617325,10617326,10617330,10617333,10617334,10617335,10617336,8905248,10617337,10617338,8905251,10617340,10617341,10617342,10617343,10617344,10617346,8905259,8905260,8905261,8905262,8905263,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,3232899,3232900,3232901,3232902,3232903,3232909,3232910,8905662,8905663,8905665,8905711,8905720,8905721,8905735,10620117,10620118,10425358,10615167,10620200,10620201,10620202,10615229,10425552,10425555,10615343,10615344,10425910,10615710,10425937,10615822,10615823,10615824,10616006,8540418,10426339,8540631,8611238,10616644,8611374,8611391,8611455,8611456,8611457,8611458,8611459,8611460,8611461,8611462,8611463,8611464,8611465,8611466,8611467,8611468,10427106,10610964,10610965,10610984,10610985,10614048,10714020,10614220,6669823,10614376,10714203,10614415,10614416,10611449,10614503,10614504,10614505,10611514,10611517,10614593,10559744,10611646,10611655,10611856,10611954,8549450,10612191,10612268,10612294,10612381,7017822,7017823,7017826,7017827,7017830,7017831,10609845,7017840,7017841,7017842,7017843,7017856,7017857,7017870,7017871,7017872,7017873,7017886,7017887,10612916,10612938,10612939,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,9196366,9196371,9196372,9196373,10610060,10613081,10613082,10613235,10613369,10613391,10613392,10613393,10613394,10613406,10613421,10610429,10613431,10613432,10613434,10558596,10613504,10613505,10613513,10613514,10613525,10613527,10613531,10613695,10613737,10613738,10613750,10610901,10610954,10610958,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,10415375,10415376,6672661,6672662,6672664,6672669,6672670,6672673,6672675,10415392,10415393,10415394,6672680,6672684,6672686,6672697,6672698,10417424,6672716,6672725,6672727,10419472,10419474,10419475,10419476,10419477,10419478,10419479,10419481,10416481,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,10417531,10419531,10417532,10419532,10417533,10419533,10419534,10417534,10419535,10417535,10419536,10419537,10116818,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,10417149,10417150,10417151,10417152,10417153,10417154,10417155,9169233,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'