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(8068869,8068870,8068871,8068872,8068890,7068343,7068344,7068345,7068346,7068347,7076359,10976284,8569823,8569824,8569825,8569826,8569827,8569828,8569829,7073972,7073973,7073974,7073975,7073976,7073977,7073978,7073979,7074001,7074197,8067201,7066277,7066278,7074682,7066768,7066864,7074981,7074982,7075102,7075294,7075295,7075296,7067296,7075297,7075298,7075780,10962567,7072192,7064470,7073176,7073627,10961372,10961385,10961386,10961387,10961388,10961389,10961390,10961596,10961597,11049053,7071196,7071197,10942965,11049398,10943153,10943154,10959256,7071828,7071829,7071830,7071831,7071898,7071899,7071900,7071901,7071902,7071903,7068979,7068980,10942204,10942205,7070915,7070916,7070917,7070918,7070919,10618020,10618021,10924282,8070859,10619177,10619372,10920152,10920153,10920154,10920155,10920156,10917501,10954011,8570044,10925759,10925760,10926233,10926234,10952919,10952920,10921893,10917135,10917136,10917137,10917138,10917139,10917140,10917141,10917142,10966593,10966594,10966595,10966596,10966597,10966598,10966599,10966600,10966601,10966602,10966603,10966604,10966605,10966606,10966607,10966608,10966609,10966610,10562134,10562135,10562136,10562137,10562138,10562139,10562140,10562141,10562142,10562143,10562144,10562145,10562146,10562147,10562148,8864363,10559757,8864727,10612270,7057871,7057872,10557718,10612644,10612939,10613126,7058666,7058667,7058668,7058669,7058670,7058671,7058672,7058673,7058674,7058675,7058808,4974474,10517686,10517687,10517688,10517689,10517690,10517691,10513949,10513950,10516704,10516705,10516706,4973455,4973456,4973457,4973458,4973459,4973460,4973604,4973672,10418903,10418904,10419008,10419009,10419010,10419011,10419012,10419013,10417189,4974125,10463693,8917084,8917085,10155919,10629505,10627161,10632306,10627776,10630310,10630311,10631729,10631730,10571304,10571305,10571457,10571458,10568943,10568944,10568945,10568946,10568947,10568948,10568949,10568950,10568951,10568952,10568953,10568954,10568955,10568956,10568957,10568958,10568959,10568960,10568961,10568962,10568963,10568964,10568965,10568966,10568967,10568968,10568969,10568970,10568971,10568972,10568973,10568974,10568975,10568976,10568977,10568978,10568979,10568980,10568981,10568982,10568983,10568984,10568985,10568986,10568992,10568993,10568994,10568995,10568996,10568997,10568998,10568999,10569000,10569001,10569002,10569003,10569004,10569005,10569006,10569007,10569008,10569009,10569010,10569011,10569012,10569013,10569014,10569015,10569016,10569017,10569018,10569019,10569020,10569021,10569022,10569023,10569024,10569025,10569026,10569027,10569028,10569029,10569030,10569031,10569032,10569033,10569034,10569035,10569036,10569037,10569038,10569039,10569040,10569041,10569042,10569043,10569044,10569045,10569046,10569047,10569048,10569049,10569050,10569051,10569052,10569053,10569054,10569055,10569056,10569057,10569058,10569059,10569060,10569061,10569062,10569063,10569064,10569065,10569066,10569067,10569068,10569069,10569070,10569071,10569072,10569073,10569074,10569075,10569076,10569077,10569078,10569079,10569080,10569081,10569082,10569083,10569084,10569085,10569086,10569087,10569088,10569089,10569090,10569091,10569092,10569093,10569094,10569095,10569096,10569097,10569098,10569099,10569100,10569101,10569102,10569103,10569104,10569105,10569106,10569107,10569108,10569109,10569110,10569111,10569112,10569113,10569114,10569115,10569116,10569117,10569118,10569119,10569120,10569121,10569122,10569123,10566123,10569124,10569125,10569126,10569127,10569128,10569129,10569130,10569131,10569132,10569133,10569134,10569135,10569136,10569137,10569138,10569139,10569140,10569141,10569142,10569143,10569144,10569145,10569146,10569147,10569148,10569149,10569150,10569151,10569152,10569153,10569154,10569155,10569156,10569157,10569158,10569159,10569160,10569161,10569162,10569163,10569164,10569165,10569166,10569167,10569168,10569169,10569170,10569171,10569172,10569173,10569174,10569175,10569176,10569177,10569178,10569179,10569180,10569181,10569182,10569183,10569184,10569185,10569186,10569187,10569188,10569189,10569190,10569191,10569192,10569193,10569194,10569195,10569196,10569197,10569198,10569199,10569200,10569201,10569202,10569203,10569204,10569205,10569206,10569207,10569208,10569209,10569210,10569211,10569212,10569213,10569214,10569215,10569216,10569217,10569218,10569219,10569220,10569221,10569222,10569223,10569224,10569225,10569226,10569227,10569228,10569229,10569230,10569231,10569232,10569233,10569234,10569235,10569236,10569237,10569238,10569239,10569240,10569241,10569242,10569243,10569244,10569245,10569246,10569247,10569248,10569249,10569250,10569251,10569252,10569253,10569254,10569255,10569256,10569257,10569258,10569259,10569260,10569261,10569262,10569263,10569264,10569265,10569266,10569267,10569268,10569269,10569270,10569271,10569272,10569273,10569274,10569275,10569276,10569277,10569278,10569279,10569280,10569281,10569282,10569283,10569284,10569285,10569286,10569287,10569288,10569289,10569290,10569291,10569292,10569293,10569294,10569295,10569296,10569297,10569298,10569299,10569300,10569301,10569302,10569303,10569304,10569305,10569306,10569307,10569308,10569309,10569310,10569311,10569312,10569313,10569314,10569315,10569316,10569317,10569318,10569319,10569320,10569321,10569322,10569323,10569324,10569325,10569326,10569327,10569328,10569329,10569330,10569331,10569332,10569333,10569334,10569335,10569336,10569337,10569338,10569339,10569340,10569341,10569342,10569343,10569344,10569345,10569346,10569347,10569348,10569349,10569350,10569351,10569352,10569353,10569354,10569355,10569356,10569357,10569358,10569359,10569360,10569361,10569362,10569363,10569364,10569365,10569366,10569367,10569368,10569369,10569370,10569371,10569372,10569373,10569374,10569375,10569376,10569377,10569378,10569379,10569380,10569381,10569382,10569383,10569384,10569385,10569386,10569387,10569388,10569389,10569390,10569391,10569392,10569393,10569394,10569395,10569396,10569397,10569398,10569399,10569400,10569401,10569402,10569403,10569404,10569405,10569406,10569407,10569408,10569409,10569410,10569411,10569412,10569413,10569414,10569415,10569416,10569417,10569418,10569419,10569420,10569421,10569422,10569423,10569424,10569425,10569426,10569427,10569428,10569429,10569430,10569431,10569432,10569433,10569434,10569435,10569436,10569437,10569438,10569439,10569440,10569441,10569442,10569443,10569444,10569445,10569446,10569447,10569448,10569449,10569450,10569451,10569452,10569453,10569454,10569455,10569456,10569457,10569458,10569459,10569460,10569461,10569462,10569463,10569464,10569465,10569466,10569467,10569468,10569469,10569470,10569471,10569472,10569473,10569474,10569475,10569476,10569477,10569478,10569479,10569480,10569481,10569482,10569483,10569484,10569485,10569486,10569487,10569488,10569489,10569490,10569491,10569492,10569493,10569494,10569495,10569496,10569497,10569498,10569499,10569500,10569501,10569502,10569503,10569504,10569505,10569506,10569507,10569508,10569509,10569510,10569511,10569512,10569513,10569514,10569515,10569516,10569517,10569518,10569519,10569520,10569521,10569522,10569523,10569524,10569525,10569526,10569527,10569528,10569529,10569530,10569531,10569532,10569533,10569534,10569535,10569536,10569537,10569538,10569539,10569540,10569541,10569542,10569543,10569544,10569545,10569546,10569547,10569548,10569549,10569550,10569551,10569552,10569553,10569554,10569555,10569556,10569557,10569558,10569559,10569560,10569561,10569562,10569563,10569564,10569565,10569566,10569567,10569568,10569569,10569570,10569571,10569572,10569573,10569574,10569575,10569576,10569577,10569578,10569579,10569580,10569581,10569582,10569583,10569584,10569585,10569586,10569587,10569588,10569589,10569590,10569591,10569592,10569593,10569594,10569595,10569596,10569597,10569598,10569599,10569600,10569601,10569602,10569603,10569604,10569605,10569606,10569607,10569608,10569609,10569610,10569611,10569612,10569613,10569614,10569615,10569616,10569617,10569618,10569619,10569620,10569621,10569622,10569623,10569624,10569625,10569626,10569627,10569628,10569629,10569630,10569631,10569632,10569633,10569634,10569635,10569636,10569637,10569638,10569639,10569640,10569641,10569642,10569643,10569644,10569645,10569646,10569647,10569648,10569649,10569650,10569651,10569652,10569653,10569654,10569655,10569656,10569657,10569658,10569659,10569660,10569661,10569662,10569663,10569664,10569665,10569666,10569667,10569668,10569669,10569670,10569671,10569672,10569673,10569674,10569675,10569676,10569677,10569678,10569679,10569680,10569681,10569682,10569683,10569684,10569685,10569686,10569687,10569688,10569689,10569690,10569691,10569692,10569693,10569694,10569695,10569696,10569697,10569698,10569699,10569700,10569701,10569702,10569703,10569704,10569705,10569706,10569707,10569708,10569709,10569710,10519323,10519324,10519325,10519326,10519327,10519328,10519329,10519330,10519331,10519332,10519333,10519334,10519335,10519336,10519337,10519338,10520822,10520924,10520925,10520926,10520927) 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'