|
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=139222
) 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=138593
) 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=138480
) 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=136569
) 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=134224
) as subquery
In These Times
<< Back to organisation profile
Features
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
Related topics/regions:
[Iraq]
[United States]
01.09.2006
Concrete political action and speedier access to anti-retroviral drugs should lead the international community's response to the AIDS epidemic, not more high-minded but toothless pledges, says Michael McColly, who has written a memoir on the work of AIDS activists around the world.
Story link
30.08.2006
Concrete political action and speedier access to anti-retroviral drugs should lead the international community's response to the AIDS epidemic, not more high-minded but toothless pledges, says Michael McColly, who has written a memoir on the work of AIDS activists around the world.
Story link
18.07.2006
While 'American Taliban' John Walker Lindh has commonly been treated by the United States as a traitor, his incarceration derives more from his conversion to Islam as a white man, says Salim Muwakkil. His situation recalls previous struggles with bigotry in the U.S., raising the question, "can America and Islam coexist?"
Story link
Related topics/regions:
[United States]
Image: Salim Muwakkil says many white Americans see Lindh as a traitor to his culture. © In These Times
06.06.2006
Gay men in Iraq are increasingly being intimidated and murdered by Shi'ite death squads under a "sexual cleansing" pogrom originated in Iran--and American authorities are allegedly letting it happen.
Story link
Related topics/regions:
[Iran]
[Iraq]
Image: Supporters of Grand Ayatollah Ali al-Sistani, who issued the anti-gay fatwa. © In These Times
<< Previous
| 1
| 2
| 3
| < 4 >
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-48
| Next >>
|
|
|
|
