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(4970177,4970178,4970179,4970180,4970181,4970182,4970183,4970198,4970200,4970204,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,4970228,4970229,4970283,4970319,4970320,4970322,4970361,4970362,4970363,4970388,4970390,4970392,4970407,4970450,4970467,4970468,4970482,4970483,4970484,4970485,4970486,4970494,4970502,4970504,4970505,4970506,4970507,4970528,4970529,4970530,4970533,4970534,4970555,4970561,4970581,4970584,4970624,4970642,4970643,4970644,4970672,4970675,4970676,4970684,4970693,4970694,4970735,4970736,4970738,4970740,4970741,4970766,4970767,4970770,4970782,4970783,4970813,4970814,4970815,4970845,4970848,4970852,4970863,4970888,4970890,4970900,4970915,4970925,4970928,4970966,4971010,4971011,4971012,4971035,4971052,4971064,4971065,4971074,4971077,4971081,4971086,4971087,4971088,4971119,4971149,4968189,4968212,4968216,4968268,4968304,4968314,4968335,4968353,4968356,4968361,4968362,4968414,4968415,4968417,4968418,4968436,4968460,4968478,4968483,4968484,4968499,4968501,4968502,4968503,4968505,4968508,4968510,4968512,4968514,4968535,4968562,4968571,4968597,4968598,4968599,4968606,4968650,4968684,4968685,4968750,4968772,4968779,4968780,4968782,4968792,4968793,4968808,4968815,4968824,4968836,4968839,4968840,4968841,4968850,4968888,4968919,4968923,4968924,4968945,4968946,4968950,4968972,4969004,4969005,4969006,4969028,4969046,4969057,4969060,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,4969125,4969131,4969158,4969175,4969179,4969185,4969186,4969209,4969211,4969216,4969218,4969219,4969221,4969222,4969223,4969224,4969225,4969240,4969251,4969272,4969276,4969321,4969326,4969442,4969451,4969452,4969453,4969454,4969455,4969456,4969457,4969458,4969459,4969460,4969461,4969462,4969463,4969464,4969491,4969502,4969520,4969522,4969523,4969524,4969581,4969591,4969592,4969629,4969646,4969655,4969662,4969682,4969690,4969702,4969703,4969710,4969726,4969731,4969732,4969733,4969734,4969736,4969737,4969739,4969761,4969766,4969767,4969769,4969770,4969772,4969773,4969797,4969813,4969825,4969840,4969861,4969862,4969863,4969886,4969910,4969951,4969965,4969981,4970007,4970008,4970029,4970030,4970032,4970034,4970130,4970131,4970132,4970133,4970134,4970135,4970136,4970142,8074897,8074898,8074899,8074900,8074901,8074940,8074941,8074942,8074943,8074944,8074945,8075218,8075219,8075258,4967050,4967051,4967077,4967080,4967136,4967154,4967155,4967161,4967170,4967172,4967173,4967175,4967179,4967181,4967182,4967199,4967200,4967201,4967206,4967207,4967218,4967249,4967250,4967251,4967252,4967255,4967264,4967290,4967291,4967292,4967298,4967319,4967334,4967338,4967345,4967357,4967360,4967404,4967411,4967417,4967432,4967446,4967447,4967474,4967476,4967477,4967479,4967582,4967584,4967586,4967603,4967604,4967606,4967616,4967631,4967632,4967668,4967669,4967670,4967681,4967682,4967683,4967696,4967697,4967698,4967699,4967728,4967729,4967748,4967749,4967751,4967763,4967772,4967774,4967775,4967780,4967781,4967852,4967862,4967899,4967901,4967906,4967907,4967908,4967913,4967914,4967936,4967954,4967955,4967956,4967957,4968038,4968069,4968070,4968125,4968128,4968130,8074450,8074451,8074452,8074453,8074454,8074494,8074495,8074496,8074497,8074498,8071670,8071671,8071672,8071673,8071674,8071675,8071676,8071677,8071678,8071679,8071680,8071681,8071682,8071683,8071684,8071685,8071686,8071687,8071688,8071689,8071690,8071691,8071692,8071693,8071694,8071695,8071696,8071697,8071698,8071699,8071700,8071701,8071702,8071703,8071704,8071705,8071706,8071707,8071708,8071709,8071710,8071711,8071712,8071713,8071714,8071715,8071716,8071717,8071718,8071719,8071720,8071721,8071722,8071723,8071724,8071725,8071726,8071727,8071728,8071729,8071730,8071731,8071732,8071733,8071734,8071735,8071736,8071737,8071738,8071739,8071740,8071741,8071742,8071743,8071744,8071745,8071746,8071747,8071748,8071749,8071750,8071751,8071752,8071753,8071754,8071755,8071756,8071757,8071758,8071759,8071760,8071761,8071762,8071763,8071764,8071765,8071766,8071767,8071768,8071769,8071770,8071771,8071772,8072300,8072361,8072367,8072378,8072382,8072389,8072395,8072400,8072404,8072410,8072416,8072421,8072426,8072442,8072446,8072453,8072458,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,8072956,8072958,8072959,8072960,8072961,8072962,8072963,8072964,8072965,8073515,8073541,10623057,10623085,10623086,10623092,10623093,10623105,10623119,10623120,10623121,10623133,10623137,10623142,10623147,10623149,10623151,10623155,10623156,10623160,10623172,10623183,10623185,10623186,10623187,10623188,10623189,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623240,10623247,10623264,10623265,10623268,10623270,10623271,10623306,10623342,10623436,10623492,10623494,10623499,10623504,10623508,10623510,10623511,10623545,10623762,10623763,10623764,10623775,10623776,10623786,10623787,10623855,10623856,10623857,10623858,10623859,10623860,10623861,10624125,10624187,10624196,10624197,10624198,10624199,10624200,10624209,10624289,10624290,10624291,10624292,10624293,10624294,10624295,10624365,10624368,10624373,10624389,10624390,10624473,10624484,10624576,10624588,10624595,10624601,10624617,10624618,10624665,10624727,10624744,10624775,10624778,10624788,10624845,10624865,10624911,10621962,10622132,10622160,10622161,10622162,10622163,10622166,10622179,10622203,10622204,10622205,10622208,10622233,10622266,10622269,10622283,10622286,10622287,10622293,10622301,10622314,10622315,10622317,10622326,10622327,10622339,10622366,10622419,10622424,10622430,10622441,10622461,10622464,10622482,10622484,10622486,10622487,10622488,10622489,10622490,10622491,10622492,10622493,10622494,10622495,10622496,10622497,10622498,10622499,10622500,10622501,10622502,10622504,10622508,10622523,10622524,10622525,10622527,10622528,10622530,10622535,10622541,10622543,10622547,10622562,10622630,10622634,10622635,10622636,10622637,10622639,10622640,10622641,10622643,10622673,10622675,10622677,10622678,10622679,10622680,10622681,10622722,10622765,10622767,10622779,10622780,10622821,10622822,10622823,10622824,10622825,10622826,10622852,10622876,10622879,10622928,10622932,10622935,10620005,10620019,10620026,10620036,10620038,10620041,10620079,10620082,10620095,10620107,10620108,10620123,10620124,10620125,10620126,10620127,10620130,10620131,10620132,10620133,10620134,10620135,10620136,10620140,10620156,10620414,10620565,10620600,10620606,10620607,10620608,10620609,10620615,10620617,10620628,10620635,10620692,10620693,10620698,10620718,10620724,10620730,10620733,10620734,10620764,10620771,10620789,10620790,10620791,10620814,10620838,10620869,10620870,10620872,10620875,10620892,10620906,10620918,10620921,10620922,10620946,10620947,10621032,10621053,10621061,10621065,10621131,10621189,10621190,10621191,10621194,10621195,10621262,10621306,10621363,10621443,10621456,10621457,10621458,10621476,10621477,10621478,10621479,10621494,10621495,10621506,10621546,10621547,10621553,10621559,10621561,10621562,10621566,10621578,10621579,10621584,10621596,10621597,10621598,10621599,10621600) 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'