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(10939612,7076004,7076018,7076066,10989163,10989192,7068612,7068692,7068693,7068694,7068702,10940338,7068717,7068718,7068719,10940344,10940349,7068909,10940532,8066955,8066956,8066957,8066958,7073983,7073984,7073985,7073986,7073987,7073994,7073997,7073998,8067207,8067260,8067262,8067487,7074562,7074574,7074590,7074606,7074621,7074627,7074630,7074636,7066656,7066663,7074688,7074716,7074719,7074726,10437621,10437622,7074818,7074839,7074840,7074853,7074912,7074949,7074976,7074994,7074995,10987836,10987837,10987838,10987839,10987840,10987841,10987842,10987843,10987844,10987845,10987846,10987847,10987848,10987849,10987850,10987851,10987852,10987853,10987854,10987855,10987856,10987857,10987858,10987859,10987860,10987861,10987862,10987863,10987864,10987865,10987866,10987867,10987868,10987869,10987870,10987871,10987872,10987873,10987874,10987875,10987876,10987877,10987878,10987879,10987880,10987881,10987882,10987883,10987884,10987885,10987886,10987887,10987888,10987889,10987890,10987891,10987892,10987893,10987894,10987895,10987896,10987897,10987898,10987899,10987900,10987901,10987902,10987903,10987904,10987905,10987906,10987907,10987908,10987909,10987910,10987911,10987912,10987913,10987914,10987915,10987916,10987917,10987918,10987919,10987920,10987921,10987922,10987923,10987924,10987925,10987926,10987927,10987928,10987929,10987930,10987931,10987932,10987933,10987934,10987935,10987936,10987937,10987938,10987939,10987940,10987941,10987942,10987943,10987944,10987945,10987946,10987947,10987948,10987949,10987950,10987951,10987952,10987953,10987954,10987955,10961955,10987956,10987957,10987958,10987959,10987960,7075418,8068398,8068399,8068400,8068401,8068402,8068403,8068404,8068405,10962199,8068406,8068407,8068408,8068409,8068410,8068411,8068412,8068413,8068414,8068415,8068416,8068417,8068418,8068419,8068420,8068421,8068422,8068423,8068424,8068425,8068426,8068427,8068428,8068429,8068430,8068431,8068432,8068433,8068434,8068435,8068436,8068437,8068438,8068439,8068440,8068441,8068442,8068443,8068444,8068445,8068446,8068447,8068448,8068449,8068450,8068451,8068452,8068453,8068454,8068455,8068456,7067627,7067685,7067686,8068606,8068613,8068614,8068663,8068681,7067794,8068692,8068693,8068736,8068746,8068754,7067906,7067922,7067923,7075932,10972791,10972792,10972793,7072140,7072141,7072142,7072144,7072285,10973187,7072533,8075307,8075308,8075309,8075310,10932143,10960837,8066420,8066421,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066429,8066430,8066431,8066432,8066433,8066434,8066435,8066436,8066437,8066438,8066439,8066440,10961250,8066559,8066560,8066578,8066579,8066596,8066597,8066639,8066669,8066670,8066699,8066700,8066701,8066702,8066703,8066721,8066722,8066723,8066724,8066725,8066759,8066779,8066780,8066781,8066791,8066792,8066793,8066794,8066821,8066840,8066841,8066854,8066870,8066892,8066893,8066894,7070943,7070945,7070946,7070951,7070952,7070965,7070967,7070975,7070982,7070988,7070991,7070992,7071004,7071005,7071006,7071007,11048948,7071058,7071059,7071060,7071100,10942811,7071230,7071362,7071368,7071369,7071373,7071377,11049324,10972128,7071521,10959233,11049492,7071612,7071613,7071614,7071621,7071634,7071635,7071642,7071650,7071656,7071657,10943287,7071670,7071671,7071679,7071680,7071687,7071882,7068945,3655640,10940728,10940744,10940775,10940807,7069253,7069260,7069261,7069290,7069291,7069302,7069305,7069312,7069313,7069331,7069337,7069379,7069380,7069394,7069397,7069406,7069407,7069438,10970152,3656301,10941706,10941786,10941819,10941874,10941884,10941958,10941979,10941984,3656943,10942043,7070565,10942296,7070680,7070766,10942420,7070815,11048719,7070875,7070889,7070890,7070891,7070892,7070920,7070921,7070922,7070923,7070924,10923472,10923473,10923474,10923475,10618016,10923556,10923557,10923577,10923578,10923579,10923587,10923588,10923589,10923590,10923613,10923614,10918718,10623291,10623292,10623293,10623294,10623295,10618370,10623491,10919485,10919486,10919487,10919488,10919489,10919490,10919491,10919492,10968647,8071012,8071013,8071014,8071015,8071016,8071017,8071018,10919823,10619332,10619333,8071201,8071202,10925432,10925433,10925446,10925447,10925448,10925457,10621981,10621986,10621996,10622010,10622012,10953681,10622032,10622033,10622049,10622050,10622101,10622102,10622113,10622114,10622121,10622126,10622127,10617157,10922722,10922769,10922770,10922787,10922788,10922815,10922816,10922917,10922918,10922934,10922935,10922936,10922954,10922955,10922956,10922985,10917991,10927996,10927997,10927998,10927999,10928000,10928001,10923018,10928058,10923081,10928119,10928120,10923207,10923224,10918270,10923270,10918271,10923271,10923272,10923333,10923340,10923471,8570013,8570043,10615103,10615127,10615130,10615131,8570086,10615313,10615318,10615319,10615374,10615375,10615376,10615377,10615378,10930741,10620862,10615926,10621144,10926762,10926763,10621424,10621430,10621431,10621432,10621433,10621434,10621439,10621440,10621441,10621460,10621464,10621480,10621513,10621514,10621537,10621538,10621539,10621540,10621610,10621611,10621612,10621613,10621614,10621616,10621617,10621618,10621630,10621646,10621669,10621676,10621745,10559298,10559299,10559300,10559301,10559302,10559303,10559304,10559305,10559306,10559307,10559308,10559309,10559310,10559311,10559312,10559313,10559314,10559315,10559316,10559317,10614228,7059759,10611267,10614343,7059867,8864402,8864404,10559701,10611918,10611919,10611920,10611921,10611937,10611938,10611939,10611940,8864808,7057495,7057517,7057637,7057677,7057678,7057720,7057721,7057724,7057725,7057726,7057727,7057728,7057729,7057730,7057731,10609305,10609331,7057867,7057868,7058030,10557979,10561087,10561088,10561089,10561090,10561091,10561092,10561093,7058683,8863100,8863101,8863118,10558438,10558439,10558440,8863153,8863157,8863158,8863169,8863173,10613350,7058864,7058873,7058881,7058943,10613475,10613505,10613523,7059128,7059160,8863603,8863604,8863703,8863713,8863716,8863814,4974191,10511465,10511466,10511467,10511468,10511469,10511470,10511471,10511472,10511473,10511474,10511475,10511476,10511477,10511478,10511479,10511480,10511481,10511482,10511483,10511484,10511485,10511486,10511487,10511488,10511489,10511490,10511491,10511492,10511493,10511494,10511495,10511496,10511497,10511498,10511499,10511500,10511501,10511502,10511503,10511504,10511505,10511506,10511507,10511508,10511509,10511510,10511511,10511512,10511513,10511514,10511515,10511516,10511517,10511518,10511519,10511520,10511521,10511522,10511523,10511524,10511525,10511526,10511527,10511528,10511529,10511530,10511531,10511532,10511533,10511534,10511535,10511536,10511537,10511538,10511539,10511540,10511541,10511542,10511543,10511544,10511545,7055965,7055966,10513628,10513629,10515672,10515673,10515908,10515910,10515911,10515912,7056578,2809332,2809394,7056976,7057445,10419223,10419224,10419225,10419237,10419238,10419240,10419257,10419258,10417270,10417271,10419285,10419295,10419296,10419298,10419347,10417399,10417470,8918230,4973441,4973442,4973443,10419560,10419180,4971527,4971528,4971642,4971651,10463587,10463588,10463589,10463590,10463591,10463592,10463593,10463594,10463595,10463596,4972010,4972011,4972012,4972013,4972140,10467919,10467928,10467939,4972220,4972221,10467946,10469952,4972230,4972232,10467966,4972256,4972263,4972264,10467988,10468021,10468100,8917180,8563467,8917216,4972434,4972456,10468215,10468216,10627969,10628172,10628787,10628806,10628845,10628846,10628847,10628848,10628849,10627017,10627018,10627024,10627033,10627034,10627035,10627036,10632047,10632048,10632049,10632050,10632051,10632052,10632053,10632054,10632055,10632056,10627061,10632098,10632106,10632107,10627402,10627780,10627781,10627784,10627785,10627788,10627791,10627792,10627804,10627809,10627821,10627827,10627831,10627832,10627833,10627834,10627835,10627836,10627837,10627838,10627839,10627840,10627841,10627842,10627843,10627844,10627845,10627846,10627847,10627848,10627849,10627850,10627851,10627852,10627853,10627854,10627855,10627857,10627858,10627866,10627867,10627879,10627887,10627888,10627889,10627890,10627891,10627892,10627901,10627902,10627903,10627904,10627907,10627908,10627911,10627914,10627917,10627922,10627923,10627924,10627925,10627926,10627931,10627932,10630044,10630298,10630307,10630308,10630309,10630340,10630596,10630597,10630598,10630682,10630683,10630684,10630835,10630836,10630837,10630883,10625927,10630944,10630946,10630947,10626121,10626122,10626311,10626312,10626319,10626320,10626321,10626322,10626323,10626331,10631455,10571688,10568987,10521190,10521920,10420403,10420405,10420407,10421479,10421939,10421082,10421108,10421120,10421128,10421133,10422168,10422170,10422174,10422176,10422177,10421208) 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'