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,10939736,10939737,10939738,10939739,10939740,10939741,10939742,10939743,10939744,10939745,10939746,10939874,10940015,10940106,10940107,4970729,4970741,4970742,10940186,10940190,10940191,10940343,10940345,10940347,10940348,10940349,10940350,10940351,10940356,10940357,10940399,10940410,10940413,10940414,10940415,4971023,10940464,10940470,10940471,4971096,10940508,10940522,10940523,10940524,10940531,4971139,4971140,4971141,10940549,4971142,10940553,10940554,10940556,10940557,8066940,4968179,8066941,8066943,8066946,8066947,8066952,8066953,4968193,8066954,4968194,8066959,8066960,8066961,4968218,4968250,4968251,4968252,4968253,4968340,8067173,8067174,8067200,8067284,8067288,8067289,8067290,8067291,8067304,8067324,8067325,8067449,4968701,4968702,8067463,4968703,4968704,4968705,4968706,4968707,4968708,4968709,4968710,4968711,4968712,4968713,4968714,4968715,8067483,8067528,4968785,8067551,4968812,4968813,8067580,4968844,8067639,8067640,8067641,8067642,8067643,8067644,8067645,8067649,8067651,8067652,8067653,8067654,8067670,4968925,10938658,10938660,10938667,4969285,4969286,4969287,4969288,10938888,10938889,10938900,10938901,10938902,10938912,10938923,10938924,10938965,10939037,10939190,10939367,10939380,10939381,10939418,8064919,8064920,8064921,8064922,8064923,8064924,8064925,8064926,8064963,8065074,8065215,8065221,8065282,8065291,8065363,8065376,8065393,8065525,8065575,8075346,8075347,8075348,8075349,8075350,8075351,8075352,8075353,8075354,8075355,8075356,8075359,8075360,8075361,8075362,8075363,8075366,8075367,8075368,8075369,8065667,8065704,8075491,8075492,8075493,8075538,4967033,8065797,4967041,8065853,8065917,8065948,8065991,8066166,8066167,8066214,8066215,8066216,8066226,8066227,8066229,8066231,8066232,8066255,8066257,8066258,8066259,8066262,8066263,8066273,8066299,8066305,8066308,8066330,8066331,8066332,8066333,8066334,8066335,8066336,8066338,8066354,8066355,8066356,8066357,8066358,8066371,8066374,8066375,8066376,8066378,8066379,8066394,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066429,8066430,8066438,8066440,8066471,8066495,8066508,8066512,8066562,8066563,8066564,8066566,8066567,8066568,8066569,8066570,8066571,4967842,4967843,4967845,4967846,4967847,4967848,4967849,4967852,4967858,4967861,8066628,8066632,8066636,8066637,8066638,8066640,8066641,8066642,8066643,8066644,8066649,8066654,8066655,8066756,8066757,8066758,8066759,8066761,8066762,8066763,8066764,8066765,8066766,8066768,8066818,8066819,8066822,8066823,8066824,8066825,8066826,8066827,8066828,8066829,8066831,8066833,8066834,8066846,8066881,8066884,8066890,8066895,8066897,11049798,8063953,8064011,8064054,8064242,8064396,8064464,8064528,8064530,8064534,8064535,8064539,8064540,8064543,8064677,8064680,8064718,8064747,8064790,8064843,8064856,8064864,8064877,8064878,8064879,8064904,3655660,3655804,3655806,3655919,3655920,3656058,3656059,3656069,3656072,3656086,3656089,3656095,3656189,3656214,3656215,3656216,8072467,8072468,3656375,3656385,3656451,3656452,3656453,3656454,3656455,3656456,3656470,8072675,3656516,3656625,3656626,3656632,3656637,3656651,3656652,3656661,3656662,3656663,3656667,3656668,3656669,3656676,3656888,3657004,3657008,3657009,3657010,3657011,3657012,3657013,3657014,3657015,3657016,3657017,3657018,3657019,3657020,3657021,3657022,3657023,3657024,3657025,3657026,3657027,3657028,3657160,3657161,3657162,3657163,3657164,3657165,3657166,3657167,3657168,3657169,3657170,3657171,3657178,3657179,3657180,3657181,3657182,3657183,3657184,3657185,3657186,3657187,3657188,3657189,3657190,3657191,3657192,3657193,3657194,11049588,11049602,11049611,8073506,8073511,11049622,11049634,11049682,11049683,11049684,11049707,11049739,10918486,10918487,10918569,10918570,10918571,10918572,10918573,10918574,10918575,10918576,10918653,10918657,10918658,10918682,10918700,10918713,10918717,10918726,10918730,10918732,10918735,10918742,10918767,10623257,10918768,10918769,10918770,10918771,10623318,10918839,10623492,10919207,10919208,10919209,10919210,10919211,10919212,10919244,10919245,10919246,10919247,10919248,10919250,10623887,10623888,10623889,10623890,10623891,10623892,10623893,10623894,10623895,10623896,10623897,10919506,10919507,10919508,10919509,10919510,10919564,10919565,10919566,10919567,10919568,10624173,10624174,10624175,10919751,10919833,10919887,10919888,10919889,10919890,10919891,10919892,10919893,10919894,10919895,10919897,10919913,10919988,10920084,10920085,10920086,10920226,10920227,10920228,10917474,10917475,10917476,10917477,10917478,10917479,10917480,10917481,10917482,10917483,10917484,10917485,10917486,10621977,10621979,10621983,10621992,10621994,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622009,10622014,10622100,10622125,10622131,10917704,10917705,10622196,10917706,10917707,10917708,10917709,10917733,10917852,10917853,10917854,10917855,10917857,10917858,10917859,10917860,10917861,10917865,10917866,10917870,10622361,10917871,10622362,10622364,10917875,10917964,10918021,10918022,10622534,10918119,10918120,10918121,10918122,10918123,10918124,10918154,10918285,10918335,10620072,10620073,10620080,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,10915664,10915666,10915667,10620261,10620356,10620359,10620372,10620375,10620378,10620385,10620404,10620469,10916015,10916016,10916017,10916018,10916019,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620721,10620723,10620729,10620731,10620732,10620734,10620735,10620736,10620737,10620738,10620739,10620740,10620741,10620924,10620950,10620992,10621008,10621088,10621109,10621120,10621121,10621124,10621127,10621128,10621129,10621136,10621144,10621147,10621148,10621149,10621151,10621152,10621161,10621165,10621230,10621234,10621236,10621237,10621238,10621241,10621242,10621243,10621244,10621245,10621246,10621259,10621261,10621264,10621268,10621278,10621281,10621286,10621307,10621308,10621309,10621325,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10916878,10916879,10621387,10621388,10621390,10621396,10621429,10621436,10621437,10621438,10621448,10621449,10621493,10621496,10621500,10621501,10621507,10621530,10621533,10621544,10621567,10621568,10621571,10621573,10621574,10621576,10621577,10621581,10621582,10621589,10621590,10621591,10621592,10621593,10621594,10621623,10621625,10621635,10621636,10621646,10621657,10621658,10621659,10621660,10621662,10621693,10621696,10621705,10621706,10621707,10621708,10621709,10621711,10621712,10621719,10621744,10565144,10565145,10565221,10565222,10565548,10565876,10565955,10566014,10566048,10566049,10563790,10563827,10563828,10563829,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563970,10563971,10563972,10563973,10563974,10564124,10564164,10564165,10564166,10564167,10564168,10564169,10564170,10564171,10564172,10564173,10564174,10564175,10564176,10564177,10564178,10564179,10564180,10564181,10564182,10564183,10564184,10564185,10564186,10564187,10564882,10517112,10517113,10517114,10517115,10517116,10517142,10517143,10517144,10517151,10517152,10517153,10517154,10517155,10517156,10517157,10517158,10517159,10517160,10517161,10517162,10517163,10517164,10517165,10517166,10517167,10517168,10517169,10517179,10517180,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,10517564,10517565,10517566,10517567,10517568,10517569,10517570,10517571,10517572,10517573,10517574,10517575,10517576,10517577,10517578,10517579,10517580,10517581,10517582,10517583,10517584,10517585,10517586,10517587,10517588,10517589,10517590,10517591,10517592,10517680,10517681,10517682,10517683,10517684,10517729,10517738,10517740,10517744,10517787,10518993,10419304,10419305,10419317,10419414,10419457,10419564,10419565,10419566,10419567,10419577,10419653,10419654,10419853,10419854,10419855,10419867,10419868,10419876,10419877,10419909,10419914,10419917,10419919,10419924,10419927,10419932,10420032,10420070,10420110,10420143,10420157,10420158,10420175,10420192,10420204,10471009,10471171,10471414,10471415,10471416,10471417,10471508,10471564,10471566,10471597,10471600,10471660,10471661,10471666,10471669,10471672,10471705,10471716,10471743,10471748,10471824,10471826,10471852,10471860,10471865,10471870,10471871,10470161,10470201) 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'