|
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=143916
) 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=140046
) 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=131806
) as subquery
Brazil Justice Net
BRAZIL JUSTICE NET (known also in Portuguese as SEJUP--Servico Brasileiro de Justica e Paz) was founded in 1991 and specializes in preparing news and reports in English about Brazilian human rights and social issues. Among the issues we cover are land questions, indigenous issues, environment, the churches, women's issues, violence, racism, children, grassroots movements.
Main Address
Caixa Postal 125
18150-970 Ibiuna, Sao Paulo
Main Telephone
551597833139
Joined OneWorld
08.02.2006
Features
15.12.2006
Militias formed by police, ex-police officers, firemen, prison workers, and military personnel have expelled drug traffickers from the west and northern areas of the city of Rio de Janeiro.
Read more
Related topics/regions:
[Brazil]
27.09.2006
Here in Brazil, the country is on the eve of the first round of elections at the state and national level. It is the fifth time since the end of the military dictatorship that Brazilians will vote for a president, state governors and representatives. The social movements struggled hard for this right to votehas it made a difference for the Brazilian people?
Story link
Related topics/regions:
[Brazil]
27.04.2006
Last month, on International Women's Day (March 8), nearly 2,000 rural women workers marched to the Aracruz Celulose greenhouse in the state of Rio Grande do Sul and destroyed thousands of eucalyptus seedlings and the accompanying research (...) Why did the women destroy the Aracruz seedlings? The women issued the following press release explaining their actions.
Story link
Related topics/regions:
[Brazil]
Image: www.ecoar.org.br
|
|
|
|
