
|

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=152680
) 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=152229
) 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=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
In These Times
<< Back to organisation profile
Features
29.08.2007
Steve Ellner looks at the successes and failures of some of the key policies advanced by the pioneer of "21st century socialism," looking particularly at Hugo Chavez's state-endorsed workers cooperatives and his initiative to eliminate illiteracy.
Story link
Related topics/regions:
[Venezuela]
Related links
14.08.2007
Tens of thousands of Africans attempted to reach Italy in recent years by making the deadly journey across the Mediterranean. Many are being driven away from their coastal homes as the European fishing industry gains access -- legally and illegally -- to West African waters.
Story link
Related topics/regions:
[Ghana]
[Africa]
Related links
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
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-48
| Next >>
|
 |


|
 |