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(10962716,7068051,7068052,7068053,7068054,7068055,7068056,7068057,7068058,7068059,7068060,7068061,7068062,7068063,7068064,7068065,7068066,7068067,7068068,7068069,7068070,7068071,7068072,7068073,7068074,7068075,7068076,7068077,7068078,7068079,10943519,10943520,10943521,10943522,10943523,10943524,10943525,10943526,10943527,10943528,10943529,10943530,10943531,7076299,8569399,8569400,8569401,10940063,10940064,10940065,10940066,10940067,10940068,10940069,10940070,10940071,10940072,10940073,10940074,10940075,10940076,10940077,10940078,4970854,8569744,8569745,8569746,8569747,8569748,10940510,10940511,10940512,10944347,10944348,7073981,7073982,7066597,7066803,7066804,7066805,10964578,10964579,10938587,10938588,10938589,10938590,10938591,10938592,10938593,10938594,10938595,10938596,10938597,10938598,10938599,10938600,10938601,10938602,10938603,10938604,10938605,10938606,10938607,10938608,7067703,7067837,10962576,10962594,7064214,7064215,7064216,7064217,7064218,7064219,7072219,7064220,7064221,7064222,7064223,7064224,7064225,7064226,7064227,7064228,7064229,7064230,7064231,7064232,7064233,7064234,7064235,7064236,7064237,7064238,7064239,7064240,10973287,10973288,10973289,10973290,10973291,10973292,10973293,10973294,10973295,10973296,10973297,10973298,8066071,8066157,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967451,4967452,4967453,4967454,4967455,4967456,4967457,4967458,4967459,4967460,10961250,10961251,10961252,10961253,10961254,10961255,10961256,10961257,10961258,8064251,8064252,8064253,8064254,8064255,8064256,8064257,8064258,8064259,8064260,8064261,8064262,8064263,8064264,8064265,8064266,8064267,8064268,8064269,8064270,8064271,8064272,8064273,8064274,8064275,8064276,8064277,8064278,8064279,8064280,8064281,8064282,8064283,8064284,8064285,8064286,8064287,8064288,8064289,8064290,8064291,8064292,10944466,7069232,11047601,11047602,11047603,11047604,11047605,11047606,11047607,11047608,11047609,7069769,11049567,11049568,11049569,10617967,10617968,10617969,10617970,10617971,10617972,10968161,10619016,10619017,10920063,10920064,10617032,10617051,10917800,10917801,10917802,10917803,10917804,10918011,10918012,10918013,10619963,10920530,10915556,10915585,10915586,10615148,10615149,10615150,8570279,8570280,8570281,8570282,8570283,8570284,8570285,8570286,8570287,8570288,8570289,8570290,8570291,8570292,8570293,8570294,10930515,10620584,10620585,10620586,10620587,10620588,10620589,10620590,10965645,10965646,10965647,10965648,10965649,10965650,10965651,10965652,10965653,10965654,10965876,10965877,10965878,10926868,10953099,10953100,10953101,10953102,10953103,10953104,10953105,10953106,10953107,10953108,10953109,10953110,10953111,10953112,10953113,10953114,10953115,10953116,10953117,10953118,10953119,10953120,10953121,10953122,10953123,10953124,10616466,10953125,10616467,10953126,10616468,10953127,10953128,10953129,10953130,10953131,10953132,10953133,10953134,10953135,10953136,10953137,10953138,10953139,10953140,10953141,10953142,10953143,10953144,10953145,10953146,10953147,10953148,10953149,10953150,10917016,10616539,10559632,10562852,10562853,10562854,10562855,10562856,10562857,10562858,10562859,10562860,10562861,10562862,10562863,10562864,10562865,10562866,10562867,8864678,10611994,10557614,10557615,10557616,10612687,10612688,10612764,10612783,10612784,10612875,10609995,10609996,10609997,10609998,10613104,7058660,7058661,7058662,7058663,7058664,7058665,7058676,8863203,8863204,8863205,8863206,8863207,8863208,8863209,8863210,8863211,8863212,8863213,8863214,8863215,8863216,8863217,8863218,8863219,10558598,10610868,10513237,10513238,10513239,10513240,4974325,4974326,4974435,7056076,7056243,7056244,7056245,10513909,10513910,10513911,10513912,10514166,2809104,2809105,2809106,2809107,2809108,2809109,2809110,2809111,2809337,8861637,8861638,8861639,8861640,8861641,8861642,8861643,8861644,8861645,8861646,8861647,8861648,8861649,8861650,8861651,8861652,8861653,8861654,8861655,8861656,8861657,10519005,10519006,10519007,10519008,10519009,10519010,10519011,10519012,10519013,10519014,10519015,10519016,10519017,10519018,10519019,10519020,10519021,10515076,10515077,10416370,10416371,7054895,7054896,7054897,10418826,10416062,10418115,10417186,10462919,10462920,10462921,10462922,10462923,10462924,10462925,10462926,10462927,10462928,10462929,10462930,10462931,10462932,10462933,10462934,10462935,10462936,10462937,10462938,10462939,10462940,4971337,4971705,4971706,4971707,4971708,4971709,4971710,4971711,4971712,4971713,4971714,4971715,4971716,4971717,4971718,4971719,4971720,4971721,10469908,10469909,10468110,10629486,10629487,10629559,10629560,10629561,10632051,10632124,10153865,10154315,10154316,10154317,10154318,10154319,10154320,10154321,10154322,10154323,10154324,10154325,10154326,10154327,10154328,10154329,10154330,10154331,10154332,10154333,10154334,10154335,10154336,10154337,10154338,10154339,10154340,10154341,10154342,10154343,10154344,10154345,10154346,10154347,10154348,10154349,10154350,10154351,10154352,10154353,10154354,10154355,10154356,10154357,10154358,10154359,10154360,10154361,10154362,10154363,10154364,10154365,10154366,10154367,10154368,10154369,10154370,10154371,10154372,10154373,10154374,10154375,10154376,10154377,10154378,10154379,10154380,10154381,10154382,10154383,10154384,10626875,10568533,10568548,10568560,10568561,10568562,10568563,10568564,10568565,10568566,10568567,10568568,10568569,10568570,10568571,10568572,10568573,10568574,10568575,10568576,10568577,10568578,10568579,10568580,10568581,10568582,10568583,10568584,10568585,10568586,10568587,10568588,10568589,10568590,10568591,10568592,10568593,10568594,10568595,10568596,10568597,10568598,10568599,10568600,10568601,10568602,10568603,10568604,10568605,10568606,10568607,10568608,10568609,10568610,10568611,10568612,10568613,10568614,10568615,10568616,10568617,10568618,10568619,10568620,10568621,10568622,10568623,10568624,10568625,10568626,10568627,10568628,10568629,10568630,10568631,10568632,10568633,10568634,10568635,10568636,10568637,10568638,10568639,10568640,10568641,10568642,10568643,10568644,10568645,10568646,10568647,10568648,10568649,10568650,10568651,10568652,10568653,10568654,10568655,10568656,10568657,10568658,10568659,10568660,10568661,10568662,10568663,10568664,10568665,10568666,10568667,10568668,10568669,10568670,10568671,10568672,10568673,10568674,10568675,10568676,10568677,10568678,10568679,10568680,10568681,10568682,10568683,10568684,10568685,10568686,10568687,10568688,10568689,10568690,10568691,10568692,10568693,10568694,10568695,10568696,10568697,10568698,10568699,10568700,10568701,10568702,10568703,10568704,10568705,10568706,10568707,10568708,10568709,10568710,10568711,10568712,10568713,10568714,10568715,10568716,10568717,10568718,10568719,10568720,10568721,10568722,10568723,10568724,10568725,10568726,10568727,10568728,10568729,10568730,10568731,10568732,10568733,10568734,10568735,10568736,10568737,10568738,10568739,10568740,10568741,10568742,10568743,10568744,10568745,10568746,10568747,10568748,10568749,10568750,10568751,10568752,10568753,10568754,10568755,10568756,10568757,10568758,10568759,10568760,10568761,10568762,10568763,10568764,10568765,10568766,10568767,10568768,10568769,10568770,10568771,10568772,10568773,10568774,10568775,10568776,10568777,10568778,10568779,10568780,10568781,10568782,10568783,10568784,10568785,10568786,10568787,10568788,10568789,10568790,10568791,10568792,10568793,10568794,10568795,10568796,10568797,10568798,10568799,10568800,10568801,10568802,10568803,10568804,10568805,10568806,10568807,10568808,10568809,10568810,10568811,10568812,10568813,10568814,10568815,10568816,10568817,10568818,10568819,10568820,10568821,10568822,10568823,10568824,10568825,10568826,10568827,10568828,10568829,10568830,10568831,10568832,10568833,10568834,10568835,10568836,10568837,10568838,10568839,10568840,10568841,10568842,10568843,10568844,10568845,10568846,10568847,10568848,10568849,10568850,10568851,10568852,10568853,10568854,10568855,10568856,10568857,10568858,10568859,10568860,10568861,10568862,10568863,10568864,10568865,10568866,10568867,10568868,10568869,10568870,10568871,10568872,10568873,10568874,10568875,10568876,10568877,10568878,10568879,10568880,10568881,10568882,10568883,10568884,10568885,10568886,10568887,10568888,10568889,10568890,10568891,10568892,10568893,10568894,10568895,10568896,10568897,10568898,10568899,10568900,10568901,10568902,10568903,10568904,10568905,10568906,10568907,10568908,10568909,10568910,10568911,10568912,10568913,10568914,10568915,10568916,10568917,10568918,10568919,10568920,10568921,10568922,10568923,10568924,10568925,10568926,10568927,10568928,10568929,10568930,10568931,10568932,10568933,10568934,10568935,10520775,10520894,10520895,10521024,10521028,10420398,10420956,10473625) 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'