|
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=160925
) 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=160914
) 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=160890
) 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=160880
) 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=160871
) as subquery
OneWorld US
<< Back to organisation profile
Features
19.06.2008
WASHINGTON, Jun 19 (OneWorld) - Over 37 million people were living as refugees from conflict or persecution at the end of 2007, marking the second straight year of increases after a five-year decline, said a concerned UN Refugee Agency (UNHCR) this week.
Story link
Related topics/regions:
[Africa]
19.06.2008
WASHINGTON, Jun 18 (OneWorld) - Renewable energy is approaching a "tipping point" and should expand dramatically in the next decade, further narrowing the gap between alternative forms of energy and fossil fuel use, said environmental and economic experts at a forum here Monday.
Story link
17.06.2008
WASHINGTON, Jun 16 (OneWorld) - The greatest effect of China's Wenchuan Earthquake may not be on Sichuan Province's buildings, but rather, its children. Local and international groups have launched several initiatives to help meet the needs of many of the estimated 3 million children affected by the earthquake.
Story link
Related topics/regions:
[China]
14.06.2008
UNITED NATIONS, Jun 13 (OneWorld) - Millions of people across the world are more likely to face hunger and starvation due to disruption in aid deliveries caused by the rising prices of food, UN officials said this week.
Story link
13.06.2008
Afghan president Hamid Karzai unveiled a new 5 year plan for social and economic development at a conference to reform aid efforts to Afghanistan in Paris yesterday, writes the UN News Agency.
Story link
Related topics/regions:
[Afghanistan]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
