Difference between revisions of "User talk:Mitja"

From Culture.si
Line 1: Line 1:
{{CURRENTWEEK}}
+
{{#arr:dataloop
{{{after ={{#expr:100*{{CURRENTYEAR}} + {{CURRENTWEEK}}}}}}}
+
|{{#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','Education','Embassies') group by xc._multi_to,xt._multi_to order by xc._multi_to,xt._multi_to}}
{{{after1 ={{#expr:{{{after}}} + 1}}}}}
+
|each = <li>{{{country}}}, {{{category}}}, {{{cnt}}}
{{{after2 ={{#expr:{{{after1}}} + 1}}}}}
 
 
 
Weeks: {{{after}}},{{{after1}}},{{{after2}}}
 
----
 
<!-- fetches pages nad external links
 
{{#eval:parse|
 
{{#arr:dataloop|
 
{{#fetch:sql|SELECT el_to,string_agg(concat('[','[{','{ns:', page_namespace,'}','}:', page_title , ']]'),' ') as pages FROM externallinks as x, page as p WHERE page_id=el_from GROUP BY el_to LIMIT 20}}
 
|each = <li><span class="xlink">{{{el_to}}}</span><br>{{{pages}}}
 
}}}}
 
-->
 
 
 
{{#arr:dataloop|
 
{ {#fetch:sql|SELECT el_to, http_result_code(el_to) as status FROM externallinks LIMIT 1}}
 
|each = <li>{{{status}}}:: <span class="xlink">{{{el_to}}}</span>
 
}}
 
 
 
 
 
{{#arr:dataloop|
 
{{#fetch:smw|http://www.culture.si/w/index.php?title=Special:Ask&q=[[Category:Festivals]]+[[Festival+weeks::{{{after}}}]]+OR+[[Festival+weeks::{{{after1}}}]]+OR+[[Festival+weeks::{{{after2}}}]]&po=%3FWebsite%0D%0ATown%0D%0AOrganised+by%0D%0ATeaserImg%0D%0ATeaser100%0D%0A&eq=yes&p[format]=json&sort_num=&order_num=ASC&sort_num=label&order_num=ASC&p[link]=none|link=Organised by,Established}}
 
|first = <h2>Festivals in Slovenia</h2>
 
<ul class="festivals">
 
|each = <li style="clear:both"><b>[{{{url}}} {{{label}}}]</b><br>{{#ifexist:{{{TeaserImg}}}|[[{{{TeaserImg}}}|120x120px|left]]}}<i>{{{Teaser100}}} [{{{Website}}} Site]</i><br>
 
 
}}
 
}}

Revision as of 17:25, 19 March 2014

  • Albania, Music, 2
  • Albania, Theatre, 1
  • Argentina, Design, 1
  • Argentina, Film, 5
  • Argentina, Literature, 2
  • Argentina, Visual_arts, 2
  • Australia, Dance, 1
  • Australia, Music, 2
  • Australia, Puppetry, 1
  • Australia, Theatre, 3
  • Austria, Architecture, 2
  • Austria, Comic_art, 1
  • Austria, Dance, 6
  • Austria, Design, 4
  • Austria, Film, 4
  • Austria, Literature, 11
  • Austria, Museums, 1
  • Austria, Music, 38
  • Austria, New_media_art, 8
  • Austria, Photography, 6
  • Austria, Puppetry, 5
  • Austria, Support_services, 2
  • Austria, Theatre, 20
  • Austria, Visual_arts, 40
  • Belgium, Dance, 3
  • Belgium, Design, 3
  • Belgium, Film, 1
  • Belgium, Literature, 5
  • Belgium, Music, 3
  • Belgium, Photography, 1
  • Belgium, Theatre, 3
  • Belgium, Visual_arts, 2
  • Bolivia, Media, 1
  • Bolivia, Photography, 1
  • Bolivia, Visual_arts, 1
  • Bosnia_and_Herzegovina, Dance, 1
  • Bosnia_and_Herzegovina, Film, 2
  • Bosnia_and_Herzegovina, Literature, 3
  • Bosnia_and_Herzegovina, Music, 6
  • Bosnia_and_Herzegovina, New_media_art, 1
  • Bosnia_and_Herzegovina, Puppetry, 4
  • Bosnia_and_Herzegovina, Theatre, 10
  • Bosnia_and_Herzegovina, Visual_arts, 4
  • Brazil, Dance, 5
  • Brazil, Film, 2
  • Brazil, Literature, 2
  • Brazil, Museums, 1
  • Brazil, Theatre, 4
  • Brazil, Visual_arts, 3
  • Bulgaria, Film, 1
  • Bulgaria, Literature, 2
  • Bulgaria, Puppetry, 1
  • Bulgaria, Theatre, 3
  • Canada, Film, 3
  • Canada, Literature, 3
  • Canada, New_media_art, 3
  • Canada, Theatre, 3
  • Canada, Visual_arts, 2
  • Chile, Film, 2
  • Chile, Literature, 1
  • China, Film, 4
  • China, Literature, 3
  • China, Visual_arts, 2
  • Colombia, Film, 1
  • Colombia, Literature, 1
  • Colombia, Visual_arts, 2
  • Croatia, Animation, 1
  • Croatia, Architecture, 3
  • Croatia, Archives, 1
  • Croatia, Comic_art, 1
  • Croatia, Dance, 13
  • Croatia, Design, 2
  • Croatia, Film, 13
  • Croatia, Literature, 7
  • Croatia, Museums, 3
  • Croatia, Music, 23
  • Croatia, New_media_art, 9
  • Croatia, Photography, 2
  • Croatia, Puppetry, 6
  • Croatia, Theatre, 38
  • Croatia, Visual_arts, 25
  • Czech_Republic, Architecture, 2
  • Czech_Republic, Dance, 1
  • Czech_Republic, Design, 1
  • Czech_Republic, Film, 5
  • Czech_Republic, Literature, 9
  • Czech_Republic, Museums, 1
  • Czech_Republic, Music, 10
  • Czech_Republic, New_media_art, 1
  • Czech_Republic, Puppetry, 11
  • Czech_Republic, Theatre, 17
  • Czech_Republic, Visual_arts, 5
  • Denmark, Theatre, 1
  • Ecuador, Film, 1
  • Egypt, Dance, 1
  • Egypt, Music, 1
  • Egypt, Photography, 1
  • Egypt, Visual_arts, 1
  • Estonia, Film, 1
  • Estonia, New_media_art, 1
  • Estonia, Puppetry, 1
  • Estonia, Theatre, 1
  • Estonia, Visual_arts, 2
  • Ethiopia, Film, 1
  • Finland, Dance, 4
  • Finland, Film, 1
  • Finland, Literature, 1
  • Finland, Music, 4
  • Finland, Theatre, 1
  • France, Architecture, 3
  • France, Comic_art, 1
  • France, Dance, 6
  • France, Film, 9
  • France, Literature, 14
  • France, Museums, 2
  • France, Music, 7
  • France, New_media_art, 2
  • France, Photography, 3
  • France, Puppetry, 2
  • France, Theatre, 11
  • France, Visual_arts, 12
  • Georgia, Literature, 1
  • Germany, Architecture, 1
  • Germany, Dance, 8
  • Germany, Design, 1
  • Germany, Film, 14
  • Germany, Literature, 6
  • Germany, Museums, 1
  • Germany, Music, 26
  • Germany, New_media_art, 2
  • Germany, Theatre, 13
  • Germany, Visual_arts, 12
  • Ghana, Visual_arts, 1
  • Greece, Film, 3
  • Greece, Literature, 1
  • Greece, Music, 1
  • Greece, Puppetry, 1
  • Greece, Theatre, 1
  • Hungary, Animation, 1
  • Hungary, Architecture, 1
  • Hungary, Comic_art, 1
  • Hungary, Dance, 1
  • Hungary, Film, 4
  • Hungary, Literature, 1
  • Hungary, Music, 5
  • Hungary, Theatre, 4
  • Hungary, Visual_arts, 4
  • India, Architecture, 1
  • India, Film, 3
  • India, Literature, 1
  • India, Music, 1
  • India, New_media_art, 1
  • Indonesia, Film, 1
  • Iran, Theatre, 1
  • Ireland, Design, 1
  • Ireland, Literature, 3
  • Ireland, Music, 4
  • Ireland, Visual_arts, 2
  • Israel, Architecture, 1
  • Israel, Design, 1
  • Israel, Film, 2
  • Israel, Music, 7
  • Israel, Puppetry, 2
  • Israel, Theatre, 3
  • Israel, Visual_arts, 3
  • Italy, Architecture, 3
  • Italy, Dance, 8
  • Italy, Film, 11
  • Italy, Literature, 4
  • Italy, Museums, 1
  • Italy, Music, 10
  • Italy, New_media_art, 1
  • Italy, Photography, 3
  • Italy, Puppetry, 2
  • Italy, Theatre, 19
  • Italy, Visual_arts, 17
  • Japan, Design, 2
  • Japan, Film, 3
  • Japan, Literature, 3
  • Japan, New_media_art, 1
  • Japan, Photography, 1
  • Japan, Visual_arts, 4
  • Kosovo, Film, 2
  • Kosovo, Music, 1
  • Kosovo, Theatre, 1
  • Kosovo, Visual_arts, 1
  • Latvia, New_media_art, 2
  • Latvia, Visual_arts, 3
  • Lithuania, Film, 2
  • Lithuania, Literature, 1
  • Lithuania, Visual_arts, 2
  • Luxembourg, Film, 1
  • Luxembourg, Literature, 1
  • Luxembourg, Music, 1
  • Luxembourg, Theatre, 1
  • Malta, Puppetry, 1
  • Malta, Theatre, 1
  • Mexico, Film, 1
  • Mexico, Literature, 1
  • Mexico, New_media_art, 1
  • Montenegro, Architecture, 1
  • Montenegro, Film, 1
  • Montenegro, Literature, 1
  • Montenegro, Music, 1
  • Montenegro, New_media_art, 1
  • Montenegro, Photography, 1
  • Montenegro, Puppetry, 1
  • Montenegro, Theatre, 6
  • Montenegro, Visual_arts, 2
  • Netherlands, Animation, 1
  • Netherlands, Comic_art, 1
  • Netherlands, Film, 1
  • Netherlands, Literature, 1
  • Netherlands, Music, 3
  • Netherlands, New_media_art, 1
  • Netherlands, Theatre, 2
  • Netherlands, Visual_arts, 4
  • Nicaragua, Theatre, 1
  • North_Macedonia, Dance, 1
  • North_Macedonia, Film, 2
  • North_Macedonia, Literature, 4
  • North_Macedonia, Music, 5
  • North_Macedonia, New_media_art, 1
  • North_Macedonia, Support_services, 1
  • North_Macedonia, Theatre, 7
  • Norway, Dance, 2
  • Norway, Film, 2
  • Norway, Music, 1
  • Norway, New_media_art, 2
  • Norway, Theatre, 1
  • Oman, Music, 1
  • Paraguay, Film, 1
  • Peru, Film, 1
  • Poland, Dance, 1
  • Poland, Film, 1
  • Poland, Literature, 2
  • Poland, Music, 2
  • Poland, Puppetry, 1
  • Poland, Theatre, 3
  • Poland, Visual_arts, 2
  • Portugal, Architecture, 1
  • Portugal, Comic_art, 1
  • Portugal, Dance, 1
  • Portugal, New_media_art, 1
  • Portugal, Photography, 1
  • Portugal, Theatre, 3
  • Portugal, Visual_arts, 3
  • Romania, Architecture, 1
  • Romania, Film, 5
  • Romania, Museums, 1
  • Romania, Music, 1
  • Romania, New_media_art, 1
  • Romania, Theatre, 3
  • Romania, Visual_arts, 1
  • Russia, Dance, 1
  • Russia, Design, 1
  • Russia, Film, 1
  • Russia, Literature, 1
  • Russia, Music, 3
  • Russia, New_media_art, 1
  • Russia, Puppetry, 2
  • Russia, Theatre, 5
  • Russia, Visual_arts, 1
  • Serbia, Architecture, 2
  • Serbia, Archives, 1
  • Serbia, Dance, 2
  • Serbia, Design, 1
  • Serbia, Film, 3
  • Serbia, Literature, 3
  • Serbia, Museums, 1
  • Serbia, Music, 16
  • Serbia, New_media_art, 2
  • Serbia, Photography, 2
  • Serbia, Puppetry, 1
  • Serbia, Theatre, 18
  • Serbia, Visual_arts, 7
  • Singapore, Dance, 2
  • Singapore, Music, 1
  • Singapore, New_media_art, 1
  • Slovakia, Dance, 3
  • Slovakia, Film, 1
  • Slovakia, Literature, 2
  • Slovakia, Museums, 1
  • Slovakia, Music, 5
  • Slovakia, New_media_art, 1
  • Slovakia, Photography, 2
  • Slovakia, Puppetry, 3
  • Slovakia, Theatre, 8
  • Slovakia, Visual_arts, 3
  • South_Africa, Visual_arts, 1
  • South_Korea, Architecture, 1
  • South_Korea, Film, 1
  • South_Korea, New_media_art, 1
  • South_Korea, Theatre, 1
  • South_Korea, Visual_arts, 1
  • Spain, Comic_art, 1
  • Spain, Film, 6
  • Spain, Literature, 7
  • Spain, Music, 4
  • Spain, Photography, 1
  • Spain, Theatre, 1
  • Spain, Visual_arts, 8
  • Sri_Lanka, Music, 1
  • Sweden, Film, 1
  • Sweden, Literature, 1
  • Sweden, Music, 2
  • Sweden, Theatre, 2
  • Switzerland, Dance, 5
  • Switzerland, Film, 3
  • Switzerland, Music, 4
  • Switzerland, New_media_art, 2
  • Switzerland, Theatre, 3
  • Switzerland, Visual_arts, 3
  • Turkey, Film, 1
  • Turkey, Literature, 1
  • Turkey, Music, 1
  • Turkey, Puppetry, 2
  • Turkey, Theatre, 2
  • Turkey, Visual_arts, 1
  • Ukraine, Literature, 1
  • Ukraine, Music, 1
  • Ukraine, Visual_arts, 2
  • United_Arab_Emirates, Film, 1
  • United_Kingdom, Architecture, 2
  • United_Kingdom, Dance, 5
  • United_Kingdom, Design, 2
  • United_Kingdom, Film, 3
  • United_Kingdom, Literature, 4
  • United_Kingdom, Museums, 1
  • United_Kingdom, Music, 13
  • United_Kingdom, New_media_art, 2
  • United_Kingdom, Photography, 1
  • United_Kingdom, Puppetry, 1
  • United_Kingdom, Theatre, 6
  • United_Kingdom, Visual_arts, 11
  • Uruguay, Film, 1
  • USA, Architecture, 2
  • USA, Dance, 3
  • USA, Design, 3
  • USA, Film, 13
  • USA, Intangible_heritage, 2
  • USA, Literature, 3
  • USA, Music, 15
  • USA, New_media_art, 7
  • USA, Puppetry, 1
  • USA, Theatre, 2
  • USA, Visual_arts, 10