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(4970705,8569474,4970736,4970738,4970761,8569558,7065953,7065968,7066009,7066018,7066085,7066122,7066123,7066130,7066131,7066132,7066133,7066134,7066222,7066260,7066267,8067906,8067907,8067908,8067917,8067934,10939397,10939415,10939417,7064502,7064503,7064504,4967032,8065812,8065813,8065824,8065825,8065834,8065835,8065838,8065839,8065840,8065843,7065342,10933041,10933050,10933060,7065915,11047588,10941948,11048363,11048370,8073547,8073548,8073549,10618178,10618179,10618180,10618181,10618182,10618183,10618267,10618269,10618300,10618301,10623508,8070774,8070775,8070776,8070777,8070778,10619177,10925401,10619895,10619896,10616984,10617017,10617019,10617020,10622030,10622031,10622042,10622055,10617068,10617072,10617220,10622266,10622267,10617377,10617384,10617403,10617404,10617405,10617409,10617417,10617422,10617423,10617428,10617429,10617430,10617431,10617432,10617433,10617434,10617435,10617438,10617442,10617443,10617445,10617462,10617474,10622536,10617958,10614975,10614977,10614978,10614979,10615002,10615202,10615237,10615242,10615243,10615244,10615334,10615389,10615431,10615450,10615462,10615463,10615464,10615466,10615467,10615468,10615469,10615470,10615556,10615574,10615575,10615576,10615578,10615677,10615678,10615698,10615699,10615700,10615701,10615702,10615703,10615704,10615705,10615718,10615720,10615721,10615722,10615738,10615818,10615822,10615867,10615869,10616007,10616044,10616045,10616062,10616064,10616065,10616066,10616070,10616080,10616089,10616092,10616175,10616572,10616576,10616615,10616629,10616630,10616631,10616632,10616633,10616634,10616635,10616636,10616637,10616638,10616644,10616655,10616704,10616804,10616842,10616854,10616888,10616911,10616913,10610964,10610969,10610970,10610971,10610972,10610973,10610974,10610975,10610976,10610977,10610978,10610984,10610985,10610990,10610991,10610994,10614021,10614048,10611048,10614050,10611053,10611054,10614097,10614099,10614100,10614101,10614102,10611110,10611112,10611126,10614166,10614174,10614176,10611179,10614181,10614204,10614210,10614211,10614213,10614214,10611219,10611228,10614259,10614289,10614296,10614297,10614314,10614354,10611357,10611367,10611368,10611369,10611370,10614376,10611388,10611395,10611402,10611415,10611418,10611422,10611423,10611434,10611438,10611441,10611442,10611445,10611448,10614452,10614453,10614454,10614455,10614456,10614457,10611460,10614463,10614464,10611470,10611476,10611477,10611494,10611499,10614501,10611508,10611511,10614515,10611516,10614524,10614532,10611533,10611535,10611540,10611545,10611551,10611556,10611557,10611558,10611559,10614588,10614592,10611595,10611602,10611603,10611605,10611610,10611614,10559766,10611623,10611626,10611629,10614633,10611645,10611647,10614648,10611648,10611653,10611656,10614663,10611668,10611670,10611679,10611684,10611699,10611700,10611701,10611702,10611703,10611713,10611715,10614729,10611742,10611743,10614749,10614752,10611761,10611788,10611801,10611802,10611815,10611819,10611844,10611845,10611856,10614858,10614859,10614862,10614940,10614941,10614942,10614943,10611981,10611983,10611985,10609034,10609035,10612035,10609036,10612036,10612051,10612069,10609070,10609071,10609072,10609073,10609074,10609075,10612075,10609076,10612076,10609077,10609078,10609079,10609080,10609081,10609082,10612082,10609083,10612083,10609084,10609085,10609086,10609087,10609088,10609089,10609090,10609091,10609092,10609093,10609094,10609134,10609135,10609136,10609137,10609139,10612140,10612141,10612142,10609142,10609143,10612143,10612144,10612145,10612146,10612147,10612148,10612149,10612150,10612151,10612152,10612153,10612154,10612155,10612156,10612157,10609164,10609165,10609169,10609186,10609189,10609190,10609191,10609195,10609197,10609202,10609203,10609204,10609211,10609212,10609221,10609223,10609224,10609227,10609228,10609231,10612231,10612232,10612233,10609257,10609261,10609262,10612271,10612274,10609285,10612286,10612299,10612300,10612301,10612302,10612303,10612304,10612305,10612306,10612307,10612308,10612309,10612310,10612311,10612312,10609313,10612313,10612314,10612315,10612320,10612321,10609336,10612344,10609348,10609350,10609351,10609352,10612356,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609376,10609377,10609378,10609385,10609386,10609391,10609393,10609394,10609395,10609396,10609397,10609398,10612408,10612409,10612410,10612411,10612417,10612506,10612555,10612556,10612557,10612558,10609564,10609567,10612620,10612697,10609717,10612757,10609770,10609772,10609816,10609818,10609819,10612821,10612822,10609824,10609826,10609836,10609838,10609871,10609872,10612886,10612888,10612893,10612894,10612895,10612896,10612897,10612898,10612909,10612910,10612911,10612913,10612915,10612916,10609946,10612951,10612970,10609972,10609975,10609976,10610000,10610006,10613019,10610030,10613047,10610048,10613048,10613049,10613050,10613056,10613079,10613080,10613081,10613082,10613086,10613089,10610098,10610152,10610167,10610168,10613170,10613193,10613194,10610214,10610233,10613235,10610236,10610268,10610271,10610282,10610289,10613308,10613309,10613310,10613311,10613312,10613313,10613314,10613315,10613316,10613317,10613318,10613319,10613320,10613330,10613331,10613335,10613342,10613349,10613350,10610351,10613378,10613380,10610396,10613406,10610466,10613513,10613514,10613515,10613516,10613517,10613518,10613519,10610520,10610535,10613543,10613546,10613547,10613553,10613570,10613571,10613572,10613646,10613675,10613678,10610691,10613693,10610694,10610695,10613695,10610696,10610697,10613700,10613701,10613702,10613703,10613704,10613705,10613706,10613707,10613708,10610709,10613709,10613710,10613711,10613712,10613713,10613714,10613715,10613716,10613717,10613718,10610727,10613727,10613728,10613729,10610732,10613736,10610743,10610768,10610769,10610770,10610771,10610772,10610779,10610789,10613805,10613806,10613822,10610836,10610842,10610843,10610844,10613844,10610845,10610846,10610847,10610848,10610849,10610850,10610851,10610852,10610853,10610854,10610860,10610863,10610864,10610901,10610908,10610917,10610918,10610919,10610920,10610921,10610922,10610923,10610924,10610927,10613932,10610942,10610952,10610958,10514037,10514038,10415223,10419258,10419259,10419260,10417285,10417286,10417293,10419293,10417348,10417349,10417350,10417356,10417357,10419357,10417358,10419358,10419359,10417359,10419360,10417360,10419361,10419362,10419370,10417373,10417374,10417375,10416375,10417376,10416376,10417377,10416377,10417378,10416378,10416379,10416380,10416381,10416382,10417383,10417384,10417385,10417398,10417399,10417400,10417401,10417402,10417405,10417406,10417407,10417408,10419440,10419441,10419442,10416460,10419468,10419473,10419474,10419475,10419477,10419478,10419479,10419480,10419481,10419482,10419484,10419485,10415487,10419487,10419489,10419491,10416497,10416498,10417531,10417532,10417533,10416533,10416536,10417537,10416540,10416541,10416542,10416545,10416547,10416548,10416553,10416554,10416555,10416556,10416557,10416558,10416559,10416560,10416561,10416562,10416563,10416564,10417565,10416565,10416569,10419569,10417583,10417585,10419592,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10417609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10416628,10419628,10416629,10416630,10419630,10416631,10419631,10416632,10419632,10416633,10419633,10419634,10417635,10419635,10417636,10419636,10419637,10419641,10419642,10419643,10419644,10419645,10419646,10419653,10419654,10419655,10419658,10419659,10419661,10419662,10419663,10419664,10419665,10419666,10419667,10415671,10415673,10415682,10415694,10415695,10417700,10416720,10416722,10416724,10416726,10416760,10419762,10419769,10419772,10419774,10416775,10419776,10419779,10419781,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10417965,10417992,10417993,10417994,10417995,10417996,10417997,10417998,10417999,10418000,10418001,10418002,10418003,10418004,10418005,10418006,10418007,10418008,10418009,10418010,10418011,10418012,10418013,10418014,10418015,10418016,10418017,10418018,10418019,10418020,10418021,10418022,10418023,10418024,10418025,10418026,10416027,10418027,10418028,10416029,10418029,10418030,10416031,10418031,10418032,10416033,10418033,10418034,10418035,10417035,10418036,10416056,10416114,10416117,10462907,10462908,10462909,10463001,10463002,10471065,10471066,10471067,10471114,10471117,10471173,10467327,10467477,10469882,10469883,10469884,10469885,10469886,10469887,10469888,10469889,10469890,10469891,10469892,10463981,10463982,10463983,10470062,10470063,10470064,10470065,10470066,10470067,10470068,10470069,10470070,10470071,10470072,10470137,10470161,10470201,10470631,10470643,10470805) 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'