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 >= 1716129000
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 <= 1716129000 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
|
|
Anglo American has sought fertiliser partners for months, says CEO
Published: 17 May 24
Anglo American has been looking for partners for its fertiliser project in North Yorkshire for around six months, CE Duncan Wanblad told Reuters, reiterating the business will be one of three pillars of the revamped miner, even as work there stalls. The London-listed miner outlined a radical plan on Tuesday to shrink by divesting less profitable coal, nickel, diamond and platinum businesses, as it moves to fend off BHP Group's $43-billion takeover offer.
|
|
|
Chile's Cochilco raises 2024, 2025 copper price estimates
Published: 17 May 24
The Chilean Copper Commission (Cochilco) on Thursday raised its average copper price estimates for both this year and next. Cochilco now sees average copper prices this year at $4.30/lb, from $3.85/lb before. For next year, Cochilco estimates average copper prices around $4.25/lb, up from $3.90/lb before.
|
|
|
Central lime project, Papua New Guinea
Published: 17 May 24
The project will be Asia Pacific’s first carbon-neutral quicklime, clinker and cement project for supply to Papua New Guinea, Australia and the South Pacific at a much lower cost than that of Asian exporters.
|
|
|
|