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=159103
) 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=158804
) 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=158635
) 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=158566
) 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=158335
) as subquery
24.03.2008
Three Reporters Without Borders representatives, including secretary-general Robert Ménard, today unfurled a banner showing the Olympic rings transformed into handcuffs at the official Olympic torch-lighting ceremony in Olympia, Greece (photo, right).
+ Investigate Crackdown Before Torch Relay’s Passage Through Tibet
13.03.2008
UNESCO withdrew its patronage for Online Free Expression Day at the last minute yesterday, on the grounds that it could not support the various demonstrations organised to mark it.
07.03.2008
The first International Online Free Expression Day will be launched on 12 March, which will also see a “24-hour online demo against Internet censorship”.
28.02.2008
An international media freedom group has voiced concern over the health of detained Chinese cyber-dissident and human rights lawyer Yang Maodong, who has been on hunger strike for 11 weeks.
+ CPJ Highlights China's Poor Press Record
