|
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=117598
) 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=116791
) 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=115406
) as subquery
working TV
This group produces video, broadcast television programs and web video from a progressive workers' perspective. Based in Vancouver, working TV also broadcasts weekly on community access television in the province of British Columbia.
Main Address
2149 Parker Street
Vancouver, BC
V5L 2L6
Main Telephone
604-253-6222
Joined OneWorld
17.12.2001
Features
23.08.2005
On August 10th, 1974, Eddie Nalon bled to death in a solitary confinement unit at Millhaven Maximum Security Prison when the emergency call button in his cell failed to work. An inquest into his death found that the call buttons in that unit had been deactivated by the guards. Later, there was another death in this same unit. The call buttons had not been repaired. Prisoners at Millhaven mark the anniversary of these deaths by fasting and refusing to work.
Story link
Related topics/regions:
[Canada]
09.08.2005
Madeleine Parent and Jean-Claude Parrot have led extraordinary lives. They have been celebrated for their courage and commitment. Their accomplishments have improved the lives of millions of Canadians. Their dedication has made them international heroes of the labour movement and to a new generation of young activists. Parent and Parrot recently spoke about their lives as activists as they each launched a new book.
Story link
Related topics/regions:
[Canada]
15.07.2005
Jose La Luz, Assistant Director of Organizing for the AFL-CIO, spoke at the Hospital Employees' Union 2005 Summer School at UBC. He led the drive which organized tens of thousands of public sector workers in Puerto Rico. He is a fiery speaker and HEU activists gave him repeated standing ovations. He provides a glimpse of the progessive current in the U.S. labour movment we seldom see in Canada. Watch him here.
Story link
Related topics/regions:
[Canada]
|
|
|
|
