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(4970270,4970451,4970452,4970453,4970454,4970455,4970456,4970457,4970458,4970459,4970460,4970461,4970462,4970463,4970464,4970465,4970466,4970467,4970468,4970469,4970470,4970471,4970472,4970473,4970474,4970475,4970476,4970477,4970478,4970479,4970480,4970481,4970482,4970483,4970484,4970496,4970500,4970501,4970502,4970503,4970504,4970505,4970506,4970507,4970520,4970524,4970530,4970532,4970535,4970542,4970546,4970552,4970553,4970554,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970566,4970576,4970599,4970600,4970601,4970602,4970603,4970637,4970638,4970640,4970641,4970659,4970660,4970661,4970677,4970678,4970686,4970693,4970694,4970700,4970704,4970714,4970723,4970731,4970732,4970736,4970738,4970740,4970745,4970755,4970756,4970762,4970767,4970768,4970769,4970773,4970774,4970784,4970831,4970833,4970834,4970852,4970859,4970860,4970861,4970862,4970863,4970866,4970867,4970873,4970874,4970876,4970878,4970881,4970882,4970883,4970886,4970887,4970888,4970892,4970893,4970897,4970900,4970901,4970905,4970912,4970914,4970918,4970924,4970928,4970929,4970934,4970936,4970938,4970941,4970942,4970943,4970951,4970953,4970956,4970974,4970977,4970979,4970981,4971018,4971029,4971034,4971035,4971036,4971064,4971070,4971079,4971080,4971084,4971088,4971095,4971096,4971111,4968184,4968229,4968238,4968242,4968243,4968244,4968265,4968277,4968278,4968280,4968282,4968284,4968288,4968290,4968318,4968342,4968367,4968377,4968380,4968382,4968384,4968386,4968388,4968389,4968392,4968395,4968396,4968397,4968401,4968413,4968414,4968417,4968429,4968442,4968444,4968445,4968455,4968456,4968457,4968484,4968559,4968562,4968563,4968564,4968571,4968619,4968620,4968621,4968622,4968624,4968625,4968627,4968642,4968645,4968652,4968653,4968675,4968682,4968692,4968712,4968730,4968731,4968732,4968734,4968736,4968737,4968738,4968739,4968740,4968761,4968762,4968764,4968808,4968824,4968825,4968828,4968834,4968842,4968843,4968844,4968845,4968861,4968862,4968875,4968876,4968877,4968878,4968879,4968880,4968881,4968882,4968883,4968884,4968885,4968886,4968887,4968899,4968900,4968901,4968954,4968979,4968980,4968981,4968982,4968983,4968984,4968985,4969020,4969021,4969022,4969023,4969024,4969025,4969026,4969029,4969030,4969031,4969075,4969084,4969089,4969109,4969110,4969119,4969134,4969154,4969179,4969226,4969227,4969240,4969241,4969242,4969243,4969244,4969245,4969257,4969272,4969284,4969285,4969286,4969288,4969290,4969291,4969292,4969293,4969294,4969295,4969296,4969297,4969299,4969322,4969327,4969357,4969378,4969379,4969465,4969466,4969467,4969468,4969469,4969470,4969588,4969723,4969732,4969822,4969824,4969825,4969827,4969828,4969829,4969846,4969847,4969848,4969849,4969850,4969851,4969852,4969878,4969879,4969881,4969907,4969985,4970003,8074679,8074680,8074681,8074682,8074683,8075257,8075258,8075259,8075260,8075268,8075269,8075272,8075288,8075289,8075330,8075387,8075388,8075389,8075390,8075392,8075393,8075394,8075398,8075399,8075428,8075430,8075444,8075445,8075447,8075536,4967030,4967061,4967082,4967083,4967084,4967085,4967086,4967087,4967088,4967089,4967090,4967112,4967177,4967239,4967240,4967305,4967353,4967356,4967357,4967390,4967395,4967432,4967435,4967441,4967517,4967569,4967570,4967843,4967885,4967886,4967887,4967888,4967889,4967890,4967891,4967892,4967893,4967894,4967895,4967896,4967897,4967898,4967899,4967900,4967901,4967902,4967903,4967904,4967905,4967906,4967907,4967908,4967909,4967910,4967911,4967912,4967913,4967914,4967915,4967916,4967917,4967918,4967919,4967920,4967921,4967922,4967923,4967924,4967925,4967926,4967927,4967929,4967934,4967936,4967941,4967985,4967988,4967990,4967991,4968004,4968029,4968031,4968073,8074076,8074077,8074078,8074079,8074080,8074118,8074119,8074120,8074121,8074122,8074635,8074636,8074637,8074638,8074639,8072616,8072617,8072618,8072619,8072620,8072621,8072622,8072643,8072644,8072645,8072646,8072647,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072693,8072694,8072695,8072696,8072697,8072698,8072699,8072700,8072701,8072702,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,8072748,8072749,8072750,8072751,8072752,8072753,8072754,8072755,8072756,8072757,8072758,8072759,8072760,8072761,8072762,8072763,8072764,8072765,8072766,8072767,8072768,8072769,8072770,8072771,8072772,8072773,8072774,8072775,8072776,8072777,8072778,8072779,8072780,8072781,8072782,8072783,8072784,8072785,8072786,8072787,8072788,8072789,8072790,8072791,8072792,8072953,8072954,8072955,8072956,8072957,8072961,8072962,8072963,8072964,8072965,8073069,8073070,8073075,8073489,8073490,8073491,8073503,8073504,8073514,8073515,8073516,8073526,8073527,10623042,10623044,10623045,10623048,10623049,10623050,10623057,10623063,10623079,10623080,10623081,10623082,10623083,10623084,10623085,10623086,10623104,10623105,10623106,10623108,10623111,10623136,10623140,10623157,10623165,10623170,10623171,10623185,10623186,10623187,10623188,10623189,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623205,10623209,10623211,10623212,10623213,10623214,10623236,10623237,10623238,10623239,10623240,10623241,10623242,10623245,10623246,10623291,10623293,10623296,10623297,10623298,10623299,10623300,10623301,10623302,10623303,10623304,10623305,10623306,10623307,10623308,10623309,10623387,10623471,10623493,10623499,10623502,10623504,10623518,10623553,10623559,10623560,10623561,10623562,10623563,10623579,10623580,10623581,10623604,10623605,10623606,10623616,10623617,10623618,10623626,10623627,10623628,10623629,10623630,10623651,10623653,10623656,10623657,10623666,10623667,10623668,10623669,10623670,10623671,10623672,10623673,10623674,10623675,10623676,10623677,10623678,10623679,10623680,10623681,10623682,10623683,10623684,10623685,10623686,10623687,10623688,10623689,10623690,10623691,10623692,10623736,10623751,10623822,10623828,10623829,10623830,10623831,10623888,10623897,10623902,10623905,10623912,10623913,10623939,10623941,10623942,10623943,10623944,10623945,10623946,10623947,10623948,10623949,10623950,10623951,10623952,10623955,10623964,10623986,10623987,10623988,10623989,10623990,10623991,10623992,10623996,10623997,10624002,10624007,10624016,10624019,10624033,10624034,10624035,10624036,10624037,10624038,10624039,10624051,10624056,10624077,10624078,10624081,10624082,10624083,10624117,10624176,10624177,10624178,10624179,10624180,10624181,10624182,10624183,10624184,10624185,10624186,10624187,10624196,10624197,10624198,10624230,10624258,10624259,10624270,10624292,10624293,10624295,10624307,10624337,10624377,10624453,10624454,10624455,10624456,10624457,10624458,10624459,10624460,10624461,10624462,10624463,10624464,10624465,10624466,10624467,10624468,10624469,10624470,10624471,10624472,10624473,10624515,10624516,10624517,10624523,10624537,10624542,10624576,10624596,10624605,10624612,10624616,10624617,10624618,10624619,10624620,10624621,10624622,10624669,10624682,10624690,10624695,10624720,10624721,10624723,10624724,10624729,10624730,10624748,10624796,10624797,10624798,10624800,10624810,10624820,10624821,10624878,10624892,10624895,10624914,10624916,10624954,10624959,10624961,10621971,10621972,10621981,10621982,10621988,10621999,10622013,10622036,10622046,10622056,10622057,10622061,10622062,10622099,10622100,10622105,10622107,10622108,10622109,10622110,10622112,10622114,10622115,10622116,10622117,10622118,10622124,10622133,10622139,10622140,10622151,10622153,10622154,10622158,10622169,10622188,10622235,10622261,10622283,10622290,10622293,10622296,10622301,10622316,10622326,10622327,10622356,10622357,10622374,10622413,10622414,10622427,10622452,10622460,10622464,10622473,10622501,10622502,10622524,10622525,10622526,10622527,10622528,10622530,10622533,10622541,10622542,10622596,10622597,10622598,10622599,10622600,10622601,10622602,10622632,10622644) 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'