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(4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971070,4971071,4971072,4971110,4971111,4971112,4971113,4971114,4971115,4971116,4971117,4971118,4971119,4971120,4968846,4968847,4968848,4968849,4968850,4968851,4968852,4968853,4968854,4968855,4968856,4968857,4968858,4968859,4968860,4968861,4968862,4968863,4968864,4968865,4968866,4968867,4968868,4968869,4968870,4968871,4968872,4968873,4968874,4968875,4968876,4968877,4968878,4968879,4968880,4968881,4968882,4968883,4968884,4968885,4968886,4968887,4968888,4968889,4968890,4968891,4968892,4968893,4968894,4968895,4968896,4968897,4968898,4968899,4968900,4968901,4968902,4968903,4968904,4968905,4968906,4968907,4968908,4968909,4968910,4968911,4968912,4968913,4968914,4968915,4968916,4968917,4968918,4968919,4968920,4968921,4968922,4968923,4968924,4968925,4968926,4968927,4968928,4968929,4968930,4968931,4968932,4968933,4968934,4968935,4968936,4968937,4968938,4968939,4968940,4968941,4968942,4968943,4968944,4968945,4968946,4968947,4968948,4968949,4968950,4968951,4968952,4968953,4968954,4968955,4968956,4968957,4968958,4968959,4968960,4968961,4968962,4968963,4968964,4968965,4968966,4968967,4968968,4968969,4968970,4968971,4968972,4968973,4968974,4968975,4968976,4968977,4968978,4968979,4968980,4968981,4968982,4968983,4968984,4968985,4968986,4968987,4968988,4968989,4968990,4968991,4968992,4968993,4968994,4968995,4968996,4968997,4968998,4968999,4969000,4969001,4969002,4969003,4969004,4969005,4969006,4969007,4969008,4969009,4969010,4969011,4969012,4969013,4969014,4969015,4969016,4969017,4969018,4969019,4969020,4969021,4969022,4969023,4969024,4969025,4969026,4969027,4969028,4969029,4969030,4969031,4969032,4969033,4969034,4969035,4969036,4969037,4969038,4969039,4969040,4969041,4969042,4969043,4969044,4969045,4969046,4969047,4969048,4969049,4969050,4969051,4969052,4969053,4969054,4969055,4969056,4969057,4969058,4969059,4969060,4969061,4969062,4969063,4969064,4969065,4969066,4969067,4969068,4969069,4969070,4969071,4969072,4969073,4969074,4969075,4969076,4969077,4969078,4969079,4969080,4969081,4969082,4969083,4969084,4969085,4969086,4969087,4969088,4969089,4969090,4969091,4969092,4969093,4969094,4969095,4969096,4969097,4969098,4969099,4969100,4969101,4969102,4969103,4969104,4969105,4969106,4969107,4969108,4969109,4969110,4969111,4969112,4969113,4969114,4969115,4969116,4969117,4969118,4969119,4969120,4969121,4969122,4969123,4969124,4969125,4969126,4969127,4969128,4969129,4969130,4969131,4969132,4969133,4969134,4969135,4969136,4969137,4969138,4969139,4969140,4969141,4969142,4969143,4969144,4969145,4969146,4969147,4969148,4969149,4969150,4969151,4969152,4969153,4969154,4969155,4969156,4969157,4969158,4969159,4969160,4969161,4969162,4969163,4969164,4969165,4969166,4969167,4969168,4969169,4969170,4969171,4969172,4969173,4969174,4969175,4969176,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969184,4969185,4969186,4969187,4969188,4969189,4969190,4969191,4969192,4969570,8075272,8075284,8075285,8075286,8075287,8075288,8075289,8075290,8075291,8075292,8075293,8075294,8075295,8075296,8075297,8075298,8075299,8075300,8075301,8075302,8075303,8075304,8075305,8075306,8075307,8075308,8075309,8075310,8075311,8075312,8075313,8075314,8075315,8075316,8075317,8075318,8075319,8075320,8075321,8075322,8075323,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075332,4968004,4968005,4968006,4968007,4968008,4968009,4968010,4968011,4968012,4968013,4968014,4968015,4968016,4968017,4968018,4968019,4968020,4968021,4968022,4968023,4968024,4968025,4968026,4968027,4968028,8072541,8072542,8072543,8072544,8072545,8072546,8072547,8072548,8072549,8072550,8072551,8072552,8072553,8072554,8072555,8072556,8072557,8072558,8072559,8072560,8072561,8072562,8072563,8072564,8072565,8072566,8072567,8072568,8072569,8072570,8072571,8072572,8072573,8072574,8072575,8072576,8072577,8072578,8072579,8072580,8072581,8072582,8072583,8072584,8072585,8072586,8072587,8072588,8072589,8072590,8072591,8072592,8072593,8072594,8072595,8072596,8072597,8072598,8072599,8072600,8072601,8072602,8072603,8072604,8072605,8072606,8072607,8072608,8072609,8072610,8072611,8072612,8072613,8072614,8072615,8072616,8072617,8072618,8072619,8072620,8072621,8072622,8072623,8072624,8072625,8072626,8072627,8072628,8072629,8072630,8072631,8072632,8072633,8072634,8072635,8072636,8072637,8072638,8072639,8072640,8072641,8072642,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,8072793,8072794,8072795,8072796,8072797,8072798,8072799,8072800,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8072809,8072810,8072811,8072812,8072813,8072814,8072815,8072816,8072817,8072818,8072819,8072820,8072821,8072822,8072823,8072824,8072825,8072826,8072827,8072828,8072829,8072830,8072831,8072832,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,8072841,8072842,8072843,8072844,8072845,8072846,8072847,8072848,8072849,8072850,8072851,8072852,8072853,8072854,8072855,8072856,8072857,8072858,8072859,8072860,8072861,8072862,8072863,8072864,8072865,8072866,8072867,8072868,8072869,8072870,8072871,8072872,8072873,8072874,8072875,8072876,8072877,8072878,8072879,8072880,8072881,8072882,8072883,8072884,8072885,8072886,8072887,8072888,8072889,8072890,8072891,8072892,8072893,8072894,8072895,8072896,8072897,8072898,8072899,8072900,8072901,8072902,8072903,8072904,8072905,8072906,8072907,8072908,8072909,8072910,8072911,8072912,8072913,8072914,8072915,8072916,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072925,8072926,8072927,8072928,8072929,8072930,8072931,8072932,8072933,8072934,8072935,8072936,8072937,8072938,8072939,8072940,8072941,8072942,8072943,8072944,8072945,8072946,8072947,8072948,8072949,8072950,8072951,8072952,8072953,8072954,8072955,8072956,8072957,8072958,8072959,8072960,8072961,8072962,8072963,8072964,8072965,8072966,8072967,8072968,8072969,8072970,8072971,8072972,8072973,8072974,8072975,8072976,8072977,8072978,8072979,8072980,8072981,8072982,8072983,8072984,8072985,8072986,8072987,8072988,8072989,8072990,8072991,8072992,8072993,8072994,10622972,10623059,10623061,10623101,10623491,10623492,10623493,10623494,10623503,10623656,10623657,10623658,10623659,10623976,10624361,10624632,10624633,10624898,10624899,10624900,10624901,10624902,10624903,10624904,10624905,10624906,10624907,10624908,10624909,10624910,10624911,10624912,10624913,10624914,10624915,10624916,10624917,10624918,10624919,10624920,10624921,10624922,10624923,10624924,10624925,10624926,10624927,10624928,10624929,10624930,10624931,10624932,10624933,10624934,10624935,10624936,10624937,10624938,10624939,10624940,10624941,10624942,10624943,10624944,10624945,10624946,10624947,10624948,10624949,10624950,10624951,10624952,10624953,10624954,10624955,10624956,10624957,10624958,10624959,10624960,10624961,10622187,10622189,10622217,10622224,10622225,10622230,10622235,10622611,10620145,10620146,10620148,10620149,10620150,10620151,10620444,10620470,10620523,10620524,10620525,10620527,10621033) 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'