|
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=160979
) 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=160943
) 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=160895
) 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=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
Inter Press Service (IPS)
<< Back to organisation profile
Features
27.06.2008
ASUNCION, Jun 26 (IPS) - Paraguay's public hospitals are on the verge of collapse, due to a lack of resources for responding to the wave of southern hemisphere winter illnesses. The first measure to be adopted by the new government that will take over in August will be to declare a "social emergency" in healthcare, the future health minister told IPS.
Story link
Related topics/regions:
[Paraguay]
24.06.2008
UNITED NATIONS, Jun 23 (IPS) - Two years after the African Union mandated Senegal to conduct the trial of Chadian dictator Hissene Habre, who is accused of thousands of political murders during his eight-year reign, the prosecution remains in limbo, six human rights groups complained in a joint statement Monday.
Story link
Related topics/regions:
[Senegal]
[Chad]
17.06.2008
BANGKOK, Jun 16 (IPS) - Cambodian lawmakers are still to offer unanimous support for a petition aimed at combating corruption that was presented to the National Assembly in mid-May. The call was a cry from ordinary people -- over a million of them.
Story link
Related topics/regions:
[Indonesia]
[Cambodia]
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.
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
