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(8068802,8068807,8068814,8068815,8068816,8068817,8068818,8068819,8068820,8068821,8068822,8068823,8068824,8068825,8068826,8068827,8068828,8068829,8068830,8068831,8068832,8068833,8068834,8068835,8068836,8068837,8068838,8068839,8068840,8068841,8068842,7067875,8068867,8068868,7068160,7068161,7068162,7068163,7068326,7068327,7068328,7068329,7068330,7068331,7068332,7068333,7068334,7068335,7068336,7068337,7068338,7068339,7068340,7068341,7068342,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970891,4970892,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970974,4970975,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971037,4971051,4971054,4971055,4971056,4971057,4971058,10437278,10437279,10437287,10437291,10437292,10437293,10437294,10437296,10437297,10437306,10437309,10437310,10437311,10437317,10437322,10437323,10437324,10437325,10437326,10437327,10437328,10437332,10437333,10437334,10437335,10437336,10437347,10437385,10437386,10437396,10437495,10437496,10437497,10437498,10437499,10437564,10437568,10437570,10437573,10437583,10437585,10437586,10437587,10437589,10437598,10437599,10437602,10437603,10437626,10437627,10437628,10437629,7066748,7066759,7066760,7066761,7066762,7066763,7066764,7066860,7066861,7066869,7066870,7066872,7066873,7066875,7066876,7066889,7066925,7066926,7066927,7066936,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,8068795,10931745,10931800,10931865,10931867,10931872,8075290,10931875,10931877,10931880,8075312,10931915,10931924,10931926,10931927,10931938,10931939,10931945,10931946,10932000,10932001,10932002,10932003,10932006,10932013,10932065,10932068,10932069,10932178,10932180,10932247,10932248,10932251,10932252,10932253,10932255,10932256,10932259,10932493,10932496,10932501,10932505,10932508,10932513,10932520,10932523,10932542,10932597,10932636,10932640,10932648,10932661,10932676,10932692,10932754,10932809,10932842,10932843,10932854,10932864,10932907,10932911,10932912,10932914,10932919,10932921,10932931,10932962,10932972,10932973,10932976,10932977,10932994,10933001,10933004,10933032,10933099,10933153,10933171,10933173,10933183,10933185,8860727,10942600,8860948,8860954,8860955,8860957,8860961,8860962,8860965,8860967,8860968,10942790,10942791,10942792,10942793,8860993,8860995,8861069,10942889,10942890,10942917,10942918,8861130,10942952,10942953,10942954,10942955,10942956,10942957,10942958,10942959,10942981,10942982,10942983,10942984,10942988,10942989,10942990,10942991,10942992,10942993,10942994,10942995,10942996,10942997,10942998,10942999,10943000,10943001,10943002,10943003,10943009,10943010,8861202,10943041,10943060,8861340,8861341,8970235,8970236,8970237,10944442,10944634,10944635,10944636,10944637,10944657,10944658,10944659,10944662,8072308,8072535,8072536,8072537,8072541,8072543,8072545,8072550,8072556,8072562,8072563,8072564,8072570,8072571,8072577,8072579,8072693,8072694,8072695,8072696,8072697,8072793,8072794,8072795,8072796,8072797,8072798,8072799,8072800,8072809,8072810,8072811,8072812,8072813,8072814,8072815,8072816,8072825,8072826,8072827,8072828,8072829,8072830,8072831,8072832,8072845,8072846,8072847,8072848,8072849,8072850,8072851,8072852,8072865,8072866,8072867,8072868,8072869,8072870,8072871,8072872,8072885,8072886,8072887,8072888,8072889,8072890,8072901,8072902,8072903,8072904,8072905,8072906,8072907,8072908,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072935,8072936,8072937,8072938,8072939,8072940,8072941,8072942,8072950,8072951,8072952,8072953,8072954,8072955,8072956,8072957,8072966,8072967,8072968,8072969,8072970,8072971,8072972,8072973,8072992,8072993,8073096,10942112,10942116,10942126,10942128,10942130,10942200,10942201,10942202,10942255,10942275,10942298,8073533,8073534,8073535,8073537,8073538,8073539,8073542,10942404,8073543,10923561,10923562,10923563,10923564,10923565,10923566,10923567,10923568,10923569,10923570,10923571,10923572,10923573,10923574,10923575,10623170,10924250,10924251,10924252,10924253,10924254,10924255,10924256,10924257,10924258,10924259,10924260,10924261,10924262,10924263,10924264,10924265,10924266,10924267,10924268,10924269,10924270,10924271,10924272,10924273,10924274,10924275,10924276,10924277,10924278,10924279,10924319,10924320,10924321,10924322,10924323,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,10925098,10925376,10925377,10925378,10925379,10925380,10925381,10925382,10925383,10925384,10925385,10925386,10925387,10925388,10925389,10925390,10925391,10925392,10925393,10925394,10925395,10925396,10925397,10925398,10925399,10925400,10925401,10925402,10925403,10925404,10925405,10925406,10925407,10925408,10925409,10925410,10925411,10925412,10925413,10925414,10925415,10925416,10925417,10925418,10925419,10925420,10925421,10925422,10925423,10925424,10925425,10925426,10925427,10925428,10925429,10925430,10925431,10925450,10922500,10922502,10922506,10922515,10922518,10922525,10922526,10922527,10922531,10922532,10922533,10922534,10922537,10922545,10922548,10922549,10922579,10922580,10922581,10922582,10922602,10922619,10922621,10922622,10922623,10622126,10922640,10922641,10922642,10922643,10922644,10922645,10922646,10922647,10922648,10922649,10922650,10922651,10922652,10922653,10922654,10922655,10922656,10922657,10922658,10922659,10922660,10922661,10922662,10922663,10922664,10922665,10922666,10922667,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,10922256,10922259,10922260,10922261,10922262,10922263,10922265,10922266,10922268,10922270,10922271,10922272,10922278,10922288,10922289,10922291,10922292,10922359,10922360,10922458,10614384,10614385,10614401,10563136,10563149,10563150,10563172,10563173,10563174,10563175,10563180,10563181,10563190,10563191,10563214,10612964,10612965,10564469,10564470,10564488,10564489,10564490,10564491,10564492,10564493,10564494,10564495,10564496,10564497,10564498,10564499,10564500,10564501,10564502,10564503,10564504,10564505,10564506,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,10564600,10564601,10564602,10564603,10564604,10564605,10564606,10564607,10564608,10564614,10564615,10564616,10564617,10564622,10564628,10564629,10564630,10564647,10564657,10564658,10564680,10564681,10564682,10564684,10564685,10564688,10564689,10564690,10564691,10564692,10564699,10564700,10564701,10564702,10564715,10564716,10564717,10564718,10564719,10564720,10564721,10564722,10564723,10564724,10564725,10564726,10564742,10564743,10564744,10564745,10564746,10564747,10564748,10564779,10564780,10564781,10564782,10564783,10564784,10564785,10564786,10564787,10564788,10564810,10564811,10564812,10564813,10564814,10564815,10564816,10564817,10564818,10564819,10517242,10517243,10512801,10420140,10471493,10471494,10471495,10471499,10471500,10471501,10471502,10471503,10471505,10470721) 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'