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(10939647,11014761,11014768,11014769,11014854,11014963,11015532,11015533,11015534,11015535,11015536,11015537,11015538,11015539,11015540,11015541,10933283,7073977,7073978,7073979,7066210,7066272,7066370,10437278,10437279,10437280,10437281,10437282,10437283,10437284,11016136,11016137,11016138,11016139,11016140,11016141,11016142,11016143,11016144,11016186,11016187,11016188,10964457,10964521,10964522,10964547,7066895,11013620,11013621,11013622,11013623,11013624,11013625,11013626,11013627,11013628,11013629,11013630,11013631,11013632,11013633,11013634,11013635,11013636,11013637,11013638,11013639,11013640,11013641,11013642,11013643,11013644,11013645,11013646,11013647,11013648,11013649,11013650,11013651,11013652,11013653,11013654,11013655,11013656,11013657,11013658,11013659,11013660,11013661,11013662,11013663,11013664,7067208,7067209,7075233,7075240,7075257,7075262,7075730,7075751,7075753,7075768,7075871,8068794,8068816,7064072,8065085,8065090,8065092,10931545,8075321,7072608,7072609,7072610,7072617,10931995,10931997,10960397,10960398,10960399,10932276,10932277,10932598,10932599,10932600,10932601,10932602,10932603,10932604,10932605,10932606,10932607,10932608,10932609,10932610,10932611,10932612,10932613,10932614,10932615,10932616,10932617,10932618,10932619,10932620,10932621,10932622,10932623,10932624,10932627,10932628,10932629,10932630,10932631,10932632,10932633,10932634,10932635,10932636,10932637,10932638,10932639,7073579,7073580,7073581,7073582,7073583,10933016,10933017,7073878,7065906,10942596,11048983,11048984,11048985,11049017,7071245,7071246,11049217,11049218,11049220,7071398,11049303,10998106,7071422,10998107,10998108,10998119,10998125,10972181,10972190,10959222,6000018,7071861,6000216,10944634,10944635,10944636,10944637,10944638,10944639,10944640,10944641,10944642,10944643,10944644,10995918,10995919,10995920,10995921,10944657,10995922,10944658,10995923,10944659,10995924,10944660,10995925,10995926,10944661,10995927,10944662,10995928,10944663,10944664,10944665,10944666,10944667,10944680,7069314,7069315,7069316,10957462,10957463,10957464,10957465,10958011,11048305,10942112,10942113,10942143,10958362,10958363,10958364,10997584,10997585,10997586,10997587,10617962,10623056,10967838,10618237,10918747,10968066,10618667,10618668,10618872,10618873,10619144,10619145,8070922,8070962,10619895,10922529,10922538,10922539,10922540,10922541,10922542,10922543,10922544,10922579,10953989,10954006,10928255,10928256,10928257,10928258,10928259,10920601,10920602,8570083,10920878,10920879,10920880,10615441,8570485,10926077,10926078,10926141,10926180,10926255,10615872,10921623,10921624,10917036,10917037,10927111,10922233,10927435,7059467,7059606,10614411,8864297,8864303,8864318,8864324,9173820,9173821,10565700,7057684,7057685,7057686,7057687,10612275,10557456,10609346,10609349,10557523,10557524,10557525,10557526,10557527,10557528,10557529,10557530,10557531,7058170,7058450,7058451,7058452,7058761,10564471,10564472,10564473,10564474,10564475,10564476,10564477,10564478,10564479,10564480,10564481,10564482,10564483,10564484,10564485,10564486,10564487,10564488,10564489,10564490,10564491,10564492,10564493,10564494,10564495,10610345,10613350,10613353,10610354,10564507,10564508,10564509,10564510,10564511,10564512,10564513,10564514,10564515,10564516,10564517,10564518,10564519,10564520,10564521,10564522,10564523,10564524,10564525,10564526,10564527,10564528,10564529,10564530,10564531,10564532,10564533,10564534,10564535,10564536,10564537,10564538,10564539,10564540,10564541,10564542,10564543,10564544,10564545,10564546,10564547,10564548,10564549,10564550,10564551,10564552,10564553,10564554,10564555,10564556,10564557,10564558,10564559,10564560,10564561,10564562,10564563,10564564,10564565,9172753,10564566,9172754,10564567,10564568,9172755,9172756,10564569,10564570,10564571,10564572,10564573,10564574,10564575,10564576,10564577,10564578,10564579,10564580,10564581,10564582,10564583,10564584,10564585,10564586,10564587,10564588,10564589,10564590,10564591,10564592,9172919,10610698,10610768,10610773,9173285,9173286,9169456,10517315,10517316,10517317,10517318,9161540,9161541,4974410,9169697,7055959,10513790,10513791,10513792,10513793,10513794,10513795,10513796,10517823,10517824,10517825,10513890,10513891,4975123,4975124,10516619,10516682,7057159,7057244,9171126,10517042,10517043,10517044,10517045,10517046,10517047,10517048,10517049,10517050,10517051,10517052,10517053,10517054,10517055,10517056,10517057,10517058,10517059,10517060,10517061,10517062,10517063,10517064,10517065,10517066,10517067,10517068,10517069,10517070,10517071,10517072,10517073,10517074,10517075,10517076,10517077,10517078,10517079,10517080,10517081,10517082,10517083,10517084,10517085,10517086,10517087,10517088,10517089,10517090,10517091,10517092,10517093,10517094,10517095,10416243,9160373,10418338,10415405,4973367,4973368,4973369,4973370,4973371,4973372,4973373,4973374,4973375,4973376,4973377,4973378,10415493,10415494,10415495,10415496,10415497,10415498,10415499,10415500,10416644,4973643,10417799,10415996,10420037,10420038,10418052,10418082,10418094,10418135,4974135,4974136,4974137,4974138,4974139,8864870,8865134,6666780,10465755,9167264,8563212,10469970,10469971,6667404,6667405,6667535,6667536,6667537,6667538,8563537,9167654,9167655,9167656,8917322,9167771,8917427,10468364,10462392,10462639,9168152,8917919,10159592,10159593,10159594,10159595,10159596,10159750,10628740,10628844,10155736,10155806,10155823,10155824,10155825,10155826,10166405,10626986,10627091,10627092,10627093,10158779,10158780,10158781,10164002,10164003,10627886,10627931,10161920,10161929,10161947,10162328,10162329,10162330,10162331,10162332,10162333,10162334,10631148,10631149,10631666,10631689,10631690,10631697,10631698,10626753,10626754,10626755,10626756,10626829,10631855,10574443,10566190,10566191,10572424,10569829,10569830,10569831,10569832,10569833,10569834,10569835,10569836,10569837,10569838,10569839,10569840,10569841,10569842,10569843,10569844,10569845,10569846,10569847,10569848,10569849,10569850,10569851,10569852,10569853,10569854,10569855,10569856,10569857,10569858,10569859,10569860,10569861,10569862,10569863,10569864,10569865,10569866,10569867,10569868,10569869,10569870,10569871,10569872,10569873,10569874,10569875,10569876,10569877,10569878,10569879,10569880,10569881,10569882,10569883,10569884,10569885,10569886,10569887,10569888,10569889,10569890,10569891,10569892,10569893,10569894,10569895,10569896,10569897,10569898,10569899,10569900,10569901,10569902,10569903,10569904,10569905,10569906,10569907,10569908,10569909,10569910,10569911,10569912,10569913,10569914,10569915,10569916,10569917,10569918,10569919,10569920,10569921,10569922,10569923,10569924,10569925,10569926,10569927,10569928,10569929,10569930,10569931,10569932,10569933,10569934,10569935,10569936,10569937,10569938,10569939,10569940,10569941,10569942,10569943,10569944,10569945,10569946,10569947,10569948,10569949,10569950,10569951,10569952,10569953,10569954,10569955,10569956,10569957,10569958,10569959,10569960,10569961,10569962,10569963,10569964,10569965,10569966,10569967,10569968,10569969,10569970,10569971,10569972,10569973,10569974,10569975,10569976,10569977,10569978,10569979,10569980,10569981,10569982,10569983,10569984,10569985,10569986,10569987,10569988,10569989,10569990,10569991,10569992,10569993,10569994,10569995,10569996,10569997,10569998,10569999,10570000,10570001,10570002,10570003,10570004,10570005,10570006,10570007,10570008,10570009,10570010,10570011,10570012,10570013,10570014,10570015,10570016,10570017,10570018,10570019,10570020,10570021,10570022,10570023,10570024,10570025,10570026,10570027,10570028,10570029,10570030,10570031,10570032,10570033,10570034,10570035,10570036,10570037,10570038,10570039,10570040,10570041,10570042,10570043,10570044,10570045,10570046,10570047,10570048,10570049,10570050,10570051,10570052,10573206,10573207,10573208,10570482,10571030,10571031,10571032,10571033,10571034,10571035,10571036,10571037,10521565,10522545,10522546,10522547,10522548,10522549,10522684,10522685,10522686,10520751,10520752,10522827,10423265,10423276,10422296,10422297,10422298,10420391,10473249,10473250,10473251,10473252,10473253,10473254,10473255,10473256,10473258,10473259,10473260,10473261,10473262,10473263,10474113,10474139,10474140,10474141,10474142,10474143,10474144,10474145,10474146,10474147,10474148,10474149,10474150,10474151,10474210,10474211,10474212,10474213,10474214,10474215,10474216,10474217,10474218,10474219,10474220,10474221,10474222,10474223,10474224,10474225,10474226,10474227,10474228,10474229,10474230,10476427,10476448,10476453,10472502,10476511,10472640,10472641,10472642,10472643,10472644,10472645,10472646,10472647,10472648,10472649,10472650,10472651,10472652,10472653,10472654,10472655,10472656,10472657,10472658,10472659,10472660,10472661,10472662,10472663,10472664,10472665,10472666,10472775,10472776,10472777,10472778,10472779,10472789,10472872) 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'