|
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=149194
) 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=144225
) 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=144321
) 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=140725
) 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=140707
) as subquery
OneWorld TV
<< Back to organisation profile
Features
14.05.2007
When the largest collection of chemical explosives ever found in a British home was discovered by the police, along with a rocket launcher and biological fall-out suit, it was not seen as a threat to the public, or even considered newsworthy.
Story link
Related topics/regions:
[United Kingdom]
02.01.2007
More than 105,000 young people from 37 African countries have taken part in a series of contests designed to come up with ideas for short films on HIV and AIDS. Some of the resulting 28 films are touching, some are funny. See the clips.
Story link
Related topics/regions:
[Africa]
Image: Scenarios from Africa
29.12.2006
More than 100,000 young people from 37 African countries have taken part in a series of contests to come up with ideas for short films on HIV and AIDS. Some of the resulting 28 films are touching, some are funny. See them on OneWorld TV.
Story link
Image: Scenarios from Africa
12.10.2006
Leading off OneWorld TV's new video podcasts is an exclusive interview series with those at the cutting edge of using video for social change.
Story link
11.10.2006
Leading off OneWorld TV's new video podcasts is an exclusive interview series with those at the cutting edge of using video for social change.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-15
| Next >>
|
|
|
|
