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=140217
) 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=140150
) 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=138577
) 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=132400
) 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=128111
) as subquery
02.10.2006
Nėpėrmes projektit Zhvillimi ekonomik pėrmes punėsimit nė lagjen - 7 Shtatori tė organizatės joqeveritare, Syri i Vizionit nga Peja nė bashkėpunim me organizatėn partnere, Vizioni nga Istogu, ka filluar tė zbutet problemi i punėsimit tė kthyerve dhe vendasve nė njė ndėr lagjet mė gjendjen mė rėndė sociale e ekonomike tė Pejės.
23.09.2006
Nėn organizimin e organizatės joqeveritare Syri Vizionit u organizua turniri shumetnik i futbollit me banorėt e lagjes 7 Shtatori tė qytetit tė Pejės.
15.08.2006
OJQ Syri i Vizionit ka filluar implementimin e projektit Zhvillimi ekonomik pėrmes punėsimit i cili synon punėsimin e 12 personave si tė kthyer dhe pritės nė Lagjen me komunitet tė pėrzier 7 Shtatori nė Pejė duke krijuar kėshtu kushte mė tė mira pėr integrim dhe zhvillim ekonomik pėr kėto komunitete.
28.04.2006
Zyrtarisht ka filluar vazhdimėsia e projektit Plani i veprimit pėr re-integrim nė lagjen - 7 Shtatori i cili vjen si rezultat i punės nė projektin e para njė viti, respektivisht projektit tė zbatuar nga OJQ Syri i Vizionit nė partneritet me OJQ tė Vizioni-02, nga Istogu dhe Helping People in Need HPN, nga Rozhaja.
22.02.2006
Aiming to eradicate illiteracy within the mixed community of 7 Shtatori avenue of Pejė town, nongovernmental organization Syri i Vizionit, during the period of November 2005 February 2006 has implemented the course with three citizens groups: women, youth and grownups, with participation of 45 persons. The course has been organized in the Community Center of this avenue.
