|
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=115336
) 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=114303
) 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=114235
) 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=113482
) 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=112312
) as subquery
In These Times
<< Back to organisation profile
Features
15.07.2005
"The image manipulation of this administration is sinister. I wanted to do something to combat that," said political cartoonist Ward Sutton, a renown comic strip artist whose work has appeared in Rolling Stone and Time magazines. Since the first Gulf War, Sutton has become more political in his art, which he hopes will open the eyes of the public to the lies they have been told.
Story link
Related topics/regions:
[United States]
30.06.2005
From T-Mobile commercials to the popular TV drama "24," images of torture abound in U.S. pop culture these days. Chalk it up to harmless bits of Hollywood imagination, or a dangerous phenomenon desensitizing Americans to the real life torture and misery taking place at Guantanamo Bay and Abu Ghraib?
Story link
Related topics/regions:
[United States]
29.06.2005
"Real news is the news you and I need to keep our freedoms," correspondent and historian Richard Reeves once told a student. Public broadcasting's number one news anchor, Bill Moyers, stands up to those who, with metallic flags on their lapels, are attempting to muzzle the few in American society who are reporting the news rather than the spin.
Story link
Related topics/regions:
[United States]
Image: 'I'm in hot water because my colleagues and I at ''NOW'' didn't play by the conventional rules of Beltway journalism.' © In These Times
17.06.2005
Father's Day raises some difficult issues for the African-American community, which has the highest number of absent males than any other. Poverty, disease, violence, and mass incarceration take away more and more men from the family unit, rending the fabric of the community, says In These Times editor Salim Muwakkil.
Story link
Related topics/regions:
[United States]
31.05.2005
The Bush administration is making a final push for Congressional passage of a free trade agreement with five Central American countries and the Dominican Republic, but claims that it will improve economies and strengthen freedom and democracy in Central America are not even supported by a majority in the Republican-led U.S. Congress, says In These Times senior editor David Moberg.
Story link
Related topics/regions:
[United States]
[Central America]
[Caribbean]
Image: Demonstrations in Costa Rica against CAFTA in 2004 © In These Times
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| < 8 >
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-48
| Next >>
|
|
|
|
