|
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=138786
) 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=138555
) 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=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
Christian Science Monitor
<< Back to organisation profile
Features
05.09.2006
After more than a week of fighting with the Tamil Tigers, the Sri Lankan Army Monday captured a strategically important rebel position. The Tigers retreated from Sampur without much resistance, following days of pounding from the military's Israeli-made Kfir jets.
Story link
Related topics/regions:
[Sri Lanka]
31.08.2006
For years, Nawab Mohammed Akbar Khan Bugti battled the Pakistan Army. The 80-year-old renegade hidden in the mountains of Balochistan became a legend in his fight for greater autonomy against what he saw as colonial brutality.
And his death this weekend, during a fierce three-day battle that left more than 30 dead, could prove a serious blow to Pakistan's stability.
Story link
Related topics/regions:
[Pakistan]
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]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
