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 >= 1550700000
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 <= 1550700000 AND ase_s_id IN (13786,13947,13787,13788,13789,13790,13791,13792,13793,13946,13979,13980,13981,13982,13983,13984,13978,13986,13985,13987,13989,13988,13990,13991,13992,13993,13994,13995,13996,13997,13777,13831,13778,13779,13828,13945,15252,13929,13781,13782,13783,13784,13785,13959,13960,13961,13962,13963,13964,13958,13966,13965,13967,13969,13968,13970,13971,13972,13973,13974,13975,13976,13977) GROUP BY a_id ORDER BY a_publish_date DESC LIMIT 0, 250
|
 |
Mt Keith satellite project, Australia
Published: 15 Feb 19
The project proposes to develop a nickel mine as a satellite operation to the Mt Keith mine.
|
Mt Keith satellite project, Australia
|
 |
Lake Wells sulphate of potash project, Australia
Published: 15 Feb 19
Australia Potash Limited will raise up to A$5.2-million through a renounceable rights issue to complete a definitive feasibility study on the project.
|
Lake Wells sulphate of potash project, Australia
|
 |
Sconi cobalt/nickel/scandium project, Australia
Published: 15 Feb 19
An independent nickel and cobalt sulphate market study has flagged the planned Sconi project as one of the most competitive producers in the world, once operational.
|
Sconi cobalt/nickel/scandium project, Australia
|
 |
North Carolina highway projects, US
Published: 15 Feb 19
The North Carolina Department of Transportation has awarded two contracts for the projects.
|
North Carolina highway projects, US
|
 |
Atlantis Phase 3 expansion, Mexico
Published: 15 Feb 19
Atlantis Phase 3 will include the construction of a new subsea production system.
|
Atlantis Phase 3 expansion, Mexico
|
|
|