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(10861376,10861377,10861403,10861509,10861510,10861512,10848676,10848677,3228992,8569558,3229120,3229121,3229122,3229123,7066018,10862978,10861021,10861022,8630433,10939426,7201187,7201335,7201337,10866688,10866689,10866690,8595230,8595236,10866977,10866981,10866982,10866983,10866984,10866985,10866992,10866993,10859436,10859438,10859439,10859440,10859441,10859442,10859443,10859444,10859445,10859446,10859447,10859448,10859449,8910078,8910239,8910240,8910241,8910253,8910254,8910255,4430165,7201060,10866149,10863382,10863386,10863391,10863409,10863414,10863415,10863416,10863417,10863418,10863419,10863420,10863421,10863422,10863423,10863427,10863428,10863429,10863432,7198687,8908503,8625285,8625286,8625288,8625290,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,8625323,8625326,10863985,10863986,10863987,8625349,8625350,8625351,8625359,8625360,8625363,8625365,8625367,8625370,10864148,10856310,7199438,7199439,10101493,11048458,11048459,10853747,10853753,10854051,10854056,10854103,10854139,10854141,11046633,11046634,11046635,10838902,10838903,8624424,10617047,8905237,8905535,8905858,3233290,8905969,8905971,8905972,10615092,10615317,10615320,10615321,10615322,10615323,10615324,10426216,10426217,10426334,10426370,8633951,8633952,8611345,8611346,8611347,8611388,10616853,10616854,10616911,10614048,10611053,10611054,10611226,10614236,8864195,10611417,10614487,10614488,10611519,10611666,10614749,10609276,10609277,10609298,10612381,10609631,10609632,10609633,8851873,8566633,8566712,10612885,10612886,10612887,10612888,10612889,10612890,10612891,10612892,10612893,10612894,10612895,10612896,10612897,10612898,10612899,10612900,10612902,10612904,10612905,8852332,8852368,8852369,8852370,8852371,10613350,10610675,10610955,10610958,9169464,9169465,10117944,9169826,10118129,6674152,10118213,10118354,10118355,10118357,10118358,9912766,10118910,10419261,10415327,10415328,10415344,10417391,10417392,10417393,10415402,10415403,10415404,10415405,10415406,10416543,10419564,10419565,9168696,9168697,9168698,9168699,9168700,10417649,10417650,10418734,9168861,10419852,10419853,10419854,10419855,10419856,10419857,10419858,10419859,10419860,10419861,10419862,10419863,10419865,10419867,10419868,10419869,10419870,10419871,10419872,10419873,10416919,10416920,10416921,10416922,10416923,10416924,10416925,10416926,10416928,10416929,10416930,10416932,10416933,10416934,10416935,10416936,10416937,10416938,10416939,10416940,10416941,10416942,10416943,10416944,10416945,10416946,10416947,10416948,10416949,10416950,10416951,10416952,10416953,10416954,10416955,10416956,10416957,10416958,10416959,10416960,10416961,10416962,10416963,10416964,10416965,10416966,10416967,10416968,10416969,10416970,10416971,10416972,10416973,10416974,10416975,10417979,9169102,10419067,10117438,10117456,10117462,9182547,8549824,8549889,8549891,8549892,10469519,10469520,10469571,8550163,8916775,8916776,8916777,8916793,10469936,10469938,10469939,10469940,10469941,10469942,10469943,10469944,10469945,10469946,9167858,10470631,10468766,10468769,10468770,10468771,10468772,10468773,10468774,10468775,10468776,10468777,10468778,10468779,10468780,10427669,10427670,10427671,10889175,10885312,10885313,10887714,10887883,10887949,10887951,10887954,10887955,10888050,10888185,10888190,10888191,10888192,10888193,10888196,10888348,10888351,10888352,10888353,10888356,10888357,10883444,10162131,10162161,10162162,10162163,10162164,10877176,10877177,10887377,10887388,10887435,10887453,10602220,10608383,10602486,10602530,10602534,10602557,10602559,10602590,10602594,10602622,10602635,10602639,10602647,10602714,10604002,10604003,10604067,10604200,10601559,10601566,10604692,10601847,10601854,10601855,10601859,10601861,10601867,10601872,10601878,10601887,10601888,10601904,10508181,10508182,10508350,10411385,10409465,10409466,10409467,10409468,10486324,10486325,10413897,10413898,10413899,10413900,10413901,10413902,10413903,10413904,10413905,10413906,10413907,10413908,10413909,10413910,10413911,10413912,10413913,10413914,10414826,10406941,10406942,10415052,10415053) 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'