|
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=153512
) 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=153188
) 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=151594
) as subquery
International Confederation of Free Trade Unions
ICFTU has 157 million members in 225 affiliated trade union organisations from 148 countries and territories.
Main Address
5 Boulevard du Roi Albert II, Bte 1
B-1210 Brussels
Main Telephone
+32 2 224 0211
Joined OneWorld
25.07.2002
Features
26.09.2007
The latest issue of the World Bank’s highest-circulation annual publication, Doing Business, has again come under fire from trade unions for its assertion that elimination of workers' protection rules creates higher economic growth and job creation.
Story link
18.09.2007
A total of 144 trade unionists were murdered for defending workers' rights last year, and more than 800 were beaten or tortured, according to a survey by the 168-million member International Trade Union Confederation.
Story link
24.07.2007
Libya's release of five Bulgarian nurses and a Palestinian doctor - jailed in 1999 for allegedly infecting 393 children with HIV - has been welcomed by the International Trade Union Confederation.
Story link
Related topics/regions:
[Bulgaria]
[Libya]
[Palestine]
|
|
|
|
