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=145220
) 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=145036
) 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=139275
) 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=108740
) as subquery
22.01.2007
A1 TV won the Annual Civil Society Media Award, presented by the Macedonian Institute for the Media (MIM) for contributions in strengthening of civil society in Macedonia in 2006.
17.01.2007
Na 18 januari 2007 so pocetok vo 19:00 casot, Makedonskiot institut za mediumi (MIM) vo prostoriite na Kulturniot centar “Mala stanica” ke ja odrzi prvata ceremonija na dodeluvanje na Godisnata mediumska nagrada na civilnoto opstestvo, koja mu se dodeluva na mediumot koj vo 2006 godina go dal najgolemiot pridones za zajaknuvanjeto na gragjanskoto opstestvo vo Makedonija.
13.09.2006
The Macedonian Institute for the Media (MIM) and the Institute for Sustainable Communities (ISC) announced the start of the selection process for the media outlet that made the greatest contribution to the development of civil society in 2006.
