
|

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=115255
) 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=111354
) 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=110398
) as subquery
BC Government and Service Employees' Union
This progressive Canadian union represents some 60,000 British Columbians within and outside the provincial public service. The BCGEU is a strong advocate on issues affecting working people and their families, the poor and the disadvantaged, First Nations people, youth and other equity-seeking groups.
Main Address
4911 Canada Way,
Burnaby BC V5G 3W3
Main Telephone
1-800-663-1674
Joined OneWorld
09.03.2004
Features
13.07.2005
A controversial 2003 decision by the B.C. Labour Relations Board, one of the most pro-employer boards in Canada, has been overturned by a reconsideration panel. For a full week during BCGEU's organizing drive at a call centre owned in the U.S., the company projected continuous high tech slide shows with strong anti-union messages onto screens set up in the workplace. Company managers also distributed "gifts" to employees bearing anti-union messages.
Story link
Related topics/regions:
[Canada]
[United States]
13.05.2005
Working parents need affordable child care to balance work and family needs. And studies show, children who get good care in their early years do better at school, are well-adjusted teenagers, and become more stable adults. Yet quality, affordable child care is out of reach for many B.C. families. The federal government has signed bilateral agreements with some other provinces but in B.C., the Gordon Campbell Liberal government is refusing federal funding because it does not want to be held accountable on how it spends the money.
Story link
Related topics/regions:
[Canada]
28.04.2005
The Supreme Court of Canada says it will hear arguments on whether the British Columbia provincial government's contract-breaking law violates the equality and freedom of association rights of health care workers in B.C. On trial is the 2002 legislation that shredded legally negotiated collective agreements paving the way for an unprecedented privatization of health care services and the mass firing of more than 8,000 health care workers – mostly women.
Story link
Related topics/regions:
[Canada]
|
 |


|
 |