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=160792
) 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=160142
) 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=160064
) 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=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
04.06.2008
Fertility rates in Central America far exceed the Latin American average because Central American youth lack access to sex education, contraceptives, and youth-oriented policies, says a new study by a sexual health institute.
25.04.2008
Over 3,000 Nigerian women die each year due to complications resulting from unsafe abortions, says a new study from a sexual and reproductive health institute.
23.04.2008
Innovative Medicaid family planning expansions designed by state officials have hugely benefited the provision and accessibility of health care coverage for low-income people across the United States, says a new report from a reproductive health institute.
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.