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=91301
) 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=89769
) 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=89580
) 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=86224
) 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=85872
) as subquery
05.08.2004
Everyone needs and wants to communicate, and they do so with the tools at hand. Africa's needy urban people are using the most readily available communication technology for them, mobile phones, in innovative ways. But there is still a question over whether this access gives them true inclusion in the global "information society" the people with access to communication technologies and the information they share.
12.07.2004
In the midst of the current enthusiasm for "ICTs for development", it is often forgotten that most rural Africans do not yet even have access to telephones. Initiatives such as the World Summit on the Information Society aspire to bridge the digital divide in order to reduce poverty and achieve the Millennium Development Goals, but this aim risks being undermined if basic telephone connectivity is not first made available.
08.07.2004
The Panos Global AIDS Programme (GAP) will be running a series of activities and producing resources for the media around the XV International AIDS Conference in Bangkok, July 11th to 16th, for both media attending the Conference and for those who are not. The Panos GAP is a network of Panos offices from Africa, Asia, the Caribbean and Europe. It aims to support in-depth, balanced media reporting in the South and to provide a Southern perspective to media in the North.
18.05.2004
In most of rural Africa there is still only one telephone for every thousand people. Yet, the use of mobile phones in cities has risen dramatically over the past decade. A new Panos report (pdf) asks whether mobile services will become cheap enough for rural needs or are fixed-lines and subsidies really what's needed?
12.05.2004
A study shows despite strong growth in landline and mobile telephony in African cities, rural areas still thirst for cost effective telephone connections.
