|
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=101305
) 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=101063
) 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=101023
) 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=101058
) 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=100820
) as subquery
InfoChange
<< Back to organisation profile
Features
13.01.2005
People of Sohangarh village in Deogarh block of the Rajsamand district in western Indian state of Rajasthan has brought an economic turnaround by reviving twenty five hectares of common pastureland.
Story link
Related topics/regions:
[India]
12.01.2005
The tsunami disaster not only took lives and destroyed properties of people on the coastlines, but also wiped out the livelihoods of innumerable fishermen in India who lost boats and fishing nets, plunging them further into a crisis.
Story link
Related topics/regions:
[India]
10.01.2005
Rumours of contamination of fishes in coastal areas of India and Sri Lanka has hit the fishing industry hard as people have stopped consuming fishes in large parts of India. Even though experts and the government have allayed the fears, people continue to believe the rumours.
Story link
Related topics/regions:
[India]
[Sri Lanka]
10.01.2005
A new report by India’s national commission for women reveals that violence against women and increased alcoholism are the direct outcomes of ‘development-induced’ displacement in India.
Story link
Related topics/regions:
[India]
04.01.2005
A week after one of the world’s worst natural disasters, the focus of the UN’s multi-agency relief effort is shifting to caring for the millions of people displaced by the tsunami tragedy.
Story link
Related topics/regions:
[East Asia]
[South Asia]
[South East Asia]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| < 10 >
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
