|
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=103417
) 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=103067
) 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=101925
) 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=99322
) 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=97599
) as subquery
Fahamu - Networks for Social Justice
<< Back to organisation profile
Features
18.02.2005
An innovative program in Malawi provides free, trained legal advisors to anyone who comes in contact with the criminal justice system at any point--from police stations to prisons. Since 2000, 37 paralegals have facilitated the release of more than 2,000 prisoners who were unlawfully or unnecessarily detained, significantly reducing the pre-trial prison population. Similar projects are being considered as far afield as Bangladesh and Cook County, Illinois, USA.
Story link
Related topics/regions:
[Malawi]
14.02.2005
By focusing on children, Radio Chikuni is not doing anything new. But by putting them on the air as program producers and hosts, it's breaking new ground in Zambia.
Story link
Related topics/regions:
[Zambia]
24.01.2005
A consortium of civil society organisations is concerned about the ratification of a Protocol on the Rights of Women in Africa. It will not come into force unless 15 African countries adopt the protocol. This petition can be supported by SMS technology.
Story link
Related topics/regions:
[Africa]
10.12.2004
We live by an "ethical double standard which leads us to accept the poverty manufactured by our society, even though it kills more surely and methodically than machetes and militias," says UNESCO Assistant Director-General Pierre Sané, in this penetrating essay painting freedom from extreme poverty as the most fundamental human right.
Story link
10.11.2004
Join a petition urging African governments to ratify a protocol that guarantees significant rights to women in the continent. The petition can be signed online and by sending a text message or email.
More
Related topics/regions:
[Africa]
[gender & ICT]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| < 7 >
| 8
| 9
| 10
| 11
| Next >>
|
|
|
|
