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=160918
) 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=160904
) 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=160655
) as subquery
Advocacy Project
The Advocacy Project, a nonprofit organization formed in 1998, seeks to help community-based organizations produce, disseminate, and use information in their efforts to become more effective advocates for social justice and human rights.
19.06.2008
Hundreds of children, including 240 orphans, will be affected by the Israeli military's recent decision to shut down schools and orphanages belonging to the Islamic Charitable Society.
18.06.2008
Wastepickers in Delhi, who live and work in profoundly unsanitary conditions, won a major concession earlier this month from their local government: a portable toilet.
The Advocacy Project
23.05.2008
A local forensic team is set to exhume and identify more than 120 people massacred by the Peruvian military in 1984, a process that will help relatives of those "disappeared" during the country's civil war heal and demand justice.
