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=79656
) 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=79190
) 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=77744
) as subquery
Committee to Protect Journalists
CPJ is an independent, nonprofit, nonpartisan organisation that documents and responds to press freedom violations worldwide.
19.02.2004
The Committee to Protect Journalists, a longtime OneWorld partner, has been awarded the prestigious Prize for Journalism and Democracy, given annually by Europe's Organization for Security and Cooperation. Read the acceptance speech by CPJ director Ann Cooper.
13.02.2004
Tunisia’s president will be in Washington Tuesday for talks with Pres. Bush. Tunisia has become an ally in the 'war on terror,' but wages its own terror war against human rights activists and the media. Human rights and press freedom groups here are urging Bush to take Tunisia to task for its repressive policies.
28.01.2004
A producer and driver working for CNN in Iraq were killed Tuesday when a man in a car opened fire on their vehicle. Last year, according to the Committee to Protect Journalists, 13 journalists were killed in Iraq--which is judged the most dangerous spot for the profession.
