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=147712
) 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=145638
) 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=143746
) as subquery
Council for the Defence of Human Rights and Freedoms
CDHRF was founded in December of 1989 with the goal to defend and promote human rights and freedoms, foreseen in UN Universal Declaration on Human Rights and other international documents on human rights. CDHRF investigates and testifies on human rights violation and demands from all that exercise power to reject the abusing practices and to respect international documents on human rights and freedoms. CDHRF is a member of the International Federation of Human Rights (IFHR) and also a member of the Steering Committee of Balkans Human Rights Network (BHRN). CDHRF is organized into 5 Regional Centers with 30 municipal offices, and has members from all ethnic groups living in Kosovo. CDHRF publishes daily, weekly, monthly, quarterly, semi-annual and annual reports in Albanian, English and Serbian. CDHRF is also intensively involved in cooperating with the International Crime Tribunal for Former Yugoslavia.
29.03.2007
Drejtuesit e Kėshillit pėr Mbrojtjen e Lirive dhe tė Drejtave tė Njeriut (KMLDNJ) janė takuar tė enjten me kryetarin e Kuvendit tė Kosovės, Kolė Berisha, tė cilin e kanė njoftuar me veprimtarinė e gjithmbarshme tė kėtij Kėshilli por edhe me problemet serioze tė financave mė tė cilat ballafaqohet nga dita nė ditė.
12.12.2006
Me shtatė ēmime pėr filmat mė tė mirė, tė dielėn mbrėma, ka pėrfunduar festivali i shtatė ndėrkombėtar i filmit pėr tė drejtat e njeriut "Njė botė 2006". Filmi danez, "Sekreti gjerman", dhe filmi nga Mbretėria e Bashkuar, "Hetimet s'vazhdojnė", janė shpallur fitues tė ēmimit pėr filmin mė tė mirė dokumentar tė Festivalit, ndėrsa filmat "Golgota e Llapit" (Kosovė) dhe "Hapi i fundit pas paqes" i regjisorit Bahaa Ghazawy kanė, janė nderuar me ēmimin pėr filmin mė tė mirė qė kontribuon pėr tė drejtat e njeriut.
