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(10447845,10447959,10447967,10447989,8574297,10447999,10448006,8574348,8574352,8574357,8838687,8574393,8574403,8574404,8838740,8574501,8574502,8574503,8574504,8574505,8574506,8574535,8574562,8574586,7068762,10940407,10940408,10940409,8569797,8569802,8569803,7068839,7068840,7068841,8569820,7068864,8569842,8569843,8569844,8569845,8569846,8569847,8569848,8569849,10976578,10976579,10950566,7065951,7074115,7074131,8067649,8609677,10497735,10497736,10497737,8068000,8068031,8068077,8068078,8068079,8068102,8068103,8068104,8068105,8068148,8068149,8068150,8068151,8068152,8068153,8068202,8068203,8068256,8068257,8068258,8068274,8068275,8068276,8068321,8068322,8068323,8068324,8068375,8068376,8068377,8068378,8068402,8068403,8068440,8068441,8068528,8838199,8068618,8068626,8068669,8068670,8838409,8835444,8835447,8835455,8835460,8835462,10985824,10985835,10985836,10985837,8911304,7072395,7072396,7072409,7072421,10931772,7072580,7072581,7072615,7073003,7073071,7073072,8836677,8066192,8066205,8066217,8066257,8066258,8066259,8066305,8066316,8066331,8066332,8066333,8066354,8066355,8066356,8066407,8066408,8066424,8066425,8066613,8066614,8066672,8066730,4968060,11049106,7071325,7071710,10998404,8970235,8835351,7068986,7069005,7069006,3656272,8564781,10996761,8564787,8564795,8564808,8909176,3656723,3656724,8909300,8909318,8909557,8909558,8909571,8909572,10942328,8909767,8909776,10942427,8909926,8909928,8909929,8909940,7070925,7070926,7070927,7070928,10923660,8906182,10923661,10923662,10923663,10923664,10923665,10923755,10923756,10923757,10923758,8906358,10923837,10923838,10923839,8906373,10923896,10923897,10923898,10918911,10918912,10918913,10923981,10923982,10924068,10924069,10924288,10919614,10919615,10919616,10919617,10924668,10924893,10924894,10924895,10924896,10924897,10924898,10924899,10925010,10925011,8907761,8907762,8907763,8907764,8907765,10925271,10925272,10925273,10925274,8907796,10925275,10925276,8907896,8907897,8907898,8907899,8907900,8907901,8907902,8907903,8907904,8907905,8907906,8907907,8907908,8907909,8907910,8907911,10918157,11006522,10622888,10622900,10920566,10620071,10920617,10920618,10920656,10615238,8570198,10920771,10920921,10920922,10920923,10920924,10920992,10920993,10920994,10921085,10921087,10921088,10921089,10921090,10921091,10921264,10930754,10930755,10615874,10620875,10620876,10621074,10621075,10621118,10921640,10921762,10621268,10621278,10621297,10621336,10621362,10979062,10979067,10621411,10621449,10621455,10621656,10621657,10621690,9205921,9205922,9190016,8864813,8864817,9203323,9195447,9203489,9203490,9203491,9203492,9203493,9203494,9195499,9195500,9203515,9195557,9195558,9195559,9187626,9187627,9195641,9195642,9195643,9195644,9195645,9203681,9195716,9195717,9187723,9203757,9195782,9195783,9195784,9195785,9195786,9195787,9195788,9187800,9187810,7057993,9203831,9203832,9187906,9187988,9187989,9187991,9187992,9187993,7058183,9204021,9204124,9188127,9188130,9204265,9204266,9188267,9204302,9204325,9204326,9204349,9204364,9204430,9204435,9204527,9204556,7058726,9204597,10613351,8863297,8863340,8863341,8863342,8863355,8863356,8863357,8863358,8863374,8863379,8863380,8863387,8863388,8863402,8863403,8863420,8863428,8863429,8863430,10613622,8863497,8863498,8863517,8863534,8863535,8863536,8863537,8863538,9193392,9193398,9193451,9177506,9161595,10555476,10555477,10555478,10555479,10555480,10555481,10555482,10555483,10555484,10555485,9177701,10555526,10555527,10555528,10555529,10555530,10555531,10555532,10555533,10555534,4974627,9193779,9194124,9194125,9194126,9202130,7056474,9178311,9194352,9194353,9194354,9194355,9202427,9202435,9194493,9194494,9194495,10556322,9202588,9202589,9202590,9202591,9202608,9202609,9202610,9202611,9202612,9194633,10556460,10556461,10556562,10556563,9194773,2809401,9202860,9202861,9202862,9194879,9194880,9194881,9194882,10556741,10556742,10556743,9195114,9195115,9195128,9195129,9195130,9203153,10557073,10557074,10557075,10557076,10557077,10557078,10557079,10557080,10557081,10557082,10557083,10557084,10557085,10557086,10557087,10557088,10557089,10557090,10557091,10557092,10557093,10557094,10557095,10557096,9195288,10416232,9192548,9192581,10417546,9192677,9192691,9192818,9168830,9168831,9200838,10417762,10417767,10417776,10417783,9192878,9192906,9192947,9192948,9192949,9192950,9192993,9193011,9193065,9193081,10417116,10417124,10418125,10418132,10418136,8864836,9206410,9206513,9206544,9206569,9206585,6666960,4971938,4971939,4971941,4971949,4971959,4971965,4971975,4971978,4971980,4971983,4971984,4971985,4971986,4971988,4971998,4971999,4972019,10463768,10463769,10463770,10463771,10463772,4972048,10463773,10463774,10463775,10463776,10463777,10463778,10463779,10463780,10463781,10463782,10463783,10463784,10463785,10463786,10463787,10463788,10463789,10463790,6667212,10463791,6667213,10463792,10463793,10463794,10463795,10463796,10463797,10463798,10463799,10463800,10463801,10463802,10463803,10463804,10463805,10463806,10463807,10463808,10463809,10463810,10463811,10463812,10463813,10463814,10463815,10463816,10463817,10463818,10463819,10463820,10463821,10463822,10463823,10463824,10463825,10463826,10463827,10463828,10463829,10463830,10463831,10463832,10463833,4972127,4972245,8917198,10470286,10470349,10470390,10470394,9167869,10470499,10470500,10470510,10470511,10470597,10470600,10470601,9200050,9200234,9200235,9200236,10174487,10174533,10169535,10628024,10628025,10174828,10169874,10179965,10179991,10180148,10180149,10180150,10180151,10180178,10180179,10180180,10180181,10180551,10180552,10180553,10180582,10180583,10180937,10180938,10180960,10180961,10186193,10186194,10186195,10629689,10629697,10629880,10168498,10168527,10632018,10168593,10168594,10168595,10168612,10168613,10168614,10183622,10183623,10183624,10183646,10183647,10183648,10183649,10168689,10183750,10183752,10627282,10183814,10153853,10168916,10168957,10173996,10173997,10173998,10168998,10173999,10174000,10174003,10169074,10169075,10169076,10169077,10169078,10169079,10169150,10169151,10169152,10169153,10169154,10169155,10169156,10169157,10169158,10169159,10169283,10169284,10169285,10174451,10174452,10181486,10181487,10181488,10186732,10186802,10630353,10630354,10630355,10630364,10186901,10630384,10630385,10630386,10181968,10181969,10182042,10182055,10630621,10182208,10182209,10182220,10630726,10177321,10172345,10172349,10182371,10182381,10177404,10177420,10177421,10182476,10182482,10631006,10631010,10631011,10167661,10167662,10167666,10167667,10167668,10167669,10167670,10167682,10167683,10167684,10167685,10167695,10167732,10167733,10167734,10167735,10167736,10167737,10167783,10182803,10167808,10167809,10167810,10167811,10167812,10167813,10172870,10167871,10172872,10167872,10167873,10167874,10167895,10167896,10167897,10167898,10167899,10167925,10167926,10167946,10167947,10167948,10182990,10167990,10182997,10168017,10626536,10168066,10168067,10168068,10183074,10183079,10168097,10168113,10183140,10183149,10168152,10168181,10168191,10183251,10183252,10168310,10168314,10183322,10183323,10168326,10168332,10168343,10168344,10168345,10168346,10168347,10168348,10168349,10168350,10168351,10168372,10168373,10168384,10168397,10168398,10168458,10168459,10183461,10183470,10577113,10577114,10577115,10577116,10577117,10577118,10577119,10577120,10577121,10577495,10577496,10577497,10568669,10568670,10568671,10568672,10568673,10574727,10574782,10571877,10577911,10577912,10581065,10581066,10578071,10578072,10578086,10578087,10578088,10578089,10578090,10578211,10578212,10578213,10578214,10578215,10578216,10578311,10572312,10578312,10572313,10578313,10578396,10578452,10578453,10578454,10575564,10575565,10578570,10578571,10578572,10581617,10581642,10581643,10581644,10581665,10575687,10575688,10575689,10581694,10581698,10581699,10581705,10581706,10581707,10569742,10569743,10569744,10581761,10578792,10569909,10579100,10576180,10576181,10576562,10576721,10576722,10576733,10576734,10576735,10576736,10576737,10576738,10576739,10576740,10576741,10576742,10576743,10576744,10576745,10576746,10576747,10576748,10523246,10535419,10535420,10535421,10523672,10523696,10523702,10523703,10536044,10536412,10534654,10534655,10536662,10528674,10528675,10528676,10524883,10534934,10534935,10422987,10487934,10488016,10479211,10479212,10479213,10479214,10479396,10479397,10479398,10479399,10479400,10479401,10479495,10479496,10479497,10479498,10479532,10479560,10479561,10479565,10479566,10479574,10479660,10479756,10479757,10479758,10479773,10479822,10479823,10479824,10479825,10479826,10479827,10479828,10479829,10479830,10479898,10479936,10479937,10479938,10480371,10480372,10487560,10487588,10487612,10487613,10487614,10487685,10487734) 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'