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(11001658,11001659,7076154,7068308,7068309,7068339,11002060,11002061,10989161,10989162,11002266,11002267,4970921,7068709,11002483,8569809,11002633,11002634,11002635,10963805,7074164,11002932,11003034,11003186,11003187,11003188,11003292,11003293,8067615,8067646,11003380,11003381,8067675,8067716,7074750,11003505,11003506,7074831,7074843,7074849,7074859,7074892,7066927,10961664,10961665,10961666,10961667,10961668,10961669,10961670,8067956,8067957,8067958,8067959,8067991,8067992,8067993,8067994,8067995,11013821,8068067,8068068,8068069,8068070,8068071,8068072,10987879,10987880,10987881,10961908,10961909,10961910,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,10987968,10987992,11014020,10988039,10988040,8068253,8068307,8068363,8068364,8068365,8068366,8068367,8068368,8068398,8068430,8068431,11014251,8068473,8068484,8068519,11014357,8068602,8068608,8068619,8068652,8068653,8068672,8068691,8068699,8068724,11001521,11001523,11001524,8068750,8068755,8068756,10972729,10972730,10972731,7072350,7072361,7072370,7072373,7072397,7072398,11012197,11012198,7072618,7072619,7072620,7072677,7072721,7072767,7072768,8065794,7072820,8065812,10932202,10932207,10932208,10986546,10986547,10986548,10986549,10986550,10986551,10986552,10986553,10986554,10986555,7072917,8066219,8066220,8066221,8066249,8066306,8066307,8066401,8066402,8066433,8066434,8066475,11000201,11000265,11000266,11000267,11000268,8066572,8066601,8066602,8066615,8066645,8066646,8066647,8066648,8066649,10961402,11000425,8066760,8066761,8066762,8066763,10961528,8066827,8066828,8066874,8066875,8066895,8066904,11049011,7071158,11049101,10942830,10942926,10942970,10942971,10943017,10943041,10943046,11049340,10943090,10972170,10985253,10985259,10985260,10985271,10985272,10985274,10985275,10985276,10985287,10985300,10985383,10985384,10985385,10985386,10985387,10985388,10985389,10985410,10985411,10985489,10985490,10985491,10985492,10985493,3655512,3655513,3655517,3655518,3655519,7068964,11008673,7069038,10940693,10995757,10940715,10940716,10995796,10995871,10970022,11009204,10996328,11009529,3656595,10997099,10997100,10997222,10997223,10997318,10997319,10997379,11006628,10923495,10923496,10923497,10618026,10618027,10918541,10918542,10918543,10918544,10918545,10918546,10923548,10923549,10923571,10923581,10923630,10618155,10923762,10923763,10923764,10923765,10923766,10923767,10923768,10923769,10923770,10923771,10623306,10923843,10923844,10923845,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10918962,10918963,10923983,10923984,10923985,10924071,10924072,10924073,10924074,10924075,10924107,10924173,10924174,10924175,10919183,10924235,10924236,10924237,10924238,10924267,10924274,10924275,10919316,10919317,10919318,10919319,10994595,10924448,10994596,10924449,10924450,10924451,10924452,10924453,10924454,10924455,10924456,10924457,10924458,10924459,10924460,10924461,10924462,10924463,10924464,10924465,10924466,10924467,10623959,10994697,10994698,10994765,10924771,10919858,10919859,10919860,10919861,10919862,10919863,10919864,10919865,10924915,10924916,10924917,10924918,10925116,10925117,10969305,10969306,10969307,10969308,10969309,10969310,10925172,10925288,10925289,10925290,10925291,10925292,10925293,10925294,10925295,10925296,10925397,10925398,10925466,10925467,10925468,10925469,10925470,10617000,11005681,10617086,10617087,11005759,11005760,10922653,10922654,10922655,10922656,10922657,10922658,10922659,10922660,10922661,10922662,10922663,10617155,10617156,10922676,10922686,10922720,10617218,10922743,10617255,10922772,10922773,10922774,10622406,10923007,10923041,10923069,10923070,10923071,10923072,10923084,10923095,10923130,10923131,10923157,10923158,10980365,10923242,10923243,10923295,10923296,10923297,10923298,10923299,11006453,10923368,10918376,10918377,10622909,10923431,10923457,10923458,10925495,10615088,10615266,10920781,10920782,10925850,10925870,10620371,8570351,8570354,8570355,10920997,10615681,11004355,10930646,10615717,10921282,11004561,10921427,10921551,10921650,11004885,11004886,10921782,10921783,10621288,10621289,10616334,10616335,10616336,10616337,10616338,10616339,10616340,10616341,10616342,10616343,10921904,10921905,10921906,10921907,10921908,10921909,10621426,10621450,10616462,10621531,10621532,10621533,10621568,10621621,10621622,10621623,10621625,11005312,11005313,11005314,11005315,11005316,11005317,11005318,11005319,10621667,10621674,10621677,10621678,10621679,10621680,10616689,10616690,10616691,10616692,10621728,10621746,10621747,7059522,10614160,10611236,10611293,10614296,10614299,10614377,10614407,10611520,10611521,10611522,10611523,10611524,10611525,10611526,10611527,10611528,10614532,10614637,10562957,10562958,8864814,10612104,10612105,7057771,10612414,10609667,10609677,10609678,10612848,10612883,10612909,10613075,10613293,10613300,10613301,10613365,10613388,10613391,10613394,10613395,7058919,10613496,10613540,10613541,10613543,10613544,10613546,10613547,10613548,10613553,10613554,10613559,10613561,7059082,8863439,7059117,8863500,10613652,10613663,10613664,7059169,10613672,10610706,7059239,8863620,8863623,7059289,7059290,7059393,7059410,7059434,7055538,9169720,10555585,10555586,10555587,10555588,10555589,10555590,4974765,4974766,4974769,4974776,4974783,4974824,4974842,4974871,4974872,4974873,10555848,10555849,4974890,4974891,4974892,4974893,4974894,4974895,2809395,2809398,10512814,10516998,10516999,9171192,9171214,10415325,9168889,9168957,9168958,9169111,10420065,10417131,10469162,10469164,10469185,10469189,10469196,10469211,10469237,10469250,10469533,10469534,10467570,9175054,10465682,10465683,10465684,10465685,10465686,10465687,10465688,10465689,10465690,10465691,10465692,10465693,10465694,10465695,10465696,10465697,10465698,10465699,10465700,10465701,10465702,10465703,10465704,10465705,10465706,10465707,10465708,10465709,4972043,4972165,10467921,10469928,4972204,10467929,4972224,10467972,4972254,8563376,8563378,8563390,10468090,10470112,8917217,4972446,10468222,10470403,10470524,10470671,10169485,10169486,10169487,10169512,10169513,10169536,10169555,10164589,10628091,10169632,10169633,10169712,10169721,10169737,10169769,10169770,10169781,10169782,10169792,10169793,10169794,10169817,10169876,10169922,10169940,10169941,10169981,10170031,10165241,10165242,10170327,10170441,10170442,10170443,10170567,10170652,10170653,10166089,10166193,10629936,10629937,10168485,10168506,10168507,10168586,10168587,10168588,10168624,10168632,10168633,10168816,10168844,10168896,10168898,10168948,10168949,10168958,10168959,10168960,10168988,10168989,10169033,10169080,10169081,10169082,10169083,10169084,10169085,10169160,10169161,10169162,10169180,10169202,10169203,10169204,10169205,10169206,10169207,10169208,10169254,10169255,10169286,10169287,10169288,10169289,10169290,10169353,10169354,10169355,10169356,10169357,10169358,10169379,10169388,10169389,10169420,10169421,10169422,10169423,10630070,10630071,10630103,10166719,10166720,10166721,10166722,10166811,10166812,10166855,10161884,10166955,10166956,10630533,10630534,10630535,10630536,10630537,10630627,10162177,10167198,10167199,10630730,10630731,10630732,10630733,10167310,10167349,10630863,10630864,10630917,10630918,10630919,10630920,10630921,10630922,10631003,10631029,10162689,10162690,10162691,10162692,10162693,10162694,10162695,10162696,10162697,10162698,10162699,10162700,10162715,10162716,10162717,10631214,10631215,10631216,10631217,10631218,10631219,10631220,10631229,10162796,10168054,10168098,10168214,10168215,10168303,10168304,10168305,10168306,10168307,10168308,10168375,10168415,10577229,10571495,10577571,10577572,10577573,10577574,10577575,10577576,10577577,10571667,10580694,10568705,10580706,10568706,10580707,10577770,10580804,10580805,10580806,10574825,10568910,10577934,10577935,10577936,10571947,10571948,10580952,10574966,10574967,10574968,10574969,10574970,10581015,10581076,10578097,10575215,10575216,10575217,10575218,10572371,10572372,10575466,10575578,10575579,10575580,10578934,10578935,10578936,10578937,10578938,10578939,10575999,10579138,10576779,10576780,10576781,10576782,10576783,10576784,10576785,10576786,10576989,10523750,10527768,10523769,10523770,10523771,10523772,10523773,10523774,10523775,10523776,10523777,10523778,10523785,10523786,10523787,10523788,10523799,10523800,10523801,10523802,10527803,10524592,10524593,10524710,10524711,10524712,10524720,10423816,10421099,10479135,10481229,10481230,10481231,10481232,10481451,10481452,10481453,10481634,10479672,10479673,10479674,10479675,10479676,10479677,10481727,10481728,10481729,10481730,10481731,10481732,10479832,10479833,10479834,10479835,10479836,10479837,10479885,10479944,10479945,10477966,10480016,10480017,10480018,10480019,10478052,10480097,10480098,10480219,10480220,10480221,10480222,10480223,10480224,10480225,10480226,10480227,10480285,10480286) 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'