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=155750
) 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=155740
) 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=155654
) 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=155477
) 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=155456
) as subquery
30.11.2007
Hiv/aids-epidemian leviäminen on hidastunut, kertoo YK-järjestö UNAIDSin ja Maailman terveysjärjestö WHO:n tuore raportti (pdf, engl.). Toinen hyvä uutinen on, että maailmassa on vähemmän hiv:n kantajia kuin aiemmin on arvioitu.
28.11.2007
Around 15 organisations, on November 27, held a silent protest at New Delhi’s cultural hub Mandi House in support of Bangladeshi writer Taslima Nasreen, who has been in exile since 1994. Living in eastern Indian city of Kolkata since 2003, she had to recently move out when under pressure from Muslim fundamentalists, the West Bengal government forced her to leave at once.
22.11.2007
Bangladeshin hallituksen mukaan kansainvälinen yhteisö on tähän mennessä luvannut auttaa hirmumyrsky Sidrin uhreja 120 miljoonalla dollarilla. Euroopan komissio on luvannut apua noin kymmenen miljoonaa.
21.11.2007
The Vanasthali Rural Development Centre (VRDC) in Pune was started with a simple thought: to train rural women to enable them start balwadis or nurseries in their villages. Years later, activist Nirmala Purandare's dream has heralded a social revolution with the training of barefoot teachers in the Indian state of Maharashtra.