|
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=151642
) 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=145105
) 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=141851
) 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=141823
) 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=139231
) as subquery
In These Times
<< Back to organisation profile
Features
26.07.2007
Latino teenagers, including undocumented immigrants, are being recruited into the U.S. military with false promises of citizenship for themselves and their families, reports Deborah Davis for In These Times.
Story link
Related topics/regions:
[United States]
[Iraq]
18.01.2007
"There is no rhyme or reason to the world of Guantanamo--only a cruel inhumanity," says H. Candace Gorman, providing the inside scoop on some of the detainees and the legal and personal challenges they face.
Story link
Related topics/regions:
[United States]
02.11.2006
There have been times when the U.S. media have been ahead of the public, but today they are reporting the dots without connecting them, says professor Susan Douglas, and missing one of the biggest stories of our time: widespread outrage, despair, and fear over the subversion of democratic processes.
Story link
01.11.2006
There have been times when the U.S. media have been ahead of the public, but today they are reporting the dots without connecting them, says professor Susan Douglas, and missing one of the biggest stories of our time: widespread outrage, despair, and fear over the subversion of democratic processes.
Story link
Related topics/regions:
[United States]
12.09.2006
In coordination with the release of the new documentary Iraq for Sale: The War Profiteers, a consortium of progressive media outlets are covering the issues and individuals impacted by privatization in Iraq.
Story link
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-48
| Next >>
|
|
|
|
