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(8068855,8068856,10939647,7076137,7076341,7076342,10943871,8569453,4971060,10963529,4971061,10963530,4971062,10963531,10963532,10963533,10963534,10963535,10963536,10963537,10963538,10963539,10963540,10963541,10963542,10963543,10963544,10963545,10963546,10963547,10963548,10963549,10963735,7066141,7074236,4968452,8067243,7066486,7074685,7066917,7066930,7075021,7067053,7067054,7067446,7075522,10962226,7067720,7075768,7067779,10939421,7067876,10962563,7067879,7067880,8064997,10986174,10960261,10960262,10960263,10960264,7064628,10960389,10960390,10932145,10932146,10932147,4967027,4967028,4967029,8065934,8065935,7073125,7073182,10932589,10960986,10986994,10986995,10986996,7065457,10961197,7073615,7073616,4967900,4967901,4967902,7073867,7065918,10942579,11048894,10942628,10942629,11048972,11048973,10942754,10958943,10958947,10943221,10995651,10995652,7069497,7069503,10996215,3656123,3656124,10996267,10996297,10996298,10996299,10996300,10996301,10996302,10996303,10996308,10996309,10941328,10941329,10941330,10941331,10941332,10941333,10941334,10941335,10941336,10941337,10941338,10996402,10996403,10996404,10996405,10996406,10996410,10996411,10996686,7070094,10996795,10996894,11048137,11048402,11048431,10958290,10923562,10923563,10923564,10967881,10618269,10618277,10618288,10618291,10618293,10618304,10618322,10618528,10919275,10919369,10919407,10919447,10919449,10623965,10919477,10619131,10619132,10619133,10619134,10619141,10619142,10619143,10619147,10619148,10619494,10624549,8071264,8071265,10925204,10925211,10624832,10995534,10966649,10992670,10922538,10922539,10922540,10922541,10922542,10922543,10922544,10622054,10922579,10917586,10617150,10917663,10917664,10617223,10953985,10617379,10617469,10617472,10617509,10954220,10954221,10954222,10918117,10617628,10993401,10993402,10614970,10915483,10915517,8569959,10615037,10915571,10915590,10615106,10915618,10990767,10990768,10915658,10620235,10620236,10915761,10990914,10990915,10990916,8570353,10915963,10915982,10915983,10615524,10615525,10615581,10916096,10916119,10916154,10991315,10991331,10991370,10991371,10916266,10991438,10916292,10965452,10965453,10965454,10965455,10965457,10916350,10916406,10916415,10916418,10615909,10615915,10916481,10916485,10991661,10991662,10916521,10916533,10916534,10616045,10616048,10616050,10916597,10991767,10991768,10916620,10991769,10991770,10991771,10621160,10916673,10916723,10921864,10916894,10616395,10916951,10917006,10922009,10917031,10917047,10917060,10922065,10917067,10917070,10917105,10917111,10917112,10917114,10917116,10917127,10917143,10917144,10917145,10917146,10616638,10917149,10917150,10917151,10917156,10917158,10917163,10917179,10917180,10917183,10917191,10917196,10917197,10917202,10917203,10917204,10917205,10917207,10917209,10917210,10616701,10917217,10917218,10917233,10917282,10917285,10917288,10917295,10616787,10616790,10917353,10953520,10917381,10917382,10616875,10917396,10917429,10917430,10917450,10917465,7059465,7059466,10565125,10565126,10613997,10614049,10565318,10559318,10559319,10614174,10614175,10614177,9165544,10614210,10559471,10559472,10559473,10559474,10559475,10559477,10559478,7059845,7059847,7059855,7059857,7059860,10614366,10614411,10614502,10614508,10614530,10559739,10559740,10611612,9166022,8864623,8864685,10611864,6666233,6666259,10611944,10608964,10608965,10611986,10609034,10609070,10609071,10609072,7057583,9163426,10612098,7057625,7057626,7057659,10609207,10612221,9163571,10612240,10612356,9171699,9163703,10557531,9163739,9171800,9171868,10609726,8862643,10609818,10609819,10612850,10612852,10612856,10609857,10609858,10609881,10609900,10609901,10609906,10610012,10613019,7058523,10610068,7058632,8863020,8863038,10613214,10613215,7058743,10610271,10558466,10558467,10558468,10558469,10613328,10610346,10558497,10558498,10558499,10558500,10610355,10613359,10613360,10613362,10610364,10558542,10558543,10558544,10558545,7058900,7058901,10613404,7058931,7058936,7058937,10564610,10564640,10564682,10564690,7059116,10564864,10613754,10564905,10610755,10610768,10610773,10613812,10610842,9165198,10610911,10610912,10610915,10610916,10613932,10613941,10613946,9173284,4974185,4974221,4974233,4974247,9169418,4974284,4974288,4974310,4974311,4974331,4974334,10515320,10515321,7055749,9169605,9161708,7055901,7055902,7055903,10515725,10515727,9169916,4974770,4974771,4974772,4974773,4974774,4974775,4974776,4974777,4974778,4974779,4974780,4974781,4974782,9169972,9169973,9169974,9169995,10515820,7056213,9170109,7056362,9162333,10512149,9162347,9170464,9170469,9162495,9162496,9162497,10512584,10512733,10512734,7057130,10513037,10513038,10513039,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,7057424,10517072,7057425,10517073,7057426,10517074,10517075,10517076,10517077,10517078,10517079,10517080,10517081,10517082,10517083,10517084,10517085,10517086,10517087,10517088,10517089,10517090,10517091,10517092,10517093,10517094,10517095,10517097,10517098,10517099,10517100,10517101,10517102,10517103,10517104,8861815,7057463,10415312,10415313,10416321,10416322,10416328,10415387,10419398,10419427,10419450,10416460,10416468,9168560,9168561,9168562,9168563,10415496,10415497,10415498,4973438,10415508,9168627,9168628,9160647,10416569,10418581,10418582,10418583,10418584,7054883,10419653,10419654,10419655,10418740,10418741,10418742,10418743,10418744,9160961,10415887,10418914,9169021,10418969,10417981,9169136,4974011,4974012,4974013,4974014,7055363,10419166,10419172,10419173,10416182,4974140,9166321,10470976,6666546,10469149,10467260,10469282,10469283,8865234,8865250,10467314,10469340,10469341,10463412,10463413,10471461,6666919,10467558,10467606,10467607,8916779,8916780,8916781,8916782,8916783,8916784,8916785,8916786,6667156,10469906,6667429,8563381,8563382,6667489,10470179,10470180,9167671,10468258,8563593,8563594,10462305,10462306,9167769,6667795,10468506,10468558,10468559,10468607,10468608,9168099,10464678,9168102,10464730,10464731,8917804,8917805,10466838,9160279,10628373,10628640,10628814,10628905,10165441,10155627,10629143,10629144,10629256,10629958,10631992,10158628,10153853,10153854,10153855,10153856,10153857,10153858,10153859,10627754,10627775,10627776,10627948,10630023,10630024,10630100,10630154,10161841,10162106,10630654,10162236,10630848,10630849,10630865,10630866,10630942,10630943,10631546,10631549,10163250,10626732,10626739,10626740,10626741,10626744,10163276,10163277,10574296,10568474,10568493,10568520,10568544,10568559,10569179,10570067,10570068,10573288,10567318,10567319,10567357,10567358,10567359,10576395,10576396,10576397,10576456,10573474,10567847,10567962,10567963,10521336,10525367,10525368,10525369,10525370,10525371,10521485,10521553,10521554,10526114,10526115,10526116,10526117,10526118,10526119,10526120,10526121,10526122,10526123,10526124,10526125,10526126,10526127,10526128,10526129,10526130,10526131,10526132,10526133,10526134,10526135,10526136,10526137,10526138,10526139,10526140,10526141,10526142,10526143,10526144,10526145,10526146,10526147,10526148,10526149,10526150,10526151,10526152,10526153,10526154,10526155,10526156,10526157,10526158,10526159,10526160,10526161,10526162,10526163,10526164,10526165,10526166,10526167,10526168,10526169,10526170,10526171,10526172,10526173,10526174,10526175,10526176,10526177,10526178,10526179,10526180,10526181,10526182,10526183,10526184,10526185,10526186,10526187,10526188,10526189,10526190,10526191,10526192,10526193,10526194,10526195,10526196,10526197,10526198,10526199,10526200,10526201,10526202,10526203,10526204,10526205,10526206,10526207,10526208,10526209,10526210,10526211,10526212,10526213,10526214,10526215,10526216,10526217,10526218,10522218,10526219,10526220,10526221,10526222,10526223,10526224,10522224,10526225,10526226,10526227,10526228,10526229,10526230,10526231,10526232,10526233,10526234,10526235,10526236,10526237,10526238,10526239,10526240,10526241,10526242,10526243,10526244,10526245,10526246,10526247,10526248,10526249,10526250,10526251,10526252,10526253,10526254,10526255,10526256,10526257,10526258,10526259,10526260,10526261,10526262,10526263,10526264,10526265,10526266,10526267,10526268,10526269,10526270,10526271,10526272,10526273,10526274,10526275,10526276,10526277,10526278,10526279,10526280,10526281,10526282,10526283,10526284,10526285,10526286,10526287,10526288,10526289,10526290,10526291,10526292,10526293,10526294,10526295,10526296,10526297,10526298,10526299,10526300,10526301,10526302,10526303,10526304,10526305,10522466,10522467,10522468,10522505,10522506,10522507,10522508,10522513,10522522,10522523,10522571,10522900,10522901,10422272,10422284,10422285,10421213,10473533,10473539,10473547,10473553,10474184,10474199,10476427) 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'