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=154674
) 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=150807
) 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=150482
) as subquery
Article 19
Named after Article 19 of the Universal Declaration of Human Rights, Article 19 works worldwide to combat censorship by promoting freedom of expression and access to official information, and to strengthen local capacity to monitor and protest censorship.
31.10.2007As the UN Human Rights Committee begins to scrutinise Britain's rights performance, Article 19 calls on the committee to question the government on its plans to reduce use of the Freedom of Information Act, the ban on unauthorised demonstrations near Parliament Square and the high cost of defending libel actions.
29.06.2007
UK development groups broadly welcomed the Cabinet changes ushered in by the new Prime Minister, Gordon Brown, as they outlined the areas in which they wanted action.
21.06.2007
The Sri Lankan government's blocking of access within the country to TamilNet, a Norway-based website, has been described by an international media monitoring group as "a new and more extreme form of censorship".
+ Civilians caught up in Sri Lanka conflict
