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=87603
) 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=86842
) 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=86570
) 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=85865
) 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=82010
) as subquery
07.06.2004
The BBC plans to use Creative Commons licenses to open up its archive of broadcasting material, through an initiative called the Creative Archive...
26.05.2004
Violence by armed groups and violations by governments have combined to produce the most sustained attack on human rights in 50 years, according to a report published by Amnesty International. Listen to the news release on OneWorld Radio.
21.05.2004
The world was stunned by video showing U.S. soldiers abusing Iraqi prisoners. And efforts to spin the footage as an aberration are still haunted by the Pentagon's Latin American legacy. For years, its School of the Americas trained foreign soldiers in techniques of torture, assassination and social hacking. An audio interview with Eric LeCompte, organizing coordinator of School of the Americas Watch.
Tune in to a 24-hour multilingual broadcast exploring issues of racism and discrimination via internet and satellite on International Day for the Elimination of Racial Discrimination, 21 March. Radio Voix Sans Frontières is an international broadcast campaign from AMARC, co-produced in collaboration with community radio stations around the world.
