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 >= 1719801000
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 <= 1719801000 AND ase_s_id IN (14576,15076,14885,15075,14270,14271,14272,14886,14274,14273,14888,15674,14887,13947,13786,13787,13788,13789,13790,13792,13793,13946,13979,13980,13981,13982,13983,13984,13978,13986,13985,13987,13989,13988,13990,13991,13992,13993,16694,16693,16696,16695,16697,16698,16699,13994,13995,13996,13997,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,570,559,564,558,566,556,571,560,565,555,569,562,568,561,567,557,572,563,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
|
Cape Town calls for private-sector intervention as port ranks worst in the world
Published: 28 Jun 24
According to the newly published World Bank Container Port Performance Index, compiled from 2023 data, the Port of Cape Town is the worst performing port in the world. It is joined in the bottom 16 of the 405-strong list of container ports by Durban, Ngqura and Port Elizabeth (Transnet still refers to the port by this name).
|
|
|
Event to highlight key African projects
Published: 28 Jun 24
The upcoming African Energy Week (AEW): Invest in African Energy 2024 conference will focus on critical industry issues and investment opportunities in Africa's energy sector, including discussion on key energy projects and Africa’s burgeoning green hydrogen industry. The conference will be held from November 4 to 8 at the Cape Town International Convention Centre in Cape Town.
|
|
|
|