|
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=160247
) 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=160246
) 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=159386
) 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=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
Christian Science Monitor
<< Back to organisation profile
Features
30.04.2008
Why some say travelers should think twice before boarding.
Story link
30.04.2008
Why some say travellers should think twice before boarding.
Story link
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
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
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
