|
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=144028
) 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=143706
) 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=141570
) 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=141351
) 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=141347
) as subquery
InfoChange
<< Back to organisation profile
Features
19.12.2006
Farmers in Raigad district, in the west Indian state of Maharashtra, use satellite imagery to prove that their lands are fertile, thus thwarting the government's move to acquire their lands for the development of a Special Economic Zone (SEZ) at cheap rates by claiming it was not productive land.
Story link
Related topics/regions:
[India]
[human rights & ICT]
[Internet]
Image: Indian farmers burn genetically modified crop © Inter Continental Caravan
12.12.2006
Trade losses to software manufacturers due to piracy are as high as $125 billion. We need to interrogate why piracy of software, books, music etc exists as a market phenomenon. Could it be an organic market reaction to the exclusion of consumers by copyright industries? Lawrence Liang and Achal Prabhala take an indepth look into the prevailing market trends and consumer behaviour.
Story link
Related topics/regions:
[South Africa]
[India]
[civil society & ICT]
[economy]
Image: © Linux - software liberi
26.10.2006
India ranks low once again on the Global Hunger Index, confirming what development experts have been saying all along--that the country's economic boom is not being matched by corresponding levels of progress in the human development indices
Story link
24.10.2006
Even though local authorities have been asked to prepare to accommodate thousands of Indian children expected to be freed from their jobs by raids conducted on homes and restaurants, activists say scant attention has been paid to how they will be rehabilitated.
Story link
Image: Child Labour
23.10.2006
Even though local authorities have been asked to prepare to accommodate thousands of Indian children expected to be freed from their jobs by raids conducted on homes and restaurants, activists say scant attention has been paid to how they will be rehabilitated.
Story link
Related topics/regions:
[India]
Image: Child Labour
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
