|
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=157740
) 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=157210
) 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=156055
) as subquery
SixDegrees magazine
SixDegrees on englanninkielinen ilmaisjakelulehti, joka ilmestyy Helsingissä, Tampereella, Turussa ja Tallinnassa. SixDegrees on sitoutumaton monikulttuurinen julkaisu, jonka tarkoituksena on edistää suvaitsevaisuutta ja luoda kohtaamispaikka suomalaisille sekä Suomessa asuville ulkomaalaisille ja maahanmuuttajille.
Main Address
Vilhonvuorenkatu 11 B
00500 Helsinki
Finland
Main Telephone
+358 9 777 2007
Joined OneWorld
04.10.2004
Features
12.02.2008
The new Finnish Immigration Service has taken the reign from the Directorate of Immigration. The aim is to improve customer services, and one way of doing this will be the upcoming web-based feedback channels. That will not, however, automatically improve the attitudes in the customer service, something that has also triggered complaints.
Story link
Related topics/regions:
[Finland]
25.01.2008
Johanna Suurpää recently became Finland’s new Ombudsman for Minorities. The Ombudsman for Minorities is an independent authority established for the advancement of the status and legal protection of ethnic minorities and foreigners as well as to promote equality and good ethnic relations.
Story link
Related topics/regions:
[Finland]
11.12.2007
Prime Minister Matti Vanhanen has demanded changes to the Finnish gun ownership law as a result of the events in Jokela. But how effective are gun laws in preventing death and injury, really?
Story link
Related topics/regions:
[Finland]
Image: - © Corporate Watch
|
|
|
|
