|
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=138125
) 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=136861
) 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=136522
) 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=136281
) 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=136195
) as subquery
Christian Science Monitor
<< Back to organisation profile
Features
22.08.2006
ULGARA, INDIA – A sprawling, yet largely hidden, war is raging in India's rural countryside, and after years of ignoring it, Delhi is signalling a military counteroffensive. India's Maoist insurgents, also called Naxalites, have expanded their area of operations from just four states 10 years ago to half of India's 28 states today.
Story link
Related topics/regions:
[India]
24.07.2006
The Pakistani government is seriously thinking of amending the Hudood ordinances - laws that govern and define behaviour for women and impose harsh penalties if violated - after a television channel had a debate on the controversial laws.
Story link
Related topics/regions:
[Pakistan]
17.07.2006
The militant group has transferred the Arab-Israeli conflict to Israeli territory for the first time in more than 50 years.
Story link
Related topics/regions:
[Israel]
[Palestine]
12.07.2006
The timing, just ahead of the G-8 summit, also draws parallels with last year's London bombings, says Anuj Chopra.
Story link
Related topics/regions:
[India]
10.07.2006
Faster than a speeding horse! Able to leap across Himalayan rivers in a single bound! It's ... Krrish!!
Story link
Related topics/regions:
[India]
Image: Krrish
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
