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(8630649,8630660,8574197,10962733,10962734,7076286,7076353,8631041,8631064,8631091,8631093,8631117,8631118,4970738,8631188,3229009,3229011,8631255,8631257,8631259,8631261,8631263,8631265,8631267,8631269,8631271,8631273,8631277,8631304,8631305,8631306,8631307,3229078,8631308,8631309,8631316,8631317,8631318,8631319,8631320,8631321,8631328,8631329,8631330,8631331,8631332,8631333,8631334,8631335,8631336,8631337,8631338,8631339,8631340,8631341,8631342,8631343,8631344,8631345,8631657,8583487,8583489,10950674,8583521,8583522,8631732,7066106,10963826,10963827,10963831,10963832,10963833,10963837,10963838,10963841,10963842,10963847,10963848,8631876,8631881,8631885,8583741,8631957,8631959,8631960,8631972,8631981,8631984,8631986,8632015,8632016,8632018,8632019,8575567,10847229,10847230,8575665,8632283,8632285,8632288,8632289,8632290,8632291,8632292,8632293,8632294,8632301,8632305,8632308,8632316,10844713,8837591,11040243,8620481,10962455,10447786,10447791,10447792,10447795,10447805,8911035,7201382,10985861,10842945,10842986,10842992,10842999,10973003,7201596,10973056,10960066,10960068,10960069,10973083,10843158,7201680,7201681,10986174,10999819,10960858,7202439,5654538,5654542,7202524,10999966,10999967,5654660,11000014,11000049,11000050,11000051,11000052,11000053,11000055,11000082,11000100,10844192,5654777,7202768,8837157,3227260,3227261,8837361,8837363,10958628,10958629,7070953,8910056,7071260,7071261,7071267,7200906,7071661,10972450,10972451,10972452,10972453,10972454,10102911,10102912,10972496,10972503,10972507,10972516,10972520,10972531,10102994,10972551,10972563,10972573,7201157,7201159,10995717,10995822,7198457,7198458,7198459,7198460,7198461,7198463,7069389,7198722,10996176,7198760,10996290,10996305,8615499,8615503,10996388,10996389,10957566,10957648,10957649,10941696,10941699,10941713,10941724,10941725,10941738,10941752,10941753,10941769,10941809,10941838,7199545,7199569,8616252,10101564,10101565,10101566,7070749,7070757,7070760,10993665,10993666,3233400,3233401,3233402,3233417,3233418,3233419,3233422,3233426,3233427,3233430,3233431,10623064,11045974,11045978,11045979,11045980,10994158,10994184,3233953,10994229,10994230,10994238,7196891,3234552,11046938,3234673,11046939,3234674,3234675,3234676,3234677,3234678,3234679,3234680,11046967,3234718,11047033,11047054,11047059,11047082,8907461,11047093,11047094,11047095,11047096,11047097,11047103,11047148,11047169,7197806,11047266,11047268,11047269,10995299,10995300,10995301,10995302,10995303,10995306,10995307,10995308,10995309,10995310,7197906,7197908,7197909,7197910,7197911,7197912,10995358,10995363,10995372,10995384,10619864,10619866,10619895,10927504,10927505,10966658,8541521,8541606,10992846,10992847,10992848,10992849,10992850,10992851,10992852,10992853,10992854,10992855,10992856,8541719,8541720,8541722,10622258,10622264,10622265,10622266,10622267,10622268,10617323,10617324,10622428,10622460,10993170,10993173,10993200,10993204,10993292,10993350,10993363,10993367,10993377,10993380,10993381,10993383,8905769,8905772,10993399,10993423,10951574,10951581,10951587,10951597,10425393,10951689,10951732,8570103,8570105,8570106,8570113,10620186,10620195,10620196,10620197,10620201,10425552,10425573,11042899,11042923,11042924,11042925,11042926,11042927,11042928,11042932,11042933,11042934,11042938,10951904,10615363,10425910,10425939,10426008,10426009,10426010,10620764,10930733,10930737,10991468,10991489,10991490,10991491,10991492,10991494,10991496,10991497,10991509,10991510,8540377,8540378,10615896,10991592,10991606,10991657,10991660,10991664,10991665,10991666,10991667,10991671,10991672,10991673,10991674,10991675,10991676,10991677,10991678,10991697,10991698,10991701,10991702,3231437,10616045,10991703,10991715,10991716,10991718,10991728,10991730,10991733,10991739,10991742,10991753,10991754,10991767,10991768,10991769,10991770,10991771,8540604,10991783,10991784,10991785,10991786,10991865,10991897,10991898,10991912,10991915,10991916,10991917,10991918,10991919,10991920,10991921,10991923,10991924,10991925,10991926,10991930,10991937,10991952,10991953,10991954,10991955,10991961,8904348,10991999,10992000,10992233,10992236,10992241,10992278,10992281,10992282,10992283,10992284,10992285,10992287,10992288,10992380,10992382,10992384,10992385,10992387,10992392,10992395,3232142,3232143,3232151,3232152,3232153,3232174,10953442,3232196,3232197,3232238,3232241,3232256,3232265,3232270,3232275,3232283,3232287,3232290,3232294,3232295,3232296,3232297,3232298,3232299,3232300,3232301,3232316,3232325,3232328,3232346,10613978,9189361,10614024,10614064,7059859,10614415,10559609,10614498,10614501,10614502,10122122,9189927,9189928,9213947,9189954,9189980,9189982,10122201,10122209,10122287,7057465,10611969,10612062,10612063,10612064,9187423,10609313,10612381,9211924,9211925,9211936,9211941,9188329,9188330,9188331,9188332,9188334,9188344,9188346,9196362,9188369,9188378,9188417,9188431,9188438,10613127,9172490,9172535,9188597,10613435,9188812,9188813,9188954,9188957,6677244,6677251,6677260,10613811,10613859,10613875,10613888,10117529,9169355,9169407,10515343,9185604,9185610,9185618,9185619,9185621,9209628,9185717,9185735,10513553,9185741,10513554,10513555,10513556,10513557,10513558,10125973,9185803,9185826,9185828,10126033,7015492,7015493,9185853,9185859,9185861,9185866,7056038,9185888,9185920,9185931,9185932,9185933,9185939,10118152,10126158,10126159,10126199,10118214,9186034,9186035,9186038,9186039,6674280,6674285,10118293,6674454,6674460,10118451,10516142,9186353,6674592,9170421,9178490,9178492,9186564,9186754,9186783,9186786,9186789,9186812,9186990,9187011,9187036,9187037,9187045,9187058,9187059,9187060,9179212,9211270,9192299,4973319,10415392,9192483,10415791,10415792,6673081,10419813,10419814,10419816,10419839,10419844,10419845,10419848,9169034,9169035,9169051,10420014,10420015,10420016,10420053,10419110,10419113,9169275,10122528,10122529,10122530,10122531,10122532,10122536,6670768,10469376,10469380,6671134,6671137,6671139,10123164,10463595,3963603,9207303,6667323,10115665,8550649,9192122,9192123,9192124,9192126,9192127,9192129,9192210,9192239,9192248,9192258,9184261,9192293,9192294,9192297,9192298,10888565,10888566,10883665,10883668,10888704,10893756,10893767,10884086,10884087,10889711,10889718,10884793,10890006,10890007,10890008,10171174,10890255,10890256,10890257,10890258,10890259,10890390,10887483,10632012,10887544,10632106,10632107,10632109,10627707,10627708,10627715,10627716,10627717,10627718,10627719,10627720,10627721,10627722,10627723,10627771,10888339,10883401,10883402,10883408,10883409,10630040,10630041,10630043,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630080,10630090,10886062,10886063,10886069,10886070,10886071,10172088,10172095,10162113,10886161,10886206,10886220,10886294,10886302,10886303,10886344,10886391,10886392,10886393,10886394,10886395,10172416,10891450,10886513,10886553,10886568,10949419,10886609,10626127,10626128,10626142,10886682,10626233,10886744,10626234,10626237,10886748,10886749,10886750,10626240,10626245,10626246,10626259,10626297,10886815,10886818,10886841,10626343,10886860,10167917,10167934,10167968,10626450,10167992,10168007,10168026,10168027,10168029,10887096,10887097,10887195,10626710,10626711,10887223,10887224,10887225,10887226,10887227,10887228,10887229,10887231,10887232,10887241,10887242,10887243,10631794,10887460,10601398,10598635,10598636,10598862,10598863,10598864,10590996,10579475,10579478,10582567,10582569,10600621,10600622,10600623,10600624,10600625,10600626,10600627,10600628,10600629,10591758,10579810,10579811,10579836,10539281,10539282,10539283,10539284,10539285,10539286,10539287,10539288,10539289,10539312,10539313,10539374,10539405,10539406,10539407,10539408,10539409,10539410,10539411,10539486,10539487,10539488,10539489,10539490,10539491,10539492,10533566,10533567,10533581,10533582,10533583,10533584,10528100,10530107,10530108,10528109,10528115,10528116,10528117,10530125,10528138,10528140,10528142,10528146,10528162,10528176,10538261,10538262,10538264,10522346,10522404,10522452,10522453,10542603,10522612,10522613,10528630,10528631,10528632,10528633,10528634,10528635,10528638,10528639,10528640,10528641,10530647,10530648,10530649,10530650,10530753,10536849,10536850,10536851,10536857,10536860,10530937,10530938,10546992,10546993,10547031,10533104,10422315,10422330,10498250,10498251,10498252,10422363,10422366,10424483,10424484,10424487,10424489,10423738,10423739,10423740,10421961,10421964,10421984,10422993,10422994,10422000,10423001,10423006,10423007,10422218,10485939,10484499,10484500,10484518,10486698) 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'