SELECT DISTINCT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid, u.username as user FROM #__adsmanager_ads as a LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE a.id=3 and c.published LIMIT 1
Cabinet ministers and MPs are among those who have publicly announced their intention to vie for governor and Senate seats as early campaigns for the new electoral offices start ahead of the 2012 polls.
International Criminal Court Registrar Silvana Arbia has praised the Government move to sign an agreement with the court granting it immunity and privileges to operate locally.
It has been dubbed one of the most progressive Bill of Rights, with more than 30 articles addressing social, economic, religious, labour, political, civil, environmental and cultural rights.
Higher Education Minister William Ruto has said the Cabinet was informed of the invitation of Sudan President Omar al-Bashir to the promulgation ceremony at Uhuru Park.
The political landscape ahead of the race to succeed Kenya's third president, Mwai Kibaki, has been reshaped and will be unlike any other in the country's 47-year history.
It is 10am and I arrive at a five star beach club next to the Kilindini harbour to meet a beach boy who would hook him up with a child prostitute and a potential 'buyer'.
During this time of the year Mombasa and its environs is a melting pot of frenzyengulfed in a holiday mood, as thousands of visitors troop to the coastal city for the tourist high season.
Undercover Series: We trail the child sex ring from the wealthy brokers of Nairobi to the peddlers of underage girls and boys in Ukunda and the world of perverts and drug peddling in Mombasa...
The mandate to arrest post-election violence suspects and hand them over to the International Criminal Court when it issues indictments is proving too hot to handle.
AFP - Mozambique police were on alert on Sunday after days of riots over food prices, as calls for renewed protests were circulated via mobile phone text messages.
AFP - A year out from defending their World Cup crown, South Africa looked in disarray when they completed a dismal Tri Nations campaign with a 41-39 defeat against Australia on Saturday.
AFP - South Africa launched a challenge for African Nations Cup redemption by outplaying minnows Niger 2-0 Saturday in the north-east city of Nelspruit.
AFP - Mohamed ElBaradei, the former UN nuclear chief turned Egyptian reformer, accused the government of publishing pictures of his daughter in a swimsuit and at an event in which alcohol was served, a newspaper reported on Saturday.
AFP - Mobile phone messages calling for new riots over food and fuel price hikes swirled around Mozambique's capital Maputo Saturday as it recovered from three days of violence that left 10 people dead.
AFP - Samuel Eto'o scored twice as Cameroon won in Mauritius Saturday and Rabah Saadane quit as Algeria coach after a home draw with Tanzania when the 2012 African Nations Cup qualifiers kicked off.
AFP - Egyptian police are investigating an anonymous poster campaign backing intelligence chief Omar Suleiman to take over the presidency from veteran incumbent Hosni Mubarak, an officer said on Saturday.
AFP - South Sudan must shift its massive dependence on oil and instead work to develop its agricultural sector, the World Bank's vice president for Africa said on Saturday.
AFP - A Darfur rebel group said 10 people were killed in clashes with Sudanese police in two camps for displaced people in the war-ravaged region of western Sudan on Saturday.
AFP - China beat South Africa 4-1 to get off the mark at the third attempt, England drew with South Korea, and Argentina dished out a 4-0 rout to Spain at the women's field hockey World Cup on Friday.
AFP - Police in Mozambique fired rubber bullets and live ammunition to quell more demonstrations against rising food prices, as the death toll from the unrest climbed to 10 with more than 440 injured.
AP - Mozambique's economy has lost more than $3 million because of deadly riots over the rising prices of food and other goods, the government said Friday, as state media reported new protests in two other towns.
Reuters - More than two dozen children in the Democratic Republic of the Congo are among the hundreds of victims of a recent wave of rapes in the nation's conflict-torn east, the United Nations said on Friday.
AFP - Standard Bank Africa announced Friday a 100 million dollar scheme to reach some 750,000 small scale farmers in Ghana, Mozambique, Tanzania and Uganda in a bid to boost output.
AFP - The African Union force in Somalia has boosted its size and set up nine new positions in Mogadishu where it is protecting the government from a fierce Islamist insurgency, an official said Friday.
AP - A nationwide civil service strike entering its third week is causing massive backlogs at courthouses, and a top South African lawyer said Friday that defendants whose legal proceedings are delayed could end up suing the government for damages.
AFP - Politicians from northern Nigeria on Friday accused President Goodluck Jonathan of ordering corruption investigations against those opposed to his candidacy in upcoming elections.