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(7075868,10198199,10198200,10198214,7076010,7076011,8837047,7074307,8837371,8837376,10199613,10199614,10251770,10251771,10251772,10251775,10251776,10251777,10251778,10251779,10251780,10251781,10251782,10251783,10251784,10251785,10251786,10251787,10251788,10251789,10251790,10251791,10251792,10251793,10251794,10251795,10251796,10251797,10251798,10251799,10251800,10251801,10251802,10251803,10251804,10251805,10199805,10199806,10251806,10251807,10251808,10251809,10251810,10251811,10251812,10251813,10251814,10251815,10251816,10251817,10251818,10251819,10251820,10251821,10251822,10251823,10251824,10251825,10251826,10251827,10251828,10251829,10251837,7066613,7066614,7066615,7066623,7066627,7066628,7066629,7066725,7066910,10197191,10197196,10197197,10197199,10197202,10249658,10249661,10249662,8835524,10223806,10223807,10223808,10223809,10223810,10223823,10223916,10234256,10222216,10222233,10222234,7073125,7065782,8970233,8970234,10231181,7069414,8860410,10624658,10620270,10620271,8570279,8570280,8570281,8570282,8570283,8570284,8570285,8570286,8570287,8570288,8570289,8570290,8570291,8570292,8570293,8570294,10930649,9181414,10565249,9173555,9173563,9173567,8864543,6666166,6666167,9171777,8862470,10561087,10561088,10561089,10561090,10561091,10561092,10561093,7058455,7058657,7058658,7058659,7058660,7058661,7058662,7058663,7058664,7058665,10613312,10613313,10613314,10613315,9172912,9172913,9172914,9172915,9188961,9188962,9188963,9188964,9188965,9188966,9188967,4974193,4974247,4974310,4974311,4974334,10513630,10513659,9169943,10512030,10512031,10512032,10514094,10514412,10514413,10514414,10514415,10514416,10514447,10512663,10512664,10512665,10512666,10512667,10512668,10512669,10512670,10512671,10512672,10512673,10512674,10512675,7057087,7057088,9171049,9171052,7057239,10516987,10516988,10516989,10516990,10516991,10516992,10516993,10419296,10419298,9168512,10416514,10416515,10416516,10416518,10416519,10416520,10417576,4973954,10419180,4974120,4974121,4974149,6666463,9198589,9198590,6666629,8865200,9166807,9190858,9190859,9167178,9167179,6667599,9175795,9199913,9199916,9199917,9199918,9199919,9199921,9199922,9199923,9199924,9199925,9199926,9199927,9199928,9199929,9199930,9199931,9199932,9199933,9199934,9199935,9199936,9199937,9199938,9199939,9199940,9199941,9199942,9199943,9199944,9199945,9199946,9199947,9199948,9199949,9199950,9199951,9199952,9199953,9199954,9199955,9199956,9199957,9199958,9199959,9199960,9199961,9199962,9199963,9199964,9199965,9199966,9199967,9199968,9199969,9199970,9199971,9199972,9199973,9199974,9199975,9199976,9199977,9199978,9199979,9199980,9199981,9199982,9199983,9199984,9199985,9199986,9199987,9199988,9199989,9199990,9199991,9199992,9199993,9199994,9199995,9199996,9199997,9199998,9199999,9200000,9200001,9200002,9200003,9200004,9200005,9200006,9200007,9200008,9200009,9200010,9200011,9200012,9200013,9200014,9200015,9200016,9200017,9200018,9200019,9200020,9200021,9200022,9200023,9200024,9200025,9200026,9200027,9200028,9200029,9200030,9200031,9200032,9200033,9200034,9200035,9200036,9200037,9200038,9200039,9200040,9200041,9200042,9200043,9200044,9200045,9200046,9200047,9200048,9200049,9200050,9200051,9200052,9200053,9200054,9200055,9200056,9200057,9200058,9200059,9200060,9200061,9200062,9200063,9200064,9200065,9200066,9200067,9200068,9200069,9200070,9200071,9200072,9200073,9200074,9200075,9200076,9200077,9200078,9200079,9200080,9200081,9200082,9200083,9200084,9200085,9200086,9200087,9200088,9200089,9200090,9200091,9200092,9200093,9200094,9200095,9200096,9200097,9200098,9200099,9200100,9200101,9200102,9200103,9200104,9200105,9200106,9200107,6668105,9200108,6668106,9200109,9200110,9200111,9200112,9200113,9200114,9200115,9200116,9200117,9200118,9200119,9200120,9200121,9200122,9200123,9200124,9200125,9200126,9200127,9200128,9200129,9200130,9200131,9184131,9200132,9184132,9200133,9184133,9200134,9184134,9200135,9184135,9200136,9184136,9200137,9200138,9200139,9200140,9200141,9200142,9200143,9200144,9200145,9200146,9200147,9200148,9200149,9200150,9200151,9200152,9200153,9200154,9200155,9200156,9200157,9200158,9200159,9200160,9200161,9200162,9200163,9200164,9200165,9200166,9200167,9200168,9200169,9200170,9200171,9200172,9200173,9200174,9200175,9200176,9200177,9200178,9200179,9200180,9200181,9200182,9200183,9200184,9200185,9200186,9200187,9200188,9200189,9200190,9200191,9200192,9200193,9200194,9200195,9200196,9200197,9200198,9200199,9200200,9200201,9200202,9200203,9200204,9200205,9200206,9200207,9200208,9200209,9200210,9200211,9200212,9200213,9200214,9200215,9200216,9200217,9200218,9200219,9200220,9200221,9200222,9200223,9200224,9200225,9200226,9200227,9200228,9200229,9200230,9200231,9200232,9200233,9200234,9200235,9200236,9200237,9200238,9200239,9200240,9200241,9200242,9200243,10175937,10629472,10629473,10629474,10629475,10629476,10629477,10629478,10629479,10629480,10629481,10629482,10629483,10629486,10629487,10173872,10172283,10177302,10626158,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,10582471,10582472,10582473,10582474,10582475,10522134,10528628,10530647,10530648,10530649,10530650,10530752,10530753,10524761,10524762,10524763,10524764,10524765,10524766,10524767,10524768,10524769,10423586,10423587,10477377,10486484,10486485,10486486) 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'