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(4970736,4970738,8569558,10989324,7065915,7065968,7065986,7065987,7065988,7065989,7065990,7066024,7066025,7066026,7066027,7066029,7066030,7066031,7066056,7066058,7066060,7066061,7066100,7066123,7066127,7066189,7066237,7066238,7066262,7066263,7066264,7066267,8067938,8067939,10939417,10939442,8065838,8065839,8065840,10960474,7065336,10958959,10958971,10931197,8860323,8860384,10958391,10618178,10618179,10618180,10618181,10618265,10618266,10618267,10618271,10618272,10623505,10623508,10619177,10619895,10619896,10616984,10617035,10617068,10617072,10617194,10617212,10954017,10954018,10615002,10620119,10620120,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10615202,10620202,10615232,10615234,10615258,10615327,10615334,10615335,10615363,10615389,10615466,10615468,10615469,10615509,10615556,10615571,10615576,10615578,10615580,10615581,10615592,10615685,10615717,10615718,10615719,10615818,10615822,10615971,10615972,10965514,10615979,10615980,10616007,10616089,10616092,10616175,10616469,10616470,10616471,10616472,10616473,10616576,10616639,10616640,10616641,10616642,10616643,10616644,10616645,10616646,10616647,10616648,10616649,10616650,10616651,10616652,10616655,10616656,10616695,10616704,10616785,10616804,10616842,10616866,10616888,10616911,10616913,10610969,10614020,10614021,10614022,10614024,10614025,10614026,10611048,10614048,10614050,10611053,10611054,10614097,10614099,10614101,10614102,10611126,10611179,9165541,10614210,10614259,10614274,10614282,10614289,10611290,10611291,10614296,10614297,10614314,10611367,10611368,10611369,10611370,10614376,10611388,10611395,10611402,10611415,10611418,10611422,10611434,10611438,10611442,10611448,10611460,10614463,10614464,10611470,10614476,10611476,10611477,10614486,10611494,10611499,10614501,10611511,10611516,10614518,10611533,10611535,10611540,10611545,10559703,10611556,10611557,10611558,10559712,10614588,10614592,10611595,10611602,10611605,10611614,10559766,10611623,10611626,10611629,10614632,10614635,10614636,10611645,10614647,10611647,10614648,10611648,10611653,10611656,10614663,10614664,10614665,10614666,10614667,10611668,10611679,10611684,10611708,10611709,10611710,10611711,10611712,10611713,10611714,10611717,10611718,10614729,10611764,10611778,10611788,9166133,10611801,10611802,10611813,10611819,10611824,10611856,10614858,10614859,10614862,10614864,6666259,10614925,10611965,10611966,10611981,10612035,10612036,10612040,10612051,10612069,10612082,10612083,10612108,10612166,10612168,10612169,10612229,10612230,10612232,10612233,10612273,10609285,10612286,10612291,10609313,10612320,10612321,10612344,10609348,10609350,10609351,10609352,10609355,10612356,10609357,10609358,10609359,10609362,10609363,10609367,10609376,10609385,10609397,10609398,10612408,10609408,10612409,10612410,10612411,10612417,10609432,10609443,10609444,10609452,10612506,10612555,10612556,10612557,10612558,10612620,10609626,8862508,8862509,10609662,8862529,8862530,10609673,10612697,8862567,10609715,10609716,10612757,10609766,10609770,10612772,10612809,10609816,10609818,10609819,10609824,10609826,10609838,10612886,10612888,10612893,10612894,10612895,10612896,10612897,10612907,10612909,10612910,10612911,10612912,10612913,10612914,10612916,10609946,10612958,10609972,10609975,10609976,10610006,10613019,10610046,10613056,10610061,9172407,10613079,10613080,10613081,10613082,10613089,10610098,10613139,10613140,10613142,10613158,10610167,10610168,10613168,10613169,10613171,10613174,10613177,10613178,10613185,10613186,10613193,10613197,10613210,10613211,10613212,10613214,10613220,10613221,10613230,10613231,10610233,10613235,10610236,10613257,10613258,10613259,10610268,10610271,10613278,10613279,10610282,10610289,10610315,10610316,10610318,10610319,10613322,10613328,10613329,10613330,10613331,10613332,10613333,10613334,10613335,10613336,10613337,10613338,10613339,10613340,10613341,10613342,10613343,10613344,10613345,10613349,10613350,10610351,10613352,10613370,10613380,10610396,10610397,10610417,10613440,10613442,10613453,10610466,10613503,10613513,10613514,10613527,10613530,10613531,10613533,10613547,10613553,10613559,10613560,10613561,10613562,10613564,10613565,10613572,10613643,10613646,10613654,10613661,10613662,10613663,10613668,10613669,10613670,10613671,10613672,10613674,10613679,10613680,10613681,10613682,10613683,10613686,10613689,10613690,10613691,10613710,10613711,10613712,10613719,10613720,10613732,10613733,10613736,10613739,10613751,10613752,10613783,10613804,10613805,10613806,10610836,10613844,10610847,10610850,10610901,10610908,10610917,10610918,10610919,10610920,10610921,10610922,10610923,10610924,10610942,10610958,7055465,7055466,9169318,9169320,9169321,9169322,7055491,9169350,7055528,7055529,9185373,7055540,7055541,7055546,7055547,9169428,9169445,9169446,9169571,9169639,9169660,9169672,9169695,9169708,9169750,9169791,9161792,9169849,9177901,9169902,9169903,10514037,10514038,9178427,10419258,10419259,10419260,10419262,10419270,9168349,10417273,10417274,10417275,10417276,10416281,10417287,10417289,10417291,10417292,9168382,9168383,10417310,10415313,10415314,10418335,10419358,10419360,10419362,10419364,10419365,10419370,9168455,10417398,10417399,10417400,10417401,10417402,10417405,10417406,10417407,10417408,9168494,9168510,10419437,10419438,10419439,9168522,10416460,10419470,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10416482,10419483,10416483,10419484,10416484,10419485,10416485,10419486,10418486,10416486,10419487,10416487,10416488,10419488,10419489,10418489,10419490,10419491,10419492,10418493,10418495,10418496,10418497,10418498,10418499,10418503,10418504,10417531,10417532,10417533,10417537,10415539,10415540,10415541,10415542,10417565,10419569,10416569,10416570,10416571,10416572,10416573,10416574,10416575,10416576,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10419602,10416602,10419603,10416603,10419604,10416604,10419605,10416605,10419606,10416606,10419607,10416607,10419608,10416608,10419609,10417609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10419635,10419636,10416638,10416639,10419640,10419641,10419642,10419643,10419644,10419645,10419647,10419650,10419651,10419653,10419654,10419655,10419658,10419659,10419661,10419662,10419663,10419664,10419665,10419666,10419667,10415673,10415682,10416694,10415694,10415695,10415697,10415699,10417700,10415701,10415703,10415704,10415705,10415706,10415707,10415708,10415709,10415710,10415711,10415712,10415713,10415714,10415715,10415716,10418735,10418736,10418737,10419759,10419760,10419761,9168840,10416775,9168872,10419811,10416813,9168897,9168900,10415839,9168924,9168925,9168926,9168927,9168936,10418864,10418865,10418877,9168963,9168965,9168966,9168969,10418891,10418897,10418899,10418902,10418904,10418905,10418906,10415910,10415911,10415913,10415914,9169014,10418948,10418954,10418958,10418959,10418960,9169066,10418992,10418993,10417025,10419026,10417026,10416027,10417027,10417028,10416029,10417029,10417030,10419031,10416031,10417031,10417032,10416033,10417033,10417034,10417036,10417037,10417038,10417039,10417040,10417043,10417044,10417045,10418047,10417048,10417049,10417051,10417052,10416056,10418060,10418068,10418076,10418077,10418078,10418079,9169181,10416114,10416117,10419145,10419146,10419147,10416182,10416183,10416185,10416186,10416187,10416189,10416190,10416191,10416192,10416193,10468916,10468921,10471014,10471015,10471068,10469137,10469138,10469234,10469259,10469263,10469264,10469265,10469381,10469663,10469670,10469671,10469672,10469673,10469674,10469675,10469676,10469677,8916796,8916797,9167540,9167638,9167681,9167686,10468294,9167750,9167752,10468337,10468338,10468339,10468340,9167770,9167781,9167782,9167791,9167810,9167811,9167848,9167857,9167859,9167860,9167861,9167871,9167994,9168023,9168024,9168072,9168118,10470721,10470722,9168168,9168210,9168273,9168284,9168285,9168286,9168287,9168288,9168289,9168290,9168291,9168292,9168293,9168294,10628152,10628153,10628371,10632010,10163717,10627712,10161818,10161827,10161833,10161917,10161948,10161976,10162074,10162127,10162128,10162129,10162130,10162237,10162851,10167916,10631455,10631456,10626509,10631794,10631795,10579825,10527750,10521871,10521872,10521873,10521879,10521880,10528238,10522838,10524923,10424392,10424393,10424396,10424403,10424404,10424408,10424412,10424418,10424423,10424426,10424429,10424434,10421485,10421494,10421497,10421498,10421499,10421500,10421501,10421502,10421503,10421504,10421508,10421510,10421513,10421514,10421515,10421516,10421517,10421518,10421519,10421520,10421521,10421522,10421523,10421524,10421525,10421526,10421527,10421528,10421529,10421530,10421531,10421532,10421533,10421534,10421535,10421536,10421537,10421551,10477680,10477681) 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'