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 >= 1725755400
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 <= 1725755400 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
|
![An aerial view of the process plant, shaft headframe and site buildings at the Peak Mine.](https://cisp.cachefly.net//assets/articles/images/resized/0001111058_resized_goldcopperpeakmineaustraliaaureliaminerals.png) |
Peak mine, Australia
Published: 26 Jan 24
A gold/copper mine in Cobar, central west New South Wales, Australia
|
|
![An image of copper](https://cisp.cachefly.net//assets/articles/images/resized/0001106622_resized_naturalnativecopper1022.jpg) |
Cobre Panama mine, Panama
Published: 15 Dec 23
Cobre Panama is one of the largest new copper mines to open in the past decade, and the first large-scale operation to be built in Panama.
|
|
![An image of the Eloise copper mine](https://cisp.cachefly.net//assets/articles/images/resized/0001105464_resized_eloisemine1022.jpg) |
Eloise mine, Australia
Published: 08 Dec 23
The mine is located in north Queensland, in Australia, about 60 km south-east of Cloncurry and 155 km east-south-east of Mount Isa.
|
|
![A stock image of the periodic symbol for copper](https://cisp.cachefly.net//assets/articles/images/resized/0001100837_resized_copper21022.jpg) |
Caserones mine, Chile
Published: 17 Nov 23
The Caserones mine produces high-quality copper concentrate, copper cathode and molybdenum concentrate.
|
|
![An image of the Bibiani and Chirano processing operations](https://cisp.cachefly.net//assets/articles/images/resized/0001099427_resized_bibianiandchiranoasantegoldcorporation1022.jpg) |
Bibiani mine, Ghana
Published: 10 Nov 23
Bibiani is an historically significant gold mine in Ghana
|
|
|
|