|
select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=156829
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=156809
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=156186
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=156080
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=155785
) as subquery
allAfrica.com
<< Back to organisation profile
Features
15.01.2008
Around the edges of Cape Town, older women are leading the fight against hunger, disempowerment, and disease by planting organic community gardens.
Story link
Related topics/regions:
[South Africa]
Related links
14.01.2008
The "Malaria Initiative," a 5-year prevention and treatment program launched two years ago in Africa, has already reached 85 percent of the the most vulnerable groups -- women and children under five -- in 15 countries.
Story link
Related topics/regions:
[Africa]
Image: A woman and child sit on an insecticide-treated mosquito net. © International Federation of Red Cross and Red Crescent Societies
Related links
17.12.2007
"The SADC [South African Development Community] countries need to ratchet up their pressure [on Zimbabwe], and they need to do it not just behind doors but openly so that world public opinion can be mobilised behind African voices, behind African leadership," said the secretary-general of human rights organization, after attending a meeting in Cape Town last week to launch a new global campaign for human rights.
Story link
Related topics/regions:
[Zimbabwe]
[Southern Africa]
Related links
13.12.2007
Accused of committing human rights atrocities during his long tenure, Zimbabwean President Robert Mugabe arrived at the EU-Africa summit amid vociferous demonstrations by protesters and official condemnation by European heads of state.
Story link
Related topics/regions:
[Zimbabwe]
Related links
03.12.2007
The HIV/AIDS epidemic negatively impacts livestock productivity among poor and vulnerable families who rely on their animals for food and a small income, warns the UN’s food agency.
Story link
Related topics/regions:
[Africa]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
