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=88320
) 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=87122
) 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=81660
) 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=57854
) 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=31287
) as subquery
16.06.2004
Every fortnight since the invasion of Iraq, a group of 20 young journalists, from mainly Muslim countries around the world, send in their diary entries to Counterpoint, the British Council’s cultural relations website. The Keeping in Touch project allows the group to communicate in a time of growing misunderstanding between peoples by exploring, understanding and acknowledging cultural and religious difference.
31.05.2004
Two Australian scientists will work with their British counterparts to work on the design of faster laser-driven computers. This collaboration is being facilitated by the British Council Eureka Prize for Inspiring Science.
16.03.2004
The Global Gateway is a new international website for people involved in education across the world to engage in creative partnerships.
Intended for young people, teachers, parents, school leaders, governors and local authorities, it is designed to provide quick access to comprehensive information on how to develop an international dimension to education.
01.05.2002
For human rights news and information from around the world, and about organisations in the UK and internationally which are working on human rights issues, check out the British Council's informative web portal.
