|
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 >= 1537894800
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 = 43 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 <= 1537894800 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
|
 |
Cerro Verde mine, Peru
Published: 22 Sep 17
A copper mine about 32 km south-west of Arequipa, Peru.
|
Cerro Verde mine, Peru
|
 |
Chino mine, US
Published: 15 Sep 17
A copper/molybdenum mine located in Grant County, New Mexico, in the US.
|
Chino mine, US
|
 |
Safford mine, US
Published: 08 Sep 17
A copper mine in south-east Arizona, in the US.
|
Safford mine, US
|
 |
Cigar Lake mine, Canada
Published: 01 Sep 17
A uranium mine located in the Athabasca basin, north of Saskatchewan, in Canada.
|
Cigar Lake mine, Canada
|
 |
Inkai mine, Kazakhstan
Published: 25 Aug 17
A uranium mine in the Suzak district of South Kazakhstan Oblast.
|
Inkai Mine
|
 |
Fazenda Brasileiro mine, Brazil
Published: 11 Aug 17
A gold mine located in Bahia state in Brazil, about 180 km north-west of the state capital Salvador.
|
Fazenda Brasileiro mine, Brazil
|
 |
Caeté mining complex, Brazil
Published: 04 Aug 17
A gold mining complex in the state of Minas Gerais, Brazil, 50 km east of Belo Horizonte.
|
Caeté mining complex, Brazil
|
 |
Santa Luz mine, Brazil
Published: 28 Jul 17
A gold mine located in the Maria Preta mining district, 35 km north of Santa Luz, in Bahia state, Brazil.
|
Santa Luz mine, Brazil
|
 |
Pilar mine
Published: 21 Jul 17
A gold mine located in the state of Goiás in central region of Brazil.
|
Pilar mine, Brazil
|
|
|
Africa Mining Projects in Progress 2018 - Second Edition (PDF Report)
Buy Report
Platinum 2018: A review of South Africa's platinum sector (PDF Report)
Buy Report
Real Economy Insight 2018 - Platinum (PDF Report)
Buy Report
Real Economy Insight 2018 - Iron-Ore (PDF Report)
Buy Report
Real Economy Insight 2018 - Gold (PDF Report)
Buy Report
Real Economy Insight 2018 - Coal (PDF Report)
Buy Report
