|
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=58607
) 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=59440
) 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=15362
) 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=31406
) 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=18721
) as subquery
World Association for Christian Communication
<< Back to organisation profile
Features
19.04.2002
Under a new project, UNDP and the Freeplay Foundation are set to ask Nigerienes to exchange illicit guns for radios. The aim is to help restore peace in the country and create new job opportunities.
Story link
Related topics/regions:
[Niger]
[capacity building]
[media technologies]
Image: Radios may finally bring the message of peace to Niger © BalkanLink
18.04.2002
Mitri Raheb uses an example from the Israeli-Palestinian conflict to illustrate how media control works.
Story link
Related topics/regions:
[Palestine]
[Israel]
04.04.2002
Advertising is a one-way barrage that, much as we'd like to, we can't avoid or reply to. WACC looks at the methods some groups are using to counter the powerful effect of the 'atmospheric pressure'.
Story link
06.03.2002
Isn't it ridiculous to suggest that mobile phones can improve the lives of rural poor people? The pre-industrial setting of rural Bangladesh is the location of a high-tech enterprise tipped as a model for communication and poverty reduction for the entire Third World. Sean Hawkey finds out in Bangladesh.
Story link
Related topics/regions:
[Bangladesh]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| < 7 >
| 8
| 9
| 10
| 11-13
| Next >>
|
|
|
|
