|
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=132577
) 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=109017
) 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=93855
) as subquery
ORBIS UK
ORBIS UK is a leading international sight saving NGO, created in 1982 to eliminate avoidable blindness. We work in partnership with local health professionals and members of the community to improve the quality of eye care available for people where the need is greatest. To date, our training and skills programmes have enabled 70,000 medical professionals in 76 countries to give 17.5 million people back their sight and their future.
We have established sustainable local offices in India, Bangladesh, China, Vietnam and Ethiopia and are a leading member of the WHO Vision 2020- right to sight initiative.
Main Address
4th Floor
Fergusson House
124–128 City Road
London EC1V 2NJ
Main Telephone
0207 608 7260
Joined OneWorld
26.10.2005
Features
10.05.2006
Mondays are now the day for a flutter, with more than 70 charities benefiting from the new online lottery.
Story link
Related topics/regions:
[United Kingdom]
Image: Monday, the charities lottery
07.04.2005
World Health Day tends to focus on life-threatening issues such as malaria and child mortality. We should also remember the sight-saving work of organisations like the ORBIS Flying Eye Hospital. Here an eye surgeon is interviewed about his first visit to India.
Story link
Related topics/regions:
[India]
12.09.2004
The Cyber-sight program of Orbis International links specialist ophthalmologist volunteer telementors with partner organisations in the developing world for discussion of specific cases requiring treatment. Clinical pictures and history are available through a special website.
Story link
Related links
|
|
|
|
