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 >= 1716611400
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 <= 1716611400 AND ase_s_id IN (14889,14891,14892,14893,14894,14895,15673,14896,14897,14898,14899,14900,13929,13778,16683,13779,13828,13945,15252,13781,13783,13784,13785,13959,13960,13961,13962,13963,13964,13958,13966,13965,13967,13969,13968,13970,13971,13972,13973,16686,16685,16690,16688,16691,16692,16687,13974,13975,13976,13977,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, 100
|
|
Project Nour, Mauritania
Published: 24 May 24
Project Nour could become one of the biggest green hydrogen projects globally.
|
|
|
Umoyilanga hybrid power plant, South Africa
Published: 24 May 24
EDF Renewables and Perpetua Holdings plan to build a hybrid development that combines solar, wind and battery storage technologies to offer dispatchable and reliable power to the national electricity grid.
|
|
|
Vaal Water Lettuce invasion signifies need to weed out water pollution
Published: 24 May 24
The Vaal Barrage is now home to an invasive plant species that has had significant negative economic and environmental consequences for the region, and its rapid spread will not slow down without intervention. This has left the Department of Water and Sanitation (DWS), Rand Water and local communities, besides others, scrambling to get the species under control and mitigate the damage it is causing.
|
|
|
|