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=157831
) 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=156649
) 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=154996
) as subquery
Environmental Investigation Agency (EIA)
The Environmental Investigation Agency (EIA) is an international campaigning organisation committed to investigating and exposing environmental crime and threats to the natural world. Since 1984, EIA has used pioneering investigative techniques all over the world.
15.02.2008
Laws are failing to protect the critically endangered Sumatran Tiger, according to a report by wildlife trade network monitors.
India's tigers at risk
08.01.2008
Global retail giant Wal-Mart is selling products made from illegally logged timber – in turn threatening the habitat of the highly endangered Siberian tiger, according to new evidence from an environmental activism group.
08.11.2007
United States legislation against illegal timber products -- currently worth an estimated $3.8 billion -- would be a historic milestone in the battle against illegal logging and deforestation, says an environmental campaign group.
