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=159504
) 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=159473
) 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=159314
) 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=159022
) 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=158249
) as subquery
07.04.2008
Supermarket chain Asda wants overseas suppliers excluded from a new UK code of conduct which is designed to ensure that the big grocers do not use their buying power to impose unfair trading terms.
06.04.2008
Police had to bring in reinforcements to marshal the Olympic torch relay through London after a series of protests along the 31-mile route by critics of China's human rights record.
+ IOC memo minimises events in Tibet
01.04.2008
Al Gore has launched a drive to mobilise 10 million volunteers to force politicians to act on climate change - twice as many as the number who marched against the Vietnam war or in support of civil rights during the heyday of US activism in the 1960s.
20.03.2008
One of the biggest fashion retailers in the US, Banana Republic, last night began an investigation into allegations that workers in India who make its clothes are being forced to work more than 70 hours a week for as little as 15p an hour.
