|
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=160733
) 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=158441
) 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=154880
) as subquery
American Friends Service Committee
AFSC is a faith-based organization working for peace, justice and reconciliation in 22 countries of the world. With national headquarters in Philadelphia and 9 regional offices throughout the United States, AFSC emphasizes people, not politics or ideology – upholding the dignity and promise of every person.
Main Address
1501 Cherry Street
Philadelphia, PA 19106
Main Telephone
215-241-7060
Joined OneWorld
23.04.2003
Features
29.05.2008
As a national conference to end solitary confinement in U.S. prisons gets underway this week, activists offer a wealth of resources on the subject, including prisoner testimonies.
Story link
Related topics/regions:
[United States]
03.03.2008
Peace advocates are calling on Americans to hold events in their hometowns the day after the 4,000th U.S. military death in Iraq is announced.
Story link
Related topics/regions:
[United States]
[Iraq]
Related links
06.11.2007
This year a delegation of interfaith peace advocates joined Palestinians to celebrate their annual olive harvest and meet with locals working for peace and justice.
Story link
Related topics/regions:
[Palestine]
[Israel]
Related links
|
|
|
|
