
|

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=117197
) 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=112686
) 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=109966
) as subquery
Vancouver Island Public Interest Research Group
VIPIRG combines original research on emerging social and environmental issues with education, advocacy and action for positive change. Its research is directly relevant to the community and its projects are developed in partnership and consultation with other groups. VIPIRG is a non-profit society based at the University of Victoria.
Main Address
PO Box 3035 Stn CSC
Victoria, BC, V8W 3P3
Main Telephone
250-472-4558
Joined OneWorld
29.01.2004
Features
16.08.2005
On a misty day in January 2001, TimberWest Forest Corp. permanently closed its Youbou Sawmill on Cowichan Lake leaving over 200 workers without jobs. This act of industrial “restructuring” stunned the displaced workers, their families, and their forest dependent community. Two years later, the Youbou TimberLess Society (YTS) collaborated with the Vancouver Island Public Interest Research Group (VIPIRG) to investigate the true human impacts that the mill closure had on the lives of the former millworkers.
Story link
Related topics/regions:
[Canada]
06.06.2005
Imagine a slight pretty young woman pointing a machine gun at terrified women and children, lying on their stomachs on the floor. This is the real world of Iraq. The young woman looks into the eyes of her captives and sees their fear and hatred. She begins to realize that these are the people she was told she came to help. When the Colorado National Guard recruiters came to her school, they persuaded Kelly Dougherty that she could serve her country in domestic disasters like floods and earthquakes.
Story link
Related topics/regions:
[Canada]
[United States]
22.04.2005
Jennifer Moore is a bland English name. So why, when I am looking at women's clothes in a department store and see that name on labels, do I think of Guatemalan women and children bent over sewing machines? Rosita Escobar came to Canada to tell us about these thousands of women and girls who work in sweatshops called maquilas that produce the garments that end up in our fancy shops with inflated prices. Jennifer Moore is just one of hundreds of labels used to produce clothing for our consumption–crazy society.
Story link
Related topics/regions:
[Central America]
[Canada]
[Guatemala]
|
 |


|
 |