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=110431
) 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=85774
) 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=84894
) as subquery
MediaWise Trust
MediaWise Trust is an independent media ethics charity supported by journalists, media lawyers and politicians. Its primary purpose is to promote high standards in journalism by providing advice, information, research and training on media policy, practice and law. PressWise runs the Refugees, Asylum-seekers & the Media project (www.ramproject.org.uk).
29.04.2005
Charities are occasionally regarded as fair game for tabloid journalists. In this case of a volunteer accused of child trafficking in Montenegro, it took 15 months before the Sunday Mirror lost the defamation claim and apologised.
11.05.2004
Two thousand delegates from the world's broadcasting industry sat down with 150 youth delegates in Rio de Janeiro at the end of April to discuss issues of common concern. This was the 4th World Summit on Media for Children & Adolescents, and the most ambitious yet.
