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=158955
) 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=158327
) 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=153922
) 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=151206
) 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=150238
) as subquery
18.03.2008
Some Ugandan policymakers are seriously considering the results of a new study that recommends more funding for youth-friendly sex education and related services to stem the spread of HIV and other diseases.
28.02.2008
A large number of HIV+ women who get pregnant say they didn't intend to, but U.S.-funded programs to prevent HIV, which got a boost in spending yesterday, do not provide contraceptions.
12.10.2007
The number of induced abortions worldwide declined from nearly 46 million to under 42 million between 1995 and 2003, according to a new report.
12.07.2007
More than 100 million married women in developing countries are able to become pregnant but do not want to, and yet are not using contraception, according to a new report.
14.06.2007
Teen males in the United States today are having fewer sexual partners and are more likely to use condoms than generations past, but inadequate sex education policies and poorer access to healthcare are impeding their progress, says a sexual health advocate.