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(10962596,8630758,8630759,8630760,8630761,8630762,8630763,8630764,8630765,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630784,7068610,8569642,8569643,10459532,10459533,10459534,10459535,7066260,7066268,7066269,10951056,9216108,9216109,9216110,9216111,9216112,9216113,9216114,9216115,9216116,9216117,9216118,9216119,9216120,9216121,9216122,9216123,9216124,9216125,9216126,9216127,9216128,9216129,9216130,9216131,9216132,9216133,9216134,9216135,9216136,9216137,9216138,9216139,9216140,9216141,9216142,9216143,9216144,9216145,9216146,9216147,9216148,9216149,9216150,9216151,9216152,9216153,9216154,9216155,9216156,9216157,9216158,9216159,9216160,9216161,9216162,9216163,9216164,9216165,9216166,9216167,9216168,9216169,9216170,9216171,9216172,9216173,9216174,9216175,9216176,9216177,9216178,9216179,9216180,9216181,9216182,9216183,9216184,9216185,9216186,9216187,9216188,9216189,9216190,9216191,9216192,9216193,9216194,9216195,9216196,9216197,9216198,9216199,9216200,9216201,9216202,9216203,9216204,9216205,9216206,9216207,9216208,9216209,9216210,9216211,9216212,9216213,9216214,9216215,9216216,9216217,9216218,9216219,9216220,9216221,9216222,9216223,9216224,9216225,9216226,9216227,9216228,9216229,9216230,9216231,9216232,9216233,9216234,9216235,9216236,9216237,9216238,9216239,9216240,9216241,9216242,9216243,9216244,9216245,9216246,9216247,9216248,9216249,9216250,9216251,9216252,9216253,9216254,9216255,9216256,9216257,9216258,9216259,9216260,9216261,9216262,9216263,9216264,9216265,9216266,9216267,9216268,9216269,9216270,9216271,9216272,9216273,9216274,9216275,9216276,9216277,8575938,7075293,11001078,7067757,10103143,10103205,10103267,10842898,7072148,7072149,7072150,7072151,7072152,7072153,10960031,10960032,10960033,10999085,7201736,7201737,3899005,3899006,8836530,8836534,8836636,8836637,8836638,8836639,10843961,7065354,7065355,7073432,7073433,7073434,10844202,10104598,9794571,9794572,10104644,9794593,10102019,10102021,8910230,8910231,8910232,8910233,8910234,8910235,8910236,8910237,8910238,8910239,8910240,8910241,8910242,8910243,8910244,8910245,8910246,8910247,8910248,8910249,8910250,8910251,8910252,8910253,8910254,8910255,8910256,8910257,8910258,8910259,8910260,8910261,8910262,8910263,8910264,8910265,8910266,8910267,8910268,8910269,8910270,8910271,8910272,8910273,8910274,8910275,8910276,8910277,8910278,8910279,8910280,8910281,8910282,8910283,8910284,8910285,8910286,8910287,8910288,8910289,8910290,8910291,8910292,8910293,8910294,8910295,8910296,8910297,8910298,8910299,8910300,8910301,8910302,8910303,8910304,8910305,8910306,8910307,8910308,8910309,8910310,8910311,8910312,8910313,8910314,8910315,8910316,8910317,8910318,8910319,8910320,8910321,8910322,8910323,8910324,8910325,8910326,8910327,8910328,8910329,8910330,8910331,8910332,8910333,8910334,8910335,8910336,8910337,8910338,8910339,8910340,8910341,8910342,8910343,8910344,8910345,8910346,8910347,8910348,8910349,8910350,8910351,8910352,8910353,8910354,8910355,8910356,8910357,8910358,8910359,8910360,8910361,8910362,8910363,8910364,8910365,8910366,8910367,8910368,8910369,8910370,8910371,8910372,8910373,8910374,8910375,8910376,8910377,8910378,8910379,8910380,7071391,7071472,7071473,7071545,7071547,10102868,10102901,10839764,7069604,3926354,8564681,8564682,8564683,10101282,10101335,8616080,8616092,8616093,8616094,8616095,8616096,8616097,8616098,8557275,10942240,10942241,10942243,10942246,3923481,3923524,10618352,10838026,10838027,10838028,10838884,10966702,10966736,10617329,10615046,8570056,8570057,8570068,10615292,8570127,10615545,8611388,10616859,10616860,10614265,10614266,10614556,10614557,10614558,6665957,6665958,10609383,10609384,7057953,7057956,7057958,7058012,7058019,8851801,9172330,10613017,10613032,10613033,10121053,9915293,9915294,9915295,9915296,9915297,9915298,9915299,9915300,9915301,9915302,9915303,9915304,9169444,9169692,9210115,8850071,8850093,10118500,9911406,6666536,9190940,9191011,9191012,9191013,8916793,6667276,6667283,6667284,6667285,6667286,6667315,9191520,9191523,9207965,9207966,9168197,9168210,9168211,10173607,10173608,10173609,10627192,10627193,10627194,10627195,10627196,10627198,10627199,10627383,10627384,10627405,10627406,10173951,10154002,10164047,10164048,10174088,10174089,10174090,10163084,10163085,10163088,10173259,10604984,10604985,10604986,10604987,10604988,10604989,10607005,10541694,10541695,10544335,10544336,10544337,10544338,10544339,10508526,8562790,8562791,8562792) 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'