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=67563
) 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=65560
) 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=65562
) 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=65561
) 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=56859
) as subquery
08.09.2003
Campaigners have used almost every technique the Internet offers to raise awareness of the injustices that the present global trade regime perpetuates and to organize action to resist corporate globalization that places profit before people. Glen Tarman of the Trade Justice Movement traces the growth of online activism around trade issues.
12.08.2003
If you manage or are connected in any way with an e-government application in the public administration of your country, then you can submit its description for an "E-government Case Studies Compendium". The Division for Public Administration and Development Management of the United Nations Online Network in Public Administration and Finance is building this compendium.
01.08.2003
Nominations have been invited for eminent experts from UN member states, to be part of a panel that will propose the best achievements in e-content products. A showcase event on best contents from around the world will be held on 10 December 2003 in Geneva in the framework of the World Summit on the Information Society (WSIS). More details (PDF document)
01.08.2003
E-Democracy.org, the world's first election-oriented Website, is working to increase public use and awareness of reliable, high-quality election information resources in the 2004 US elections. This is your chance to help build a comprehensive directory of the best election resources based on the citizen perspective. You can also volunteer your skills for the Website.