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,8630536,8630537,8630538,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,8630754,8630811,8574513,8630993,8631003,8631046,3228960,3228961,8631192,3229171,8631518,8631519,7065936,8631598,8631599,8631614,8631615,8583440,8631622,8631623,8631624,8631625,8631630,8631635,10950674,10950747,10950748,7066142,8575733,8575734,8575735,8632392,8067931,8629621,3227401,8629639,8629705,8629732,8573292,8573293,8573335,8573336,8573337,8630172,8630173,8630187,8630323,8630324,8630325,8630326,8630327,8630328,8630329,8630330,8630331,8630332,8630333,8630334,8630335,8630336,8630337,8630338,8630339,8630340,8630341,8630342,8630343,8630344,8630345,8630346,8630347,8630348,8630349,8630350,8630351,8630352,8630353,8630354,8630355,8630356,8630357,8630403,7067801,8630458,8630459,7201257,7201258,7201259,7201260,7201261,7201262,7201263,7201264,7201265,7201275,7201319,7201321,8627752,7201354,8627757,8627760,8627763,8627765,7201366,7201367,8627767,8627770,8627774,8627777,8627783,7201415,8627821,7201422,7201424,7201453,7201585,7201586,7201587,7201588,7201605,7201607,7201629,7201683,7201727,7201741,7201742,8628148,7201756,7201758,8628169,8628170,7201775,7201776,7201777,7201778,7201779,7201780,7201781,7201782,8628183,8628184,8628185,8628186,8628187,8628188,8628189,8628190,8628230,7201861,8628265,8628294,8628295,7201959,7201976,10960474,8628581,8628582,8628583,8628584,8628585,8628588,8628589,8628632,8628633,8628641,8628643,8628654,7202259,8628662,8628665,7202265,7202266,8628666,8628667,8628668,8628669,8628678,8628680,7202285,8628699,8628713,8628718,8628719,8628753,8628754,8628755,8628756,8628757,8628758,8628759,8628760,8628761,8628762,8628763,8628764,8628765,8628766,8628767,8628768,8628769,8628770,7202524,5654617,5654627,9794578,9794579,9794580,9794587,9794588,9794592,7202769,9794594,8629250,8629264,8629340,8629341,8629429,8629430,8629434,8629435,3227207,7200105,7200106,7200107,7200108,7200109,7200110,7200123,7200124,7200125,7200126,3237402,7200233,8626719,8626720,8626721,8626722,8626723,8626724,8626725,8626726,7200382,8626827,8626829,7200468,7200469,7200470,7200542,8626963,7200594,7200595,7200596,7200597,10959088,8627051,8627053,8627059,8627060,8627061,10985141,7200786,8627221,8627223,8627224,8627225,8627227,8627228,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627244,8627246,8627247,8627248,8627253,8627254,8627255,8627256,8627257,8627258,8627259,8627260,8627261,8627262,8627263,8627264,8627266,8627267,8627268,8627269,8627270,8627272,8627273,8627275,8627277,8627279,8627280,8627282,8627283,8627290,8627310,8627312,8627313,8627357,8627358,8627359,8627360,8627361,8627362,8627363,8627377,8627378,8627379,8627380,8627381,8627382,8627383,8627384,8627385,8627386,8627387,8627388,8627389,8624547,10944447,8624708,8624709,8624710,8624711,8624712,8624713,8624714,8624715,8624716,8624717,8624718,8624719,8624720,8624721,7198394,8908289,8908290,8908468,8908469,8908470,8908517,7198724,7198725,7198726,7198727,7198728,7198729,7198730,7198731,7198767,7198783,7198784,7198785,7199130,7199158,8564678,7199540,7199541,7199542,7199545,7199571,7199575,10101492,10101534,10101551,8860396,8860397,8860405,10958379,8905894,8905900,8905930,8905934,7196378,10623490,11007196,11007197,7196890,7196891,7196892,7197051,8613644,7197075,7197103,7197239,7197288,7197289,3234660,3234661,3234730,7197589,8907409,7197602,7197813,7197814,7197815,7197816,7197817,7197818,7197819,7197820,7197902,7197910,10619887,10617171,10622268,8905221,8905261,8905262,8905263,10622360,10617426,10617427,10617449,10617450,3232899,3232900,3232901,3232902,3232903,3232909,3232910,8905662,8905663,8905665,8905711,8905735,10614969,10614982,10614983,10614984,10614986,10614987,10614988,10614989,10614991,10614992,10614993,10614994,10614995,10614998,10615024,10615025,10615026,10615036,10615075,10615076,10615108,10615109,10615125,10425358,10615167,10620200,10620201,10620202,10615229,10615248,10425910,10615710,10615711,10425937,10615721,10615722,10615726,10615727,10615728,10615780,10615819,10615820,10615822,10615823,10615824,10426254,8540418,8540612,8540613,8540614,8540631,10426628,3231704,8611238,10616644,8611374,8611391,8611455,8611456,8611457,8611458,8611459,8611460,8611461,8611462,8611463,8611464,8611465,10616790,10427106,10427112,10614048,10714020,10614220,6669823,10614376,10614415,10614416,10611449,10611514,10611517,10614518,10614593,10611646,10611655,10614725,10611731,10614744,10611856,10614857,10611954,8549450,10612191,10612268,8862556,8862557,10609845,10612916,10612942,10612943,9196366,9196371,9196372,9196373,10610044,10613056,10613057,10613058,10610060,10613063,10613066,10613079,10613080,10613081,10613082,10613235,10613391,10613392,10613393,10613394,10613406,10613421,10610429,10613431,10613432,10613434,10558596,10613504,10613505,10613513,10613514,10613525,10613527,10613531,10613545,10613547,10613565,10613695,10613737,10613738,10610901,9169305,9169306,9169307,9169308,9169310,9169319,9169329,9169355,9169356,6673563,9169370,6673576,9169378,10117580,9169395,9169396,9169407,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,7015142,6673694,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,6673763,6673767,10117763,6673789,6673803,6673808,10117817,9169638,9169748,10125985,10118177,6674186,6674198,6674247,6674276,6674278,10118270,10118271,6674280,6674281,10118273,10118274,6674283,6674284,6674285,10118277,6674286,6674287,10118293,10118294,10118295,10118298,9168305,9168306,9168307,9168309,6672524,6672525,6672527,10416255,10419256,10416256,10416257,10416260,10416261,10416264,10416265,10416266,10416272,10416284,10416298,10419306,10419307,9168403,10419349,10419350,6672652,6672653,6672655,10415375,10415376,6672661,6672662,6672664,6672669,10417385,6672670,6672673,6672675,10415392,10415393,10415394,6672680,6672683,6672684,6672686,6672697,6672698,10417424,6672716,6672725,6672727,10419450,10419452,10419453,10419454,10419455,10419457,10416481,10417531,10417532,10417533,10417534,10417535,10116818,10417633,10415726,10415727,10415728,10415729,10415730,10415731,10415732,10415733,10415734,10415735,10415736,10415737,6673067,10415791,10415792,10415793,10415794,10415795,10415796,10415797,6673081,10415815,10415816,6673100,10415821,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,6673122,6673124,6673125,9168930,9168931,9168932,9168937,9168938,9168939,9168940,9168941,10415873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,10418048,10418109,10418110,10117401,10418141,10418142,10418143,10418144,10418145,10418146,9169233,10471173,8550018,8550037,8550038,8550131,8550133,8550134,8550135,8550267,10467821,6667453,9167953,9167993,10470721,10470722,10888487,10888524,10893804,10888829,10888839,10888840,10888841,10889019,10889020,10889021,10884075,10884088,10884089,10884324,10884420,10884421,10884631,10155731,10884950,10890163,10890255,10890256,10890257,10890258,10890259,10885313,10885465,10885468,10885469,10632012,10887711,10887722,10887724,10887930,10887931,10887965,10887966,10888018,10888019,10883407,10883413,10883416,10885525,10630042,10885751,10161868,10885867,10886058,10886059,10886060,10886061,10162177,10162239,10162240,10886250,10881491,10187507,10881537,10876751,10886878,10886910,10886918,10631455,10631456,10887052,10168073,10887072,10882082,10887096,10887097,10882127,10882145,10887352,10647518,10582561,10579772,10579773,10579774,10579775,10579776,10579777,10579778,10579779,10579780,10579781,10545356,10545357,10545358,10545371,10545372,10545373,10542440,10527020,10505583,10407238,10407254,10407255,10407256,10407257,10407331,10407344,10407345,10407346,10407925,10408157,10408158,10408159,10408160,10408161,10408163,10487111,10408820,10408822,10408823,10408824,10409053,10409054,10409055) 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'