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(8068827,8068828,8068830,8068832,8068833,8068834,8068835,8068836,8068837,8068838,8068839,8068840,8068841,8068842,8068867,8068868,7067979,7067984,7067987,10939639,10939640,10939651,7068083,7068330,7068332,7068333,7068336,7068338,7068339,10943759,10943760,10943761,10943864,10943868,10943869,10943870,10943871,10943872,7068460,10940263,4970887,4970957,4970960,4970961,4970962,4970988,4971054,4971055,4971056,4971057,4971058,10940487,10940488,10940489,7066008,8067187,10437085,10437086,8067235,8067236,8067238,8067239,10437178,10437179,10437183,10437184,10437278,10437279,10437287,10437291,10437297,4968668,4968669,10437309,10437310,10437311,10437317,10437322,10437323,10437324,10437325,10437326,10437327,10437328,10437389,10437390,10437396,10437421,8067549,8067574,10437498,8067637,8067659,8067660,8067661,8067662,10437598,10437603,7066759,7066761,7066762,7066764,7066771,10437629,7066861,7066869,7066870,10938495,7066873,7066889,7066925,7066926,7066927,7066936,7067033,10938719,7067109,8068032,8068033,8068034,8068035,8068036,8068037,8068038,8068039,8068306,8068307,8068308,8068309,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8068318,8068319,8068320,8068321,8068322,8068323,8068324,8068325,8068326,8068327,8068328,8068329,8068330,8068331,8068332,8068333,8068334,8068335,8068336,8068337,8068338,8068339,8068340,8068341,8068342,8068343,8068344,8068345,8068346,8068347,8068348,8068349,8068350,8068351,8068352,8068353,8068354,8068355,8068356,8068357,8068358,8068359,8068360,8068361,8068362,8068363,8068364,8068365,8068366,8068367,8068368,8068369,8068370,8068371,8068372,8068373,8068374,8068375,8068376,8068377,8068378,8068379,8068380,8068381,8068382,8068383,8068384,8068385,8068386,8068387,8068388,8068389,8068390,8068391,8068392,8068393,8068394,8068395,8068396,8068397,7067845,8068821,8068823,8068824,10931319,10931321,10931336,10931358,10931377,10931391,10931393,10931394,10931395,10931396,10931397,10931398,10931400,10931401,10931402,10931403,10931404,10931405,10931406,10931407,10931408,10931409,10931410,10931411,10931412,10931413,10931414,10931415,10931416,10931417,10931418,10931419,10931420,10931421,10931422,10931423,10931424,10931425,10931426,10931427,10931428,10931429,7064086,7064087,10931548,10931643,10931644,10931645,8075145,8075146,8075147,10931800,8075188,8075189,8075190,10931886,10931911,10931912,10931913,10931914,10931915,10931916,10931917,10931918,10931919,10931920,10931921,10931926,10931963,10931964,10932000,10932001,10932002,10932003,10932006,10932065,7064757,7064758,7064759,7064760,7064761,7064762,7064763,7064764,7064765,7064766,7064767,7064768,7064773,7064774,7064805,10932178,10932180,10932205,10932248,10932251,4967126,4967127,7064911,4967128,4967129,4967130,4967131,4967132,7064917,4967133,4967135,10932276,10932277,10932279,10932283,10932285,8065931,10932307,10932308,10932309,10932312,10932313,7064980,7064981,7064982,7064990,7064991,7064992,7064993,7064994,7064995,7064996,7064997,7064998,7065002,7065003,7065004,7065005,7065006,7065007,7065008,8065987,7065010,7065011,7065012,7065013,7065015,7065016,7065017,7065018,7065019,7065020,10932493,10932496,8066131,10932513,10932622,10932633,10932634,10932635,10932636,10932637,10932638,10932639,10932640,10932641,10932642,10932643,8066274,8066275,8066276,8066277,8066278,10932650,10932676,8066369,8066370,8066371,8066372,8066373,8066374,8066375,8066376,8066377,8066378,8066379,8066380,8066381,8066382,8066383,8066384,8066385,8066386,8066387,8066388,8066389,8066390,8066391,8066392,8066393,8066394,8066395,8066396,8066397,8066398,8066399,8066400,8066401,8066402,8066403,8066404,8066405,8066406,8066407,8066408,8066409,8066410,8066411,8066412,8066413,8066414,8066415,8066416,8066417,8066418,8066419,10932854,10932869,10932870,10932871,10932872,10932873,10932874,10932914,10932917,10932918,10932919,10932922,10932925,10932928,10932956,10932958,10932960,10932984,10933032,10933043,10933082,10933090,10933148,10933182,8073670,8073671,8073672,8073673,11049781,8073722,8073723,8073724,8073725,8073726,8073727,8064009,8073776,8073777,8073778,8073825,8073826,8073827,8073828,10942784,10942790,10942791,10942792,10942793,10942797,10942890,8064248,8064249,10942957,10942981,10942982,8064336,10942983,10942984,10942988,10942989,10942990,10942991,10942992,10942993,10942994,10942995,10942996,10942997,10942998,10942999,10943000,10943001,10943002,10943003,10943007,10943041,10943047,10943048,8064585,8064586,8064587,8970235,8970236,8970237,10931199,10931204,8064854,8064855,10931244,10931245,10931248,3655666,3655667,10940792,10940793,10940923,10940942,10940943,3656403,3656424,3656425,3656426,3656427,3656428,3656429,3656430,3656431,3656432,3656433,3656434,3656435,3656436,3656468,3656479,8072695,8072703,8072704,8072705,8072706,8072707,10941654,8072798,8072814,8072830,8072845,8072846,8072847,8072848,8072849,8072850,8072851,8072852,8072861,8072862,8072870,8072888,8072906,8072922,8072940,8072955,8072971,10942112,10942130,10942201,10942291,10942298,10942349,10942350,10942351,10942352,10942421,8073548,11049725,10622987,10923561,10923562,10923563,10923564,10923565,10923566,10923567,10923568,10923569,10923570,10923571,10923572,10923573,10923574,10923575,10623171,10924253,10924255,10924257,10924259,10924260,10924266,10924276,10924277,10623789,10924319,10924320,10924321,10924322,10924323,10624055,10924772,10924773,10924774,10924775,10924776,10924777,10924778,10924779,10924780,10924781,10924782,10924783,10924784,10924785,10924786,10924787,10924788,10924789,10924790,10924791,10924792,10924793,10924794,10924795,10924796,10924797,10924798,10924799,10924800,10924801,10924802,10924803,10924804,10924805,10924806,10924807,10924808,10924809,10924810,10924811,10924812,10924813,10924814,10924815,10924816,10924817,10924818,10924819,10924820,10924821,10924822,10924823,10924824,10924825,10924826,10924827,10924828,10924829,10924830,10924831,10924832,10924833,10924834,10924835,10924836,10924837,10924838,10924839,10924840,10924841,10924842,10924843,10924844,10924845,10924846,10924847,10924848,10924849,10924850,10624392,10925098,10624841,10624853,10624854,10925376,10925377,10925378,10925379,10925380,10925381,10925382,10925383,10925384,10925385,10925386,10925387,10925388,10925389,10925390,10925391,10925392,10925393,10925394,10925395,10925396,10925397,10925398,10925401,10925404,10925409,10925410,10925411,10925412,10925413,10925414,10925421,10925422,10925423,10925424,10925425,10925429,10925430,10925431,10925450,10922474,10922496,10922497,10922498,10922500,10922526,10922548,10922549,10922579,10922619,10922621,10622126,10922640,10922641,10922642,10922643,10922644,10922645,10922646,10922647,10922648,10922649,10922650,10922651,10922652,10922655,10922656,10922657,10922658,10922659,10922662,10922663,10922665,10922666,10922667,10622653,10622654,10622655,10622805,10622938,10620105,10620229,10620230,10620231,10620526,10621087,10621269,10621323,10621324,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621340,10621341,10621342,10621343,10621344,10621345,10621346,10621347,10621348,10621349,10621350,10621351,10621352,10621353,10621354,10621355,10621356,10621357,10621358,10922266,10922359,10922362,10922363,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10922458,10610965,10611196,10611226,10614232,10614401,10611698,10614766,10611851,10611853,10611972,10611973,10563136,10612006,10612007,10563181,10612085,10609277,10609592,10612964,10564470,10564497,10564560,10564561,10564562,10564563,10564564,10564565,10564566,10564567,10564568,10564569,10564570,10564571,10564572,10564573,10564574,10564575,10564576,10564577,10564578,10564579,10564580,10564581,10564582,10564583,10564584,10564585,10564586,10564587,10564588,10564589,10564590,10564591,10564592,10564593,10564594,10564595,10564596,10564597,10564598,10564599,10564600,10564601,10564602,10564603,10564604,10564605,10564606,10564607,10564608,10564616,10564640,10564641,10564642,10564643,10564658,10564682,10564684,10564690,10564700,10564715,10564716,10564717,10564718,10564719,10564720,10564721,10564722,10564723,10564724,10564725,10564726,10564782,10564810,10564812,10610823,10610824,10610847,10610850,10517242,10517243,10415288,10415289,10415379,10415471,10415628,10416718,10415843,10415852,10415854,10419869,10415916,10415917,10415921,10416046,10416047,10416052,10416055,10416056,10416057,10416126,10417161,10463442,10471493,10471499,10471500,10471503,10471505,10465676,10471800,10471805,10471809,10471825,10471837,10471845,10471853,10471858,10471862,10471864,10471867,10471872,8563287,8563352,8563370,8563371,8563381,8563382,8563385,8563392) 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'