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=1184
) 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=19754
) 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=31293
) 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=18733
) 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=15466
) as subquery
International Institute For Democracy And Electoral Assistance
16.09.2002
Ways of guaranteeing election rights for disabled people - "among the most marginalised in the world" - are being discussed at an international workshop in Sweden today and tomorrow.
30.07.2002
Observers have described the May 2002 Parliamentary elections in Burkina Faso as a "break through for democracy". The elections marked the end of an era of dominance by the ruling party and the emergence of a strong Parliamentary opposition. read IDEA's policy brief for full report.
22.03.2002
Did you know that more people voted in the 1950 general election than in the 2001 election, despite the population being 20% less than it is now? IDEA report on political participation and bring you all the relevant facts and figures.
16.01.2002
What are the implications of the IT revolution for democracy? This was one of the headline issues discussed at the International IDEA's Democracy and the Information Revolution, reports from which are available online.
