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 >= 1719729000
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 <= 1719729000 AND ase_s_id IN (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
|
|
Construction – Midyear Review 2023
Published: 18 Oct 23
The Construction – Midyear Review 2023 is a three-page synopsis of key developments in the construction sector over the past 12 months, which is yet to recover to pre-Covid-19 pandemic levels of output.
|
|
|
Pumps – Midyear Brief 2023
Published: 18 Oct 23
The Pumps – Midyear Brief 2023 is a three-page synopsis of key developments in the pumps market over the past 12 months, which has been on a growth trajectory for years, with the trend expected to continue.
|
|
|
Manufacturing – Midyear Brief 2023
Published: 18 Oct 23
The Manufacturing – Midyear Brief 2023 is a three-page synopsis of key developments in the global manufacturing sector over the past 12 months, which continues to surpass the performance of previous years and exceed expectations.
|
|
|
Steel – Midyear Brief 2023
Published: 18 Oct 23
The Steel – Midyear Review 2023 is a three-page synopsis of key developments in South Africa’s steel sector over the past 12 months, which finds itself under great pressure, owing to a prolonged period of economic decline, among other concerns.
|
|
|
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.
|
|
|
|