|
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=160857
) 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=160824
) 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=160799
) 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=160758
) 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=160511
) as subquery
Inter Press Service (IPS)
<< Back to organisation profile
Features
12.06.2008
JEBALIYA REFUGEE CAMP, Gaza, Jun 11 (IPS) - In the brightly painted new intensive care unit wing of al-Awda, northern Gaza's only emergency medical facility in the massive Jebaliya refugee camp, doctors, nurses, aides, and administrators are ready to provide emergency surgery services for the area's 300,000 people.
Story link
Related topics/regions:
[Israel]
[Palestine]
Image: Kids in the Gaza strip. © Thatcher Cook / Mercy Corps
09.06.2008
WASHINGTON, Jun 6 (IPS) - While Republicans succeeded Friday in effectively killing major bipartisan legislation in the U.S. Senate to cut greenhouse emissions that contribute to global warming, environmental groups expressed hope that the three days of debate on the measure have set the stage for success next year after the November elections.
Story link
Related topics/regions:
[United States]
Image: Senator Joe Lieberman was a chief sponsor of the Climate Security Act.
05.06.2008
BEIJING, Jun 4 (IPS) - Unprecedented food scarcity is beginning to dictate the rules of a new political order where individual countries are scrambling to secure their own food supplies with little concern for the rest of the world, says the founder of the Earth Policy Institute.
Story link
Related topics/regions:
[China]
31.05.2008
CAPE TOWN, May 30 (IPS) - When four-year-old Alice Were suddenly developed a fever, her mother Miriam took her to the local medicine woman close to her house in Kangemi, a poor, cramped settlement on the outskirts of the Kenyan capital, Nairobi. Two days later, Alice was unconscious. Her frantic mother rushed to hospital with the child in her arms. But it was too late. Alice died of malaria.
Story link
Related topics/regions:
[Africa]
13.05.2008
FALLUJAH, May 12 (IPS) - Sharp increases in food prices have generated a new wave of anti-occupation and anti-U.S. sentiment in Fallujah.
Story link
Related topics/regions:
[Iraq]
[United States]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
