Everything Mining Industry Country Focus How to Guide
Limit search to:
Start Date   
End Date   
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 >= 1623843900 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 <= 1623843900 AND ase_s_id IN (13206,13207,13208,13209,13210,13211,14520,13212,13213,13832,13214,13215,13216,13217,13218,13219,14182,13220,13221,14501,13222,13223,14674,14186,14436,13224,13225,13226,13227,13228,13229,14519,14485,13230,14484,14878,14183,13350,13144,14299,13177,14298,13145,13147,14184,13146,13149,14301,13150,13153,14275,13151,13152,13148,14302,14304,14303,14305,13154,13155,13156,13157,13158,13159,13160,13161,14309,13162,13171,13163,13164,13165,13166,13167,13168,14300,13169,13170,13172,13173,13174,13175,14307,14276,14308,14310,13176,13188,13189,13190,13191,14187,13194,13196,13197,13195,13198,13200,13201,13202,14306,13203,13204,13205) GROUP BY a_id ORDER BY a_publish_date DESC LIMIT 0, 250
Unfortunately no search results have been found.
Please try another search or reduce the amount of search filters.

Latest content...

Register for daily alerts on news as it breaks in various key economic sectors - Click here to register