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(10861349,10861350,10861363,10861366,10861386,3228965,3228966,10861839,10989324,3229127,3229128,3229129,3229130,3229131,10862014,3229281,3229282,3229283,3229284,3229285,8621878,8631705,10862383,10849389,10862544,10862550,10862551,10862553,7066267,10863003,10850020,8632392,8632397,3227395,10860426,10860548,8630419,8630433,10939419,10861114,10861126,10861130,10861133,10861135,10861141,10861144,10861152,10861175,10861176,10861177,10861178,10861179,7201197,10866271,10866273,10866275,7201307,10866362,3238520,7201375,7201376,7201377,10858792,7201866,10866930,7201893,10858959,7201959,7201963,7201964,7201970,8065838,8065839,8065840,8911927,8911954,8911961,8911962,8628634,10859286,10859288,10859532,7202524,7202525,7202526,7202585,7202618,7202689,7202690,10859754,10859756,9794574,9794577,7202766,8629329,8629330,8629331,10860033,7065856,10865246,10865247,10865249,10865250,10865251,10865264,10865265,10865266,10865268,10865269,10865270,10865271,10865272,10865273,10865274,8910080,10857404,10857428,10865444,10102356,10102359,8834751,8834752,8834762,8834763,7200521,10865571,10865572,10865573,10865574,10865575,10865576,10865577,10865578,10865579,10865580,10865581,10865582,10865583,10865584,10865585,10865586,10865587,10865588,10865589,10865590,10865591,10865592,10865593,10865594,10865595,10865596,10865597,10865598,10865599,10865600,10865601,10865602,10865603,10865604,10865605,10865606,10865607,10865608,10865609,10865610,10865611,10865612,10865613,10865614,10865615,10865616,10865617,10865618,10865619,10865620,10865621,10865622,10865623,10865624,10865625,10865626,10865627,10865628,10865629,10865630,10865631,10865632,10865633,10865634,10865635,10865638,8627015,8627020,8627028,7200714,10865855,10865859,10866055,10866126,10866146,10866148,10866150,7198684,7198686,8625251,8625252,8625254,8625256,8625258,8625265,8625266,8625268,10864148,10864150,10864202,10864234,10856259,10864280,10856309,10856310,10864330,10864331,10856350,10864380,10856525,10856526,8626149,8626159,8626166,8626171,8626174,10865030,10865031,10865032,10865033,10865034,10865035,10865036,10865037,10865038,10865039,10865040,10865041,10865042,10865043,10865044,10865045,10865046,10857076,10857133,7200172,10853239,10853240,10853255,10853258,10853261,10853263,10853296,10853297,10853300,10853301,10853329,3923440,3923441,3923625,10853728,10853734,10853735,10623491,10623492,10854077,10854322,10838790,7197439,10855126,10617047,10954017,10954018,10852637,3232909,3232910,3922909,10615001,10615002,10425394,10615092,10615202,10425589,10425590,10615268,10615334,10615389,10615568,10615569,10615570,8633275,8633276,8633277,10615718,10615818,10426268,10615947,10426341,8540594,10426447,8540625,8904203,8634297,8634298,10616697,10616796,10616804,10616888,10616911,10616913,10616932,10614024,10614048,10614050,10611053,10611054,10614282,10611367,10611368,10611369,10611370,10614376,10611417,10611456,10614501,10611519,10614634,10611666,10611761,10611802,10611812,10611819,10612051,10612069,10612178,10612179,10612180,10612181,10612186,10612187,10612188,10612263,10612273,10612320,10612321,10609392,10612479,8851770,8851771,8851772,8851773,10609664,10609685,10612757,8566603,10612884,10612893,10612894,10612896,10612897,10612916,10610006,10613019,10610035,10610037,10610039,10610041,10610042,10610044,10610053,10610054,10610108,10613193,10613235,10610268,9914817,10613349,10613350,10610396,8852564,10610492,10610493,10613513,10613514,8852678,8852679,8852680,8852681,8852682,8852683,8852684,8852685,8852686,10610674,10610675,10610676,10610862,10610958,6673684,7055654,10117691,9169540,6673769,9169639,9169708,10117944,6674152,6674190,6674249,6674253,6674326,10118420,8850094,9913034,10419255,10419260,10419262,6672551,10415314,10418316,10418317,10418318,10418319,10418320,10418321,10418322,10415323,10418323,10418324,10418325,10418326,10418327,10418328,10418329,10418330,10418331,10419358,10419360,10419362,10419370,10417537,10418552,10418553,10418555,10418556,10418557,10417565,10418569,10418570,10418571,10418573,10418574,10418575,10418576,10418577,10418578,10418579,10417609,10415634,10417649,10417650,10415682,10417700,10418734,6673080,10418806,10418807,10418808,10418809,10418810,10419811,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,10418821,10418822,10418823,10418824,10418825,10418826,6673111,10418827,6673112,10418828,6673113,10418829,6673114,10418830,6673115,10418831,6673116,10418832,6673117,10418833,6673118,10418834,6673119,10418835,6673120,10418836,6673121,10418837,6673122,10418838,10418839,6673124,10418840,6673125,10418841,6673126,10418842,10418843,10418844,6673128,6673129,10418845,10418846,6673131,10418847,10418848,10418849,6673133,10418850,6673134,10418851,6673135,10418852,6673136,10418853,6673137,10418854,6673138,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,10418863,10418864,9169033,10419026,10419031,10416056,10117423,10117424,10416187,10416190,6670688,6670689,8550058,9167634,10116206,10116207,10116208,10116209,10116210,10116211,10116212,10116213,10116214,10116215,10116216,10116217,10116218,10116219,10116220,10116221,10116222,10116223,10470721,10470722,10888524,10884474,10884630,10889842,10884933,10890096,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890161,10890162,10890173,10890174,10890175,10875193,10875194,10875195,10890208,10890209,10890210,10890211,10890212,10875237,10880250,10887949,10888082,10888100,10888298,10883430,10885955,10876482,10876588,10886868,10877176,10877177,10882372,10602445,10602736,10603833,10603875,10585350,10604216,10536719,10508178,10508179,10508198,10508473,10508474,10508527,10508606,10507662,10507663,10507664,10507718,10507719,10507720,10507757,10507902,10507937,10508002,10508009,10508010,10508011,10508012,10508025,10411385,10411397,10409434,10409435,10409449,10407462,10409496,10411563,10411564,10409752,10413988,10412145,10412158,10414190,10414191,10414193,10414426,10415120,10415131,10415134,10415137,10415139,10415145,10415147,10415152,10415157,10415158,10415159,10415160) 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'