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 >= 1717333200
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 <= 1717333200 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, 100
|
|
Bird flu vaccines for laying hens prove effective in practice
Published: 28 May 24
Bird flu vaccines for laying hens are effective in practice, the Dutch government said on Tuesday, while confirming plans to vaccinate poultry against the virus that ravaged flocks around the world and is raising fears about human transmission. Highly pathogenic avian influenza, commonly called bird flu, has killed or caused the culling of hundreds of millions of poultry globally in recent years, most of them laying hens, which sent egg prices rocketing.
|
|
|
Johannesburg one of 3 cities to benefit from Suncasa project tackling climate threats
Published: 28 May 24
The Scaling Urban Nature-Based Solutions for Climate Adaptation in Sub-Saharan Africa (Suncasa), a new three-year project, will undertake watershed restoration and adaptation actions in Dire Dawa, Ethiopia; Kigali, Rwanda; and Johannesburg, South Africa. It is expected to reduce climate-fuelled flood risks and enhance the resilience of people in these three sub-Saharan African cities, while promoting gender equality and social inclusion and strengthening biodiversity protection.
|
|
Globe says Kanyika capital funding requirements finalised at $46m
Published: 28 May 24
Australia-listed Globe Metals and Mining has reported that capital funding requirements for Phase 1 project development at its Kanyika Niobium project, in Malawi, have been finalised at an estimated $46-million, inclusive of a 25% project contingency allocation. The company says the Phase 1 project development plan is confirmed with a clear path to project construction.
|
|
|
|