|
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=134433
) 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=134307
) 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=133099
) 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=131131
) 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=130332
) as subquery
Leadership Conference on Civil Rights/Leadership Conference Education Fund
<< Back to organisation profile
Features
08.06.2006
A US Supreme Court decision has dealt "a substantial blow to civil rights" with its ruling that a government employee is not protected by the First Amendment right of free speech as part of performing job-required duties.
Story link
Related topics/regions:
[United States]
07.06.2006
Civil rights groups say the bill, passed on May 25, does not go far enough in fixing the nation's broken immigration policies. While they admit the bill is a valiant attempt, the groups are concerned with provisions that strip immigrants of basic civil liberty protections.
Story link
Related topics/regions:
[United States]
19.05.2006
The Bill of Rights and other constitutional amendments largely exist to expand Americans' liberties, not restrict them, say civil rights leaders denouncing the amendment to ban same-sex marriage that Congress is now considering--just months before crucial mid-term elections.
Story link
Related topics/regions:
[United States]
Related links
18.04.2006
Native peoples are still trying to vote in Alaska because the US state has not fully complied with provisions of the Voting Rights Act of 1965, charges a new report.
Story link
Related topics/regions:
[United States]
05.04.2006
Help stop the criminalization of immigrant communities by joining Civilrights.org on April 10th at a massive nationwide rally. Find out what's going on in your city!
Story link
Related topics/regions:
[United States]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| < 7 >
| 8
| 9
| 10
| 11-20
| 21-30
| 31-34
| Next >>
|
|
|
|
