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=132694
) 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=97209
) 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=92483
) as subquery
Charkha development Communication Network
Charkha aims to manage and administer a development communication network to disseminate information and educate underprivileged section of the community.
12.05.2006
Water scarcity is not something new. It haunts many places in Gujarat. But what is new is that inspite of water shortage there are many villages in Gujarat which have faced the drought successfully. These villages could save themselves from the drought because they welcomed the Roof Rain Water Harvesting Structure (RRWHS) introduced by the Aga Khan Rural Support Program (AKRSP), says Aditi Varma from Charkha.
03.11.2004
Charkha Development Communication Network has announced three media fellowships for journalists and others writing on peace and development in Kashmir Valley, Jammu and Ladakh region. The Charkha Sanjoy Fellowships for Peace and Development were initiated last year. Read Press Release and Details of the Scholarship.
24.08.2004
An Indian NGO is conducting audience research as the first step towards launching a community radio project in the country’s Jharkhand state. The World Bank-funded initiative will give rural communities a chance to raise issues that concern them through programmes broadcast from the government-run radio station.
