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(10939603,10939607,10939643,10939708,10939709,10939713,10939714,10939715,10939716,10939718,10939719,10939720,10939721,10939725,10939726,10939727,10939728,10939729,10939732,10939737,10939738,10939739,10939740,10939743,10939744,10939747,10939751,10939752,10939753,10939755,4970383,10939794,10939895,10939924,10939946,10939947,10939948,10939949,10939950,10939951,10939952,10939953,10939954,10939955,10939956,10939957,10939958,10939959,10939960,10939961,10939962,10939963,10939964,10939965,10939966,10939967,10939968,10939969,10939970,10939971,10939972,10939973,10939974,10939975,10939976,10939977,10939978,10939979,10939980,10939981,10939982,10939983,10939984,10939985,10939986,10939987,10939988,10939989,10939990,10939991,10939992,10939993,10939994,10939995,10939996,10939997,10939998,10939999,10940000,10940001,10940002,10940058,10940059,10940060,10940061,10940066,10940075,10940082,4970677,4970684,10940092,4970689,10940100,4970738,4970750,4970826,10940246,10940264,10940342,10940374,10940402,4971029,10940497,10940502,4971137,4971138,8066941,8066948,4968188,8066949,8066954,8066965,8066977,8067027,4968315,8067077,8067160,8067161,8067185,8067252,8067377,8067414,8067415,8067423,8067428,8067429,8067436,8067437,8067449,8067451,8067452,8067453,8067477,8067518,4968846,8067652,8067653,8067679,8067689,8067692,8067702,8067716,8067749,8067753,10938479,10938596,4969193,4969194,4969195,4969196,4969197,10938605,4969198,4969199,10938619,4969252,4969253,4969254,4969255,4969256,10938714,10938715,10938895,4969493,10938930,10938951,10939028,10939079,10939080,10939081,10939082,10939083,10939093,10939098,10939116,10939117,10939118,10939119,10939120,10939121,10939146,10939147,10939148,10939149,10939150,10939153,10939168,10939253,10939374,10939380,10939381,10939382,10939409,10939424,10939468,10939469,10939495,10939524,10939531,10939532,10939533,10939534,10939552,8065081,8065087,8065088,8065089,8065091,8065094,8065123,8065151,8065184,8065208,8065209,8065210,8065214,8065215,8065216,8065217,8065219,8065220,8065221,8065653,4967032,4967055,8065902,8065932,8065933,8065945,8065959,8065960,8065961,8065962,8065963,8065964,8065965,8065966,8065967,8065968,8065969,8065970,8065971,8065972,8065973,8065974,8065975,8065991,8066069,4967371,8066138,8066139,4967406,4967448,4967449,4967455,4967456,4967553,4967560,4967577,8066347,8066432,4967703,8066474,4967743,4967744,4967745,4967746,4967747,4967752,4967753,4967767,4967768,4967769,4967819,4967820,4967821,4967822,4967823,4967824,4967825,4967826,8066589,8066590,4967840,8066626,8066672,8066678,4967941,8066740,4967982,4967983,4967984,4967993,4967994,4967995,4968002,4968030,4968031,8066820,8066838,8066850,8066861,11049795,11049796,11049807,8064015,8064244,8064252,8064253,8064254,8064255,8064256,8064257,8064258,8064265,8064266,8064267,8064268,8064280,8064281,8064282,8064283,8064284,8064285,8064289,8064290,8064324,8064364,8064374,8064394,8064478,8064479,8064480,8064481,8064482,8064520,8064521,8064522,8064525,8064857,3655790,3655791,3655792,3655974,3655975,3655994,3656011,3656033,3656055,3656058,3656059,3656076,3656081,3656083,3656084,3656085,3656086,3656087,3656088,3656089,3656122,3656137,3656138,3656156,3656158,3656187,3656201,3656376,3656380,3656451,3656452,3656453,3656454,3656455,3656456,3656470,8072644,8072649,8072654,8072659,8072664,8072669,8072674,8072679,8072684,8072689,8072694,8072704,8072709,8072724,8072729,8072749,8072769,8072774,8072793,3656630,8072794,8072795,8072796,8072797,3656633,8072798,3656634,8072799,3656635,8072800,3656636,3656637,3656640,3656641,8072805,3656642,3656644,3656645,3656646,3656647,3656648,3656649,8072813,3656650,3656651,3656652,8072821,3656657,3656662,3656663,3656664,8072829,3656665,3656667,3656668,3656669,3656670,8072837,3656673,3656674,8072849,8072869,3656705,3656716,8072887,3656740,8072905,3656744,8072921,8072939,8072954,3656792,3656793,3656794,8072970,3656815,3656834,3656888,8073096,8073097,3656942,3656996,11049549,11049567,11049568,11049571,8073473,8073484,8073485,8073486,10623004,10623005,10623006,10623007,10623008,10623009,10623010,10623011,10623014,10623024,10623041,10623090,10623091,10623256,10623257,10623258,10623259,10623260,10623492,10623493,10623603,10623669,10623693,10623694,10623695,10623696,10623697,10623698,10623699,10623700,10623701,10623702,10623703,10623704,10623756,10623767,10623768,10623769,10623770,10623834,10623837,10623859,10623860,10623864,10623872,10623873,10623878,10623879,10623880,10624096,10624158,10624169,10624170,10624171,10624172,10624218,10624545,10624546,10624659,10624660,10624661,10624662,10624663,10624664,10624665,10624666,10624692,10624833,10624841,10621975,10621982,10621984,10621989,10621990,10621991,10622000,10622001,10622002,10622003,10622011,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622027,10622029,10622037,10622038,10622039,10622048,10622049,10622050,10622051,10622052,10622053,10622058,10622064,10622065,10622066,10622068,10622070,10622074,10622075,10622076,10622078,10622079,10622080,10622089,10622107,10622108,10622109,10622110,10622113,10622114,10622141,10622142,10622143,10622144,10622145,10622198,10622269,10622348,10622349,10622350,10622363,10622409,10622543,10622602,10622860,10622861,10622872,10622874,10622875,10622902,10622924,10619963,10619999,10620000,10620014,10620020,10620033,10620050,10620051,10620072,10620076,10620165,10620238,10620297,10620298,10620299,10620300,10620301,10620302,10620303,10620304,10620305,10620306,10620307,10620308,10620324,10620329,10620346,10620348,10620350,10620351,10620352,10620372,10620390,10620391,10620392,10620395,10620396,10620397,10620409,10620411,10620415,10620417,10620418,10620419,10620424,10620457,10620482,10620512,10620564,10620565,10620566,10620567,10620568,10620569,10620570,10620571,10620572,10620573,10620574,10620575,10620576,10620577,10620578,10620579,10620580,10620581,10620584,10620585,10620586,10620587,10620588,10620589,10620631,10620636,10620701,10620739,10620760,10621059,10621060,10621061,10621062,10621084,10621144,10621264,10621421,10621428,10621429,10621510,10621516,10621517,10621535,10621536,10621541,10621543,10621749,10621817,10621875,10565221,10565222,10565249,10565316,10565317,10565320,10565321,10565322,10565323,10565328,10565331,10565332,10565333,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10565370,10565371,10565460,10565461,10565462,10565463,10565464,10565465,10565466,10565467,10565468,10565469,10565470,10565471,10565472,10565473,10565474,10565475,10565476,10565477,10565478,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565544,10565545,10565546,10565547,10565548,10565560,10565619,10565620,10565621,10565653,10565883,10565887,10565929,10565970,10566059,10566061,10566062,10566063,10566064,10566065,10566066,10566094,10566098,10566099,10566100,10566101,10566110,10566111,10563510,10563542,10563583,10563584,10563585,10563700,10563720,10563721,10563722,10563723,10563724,10563725,10563726,10563727,10563795,10563796,10563813,10563827,10563828,10563829,10563924,10563925,10563936,10563937,10563945,10563946,10563955,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563975,10563976,10564141,10564142,10564151,10564200,10564460,10564611,10564680,10564681,10564682,10517287,10517288,10517306,10517307,10517308,10517309,10517310,10517311,10517312,10517313,10517314,10517329,10517330,10517331,10517592,10517650,10517651,10517652,10517653,10517656,10517658,10517660,10517661,10517662,10517663,10517664,10517665,10517666,10517667,10517668,10517670,10518771,10518772,10518773,10518774,10518775,10518776,10518777,10518778,10518779,10518780,10518781,10518782,10518783,10518784,10419232,10419237,10419315,10419622,10419623,10419624,10419625,10419626,10419668,10419669,10419670,10419671,10419672,10419757,10419882,10420023,10420024,10420149,10420150,10420151,10420152,10470903,10471010,10471011,10471079,10471136,10471357,10471358,10471359,10471366,10471367,10471368,10471369,10471370,10471371,10471372,10471373,10471384,10471386,10471387,10471412,10471457,10471460,10469894,10469896,10469911,10469920,10469936,10469937,10469942,10469967,10469968,10469969,10469992,10469993,10470008,10470217,10470271,10470808,10470809) 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'