
|

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=158153
) 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=158063
) 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=157970
) 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=157846
) 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=157839
) as subquery
Inter Press Service (IPS)
<< Back to organisation profile
Features
21.02.2008
NEW YORK, Feb 19 (IPS) - As the United States moves towards holding death-sentence trials for six Guantanamo Bay detainees alleged to have plotted the Sep. 11 attacks, legal scholars and human rights advocates are questioning not only the six-year-long process and timing of the charges, but also whether the accused could ever receive fair trials.
Story link
Related topics/regions:
[United States]
15.02.2008
MANILA, Feb 14 (IPS) - Non-government organizations (NGOs) opposed to the presence of United States troops in the country are calling for a suspension of U.S.-Philippine joint military exercises scheduled for Feb. 18.
Story link
Related topics/regions:
[United States]
[Philippines]
14.02.2008
Creating a "pivotal" moment in Malaysian history, human rights activists and other non-governmental leaders are mobilizing to participate in the upcoming general elections, unexpectedly announced alongside Prime Minister Abdullah Badawi's dissolution of parliament this Wednesday.
Story link
Related topics/regions:
[Malaysia]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| < 6 >
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
 |


|
 |