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(7076159,10943628,8569566,10989324,10989326,7065995,7066050,7066167,7066177,7066276,10990263,10990264,10990265,10990266,10990267,7074584,7074777,7074922,8067909,7075018,8067910,8067933,10939427,10939428,10959882,7072225,10960057,7064548,4967032,8065830,7065567,7065568,7065856,10959202,10959204,10985217,10985218,10985219,10985220,10985221,10985222,10985223,10985224,10985225,10959252,10959614,10959615,11048357,11048364,11048410,11048437,10618277,10618281,10618286,10618287,10618291,10618299,10618304,10623508,10619177,10619864,10619865,10619866,10617024,10617035,10617047,10617091,10617164,10617166,10622189,10622258,10622264,10622268,10953992,10953994,10622360,10954023,10622431,10954097,10622447,10622455,10622463,10617500,10617506,10622514,10622516,10954196,10615008,10615009,10615080,10620121,10615152,10615165,10615166,10615202,10615230,10615237,10615265,10615293,10615295,10615296,10615297,10615298,10615299,10615300,10615301,10615302,10620302,10615303,10615304,10615305,10620306,10615306,10615324,10615338,10615347,10615353,10615363,10615443,10615447,10615548,10615580,10615590,10615603,10615604,10615615,10615624,10615654,10615658,10615685,10615694,10615703,10615709,10615724,10615725,10615726,10615728,10615771,10615773,10615777,10615778,10615781,10615785,10615786,10615789,10615798,10615799,10615822,10615826,10615841,10615842,10615845,10615846,10615847,10615848,10615849,10615850,10615852,10615853,10615855,10615856,10615857,10615858,10615876,10615877,10615960,10615961,10615977,10615978,10991663,10991664,10991665,10991666,10991667,10991668,10616048,10616049,10616060,10991757,10991760,10616105,10991775,10616193,10616202,10616203,10616204,10616205,10616206,10616207,10616208,10616212,10616213,10616214,10952894,10616237,10952895,10952896,10616238,10616239,10952897,10616242,10616277,10616280,10616281,10616291,10616292,10616294,10616296,10616325,10616326,10616338,10616339,10616340,10616358,10616385,10616392,10616396,10616398,10616399,10616414,10616416,10616437,10616438,10616439,10616442,10616641,10616642,10616643,10616644,10616645,10992335,10992336,10616697,10616815,10616844,10616848,10616858,10616866,10616888,10616904,10616910,10616916,10616917,10616918,10610984,10610985,10614048,10614050,9165413,9165460,7059643,7059644,10611146,10611148,10611149,10611161,10614181,10611203,10614210,10614236,10611236,10614237,10611257,10614289,10611295,10614297,10611298,10611299,10614301,10614304,10611365,10611375,10611377,10611393,10611396,10611407,10611408,10611416,10611426,10611432,10611456,10611464,10611485,10611489,10614493,10611498,10614501,10611508,10611509,10614524,10611526,10611539,10611540,10614542,10611545,10611551,10559703,10611555,10611557,10611558,10611559,10559711,10559712,10611586,10611610,10611611,10614619,10611625,10614637,10614638,10611640,10611643,10611660,10611670,10611673,10611675,10611678,10611684,10614713,9166099,10614763,10611764,10611799,10611802,10611819,10614857,9166251,10611960,10611973,10611981,10611983,10611989,10611995,10611997,10611999,10612000,10612001,10612002,10612003,10612004,10612029,10612042,10612062,10612063,10612064,10612082,10612083,10609085,10609093,10609095,10609106,10612109,10612126,10609150,10609151,10609152,10609154,10612168,10612169,10612189,10609194,10609195,10612210,10612223,10612224,10609243,10609246,10609262,10609277,10609278,10609285,10609287,10609303,10609338,10612344,10609376,10609378,10609379,10609392,10609411,10609422,10612429,10612430,10612431,10609446,10609447,10609455,10609462,10612467,10612473,10609474,10612476,10612477,10609494,10612501,10612502,10612503,10612504,10612505,10612506,10609514,10609528,10609536,10609541,10612572,10609578,10609579,10609580,10609581,10609582,10609583,10609584,10609585,10609586,10612601,10612602,10612603,10612604,10612605,10612606,10612607,10612608,10612609,10612610,10609618,10609619,10609620,10609621,10609622,10609639,10612654,10609657,10609669,10609674,10612675,10609679,10609680,10612685,10612691,10612692,10612703,10612713,10609713,10609724,10612746,10612767,10609770,10609824,10612825,10609828,10612833,10612834,10609835,10609836,10609838,10612841,10609841,10612842,10612846,10612849,10612884,10612904,10612907,10612912,10612914,10612915,10612933,10609937,10609938,10612945,10612958,10612960,10612961,10612967,10609978,10612992,10610006,10610035,10610037,10610039,10610041,10610042,10610044,10610046,10610053,10610054,10613056,10613080,10610098,10613127,10613187,10613192,10613193,10613194,10613195,10613202,10613203,10610233,10610237,10613322,10613342,10613349,10613380,7058908,10613440,10613442,10610480,10613508,10613509,10613513,10613514,10613579,10613594,10613612,10613654,10613662,10610668,10613673,10610676,10610677,10610678,10613694,10613735,10613744,10610753,10610782,10610783,10610784,10610789,10610799,10613805,10613806,10610822,10610825,10610826,10610830,10610834,10610869,10610871,10610927,10610947,10610955,9169302,9169305,7055539,7056001,10415224,10418232,10418233,10418234,9160319,10419252,10416253,9160335,10416258,9160342,10418271,10418272,10417283,10416284,10418303,10418304,10418305,10418306,10415313,10415314,10415317,10418318,10418323,10418324,10418325,10418326,10418327,10418328,10418329,10418330,10416361,10419366,10416376,10416379,10416382,10418383,10418384,10418385,10418389,10415389,10418390,10418391,10415391,10418392,10418407,10419408,10415408,10416415,10419416,10416416,10416417,10416418,10416419,10416420,10416421,10416422,10416423,10416424,10416425,10416426,10416427,10416428,10417429,10416429,10417430,10416430,10417431,10417432,10417433,10417434,10417435,10417436,10417437,10417438,10417439,10417440,10417441,10417442,10415451,10419463,10418466,10418473,10418488,10416490,10416491,10418492,10416492,10418506,10416521,10416523,10417529,10416529,10416530,10417534,10417537,10415539,10415540,10415541,10415542,10416544,10416551,10418552,10418553,10419556,10418557,10419557,10415557,10419564,10419565,10419566,10415566,10419567,10419570,10416573,10416574,10416575,10418577,10416577,10416580,10415602,10415603,10415604,10415605,10415606,10415607,10416627,10415634,10417634,10415654,10415657,10415658,10415660,10415662,10417666,10418689,10418690,10415705,10415711,10415718,10418734,10415743,10417788,10416789,10416793,10416794,10416797,10419802,10419803,10419804,10419805,10419806,10419807,10419808,10419809,10416840,10416841,10416842,10416843,10416844,10416845,10416846,10418864,10418865,10419865,10419866,10416873,10416874,10418877,10416887,10416888,10416889,10416890,10416891,10416892,10416922,10418953,10417955,10417964,10416967,10417977,10417982,10417985,10416988,10417989,10416989,10416990,10417996,10418003,10418019,10418020,10418021,10417021,10418022,10418028,10418033,10416034,10418034,10418035,10418036,10417036,10417037,10417038,10417039,10417040,10417042,10417045,10417050,10417051,10417052,10417054,10417055,10417056,10417057,10417058,10417059,10417060,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417070,10417071,10417073,10417075,10417076,10417077,10418078,10417078,10418079,10419082,10416113,10419114,10418146,10418169,10418170,10418171,10418172,10418173,10418174,10419179,10419197,7055450,10468893,10468947,10471116,10469143,10471162,10469248,10467466,10467514,10467519,10467525,10467530,10467542,10467546,10467553,10469918,10469919,10469920,10469921,10469922,10469923,10469924,10469925,10469926,10469929,10469930,10469946,10463995,10463996,10470109,10470114,4972394,4972395,4972396,4972397,10470161,10470174,10470223,10464235,10468253,10468254,10468255,10470264,10470265,10470295,10470302,10470320,10468323,10468324,10468325,10468326,10468327,10468328,10468329,10470333,10470337,10470353,10470354,10470365,10470380,10470381,10470385,10470420,10470421,10470432,10470434,10470447,10470448,10470449,10470450,10470451,10470452,10470453,10470454,10470455,10470456,10470457,10470458,10470459,10470460,10470461,10470462,10470463,10470464,10470465,10470466,10470467,10470468,10470469,10470470,10470473,10470475,10470477,10470478,10470480,10470481,10470483,10470484,10470486,10470489,10470490,10470491,10470492,10470495,10470497,10470499,10470500,10470501,10470503,10470504,10470505,10470510,10470511,10470512,10470513,10470514,10470515,10470516,10470517,10470519,10470520,10470521,10470523,10470526,10470527,10470528,10470529,10470531,10470532,10470534,10470535,10470537,10470538,10470540,10470542,10470544,10470545,10470546,10470548,10470550,10470553,10470554,10470556,10470559,10470561,10470563,10470564,10470566,10470568,10470570,10470572,10470574,10470581,10470590,10470593,10470607,10470608,10470613,10470614,10470622,10470623,10470627,10470628,10470643,10470647,10470648,10470673,10470694,10468695,10468696,10470696,10468697,10468698,10470704,10468758,10468825,10468840,10468855,10468857,10468858,10468860,10468862,10468863,10468867,10468868,10632011,10632013,10627321,10153861,10153862,10153863,10627771,10630822,10630823,10630853,10630856,10626123,10626143,10626144,10626145,10626431,10626876,10421515,10477421,10477423,10477437,10477438,10477505,10477549,10476342) 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'