|
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=160657
) 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=160652
) 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=160603
) 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=160576
) 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=159640
) as subquery
International Rescue Committee
<< Back to organisation profile
Features
24.05.2008
International aid workers are welcoming today's announcement that they will be allowed into Myanmar (formerly Burma) even as they "seek clarity" about the terms of their engagement in the cyclone-damaged country.
Story link
Related topics/regions:
[Myanmar]
23.05.2008
A "child survival program" treats children under the age of five for life-threatening disease in the Kono District of Sierra Leone, one of the areas hit hardest by the country's 10-year civil war.
Story link
Related topics/regions:
[Sierra Leone]
Related links
20.05.2008
Florence Okot and dozens of other HIV-positive women in northeastern Uganda have birthed healthy babies thanks to a new program focused on preventing mother-to-child transmission of HIV.
Story link
Related topics/regions:
[Uganda]
Related links
16.05.2008
Visit some of the specials spaces set aside for youth in a refugee camp in Darfur, where children of all ages can go to play, learn, and begin the healing process. [Scroll down to view video.]
Story link
Related topics/regions:
[Sudan]
Related links
10.04.2008
As the Nepalese vote in the country's first elections in almost a decade, a photoessay explores the election's significance in rural Nepal, where poverty is rife and many lives have been scarred by the recent civil war.
Story link
Related topics/regions:
[Nepal]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| Next >>
|
|
|
|
