|
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=157625
) 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=157212
) 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=157012
) 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=157011
) 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=157001
) as subquery
OneWorld UK
<< Back to organisation profile
Features
08.02.2008
Lehmien päästelemät kaasut ja virtsa menevät nyt Kiinassa hyötykäyttöön, sillä maassa avattiin äskettäin maailman tiettävästi suurin lehmien jätökset hyväksikäyttävä voimalaitos. Se tuottaa paitsi 30 000 kilowattituntia sähköä päivässä, myös 200 000 tonnia luonnonmukaista lannoitetta vuodessa.
Story link
Related topics/regions:
[China]
25.01.2008
Keniassa presidentti ja oppositiojohtaja ovat tavanneet toisensa ensimmäistä kertaa joulukuun kiisteltyjen vaalien jälkeen, ja sovunhieronta on alkanut ainakin virallisesti. Mutta mitä tapahtuu Nairobin kaduilla ja slummeissa, ja mitä mieltä tavalliset kansalaiset ovat johtajistaan?
Story link
Related topics/regions:
[Kenya]
22.01.2008
Confused about GSPs, EPAs and TRIPS? The new OneWorld Guide to Trade and Poverty suggests keeping it all simple. If the EU and US won't cut their farm subsidies without conditions, then the rest of the detail probably isn't worth bothering about.
Story link
21.01.2008
Still Life starts with a huge advantage: it is set in a town being demolished brick by brick, stone by stone, before being flooded by China’s vast Three Gorges dam.
Story link
Related topics/regions:
[China]
21.01.2008
Like all docudramas, Battle for Haditha raises the issue of the ethics of imagining a real event – in this case, the retaliatory massacre of 24 Iraqis after a roadside bomb killed two US soldiers – and presenting it as a drama.
Story link
Related topics/regions:
[Iraq]
[United States]
<< Previous
| 1
| 2
| 3
| 4
| < 5 >
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
