|
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=86846
) 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=85159
) 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=83862
) 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=76523
) 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=73340
) as subquery
The Hoot, Media Foundation
<< Back to organisation profile
Features
26.05.2004
More coverage, more advertising, more polls, more flashy graphics - but predictions of the result by the Indian media were universally wrong. As almost 70% of rural communities in India do not even own a radio, it seems that the media is just not in touch with reality.
Story link
Related topics/regions:
[India]
03.05.2004
As many as ten new newspapers have been launched from the east Indian state of Orissa just before the elections. Interestingly, because many of these newspapers are owned by politicians, the editorial content is seen to be biased.
Related topics/regions:
[India]
16.04.2004
Journalists in the Himalayan kingdom of Nepal have joined street protests along with the common man.
Related topics/regions:
[Nepal]
12.01.2004
Entries for the IFJ Journalism for Tolerance Prize are being invited from across South Asia relating to articles on promoting tolerance, combating racism and contributing to an understanding of cultural, religious and ethnic differences. The last date for sending articles is February 27, 2004.
Related topics/regions:
[South Asia]
21.11.2003
A journalist for a news channel in the south Indian state of Kerala had to go into hiding after being harassed by the police for highlighting the cause of tribals.
Related topics/regions:
[India]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| Next >>
|
|
|
|
