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 >= 1550458800
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 <= 1550458800 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, 250
|
Chemicals 2007
Published: 15 Mar 07
This report discusses the state of South Africa’s chemicals sector, and profiles the activities of key participants.
|
Chemicals 2007
|
Projects in Progress - Summary Report 2007 (First edition)
Published: 28 Feb 07
This report contains information on some of the largest industrial and mining projects being carried out across Africa. It includes details on the main contracts awarded, and contact information.
|
Projects in Progress - Summary Report 2007 (First edition)
|
Defence 2006
Published: 14 Nov 06
South Africa's defence-related industries face complex challenges
in operating in the global defence sector. This report provides
details on South Africa's defence-related industries.
|
Text, Introductions
|
Projects in Progress - Summary Report 2006 (Second edition)
Published: 30 Oct 06
This report contains information on some of the largest industrial
and mining projects being carried out across Africa. It includes
details on the main contracts awarded, and contact information.
|
Text, Introductions
|
Road 2006
Published: 09 Oct 06
Transport is a mainstay of the economy, and requires significant investment. This report provides a snapshot of South Africa’s road transport infrastructure.
|
Text, Introductions
|
Telecommunications 2006
Published: 01 Sep 06
South Africa's telecommunications market is
currently undergoing changes that will alter the way the industry operates. This report examines the state of the country's fixed-line and mobile sectors.
|
Text, Introductions
|
Rail 2006
Published: 31 Jul 06
This report examines the role of rail in the South African transport environment, highlighting changes currently taking place in the sector and the activities of major participants.
|
Text, Introductions
|
Automotive 2006
Published: 06 Jul 06
South Africa's broader automotive industry represents the
largest manufacturing sector in the country. This report examines the industry, looking at exports, imports and investment.
|
Text, Introductions
|
Electricity 2006
Published: 31 May 06
This report outlines the current
status of South Africa's electricity sector, and provides some
insight into its future structure and functioning.
|
Text, Introductions
|
Liquid Fuels 2006
Published: 16 May 06
This report examines the liquid fuels industry, with particular
emphasis on the industry in South Africa.
|
Text, Introductions
|
|
|