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(10861357,10861362,8630720,10861369,10861370,10861371,10861372,10861373,8630812,8630854,8630855,8630856,8630902,8630903,8631146,8631147,8631627,8631628,8631629,8631630,8631631,8631632,8631633,8631634,10950688,8583879,8632514,8632520,8632521,8630286,8630287,10866223,10866224,10866225,10866226,10866227,10866228,10866229,10866230,10866231,10866232,10866233,10866234,10866235,10866236,10866237,10866238,10866239,10866240,10866241,10866242,10866243,10866244,10866245,10866246,10866247,10866248,10866249,10866250,10866251,10866252,7201211,10866253,10866254,10866255,10866256,10866257,10866258,10866259,10866260,10866261,10866262,10866263,10866264,10866265,10866266,10866267,10866268,10866269,10866270,10866271,10866272,10866273,10866274,10866275,10866276,10866277,7201299,8627707,8627708,8627709,8627710,8627711,8627712,8627713,7201320,10866368,10866369,10866370,7201335,7201337,7201338,10866395,8627793,8627822,7201605,7201606,7201629,7201698,8628183,8628187,7201840,7201861,7201862,7201866,8595296,8595297,7201913,7201914,7201915,7201916,7201917,7201918,7201919,7201920,7201921,7201922,7201923,7201924,7201925,7201926,7201927,7201928,7201929,7201930,7201931,7201932,7201933,7201934,7201935,7201936,7201937,7201938,7201939,7201940,7201941,7201942,7201943,7201944,7201945,7201946,7201947,7201948,7201949,7201950,7201951,7201952,7201953,7201954,10859289,10859290,8629208,8629209,8629210,8629211,8629212,8629213,8629214,8629215,8629216,8629217,8629218,8629219,8910080,8626812,8626813,8626814,8626815,7200454,7200455,7200456,7200457,7200458,7200459,7200460,7200581,8627062,8627063,8627064,8627065,8627066,8627067,8627068,8627069,8627070,8627071,8627072,8627073,8627074,8627075,8627076,8627077,8627078,8627079,8627080,8627081,8627082,8627083,8627084,8627085,8627086,8627087,8627088,8627089,8627090,8627091,8627092,8627093,8627094,8627095,8627096,8627097,8627098,8627099,8627100,8627101,8627102,8627103,8627104,8627105,8627106,8627107,8627108,8627109,8627110,8627111,8627112,8627113,7200714,8627114,8627115,8627116,8627117,8627118,8627119,8627120,8627121,8627122,4430165,10857886,10865998,10866113,10866114,10866115,10866116,10866117,10866118,10866119,10866120,10866121,10866122,10866123,10866124,10866125,10866126,10866127,10866128,10866129,10866130,10866131,10866132,10866133,10866134,10866135,10866136,10866137,10866138,10866139,10866140,10866141,10866142,10866143,10866144,10866145,10866146,10866147,10866148,10866149,10866150,10866151,10866152,10866153,10866154,10866155,10866156,10866157,10866158,10866159,10866160,10866161,10866162,10866163,10866164,10866165,10866166,10866167,10866168,10866169,10866170,10866171,10866172,10866173,10866174,10866175,10866176,10866177,10866178,10866179,10866180,10866181,10866182,10866183,10866184,10866185,10866186,10866187,10866188,10866189,10866190,10866191,10866192,10866193,10866194,10866195,10866196,10866197,10866198,10866199,10866200,10866201,10866202,10866203,10866204,10866205,10866206,10866207,10866208,10866209,10866210,10866211,10866212,10866213,10866214,10866215,10866216,10866217,10866218,10866219,10866220,10866221,10866222,8624589,10863480,10863481,10863482,10863483,10863484,10863485,10863486,10863487,8625142,8625144,8625145,10855895,8625573,8625574,8625578,8625580,8625581,7199399,7199403,8625916,8625917,8625918,8625919,8625920,8625921,8625966,8626084,8626085,8626086,8626098,8626100,8626101,8626105,8626107,8626108,8626527,3923669,8906849,8906850,7197842,8624256,8624379,8624400,8624401,8624402,8624408,8624411,8624412,8624413,8624414,8624415,8624428,8624440,8624441,8624443,8624444,8624449,8624472,8624565,8624566,8624567,8624568,8624569,8624570,8624578,10617015,10617016,10617017,8541532,8632590,8632591,8632592,8632593,8632595,8632596,8632597,8632598,8632599,8632600,8632601,8632614,8632618,8632620,8632621,8632622,8632623,8632624,8632625,8632626,8632628,8632629,8632630,8632631,8632671,8632672,8633159,8633402,8634011,8634015,8634019,8634023,8634027,8634031,8634050,8634051,8634056,8634057,8634062,8634063,8634071,8634072,8634076,8634077,8634081,8634082,8634161,8634238,8634271,8634359,8634360,8634361,8634362,8634424,8634434,8634440,10616899,10616900,10614493,9914816,9914817,8852736,8852737,8852738,9169881,9169882,6674303,6674304,10118602,10118628,10118629,10118630,9913310,9913311,9913312,9913313,9913314,10419252,10419253,10419254,10419255,10419256,10419257,10419258,10419259,10419260,10419261,10419262,10419263,10419264,10419265,10419266,10419267,10419268,10419269,10419270,10419271,10419272,10419273,10419274,10419275,10419276,10419277,10419278,10419279,10419280,10419281,10419282,10419283,10419284,10419285,10419286,10419287,10419288,10419289,10419290,10419291,10419292,10419293,10419294,10419295,10419296,10419297,10419298,10419299,10419300,10419301,10419302,10419303,10419304,10419305,10419306,10419307,10419308,10419309,10419310,10419311,10419312,10419313,10419314,10419315,10419316,10415317,10419317,10419318,10419319,10419320,10419321,10415322,10419322,10419323,10419324,10419325,10415326,10419326,10419327,10419328,10419329,10419330,10419331,10419332,10419333,10419334,10419335,10419336,10419337,10419338,10419339,10419340,10419341,10419342,10419343,10419344,10419345,10419346,10419347,10419348,10419349,10419350,10419351,10419352,10419353,10419354,10419355,10419356,10419357,10419358,10419359,10419360,10419361,10419362,10419363,10419164,9169269,6670727,976548,976580,10116029,10889766,10889767,10889911,10889912,10889913,10889914,10889915,10889916,10889917,10889918,10889919,10889920,10889921,10889922,10889923,10887457,10412472) 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'