|
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=153879
) 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=153588
) 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=153473
) 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=147115
) 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=144680
) as subquery
MISNA
<< Back to organisation profile
Features
05.10.2007
The presidents of North and South Korea have signed a historic and permanent peace accord, and the North announced that its main nuclear facility will be dismantled.
Story link
Related topics/regions:
[North Korea]
[South Korea]
Image: Closer ties between the two Koreas
27.09.2007
Until Israel gives further word the West Bank border passings will be open only for humanitarian emergencies due to the "significant terror threat" during the Jewish holiday Sukkot, which lasts a week.
Story link
Related topics/regions:
[Palestine]
[Israel]
24.09.2007
Buddhist monk-led protests against the military dictatorship of Myanmar -- formerly Burma -- have grown to include record numbers of civilians Monday, according to local sources in the tightly controlled country. It's unclear why the junta has not forcibly put down these protests, or why the jailed opposition leader Aung San Suu Kyi was allowed to greet protesters over the weekend.
Story link
Related topics/regions:
[Myanmar]
14.03.2007
In Kenya circolano 100.000 armi illegali, cioè una ogni 300 keniani, secondo stime del governo citate in un'inchiesta pubblicata sull’edizione domenicale del quotidiano The Nation dal titolo '100.000 ragioni per avere paura' - riporta l'agenzia Misna. Il problema della microcriminalità e della sicurezza nelle strade, in particolare nei centri urbani, sta diventando un problema molto sentito in Kenya, che rischia di avere anche ripercussioni politiche. “A Nairobi le armi sono usate per aggressioni agli automobilisti e furti, e possono essere facilmente “affittate per 1.000 scellini (11 euro) in alcune parti di Eastlands”, uno dei quartieri più poveri della capitale. Sembra inoltre che nel paese si possa acquistare un fucile Ak-47 con 20.000 scellini (220 euro).
Story link
Image: Armi illecite sequestrate
09.01.2007
"The scandal of hunger, that tends to worsen, is unacceptable in a world that has the goods, the know-how, and the means to end it," said Pope Benedict XVI Monday in his annual speech to diplomats.
Story link
Related topics/regions:
[Africa]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
