|
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=154976
) 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=154977
) 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=154233
) 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=153967
) 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=153081
) as subquery
Center for Global Development
<< Back to organisation profile
Features
15.11.2007
Australians emit more CO2 on a per capita basis than any other nation in the world, followed by Americans, according to the first global inventory of power stations.
Story link
08.11.2007
The first global inventory of power stations ranks 50,000 around the world. It reveals the dirtiest and cleanest companies and plants by their CO2 emissions.
Story link
17.10.2007
After a 14-year civil war was brought to a halt by UN peacekeepers, Liberians elected Africa's first female head of state. Under President Ellen Johnson-Sirleaf the country is slowly but surely pushing forwards in terms of economic growth, democracy, and education, writes Steve Radelet from Liberia.
Story link
Related topics/regions:
[Liberia]
Related links
10.10.2007
The U.S. ranks last of 21 rich countries on the environment component of the latest Commitment to Development Index, and Norway ranks first, followed by Ireland, Finland, and the UK.
Story link
12.09.2007
A new World Bank initiative, which will provide clean and reliable solar lighting to half of the 500 million Africans living without an effective source of power, is getting high marks from an independent think tank.
Story link
Related topics/regions:
[Africa]
Image: Lights in Africa, solar power
Related links
<< Previous
| 1
| 2
| 3
| < 4 >
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-24
| Next >>
|
|
|
|
