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=67304
) 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=65630
) 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=62722
) 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=65817
) 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=60421
) as subquery
04.09.2003
The online newspaper Reznet not only helps more American Indian students get a taste of the journalism field, but it is also a gathering place for Indian youth on the Internet. The Website has provided young Native Americans a new voice – literally – by broadcasting a weekly audio news show.
12.08.2003
Communities in the US and the UK are allowing their children to walk to schools in groups, instead of buses. The concept called - the walking school bus - involves children walking to their school in a group along with volunteers or with parents. It keeps them healthy and brings down emissions.
01.07.2003
In four years of heavy media consolidation in the Los Angeles area, the amount of programming for children was cut in half, and one Viacom-owned station dropped their children's offerings from 26 hours per week to only three. When decisions about what to show move from the community to Wall Street, kids may be the big losers, warns communications policy expert Norris Dickard.
24.06.2003
In a unique programme in Michigan, children grow organic vegetables and sell these in the farmer's market. The hands-on initiative, Under the Roots and Shoots Youth Oriented Garden Project, educates children on business practices and agriculture.
26.05.2003
The push to increase health insurance for low-income children seems to be working. A report by The Future of Children finds the goal of universal coverage much closer, with 88 percent of all children in the US insured.
