|
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=160681
) 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=158812
) 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=158595
) 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=156922
) 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=156733
) as subquery
Policy Innovations
<< Back to organisation profile
Features
27.05.2008
Producing animal-free meat in vitro may help ease the global hunger crisis while reducing greenhouse gas emissions from the livestock sector, writes Abigail Paris with Global Policy Innovations.
Story link
Related links
13.03.2008
In contrast to the Bush administration's 'exaggerated' use of the military as an agent of foreign policy, international economic cooperation can promote global political stability and decreased conflict, say Edward J. Lincoln and Sam Natapoff.
Story link
Related topics/regions:
[United States]
07.03.2008
International cooperation -- especially between rich and poor countries -- will be key to unleashing the social and environmental change potential of advanced new technologies, says Jeffrey Sachs.
Story link
17.01.2008
India may be considered a world leader when held to standards of population, military strength, or economic development, but this country's most valuable advantage lies in its vibrant cultural exports, comments Indian author Shashi Tharoor.
Story link
Related topics/regions:
[India]
Related links
11.01.2008
Benazir Bhutto's assassination is but the latest development in a series of destabilizing events that have plagued Pakistan for over 50 years -- and it may spell the end of Musharraf -- comments Matthew Hennessey.
Story link
Related topics/regions:
[Pakistan]
[United States]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| Next >>
|
|
|
|
