Difference between revisions of "Culture.si:Custom event list"
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | |||
+ | * Event list re Country & City | ||
+ | * Event list re Country & Category | ||
+ | |||
+ | {{#data:grid | ||
+ | |country = Event.Country | ||
+ | |city = Event.City | ||
+ | |count = count(*) | ||
+ | |#where = Event.Country <> 'Slovenia' AND (extract(year from Event.Start) = 2013 OR extract(year from Event.End) = 2013) | ||
+ | |#orderby = Event.Country, Event.City | ||
+ | |#groupby = Event.City,Event.Country | ||
+ | |#limit = 2000 | ||
+ | }} | ||
+ | |||
+ | == List of events re Category == | ||
+ | |||
{{#arr:dataloop | {{#arr:dataloop | ||
− | |{{#fetch:sql|select xc._multi_to as country, | + | |{{#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}}}, {{{ | + | |each = <li>{{{country}}}, {{{category}}}, {{{cnt}}} |
}} | }} |
Latest revision as of 21:51, 15 April 2014
- Event list re Country & City
- Event list re Country & Category
country | city | count |
---|---|---|
Albania | Elbasan | 1 |
Albania | Tirana | 1 |
Argentina | Buenos_Aires | 7 |
Argentina | Salta | 1 |
Argentina | Yerba_Buena | 1 |
Australia | Adelaide | 1 |
Australia | Brisbane | 1 |
Australia | Melbourne | 1 |
Australia | Mullumbimby | 1 |
Australia | Sydney | 1 |
Austria | Bad_Eisenkappel/Železna_Kapla | 1 |
Austria | Bad_Radkersburg/Radgona | 1 |
Austria | Bleiburg/Pliberk | 4 |
Austria | Feldbach | 2 |
Austria | Graz | 17 |
Austria | Hallein | 1 |
Austria | Judenburg | 1 |
Austria | Klagenfurt/Celovec | 11 |
Austria | Kremsmünster | 1 |
Austria | Linz | 1 |
Austria | Mistelbach_an_der_Zaya | 1 |
Austria | Oberwart | 1 |
Austria | Oslip | 1 |
Austria | Salzburg | 2 |
Austria | Sankt_Paul_im_Lavanttal/Šentpavel_v_Labotski_dolini | 1 |
Austria | Spitz_an_der_Donau | 1 |
Austria | St._Johann_im_Rosental/Šentjanž_v_Rožu | 7 |
Austria | St._Michael/Šmihel | 1 |
Austria | Vienna | 57 |
Austria | Villach/Beljak | 1 |
Austria | Weissenback_am_Attersee | 1 |
Austria | Wels | 1 |
Belgium | Antwerp | 1 |
Belgium | Bever | 1 |
Belgium | Brussels | 11 |
Belgium | Haacht | 1 |
Belgium | Leuven | 1 |
Belgium | Namur | 1 |
Belgium | Schaerbeek | 1 |
Bolivia | Santa_Cruz | 1 |
Bosnia_and_Herzegovina | Banja_Luka | 1 |
Bosnia_and_Herzegovina | Bugojno | 1 |
Bosnia_and_Herzegovina | Konjic | 1 |
Bosnia_and_Herzegovina | Mostar | 3 |
Bosnia_and_Herzegovina | Sarajevo | 13 |
Bosnia_and_Herzegovina | Zenica | 3 |
Brazil | Brasília | 1 |
Brazil | Curitiba | 1 |
Brazil | Porto_Alegre | 2 |
Brazil | Recife | 1 |
Brazil | Rio_de_Janeiro | 4 |
Brazil | São_Paulo | 4 |
Brazil | Tiradentes | 1 |
Bulgaria | Balčik | 2 |
Bulgaria | Dobrič | 2 |
Bulgaria | Sofia | 2 |
Bulgaria | Stara_Zagora | 1 |
Bulgaria | Varna | 3 |
Canada | Edmonton | 1 |
Canada | Montreal | 2 |
Canada | Ottawa | 2 |
Canada | Toronto | 3 |
Canada | Vancouver | 3 |
Chile | Providencia | 1 |
Chile | Santiago | 2 |
China | Beijing | 6 |
China | Hong_Kong | 1 |
China | Qinghai | 1 |
China | Shanghai | 1 |
Colombia | Bogotá | 2 |
Colombia | Medellin | 1 |
Croatia | Bjelovar | 1 |
Croatia | Čakovec | 1 |
Croatia | Dubrovnik | 2 |
Croatia | Islam_Grčki | 1 |
Croatia | Karlovac | 1 |
Croatia | Makarska | 1 |
Croatia | Motovun | 1 |
Croatia | Osijek | 4 |
Croatia | Poreč | 1 |
Croatia | Pula | 6 |
Croatia | Rijeka | 10 |
Croatia | Rovinj | 1 |
Croatia | Šibenik | 2 |
Croatia | Silba | 1 |
Croatia | Slavonski_Brod | 1 |
Croatia | Split | 6 |
Croatia | Starigrad | 1 |
Croatia | Umag | 1 |
Croatia | Varaždin | 4 |
Croatia | Vinkovci | 1 |
Croatia | Virovitica | 1 |
Croatia | Vukovar | 2 |
Croatia | Zabok | 2 |
Croatia | Zadar | 1 |
Croatia | Zagreb | 62 |
Czech_Republic | Beroun | 1 |
Czech_Republic | Bohumín | 1 |
Czech_Republic | Boskovice | 1 |
Czech_Republic | Brno | 8 |
Czech_Republic | České_Budějovice | 1 |
Czech_Republic | Český_Krumlov | 1 |
Czech_Republic | Český_Těšín | 1 |
Czech_Republic | Chrudim | 2 |
Czech_Republic | Horni_Počernice | 1 |
Czech_Republic | Hradec_Králové | 2 |
Czech_Republic | Hronov | 1 |
Czech_Republic | Jičín | 1 |
Czech_Republic | Karlovy_Vary | 1 |
Czech_Republic | Krakovec | 1 |
Czech_Republic | Kroměříž | 1 |
Czech_Republic | Kuks | 1 |
Czech_Republic | Liberec | 1 |
Czech_Republic | Olomouc | 1 |
Czech_Republic | Opava | 1 |
Czech_Republic | Ostrava | 5 |
Czech_Republic | Plzeň | 1 |
Czech_Republic | Prague | 15 |
Czech_Republic | Prostějov | 1 |
Czech_Republic | Sudoměřice_u_Bechyně | 1 |
Czech_Republic | Tábor | 1 |
Czech_Republic | Tetín | 1 |
Denmark | Viborg | 1 |
Ecuador | Guayaquil | 1 |
Ecuador | Manta | 1 |
Ecuador | Quito | 1 |
Egypt | Cairo | 3 |
Estonia | Tallinn | 4 |
Ethiopia | Addis_Ababa | 1 |
Finland | Helsinki | 4 |
Finland | Kaustinen | 1 |
Finland | Mikkeli | 1 |
Finland | Siilinjärvi | 1 |
France | Annecy | 1 |
France | Arras | 1 |
France | Aubagne | 1 |
France | Besançon | 1 |
France | Cannes | 1 |
France | Chalon-sur-Saône | 1 |
France | Charleville-Mézières | 1 |
France | Guyancourt | 1 |
France | Ivry-sur-Seine | 2 |
France | La_Chapelle_Saint-Luc | 1 |
France | Les_Arcs | 1 |
France | Lille | 1 |
France | Lyon | 2 |
France | Marseille | 4 |
France | Metz | 1 |
France | Montpellier | 2 |
France | Montreuil | 2 |
France | Mulhouse | 1 |
France | Nancy | 1 |
France | Paris | 26 |
France | Perpignan | 1 |
France | Poitiers | 1 |
France | Rennes | 1 |
France | Saint-Erme-Outre-et-Ramecourt | 1 |
France | Saint-Étienne | 1 |
France | Sanary-sur-Mer | 1 |
France | Sète | 1 |
France | Strasbourg | 1 |
France | Tinqueux | 5 |
France | Toulouse | 2 |
France | Villeurbanne | 1 |
Georgia | Tbilisi | 1 |
Germany | Badel | 1 |
Germany | Baden-Baden | 1 |
Germany | Berlin | 17 |
Germany | Bochum | 1 |
Germany | Braunschweig | 1 |
Germany | Chemnitz | 1 |
Germany | Cologne | 6 |
Germany | Cottbus | 1 |
Germany | Deutzen | 1 |
Germany | Dresden | 5 |
Germany | Düsseldorf | 2 |
Germany | Essen | 2 |
Germany | Frankfurt_am_Main | 4 |
Germany | Freising | 1 |
Germany | Gladbeck | 1 |
Germany | Gotha | 1 |
Germany | Halle_(Saale) | 1 |
Germany | Hamburg | 3 |
Germany | Hannover | 3 |
Germany | Heidelberg | 1 |
Germany | Holzminden | 1 |
Germany | Ilmenau | 1 |
Germany | Ingolstadt | 1 |
Germany | Karlsruhe | 2 |
Germany | Kiel | 1 |
Germany | Langen | 1 |
Germany | Lärz | 1 |
Germany | Leipzig | 5 |
Germany | Mannheim | 1 |
Germany | Marseburg | 1 |
Germany | Mülheim_an_der_Ruhr | 1 |
Germany | Munich | 7 |
Germany | Nürnberg | 1 |
Germany | Oberhausen | 2 |
Germany | Oldenburg | 1 |
Germany | Osnabrück | 1 |
Germany | Rostock | 1 |
Germany | Schnaittach | 1 |
Germany | Stuttgart | 3 |
Germany | Villingen-Schwenningen | 1 |
Germany | Wiesbaden | 1 |
Germany | Witten | 1 |
Germany | Würzburg | 1 |
Ghana | Accra | 1 |
Greece | Athens | 2 |
Greece | Kilkis | 1 |
Greece | Larissa | 1 |
Greece | Thessaloniki | 2 |
Greece | Xanthi | 1 |
Greece | 1 | |
Hungary | Budaörs | 1 |
Hungary | Budapest | 16 |
Hungary | Pécs | 1 |
India | Bangalore | 2 |
India | Chennai | 1 |
India | Mumbai | 3 |
India | New_Delhi | 1 |
India | Panaji | 1 |
Indonesia | Jakarta | 1 |
Iran | Tehran | 1 |
Ireland | Clifden | 1 |
Ireland | Dublin | 6 |
Ireland | Galway | 1 |
Ireland | Limerick | 2 |
Ireland | Newbridge | 1 |
Israel | Haifa | 2 |
Israel | Herzliya | 2 |
Israel | Holon | 5 |
Israel | Jerusalem | 2 |
Israel | Nahariya | 1 |
Israel | Rosh_Pina | 1 |
Israel | Sderot | 1 |
Israel | Shavei_Tzion | 1 |
Israel | Tel_Aviv | 11 |
Israel | Zikhron_Ya'akov | 1 |
Italy | Amantea | 1 |
Italy | Arezzo | 1 |
Italy | Bari | 1 |
Italy | Bologna | 2 |
Italy | Brescia | 1 |
Italy | Brunico | 1 |
Italy | Cesena | 1 |
Italy | Cremona | 1 |
Italy | Florence | 2 |
Italy | Gabicce_Mare | 1 |
Italy | Gorizia/Gorica | 4 |
Italy | La_Val | 1 |
Italy | Milan | 1 |
Italy | Naples | 1 |
Italy | Ostia | 1 |
Italy | Perugia | 1 |
Italy | Pordenone | 1 |
Italy | Prato | 1 |
Italy | Rome | 7 |
Italy | San_Michele_del_Carso/Vrh | 1 |
Italy | San_Vito_dei_Normanni | 1 |
Italy | Segrate | 1 |
Italy | Staranzano | 1 |
Italy | Trieste/Trst | 23 |
Italy | Udine/Videm | 3 |
Italy | Venice | 8 |
Japan | Beppu | 1 |
Japan | Fukushima | 1 |
Japan | Kobe | 1 |
Japan | Minamisōma | 1 |
Japan | Osaka | 1 |
Japan | Tokyo | 4 |
Japan | Tsukuba | 1 |
Kosovo | Peć | 1 |
Kosovo | Pristina | 2 |
Kosovo | Prizren | 1 |
Latvia | Cēsis | 1 |
Latvia | Riga | 2 |
Lithuania | Druskininkai | 1 |
Lithuania | Kaunas | 1 |
Lithuania | Vilnius | 4 |
Luxembourg | Luxembourg | 3 |
Malta | Gozo | 1 |
Malta | Valletta | 1 |
Mexico | Guadalajara | 1 |
Mexico | Mexico_City | 2 |
Montenegro | Bar | 1 |
Montenegro | Cetinje | 3 |
Montenegro | Kotor | 2 |
Montenegro | Mojkovac | 1 |
Montenegro | Podgorica | 4 |
Montenegro | Ulcinj | 1 |
Netherlands | Amsterdam | 2 |
Netherlands | Eindhoven | 3 |
Netherlands | Enschede | 1 |
Netherlands | Groningen | 1 |
Netherlands | Midsland | 1 |
Netherlands | Rotterdam | 1 |
Nicaragua | Managua | 1 |
North_Macedonia | Bitola | 3 |
North_Macedonia | Kumanovo | 1 |
North_Macedonia | Ohrid | 1 |
North_Macedonia | Prilep | 1 |
North_Macedonia | Radoviš | 1 |
North_Macedonia | Resen | 1 |
North_Macedonia | Skopje | 11 |
North_Macedonia | Štip | 1 |
North_Macedonia | Struga | 1 |
North_Macedonia | Strumica | 1 |
Norway | Bergen | 2 |
Norway | Harstad | 1 |
Norway | Oslo | 2 |
Oman | Muscat | 1 |
Paraguay | Asunción | 1 |
Peru | Arequipa | 1 |
Peru | Lima | 1 |
Peru | Piura | 1 |
Poland | Bielsko-Biała | 2 |
Poland | Katowice | 1 |
Poland | Kraków | 3 |
Poland | Łomża | 1 |
Poland | Lublin | 2 |
Poland | Mikołów | 1 |
Poland | Poznań | 1 |
Poland | Warsaw | 4 |
Poland | Wrocław | 2 |
Portugal | Almada | 1 |
Portugal | Cascais | 2 |
Portugal | Lisbon | 2 |
Portugal | Matosinhos | 1 |
Portugal | Porto | 1 |
Portugal | St._Maria_da_Feira | 1 |
Romania | Bucharest | 9 |
Romania | Giurgiu | 1 |
Romania | Mediaș | 1 |
Romania | Mogoşoaia | 1 |
Romania | Sibiu | 1 |
Russia | Irkutsk | 1 |
Russia | Moscow | 7 |
Russia | Omsk | 1 |
Russia | Perm | 1 |
Russia | Saint_Petersburg | 2 |
Serbia | Belgrade | 32 |
Serbia | Kragujevac | 3 |
Serbia | Niš | 2 |
Serbia | Novi_Sad | 7 |
Serbia | Pančevo | 1 |
Serbia | Smederevo | 1 |
Serbia | Subotica | 2 |
Serbia | Vršac | 1 |
Serbia | Zemun | 1 |
Singapore | Singapore | 3 |
Slovakia | Banská_Bystrica | 2 |
Slovakia | Bardejov | 2 |
Slovakia | Bratislava | 11 |
Slovakia | Košice | 5 |
Slovakia | Kremnica | 1 |
Slovakia | Nitra | 1 |
Slovakia | Trenčín | 1 |
Slovakia | Trnava | 1 |
Slovakia | Žilina | 3 |
South_Africa | Johannesburg | 1 |
South_Korea | Busan | 1 |
South_Korea | Gwacheon | 1 |
South_Korea | Seoul | 2 |
Spain | Alcalá_de_Henares | 1 |
Spain | Barcelona | 2 |
Spain | Getafe | 2 |
Spain | Madrid | 13 |
Spain | Sevilla | 1 |
Spain | Valencia | 1 |
Spain | Valladolid | 1 |
Spain | Vic | 1 |
Sri_Lanka | Colombo | 1 |
Sweden | Gothenburg | 3 |
Sweden | Stockholm | 2 |
Sweden | Umeå | 2 |
Switzerland | Basel | 8 |
Switzerland | Bellinzona | 2 |
Switzerland | Bern | 3 |
Switzerland | Biel/Bienne | 1 |
Switzerland | Chur | 2 |
Switzerland | Geneva | 3 |
Switzerland | Winterthur | 2 |
Switzerland | Zürich | 5 |
Turkey | Ankara | 1 |
Turkey | Istanbul | 3 |
Turkey | Izmir | 2 |
Ukraine | Kharkiv | 2 |
Ukraine | Kyiv | 2 |
United_Arab_Emirates | Dubai | 1 |
United_Kingdom | Aberdeen | 1 |
United_Kingdom | Banchory | 1 |
United_Kingdom | Belfast | 1 |
United_Kingdom | Cardiff | 1 |
United_Kingdom | East_Lothian | 1 |
United_Kingdom | Ebrington | 1 |
United_Kingdom | Findhorn | 1 |
United_Kingdom | Glenrothes | 1 |
United_Kingdom | Guildford | 1 |
United_Kingdom | Isle_of_Mull | 1 |
United_Kingdom | Liverpool | 2 |
United_Kingdom | London | 31 |
United_Kingdom | Manchester | 2 |
United_Kingdom | Newcastle | 1 |
United_Kingdom | North_Lanarkshire | 1 |
United_Kingdom | Norwich | 1 |
United_Kingdom | Nottingham | 1 |
Uruguay | Montevideo | 1 |
USA | Annapolis | 1 |
USA | Bethlehem_(PA) | 1 |
USA | Bristol | 1 |
USA | Chicago | 1 |
USA | Cleveland | 6 |
USA | Emporia | 1 |
USA | Franklin_(KS) | 1 |
USA | Houston | 1 |
USA | Huntsville | 1 |
USA | Joliet | 1 |
USA | Kansas_City | 1 |
USA | Lancastre | 1 |
USA | Los_Angeles | 2 |
USA | Mason_City | 1 |
USA | Milwaukee | 1 |
USA | Minneapolis | 1 |
USA | Munhall | 1 |
USA | Nashville | 1 |
USA | New_York | 13 |
USA | North_Bethesda | 1 |
USA | Orlando | 1 |
USA | Park_City | 1 |
USA | Riverside_(CA) | 1 |
USA | Salisbury | 1 |
USA | San_Francisco | 1 |
USA | San_Jose | 1 |
USA | Silver_Spring | 1 |
USA | Washington | 10 |
USA | Washington_D.C. | 1 |
USA | Wilmington | 1 |
USA | Youngstown | 1 |