Difference between revisions of "Culture.si:EUProjectSummary"

From Culture.si
Line 3: Line 3:
 
   |Uniq = count(DISTINCT EUProject.name)
 
   |Uniq = count(DISTINCT EUProject.name)
 
   |Name+Year = count(DISTINCT concat(EUProject.name,EUProject.Year))
 
   |Name+Year = count(DISTINCT concat(EUProject.name,EUProject.Year))
   |Name+Year = count(DISTINCT concat(EUProject.name,EUProject.Year,EUProject.Producer))
+
   |Name+Year+Producer = count(DISTINCT concat(EUProject.name,EUProject.Year,EUProject.Producer))
 
   |#where = EUProject.Year!='2013'
 
   |#where = EUProject.Year!='2013'
 
}}
 
}}

Revision as of 23:10, 9 October 2013

TotalUniqName+YearName+Year+Producer
0000

Projekti po kategorijah (po letih)

LetoKategorijaŠt. projektov

Organizacije po statusu (po letih)

LetoStatusŠt. projektov

Organizacije in število projektov (brez 2013)

OrganizacijaŠt. projektov

Vsi projekti po abecedi

LetoProjekt