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 >= 1725757200
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 <= 1725757200 AND ase_s_id IN (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
|
![Image of galena/lead](https://cisp.cachefly.net//assets/articles/images/resized/0001081252_resized_galena.jpeg) |
Abra mine, Australia
Published: 18 Aug 23
A lead/silver mine in the Edmund basin in the Gascoyne region of Western Australia.
|
|
![Image of river nuggets](https://cisp.cachefly.net//assets/articles/images/resized/0001074214_resized_rivergoldnuggetscopy.jpg) |
Singida mine, Tanzania
Published: 21 Jul 23
A gold mine in the Ikungi administrative district of the Singida region, central Tanzania.
|
|
![Imnage of Boron mine](https://cisp.cachefly.net//assets/articles/images/resized/0001074218_resized_boratesboronmineusaerialriotinto2023copy.jpg) |
Boron mine, US
Published: 14 Jul 23
A multimineral mine in the US state of California.
|
|
![Aerial view of Yaramoko mine, in Burkina Faso](https://cisp.cachefly.net//assets/articles/images/resized/0001071180_resized_goldyaramokominebagassisouthfortunasilver2023.jpg) |
Yaramoko mine, Burkina Faso
Published: 07 Jul 23
A gold mine in the Houndé greenstone belt region, in Balé, in south-western Burkina Faso.
|
|
![Imge of the Caijiaying mine, in China](https://cisp.cachefly.net//assets/articles/images/resized/0001069698_resized_caijiayingminechina.jpeg) |
Caijiaying mine, China
Published: 23 Jun 23
A zinc/lead/silver/gold mine in the north-west of Beijing in Hebei province, China.
|
|
|
|