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(4970738,3229182,3229206,8583474,8583517,8583521,8583522,8583523,8583524,8583525,10950747,10950748,3230230,8067942,8573335,8573336,8573337,7201195,7201196,7201253,7201272,7201273,7201274,7201275,7201276,7201277,7201325,7201326,7201327,7201328,7201329,7201330,7201331,7201354,7201368,7201514,7201564,7201565,7201567,7201570,7201572,7201580,7201605,7201607,7201614,7201616,7201617,7201618,7201631,7201844,7201901,8911755,7201959,7201976,10960474,7202127,7202132,7202133,7202136,7202161,7202165,7202168,7202171,7202196,7202205,7202209,7202210,7202211,7202212,7202213,7202214,7202257,7202285,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,7202439,7202585,3227094,3227207,8910056,8910100,8910106,7200507,7200508,7200509,7200548,7200607,7200608,8910444,8910466,7200778,7200779,7200780,8910600,8910601,8910602,8910603,7200829,7201071,10100083,7198397,8615017,7198644,7198645,7198648,7198649,7198678,7198679,7198680,7198681,7198682,7198683,7198684,7198685,7198687,7198688,7198690,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198726,7198727,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198740,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198759,7198760,7198762,7198763,7198764,7198765,7198766,7198767,7198768,7198769,7198770,7198772,7198781,7198782,7198783,7198784,7198785,7198853,7198890,7198891,8564678,7199415,7199449,7199480,7199540,7199541,7199542,10941948,10101528,11048447,7199881,7200030,8612892,10618178,10618179,10618180,10618181,8613064,7196523,7196526,11045965,7196528,11045975,11045977,11045983,8906900,7197239,10838801,10838855,7197417,10838965,10838966,10838967,10838968,10838969,10838970,10838971,10838972,10838973,10838974,10838975,10838976,10838977,10838978,10838979,10838980,10838981,10838982,10838983,10838984,10838985,10838986,10838987,10838988,10838989,10838990,10838991,10838992,10838993,10838994,10838995,8907461,8907462,8907463,8907464,8907465,7197843,7197846,7197849,7197850,7197899,7197900,7197901,7197902,7197903,7197904,7197905,7197906,7197907,7197908,7197909,7197910,7197911,7197912,7197913,10619875,11044807,11044808,11044809,11044810,11044811,11044812,11044813,10992856,10622266,10622267,10617377,10617384,10617403,10617404,10617405,10617409,10617417,10617422,10617423,10617428,10617429,10617430,10617431,10617432,10617433,10617434,10617435,10617438,10617442,10617443,10617445,10617451,10617452,10617512,8905662,8905663,8905665,8905686,8542165,8905711,8905717,8905718,8905719,8905720,8905721,8905735,8542253,8542254,8905934,10614982,10614983,10614984,10614986,10614987,10614988,10614989,10614991,10614992,10614993,10614994,10614995,10614998,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10848007,10615363,10615710,10615711,10615721,10615722,10426204,8540446,10426402,8540612,8540613,8540618,8540631,8611342,8611378,10616644,10616648,10616649,10616655,10616888,10610994,10614048,6669828,6669829,6669830,6669831,6669918,10614376,10611422,10611423,10611434,10611441,10611442,10611476,10611477,10611499,10614503,10614504,10614505,10611551,10611603,10611605,10611623,10611647,10611648,10611778,10611856,6666259,8549450,10609035,10609036,10612062,10612063,10612064,10609099,10609100,9187452,9187453,9211551,9211556,9211557,9211560,9211561,9211567,10609285,10609355,8862556,8862557,10609706,10612909,10612916,10609988,10610030,10613034,9172407,10613136,10613143,10613144,10613147,10613148,10613149,10613157,10613162,10613172,10613175,10613176,10613179,10613191,10613192,9172535,9172536,9172537,9172538,10613208,10613214,10613215,10613220,10613221,10613235,10613273,10613306,10610306,10610307,10610310,10613311,10610311,10610312,10610333,10613334,10610337,10613337,10613341,10613342,10613350,10613353,10613354,10613362,10613369,10613372,10613391,10613392,10613393,10613394,10613406,10613421,10613431,10613432,10613434,10613435,10613475,10613483,10613498,10613501,10613504,10613505,10613506,10613513,10613514,10613515,10613523,10613524,10613525,10613527,10613528,10613529,10613531,10613545,10613547,10613565,10613695,10613696,10613697,10613698,10613699,10613721,10613722,10613729,10613732,10613733,10613736,10613737,10613738,10613739,10613740,10613750,10610850,10610901,9169318,10117525,7055541,7055546,9169428,10117664,9169520,9169669,10117974,10118062,10118130,9169951,9169952,9169953,9169956,9169957,9169958,9169959,9169960,9169961,9169962,9169963,9170074,10118293,10118294,10118295,10118298,10118606,10118607,10118608,10118609,10118610,9186540,9186541,8552191,8552192,8552193,8552194,8552227,10514971,10416255,10416256,10416257,10416260,10416261,10416264,10416265,10416266,10416272,10415342,10416346,10416362,10416363,10419375,10419376,10419468,9168710,9168870,10418807,10418808,10418809,10418810,10417811,10417812,10418812,10418813,10419813,10417814,10418814,10419814,10419815,10417816,10419816,10419817,10418817,10417818,10419818,10419819,10417820,10418820,10419820,10419821,10418821,10419822,10417822,10418822,10419823,10418823,10419824,10417824,10418824,10419825,10418825,10417826,10419826,9168905,10419827,10418827,10417828,10419828,10419829,10417830,10418830,10419830,10418831,10419831,10417832,10418832,10419832,10418833,10419833,10417834,10418834,10419834,10418835,10419835,10419836,10418836,10417837,10419837,10418837,10419838,10418838,10417839,10419839,10418839,10419840,10418840,10417841,10419841,10418841,10419842,10418842,10417843,10418843,10419843,10418844,10419844,10417845,10419845,10418845,10419846,10418846,10417847,10419847,10418847,10419848,10418848,10417849,10419849,10418849,10419850,10417850,10418850,10418851,9168930,10417852,10418852,9168931,10418853,9168932,10417854,10418854,10417856,10418856,10417858,9168937,10418859,9168938,10417860,10418860,9168939,10418861,9168940,10417862,9168941,10418863,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,10417881,10417883,10417885,10417887,10417889,9168969,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10418961,9169136,10471173,10469245,10469277,10469278,10467327,8550018,8550131,8550133,8550134,8550135,10467558,8550266,9167397,9167398,9167399,9167400,9167770,9167782,9167792,10468551,9168025,9168027,9168121,10470721,10470722,9168216,9168290,9168293,10888565,10888566,10888637,10888638,10888639,10888640,10888641,10888642,10888655,10888656,10889020,10889451,10889490,10884631,10884652,10884653,10889707,10884764,10889775,10889776,10889777,10170914,10170915,10889944,10874953,10874954,10885001,10885074,10890085,10890141,10890144,10890145,10890146,10890147,10890148,10890149,10890154,10890155,10890158,10890160,10890164,10890165,10890166,10890167,10890168,10880304,10880305,10880306,10880307,10885313,10880325,10880326,10885465,10885468,10885469,10887483,10887484,10631994,10632010,10632011,10632012,10632013,10632018,7000826,7000845,10882675,10627405,10883044,10883143,10883358,10883359,10883378,10883392,10883393,10883396,10883397,10883398,10630039,10162052,10162113,10631412,10631413,10631414,10631415,10631416,10631417,10631418,10631419,10631420,10631421,10631422,10631423,10631424,10631425,10631426,10631427,10631428,10631429,10631430,10631431,10631432,10631433,10631434,10631435,10631436,10631437,10631438,10631439,10631440,10631441,10631442,10631443,10631444,10631445,10631446,10631447,10631448,10631449,10631450,10631451,10631452,10631453,10631454,10882007,10882008,10882009,10882010,10882132,10882133,10882134,10882135,10882149,10882150,10882151,10882152,10882153,10882154,10877181,10882284,10882356,10882357,10882358,10882396,10601338,10601339,10601340,10601341,10601342,10590285,10590286,10590287,10590288,10590299,10590300,10590301,10590302,10590303,10590304,10590305,10590306,10590310,10590311,10541367,10541368,10541369,10541444,10521871,10521872,10521873,10532142,10532143,10532144,10532145,10532146,10532147,10532148,10532149,10532150,10532151,10532152,10532153,10532154,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10498368,10498369,10498370,10421498,10421505,10421538,10421540,10420717,10420754,10420755,10420756,10420757,10420758,10420759,10420760,10420761,10420762,10420763,10420764,10420765,10420766,10420767,10498758,10424940,10424941,10424965,10424966,10424967) 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'