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(10939606,10939609,10939726,10939729,10939960,10939963,10939977,10939995,10940003,10940048,10940049,10940108,10940176,10940179,4970921,4970949,4970969,10940475,8066942,8066943,8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067493,8067495,8067497,8067500,8067511,8067516,8067576,8067577,8067578,8067617,8067676,8067716,10938513,10938518,10938521,10938522,10938523,10938524,10938525,10938530,10938531,10938533,10938534,10938539,10938541,10938542,10938632,10938634,10938644,10938645,10938648,4969289,4969296,10939219,10939231,10939232,10939235,10939237,10939238,10939253,4969877,4969882,4969885,4969909,4969913,4969916,4969947,4969949,4969966,4969967,4969976,4969977,4970013,4970014,4970015,4970016,4970017,4970018,4970019,4970020,4970021,4970031,4970040,4970049,4970055,4970057,4970063,4970092,4970100,4970115,4970137,4970138,4970139,4970140,8074856,8074857,8074858,8074859,8074860,8065090,8065091,8065092,8065093,8065094,8074902,8074903,8074904,8074905,8074906,8065303,8065309,8065322,8065339,8065340,8065347,8065348,8065349,8065350,8065360,8065361,8065362,8065363,8065365,8065366,8065367,8065369,8065371,8065384,8065386,8065387,8065388,8065393,8065415,8065418,8065425,8065426,8065438,8065439,8065440,8065441,8065455,8065456,8065457,4967050,4967051,4967052,4967106,4967167,4967168,4967169,4967174,4967175,4967176,4967177,4967178,8065918,4967186,4967187,4967189,4967200,4967202,4967205,4967214,4967215,4967216,4967217,4967218,4967219,4967220,4967221,4967222,4967223,4967224,4967226,4967228,4967235,4967236,4967237,4967238,4967239,4967240,4967241,4967242,4967243,4967244,4967245,4967246,4967247,4967254,4967257,4967258,4967265,4967266,4967267,4967268,4967269,4967273,4967274,4967276,4967277,4967278,4967279,4967280,4967281,4967282,4967296,4967297,4967300,4967304,4967305,4967308,4967309,4967310,4967311,4967312,4967313,4967314,4967315,4967316,4967324,8066139,8066219,8066220,8066221,8066260,8066271,8066280,4967547,8066281,8066282,8066284,4967551,4967553,8066289,4967556,4967559,4967560,4967562,8066297,4967568,8066306,8066307,4967577,4967578,8066314,4967585,8066322,4967595,4967598,4967600,4967601,4967602,4967609,4967612,8066347,4967618,4967619,4967620,4967621,4967622,4967623,4967624,4967625,4967626,4967630,8066364,8066365,4967637,4967641,4967644,8066381,4967653,4967659,4967660,4967661,4967662,4967663,4967664,4967665,4967672,4967673,4967675,4967679,4967685,4967686,4967687,4967688,4967689,4967690,4967691,4967692,4967693,4967694,4967695,8066433,8066434,4967703,4967704,4967705,4967709,4967710,4967711,4967712,4967714,4967720,4967726,4967727,4967728,4967734,4967737,8066502,8066503,8066512,8066513,8066514,8066531,8066532,8066536,8066538,8066572,8066601,8066615,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066673,8066675,8066734,8066737,8066755,8066760,8066761,8066762,8066763,8066764,8066765,8066797,8066807,8066827,8066828,8066874,8066877,8970145,8970150,8064015,8064016,8064017,8064018,8064019,8064020,8064021,8064027,8064030,8064034,8064039,8064040,8064041,8064042,8064043,8064044,8064045,8064048,8064049,8064050,8064051,8064052,8064056,8064059,8064074,8064082,8064097,8064098,8064099,8064103,8064104,8064105,8064106,8064107,8064109,8064111,8064112,8064115,8064121,8064122,8064123,8064124,8064132,8064138,8064139,8064140,8064149,8064368,8064370,8064373,8064374,8064386,8064393,8064394,8064395,8064407,8064410,8064411,8064412,8064413,8064414,8064421,8064424,8064427,8064430,8064431,8064432,8064433,8064434,8064435,8064436,8064437,8064438,8064439,8064442,8064443,8064446,8064447,8064448,8064449,8064451,8064454,8064455,8064456,8064457,8064459,8074411,8074412,8074413,8074414,8074415,8074455,8074456,8074457,8074458,8074459,3655681,3655683,3656442,3656455,8072644,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072659,8072664,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072679,8072684,8072689,8072693,8072694,8072695,8072696,8072697,3656636,3656638,8969907,8969933,8969935,8969948,8969954,8969955,8969956,8969957,8969958,8969959,8969960,8969961,8969962,8970038,10918474,10918475,10918476,10918477,10918478,10918479,10918480,10918481,10918482,10918483,10918484,10918485,10918486,10918487,10918488,10918489,10918490,10918491,10918492,10918493,10918494,10918495,10918496,10918497,10918498,10918499,10918500,10918501,10918502,10918503,10918504,10918505,10918506,10918507,10918508,10918509,10918510,10918511,10918512,10918513,10918514,10918515,10918518,10918519,10918522,10918523,10918526,10918528,10918529,10918530,10918531,10918533,10918535,10918538,10918541,10918542,10918545,10918548,10918549,10918553,10918555,10918556,10918558,10918562,10918566,10918567,10918568,10918570,10918572,10918574,10918575,10918576,10918578,10918579,10918584,10918585,10918587,10918589,10918594,10918595,10918596,10918597,10918598,10918599,10918600,10918601,10918602,10918603,10918604,10918605,10918606,10918608,10918609,10918630,10918637,10918638,10918651,10918652,10918653,10918654,10918655,10918656,10918657,10918658,10918659,10918660,10918662,10918664,10918669,10918673,10918674,10918675,10918677,10918678,10918681,10918682,10918683,10918684,10918686,10918690,10918691,10918692,10918693,10918694,10918697,10918699,10918700,10918709,10918713,10918714,10918717,10918719,10918723,10918725,10918726,10918730,10918731,10918732,10918735,10918742,10918746,10918747,10918748,10918749,10918750,10918751,10918752,10918753,10918754,10918755,10918756,10918757,10918758,10918759,10918760,10918761,10918762,10918763,10918764,10918765,10918766,10918767,10918768,10918769,10918770,10918771,10918772,10918773,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10918783,10918784,10918785,10918786,10918787,10918788,10918789,10918790,10918791,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10918801,10918802,10918803,10918804,10918805,10918806,10918807,10918808,10918809,10918810,10918811,10918812,10918813,10918814,10918815,10918816,10918817,10918818,10918819,10918820,10918821,10918822,10918823,10918824,10918825,10918826,10918827,10918828,10918829,10918830,10918831,10918832,10918833,10918834,10918835,10918836,10918837,10918838,10918839,10918840,10918841,10918842,10918843,10918844,10918845,10918846,10918847,10918848,10918849,10918850,10918851,10918852,10918853,10918854,10918855,10918856,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,10918867,10918868,10918869,10918875,10918876,10918884,10918885,10918886,10918887,10918890,10918891,10918892,10918893,10918894,10918895,10918896,10918897,10918901,10918903,10918904,10918905,10918907,10918908,10918911,10918914,10918919,10918921,10918928,10918929,10918930,10918932,10918938,10918940,10918941,10918948,10918950,10918951,10918952,10918953,10918961,10918962,10918964,10918968,10918974,10918975,10918976,10918977,10918978,10918979,10918980,10918981,10918982,10918991,10918992,10918993,10918994,10918995,10918996,10919000,10919001,10919002,10919003,10919004,10919005,10919006,10919010,10919011,10919012,10919017,10919018,10919023,10919029,10919030,10919036,10919037,10919038,10919039,10919045,10919048,10919049,10919052,10919053,10919054,10919059,10919060,10919062,10919065,10919066,10919067,10919068,10919069,10919070,10919074,10919075,10919076,10919077,10919078,10919079,10919080,10919081,10919082,10919092,10919093,10919094,10919095,10919096,10919097,10919098,10919099,10919101,10919102,10919107,10919108,10919109,10919110,10919111,10919112,10919113,10919115,10919116,10919121,10919122,10919128,10919129,10919130,10919131,10919133,10919134,10919135,10919139,10919141,10919146,10919147,10919148,10919149,10919150,10919151,10919152,10919153,10919154,10919155,10919164,10919165,10919166,10919167,10919168,10919170,10919171,10919172,10919173,10919174,10919175,10919176,10919177,10919178,10624578,10622117,10622119,10622130,10622284,10622543,10620153,10620154,10620156,10620157,10620158,10620159,10620160,10620161,10620163,10620300,10620316,10620371,10620618,10620619,10620668,10621109,10621248,10621250,10621284,10621285,10621287,10621288,10621289,10621290,10621324,10621390,10621391,10621392,10621426,10621450,10621469,10621470,10621471,10621472,10621508,10621531,10621532,10621533,10621591,10621634,10621661,10621667,10621677,10621678,10621679,10621685,10621699,10621710,10621728,10621737,10565158,10566080,10566081,10564555,10564992,10564993,10517143,10517144,10517794,10517795,10420075,10420104,10471199,10471509,10469911,10469923,10470010,10470011,10470014,10470129,10470251) 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'