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 >= 1720146600
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 <= 1720146600 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
|
|
Provider expands international footprint
Published: 05 Jul 24
Water storage solutions provider and manufacturer Damsak Reservoirs has expanded into international markets, the move underscoring the company’s commitment to addressing global water scarcity and infrastructure challenges, particularly in the manufacturing, mining and engineering sectors. Central to this expansion is the introduction of the new 500 000 ℓ Damsak, which was designed to offer reliability and resilience to ensure continuous operation, especially in regions experiencing water supply disruptions.
|
|
|
Programme empowers young agricultural entrepreneurs in KZN
Published: 05 Jul 24
In a move aimed at bolstering youth entrepreneurship, youth empowerment initiative Metropolitan Collective Shapers (MCS) has launched its impactful programme in KwaZulu-Natal as it continues to equip young entrepreneurs with essential skills and resources. Through the programme, which was established in 2021, youth are taught how to scale their businesses, generate employment within their communities and enhance market access.
|
|
|
|