|
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=148278
) 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=148025
) 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=148131
) 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=148058
) 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=147864
) as subquery
openDemocracy
<< Back to organisation profile
Features
18.04.2007
An imaginative collaboration of stakeholders in the global south’s textile industry offers a new model for reviving the stalled world-trade talks, says Simon Zadek.
Story link
13.04.2007
Khanty-Mansiysk is a Siberian city where the roads have no pot holes and fast Internet connections are freely available. It is also home to the production of more than half of Russia's crude oil.
Story link
Related topics/regions:
[Russian Federation]
12.04.2007
The notion of sustainability has entered the development lexicon. Michael Hopkins asks why it took so long and how the idea has been transformed in its encounter with reality.
Story link
10.04.2007
The future of a country riven by clan rivalries, regional fissures and international ambitions will be decided in its capital city, says Harun Hassan.
Story link
Related topics/regions:
[Somalia]
03.04.2007
Suhas Chakma argues that the Indian government cannot respond to the blunt brutality of Maoist insurgents with equal ruthlessness.
Story link
Related topics/regions:
[India]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-42
| Next >>
|
|
|
|
