|
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=159564
) 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=158452
) 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=158451
) as subquery
Le Monde diplomatique
Le Monde diplomatique est une publication mensuelle qui analyse en profondeur les évolutions économiques, sociales, politiques, idéologiques et religieuses qui traversent les nations et sous-tendent les rapports de forces entre États.
Main Address
21 bis, rue Claude Bernard
75242 Paris cedex 05
Main Telephone
(33)-1.42.17.37.48/42.17.29.16
Joined OneWorld
01.07.1998
Features
10.04.2008
China is worried that the recent resentment and resistance among the Tibetans could spread to other major minorities whose traditional territories have been colonised and exploited by the majority Han Chinese. The Tibetans clearly want some form of autonomy, which they will not get, says Mathieu Vernerey.
Story link
Related topics/regions:
[Tibet]
[China]
05.03.2008
Chad ranks near the bottom of almost every world league table, poor, corrupt and lawless – and now under direct attack by rebels operating out of a base in Darfur in an invasion co-ordinated by Sudan, says Gérard Prunier.
Story link
Related topics/regions:
[Chad]
[Sudan]
04.03.2008
They were murderers, rapists, torturers, butchers and their victims in Sierra Leone’s civil war. Now – for the moment, since diamond-funded conflict and chaos could return at any time, says Angela Robson – they try to fight in less destructive ways and resume the real lives they can barely remember.
Story link
Related topics/regions:
[Sierra Leone]
|
|
|
|
