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 >= 1725759000
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 <= 1725759000 AND ase_s_id IN (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) GROUP BY a_id ORDER BY a_publish_date DESC LIMIT 0, 100
|
![Image of drill core from the Jadar project](https://cisp.cachefly.net//assets/articles/images/resized/0001150019_resized_lithiumjadarjadariteserbiariotinto082021copy.jpg) |
Jadar lithium-borates project, Serbia – update
Published: 16 Aug 24
Environmental activists and opposition groups are set to gather in the centre of Serbia’s capital on August 17 to demand a halt to the Rio Tinto-proposed Jadar mine.
|
|
![Image of emerald gemstone](https://cisp.cachefly.net//assets/articles/images/resized/0001149929_resized_emeraldgemstonecopy.jpg) |
Gravelotte emerald mine, South Africa
Published: 16 Aug 24
An independent desk-based review of the discounted cash flow model for the project has highlighted its potential profitability over a 17-year mine life.
|
|
|
|