|
|
Line 1: |
Line 1: |
| | | |
| {{#arr:dataloop | | {{#arr:dataloop |
− | |{{#fetch:sql|select xc._multi_to as country,xt._multi_to as category,count(*) as cnt from "tbl_Event" e,"tbl__Event__x__Tag" xt,"tbl__Event__x__Country" xc where xt._multi_from=e._row_ref and xc._multi_from=e._row_ref and (extract(year from e."Start")=2013 or extract(year from e."End")=2013) and xt._multi_to not in ('Top','Archives','Education','Embassies','Media','Support services') group by xc._multi_to,xt._multi_to order by xc._multi_to,xt._multi_to}} | + | |{{#fetch:sql|select xc._multi_to as country,xt._multi_to as category,count(*) as cnt from "tbl_Event" e,"tbl__Event__x__Tag" xt,"tbl__Event__x__Country" xc where xt._multi_from=e._row_ref and xc._multi_from=e._row_ref and (extract(year from e."Start")=2013 or extract(year from e."End")=2013) and xt._multi_to not in ('Top','Archives','Education','Embassies','Media','Support services','Maribor,_European_Capital_of_Culture_2012') group by xc._multi_to,xt._multi_to order by xc._multi_to,xt._multi_to}} |
| |each = <li>{{{country}}}, {{{category}}}, {{{cnt}}} | | |each = <li>{{{country}}}, {{{category}}}, {{{cnt}}} |
| }} | | }} |
Revision as of 19:00, 15 April 2014
Albania, Music, 2Albania, Theatre, 1Argentina, Design, 1Argentina, Film, 5Argentina, Literature, 2Argentina, Visual_arts, 2Australia, Dance, 1Australia, Music, 2Australia, Puppetry, 1Australia, Theatre, 3Austria, Architecture, 2Austria, Comic_art, 1Austria, Dance, 6Austria, Design, 4Austria, Film, 4Austria, Literature, 11Austria, Museums, 1Austria, Music, 38Austria, New_media_art, 8Austria, Photography, 6Austria, Puppetry, 5Austria, Support_services, 2Austria, Theatre, 20Austria, Visual_arts, 40Belgium, Dance, 3Belgium, Design, 3Belgium, Film, 1Belgium, Literature, 5Belgium, Music, 3Belgium, Photography, 1Belgium, Theatre, 3Belgium, Visual_arts, 2Bolivia, Photography, 1Bolivia, Visual_arts, 1Bosnia_and_Herzegovina, Dance, 1Bosnia_and_Herzegovina, Film, 2Bosnia_and_Herzegovina, Literature, 3Bosnia_and_Herzegovina, Music, 6Bosnia_and_Herzegovina, New_media_art, 1Bosnia_and_Herzegovina, Puppetry, 4Bosnia_and_Herzegovina, Theatre, 10Bosnia_and_Herzegovina, Visual_arts, 4Brazil, Dance, 5Brazil, Film, 2Brazil, Literature, 2Brazil, Museums, 1Brazil, Theatre, 4Brazil, Visual_arts, 3Bulgaria, Film, 1Bulgaria, Literature, 2Bulgaria, Puppetry, 1Bulgaria, Theatre, 3Canada, Film, 3Canada, Literature, 3Canada, New_media_art, 3Canada, Theatre, 3Canada, Visual_arts, 2Chile, Film, 2Chile, Literature, 1China, Film, 4China, Literature, 3China, Visual_arts, 2Colombia, Film, 1Colombia, Literature, 1Colombia, Visual_arts, 2Croatia, Animation, 1Croatia, Architecture, 3Croatia, Comic_art, 1Croatia, Dance, 13Croatia, Design, 2Croatia, Film, 13Croatia, Literature, 7Croatia, Museums, 3Croatia, Music, 23Croatia, New_media_art, 9Croatia, Photography, 2Croatia, Puppetry, 6Croatia, Theatre, 38Croatia, Visual_arts, 25Czech_Republic, Architecture, 2Czech_Republic, Dance, 1Czech_Republic, Design, 1Czech_Republic, Film, 5Czech_Republic, Literature, 9Czech_Republic, Museums, 1Czech_Republic, Music, 10Czech_Republic, New_media_art, 1Czech_Republic, Puppetry, 11Czech_Republic, Theatre, 17Czech_Republic, Visual_arts, 5Denmark, Theatre, 1Ecuador, Film, 1Egypt, Dance, 1Egypt, Music, 1Egypt, Photography, 1Egypt, Visual_arts, 1Estonia, Film, 1Estonia, New_media_art, 1Estonia, Puppetry, 1Estonia, Theatre, 1Estonia, Visual_arts, 2Ethiopia, Film, 1Finland, Dance, 4Finland, Film, 1Finland, Literature, 1Finland, Music, 4Finland, Theatre, 1France, Architecture, 3France, Comic_art, 1France, Dance, 6France, Film, 9France, Literature, 14France, Museums, 2France, Music, 7France, New_media_art, 2France, Photography, 3France, Puppetry, 2France, Theatre, 11France, Visual_arts, 12Georgia, Literature, 1Germany, Architecture, 1Germany, Dance, 8Germany, Design, 1Germany, Film, 14Germany, Literature, 6Germany, Museums, 1Germany, Music, 26Germany, New_media_art, 2Germany, Theatre, 13Germany, Visual_arts, 12Ghana, Visual_arts, 1Greece, Film, 3Greece, Literature, 1Greece, Music, 1Greece, Puppetry, 1Greece, Theatre, 1Hungary, Animation, 1Hungary, Architecture, 1Hungary, Comic_art, 1Hungary, Dance, 1Hungary, Film, 4Hungary, Literature, 1Hungary, Music, 5Hungary, Theatre, 4Hungary, Visual_arts, 4India, Architecture, 1India, Film, 3India, Literature, 1India, Music, 1India, New_media_art, 1Indonesia, Film, 1Iran, Theatre, 1Ireland, Design, 1Ireland, Literature, 3Ireland, Music, 4Ireland, Visual_arts, 2Israel, Architecture, 1Israel, Design, 1Israel, Film, 2Israel, Music, 7Israel, Puppetry, 2Israel, Theatre, 3Israel, Visual_arts, 3Italy, Architecture, 3Italy, Dance, 8Italy, Film, 11Italy, Literature, 4Italy, Museums, 1Italy, Music, 10Italy, New_media_art, 1Italy, Photography, 3Italy, Puppetry, 2Italy, Theatre, 19Italy, Visual_arts, 17Japan, Design, 2Japan, Film, 3Japan, Literature, 3Japan, New_media_art, 1Japan, Photography, 1Japan, Visual_arts, 4Kosovo, Film, 2Kosovo, Music, 1Kosovo, Theatre, 1Kosovo, Visual_arts, 1Latvia, New_media_art, 2Latvia, Visual_arts, 3Lithuania, Film, 2Lithuania, Literature, 1Lithuania, Visual_arts, 2Luxembourg, Film, 1Luxembourg, Literature, 1Luxembourg, Music, 1Luxembourg, Theatre, 1Malta, Puppetry, 1Malta, Theatre, 1Mexico, Film, 1Mexico, Literature, 1Mexico, New_media_art, 1Montenegro, Architecture, 1Montenegro, Film, 1Montenegro, Literature, 1Montenegro, Music, 1Montenegro, New_media_art, 1Montenegro, Photography, 1Montenegro, Puppetry, 1Montenegro, Theatre, 6Montenegro, Visual_arts, 2Netherlands, Animation, 1Netherlands, Comic_art, 1Netherlands, Film, 1Netherlands, Literature, 1Netherlands, Music, 3Netherlands, New_media_art, 1Netherlands, Theatre, 2Netherlands, Visual_arts, 4Nicaragua, Theatre, 1North_Macedonia, Dance, 1North_Macedonia, Film, 2North_Macedonia, Literature, 4North_Macedonia, Music, 5North_Macedonia, New_media_art, 1North_Macedonia, Support_services, 1North_Macedonia, Theatre, 7Norway, Dance, 2Norway, Film, 2Norway, Music, 1Norway, New_media_art, 2Norway, Theatre, 1Oman, Music, 1Paraguay, Film, 1Peru, Film, 1Poland, Dance, 1Poland, Film, 1Poland, Literature, 2Poland, Music, 2Poland, Puppetry, 1Poland, Theatre, 3Poland, Visual_arts, 2Portugal, Architecture, 1Portugal, Comic_art, 1Portugal, Dance, 1Portugal, New_media_art, 1Portugal, Photography, 1Portugal, Theatre, 3Portugal, Visual_arts, 3Romania, Architecture, 1Romania, Film, 5Romania, Museums, 1Romania, Music, 1Romania, New_media_art, 1Romania, Theatre, 3Romania, Visual_arts, 1Russia, Dance, 1Russia, Design, 1Russia, Film, 1Russia, Literature, 1Russia, Music, 3Russia, New_media_art, 1Russia, Puppetry, 2Russia, Theatre, 5Russia, Visual_arts, 1Serbia, Architecture, 2Serbia, Dance, 2Serbia, Design, 1Serbia, Film, 3Serbia, Literature, 3Serbia, Museums, 1Serbia, Music, 16Serbia, New_media_art, 2Serbia, Photography, 2Serbia, Puppetry, 1Serbia, Theatre, 18Serbia, Visual_arts, 7Singapore, Dance, 2Singapore, Music, 1Singapore, New_media_art, 1Slovakia, Dance, 3Slovakia, Film, 1Slovakia, Literature, 2Slovakia, Museums, 1Slovakia, Music, 5Slovakia, New_media_art, 1Slovakia, Photography, 2Slovakia, Puppetry, 3Slovakia, Theatre, 8Slovakia, Visual_arts, 3South_Africa, Visual_arts, 1South_Korea, Architecture, 1South_Korea, Film, 1South_Korea, New_media_art, 1South_Korea, Theatre, 1South_Korea, Visual_arts, 1Spain, Comic_art, 1Spain, Film, 6Spain, Literature, 7Spain, Music, 4Spain, Photography, 1Spain, Theatre, 1Spain, Visual_arts, 8Sri_Lanka, Music, 1Sweden, Film, 1Sweden, Literature, 1Sweden, Music, 2Sweden, Theatre, 2Switzerland, Dance, 5Switzerland, Film, 3Switzerland, Music, 4Switzerland, New_media_art, 2Switzerland, Theatre, 3Switzerland, Visual_arts, 3Turkey, Film, 1Turkey, Literature, 1Turkey, Music, 1Turkey, Puppetry, 2Turkey, Theatre, 2Turkey, Visual_arts, 1Ukraine, Literature, 1Ukraine, Music, 1Ukraine, Visual_arts, 2United_Arab_Emirates, Film, 1United_Kingdom, Architecture, 2United_Kingdom, Dance, 5United_Kingdom, Design, 2United_Kingdom, Film, 3United_Kingdom, Literature, 4United_Kingdom, Museums, 1United_Kingdom, Music, 13United_Kingdom, New_media_art, 2United_Kingdom, Photography, 1United_Kingdom, Puppetry, 1United_Kingdom, Theatre, 6United_Kingdom, Visual_arts, 11Uruguay, Film, 1USA, Architecture, 2USA, Dance, 3USA, Design, 3USA, Film, 13USA, Intangible_heritage, 2USA, Literature, 3USA, Music, 15USA, New_media_art, 7USA, Puppetry, 1USA, Theatre, 2USA, Visual_arts, 10