|
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=158450
) 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=156344
) 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=155695
) 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=155554
) 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=155489
) as subquery
Oxfam International
<< Back to organisation profile
Features
04.03.2008
A large-scale military attack on the densely populated Gaza Strip will worsen already unacceptable levels of civilian casualties, a leading international charity warned.
Story link
Related topics/regions:
[Palestine]
[Israel]
29.11.2007
The pharmaceutical industry is denying medicines to millions of poor people and undermining its own future because companies are refusing to change the way they do business in developing country markets, according to a new report.
Story link
Related links
26.11.2007
Natural disasters have quadrupled over the last two decades, from an average of 120 a year in the early 1980s to as many as 500 today, says a new report, "Climate Alarm".
Story link
Related links
22.11.2007
A warning of an increasing public health risk in Gaza has been given by an international development group as water and sanitation services begin to buckle under the strain of Israel's restrictions on fuel, vital maintenance goods and spare parts.
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-48
| Next >>
|
|
|
|
