|
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=157500
) 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=157499
) 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=154914
) 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=153982
) 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=148029
) as subquery
Le Monde diplomatique
<< Back to organisation profile
Features
06.02.2008
Chalmers Johnson looks at 60 years of misallocation of resources in the US to the establishment and maintenance of a military-industrial complex as the basis of the nation's economic life.
Story link
Related topics/regions:
[Kosovo]
[Albania]
05.02.2008
President Suharto of Indonesia, who died last month, was responsible for the invasion of East Timor in 1975, for its occupation for almost 25 years, for the murder of so many of its people and for the insecure and traumatised state it remains in despite its emergence as a free, new country six years ago.
Story link
Related topics/regions:
[Timor-Leste]
[Indonesia]
Image: UNHCR workers remember their dead colleagues © Brennon Jones/OCPI/UNTAET
07.11.2007
When the US decided that its backyard would in future be a greater Middle East – from Pakistan to Morocco – it imagined that it could rearrange the region to suit itself. The results have been disastrous and will be long-lasting, says Alain Gresh.
Story link
Related topics/regions:
[United States]
[Middle East]
10.10.2007
The 'American Century' began only 60 years ago but seems already to be over, with the Iraq disaster forcing some of the U.S. ruling elites to realise that its hegemony has been severely weakened. Nobody seems to know what to do next, or even how to behave, says Philip S Golub.
Story link
Related topics/regions:
[United States]
08.04.2007
Since the famine of the 1840s Ireland has been a net exporter of economic migrants, who have settled round the world in search of a better life. Now immigrants from the world have arrived to do the same in booming Ireland, writes Colin Murphy.
Story link
Related topics/regions:
[Ireland]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-33
| Next >>
|
|
|
|
