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(11014519,7067937,7067938,7067944,7067945,7067946,7067947,10988875,10988892,10988930,10988931,10988951,10940013,10940014,10940015,11014985,10940016,10989035,10989036,10963304,8569741,7073847,7065856,8067028,7073959,7066174,10437278,10437279,10437280,10437281,10437282,10437283,10437284,8067423,11016119,11016257,11016258,8067918,11013779,11013780,7075233,7075240,7075257,7075262,11026959,7075281,7075282,7075284,10988095,10988096,7075520,11001268,10939381,8068794,6000122,10959549,10959550,7071882,8065085,8065090,8065092,7064072,10931541,10931542,10931543,10931544,10931819,10931828,7064446,10960160,10973204,10973205,10973206,10973207,10973208,10973209,10973210,10973211,10986213,10931995,11012306,11012307,10960386,10960387,10960388,10960389,10960390,10960391,10960392,10960393,10960394,10960395,10960396,10986741,10986742,10986743,10986744,10986745,8066140,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,10932625,10932626,7073463,7073579,7073580,11013470,11013471,11013472,11013473,11013474,11013475,11013476,11013477,11013478,11013479,11013480,11013481,10942536,10997584,10997585,10997586,10997587,11010613,11010650,8860954,8860955,8860956,8860993,8861198,8861199,8861200,7071398,10972181,10972190,10943228,10985237,11011287,11011288,11011289,11011290,11011291,11024292,11024293,11024324,11024325,11024326,11024327,11024328,10944634,10944635,10944636,10944637,10944638,10944639,10944640,10944641,10944642,10944643,10944644,10944657,10944658,10944659,10944660,10944661,10944662,10944663,10944664,10944665,10944666,10944667,10995918,10995919,10995920,10995921,10995922,10995923,10995924,10995925,10995926,10995927,10995928,10941054,10941055,10941056,10941057,10941058,3656110,10996243,10996250,10996251,10996283,10996288,10941376,8072650,8072655,8072670,8072675,8072695,10996563,10996564,10996565,10996566,10996567,10941707,10941945,3656943,8860263,11023064,11023065,11023066,11023067,11023068,10942112,10942113,11010128,11010129,11010130,11010131,11010132,11010133,11010134,11010135,11010136,11010137,11010138,11010139,11010140,11010141,11010142,11010143,11010144,11010145,11010146,11010147,11010148,11010149,11010150,11010151,11010152,11010153,11010154,11010155,8860385,10958362,10958363,10958364,8970004,11010438,11006576,11006606,11006723,10967838,11020155,11020156,10623705,10623706,10623707,10623708,10623709,10623710,10623711,10623712,10623713,10623714,10623715,10618821,10618822,10618823,10618824,10618825,10968394,8070962,8071013,10994930,10994931,10995306,10619895,10922538,10922539,10922540,10922541,10922542,10922543,10922544,10922579,11005660,11005661,11005662,11005663,11005680,10617224,10617472,10928119,10928120,11006247,10928256,10928257,10928258,10928259,11006461,11006462,11006486,11006491,10614983,10614984,10614992,10614994,10614995,10964547,10615040,10920601,10920602,10920620,10920621,10920622,10920623,10920624,10920625,10920626,8570032,10615276,10620309,10620310,10620311,10620312,10620313,8570220,10620430,10620431,10620432,10620433,10620434,10620435,10620436,10615441,10926027,10926077,10926078,8570412,11004129,10926141,8570485,10926180,11004415,10965457,10616004,11004633,11004639,10991680,10991681,11004738,11004827,11004828,10616321,10922073,11005170,10927435,11005488,10610980,10611065,9181417,7059607,9189447,9189455,9189470,9189471,9189472,10614315,10611396,10565549,10565550,10565551,10565552,10565553,10565554,10565555,10565556,10565557,10565558,10565559,10565560,10565561,10565562,10565563,10565564,10565565,10565566,10565567,10565568,10565569,10565570,10565571,10565572,10565573,10611423,10565574,10565575,10565576,10565577,10565578,10565579,10565580,10565581,10565582,10611432,10565583,10611434,10565584,10565585,10565586,10565587,10611438,10565588,10611439,10565589,10565590,10611441,10565591,10611442,10565592,10611443,10565593,10611444,10565594,10611445,10565595,10565596,10565597,10565598,10565599,10565600,10565601,10565602,10565603,10565604,10565605,10565606,10565607,10611469,10562628,10562629,10562630,10562631,10562632,10611531,10565700,10565701,10614551,10565702,10565710,10565711,10611562,10565712,10565713,10565714,10611564,10565715,10565716,10565717,10565718,10611671,10611675,10611676,8864664,10611826,8864723,10611880,10566063,9190298,7057535,9187393,10612063,7057656,7057684,7057685,7057686,7057687,10609349,7057867,7057868,10557533,10557534,10557535,10557536,10557537,10557538,10557539,10557540,10557541,10557542,10557543,10557544,10557545,10557546,10557547,10557548,10557549,10557550,10557551,10557552,10557553,10557554,10557555,10557556,10557557,10557558,10557559,10557560,10557561,10557562,10557563,10557564,10557565,10557566,10557567,10557568,10557569,10557570,10557571,10557572,10557573,10557574,10557575,10557576,10557577,10557578,10557579,10557580,10557581,10557582,10557583,10557584,10557585,10557586,10557587,10557588,10557589,10557590,10557591,10557592,10557593,10557594,10557595,10557596,10557597,10557598,10557599,10557600,10557601,10557602,10557603,10557604,10557605,10557606,10557607,10557608,10557609,10557973,10612924,10612990,9188332,10610073,10610077,10610093,10613153,10610176,9188645,9188654,9188655,9188656,9188657,9188658,10564471,10610321,10564472,10564473,10564474,10564475,10564476,10564477,10610327,10564478,10564479,9188667,10564480,10564481,10564482,10564483,10564484,10564485,10564486,10564487,10564488,10564489,10564490,10564491,10564492,10564493,10564494,10564495,10564496,10564497,10564498,10564499,10564500,10564501,10564502,10564503,10564504,10564505,10564506,9188696,9188697,9188698,9188699,9188700,9188701,9188702,9188703,9188704,9188705,9188706,9188707,9188708,9188709,9188710,9188711,9188712,9188713,9188714,10610418,9188806,9188975,10613647,10610698,10610724,9173277,9169461,9169483,10515437,10515438,10515439,9185660,9185664,9185669,4974611,7056237,9162102,4975123,4975124,9186529,10514436,10514437,2809391,9178928,9171126,8861685,9160374,9160415,4973367,4973368,4973369,4973370,4973371,4973372,4973373,4973374,4973375,4973376,4973377,4973378,4973405,4973406,10415499,10415500,8918230,4973443,9160604,9176782,9176783,9176784,9176785,10416799,10416800,9177003,9177004,9177005,9177006,9177007,9177008,9177009,9177010,9169022,10420037,9185123,10419061,9161211,10420149,8864870,6666458,4971644,10467410,10467411,10467412,10467413,10467414,10467415,10467416,10467417,10467418,10467419,10467420,10467421,10467422,10467423,10467424,10467425,10467426,10471476,6667086,6667087,9175128,10465755,9175286,10469970,10469971,9183523,9183524,9183525,9183526,6667535,6667536,6667537,8563537,9167650,9167651,9167652,9167653,8917322,4972673,4972674,4972675,9175873,9167891,10468480,8917575,9167960,9175963,9176035,10462639,8917840,10169552,10628546,10628547,10628740,10628786,10628832,10628922,10170729,10175782,10629293,10155826,10171155,10171156,10171291,10171292,10166405,10626986,10627091,10627092,10627093,10168840,10168841,10168842,10168843,10153890,10153891,10168912,10168913,10168914,10168915,10168916,10164002,10164003,10627716,10627931,10624967,10630149,10630153,10630154,10161844,10161848,10625351,10161920,10161947,10167363,10167364,10626341,10163239,10626732,10626733,10626734,10626739,10626740,10626741,10626743,10626744,10626753,10626754,10626755,10626756,10626906,10626907,10569009,10569010,10569011,10569012,10569013,10569014,10566190,10569487,10570067,10570068,10570069,10570070,10570071,10570072,10570086,10570087,10570088,10570252,10570482,10567546,10567711,10579830,10571030,10571031,10571032,10571033,10571034,10571035,10571036,10571037,10521565,10520740,10520741,10520742,10520829,10520830,10520831,10520832,10520833,10520834,10522922,10522923,10423221,10422272,10420282,10422296,10422297,10422298,10420383,10423535,10421594,10421595,10421596,10421597,10421598,10420848,10420900,10420921,10420922,10420923,10420926,10420927,10420928,10420929,10420930,10420931,10420932,10480980,10480981,10480982,10473249,10473250,10473251,10473252,10473253,10473254,10473255,10473256,10473257,10473656,10473657,10473658,10473659,10473660,10473661,10473662,10473663,10473664,10473665,10478206,10478207,10478275,10478276,10478277,10478278,10478279,10478280,10478281,10478282,10478283,10478284,10478285,10478286,10478287,10478288,10478289,10478290,10478291,10478292,10478293,10478294,10478295,10478296,10478297,10478298,10478299,10478300,10478301,10478302,10478303,10478304,10478305,10478306,10478307,10478308,10478309,10478310,10472501,10472503,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) 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'