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(7076288,7076334,7076335,7076344,7068745,7068750,10940406,10940407,8569790,10940446,8569799,7068842,7068854,7068924,7066566,10951245,10951246,10977304,10951247,10977347,10977350,10977351,10977361,10977369,10951343,10977450,10977456,10951505,10951508,10990619,8067859,10961902,10961920,10961921,10961930,10961931,10961932,10961943,10961945,7075323,7067446,10975138,10975139,10975140,10975141,10975142,10975143,10975144,10975145,10975146,10975147,10988306,10988326,10988327,10988328,10988329,10988330,10988331,10988332,10988333,10988334,10988339,10988340,10988341,10988344,10988345,10988346,10988356,10988361,10988362,10988363,10988364,10988365,10988366,10988367,10962474,8835455,8835456,8835462,10986031,10999087,11038178,11038199,11012217,11038233,10986362,10986390,10986391,10986395,10986396,10986397,10986398,10986399,10986400,10986401,10986402,10986403,10986404,10986405,10986406,10986407,10986408,10986409,10960443,10999800,8066204,10971731,10971759,10971760,10971772,10984779,10971834,10984906,10971922,10971929,10972032,10985044,10972045,10972057,10972058,10959087,10943315,10943317,10972450,10972451,10972452,10972453,10972454,10972563,10940744,7069422,11035157,11035300,7070079,10983790,10983793,10983794,10983795,10983796,10941887,10941892,10942002,10942003,10942004,10942008,10942011,10942020,10971283,10971284,11010447,7070814,7070826,10984515,10984516,10984517,10984518,10984519,10984520,10984521,10971556,10971561,10971562,10971564,10971569,10971570,10971573,11010574,10971574,11010575,11010579,11010580,11010581,11010582,11010583,10971592,10971593,10971615,11045771,10967786,10967787,10967788,11045801,11045803,11045804,10618147,11045807,11045810,11045811,11045812,11045813,11045814,11045823,11045824,11045825,10993918,10993991,10619885,10992637,10992639,10992641,10992642,10992645,10992649,10992651,10992652,10992653,10992654,10992655,10992656,10992657,10992658,10992659,10992660,10992661,10992662,10992663,10992664,10992669,10992670,10992685,10992686,10992687,10992688,10992698,10992704,10992765,10992766,10992819,10992921,10992922,10993015,10993016,10993017,10993018,10993024,10922949,10993175,10993176,10993204,10993205,10993206,10993207,10993228,10993258,10993261,10993264,10993265,10993266,10993267,10993283,10993284,10993285,10993286,10993287,10993288,10993289,10993290,10993298,10993299,10993300,10993301,10993302,10977779,10977780,10977781,10977782,10977783,10977784,10977785,10977786,10977787,10977788,10977789,10977790,10977791,10977792,10977793,10977794,10977795,10977796,10977797,10977798,10977799,10977800,10977801,10977802,10977803,10977804,10977805,10977806,10977807,10977808,10977809,10977810,10977811,10977812,10977813,10977814,10977815,10977816,10977817,10925675,10925676,10977890,10977892,8570282,10978192,10978199,10978200,10978201,10978202,10978203,10978204,10978205,10978206,10978207,10978208,10978209,10978210,10978211,10978212,10978213,10978214,10978215,10978216,10978217,10978218,10978219,10978220,10978221,10978222,10978223,10978224,10978225,10978226,10978227,10978228,10978229,10978230,10978231,10978232,10978233,10978234,10978235,10978236,10978237,10978238,10965279,10965338,10978428,10926280,10978429,10978447,10615820,10978518,10978548,10978558,10978560,10978612,10978680,10616048,10616049,10621122,10621123,10978789,10621154,10621269,10992031,10992032,10992033,10992034,10992036,10992124,10992139,10992147,10992148,10992149,10992150,10992151,10992152,10992153,10992154,10992155,10992156,10992157,10992158,10992159,10992160,10992161,10992162,10992163,10992164,10992165,10992166,10992167,10992168,10992169,10992170,10992171,10992172,10992173,10992294,10992298,10992299,10992300,10992315,10992316,10992330,10992333,10992337,10992360,10917300,10992593,10565214,10565215,10565216,10565250,10565251,10562268,7059796,10614317,7059855,7059859,7059861,7059862,10614568,10614569,10611582,10611606,9181961,9181962,9181969,10614784,10614822,7057480,7057483,7057484,7057486,7057490,7057521,7057526,7057529,7057531,7057532,10609285,10557500,10557501,10612500,9172217,9172219,9180538,9180561,10610279,10613298,10613368,9180794,8863542,9173054,9177307,9169839,9185958,9185983,9178004,9178005,9178006,10513832,9170049,9186056,9186058,9186059,9178090,9178091,9178092,9178093,9178094,9178222,7056389,9178223,9178224,9178225,9178226,9178227,9178228,9178229,9178230,9178231,9178232,9178233,9178234,9178235,9178236,9178237,10514051,10514052,7056413,7056414,7056415,7056416,9178263,9178310,9178353,9186367,9186371,9178372,9186415,9186416,9186423,9186424,9186425,9186433,9186434,9178436,9186440,9186442,9186445,9178458,9186465,9186473,9186483,9186486,9186507,9178530,9178540,9186554,9178591,9186654,9178661,9186662,9186669,9186678,9186685,9178691,9186701,9186706,9186707,9186708,9186709,9186712,9186717,9186718,9186719,9186720,9186721,9178723,9178733,9186745,9178746,9186747,9178777,9178789,9178794,10514830,10514864,10514865,10514866,9192367,9176787,9184796,9184797,9184798,10416988,10416989,10420002,9182400,9182404,10463004,10463053,10463054,10463055,10463056,10463059,10467120,10467159,10463439,4971963,4971964,4971965,4971966,4971967,4971977,4971983,4971987,4971992,6667143,4972000,4972001,6667163,6667164,4972022,9175184,10463802,10463819,10463820,10465828,10465832,10465833,10465837,10465895,10465896,9167321,9183339,10463919,10463920,10467989,10467991,10468005,10468023,10468049,10468076,10468088,9175511,10468103,8917182,8917189,10466307,10466366,10466367,10466379,10466426,10466432,10466433,10466444,9168119,6668185,6668186,9192210,4973065,4973066,9192261,9192262,9192266,9192267,10466858,10170208,10173619,10178734,10627724,10630024,10630100,10630102,10630105,10166629,10166632,10166738,10166756,10625240,10166833,10166844,10166853,10166855,10166862,10166863,10166865,10166867,10166868,10166878,10166888,10166892,10166908,10171964,10167107,10167111,10167176,10167630,10167666,10167667,10167668,10167669,10167670,10167671,10167672,10167673,10167690,10167692,10162711,10162712,10162715,10162716,10162718,10162719,10162720,10162721,10162722,10162723,10162725,10162770,10162773,10162774,10162775,10162776,10162777,10162785,10162796,10626275,10162800,10162803,10167806,10167809,10162816,10162817,10162818,10162820,10162826,10162830,10162831,10167997,10167998,10167999,10168010,10168040,10168157,10168163,10168164,10168171,10168173,10168174,10168177,10586181,10586182,10568619,10568620,10568857,10584585,10584586,10584588,10584590,10581636,10585046,10579454,10579524,10579696,10579697,10525197,10525208,10525248,10525249,10521250,10525250,10521251,10525251,10521252,10525252,10521253,10521254,10525284,10521289,10521290,10521291,10521292,10521316,10521317,10521318,10531514,10531515,10531516,10531517,10531518,10531519,10531646,10531657,10531662,10531663,10523692,10523693,10523694,10523695,10523696,10531726,10531727,10531728,10531729,10531730,10531731,10531756,10531757,10531758,10531759,10531760,10531761,10531762,10531763,10531764,10531765,10531766,10531767,10531771,10531772,10531776,10531777,10531781,10531782,10531791,10531826,10531846,10531847,10531849,10531851,10531889,10531922,10531923,10531953,10531976,10531979,10532002,10532003,10532063,10532064,10524156,10524238,10524245,10524265,10524266,10532331,10532385,10530389,10532426,10532471,10532472,10532473,10532502,10532503,10532504,10532505,10532506,10532507,10532508,10532509,10532510,10532511,10532512,10532513,10532514,10532515,10532518,10532527,10532528,10532529,10532530,10532531,10532532,10532533,10532534,10532540,10532541,10532542,10530542,10532543,10532544,10532545,10530545,10532546,10532547,10532548,10532549,10532550,10532551,10532552,10532577,10532578,10532579,10532596,10532597,10532598,10532599,10532600,10532601,10532652,10532664,10532665,10532666,10532667,10532669,10532670,10532671,10532695,10532696,10532697,10532698,10532699,10532702,10532703,10532704,10532705,10532706,10532707,10532708,10532709,10532710,10532711,10532712,10532713,10532714,10532715,10532716,10532717,10532718,10532719,10532720,10532721,10532723,10532724,10532725,10522726,10532726,10522727,10532727,10532728,10532729,10532730,10532735,10532736,10532737,10532741,10532742,10532743,10532744,10532745,10532746,10532751,10532752,10532753,10532755,10532756,10532761,10532762,10532763,10532764,10532805,10532806,10532809,10532810,10532811,10524815,10520831,10520832,10532833,10520833,10520834,10524853,10524854,10524858,10524859,10524860,10528861,10531008,10424001,10422056,10425068,10425069,10422124,10422157,10422158,10422159,10422160,10482994,10479190,10479198,10479200,10479350,10479351,10479352,10479364,10479365,10479366,10479367,10479388,10479389,10479398,10479402,10479403,10479404,10479415,10479416,10479417,10479418,10479426,10479427,10479428,10479442,10479463,10479506,10479507,10479516,10479517,10479518,10479519,10479568,10479572,10479574,10479579,10479583,10475735,10481976,10482014,10482020,10485113,10485117,10485118,10485121,10476392) 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'