|
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=156274
) 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=156197
) 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=156157
) 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=156096
) 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=156090
) as subquery
OneWorld South Asia
<< Back to organisation profile
Features
19.12.2007
YK:n yleiskokous teki tiistaina historiallisen päätöksen, kun se hyväksyi päätöslauselman kuolemanrangaistuksen kieltämiseksi. Päätös ei kuitenkaan sido jäsenmaita.
Story link
17.12.2007
For visually challenged people in western Indian state of Maharashtra, the life will become much easier with the setting up of a special resource centre in Pune. The centre will provide them 100 different services and equipment under one roof like medical treatment, walking sticks, audio calculators, braille watches, computer software, etc.
Story link
Related topics/regions:
[South Asia]
Image: Blind people sign
14.12.2007
Arviolta jo 40 prosenttia maailman lääketesteistä tehdään Aasiassa, Itä-Euroopassa ja latinalaisessa Amerikassa. Erityisesti hämäräperäisemmät testit tehdään maissa, joissa kokeita ei ole rajoitettu tiukin säädöksin.
Story link
12.12.2007
To remind the Indian government of its own promises that it had made by ratifying the UN Child Rights Convention fifteen years ago on this day (December 11), Child Rights and You (CRY) held a press conference in New Delhi.
Story link
Related topics/regions:
[South Asia]
12.12.2007
Magsaysay awardee Rajender Singh spoke to OneWorld South Asia, on December 9, in an interview after the culmination of nine-day long march to save the groundwater resources. His satyagrah on the banks of the Yamuna in New Delhi has been going on for the past more than 100 days. Following are the excerpts:
Story link
Related topics/regions:
[South Asia]
<< Previous
| 6-15
| 16
| 17
| 18
| < 19 >
| 20
| 21-30
| 31-40
| 41-50
| 51-60
| Next >>
|
|
|
|
