|
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=158825
) 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=154863
) 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=143890
) 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=138786
) 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=138555
) as subquery
Christian Science Monitor
<< Back to organisation profile
Features
15.03.2008
A new European Union report adds urgency to concerns about future conflicts and mass migration driven by a warming climate.
Story link
Related topics/regions:
[Europe]
Image: Climate refugees will be driven by drought, loss of food supplies, and rising sea levels © Michael Dunlea/The Express / Christian Aid
05.11.2007
Hundreds of thousands of Mexicans were displaced last week by the worst flooding the nation has seen in 50 years. Despite the destruction, a remarkable number of volunteers have pitched in to the relief efforts, echoing one survivor's belief that, "the only thing you can do is help others."
Story link
Related topics/regions:
[Mexico]
Related links
15.12.2006
The British and the Americans are engaged in an online competition over www.geographycup.com to find out who emerges as a victor in a battle of knowledge and understanding on geography. This transatlantic challenge was conceived by Roger Andreson - founder of a company dedicated to promoting geographical awareness through games - of Atlanta, the US and Daniel Raven-Ellison - a secondary school teacher - of Reading, England.
Story link
Related topics/regions:
[United Kingdom]
[United States]
[education & ICT]
[educational innovations]
05.09.2006
After more than a week of fighting with the Tamil Tigers, the Sri Lankan Army Monday captured a strategically important rebel position. The Tigers retreated from Sampur without much resistance, following days of pounding from the military's Israeli-made Kfir jets.
Story link
Related topics/regions:
[Sri Lanka]
31.08.2006
For years, Nawab Mohammed Akbar Khan Bugti battled the Pakistan Army. The 80-year-old renegade hidden in the mountains of Balochistan became a legend in his fight for greater autonomy against what he saw as colonial brutality.
And his death this weekend, during a fierce three-day battle that left more than 30 dead, could prove a serious blow to Pakistan's stability.
Story link
Related topics/regions:
[Pakistan]
<< Previous
| 1
| < 2 >
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
