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(10939590,10939711,10939712,10939716,10939721,10939729,10939735,10939736,10939737,10939738,10939739,10939740,10939741,10939742,10939743,10939744,10939745,10939746,10939747,10939794,10939875,10939882,10939883,10939884,10939910,10940015,10940031,4970677,10940100,10940106,10940108,4970742,10940186,10940187,10940188,10940189,10940190,10940191,10940201,10940202,10940203,10940222,4970878,10940343,10940345,10940347,10940349,10940350,10940355,10940378,10940379,10940399,4970995,10940413,10940414,10940420,10940421,4971022,10940429,4971023,10940462,10940463,10940464,10940469,10940476,10940480,10940481,10940482,10940487,10940489,10940508,10940513,10940514,10940515,10940518,10940519,10940521,10940522,10940523,10940524,10940531,4971138,4971139,4971140,4971141,4971142,10940553,10940554,8066938,8066940,8066941,8066942,8066943,8066944,8066945,8066946,8066947,8066948,8066949,8066950,8066953,8066954,4968193,4968194,8066955,8066956,8066957,8066958,8066959,8066964,8066965,4968340,8067115,8067116,8067173,8067174,8067183,8067184,8067253,8067257,8067288,8067324,8067325,8067334,8067335,8067423,8067449,8067483,8067519,8067528,8067534,8067546,8067551,8067555,8067564,8067571,8067578,8067593,8067639,8067640,8067641,8067642,8067643,8067644,8067645,8067646,8067647,8067648,8067649,8067650,8067651,8067652,8067653,8067654,8067670,8067788,10938658,10938659,10938660,10938661,10938662,10938664,10938665,10938666,10938667,10938704,10938889,10939380,10939381,10939418,10939436,10939485,8064921,8064922,8064924,8065134,8065192,8065215,8065221,8065236,8065255,8065275,8065347,8065348,8065349,8065350,8065386,8075289,8075344,8075345,8075358,8075364,8075365,8065649,8065699,8075533,8065797,4967036,4967037,4967038,4967039,4967040,4967041,4967104,8065932,8065933,8065948,8065969,8065973,8065985,8065991,8065995,8066070,8066166,8066214,8066216,8066224,8066225,8066226,8066227,8066228,8066229,8066230,8066231,8066232,8066254,8066255,8066256,8066257,8066258,8066260,8066261,8066262,8066263,8066272,8066273,8066289,8066292,8066293,8066296,8066299,8066305,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,4967644,4967645,8066421,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066429,8066430,8066433,8066438,8066440,8066471,8066495,8066507,8066508,8066509,8066510,8066512,8066556,8066562,8066563,8066564,8066565,8066566,8066567,8066568,8066569,8066570,8066571,8066572,8066573,8066574,4967840,4967841,4967842,4967843,4967844,4967849,4967850,4967851,4967856,4967857,4967859,4967860,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,8066807,8066818,8066819,8066820,8066821,8066822,8066823,8066824,8066825,8066826,8066827,8066828,8066829,8066830,8066831,8066832,8066833,8066834,8066846,8066884,8066889,8066894,8066896,8066897,8066908,8066909,8066910,11049805,8063953,8063996,8064011,8064042,8064051,8064054,8064064,8064081,8064088,8064093,8064104,8064122,8064123,8064129,8064145,8064163,8064174,8064233,8064241,8064242,8064264,8064265,8064332,8064334,8064377,8064378,8064384,8064387,8064396,8064404,8064413,8064422,8064436,8064445,8064448,8064457,8064464,8064467,8064471,8064517,8064528,8064529,8064530,8064531,8064532,8064533,8064535,8064536,8064538,8064541,8064542,8064543,8064585,8064680,8064747,3655527,3655745,3655792,3655975,3656058,3656069,3656086,3656089,3656095,3656201,3656210,3656211,3656212,3656213,8072441,3656375,3656451,3656452,3656453,3656454,3656455,3656456,3656470,3656507,3656508,3656509,8072673,8072674,8072675,3656512,8072676,8072677,3656516,3656625,3656626,3656629,3656632,3656636,3656637,3656650,3656651,3656652,3656661,3656662,3656663,3656664,3656665,3656666,3656667,3656668,3656669,3656721,3656888,3656909,3656910,3656911,3656912,3656913,3656914,3656915,3656916,3656917,3656918,11049551,11049574,11049583,11049586,11049587,11049588,11049592,11049593,11049598,11049599,11049602,11049606,11049610,11049611,8073505,11049613,11049617,11049619,11049620,11049621,11049623,11049682,11049684,10918486,10918487,10623096,10623257,10623491,10623492,10623612,10623859,10623880,10623887,10623888,10623889,10623890,10623891,10623892,10623893,10623894,10623895,10623896,10623897,10623898,10623899,10623900,10623901,10623902,10623903,10623904,10623905,10623906,10623907,10621977,10621979,10621983,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10622000,10622001,10622002,10622003,10622010,10622011,10622014,10622060,10622071,10622100,10622106,10622107,10622108,10622109,10622110,10622125,10622131,10622133,10622134,10622148,10622149,10622196,10622280,10622324,10622360,10622363,10622367,10622525,10622526,10622571,10619965,10620072,10620145,10620146,10620147,10620314,10620315,10620316,10620355,10620356,10620359,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620385,10620391,10620395,10620396,10620404,10620407,10620411,10620412,10620413,10620468,10620469,10620470,10620471,10620472,10620473,10620474,10620475,10620476,10620477,10620478,10620479,10620504,10620528,10620550,10620565,10620596,10620597,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620721,10620722,10620723,10620724,10620725,10620726,10620727,10620728,10620729,10620730,10620731,10620732,10620733,10620734,10620735,10620736,10620737,10620738,10620739,10620740,10620741,10620769,10620770,10621120,10621124,10621128,10621136,10621144,10621147,10621148,10621152,10621161,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621258,10621260,10621264,10621267,10621268,10621278,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,10621390,10621396,10621427,10621428,10621429,10621436,10621438,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621493,10621494,10621495,10621496,10621499,10621500,10621501,10621507,10621508,10621509,10621519,10621520,10621521,10621522,10621523,10621529,10621530,10621531,10621532,10621533,10621543,10621544,10621545,10621552,10621571,10621573,10621581,10621582,10621589,10621594,10621620,10621634,10621635,10621636,10621646,10621657,10621658,10621659,10621661,10621662,10621663,10621664,10621665,10621666,10621689,10621692,10621693,10621694,10621701,10621704,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621735,10621745,10621841,10621842,10565316,10565317,10565321,10565331,10565332,10565333,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,10565875,10565876,10565931,10565932,10565954,10565955,10565956,10566014,10566045,10566047,10566048,10566049,10566050,10566059,10566066,10566067,10566068,10566069,10566070,10566094,10566110,10566111,10563517,10563827,10563828,10563829,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563973,10564173,10564182,10564882,10517143,10517144,10517149,10517150,10517153,10517155,10517162,10517188,10517189,10517190,10517191,10517196,10517197,10517199,10517200,10517311,10517312,10517592,10517680,10517681,10517683,10517684,10517731,10517735,10517739,10517743,10517787,10518075,10518862,10518863,10518864,10518865,10518866,10518867,10518992,10518993,10519088,10519089,10519095,10419304,10419305,10419355,10419539,10419540,10419556,10419557,10419562,10419563,10419577,10419669,10419670,10419688,10419711,10419738,10419909,10419917,10419919,10419924,10419927,10420110,10420157,10420158,10420175,10420204,10470981,10470990,10471412,10471413,10471824,10471852,10471871) 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'