|
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=129839
) 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=115674
) 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=80924
) as subquery
Media Rights Agenda
MRA is an independent, non-governmental organisation established for the purpose of promoting and protecting press freedom and freedom of expression in Nigeria.
Main Address
44 Alhaja Kofoworola Crescent
PO Box 52113
Ikoyi
Lagos
Main Telephone
234 1 4930831
Joined OneWorld
03.08.1999
Features
27.03.2006
Congress is considering legislation--promoted by the cable companies--that could eliminate support for Public Access TV. But the stations themselves, including New York's popular Manhattan Neighborhood Network, are at the forefront of a massive campaign to save the stations.
Story link
Related topics/regions:
[United States]
21.07.2005
Arts Engine's film "Deadline" received an Emmy Award nomination this week for Outstanding Continuing Coverage of a News Story in a News Magazine. The film explores Illinois Governor George Ryan's 2003 decision to pardon all 171
Death Row prisoners and recounts the legal storm surrounding the decision.
Story link
Related topics/regions:
[United States]
Image: Still Image of Illinois Gov. Ryan from the Movie, ‘Deadline’ © Katy Chevigny and Kirsten Johnson / Media Rights AgendaRelated links
09.03.2004
For historical perspective on today's current events, Media Rights reviews "Fog of War," a documentary describing the life and times of Robert MacNamara. Get ready to participate in the Annual 'Media that Matters' Film Festival, featuring the best short films and new media to inspire you to speak out and take action for social change.
Story link
|
|
|
|
