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 >= 1652785200
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 <= 1652785200 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, 250
|
 |
Brewery Creek mine, Canada
Published: 25 Sep 20
Brewery Creek is a past-producing heap-leach gold mining operation.
|
Brewery Creek mine, Canada
|
 |
Balama mine, Mozambique
Published: 18 Sep 20
A vanadium mine in Cabo Delgado province, in Mozambique.
|
Balama mine, Mozambique
|
 |
Copper Mountain mine, Canada
Published: 04 Sep 20
A copper mine located about 20 km south of Princeton, in British Columbia.
|
Copper Mountain mine, Canada
|
 |
Wassa mine, Ghana
Published: 28 Aug 20
A gold mine located in the Wassa East district, in the Western region of Ghana.
|
Wassa mine, Ghana
|
 |
Prestea mine, Ghana
Published: 21 Aug 20
A gold mine located adjacent to the town of Prestea, in western Ghana.
|
Prestea mine, Ghana
|
 |
Mt Rawdon mine, Australia
Published: 14 Aug 20
A gold mine located 75 km south-west of Bundaberg, in Queensland, Australia.
|
Mt Rawdon mine, Australia
|
 |
Munali mine, Zambia
Published: 07 Aug 20
A nickel mine located 70 km south of Lusaka, in Southern Zambia.
|
Munali mine, Zambia
|
 |
Nathan River mine, Australia
Published: 24 Jul 20
A high-grade openpit iron-ore mine in Australia's Northern territory.
|
Nathan River mine, Australia
|
|
|