|
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=114212
) 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=111471
) 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=109800
) as subquery
Sierra Club of Canada
Founded in 1892, this NGO's priorities now range from climate change and ozone depletion to toxic chemical contamination and loss of biodiversity. The Sierra Club has worked in Canada since 1969, focussing on public policy and environmental awareness.
Main Address
412-1 Nicholas Street
Ottawa, Ontario
K1N 7B7
Main Telephone
613-241-4611
Joined OneWorld
03.12.2001
Features
28.06.2005
At a recent meeting on oceans and the law of the sea at the UN, delegates agreed that the world must address the impacts of ocean noise on marine life. This is in contrast to Canada's attempts to ignore the impacts of seismic testing on marine life. "It is shameful that DFO and the Minister of Fisheries are choosing to play dumb so that oil and gas companies can have their way," says Elizabeth May of the Sierra Club, noting that the DFO continues to allow seismic testing in sensitive regions like coastal Cape Breton.
Story link
Related topics/regions:
[Canada]
16.05.2005
Several of Canada's leading conservation, environmental and animal welfare organizations are calling on the Senate to quickly pass Bill C-15 which is designed to bring an end to the dumping of bilge oil from ships which results in the deaths of some 300,000 seabirds annually. If passed before the end of the session, it would stop operators in the shipping industry who pollute Canada's waters intentionally or through negligence.
Story link
Related topics/regions:
[Canada]
20.04.2005
Alberta stands poised to shirk its responsibility to take immediate action to protect woodland caribou, opting instead to protect industry while long-term plans are developed, says a recently released report. Right now, the province proposes too little to challenge the momentum of ongoing industrial development in caribou habitat.
Story link
Related topics/regions:
[Canada]
|
|
|
|
