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=123230
) 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=123078
) 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=122226
) 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=122331
) 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=122190
) as subquery
02.12.2005
Six countries have launched investigations in the wake of allegations that the U.S. has been secretly using airports and military bases across Europe to transport and detain terrorist suspects. The controversy threatens to undermine current attempts to mend transatlantic relations, says the Christian Science Monitor.
30.11.2005
Robin Lovitt will not be the 1,000th inmate put to death after all, as Virginia Governor Mark Warner decided Tuesday to commute his sentence to life-without-parole. But as the milestone lingers, Christian Science Monitor takes a hard look at rehabilitation and its role in the U.S. penal system.
21.11.2005
Hybrid car owners are being offered everything from tax breaks to free parking from corporations, cities, states, and even the federal government, which will award a tax credit of up to $3,150 per car beginning in January. While some worry about a "hybrid backlash," others praise any effort to push hybrid culture into the mainstream.
17.11.2005
A prototype of a $100 wind-up laptop is being presented at the World Summit on the Information Society this week. Governments, the U.N., and private companies have expressed interest in making sure the low-cost computers become available across the globe to all students--even in the poorest and most remote places.
15.11.2005
Thousands of Pakistanis have led a robust local response to the earthquake disaster that contrasts sharply with relatively tepid donations from the international community, reports David Montero, while OneWorld Country Guides volunteer editor Shazad Ali reports that A much more energetic response from the military is desperately needed.
