|
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=153628
) 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=151337
) 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=148735
) as subquery
Independent Media Center
The Indy Media Center is a coalition of many independent media organizations and producers, offering coverage of the upcoming WTO protests ignored by the corporate media.
Main Address
1415 Third Ave.
Seattle 98101
Main Telephone
206-261-0184
Joined OneWorld
05.01.2001
Features
28.09.2007
The Movement for the Emancipation of the Niger Delta (MEND) recently declared war on the Nigerian government and oil companies, demanding that local communities see benefits from the billions of dollars of oil removed from the region.
Story link
Related topics/regions:
[Niger]
[Nigeria]
Related links
17.07.2007
In the U.S. state of Louisiana, an all-white jury heard a series of white witnesses called by a white prosecutor to testify in a courtroom overseen by a white judge. On trial was a black student, accused of hitting a white peer.
Story link
Related topics/regions:
[United States]
02.05.2007
"Estos espías y orejas han comprobado que el EZLN no está promoviendo la lucha armada, sino la organización civil de la gente. Saben que, a diferencia de los partidos políticos, no estamos diciendo mentiras, sino escuchando y haciéndonos eco de las injusticias que sufre nuestro pueblo..."
Story link
Related topics/regions:
[Mexico]
|
|
|
|
