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(10940462,10940463,10940464,10940465,10940466,10940467,10940468,10940469,10940470,10940471,10940472,10940473,10940474,10940475,10940476,10940477,10940478,10940479,10940480,10940481,10940482,10940483,10940484,10940485,10940486,10940487,10940488,10940489,10940490,10940491,10940492,10940493,10940494,10940495,10940496,10940497,10940498,10940499,10940500,10940501,10940502,10940503,10940504,10940505,10940506,10940507,10437403,8067952,8067953,8067954,8067955,8067956,8067957,8067958,8067959,8067960,8067961,8067962,8067963,8067964,8067965,8067966,8067967,8067968,8067969,8067970,8067971,8067972,8067973,8067974,8067975,8067976,8067977,8067978,8067979,8067980,8067981,8067982,8067983,8067984,8067985,8067986,8067987,8067988,8067989,8067990,8067991,8067992,8067993,8067994,8067995,8067996,8067997,8067998,8067999,8068000,8068001,8068002,8068003,8068004,8068005,8068006,8068007,8068008,8068009,8068010,8068011,8068012,8068013,8068014,8068015,8068016,8068017,8068018,8068019,8068020,8068021,8068022,8068023,8068024,8068025,8068026,8068027,8068028,8068029,8068030,8068031,8068032,8068033,8068034,8068035,8068036,8068037,8068038,8068039,8068040,8068041,8068042,8068043,8068044,8068045,8068046,8068047,8068048,8068049,8068050,8068051,8068052,8068053,8068054,8068055,8068056,8068057,8068058,8068059,8068060,8068061,8068062,8068063,8068064,8068065,8068066,8068067,8068068,8068069,8068070,8068071,8068072,8068073,8068074,8068075,8068076,8068077,8068078,8068079,8068080,8068081,8068082,8068083,8068084,8068085,8068086,8068087,8068088,8068089,8068090,8068091,8068092,8068093,8068094,8068095,8068096,8068097,8068098,8068099,8068100,8068101,8068102,8068103,8068104,8068105,8068106,8068107,8068108,8068109,8068110,8068111,8068112,8068113,8068114,8068115,8068116,8068117,8068118,8068119,8068120,8068121,8068122,8068123,8068124,8068125,8068126,8068127,8068128,8068129,8068130,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,8068139,8068140,8068141,8068142,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,8068173,8068174,8068175,8068176,8068177,8068178,8068179,8068180,8068181,8068182,8068183,8068184,8068185,8068186,8068187,8068188,8068189,8068190,8068191,8068192,8068193,8068194,8068195,8068196,8068197,8068198,8068199,8068200,8068201,8068202,8068203,8068204,8068205,8068206,8068207,8068208,8068209,8068210,8068211,8068212,8068213,8068214,8068215,8068216,8068217,8068218,8068219,8068220,8068221,8068222,8068223,8068224,8068225,8068226,8068227,8068228,8068229,8068230,8068231,8068232,8068233,8068234,8068235,8068236,8068237,8068238,8068239,8068240,8068241,8068242,8068243,8068244,8068245,8068246,8068247,8068248,8068249,8068250,8068251,8068252,8068253,8068254,8068255,8068256,8068257,8068258,8068259,8068260,8068261,8068262,8068263,8068264,8068265,8068266,8068267,8068268,8068269,8068270,8068271,8068272,8068273,8068274,8068275,8068276,8068277,8068278,8068279,8068280,8068281,8068282,8068283,8068284,8068285,8068286,8068287,8068288,8068289,8068290,8068291,8068292,8068293,8068294,8068295,8068296,8068297,8068298,8068299,8068300,8068301,8068302,8068303,8068304,8068305,8068306,8068307,8068308,8068309,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8065792,8065793,8066218,8066219,8066220,8066221,8066222,8066223,8066224,8066225,8066226,8066227,8066228,8066229,8066230,8066231,8066232,8066233,8066234,8066235,8066236,8066237,8066238,8066239,8066240,8066241,8066242,8066243,8066244,8066245,8066246,8066247,8066248,8066249,8066250,8066251,8066252,8066253,8066254,8066255,8066256,8066257,8066258,8066259,8066260,8066261,8066262,8066263,8066264,8066265,8066266,8066267,8066268,8066269,8066270,8066271,8066272,8066273,8066274,8066275,8066276,8066277,8066278,8066279,8066280,8066281,8066282,8066283,8066284,8066285,8066286,8066287,8066288,8066289,8066290,8066291,8066292,8066293,8066294,8066295,8066296,8066297,8066298,8066299,8066300,8066301,8066302,8066303,8066304,8066305,8066306,8066307,8066308,8066309,8066310,8066311,8066312,8066313,8066314,8066315,8066316,8066317,8066318,8066319,8066320,8066321,8066322,8066323,8066324,8066325,8066326,8066327,8066328,8066329,8066330,8066331,8066332,8066333,8066334,8066335,8066336,8066337,8066338,8066339,8066340,8066341,8066342,8066343,8066344,8066345,8066346,8066347,8066348,8066349,8066350,8066351,8066352,8066353,8066354,8066355,8066356,8066357,8066358,8066359,8066360,8066361,8066362,8066363,8066364,8066365,8066366,8066367,8066368,8066369,8066370,8066371,8066372,8066373,8066374,8066375,8066376,8066377,8066378,8066379,8066380,8066381,8066382,8066383,8066384,8066385,8066386,8066387,8066388,8066389,8066390,8066391,8066392,8066393,8066394,8066395,8066396,8066397,8066398,8066399,8066400,8066401,8066402,8066403,8066404,8066405,8066406,8066407,8066408,8066409,8066410,8066411,8066412,8066413,8066414,8066415,8066416,8066417,8066418,8066419,8066420,8066421,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066429,8066430,8066431,8066432,8066433,8066434,8066435,8066436,8066437,8066438,8066439,8066440,8066442,8066443,8066444,8066445,8066446,8066447,8066448,8066449,8066450,8066451,8066452,8066453,8066454,8066455,8066456,8066457,8066458,8066459,8066460,8066461,8066462,8066463,8066464,8066465,8066466,8066467,8066468,8066469,8066470,8066471,8066472,8066473,8066474,8066475,8066476,8066477,8066478,8066479,8066480,8066481,8066482,8066483,8066484,8066485,8066486,8066487,8066488,8066489,8066490,8066491,8066492,8066493,8066494,8066495,8066496,8066497,8066498,8066499,8066500,8066501,8066502,8066503,8066504,8066505,8066506,8066507,8066508,8066509,8066510,8066511,8066512,8066513,8066514,8066515,8066516,8066517,8066518,8066519,8066520,8066521,8066522,8066523,8066524,8066525,8066526,8066527,8066528,8066529,8066530,8066531,8066532,8066533,8066534,8066535,8066536,8066537,8066538,8066539,8066540,8066541,8066542,8066543,8066544,8066545,8066546,8066547,8066548,8066549,8066550,8066551,8066552,8066553,8066554,8066555,8066556,4968122,4968123,4968124,4968125,4968126,4968127,4968128,4968129,4968130,4968131,4968132,4968133,4968134,4968135,11049801,11049802,10623358,10623451,10919081,10919082,10919394,10919395,10920348,10622464,10622465,10620106,10620132,10916518,10916519,10916520,10916521,10916522,10916523,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621247,10621248,10621249,10621250,10621251,10621252,10621253,10621254,10621255,10621256,10621257,10621258,10621259,10621260,10621261,10621262,10621263,10621264,10621265,10621266,10621267,10621268,10621269,10621270,10621271,10621272,10621273,10621274,10621275,10621276,10621277,10621278,10621279,10621280,10621281,10621282,10621283,10621284,10621285,10621286,10621287,10621288,10621289,10621290,10621291,10621292,10621293,10621294,10621295,10621296,10621297,10621298,10621299,10621300,10621301,10621302,10621303,10621304,10621305,10621306,10621307,10621308,10621309,10621310,10621311,10621312,10621313,10621314,10621315,10621316,10621317,10621318,10621319,10621320,10621321,10621322,10621323,10621324,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621340,10621341,10621342,10621343,10621344,10621345,10621346,10621347,10621348,10621349,10621350,10621351,10621352,10621353,10621354,10621355,10621356,10621357,10621358,10621360,10621361,10621362,10621363,10621364,10621365,10621366,10621367,10621368,10621369,10621370,10621371,10621372,10621373,10621374,10621375,10621376,10621377,10621378,10621379,10621380,10621381,10621382,10621383,10621384,10621385,10621386,10621387,10621388,10621389,10621390,10621391,10621392,10621393,10621394,10621395,10621396,10621397,10621398,10621399,10621400,10621401,10621402,10621403,10621404,10621405,10621406,10621407,10621408,10621409,10621410,10621411,10621412,10621413,10621414,10621415,10621416,10621417,10621418,10621419,10621420,10565170,10565171,10565172,10565173,10565174,10565175,10565176,10565177,10565178,10565179,10565180,10565181,10565182,10565183,10565184,10611150,10563366,10563367,10563368,10563369,10610825,10610834,10469890,8563545) 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'