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=80091
) 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=79020
) 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=78139
) 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=77208
) 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=76236
) as subquery
Leadership Conference on Civil Rights/Leadership Conference Education Fund
25.02.2004
"Unamerican, shameful, and divisive." These strong words characterize Pres. Bush's support for a Constitutional ban on gay marriage, according to a rights group defending sexual freedom of choice. The U.S. branch of Amnesty International has compiled a chilling dossier on police brutality toward gay, lesbian, and bisexual Americans.
12.02.2004
The "Fairness Act," introduced in Congress this week, is getting strong backing from civil rights groups that believe U.S. courts are taking away many rights guaranteed by the Constitution. "That's just not right," says the head of the Leadership Conference on Civil Rights, which has issued a Special Report on the topic.
02.02.2004
The state of the Indian nation in the United States is not good, the President of the Congress of American Indians warned in a recent speech. As detailed in a report by the U.S. Civil Rights Commission, many Native Americans face grinding poverty and high rates of disease, and federal management of tribes' funds is woefully inadequate.
21.01.2004
The broad coalition of groups that convinced the Senate to twice reject the appointment of Thomas Pickering as a Circuit Court of Appeals judge is furious with Pres. Bush's use of a back-door maneuver to appoint him anyway. Civil rights groups are particularly incensed that Bush chose the Martin Luther King holiday to do so.
07.01.2004
How will you commemorate Dr. Martin Luther King Jr.'s 75th birthday? Help civilrights.org promote MLK Day by sharing what your organization will be doing to celebrate. Please email event and activity details to
editor@civilrights.org.
