|
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=158324
) 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=158288
) 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=158256
) 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=158216
) 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=158212
) as subquery
Inter Press Service (IPS)
<< Back to organisation profile
Features
28.02.2008
BROOKLIN, Canada, Feb 27 (IPS) - Free, authoritative and online: 1.8 million species.
Story link
Image: Azure Sapphire in Bhutan. © Piet van der Poel
27.02.2008
Leading Indian politicians have outrightly rejected the idea of a U.S.-imposed deadline after a team of U.S. senators warned that a new inhabitant of the White House might quash a potential deal on the transfer of nuclear technology.
Story link
Related topics/regions:
[India]
[United States]
Related links
26.02.2008
A former high-ranking official from Pakistan's "shadowy but powerful" Inter Services Intelligence admitted to having manipulated the 2002 elections in favor of President Musharraf and is now saying the organization's political activities should be laid down.
Story link
Related topics/regions:
[Pakistan]
Related links
26.02.2008
UNITED NATIONS, Feb 25 (IPS) - The contentious debate on the death penalty -- which split the 192-member UN General Assembly last December -- is refusing to die.
Story link
25.02.2008
Local and international activists are calling on the military-backed interim government in Bangladesh to end the year-long state of emergency that is stifling political activity and rights.
Story link
Related topics/regions:
[Bangladesh]
Related links
<< Previous
| 1
| 2
| 3
| 4
| < 5 >
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
