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(10943577,10943578,10943579,10943580,10943581,10943582,7068175,7068176,7068177,7068178,7068179,7068180,7068181,7068182,7068183,7068184,7068185,7068186,7068187,7068188,7068189,7068190,7068191,7068192,7068193,7068194,7068195,7068196,7068197,7068198,7068199,7068200,7068201,7068202,7068203,7068204,7068205,7068206,7068207,7068208,7068209,7068210,7068211,7068212,11001906,7076304,8569405,8569406,8569407,8569408,10940100,10940101,10940102,10940103,10940104,10940105,10940106,10940107,10940108,10940109,10940110,10940111,10940112,10940113,10940114,10940115,10940116,10940117,10940118,10940119,10940120,10940121,10940122,10940123,10940124,10940125,10940126,10940127,11002189,10940128,11002190,10940129,10940130,11002191,10940131,11002192,10940132,10940133,10940134,10940135,10940136,4970933,11002450,11002451,11002452,8569755,8569756,4971032,4971033,11002586,11002587,10933294,10933295,10933296,11002747,11002748,11002749,10963866,10963867,11002905,11002906,11002907,11002908,11002909,11003322,11003323,11003345,11003346,7066732,10437699,7075042,7075043,7075088,7075089,11013922,11014212,10939424,7064283,7064284,7064285,7064286,7064287,7064288,8075233,8075234,7072733,7072734,10999566,10999568,8066007,8066012,8066015,4967770,4967771,4967772,4967773,10974251,10974252,10974253,10974254,10974255,10974256,10974257,10974258,10974259,10974260,10974261,10974262,10974263,10974264,10974265,10974266,10974267,10974268,10974269,10974270,10974271,10974272,10974273,10974274,10974275,10974276,10974277,10974278,10974279,10974280,10974281,10974282,10974283,10974284,10974285,10974286,10974287,10974288,10974289,10974290,10974291,10974292,10974293,10974294,10974295,10974296,10974297,10974298,10974299,10974300,10974301,10974302,10974303,10974304,10974305,10974306,10974307,10974308,10974309,10974310,10974311,10974312,10974313,10974314,10974315,10974316,10974317,10974318,10974319,10974320,10974321,10974322,10974323,10974324,10974325,10974326,10974327,10974328,10974329,10974330,10974331,10974332,10974333,10974334,10974335,10974336,10974337,10974338,10974339,10974340,10974341,10974342,10974343,10974344,10974345,10974346,10974347,10974348,10974349,10974350,10974351,10974352,10974353,10974354,10974355,10974356,10974357,10974358,10974359,10974360,10974361,10974362,10974363,10974364,10974365,10974366,10974367,10974368,10974369,10974370,10974371,10974372,10974373,10974374,10974375,10974376,10974377,10974378,10974379,10974380,10974381,10974382,10974383,10974384,10974385,10974386,10974387,10974388,10974389,10974390,10974391,10974392,10974393,10974394,10974395,10974396,10974397,10974398,10974399,10974400,10974401,10974402,10974403,10974404,10974405,10974406,10974407,10974408,10974409,10974410,10974411,10974412,10974413,10974414,10974415,10974416,10974417,10974418,10974419,10974420,10974421,10974422,10974423,10974424,10974425,10974426,10974427,10974428,10974429,10974430,10974431,10974432,10974433,10974434,10974435,10974436,10974437,10974438,10974439,10974440,10974441,10974442,10974443,10974444,10974445,10974446,10974447,10974448,10974449,10974450,10974451,10974452,10974453,10974454,10974455,10974456,10974457,10974458,10974459,10974460,10974461,10974462,10974463,10961485,10985208,10985209,10944473,10944474,7069334,7069335,7069336,10944949,10944950,11047624,11047625,3656506,3656581,10997192,10984354,10984355,10984356,10984357,10984358,10984359,10984360,10984361,10984362,10984363,10984364,10984365,10984366,10984367,10984368,10984369,10984370,11048663,11048664,11048665,10981537,10981538,10994782,10994784,10994785,10994803,8070858,11005734,11005748,11003666,11003776,11003777,11003778,11003779,11003780,11003781,11003833,11003834,10925734,10925735,10925736,10925737,10925738,10925739,10925740,10925741,10925742,10925743,10925744,11003916,11004014,8570362,8570367,8570368,11004078,11004079,11004080,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620661,10620662,10620663,10620664,10620665,10620666,10620667,10620668,10620669,10620670,10620671,10620672,10620673,10620674,10620675,10620676,10620677,10620678,10620679,10620680,10620681,10620682,10620683,10620684,10620685,10620686,10620687,10620688,10620689,10620690,10620691,10620692,10620693,10620694,10620695,10620696,10620697,10620698,11004669,11004670,11004671,11004727,11005206,11005207,11005208,11005209,11005210,10966231,10966353,10953356,10953357,10953358,10953359,10953360,10953361,10953362,10953363,10953364,10953365,10953366,10953367,10953368,10953369,10953370,10953371,10953372,10953373,10953374,10953375,10953376,10953377,10953378,10953379,10966438,10966439,11005539,11005540,7059472,7059498,10559241,9181734,9181735,9181736,9181737,9173774,9174023,6666256,10557617,10612845,9172392,10613107,10610312,10558479,10613332,10613333,8863239,8863240,8863241,8863242,8863243,8863244,8863245,8863246,8863247,8863248,8863249,8863250,8863251,8863252,8863253,7056250,7056251,7056252,7056253,7056254,7056255,7056256,7056257,7056258,7056259,7056260,7056261,7056262,7056263,7056264,7056265,7056266,7056267,7056268,4974971,4974972,4974973,4974974,2809134,2809135,10556475,2809340,2809341,2809342,2809343,2809344,2809345,2809346,2809347,2809348,2809349,2809350,2809351,2809352,2809353,2809354,2809355,7057124,10519068,10519069,10519070,10519071,10519072,10519073,10519074,8861783,10519075,8861784,8861785,10519076,8861786,10519077,10519078,8917990,8917991,8917992,8917993,10417351,10419694,9161079,9161080,9161081,9161082,9161083,9161084,9161085,9161086,9161087,9161088,9161089,9161090,9161091,9161092,9161093,9161094,9161095,9161096,9161097,9161098,9161099,9161100,9161101,9161102,9161103,9177158,9177159,9177160,9177161,9177162,9177163,9177164,9177165,9177166,9177167,9177168,9177169,9177170,9177171,9177172,9177173,9177174,9177175,9177176,9177177,9177178,9177179,9177180,9177181,9177182,9177183,9177184,9177185,9177186,9177187,9177188,9177189,9177190,9177191,9177192,9177193,9177194,9177195,9177196,9177197,9177198,9177199,9177200,9177201,9177202,9177203,9177204,9177205,9177206,9177207,9177208,9177209,9177210,9177211,9177212,9177213,9177214,9177215,9177216,9177217,9177218,9177219,9177220,9177221,9177222,9177223,9177224,9177225,9177226,9177227,9177228,9177229,9177230,9177231,9177232,9177233,9177234,9177235,9177236,9177237,9177238,9177239,9177240,9177241,9177242,9177243,9177244,9177245,10463229,10463230,10463231,10463232,10463233,10463234,10463235,10463236,10463237,10463238,10463239,10463240,10463241,10463242,10463243,10463244,10463245,10463246,10463247,10463248,10463249,10463250,10463251,10463252,10463253,10463254,10463255,6666928,6666929,4971784,6666930,4971785,6666931,4971786,6666932,4971787,6666933,4971788,6666934,4971789,6666935,4971790,6666936,4971791,6666937,4971792,6666938,4971793,6666939,4971794,4971795,4971796,4971797,4971798,4971799,4971800,4971801,4971802,4971803,4971804,4971805,4971806,4971807,4971808,4971809,6667000,8916878,8563440,8917934,8917935,10155226,10155227,10632054,10631090,10631091,10631092,10631093,10631094,10631095,10631168,10631169,10631170,10631171,10631172,10631173,10631174,10631868,10523112,10523113,10523114,10523115,10523116,10523117,10523118,10523119,10523120,10523121,10523122,10523123,10523124,10523125,10523126,10523127,10523128,10522040,10522041,10522042,10522399,10524668,10524669,10527046,10527047,10527048,10527049,10523076,10523077,10523078,10523079,10523080,10523081,10523082,10523083,10523084,10523085,10523086,10523087,10523088,10523089,10523090,10523091,10523092,10523093,10523094,10523095,10523096,10523097,10523098,10523099,10523100,10523101,10523102,10523103,10523104,10523105,10523106,10523107,10523108,10523109,10523110,10523111,10420306,10422387,10422398,10422406,10422414,10422443,10422782,10423886,10420966,10420967,10420968,10420969,10420970,10420971,10420972,10420973,10420974,10420975,10420976,10420977,10420978,10420979,10420980,10423108,10478534,10478535,10478536,10478537,10478538,10478539,10478540,10478541,10478542,10478543,10478544,10478545,10478546,10478547,10478548,10478549,10478550,10478551,10478552,10478553,10478554,10478555,10478556,10478557,10478558,10478559,10478560,10478561,10478562,10478563,10478564,10478565,10478566,10478567,10478568,10478569,10478570,10478571,10478572,10478573,10478574,10478575,10478576,10478577,10478578,10478579,10478580,10478581,10478582,10478583,10478584,10478585,10478586,10478587,10478588,10478589,10478590,10478591,10478592,10478593,10478594,10478595,10478596,10478597,10478598,10478599,10478600,10478601,10478602,10478603,10478604,10478605,10478606,10478607,10478608,10478609,10478610,10478611,10478612,10478613,10478614,10478615,10478616,10478617,10478618,10478619,10478620,10478621,10478622,10478623,10478624,10478625,10478626,10478627,10478628,10478629,10478630,10478631,10478632,10478633,10478634) 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'