|
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=159385
) 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=158826
) 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=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
Christian Science Monitor
<< Back to organisation profile
Features
05.04.2008
Eigg, an island off the west coast of Scotland, has switched on its own continuous, clean, and renewable energy supply.
Story link
Related topics/regions:
[United Kingdom]
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
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]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
