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 >= 1656748800
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 <= 1656748800 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
|
 |
Kristineberg mine, Sweden
Published: 13 Aug 21
A copper/zinc mine in Skellefteå Municipality, Västerbotten County, Sweden.
|
Kristineberg mine, Sweden
|
 |
Tritton Copper Operations, Australia
Published: 06 Aug 21
A copper mine located near the town of Nyngan, in central New South Wales, Australia.
|
Tritton Copper Operations, copper, Australia
|
 |
Garpenberg mine, Sweden
Published: 30 Jul 21
A polymetallic mine in Hedemora municipality, Sweden.
|
Garpenberg mine, Sweden
|
 |
Relief Canyon mine, US
Published: 23 Jul 21
A gold mine in Nevada, in the US.
|
Relief Canyon, mine, US, Americas Gold and Silver
|
 |
Modikwa mine, South Africa
Published: 02 Jul 21
A platinum group metals mine along the border between South Africa’s Mpumalanga and Limpopo provinces.
|
Modikwa mine, South Africa
|
 |
Skaland Operation, Norway
Published: 25 Jun 21
A granite mine in northern Norway on the Island of Senja.
|
Skaland Operation, Norway
|
|
|