|
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=98285
) 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=98252
) 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=98171
) 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=98036
) 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=98020
) as subquery
Christian Science Monitor
<< Back to organisation profile
Features
22.11.2004
Rural, ethnic and economic tensions in China are causing flare ups over minor incidents and leading to riots involving thousands of people.
Story link
Related topics/regions:
[China]
21.11.2004
U.S. President George W. Bush has spent a few days in South America this weekend, but Chinese President Hu Jintao has been criss-crossing the region for two weeks, signing a slew of trade accords and solidifying his nation's economic and political ties with the region.
Story link
Related topics/regions:
[China]
[Latin America & Caribbean]
19.11.2004
With a tightened Republican grip on Congress backing a second Bush Administration, battles to save the Arctic Wildlife Refuge and the Endangered Species Act could be more difficult for conservationists this time around.
Story link
Related topics/regions:
[United States]
17.11.2004
The 1.5 million garment workers in Bangladesh - one of the world's poorest nations - face an uncertain future after the textile trade quotas end in January 2005.
Story link
Related topics/regions:
[Bangladesh]
17.11.2004
For the first time since 1971, foreign student enrollment at U.S. universities has decreased as visa delays, a slow economy, and aggressive competition from other English-speaking countries have made many wonder if student life wouldn't be better outside the "land of the free."
Story link
Related topics/regions:
[United States]
<< Previous
| 16-25
| 26
| 27
| 28
| 29
| 30
| 31-40
| 41-50
| 51-60
| 61-70
| Next >>
|
|
|
|
