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(10939568,10939589,10939590,10939591,10962567,10962568,10962570,10962571,7075887,10962572,7075888,10962573,7075889,7075890,10962574,7075891,10962575,10962576,10962577,7067899,7067982,7067984,7067992,10939718,7076003,10939719,10939720,10939721,10939722,7076042,4970451,4970452,4970453,4970454,4970455,4970456,4970457,4970458,4970459,4970460,4970461,4970462,4970463,4970464,4970465,4970466,4970467,4970468,4970469,4970470,4970471,4970472,4970473,4970474,4970475,4970476,4970477,4970478,4970479,4970480,4970481,4970482,4970483,4970484,10939879,10939880,10939881,7068166,7076171,7068172,7068180,7068190,10939906,10939907,10939908,10939909,7076257,7068292,7068315,4970677,7076395,4970767,4970773,4970774,7068439,7068441,7068452,10940184,10940185,8569451,8569540,7068615,7068620,7068623,10963309,10944221,4971070,7068761,7068762,7068763,7068764,7068767,7068768,7065886,4968229,10976619,7074026,10963717,10963767,10963768,7074113,7074119,7074125,10976899,7074227,7066342,4968682,4968692,7066417,7066418,8067521,4968861,4968862,10977289,10977305,10977306,10977307,10977333,10977334,10977335,10977336,10977341,10977367,10977368,10977369,10977370,10977371,10977372,10977373,10977374,10977375,10977376,10977377,10977378,10977379,10977380,10977381,10977382,10977383,10977384,10977385,10977386,10977387,10977388,10977389,10977390,10977391,10977392,10977393,10977394,10977395,10977396,10977397,10977398,10977399,10977400,10977426,10977467,7066830,7066881,8067910,7066946,7067095,7067102,7067109,7067132,7075133,7067134,7067171,7075182,7067257,7067258,7067259,7067260,7067261,7075261,7067262,7075262,7067263,7075263,7067264,7075264,7067265,7075265,7075266,7067266,7067267,7075267,7075268,7075269,7075270,7075271,7075272,10961958,10961959,7067292,7067315,7067333,7067360,7067412,7067444,8068462,8068463,8068470,10962176,10962177,7075527,10939347,10939348,10939349,10939350,10939351,10939352,7067645,7067646,7067699,7075753,7075754,7075755,7075756,7075757,7075758,7067765,7067766,7075771,7075773,7071928,6000258,6000259,7071983,7072020,7072031,10972787,10972788,10959883,10959884,10959885,10959886,10959887,10959888,10959889,10959890,10959891,10959892,10959893,10959894,10959895,10959896,7064306,10960005,7064438,7072460,10973168,10973169,10973170,7064585,7064589,10960309,10960310,8065717,8065718,8065719,8065720,8065721,10960433,10932189,10932194,7064794,7064816,7072824,7072827,7072926,8066076,8066077,10932454,7065096,7065154,7065157,7073276,7073305,7073314,7073325,10932779,10932780,10932942,7073559,7073644,7065648,4967985,7073698,7065703,7065749,7065765,10971550,7071123,7071270,7071273,7071274,7071295,10958987,10958988,10958989,7071306,7071309,7071311,7071315,8861308,10943138,7071448,10943175,8861383,10943196,8861390,8861392,10943226,10943227,10943256,7071567,8861471,8970238,7068828,10944346,7068914,7068999,7069225,7069321,10944863,10944864,10944881,7069382,7069394,7069397,7069482,7069602,3656343,3656344,3656345,3656346,3656364,3656365,3656366,3656541,3656644,3656654,3656655,3656657,3656681,7070019,7070102,7070103,7070114,7070138,3656844,3656905,3656906,3656907,3656908,3656916,3656956,10942056,7070470,7070471,7070472,7070487,8860562,8073514,8073515,8073516,10942430,10958464,10958465,10958466,10958468,10958469,10958470,10958471,10958472,10954629,10618156,10618294,10618295,10618296,10618297,10618298,10618299,10618300,10618301,10618302,10618303,10618304,10618305,10618306,10618307,10618308,10618309,10618310,10618311,10618312,10618313,10618314,10618315,10618316,10618317,10623387,10954987,10623471,10618855,10618856,8070773,10619213,10619240,10619345,10619346,10619351,10619460,10619461,10619887,10619890,10619892,10619893,10619894,10619896,10619897,10619961,10927500,10953598,10953599,10953600,10953601,10953602,10953603,10953604,10953605,10953627,10617162,10617163,10617164,10953723,10622525,10928063,10928066,10954096,10928118,10954311,10954312,10622928,10622929,10622932,10619962,10920475,10920476,10920477,10920478,10614969,10614984,10614985,10614986,10614987,10620019,8569867,8569868,10620084,10620085,10620086,10620087,10620088,10620089,10620090,10620091,10620092,10620093,10620094,10920611,10920612,10920613,10920614,10920615,10920616,10620385,10620414,8570364,10926056,10926057,10926058,10615550,10926129,10926130,10926131,10926132,10926133,10926134,10926135,10926136,10926137,10926138,10926139,10926140,10926141,10926142,10926143,10926144,10926145,10926173,10926250,10926251,10926252,10930646,10930687,10921388,10921389,10921390,10921391,10921392,10921393,10921394,10921395,10921396,10921397,10921398,10921399,10921400,10921401,10921402,10921403,10921404,10921405,10921406,10921407,10921408,10921409,10921410,10921411,10921412,10921413,10921414,10921415,10921416,10921417,10921418,10921419,10921420,10921421,10921422,10921423,10921424,10921425,10921426,10921427,10921428,10921429,10921430,10921431,10921432,10921433,10921434,10921435,10921436,10921437,10921438,10921439,10921440,10921441,10921442,10921443,10921444,10921445,10921446,10921447,10921448,10921449,10921450,10921451,10921452,10921453,10921454,10921455,10921456,10921457,10921458,10921459,10921460,10921461,10921462,10921463,10921464,10921465,10921466,10921467,10921468,10921469,10616055,10930918,10621118,10930979,10930981,10926701,10926702,10952751,10952752,10952756,10952757,10916877,10621371,10621372,10616471,10616554,10927066,10927067,10927068,10927069,10616559,10927070,10922179,10616698,10616739,10611048,10611064,10565347,10565348,10614323,10614327,10614328,10614329,8864219,8864291,8864293,8864294,8864295,8864296,8864297,8864298,8864299,8864300,8864301,8864302,8864303,8864304,8864305,8864306,8864308,8864309,8864310,8864311,8864312,8864313,8864315,8864316,8864318,8864319,8864320,8864321,8864322,8864332,8864334,8864337,8864564,10614718,10614719,10614720,8864591,10611801,10614814,8864676,10611916,10566083,10611934,10611994,8861926,10612108,8861968,8861969,10612180,10609270,10609271,10609272,10609273,10609274,10609275,10609276,10609277,10609278,10612408,10612409,10612410,8862349,10612536,10612575,10612797,8862708,10612974,8862836,8862837,8862838,10613074,10613114,10613158,10613163,10610190,10610191,10613225,10610268,10610293,10610374,10610468,10561622,10561642,10561643,10561672,10561673,10561694,10561695,10561696,10561700,10561719,10561720,10561721,10561722,10561723,10561724,10561732,10561733,10561734,10561735,10561736,10561737,8863471,10610666,10610719,10610721,10613787,10610836,10515133,10513134,10513135,10513136,10513137,10513138,10513139,10515139,10515140,10515141,10515142,10515143,10513227,10513228,10513229,10513230,10513231,10513232,10517272,10517273,10517274,10513275,10517275,10513276,10517276,10513277,10513278,10513279,10513280,10513281,10513282,10513283,10513284,10513285,10513286,10517290,10517291,10517292,10517293,10517294,10517295,10517324,10515341,10515342,10515494,10517573,10517594,10517595,10513758,10513769,10513770,10513771,10513834,10513835,10513836,10513837,10513838,10513839,10513840,10513841,10513842,10513843,10513844,10513845,10513846,10513847,10513848,10513849,10513850,10513897,10513898,10513935,10513936,10513937,10513949,10513950,10514058,10514059,4975225,4975227,10514290,10514641,10514642,10514643,10514804,10514825,10514886,10514887,10514888,10514889,10514890,10512904,10516931,10418248,10418249,10418253,10418254,10416260,10416261,10416263,10416267,10416268,10416279,4973280,4973308,4973341,10416435,10419571,10418676,10418689,10418710,10418794,10415822,10415837,10419013,10420060,10416063,10420152,10420169,10420170,10419191,10466985,10466986,10466987,10466988,10466989,10466990,10463013,4971332,10467107,10467125,10467126,10467127,10467128,10467129,10467130,10467131,10467132,10467133,10467134,10467135,10467136,10467137,10467138,10467139,10467140,10467141,10467142,10467143,10467144,10467145,10471168,10471246,4971649,4971650,4971651,10467409,10463429,10463430,10463431,10463432,10463433,10463434,10463435,10463436,10463437,10463438,10463439,10467495,10471567,4971938,4971939,4971940,10469664,4971941,10469665,10469666,4971946,10463675,4971952,4971959,4971960,4971962,4971964,4971965,4971966,4971967,4971968,4971969,4971970,4971971,4971972,4971973,4971974,4971977,10463739,10463740,10465769,10469772,4972105,10463833,10463931,10468036,10468060,10468074,10468108,8563471,10468157,8563564,10466243,10466309,10462425,10470651,10470652,10470653,10466849,10627019,10627291,10627293,10627294,10627779,10626140,10626141,10626365,10626499,10626816,10626822,10626823,10626829,10568473,10568474,10568475,10568476,10520275,10520276,10520771,10520782,10520786,10520793,10520795,10520796,10520797,10520814,10521026,10521027,10521028,10521029,10420229,10420302,10420575,10420576,10420577,10420578,10420678,10420709,10420710,10420711,10472554,10472555) 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'