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(10939711,10939712,10939716,10939721,10939729,10939740,10939744,10939874,10939875,10939881,10943762,10940106,10940108,4970742,10940186,10940187,10940188,10940189,10940190,10940191,10940343,10940399,10940410,10940420,10940421,10940422,10940429,10940437,10940438,4971073,4971075,4971076,10940462,10940463,10940464,10940469,10940470,10940471,10940480,10944282,10940489,10940508,10940513,10940514,10940515,4971138,4971139,10940518,10940519,4971140,4971141,4971142,10940521,10940522,10940523,10940524,8066889,8066894,8066895,8066896,8066897,8066908,8066909,8066910,8066940,8066941,8066942,8066943,8066944,8066945,8066946,8066947,8066948,8066949,8066950,8066951,8066952,8066953,8066954,8066955,8066956,8066957,8066958,8066959,8066960,8066961,8066962,8066963,8066964,8066965,8067200,8067370,8067519,8067528,10437426,10437427,10437428,8067639,8067640,8067641,8067642,8067643,8067644,8067645,8067646,8067647,8067648,8067649,8067650,8067651,8067652,8067653,8067654,10437540,10437557,10437568,10437600,8067961,8067962,8067963,8067964,8067965,8067966,8067967,8067999,8068000,8068001,8068002,8068003,8068004,8068005,8068006,8068007,8068008,8068009,8068010,8068011,8068012,8068026,8068027,8068028,8068029,8068030,8068031,8068075,8068076,8068077,8068078,8068079,8068080,8068081,8068082,8068083,8068084,8068085,8068143,8068144,8068145,8068146,8068147,8068148,8068149,8068150,8068151,8068152,8068153,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068161,8068162,8068163,8068164,8068165,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068256,8068257,8068258,8068259,8068260,8068261,8068262,8068263,8068264,8068265,8068301,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8068318,8068319,8068320,8068321,8068322,8068323,8068324,8068325,8068326,8068327,8068328,8068329,8068330,8068331,8068332,8068333,8068334,10939103,8068399,8068400,8068401,8068402,8068403,8068404,8068405,8068406,8068524,8068525,8068526,8068527,8068528,8068529,8068602,8068603,8068604,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,10939367,10939380,10939381,8068680,8068681,8068682,8068683,8068684,8068685,10939418,8068686,8068697,8068698,8068699,8068700,8068701,10939436,8075337,8075338,4967033,8065797,8065821,8065969,8065985,8066079,8066081,8066166,8066214,8066216,8066224,8066225,8066226,8066227,8066228,8066229,8066230,8066231,8066232,8066254,8066255,8066256,8066257,8066258,8066259,8066260,8066261,8066262,8066263,8066272,8066273,8066292,8066293,8066308,8066328,8066329,8066330,8066331,8066332,8066333,8066334,8066335,8066336,8066337,8066338,8066354,8066355,8066356,8066357,8066358,8066369,8066370,8066371,8066372,8066373,8066374,8066375,8066376,8066377,8066378,8066379,8066394,8066421,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066508,8066509,8066510,8066562,8066563,8066564,8066565,8066566,8066567,8066568,8066569,8066570,8066571,8066572,8066573,8066574,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066636,8066637,8066638,8066639,8066640,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066649,8066650,8066651,8066652,8066653,8066654,8066655,8066656,8066657,8066658,8066756,8066757,8066758,8066759,8066760,8066761,8066762,8066763,8066764,8066765,8066766,8066767,8066768,8066818,8066819,8066820,8066821,8066822,8066823,8066824,8066825,8066826,8066827,8066828,8066829,8066830,8066831,8066832,8066833,8066834,8066881,8066884,3655745,3655746,3655840,3655919,3655920,3656059,8072441,8072467,8072468,3656385,3656451,3656452,3656453,3656454,3656455,3656456,3656470,8072673,8072674,8072675,8072676,8072677,3656625,3656626,3656632,3656636,3656637,3656650,3656651,3656652,3656663,3656664,3656665,3656668,3656669,3656687,8073039,8073040,8073041,8073042,8073043,3656998,3656999,3657000,10918486,10918487,10918569,10918570,10918653,10918657,10918658,10918767,10918768,10623318,10918839,10623412,10919207,10919208,10919209,10919210,10919211,10919212,10919244,10919245,10919246,10919247,10919506,10919507,10919508,10919509,10919510,10919564,10919565,10919566,10919567,10919568,10919887,10919888,10919889,10919890,10919988,10920084,10920085,10920086,10917474,10917475,10917476,10917477,10917478,10917479,10917480,10917481,10917482,10621977,10621983,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10917704,10917705,10622196,10917706,10917707,10917708,10917709,10917852,10917853,10917854,10917855,10622360,10622361,10622362,10622363,10622364,10622365,10622366,10622367,10622368,10918021,10918022,10622525,10622526,10918119,10918120,10918121,10918122,10918123,10918124,10918285,10918335,10619965,10620030,10620031,10620032,10915629,10915630,10915631,10915632,10915633,10915634,10915635,10915636,10915637,10915638,10915639,10915640,10915641,10915642,10915643,10915644,10915645,10915646,10915647,10915648,10915649,10915650,10915651,10915652,10915653,10915654,10915655,10915656,10915657,10915658,10915659,10915660,10915661,10915662,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620411,10620412,10620413,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10621120,10621147,10621148,10621149,10621151,10621152,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621258,10621259,10621260,10621261,10621264,10621267,10621268,10621281,10621286,10621292,10621293,10621305,10621306,10621307,10621308,10621309,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621386,10621387,10621388,10621427,10621428,10621429,10621436,10621437,10621438,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621493,10621494,10621495,10621496,10621500,10621501,10621529,10621530,10621531,10621532,10621533,10917057,10917058,10917059,10917060,10917061,10917062,10917063,10917064,10917065,10621567,10621568,10621571,10621573,10621574,10621576,10621577,10621581,10621582,10621621,10621622,10621623,10621624,10621625,10621634,10621635,10621636,10621646,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621692,10621693,10621694,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621745,10917420,10917421,10917422,10565145,10565316,10565317,10565320,10565321,10611324,10611568,10611696,10565875,10611725,10565876,10565931,10565932,10565954,10565955,10565956,10566014,10566059,10566066,10566067,10566068,10566069,10566070,10563517,10609387,10609400,10609401,10609526,10609715,10609716,10609841,10609954,10609984,10610108,10610171,10610195,10610229,10610241,10610242,10610243,10610244,10610245,10610252,10610271,10564770,10564771,10564772,10564773,10610633,10610791,10610850,10610878,10517311,10517312,10555350,10555351,10555352,10555353,10517680,10517681,10517682,10517683,10517684,10517725,10517726,10517727,10517728,10517729,10517730,10517731,10517732,10517733,10517734,10517735,10517736,10517737,10517738,10517739,10517740,10517741,10517742,10517743,10517744,10517745,10517746,10517747,10517748,10555829,10555830,10555948,10555949,10555950,10555951,10555952,10555953,10518075,10518992,10518993,10519082,10519083,10519084,10519085,10519086,10519087,10519088,10419304,10419305,10415411,10415415,10415420,10415470,10415652,10415653,10415656,10415683,10415684,10415686,10415687,10415688,10415689,10415690,10415691,10415692,10415805,10415813,10415866,10415867,10415868,10415882,10415911,10415914,10416133,10416134,10416137,10420143,10420147,10420157,10420158,10420175,10420192,10420204,10463002,10463003,10463006,10463027,10463031,10463034,10463044,10463315,10463316,10463360,10463361,10463362,10463396,10463398,10463429,10463430,10463432,10471566,10463654,10463728,10463731,10463732,10463748,10463749,10463750,10463751,10463752,10463753,10463757,10463758,10463759,10463763,10463780,10463782,10463783,10463784,10463785,10463786,10463787,10463788,10463789,8563375,8563376,8563377,8563383,10470078,8563431,8563546,10462399,10462401,10462409,10462410,10462411,10462412,10462413,10462427,10462436,10462437,10462438,10462439,10462458,10462462,10462463,10462485,10462486,10462487,10462488,10462489,10462490,10462491,10462492,10462493,10462494,10462495,10462496,10462497,10462498,10462499,10462500,10462501,10462502,10462503,10462504,10462505,10462518,10462587,10462588,10462589,10462590,10462591,10462592,10462593,10462594,10462595,10462596,10462597,10462724,10462725,10462756) 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'