
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=76230
) 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=74610
) 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=74185
) 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=74184
) 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=71685
) as subquery
Committee to Protect Journalists
<< Back to organisation profile
Features
06.01.2004
Thirty-six journalists were killed worldwide as a direct result of their work in 2003, according to the Committee to Protect Journalists. That's a sharp rise over 2002, when 19 journalists were killed in the line of duty. The war in Iraq was the main reason for the increase.
Story link
05.12.2003
A leading media watchdog group is decrying the death sentence of a Burmese sports writer accused by the military regime of "high treason," possibly stemming from a magazine article questioning the junta's use of funds intended for promoting soccer.
Story link
Related topics/regions:
[Myanmar]
02.12.2003
Una caída abrupta tanto en los ingresos por publicidad como en la circulación provocó que muchas publicaciones pequeñas y medianas dejaran de existir y también generó problemas financieros en algunas de las mayores editoriales, radioemisoras y canales de televisión del país.
Story link
Related topics/regions:
[Argentina]
Image: © Geographical http://www.geographical.co.uk
02.12.2003
Un fotógrafo argentino fue brutalmente golpeado por fuerzas policiales el lunes 9 de junio, mientras cubría un incidente afuera de una planta industrial en la ciudad de Buenos Aires.
Story link
Related topics/regions:
[Argentina]
Image: . © Canadian Journalists for Free Expression / International Freedom of Expression Exchange Clearing House
30.10.2003
Dangers are so acute in today's war zones that a media rights group felt obliged to update its media security handbook for journalists operating in conflict situations, including lessons learned in Iraq.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|