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(11014620,11014621,11014622,11014623,11014624,11014625,11014626,11014627,11014628,8838437,8838438,8838439,8838440,11027751,11027752,11027753,7076081,11014800,11014801,11014802,11014803,11014806,11014807,11014808,11014809,11014810,11014811,11014812,11014813,11014814,11027847,11027848,11027849,11014865,11027887,11027888,11027889,11027890,11027891,11027892,11027893,11027894,11027895,11027896,11027897,11027898,11015170,11015185,11015186,11015187,11015188,11015190,11015191,11015192,11015193,11015194,7068599,7068600,7068601,7068602,10963522,10950523,10950524,10950525,11041693,10976723,10976724,10976725,10976726,10976727,10976728,10976729,10976730,10976731,7074047,10976732,7074048,7074049,11041745,11041749,11041760,10437287,8575694,8575741,10951228,7074881,11013637,11039642,7066959,11039643,11039644,11039645,11039646,11039647,11039648,11039649,11013649,11039650,11039651,11039652,11039653,11039654,11039655,11039656,11039657,11039658,11039659,11039660,11039661,11039662,11039663,11039664,8837480,8837481,8837482,8837497,8837498,8837499,11013711,11013712,11013713,11013714,11013715,11013716,4969252,4969253,4969254,4969255,4969256,4969257,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969266,11013735,4969267,4969268,4969269,11013776,11013797,8837646,8837647,8837648,8837649,10939098,10939099,11001525,11001526,11001527,11001528,11014613,7072170,10960064,8911451,11012163,11012164,11012165,11012166,11012167,11012168,7072535,11025257,11025259,11025260,11025261,11025262,11025263,11025264,11025353,11025354,11025355,11025356,11025357,11025358,11025359,11025360,11025396,11025397,11025398,11025399,8836344,8836345,7072859,10986560,10986561,10986562,11012578,11012586,11012587,11012588,11012589,11012590,11012591,11012592,11012593,10999639,10999640,10999641,8066033,8066034,8066035,8066036,8066037,8066038,8066039,7073098,7065328,7065329,7065330,7065331,7065332,11013042,11013043,11013044,11013045,11013046,11013069,11013070,11013071,11013072,11013073,11013355,11013356,11013357,11013358,11013364,11013365,8837171,8837172,8837173,8837174,8837175,8837187,8837188,8837189,8837190,11013482,11013483,11013488,11013489,11013490,7071401,7071402,5999942,10943304,6000019,6000023,8910900,3655564,11021898,11021899,11021900,11021901,11021902,11021903,11021904,11021935,11021936,10995937,11021937,11021938,10995938,11021939,10995939,11021940,10995940,10995941,11021941,10995942,10995943,10995944,11021965,11021966,11022806,11035899,11048299,11048300,11048301,11048302,11048303,11023159,10942116,10958209,10958210,10958211,10958212,10958213,10958214,10958215,10958216,10958217,10958218,10958219,10958220,10958221,10958222,10958223,10958224,10958225,10958226,10958227,10958228,10958229,10958230,10958231,10958232,10958233,10958234,10958235,10958236,10958237,10958238,10958239,10958240,10958241,10958242,10958243,10958244,10958245,10958246,10958247,10958248,10958249,10958250,10958251,10958252,10958253,10958254,10958255,10971339,10971340,10971341,11023399,10971421,11006665,11006666,11006668,11006669,11006705,11006706,11006707,11019733,11006749,11006750,11006751,11045764,11045765,11045766,11045767,11045768,11045769,11045770,11045771,11045772,11045773,11045774,11045775,11045776,11045777,11045778,11045779,11045780,11045781,11045782,11045783,11045784,11045785,11019821,11019822,11019823,11006830,11006831,11032895,11032896,11019988,8906391,10918991,10918992,10918993,10918994,10918995,10919000,10919001,10968150,11020248,11020249,11020250,11020251,11020252,11020253,11020254,11020255,11020256,11020257,11020258,11020259,11020260,11020261,11033468,11033469,11033470,11033471,11033472,11046644,10919663,10919664,10919665,8907225,11020877,8070930,11020922,11020930,11020931,11020932,11020933,10925100,10925101,10925102,10925103,10925104,10917528,10917529,10917530,10917531,10917532,10917533,10917549,10917550,10927550,10917551,10917552,10917553,11005758,11005762,11031763,11005763,11005807,11005808,10917690,11005906,11005907,11005908,10917767,10917768,10917769,10917770,10917771,10917772,11005921,10917773,11005922,10917779,10917780,11018993,11018994,11018995,11018996,11018997,11006006,11006007,11006008,11006037,11006038,11019056,11019057,11019058,11019059,11019060,11019062,11019063,11019064,11019065,11019066,11032093,11006110,11006111,11006114,11006115,10918055,11006274,11006275,11032301,10928249,11006413,11006414,11006463,11019496,11019497,11019498,11019499,11019500,11019501,11019502,11019503,11019504,11019505,11019506,11019507,11019508,11006509,11006510,11032520,11032535,11032536,11032537,11032538,11032539,11032546,11006555,10990620,10990621,10990622,10990635,10990657,10990828,10990829,10964834,10964835,11030024,11030025,11030026,11030027,11030046,11017175,11017176,11017177,11017178,11017179,11017180,11017181,11017182,11017183,11017184,11017185,11017186,11017187,11017188,11017189,11017190,11017191,11017192,11017193,11017194,11017195,11017196,11017197,11017198,10615552,10916106,10916107,10916108,10916109,10916121,10916122,10916123,10916124,10916125,10916126,10916127,11017304,11017305,11017306,11017307,11017308,11017309,11017310,11017311,11017312,11017313,11017314,11017315,11017316,11017317,11017318,11017319,11017320,11017321,11017322,11017323,11017324,11017339,11017340,11017341,11017342,11017343,11017344,10930633,10926294,11004563,11004564,10621059,10621060,10621061,10621062,10621063,10621064,10621065,11004883,11004896,11004907,11030992,11031292,11031293,11005323,10917194,10917195,10917220,10917221,10917222,10917223,10917224,10917225,10917226,10917227,8904783,8904784,11005497,11005584,9165378,9165379,9165380,9165381,9165382,9165383,9165384,9165385,9165386,9165387,9165388,9165389,9165390,9165391,9165392,9165393,9165394,9165395,9165396,9165397,9165398,9165399,9165400,9165401,10611162,8864274,8864398,8864536,8864537,9214184,9203360,9203361,9203362,9179596,9172077,9172078,7058748,9188740,9188741,9188742,9188743,9188744,9188745,9196757,9188953,9188955,9197115,7059323,10564991,9201306,9201316,9201319,9201320,9201321,9201323,4974209,9177624,9177625,9177626,9177627,9177628,9177629,9177630,4974498,4974499,9201699,9201715,9201716,9201717,9201839,9201902,9201955,9201956,9202296,9202302,9202456,9186861,9203075,9200300,9200333,9200348,10415548,4973557,9200918,9200919,10416927,9201038,9201039,9201040,9201041,9201043,9201044,9206560,9206561,9206562,9206563,9206564,9206565,9206566,9206567,9206568,9206569,9206570,9206571,9206572,9206573,9206574,9206575,9206576,9206577,9206578,9206579,9206580,9206581,9206582,9174583,9174584,9174588,9174589,10465713,10465714,10465715,10465716,10465717,10465718,10465719,10465720,10465721,10465722,10465723,10465724,10465725,10465726,10465727,10465728,10465729,9183362,10470007,10470008,6667453,8917328,8917329,8917330,8917331,9200072,9200073,9176279,10179511,10179512,10179524,10179525,10179526,10179527,10159532,10159533,10159534,10159535,10159536,10159537,10159538,10159539,10159540,10159541,10159542,10159543,10159590,10179691,10179692,10179693,10179694,10179774,10174774,10174775,10180241,10170916,10170917,10629508,10156265,10181273,10166339,10166340,10166341,10166342,10166462,10163598,10173613,10173614,10173615,10158794,10158795,10168870,10169003,10169004,10169005,10169006,10169007,10174363,10174364,10630008,10176734,10177322,10162343,10172398,10172399,10631013,10631014,10631015,10631016,10631017,10172601,10167601,10172602,10167602,10172603,10167603,10172604,10167604,10172605,10167605,10172606,10172607,10172608,10172827,10626771,10626772,10626773,10178391,10178392,10178393,10178398,10178399,10178400,10178401,10178402,10571247,10571274,10571275,10571276,10571277,10574488,10574489,10574490,10574491,10574492,10574493,10574494,10574495,10574496,10574497,10574498,10574499,10574500,10574501,10574502,10574503,10574504,10571670,10571961,10571962,10571963,10571964,10571965,10571966,10569076,10569077,10569078,10569079,10569080,10584399,10584400,10584401,10569573,10569574,10572662,10572663,10572664,10572665,10572666,10572667,10572668,10572683,10572684,10572685,10572686,10572687,10572688,10572689,10572690,10572691,10572692,10587992,10587993,10587994,10587995,10587996,10587997,10587998,10587999,10588000,10588001,10588002,10588003,10588004,10588005,10582169,10573274,10573275,10573276,10570694,10570695,10570696,10570697,10570698,10570699,10570700,10570701,10570702,10570703,10570704,10570705,10570706,10570707,10570708,10570709,10570710,10570711,10570712,10570713,10570714,10570715,10570716,10570717,10570718,10570719,10570720,10570721,10570722,10573963,10573964,10573965,10573966,10573967,10573968,10571106,10521154,10519960,10522203,10522204,10522205,10522749,10522750,10522751,10522973,10423852,10421053,10423072,10479093,10479094,10479095,10479096,10479097,10479098,10472699,10472700,10472701,10472702,10472703,10472704,10472705,10472706,10472707,10472708,10472709,10472710,10472711,10472712,10487813) 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'