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=95390
) 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=94055
) as subquery
05.10.2004
New regulations on workplace drug tests entered into force on 1 October. The reform was prepared by a tripartite forum in which the trade union point of view was taken seriously. The trade union position fared even better when the matter was considered by the Finnish Parliament.
15.09.2004
The electronics industry giant Philips intends to make its entire supplier network behave in an ethical manner based on sustainable principles. This policy will apply to both labour rights and the environmental and social impacts of suppliers.
