
|

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=134135
) 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=134328
) 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=127888
) 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=124719
) 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=120437
) as subquery
Practical Action
<< Back to organisation profile
Features
09.06.2006
Nepalese families in remote mountainous areas of the country are now using simple, inexpensive and environmentally friendly gravity ropeways to get their crops to market. Find out more.
Story link
Related topics/regions:
[Nepal]
Image: Janagaon Ropeway © Mahendra
20.02.2006
Every day more than 4,000 men, women and children in the world’s poorest countries die from lethal levels of smoke in their homes. Smoke from cooking fires causes 1.6 million deaths a year, more than malaria. Join Practical Action’s campaign for urgent action to stop the killer in the kitchen.
Story link
Image: Young children exposed to cooking smoke, Nepal © Practical Action
Anniversary of a catastrophe
Related topics/regions:
[Asia and the Pacific]
Image: Sarvodaya volunteers from Singapore schools pack tsunami relief supplies © Peter Armstrong
13.10.2005
Climate change has taken an increasing toll on the poorest and most remote communities in the Andes, as they face bitterly cold winters that kill the alpacas on whom they depend. Simple shelters, together with hydroponic food-growing techniques and training, could make the difference this winter.
Story link
Related topics/regions:
[South America]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| Next >>
|
 |


|
 |