|
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=128469
) 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=127401
) 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=126636
) 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=122684
) 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=122542
) as subquery
Leadership Conference on Civil Rights/Leadership Conference Education Fund
<< Back to organisation profile
Features
28.02.2006
A lawyer who fought to end racial segregation in U.S. housing in the 1970s calls the problem "the hardest issue in America relating to race relations," but offers a proposal for eliminating the "black ghetto."
Story link
Related topics/regions:
[United States]
Related links
15.02.2006
Despite achieving remarkable growth in the last decade, tribal nations continue to lack resources, said National Congress of American Indians president Joe Garcia recently, noting that their success still depends on U.S. government investment as well as its respect for tribal rights.
Story link
Related topics/regions:
[United States]
02.02.2006
A champion of economic and social justice throughout the world, Coretta King worked tirelessly to promote human and civil rights in the decades following her husband's assassination. While her passing is a deep loss to the civil rights movement and America as a whole, we must follow her example and recommit ourselves to the social justice agenda, says Civilrights.org.
Story link
Related topics/regions:
[United States]
Image: Hurricane Katrina was a painful wake-up call to the deep inequalities within American society and why Coretta King's work must be continued. © In These Times
23.11.2005
A multi-lingual poll designed to gauge public opinion on national issues in the aftermath of Hurricane Katrina has shown that poverty at home is a more important issue to U.S. residents than fighting terrorism and establishing democracies in Iraq and Afghanistan.
Story link
Related topics/regions:
[United States]
Image: Hurricane Katrina shone a spotlight on poverty in the U.S. © In These Times
21.11.2005
U.S. Supreme Court nominee Samuel Alito, whose nomination will be voted on by senators in January, would be a "threat to civil rights" if confirmed, said a 55-year-old coalition of nearly 200 prominent U.S. civil rights organizations Thursday.
Story link
Related topics/regions:
[United States]
Image: © Leadership Conference on Civil Rights
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| < 8 >
| 9
| 10
| 11-20
| 21-30
| 31-34
| Next >>
|
|
|
|
