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(10870507,10870509,7076288,7076291,7076293,8574485,8574504,8574505,8574512,10870628,8574528,10870678,8631042,8631065,10870726,8631101,8631103,8631104,8631122,4970738,3229077,3229078,10862068,10862069,8631570,8631574,9215675,9215683,8631759,9215775,9215783,9215818,9215820,10849456,9215822,9215823,10849458,9215825,9215826,9215859,9215870,8631899,8631981,10849693,10849694,10849695,10849696,10849698,10849699,10849700,10849704,10849705,8632283,8632284,8632291,8632292,8632350,8632351,9216513,9216514,8632543,8629604,8629630,3227401,10860276,10860327,8629754,8629755,8629756,10860634,10860635,10860636,10860637,10860638,10860708,10860709,10860710,10860711,10860725,10860726,10860727,10860728,10860731,10860742,8630139,10860833,10860834,10860835,8630194,10860836,10860837,10860871,10929897,10860965,10870024,10870025,10870026,8630438,8630441,10870111,10861120,10861121,10447777,10447781,10447787,10447796,10861216,10447806,8627635,8627636,8627637,8627638,8627639,8627640,8627641,8627642,8627643,8627644,8627645,8627646,8627647,8627648,8627649,8627650,8627651,8627652,8627653,8627654,8627655,8627656,8627657,8627658,8627659,8627660,8627661,8627662,8627663,8627664,8627665,8627666,8627667,8627668,8627669,8627670,8627671,8627672,8627673,8627674,8627675,8627676,8627677,8627678,8627679,8627680,8627681,8627682,8627683,8627684,8627685,8627686,8627688,8627689,8627690,8627691,8627692,8627693,8627715,8627729,8627824,10842937,10842940,8627836,8627839,8627840,8627841,8627844,8627845,8627846,8627850,8627851,8627857,8627860,8627861,10866506,10866548,10843024,10843035,10972999,10973020,10973021,10973022,10973030,10843100,7201594,7201595,7201600,7201616,7201617,7201619,7201620,10960067,7201633,8628042,10843157,10843158,10858729,10858730,10858731,10858732,10858733,10858734,10858735,10858736,10858737,10858738,10858739,10858740,10858741,10858742,8595165,8595166,8595167,8595168,8595170,8628235,8628236,8628266,7064652,7201901,10843427,10866962,10866965,8628372,8628376,8628378,8836250,8836251,7202079,8628484,3899383,3899384,7202149,7202184,7202324,7202325,7202326,7202327,7202328,7202329,10999819,10867480,10859645,10859646,11000066,11000067,11000068,11000069,11000070,11000071,11000072,11000093,11000094,8629103,8629105,9794594,8629282,8629283,8629284,3237362,8626618,8626761,8626765,10958955,10958956,3927786,3927788,8910604,8910605,10866031,10102876,10102922,10972491,10972492,10972496,10972520,10972531,10972563,10972573,10972582,7201153,7201154,3925514,8624838,8624839,8624840,8624841,8624847,10839994,8625079,8625080,8625081,8908495,8908496,7198699,8625114,8625115,8625116,8625117,8625118,8625122,8625123,8625125,8625126,8625130,8625132,7198750,7198753,7198755,7198756,7198768,10996219,10996220,10996221,10996261,10996269,10996272,10996276,10996284,10996296,7199006,7199007,7199015,7199016,7199018,7199019,8625467,8625468,8625469,8625470,8625473,8625480,7199135,8909075,8909076,10941691,10941693,10941695,10941697,10941698,10941755,10941758,10941762,10941770,8625817,8557219,7199540,7199541,7199542,8625988,8625989,8625990,8625991,8625992,8625993,8626014,8626118,8626119,8626124,8626188,10856880,10856881,10856882,10856883,10856884,10856885,10856886,10856892,10856898,10856899,10856900,10856901,10856903,10856905,10856906,10856907,8626312,8626314,8626319,7070793,8626469,10857122,8557820,10993663,7196455,7196456,7196457,7196458,7196459,7196461,7196462,7196463,7196464,7196465,7196467,7196469,7196525,3924104,8907292,8907436,10995359,10995360,10995364,10995379,10995380,8624370,8624373,8624376,8624428,11047490,8624503,8634615,8634616,8634617,8634618,8634619,8634620,8634621,8634622,8634623,8634626,8634627,8634628,8634630,8634635,8634639,8541714,8541719,8541721,10993358,10993359,10993362,10993373,10993384,10993386,10993387,10993388,10993389,10993390,10993400,10993412,10993414,10993415,10853139,8542369,10993600,8632591,8632592,10951576,8632616,8632617,10951688,10951696,10951701,10951702,10951703,10615179,10615229,8632860,8632861,8632877,8633184,8633206,8633215,8633217,8633219,8633222,8633231,8633232,8633233,8633236,10615709,10615711,10991487,10991498,10991503,10991504,10991516,10991580,10991581,10991582,10991583,10991584,10991585,8633550,8633566,10991720,10991727,10991735,10991736,10991745,10991893,10991899,10991900,10991901,10991902,10991904,10991948,10991973,10991983,10991984,10991990,10991998,10992001,10992003,10992005,8611374,8611382,10992235,10992236,10992237,10992240,10992241,10992286,8611468,10992318,10992319,10992326,10992377,10992379,10992383,8541211,8634401,8634402,8634403,8634404,8634405,8634443,10616888,10616907,10992578,10992579,8634541,8634542,8634543,8634544,8634545,8634546,10613973,10613974,10613988,10614039,10614054,10614260,10614261,7059883,10714271,10614495,10122209,10612002,8565856,9187453,10612137,10609285,8851764,8851765,9914154,9914168,9914226,10609707,9914266,9914267,8851892,10609845,9188357,9188364,9188365,9188366,10610030,9188370,9188379,9188394,8852289,8852290,8852291,8852292,8852293,8852294,8852295,8852296,8852297,8852298,8567170,10613434,10613547,9188968,9189014,10610697,6677249,6677262,6677263,6677267,6677275,6677276,6677277,6677279,10610777,10613797,10613812,10613813,10613814,10613815,8567674,8567675,8567676,8567677,8567682,8567702,8567703,8567712,10613889,10613890,10613898,10613922,10613923,8567763,9185613,9185627,10117890,10117891,9185718,9185722,9185727,9185742,9185743,10513559,9185754,9185795,9185796,9185808,9185829,9185830,9185831,7015486,9185832,7015487,7015488,7015489,9185835,7015490,9185836,7015491,9185854,9185855,9185863,9185864,9185892,9185895,9185908,9185910,9185916,9185930,9185938,9186012,10118214,8849898,9186127,9186182,9912438,10516142,9186354,9186357,9186358,9186359,9186360,9162434,9912661,9912662,9912676,9912747,9186564,9912773,8850571,10118965,9186772,9186773,9186774,9186778,9186779,9186780,9186784,9186787,9186797,9186798,9186799,9186801,10516678,10119436,10119437,4973258,10415342,10419450,10419469,10415793,8848715,10419817,10419846,10419849,9169052,9169055,9169066,10420013,9169232,6670769,6671134,6671137,6671139,10469573,9175184,9207302,9175430,8550664,8855372,8855373,8855374,9175979,9192065,9192232,10903543,10903561,10903571,10903572,10903654,10903655,10903656,10903657,10903658,10903659,10903676,10888704,10903708,10903709,10903710,10903711,10903712,10903713,10903714,10903830,10903835,10903837,10903838,10903841,10904004,10885166,10905188,10905189,10877492,10627145,7001079,10627580,10627588,10627630,10908257,10888339,10883402,10883416,10888437,10905547,10905548,10630047,10630068,10630070,10630078,10630089,10630146,10905701,10905702,10905703,10167042,10167064,10167065,10167066,10167067,10167069,10886058,10886061,10172074,10167076,10172080,10167083,10167084,10172089,10886078,10886079,10886080,10886081,10886082,10167094,10886083,10886084,10167096,10886085,10886086,10886087,10886088,10886089,10886090,10886091,10167104,10167107,10167115,10167120,10886162,10886208,10167317,10886311,10886312,10167326,10167333,10167334,10891379,10891382,10886397,10886399,10886400,10172413,10886436,10886437,10886514,10886515,10886516,10886569,10886570,10886589,10886613,10886655,10886656,10626238,10876751,10626241,10626242,10626247,10886769,10626259,10626292,10626293,10886804,10886816,10886819,10886820,10886843,10886847,10626378,10626379,10626448,10877124,10887171,10887198,10887460,10887461,10887462,10601398,10598656,10598723,10647540,10647551,10647564,10651421,10529342,10541368,10541369,10549720,10548065,10528110,10528111,10528112,10528113,10528114,10528139,10528143,10528151,10528160,10528181,10548311,10548312,10522342,10522343,10522347,10522448,10522452,10522453,10522614,10522615,10422279,10422316,10422364,10421947,10421948,10421949,10421950,10422203,10422205,10407239,10407240,10407241,10407242,10407244,10407245,10407246,10407250,10407251,10485913,10413269,10413270,10413271,10413272,10413273,10413274,10413275,10413276,10413277,10413278,10413279,10413280,10413281,10413282,10413283,10413284,10409349,10411791,10411792,10411793,10411794,10411795,10411796,10411797,10411810,10411812,10411813,10411814,10484501,10484502,10411956,10414077,10414078,10414625,10487515,10487523,10414876,10414877,10414878,10414879,10414880,10414881,10487547,10414941,10414942,10414943,10414944,10414945,10414964,10415125,10415126,10415184) 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'