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(8911630,8911935,8911952,8911953,8911954,8911955,8911959,8911960,8911961,8911962,4970736,4970738,8569558,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,8573334,8573335,8573336,8573337,10225924,8910466,8067938,8067939,8909071,10101326,10101448,10101459,10101460,10101486,10101487,10101517,10101524,10101555,10196326,10196489,7065336,10102076,10102077,8910063,8910064,8910066,8910067,8910080,8834762,8834763,10194276,8907923,10100116,10194865,10194877,10931197,8905582,8905646,8905653,8905691,8905716,8905717,8905718,8905719,8905720,8905721,8905852,8906027,8906769,8906770,8906771,8906863,8906909,8860323,8907026,8860384,10618178,10618179,10618180,10618181,10618265,10618266,10618267,10618271,10618272,10623505,10623508,10619177,8904798,8904914,8904932,10619895,10619896,8905329,8905374,10616984,10617035,10617068,10617072,10617194,10617212,10189922,10189923,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,8574517,10615972,8574521,10615979,10615980,10616007,10616089,10616092,10616175,10188520,10616469,10616470,10616471,10616472,10616473,8575084,10616576,10616639,10616640,10616641,10616642,10616643,10616644,10616645,10616646,10616647,10616648,10616649,10616650,10616651,10616652,10616655,10616656,10616695,10616704,10201837,10950755,10616785,10616804,10616842,10616866,10616888,10616911,10616913,10614020,10614021,10614022,10614024,10614025,10614026,10614048,10614050,10614097,10614099,10614101,10614102,9165541,10614210,10614259,10614274,10614282,10614289,10614296,10614297,10614314,10614376,10614463,10614464,10614476,10614486,10614501,10614518,10559703,10559712,10614588,10614592,10559766,10614632,10614635,10614636,10614647,10614648,10614663,10614664,10614665,10614666,10614667,10614729,9166133,10614858,10614859,10614862,10614864,6666259,10614925,8549450,10611965,10611966,10611981,10612035,10612036,10612040,10612051,10612069,10612082,10612083,10612108,10612166,10612168,10612169,10612229,10612230,10612232,10612233,10612273,10612286,10612291,10612320,10612321,10612344,10612356,10612408,10612409,10612410,10612411,10612417,10612506,10612555,10612556,10612557,10612558,10612620,8862508,8862509,8862529,8862530,10612697,8862567,10612757,10612772,10612809,10612886,10612888,10612893,10612894,10612895,10612896,10612897,10612907,10612909,10612910,10612911,10612912,10612913,10612914,10612916,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,10612958,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10613019,10613056,9172407,10613079,10613080,10613081,10613082,10613089,10613139,10613140,10613142,10613158,10613168,10613169,10613171,10613174,10613177,10613178,10613185,10613186,10613193,10613197,10613210,10613211,10613212,10613214,10613220,10613221,10613230,10613231,10613235,10613257,10613258,10613259,10613278,10613279,10613322,10613328,10613329,10613330,10613331,10613332,10613333,10613334,10613335,10613336,10613337,10613338,10613339,10613340,10613341,10613342,10613343,10613344,10613345,10613349,10613350,10613352,10613370,10613380,10613440,10613442,10613453,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,10613844,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,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,10416482,10419482,10419483,10416483,10419484,10416484,10419485,10416485,10419486,10416486,10418486,10416487,10419487,10416488,10419488,10419489,10418489,10419490,10419491,10419492,10418493,10418495,10418496,10418497,10418498,10418499,10418503,10418504,10417531,10417532,10417533,10417537,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,10416694,10417700,10418735,10418736,10418737,10419759,10419760,10419761,9168840,10416775,9168872,10419811,10416813,9168897,9168900,9168924,9168925,9168926,9168927,9168936,10418864,10418865,10418877,9168963,9168965,9168966,9168969,10418891,10418897,10418899,10418902,10418904,10418905,10418906,9169014,10418948,10418954,10418958,10418959,10418960,9169066,10418992,10418993,10417025,10417026,10419026,10417027,10417028,10417029,10417030,10417031,10419031,10417032,10417033,10417034,10417036,10417037,10417038,10417039,10417040,10417043,10417044,10417045,10418047,10417048,10417049,10417051,10417052,10418060,10418068,10418076,10418077,10418078,10418079,9169181,10419145,10419146,10419147,10468916,10468921,10471014,10471015,10471068,10469137,10469138,10469234,10469259,10469263,10469264,10469265,8549936,8549937,8549939,8549951,8549952,10469381,8549996,8550030,8550031,8550058,8550070,8550073,8550145,8550147,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,9183980,9167994,9168023,9168024,9168072,9168118,10470721,10470722,9168168,9168210,9168273,9168284,9168285,9168286,9168287,9168288,9168289,9168290,9168291,9168292,9168293,9168294,10628152,10628153,10628371,10874951,10874953,10874954,10874992,10875004,10875005,10875006,10875007,10875008,10875009,10875010,10875011,10875012,10875014,10875015,10875016,10875017,10875018,10875019,10875020,10875021,10875022,10875023,10875024,10875025,10875026,10875027,10875028,10875032,10875033,10875034,10875035,10875036,10875037,10875038,10875039,10875040,10875041,10875042,10875043,10875044,10875045,10875046,10875047,10632010,10163717,10183898,10183899,10627712,10161818,10161827,10161833,10161917,10161948,10161976,10162074,10162127,10162128,10162129,10162130,10162237,10162851,10167916,10631455,10631456,10626509,10631794,10631795,10590192,10579825,10527750,10521871,10521872,10521873,10521879,10521880,10528238,10522838,10524923,10425238,10424392,10424393,10424396,10424403,10424404,10424408,10424412,10424418,10424423,10424426,10424429,10424434,10498368,10498369,10498370,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,10483210,10486535,10486536,10486542,10486545,10486549,10486554,10486556,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'