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=112374
) 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=110742
) 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=109292
) 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=102940
) 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=101772
) as subquery
01.06.2005
While girls' education and equality are major international development goals, the difficulties faced by the fairer sex is often overlooked in the world's most prosperous country. A former girl gang member has founded the Blossom Program for Girls in her Brooklyn neighborhood, where 72 percent of children are born into poverty and girls are particular victims of the poverty and violence around them.
05.05.2005
Young people in the foster care system will discuss their concerns, challenges and aspirations–and answer questions–in an online discussion on May 11 at 1 p.m. ET. Submit pre-questions to
rob@connectforkids.org and join in the live chat!
13.04.2005
The U.S. Congress is working on a budget that could include deep cuts in basic programs for children and families. Tell Congress you're willing to pay your fair share in taxes, but not for a budget that gives the affluent more than their fair share while cutting food stamps, health care and child care assistance for kids and families, says Connect for Kids on April 12--"National Budget Call-in Day."
09.02.2005
Did your fifth-grader use the school computer to research her report on alligators? Is your son's asthma regularly checked by the school nurse? Do you know a young person who had a summer job last year? Have you ever been to the zoo? Federal spending cuts could affect your life in ways you might never even consider, says Connect for Kids advocacy director Jan Richter.
20.01.2005
The U.S. Supreme Court is expected to rule soon on whether or not 16- and 17-year-olds can be put to death for heinous crimes. Proponents of the death penalty for juveniles say there's nothing magic about the age of 18.