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(8068820,10845597,10845610,10962542,10939583,10930202,10939797,10845951,10845952,10845953,10845954,10458858,7076299,7076315,7076343,10459097,10459101,10459110,10459113,10459117,10846585,8584006,8584007,8584008,8619794,8619795,8619797,3227525,10845218,10845219,10845220,11001153,10845389,11001373,11001374,6000119,8617944,10103340,10843008,10843057,10843064,10843078,10843116,3899134,3899135,3899136,3899137,3899138,3899139,8836217,8618967,8836766,7073703,7070837,7071234,7200634,10943317,10943319,10943327,10943371,10943385,10943405,10943414,10102847,8910788,8910794,11011424,10100079,8615073,3655989,3655990,7069707,10840614,10941791,10941800,10941820,10941827,10941828,10941860,10941861,10941876,10941886,10941934,10941941,10941962,10941975,10941986,10942000,10993508,10993509,10993510,10993513,10993514,10993515,10993516,10993517,10993538,10993539,10928611,10928612,10928641,10928642,7156542,11045802,11045833,11045838,11045867,11045944,11045949,11045950,11045951,11045974,11046725,11046727,11046728,11046765,11046839,11046897,11046898,11046899,11046900,11046913,11047033,11047034,11047035,11047036,11047037,11047038,11047054,11047077,11047078,11047084,11047085,11047086,11047087,11047088,11047089,11047090,11047148,11047149,11047150,11047152,11047153,11047154,11047155,11047156,11047190,11047191,11047192,11047204,11047205,11047206,11047242,11047243,11047244,11047263,11047277,11047279,11047322,11047342,11047343,11047344,11047345,11047346,11047347,10992540,10992541,10992542,10992543,10992544,10992545,10992546,10992547,10992548,10992549,10992550,10992551,10992595,10992596,10992607,10992608,10992609,10992610,10992611,10992618,10992619,10992627,10992636,8541528,10992705,10992719,10992756,10992757,10992758,10992759,10992760,10992761,10992762,10992763,10992784,10992785,10992786,10992787,10992793,10992794,10992815,10992857,10992904,10992905,10992906,10992953,10992954,10992955,10992956,10992957,10992999,10993000,10993001,10993002,10993003,10993004,10993005,10993006,10993007,10993008,11045026,11045029,10993047,10993048,10993085,10993086,10993087,8905466,10993103,10993130,10993131,10993132,10993133,10993134,10993135,10993136,10993137,10993138,10993139,10993140,10993141,10993142,10993164,10993181,10993202,11045257,11045258,11045259,10993260,10928252,10993297,10993303,10993304,11045338,10928315,10928316,10993439,10993440,10993441,10993457,10993458,10920545,8622729,8622737,8622739,10920627,10920640,10920684,10920685,10920686,10460713,10460719,10460725,10460731,10460737,10460743,10460749,10460755,10460761,10460767,10460773,10460779,10460785,10460791,10460797,10460803,10460809,10460815,10460821,10460827,10460833,10460839,10460921,10460951,10460961,10460965,10460968,10991481,10991482,10991530,10991542,10991543,10991544,10991559,10991560,10991561,10991668,10991777,10991778,10992029,10992030,10992046,10992047,10992109,10992110,10992111,10992112,10992113,10992114,10992115,10992116,10992117,10992118,10992119,10992120,10992128,10992129,10992130,10992131,10992176,10992183,10992368,10992453,10992454,10992455,10992456,10992457,10992458,10992459,10992460,10992461,10992462,10992463,10992464,10992465,10992466,10992467,10927441,10559200,10559204,10559205,10559206,10559207,10559208,10559209,10562334,9213575,9213628,9213629,9213630,9213691,7059858,9213743,9173777,9213793,9213794,9213795,9213796,9213797,9213798,9213842,9213863,9213864,9213865,9213898,9213899,9213900,9213926,9213964,9213965,9213977,9213984,10122188,10122219,10122220,10122221,10122222,9174039,8864565,10122244,10122245,10122246,10122277,9214085,10122322,10122326,10122327,9174131,9166157,9203303,9203304,9203305,7057477,7057478,7057479,10119515,7057493,7057498,7057499,7057500,7057513,10563470,10563471,10563472,10563522,10563523,10612398,10612399,10612400,10612401,9171957,9171958,9196001,9172173,9212354,9212358,9212364,9212424,7058644,7058645,10610323,10558537,10558538,10558539,10558558,10558559,10558560,10558561,9197033,9173073,9169665,9169722,9185751,9169752,9161778,4974634,4974635,4974636,4974637,10126027,10126028,10126037,10126049,10126050,10126123,10126143,10126144,9185950,9185964,10126180,10126181,10126182,9185986,9186033,10513873,10513874,10513875,10513876,10513877,10513878,10513879,10513880,10513881,10513882,10513883,10513884,10513885,9186084,10513911,10513912,9186116,9186163,9186164,9186165,9186166,9170188,9186194,9186215,9186227,9186236,9186286,9186287,9186288,9186289,9186290,9186291,9186292,9186336,9186337,9186338,9186339,9186340,9186374,9186378,9186382,9186395,9186421,9186422,9186432,9186479,9186503,9186560,9186586,9186613,9186614,9186637,9186656,9186672,9186677,9186681,10118898,10118899,10512549,10512550,10512551,9186744,9186806,9186810,9186829,9186830,10514794,9203214,9203215,9203270,9203271,10419322,8918315,8918321,8918323,6666527,9206689,9198999,9175008,9175013,3963470,3963471,6667159,6667165,10123785,8917290,9207843,9175843,8917512,4972804,8917704,9192197,10888595,10888863,10628658,10628659,10628660,10628663,10628940,10629595,10171124,10171125,10629624,10629625,10627910,10630100,10176708,10176709,10176710,10176711,10181926,10891252,10882302,10646189,10601336,10568479,10568480,10586595,10598889,10598922,10599041,10599096,10599097,10599098,10599099,10599100,10599197,10599198,10599199,10599200,10599201,10599202,10599203,10599260,10599261,10599262,10599263,10599295,10599394,10599537,10599538,10599539,10599540,10599541,10599542,10599543,10599544,10599545,10599546,10599547,10599548,10599549,10599550,10599551,10599552,10599553,10599554,10599555,10599556,10599557,10599558,10599559,10599560,10599561,10599562,10599563,10599564,10599565,10599566,10599567,10599568,10599569,10599570,10599571,10599572,10599573,10599574,10599575,10599576,10599577,10599578,10599579,10599580,10599581,10599582,10599583,10599584,10599585,10599586,10599587,10599588,10599589,10599590,10599591,10599592,10599593,10599594,10599595,10599596,10599597,10599598,10599599,10599600,10599601,10599602,10599603,10599604,10599605,10599606,10590621,10599958,10599959,10599960,10600002,10600068,10600069,10600070,10600071,10591123,10591124,10600134,10600135,10600136,10600137,10600138,10600139,10600140,10600141,10600142,10600143,10600144,10600145,10600146,10600147,10600148,10600268,10600269,10600270,10600271,10600272,10600273,10600274,10600275,10600276,10600277,10600278,10576318,10576319,10576320,10591385,10591386,10591409,10591410,10591432,10591433,10591434,10600462,10576462,10600463,10600464,10600465,10600466,10600467,10600468,10600469,10600470,10600471,10600472,10591478,10591479,10591535,10591536,10591537,10591538,10591539,10591540,10591541,10591542,10591543,10591544,10591545,10591546,10600547,10600548,10576592,10567597,10600607,10600608,10600609,10600610,10600611,10600612,10600613,10591620,10591621,10591622,10591623,10591624,10600625,10591625,10600626,10600636,10600637,10591683,10591684,10591685,10591686,10591687,10591688,10600696,10600697,10600698,10600699,10600736,10600737,10600738,10600739,10600838,10600839,10600840,10600841,10600842,10600843,10531129,10531130,10531131,10531132,10531133,10531134,10531135,10531136,10531137,10531138,10531139,10531140,10531141,10531142,10531143,10531144,10531145,10531146,10531147,10531148,10531149,10531150,10531151,10531152,10529152,10521286,10521287,10521288,10531431,10531433,10537477,10531544,10531545,10531546,10531547,10531557,10531558,10531574,10531575,10531576,10531577,10531578,10531598,10531599,10531600,10531601,10531602,10531603,10531604,10531605,10531606,10531632,10531633,10531641,10531642,10531718,10531778,10531779,10531780,10531816,10531817,10527829,10527830,10527831,10527832,10527880,10531881,10529889,10529890,10529916,10531959,10531960,10531961,10531962,10531963,10531964,10531969,10529972,10532009,10532010,10532011,10532012,10530060,10530061,10530077,10530078,10532086,10532087,10532088,10532089,10532090,10530104,10530131,10530148,10530152,10530159,10532246,10530294,10530295,10530296,10530297,10530335,10532346,10532347,10532348,10530380,10532400,10530411,10530412,10530419,10530420,10530436,10530437,10530438,10530439,10532470,10530476,10530477,10530484,10530486,10530528,10530529,10530530,10530531,10530532,10532535,10532536,10532659,10532663,10532710,10530711,10530712,10532731,10532732,10532733,10532734,10530762,10530763,10530764,10530765,10530782,10530798,10530832,10530833,10530834,10530835,10530836,10530837,10530838,10530839,10530840,10530841,10530842,10530843,10530844,10530845,10530846,10530847,10530848,10530849,10530850,10520850,10530851,10522860,10532885,10530888,10532914,10532915,10530954,10530955,10530956,10530972,10530991,10530992,10530993,10530994,10531017,10543038,10531044,10531054,10531055,10531056,10422257,10422258,10505536,10505537,10505538,10422146,10483985,10483986,10488164,10488166,10488167,10488172,10492788,10492789,10492914,10492915,10492920,10492921,10492934,10492935,10492936,10492937,10492938,10492939,10492940,10492941) 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'