|
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=160940
) 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=160823
) 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=159834
) as subquery
Link TV
Link TV connects Americans to the world. Available in the U.S. as a free channel on satellite DIRECTV (channel 375), DISH Network (channel 9410) and at LinkTV.org, Link provides diverse perspectives on global and domestic issues unavailable elsewhere. A powerful antidote to conventional media, we deliver compelling documentaries, international news, current affairs, cinema, the best of world music and more.
Main Address
P.O. Box 2008
San Francisco, CA 94126
Main Telephone
415-000-0000
Joined OneWorld
27.07.2002
Features
24.06.2008
In this upcoming documentary, an Iraqi journalist shares his story of being wrongfully jailed in Abu Ghraib Prison for allegedly planning to kill former British Prime Minister Tony Blair.
Story link
Related topics/regions:
[Iraq]
[United States]
Related links
09.06.2008
A series of town-hall discussions will look at the issues that really matter to Americans this election season. The first edition of Live from Main Street examines what we hear -- and what we don't -- in the age of corporate media.
Story link
Related topics/regions:
[United States]
16.04.2008
While General Petraeus and the American Ambassador to Iraq testified recently about security improvements and a decrease in violence in Iraq, they failed to mention the almost 5 million Iraqis displaced by the war. Jamal Dajani reports.
Story link
Related topics/regions:
[United States]
[Syria]
[Jordan]
[Iraq]
Related links
|
|
|
|
