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=99524
) 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=99085
) 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=99084
) 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=98691
) 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=98627
) as subquery
14.12.2004
Felipe Arriaga, defensor de los bosques en el estado mexicano de Guerrero, está acusado de asesinato por un talamontes. “Soy inocente”, dijo a Tierramérica desde la cárcel.
Arriaga es el quinto campesino opositor a la tala en México en caer preso desde 1999. Los otros cuatro ya están libres, tras una intensa campaña internacional a su favor.
En: Tierramérica
07.12.2004
Ecologistas garantem que uma fábrica de celulose provocou a morte em massa de cisnes no sul do Chile. Os acusados dizem que os verdes carecem de provas.
Em: Tierramérica
07.12.2004
Ecologistas aseguran que una planta de celulosa provocó la masiva mortandad de cisnes cuello negro (Cygnus melancoryphus) en el sur de Chile. Los acusados dicen que los verdes carecen de pruebas.
30.11.2004
Enquanto o Luz para Todos leva a rede elétrica aos locais sem acesso à energia, o Ações Integradas trabalha com projetos sociais para ajudar a população a utilizar essa energia para seu desenvolvimento.
29.11.2004
UNDP has declared 2005 as the International Year of Microcredit to help transform the lives of millions of people, including women, and make progress on the millennium development goals on hunger and poverty.
