SELECT a_id, a_id_word, a_headline, a_publish_date, a_abstract, a_author, a_has_video, a_has_audio FROM su_cat_sg_mappings, re_categories , re_category_sections_assoc , pr_sections , pr_article_section_assoc , pr_articles_search, pr_article_media_assoc WHERE csg_sg_id = 1 AND csg_cat_id = cat_id AND a_status = 1
AND a_process_status = 4 AND a_expiry_date >= 1714611600
AND cat_id = scat_cat_id AND scat_s_id = s_id AND s_id = ase_s_id AND ase_a_id = a_id
AND cat_re_id = 42 AND ama_a_id = a_id AND ama_mt_id = 2 AND ama_p_id = ase_p_id AND s_id NOT IN (14903,14910,14911,14906,14904,14912,14909,14908,14907,14905) AND a_publish_date <= 1714611600 AND ase_s_id IN (14576,15076,14885,15075,14270,14271,14272,14886,14274,14273,14888,15674,14887,13947,13786,13787,13788,13789,13790,13792,13793,13946,13979,13980,13981,13982,13983,13984,13978,13986,13985,13987,13989,13988,13990,13991,13992,13993,16694,16693,16696,16695,16697,16698,16699,13994,13995,13996,13997,13206,13207,13208,13209,13210,13211,14520,13212,13213,13832,13214,13215,13216,13217,13218,13219,14182,13220,13221,14501,13222,13223,14674,14186,14436,13224,13225,13226,13227,13228,13229,14519,14485,13230,14484,14878,14183,13350,570,559,564,558,566,556,571,560,565,555,569,562,568,561,567,557,572,563) GROUP BY a_id ORDER BY a_publish_date DESC LIMIT 0, 100
|
|
Amapá iron-ore project, Brazil
Published: 26 Apr 24
A capital expenditure optimisation study has resulted in a forecast increase in production of about 4.8%.
|
|
|
BHP’s mega bid for Anglo sets stage for industry shakeup
Published: 25 Apr 24
Australia-headquartered BHP has made a bold move with its bid to acquire rival Anglo American in an all-share deal valued at $38.8-billion. With this manoeuvre, BHP aims to create the largest copper miner globally, but it could face scrutiny from Anglo shareholders over valuation concerns.
Commenting on the proposed deal, Wood Mackenzie mining and metals corporate research director James Whiteside remarked that the transaction would represent the biggest shakeup of the global mining industry in more than a decade.
|
|
|
|