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=129338
) 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=127368
) 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=109927
) 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=93626
) 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=85590
) as subquery
World Association for Christian Communication
<< Back to organisation profile
Features
16.03.2006
The acquittal on defamation charges of Thai journalist Supinya Klangnarong and the Thai Post has been welcomed as a victory for free speech advocates in the region.
Story link
Related topics/regions:
[Thailand]
Image: Supinya Klangnarong
13.02.2006
Women make up more than half the world’s population yet they only show up in a tiny fraction of the world’s news. Take part in three weeks of global action until 8 March to challenge the world’s media to represent women and men in a fairer and balanced way.
Story link
Image: Fairer representation for women in the world news
22.04.2005
The new Pope may create predicaments for journalists in North Amercia and Europe, torn between professional respect for religions and concern that the power of the catholic church extends its influence into political territory.
Story link
08.09.2004
Providing open and free access to content on Internet can empower millions
without the need for paying the hefty price for information produced by
multinational companies. Lobbying for open content will pave the way for
bridging the digital divide.
More
Related topics/regions:
[content]
[culture]
07.05.2004
Campaigners, academics, lawyers, communicators and students gather at a workshop on intellectual property rights and find that even the Indian film industry poaches on traditional music.
Related topics/regions:
[India]
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-13
| Next >>
|
