|
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=111078
) 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=111068
) 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=110788
) 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=110471
) 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=110152
) as subquery
OneWorld South Asia
<< Back to organisation profile
Features
10.05.2005
Experts have raised concerns over undue haste in declaring India a `leprosy free country’ as this will slacken the vigil against the disease, which still might be lurking in various parts of the country.
Story link
Related topics/regions:
[India]
10.05.2005
When Brijesh Dubey came face-to-face with the reality that he was infected with HIV he fought not only for survival but for a life of dignity and counseled people to tide over the trauma of being HIV positive. To know more on his journey read through….
Story link
Related topics/regions:
[India]
05.05.2005
Prof. Paul Sturges of the Loughborough University speaks on Copyright in the Digital Era in New Delhi and says that policies that bring benefits to the whole community should be encouraged and that it is important for the public sector and the civil society to understand the current trends in copyright. Read report by OneWorld South Asia's Madhu Arora and Veronica Peris.
Story link
29.04.2005
A five-member task force, constituted by the Indian government in March 2005 to save the fast-dwindling tiger in the wake of disappearance of the big cat from a north Indian sanctuary, has laid out its plan of action to save the tiger from extinction. Rahul Kumar writes this report from New Delhi.
Story link
Related topics/regions:
[India]
Image: Tigers: On the verge of extinction
26.04.2005
Dr Suman Mehta, associate director of Joint United Nations Programme on HIV/AIDS (UNAIDS), who is responsible for providing policy and programme support on HIV/AIDS to countries in Asia, Pacific, Middle East and North Africa, speaks to Rajiv Tikoo of OneWorld South Asia about the 3 by 5 Progress Report and on the progress and the challenges in mainstreaming HIV/AIDS.
Story link
<< Previous
| 76-85
| 86
| 87
| 88
| 89
| 90
| 91-100
| 101-110
| 111-120
| 121-130
| Next >>
|
|
|
|
