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(10943524,3228552,8621174,3228958,3228995,11041322,3229144,3229145,3229146,3229147,3229148,3229149,10950375,8621696,8621697,8621698,8621699,8621700,8621701,10944326,10950567,10950646,10950677,10846809,10846810,10950688,8575400,8622310,3229967,3229978,11042276,11042277,8609636,8067909,10938722,8573350,8573388,8573389,11040007,10962191,10962452,8068822,7201225,7201226,7201227,7201228,7201229,7201230,7201231,7201232,7201233,7201234,7201235,7201236,7201237,7201238,7201239,7201240,7201241,7201242,7201243,7201244,7201245,7201246,7201247,7201248,7201249,7201309,7201485,7201486,10842994,10960059,10960060,7201778,7201872,7201921,7201939,7201961,7201970,7201972,7201973,7201975,10960434,10960474,11038477,11038478,11038479,11038480,8065853,7202124,7202136,7202137,7202138,7202139,7202140,7202189,10104080,7202205,7202206,7202209,10999681,8618849,7202259,7202299,7202300,7202301,7202302,7202303,7202304,7202306,7202307,7202309,7202310,7202349,7202350,7202357,7202359,11000322,8573014,3237399,8616856,8064007,11010826,11010827,11010828,8910239,8910240,8910241,10958965,8064275,7200645,7200653,7200655,7200656,7200657,7200658,7200659,7200682,7200688,7200689,7200697,7200699,7200709,7200710,7200711,7200712,7200715,7200722,7200723,7200724,7200725,7200726,7200727,7200728,7200729,7200730,10842286,10959234,10959258,8835179,10959615,10100119,10100187,7198356,8615240,7198690,8908503,7198734,7198735,7198744,7198745,7198760,11009213,8615478,8615479,8615480,8909090,8909091,11009753,11009754,7199353,7199356,10101319,10101320,10101461,7200135,8906052,8906068,8906069,8906070,8906116,7196330,7196346,10967808,10967809,10967810,10967811,10967812,8613011,7196455,7196456,7196457,7196458,7196459,7196460,7196461,7196462,7196463,7196464,7196465,7196466,7196467,7196468,7196469,8906312,10618300,10618301,10618304,8906367,8906503,10838635,10838831,11007796,7197630,7197636,7197649,8907465,7197674,7197676,7197681,7197728,7197729,10995175,10995176,10995177,10995178,10995179,10995180,10995181,10995182,10995185,10995186,10995187,10995188,10995189,10995190,10995191,10995192,10995193,10995194,10995195,10995196,10995197,10995198,3235053,8614537,8614538,8614539,8907806,11047512,11047513,10624899,10624908,10619928,7198169,7198170,8905000,10616998,10617002,10617079,10617081,10617083,10617086,10617089,10617092,8611921,8611925,10617134,10617135,10617136,10922658,10617162,10617163,10836971,11044914,10953926,10953951,10953958,10953959,8905332,10954002,10954003,10954004,10617372,8905432,8905433,10617407,10617408,10617424,10617445,8905531,10617777,8905869,8905917,8905918,8905923,11006554,11006582,11006599,11006600,11006601,10925486,10614983,10615001,10615002,10425459,10425570,10425571,10425574,10425587,10615257,10615269,10615315,10615335,10615371,10615399,10425767,10615568,10615569,10615573,10425936,10426009,10848441,10426193,10426195,10620857,10426196,10426199,10930827,10426278,10426279,10426280,10426281,10426282,10426283,10615971,10615972,10426334,8610926,8610927,8540631,10991864,10991865,10991866,10991875,10991876,10991877,10991891,10991892,10991907,10991908,10991909,10991910,10991911,10991912,10991913,10991919,10991920,10991921,10991922,10991930,10991931,10991932,10991934,10991935,10991936,10991937,10991939,10991941,10991942,10991943,10991944,10991945,10991994,8611238,8611345,8611346,8611347,8611388,8611448,8611490,10616685,10616737,10427109,8904951,10992594,10565127,9205340,9205413,9205416,9205417,7059643,7059644,10562342,10562343,10562344,10562345,10562346,10562347,10562348,10614216,10614221,10611267,10614314,10614376,10614411,10614433,10614436,10614437,10614475,10614489,9197862,10614566,10559727,10559748,10559749,6670227,6670229,10611730,10611739,10611754,10611755,10611756,10611784,10611808,10614864,9166228,10614892,10614898,10614899,10614901,10614902,10614909,10614911,10614915,10614916,10614920,10614934,10614960,10612053,10612191,10612192,10612201,10612221,7017279,7017280,10612294,7017301,7017302,7017303,7017304,10612324,10612325,10612334,7017337,7017338,7017339,7017340,7017341,7017342,10609360,10612370,10612371,10612423,10612530,7058143,10609724,10612729,10609744,10612769,10609772,10612781,10612810,10612854,10609880,10612926,10612940,7017936,7017948,7017956,10609974,7017968,7017976,7017988,10610006,10613060,10613367,10613368,10558596,10610497,9164837,10613693,6677253,6677254,6677255,6677256,6677257,6677258,6677259,6677260,6677261,6677262,6677263,6677264,6677265,6677266,6677267,6677268,6677269,6677270,6677273,6677274,10613760,10610773,9173125,10613823,10610909,9205252,10610915,10511115,10511116,10511117,10511118,10511119,10511152,10515264,10515265,10117682,10117683,10117694,10515317,10511383,10511384,10511385,10511386,6673817,10117838,10117839,10117928,10117956,10117957,10117958,10117966,10117974,10511619,9169846,10511713,10511714,10511715,10511716,10511717,9169905,6674120,9161915,9169946,9170042,9170063,9170065,9170067,10118284,6674308,8551401,6674317,8551412,6674321,8551417,8551418,10514058,10512068,10512069,10514141,10514142,10514143,10514144,10118557,10514266,8551764,9178497,10514333,10514334,8551871,7016239,7016240,7016241,7016242,10514549,10514550,10514551,10514552,10514553,10514562,10514570,10514615,10514616,10514617,10514618,10514619,10514620,10514621,10514622,10514623,10514624,10514625,10514639,10514641,10514642,10514643,10514670,10514671,8552174,8552180,10514714,10512750,10512768,10512772,10514782,10514784,10514785,10514786,10514787,10514788,10514789,10514790,10514791,10514792,10514793,10514795,10514796,10514797,10514798,10514799,10514802,10514803,10514804,10514805,10514806,10514807,10514810,10514811,10514829,10514835,10514836,10514837,10514838,10514839,10514840,10514841,10514842,10514843,10514844,10514845,10514846,10514847,10514848,10514849,10514850,10514851,10514852,10514853,10514854,10514855,10514856,10514857,10514858,10514859,10514860,10514861,10514862,10514863,10514864,10514865,10514866,10514867,10514868,10514869,10514870,10514871,10514872,10514873,10514874,10514875,10514876,10514877,10514878,10514879,10514880,10514881,10514882,10514883,10514884,10514885,10514886,10514887,10514888,10514889,10514890,10514891,10514892,10514893,10514894,10514895,10514896,10514897,10514898,10515069,10515087,10515088,7057461,10416222,9168304,10416227,9168308,6672570,4973239,6672597,10415315,10415327,10415328,10417364,10416367,9192457,9192458,9192459,9192460,10416385,10419403,10416414,9168518,9168546,10419470,10417495,9168593,9168595,9168596,9168598,9168615,10415605,9168688,10415680,10419797,6673087,6673092,10418812,10419832,10419833,6673119,6673124,10418850,10418852,9169027,10418950,10418967,10418968,10417012,9169096,10117317,10416045,6673343,10117376,10117378,10117401,10117411,9169216,10419181,10416198,10416200,7055453,8549458,10471029,9166511,6670776,8549836,8549848,8549851,8549858,8549866,8549876,10123134,10469519,10469520,10467622,8550207,8550231,8916775,8916776,8916777,8916793,9191198,9191216,9191217,9191218,10463827,10469869,10469872,10469873,10469880,9167844,10468506,10468551,10468773,10468774,10468775,10468776,10468777,10468778,10468779,10468780,9168227,9168228,10888507,10888512,10888601,10883678,10889086,10884098,10884194,10889256,10889275,10889338,10889466,10884546,10884547,10884548,10884549,10155575,10884739,10884781,10884782,10884821,10879878,10879882,10160916,10884914,10161009,10875088,10875089,10885110,10885120,10875131,10885152,10885273,10885274,10885275,10885276,10885277,10885312,10885390,10877545,10877560,10887563,10877588,10877598,10887663,10158721,10158723,10158724,10887713,10158733,10158735,10158736,10158738,10882740,10158757,10158763,10158775,10882792,10627300,10627301,10887826,10887838,10887847,10887851,10887874,10882925,10887997,10887998,10627634,10888149,10883162,10888260,10883357,10888430,10171538,10630022,10171669,10885669,10885678,10885690,10161983,10885990,10885995,10886080,10886119,10886120,10886121,10162136,10162137,10886322,10162371,10881546,10881550,10626112,10626113,10626114,10626225,10626226,10626227,10626228,10626259,10167926,10167968,10167969,10626473,10168017,10168067,10168068,10887149,10887269,10882317,10882319,10882373,10626896,10882436,10583441,10590308,10599317,10599321,10599322,10644383,10647472,10590475,10590476,10590477,10590478,10647630,10647686,10567673,10567694,10567695,10567696,10521566,10521567,10537572,10537573,10537574,10534381,10546473,10522580,10522581,10522582,10522583,10522584,10522585,10522586,10528630,10528631,10528632,10528633,10528634,10528635,10546636,10528636,10528637,10544692,10542957,10539016,10505557,10505558,10505559,10505560,10505561,10505562,10505567,10505568,10505569,10505576,10505579,10407242,10407304,10407305,10407920,10407921,10407933,10407939,10407943,10407945,10407970,10408678,10408679,10408680) 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'