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 >= 1720137600
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 <= 1720137600 AND ase_s_id IN (14576,15076,14885,15075,14270,14271,14272,14886,14274,14273,14888,15674,14887,14889,14891,14892,14893,14894,14895,15673,14896,14897,14898,14899,14900) GROUP BY a_id ORDER BY a_publish_date DESC LIMIT 0, 100
|
|
Roads, Rail & Ports – Midyear Brief 2023
Published: 18 Oct 23
The Roads, Rail & Ports – Midyear Brief 2023 is a three-page synopsis of key developments in South Africa’s roads, rail and ports sector over the past 12 months. It examines the increasing concerns about the performance of the sector, and its potential to unlock crucial economic activity.
|
|
|
Agriculture 2023 – Midyear Brief 2023
Published: 18 Oct 23
The Agriculture – Midyear Brief 2023 is a two-page synopsis of key developments in the agriculture sector over the past 12 months. It focuses on current food price inflation in South Africa, as well as trade and investment relations with South Africa’s Western counterparts.
|
|
|
Automotive – Midyear Brief 2023
Published: 17 Oct 23
The Automotive Midyear Brief is a two-page synopsis of key developments in the automotive sector over the past 12 months. It provides an overview of the promising future of electric vehicles and South Africa’s role in that future.
|
|
|
Water 2023: South Africa’s looming crisis
Published: 06 Oct 23
Without significant changes in how water is managed, South Africa’s forecasted water deficit of 1.60-billion to 2.70-billion cubic metres by 2030 will continue increasing, impacting on investment, job creation and economic growth.
The National Infrastructure Plan 2050, published in March 2022, warns that addressing South Africa’s water management challenges will get ever-more challenging owing to growing water demand driven by economic growth, urbanisation and rising standards of living, suggesting a need to broaden South Africa’s water mix.
Creamer Media’s ‘Water 2023: South Africa’s looming crisis’ report considers these challenges in the context of the global state of water resources, focusing on the country’s water regulations, policies and planning. It examines some of the country’s most pressing issues, including supply and demand; the Blue, Green and No Drop reports, which monitor wastewater quality, drinking water quality and the status of water losses and nonrevenue water respectively; and the failure of local water services. The report also considers the financial health of the water sector and the impacts thereof. The report also looks at some of the water and sanitation projects that are under way that might help deal with South Africa’s dire water situation.
|
|
|
|