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 >= 1550368800
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 <= 1550368800 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
|
 |
Joel mine, South Africa
Published: 16 Feb 18
A gold mine located in the Free State, on the south-western edge of the Witwatersrand basin, about 290 km from Johannesburg.
|
Joel mine, South Africa
|
 |
Doornkop mine, South Africa
Published: 09 Feb 18
A gold mine located about 30 km west of Johannesburg, on the northern rim of the Witwatersrand basin.
|
Doornkop mine, South Africa
|
 |
Target 1 mine, South Africa
Published: 02 Feb 18
A gold mine located near Allanridge in the Free State, about 270 km south-west of Johannesburg.
|
Target 1 mine, South Africa
|
 |
Bambanani mine, South Africa
Published: 26 Jan 18
A gold mine located 10 km south-east of Welkom, in the Free State.
|
Bambanani mine, South Africa
|
 |
Tshepong operations, South Africa
Published: 19 Jan 18
An operation mining gold and by-products of silver and uranium near Welkom in the Free State, South Africa, about 248 km from Johannesburg.
|
Tshepong operations, South Africa
|
 |
Tantahuatay mine, Peru
Published: 15 Dec 17
A gold and silver mine located in the districts of Hualgayoc and Chugur, in Cajamarca, Peru.
|
Tantahuatay mine, Peru
|
 |
Galena Complex, US
Published: 08 Dec 17
A silver/copper/lead/zinc mine in Shoshone County, Idaho.
|
Galena Complex, US
|
 |
Orcopampa mine, Peru
Published: 01 Dec 17
A gold and silver mine located in the Castilla mining district of Peru.
|
Orcopampa mine, Peru
|
 |
Bagdad mine, US
Published: 24 Nov 17
A copper and molybdenum mine in Arizona, in the US.
|
Bagdad mine, US
|
 |
Reefton mine, New Zealand
Published: 17 Nov 17
A gold mine located about 7 km south-east of Reefton, in the West Coast region of New Zealand’s South Island.
|
Reefton mine, New Zealand
|
|
|