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(10989201,7074326,7074327,7074328,7074329,7074330,7074331,7074332,7074333,7074334,7074335,7074336,7074337,7074338,7074339,7074340,8067520,8067521,4968841,4968842,4968843,4968844,4968845,10987639,10931533,10931536,10931537,10986041,10986042,10986043,10986044,10986046,10986047,10986048,10986049,10986050,10986051,10986073,8065806,8065807,8065823,7065140,10961200,10961201,10961202,10961203,7073615,7073616,7073617,7073618,7073619,7065915,10942628,10942629,10997806,10997807,10997808,10997809,10997810,10997811,10997812,10997813,10997814,10997815,10997816,10997817,10997818,10997819,10997820,10997821,10997822,10997823,10997824,10997825,10997826,10997827,10942767,10997828,10997829,10942768,10997830,10997831,10997832,10997833,10997834,10997835,10997836,10997837,10997838,10997839,10997840,7071238,10958931,10958932,10958933,10958934,10958935,10958936,10958937,10958938,10958939,10958940,11049306,11049307,11049308,11049309,11049310,11049311,10959180,10959181,10943252,7071867,7071868,10944879,10944880,10944881,10957356,10957357,10957358,10957359,10957360,10957361,10957362,10957363,10957364,10957365,10957366,10957367,10957368,10957369,10957370,10957371,10957372,10957373,10957374,3656298,3656299,3656300,3656301,3656302,3656303,3656304,3656305,3656306,3656307,3656308,3656309,3656310,3656311,10996425,3656312,10996426,3656313,3656314,3656315,3656316,3656317,3656318,3656319,3656320,3656321,3656322,3656323,3656324,3656325,3656326,3656327,3656328,3656329,3656330,3656331,3656332,3656333,3656334,3656335,3656336,3656337,3656338,3656339,3656340,3656341,3656342,3656343,3656344,3656345,3656346,3656347,3656348,3656349,3656350,3656351,3656352,3656353,3656354,3656355,3656356,3656357,3656358,3656359,3656360,3656361,3656362,3656363,3656364,3656365,3656366,3656367,3656368,3656369,3656370,3656371,3656372,3656373,11048405,10942181,10942182,10942183,10942184,10942185,10942186,10942187,10942188,10942189,10942190,10942191,10942192,10942193,10942194,11010473,11010474,11010475,11010476,11010477,11010478,11010479,11010480,11010481,11010482,11010483,11010484,11010485,11010486,11010487,11010488,11010489,11010490,11010491,11010492,11010493,11010494,11010495,11010496,11010497,11010498,11010499,11010500,11010501,11010502,11010503,11010504,11010505,10967777,10967778,10967779,10967780,10618257,10618258,8070363,8070366,8070369,8070371,8070381,8070387,8070394,8070400,8070401,8070546,8070549,8070561,8070564,8070569,8070572,10617075,10622187,10927957,10927958,10927959,10927960,10927961,10927962,10927963,10620079,10620080,10620081,10620082,10620083,10615243,10615244,10990948,10990949,10990950,10990951,10990952,10990953,10990954,10990955,10990956,10990957,10990958,10990959,10990960,10990961,10990962,10990963,10990964,10990965,10990966,10990967,10990968,10990969,10990970,10990971,10990972,10990973,10990974,10990975,10990976,10990977,10990978,10990979,10990980,10990981,10990982,10990983,10990984,10990985,10990986,10990987,10990988,10990989,10990990,10990991,10990992,10990993,10990994,10990995,10990996,10990997,10990998,10990999,10991000,10991001,10991002,10991003,10991004,10991005,10991006,10991007,10991008,10991009,10991010,10991011,10991012,10991013,10991014,10991015,10991016,10991017,10991018,10991019,10991020,10991021,10991022,10991023,10991024,10991025,10991026,10991027,10991028,10991029,10991030,10991031,10991032,10991033,10991034,10991035,10991036,10991037,10991038,10991039,10991040,10991041,10991042,10991043,10991044,10991045,10991046,10991047,10615389,10991048,10991049,10991050,10991051,10991052,10991053,10991054,10991055,10991056,10991057,10991058,10991059,10991060,10991061,10991062,10991063,10991064,10991065,10991066,10991067,10991068,10991069,10991070,10991071,10991072,10991073,10991074,10991075,10991076,10991077,10991078,10991079,10991080,10991081,10991082,10991083,10991084,10991085,10991086,10991087,10991088,10991089,10991090,10991091,10991092,10991093,10991094,10991095,10991096,10991097,10991098,10991099,10991100,10991101,10991102,10991103,10991104,10991105,10991106,10991107,10991108,10991109,10991110,10991111,10991112,10991113,10991114,10991115,10930570,10930571,10930942,10616081,10616082,10616083,10616084,10616085,10922144,10922145,10922146,10922147,10922148,10922149,10922150,10922151,10922152,10922153,10922154,10922155,10922156,10922157,10922158,10922159,10922160,10922161,10922162,10922163,10922164,10922165,10922166,10922167,10922168,10922169,10922170,10922171,10922172,10922173,10922174,10922175,10922176,10922177,10922178,10922179,10922180,10922181,10922182,10922183,10922184,10922185,10922186,10922187,10565128,10565129,10565130,10565131,10565132,10565133,10565134,10565135,10565136,10565137,10565138,10565139,10565140,10565141,10565142,10565143,10611116,10559333,8864352,8864353,8864354,8864355,8864385,8864386,10559709,9165993,9165994,9165995,9165996,9165997,9165998,9165999,9166000,9166001,9166002,9166003,9166004,10614818,9166177,9166178,8864775,8864776,8864777,8864778,8864779,8864780,8864781,8864782,8864783,8864784,8864785,8864786,8864787,8864788,8864789,8864790,8864791,8864792,9182281,10612134,10612135,10612136,10612137,10612315,10612316,10612317,10612318,7057851,7057852,7057853,7057854,10609393,9171799,9179938,8862498,8862572,8862573,7058470,10613086,10610228,7058797,7058798,7058799,7058800,7058801,7058802,7058803,7058804,7058805,7058806,7058807,7058808,7058809,7058810,7058811,7058812,10613513,10613514,10610855,10610856,10610857,10610858,10610859,10610860,10610861,10610862,10610863,10610864,10610865,10610866,10610867,10610868,10610869,10610870,10610871,10610872,10610873,10610874,10610875,7055533,9169368,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,9169513,9169514,9169515,9161692,10517791,10517792,10517793,10517794,10517795,10517796,10517797,7056160,10512739,10512740,10512741,7057156,7057216,7057245,10416339,10416340,10416341,10416342,9168426,9168427,10417361,10417362,10417363,10417364,10417365,10417366,10417367,10417368,10417369,10417370,10417371,10415375,10415376,9168499,10419469,8918211,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,9169288,10465106,10469495,10469496,6667371,6667372,8917089,8917090,6667543,6667544,6667545,6667546,6667547,6667548,10468226,10468227,6667683,6667684,6667685,6667686,6667687,6667688,6667689,6667690,6667691,6667692,6667693,6667694,6667695,6667696,6667697,6667698,6667699,6667700,6667701,6667702,6667703,6667704,6667705,6667706,6667707,6667708,6667709,8917359,6667710,8917360,6667711,8917361,6667712,8917362,6667713,8917363,6667714,8917364,6667715,6667716,6667717,6667718,6667719,6667720,6667721,6667722,6667723,6667724,6667725,6667726,6667727,6667728,6667729,6667730,6667731,6667732,6667733,9175805,9175806,9175807,9175808,9175809,9175943,9168077,6668119,8917840,8917841,8917842,8917843,8917844,8917845,8917846,8917847,8917848,8917849,8917850,8917851,8917852,8917853,8917854,8917855,10159898,10159899,10159900,10159901,10159902,10159903,10159904,10159905,10159906,10159907,10159908,10159909,10159941,10159942,10159943,10628814,10628815,10628816,10628817,10628818,10628819,10628820,10628821,10628822,10628823,10628824,10628825,10627934,10627935,10627936,10627937,10627938,10630180,10630181,10630182,10630183,10630184,10630185,10630186,10630187,10630188,10630189,10630190,10630191,10630192,10630193,10630194,10630195,10630196,10630197,10630198,10630199,10630200,10630201,10630202,10630203,10630204,10630205,10630206,10630207,10630208,10630209,10630210,10630211,10630212,10630213,10630214,10630215,10630216,10630217,10630218,10630219,10630220,10630221,10630222,10158224,10631843,10580115,10580116,10580117,10580118,10580119,10580120,10522164,10522165,10522166,10522167,10522168,10522169,10522170,10522171,10522172,10522173,10522174,10522175,10522176,10522177,10522178,10522179,10522180,10522181,10522182,10522183,10522184,10522185,10522186,10522187,10522188,10522189,10522190,10522191,10522192,10522193,10522194,10522903,10422586,10422587,10423689,10423690,10423691,10423692,10423693,10423694,10423695,10423702,10423703,10423704,10423705,10423706,10423707,10423708,10423709,10423710,10423711,10423712,10423713,10423714,10423715,10423716,10423717,10423718,10423719,10423720,10423721,10423722,10423723,10423724,10423725,10423726,10423727,10423728,10423729,10423730,10423731,10423732,10423733,10423734,10423735,10423736,10423737,10423738,10423739,10423740,10423741) 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'