Difference between revisions of "Culture.si:Custom event list"

From Culture.si
(Custom event list)
 
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','Maribor,_European_Capital_of_Culture_2012') group by xc._multi_to,xt._multi_to order by xc._multi_to,xt._multi_to}}
+
|{{#fetch:sql|select xc._multi_to as country,xm._multi_to as city,count(*) as cnt from "tbl_Event" e,"tbl__Event__x__City" xm,"tbl__Event__x__Tag" xt,"tbl__Event__x__Country" xc where xt._multi_from=e._row_ref and xm._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,xm._multi_to order by xc._multi_to,xm._multi_to}}
|each = <li>{{{country}}}, {{{category}}}, {{{cnt}}}
+
|each = <li>{{{country}}}, {{{city}}}, {{{cnt}}}
 
}}
 
}}

Revision as of 21:06, 15 April 2014

  • Albania, Elbasan, 2
  • Albania, Tirana, 1
  • Argentina, Buenos_Aires, 8
  • Argentina, Salta, 1
  • Argentina, Yerba_Buena, 1
  • Australia, Brisbane, 1
  • Australia, Melbourne, 3
  • Australia, Mullumbimby, 2
  • Australia, Sydney, 1
  • Austria, Bad_Eisenkappel/Železna_Kapla, 1
  • Austria, Bad_Radkersburg/Radgona, 1
  • Austria, Bleiburg/Pliberk, 5
  • Austria, Feldbach, 3
  • Austria, Graz, 26
  • Austria, Hallein, 1
  • Austria, Judenburg, 1
  • Austria, Klagenfurt/Celovec, 15
  • Austria, Kremsmünster, 1
  • Austria, Linz, 2
  • Austria, Mistelbach_an_der_Zaya, 2
  • Austria, Oberwart, 1
  • Austria, Oslip, 1
  • Austria, Salzburg, 3
  • 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, 9
  • Austria, St._Michael/Šmihel, 2
  • Austria, Vienna, 70
  • Austria, Villach/Beljak, 2
  • Austria, Weissenback_am_Attersee, 1
  • Austria, Wels, 2
  • Belgium, Antwerp, 1
  • Belgium, Bever, 1
  • Belgium, Brussels, 15
  • Belgium, Haacht, 1
  • Belgium, Leuven, 1
  • Belgium, Namur, 1
  • Belgium, Schaerbeek, 1
  • Bolivia, Santa_Cruz, 2
  • Bosnia_and_Herzegovina, Banja_Luka, 1
  • Bosnia_and_Herzegovina, Bugojno, 2
  • Bosnia_and_Herzegovina, Konjic, 3
  • Bosnia_and_Herzegovina, Mostar, 5
  • Bosnia_and_Herzegovina, Sarajevo, 17
  • Bosnia_and_Herzegovina, Zenica, 3
  • Brazil, Brasília, 1
  • Brazil, Curitiba, 2
  • Brazil, Porto_Alegre, 2
  • Brazil, Recife, 1
  • Brazil, Rio_de_Janeiro, 5
  • Brazil, São_Paulo, 6
  • Brazil, Tiradentes, 1
  • Bulgaria, Balčik, 2
  • Bulgaria, Dobrič, 2
  • Bulgaria, Sofia, 2
  • Bulgaria, Stara_Zagora, 2
  • Bulgaria, Varna, 3
  • Canada, Edmonton, 3
  • Canada, Montreal, 5
  • 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á, 3
  • Colombia, Medellin, 1
  • Croatia, Bjelovar, 1
  • Croatia, Čakovec, 2
  • Croatia, Dubrovnik, 4
  • Croatia, Islam_Grčki, 1
  • Croatia, Karlovac, 1
  • Croatia, Makarska, 1
  • Croatia, Motovun, 1
  • Croatia, Osijek, 9
  • Croatia, Poreč, 1
  • Croatia, Pula, 9
  • Croatia, Rijeka, 13
  • 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, 6
  • Croatia, Vinkovci, 1
  • Croatia, Virovitica, 1
  • Croatia, Vukovar, 2
  • Croatia, Zabok, 4
  • Croatia, Zadar, 1
  • Croatia, Zagreb, 78
  • Czech_Republic, Beroun, 2
  • Czech_Republic, Bohumín, 1
  • Czech_Republic, Boskovice, 1
  • Czech_Republic, Brno, 13
  • Czech_Republic, České_Budějovice, 2
  • Czech_Republic, Český_Krumlov, 2
  • Czech_Republic, Český_Těšín, 1
  • Czech_Republic, Chrudim, 3
  • Czech_Republic, Horni_Počernice, 3
  • Czech_Republic, Hradec_Králové, 4
  • Czech_Republic, Hronov, 2
  • Czech_Republic, Jičín, 1
  • Czech_Republic, Karlovy_Vary, 1
  • Czech_Republic, Krakovec, 2
  • Czech_Republic, Kroměříž, 1
  • Czech_Republic, Kuks, 2
  • Czech_Republic, Liberec, 2
  • Czech_Republic, Olomouc, 1
  • Czech_Republic, Opava, 1
  • Czech_Republic, Ostrava, 7
  • Czech_Republic, Plzeň, 2
  • Czech_Republic, Prague, 22
  • Czech_Republic, Prostějov, 1
  • Czech_Republic, Sudoměřice_u_Bechyně, 2
  • Czech_Republic, Tábor, 1
  • Czech_Republic, Tetín, 1
  • Denmark, Viborg, 1
  • Ecuador, Guayaquil, 1
  • Ecuador, Manta, 1
  • Ecuador, Quito, 1
  • Egypt, Cairo, 4
  • Estonia, Tallinn, 6
  • Ethiopia, Addis_Ababa, 1
  • Finland, Helsinki, 5
  • Finland, Kaustinen, 2
  • Finland, Mikkeli, 2
  • Finland, Siilinjärvi, 2
  • France, Annecy, 2
  • France, Arras, 1
  • France, Aubagne, 1
  • France, Besançon, 1
  • France, Cannes, 1
  • France, Chalon-sur-Saône, 1
  • France, Charleville-Mézières, 2
  • 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, 5
  • France, Metz, 1
  • France, Montpellier, 3
  • France, Montreuil, 2
  • France, Mulhouse, 1
  • France, Paris, 34
  • France, Perpignan, 1
  • France, Poitiers, 1
  • France, Rennes, 1
  • France, Saint-Erme-Outre-et-Ramecourt, 1
  • France, Saint-Étienne, 2
  • France, Sanary-sur-Mer, 2
  • 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, 20
  • Germany, Bochum, 1
  • Germany, Braunschweig, 1
  • Germany, Chemnitz, 1
  • Germany, Cologne, 6
  • Germany, Cottbus, 1
  • Germany, Deutzen, 1
  • Germany, Dresden, 6
  • 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, 4
  • Germany, Heidelberg, 1
  • Germany, Holzminden, 1
  • Germany, Ilmenau, 1
  • Germany, Ingolstadt, 1
  • Germany, Karlsruhe, 3
  • 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, 9
  • Germany, Nürnberg, 1
  • Germany, Oberhausen, 2
  • Germany, Oldenburg, 1
  • Germany, Osnabrück, 2
  • 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, 2
  • Greece, Larissa, 1
  • Greece, Thessaloniki, 2
  • Greece, Xanthi, 1
  • Hungary, Budaörs, 4
  • Hungary, Budapest, 17
  • 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, 7
  • Israel, Jerusalem, 2
  • Israel, Nahariya, 1
  • Israel, Rosh_Pina, 1
  • Israel, Sderot, 1
  • Israel, Shavei_Tzion, 1
  • Israel, Tel_Aviv, 10
  • Israel, Zikhron_Ya'akov, 1
  • Italy, Amantea, 1
  • Italy, Arezzo, 1
  • Italy, Bari, 1
  • Italy, Bologna, 4
  • Italy, Brescia, 1
  • Italy, Brunico, 2
  • Italy, Cesena, 2
  • Italy, Cremona, 2
  • Italy, Florence, 2
  • Italy, Gabicce_Mare, 1
  • Italy, Gorizia/Gorica, 5
  • Italy, La_Val, 2
  • Italy, Milan, 1
  • Italy, Naples, 1
  • Italy, Ostia, 1
  • Italy, Perugia, 1
  • Italy, Pordenone, 2
  • Italy, Prato, 1
  • Italy, Rome, 8
  • Italy, San_Michele_del_Carso/Vrh, 1
  • Italy, San_Vito_dei_Normanni, 1
  • Italy, Segrate, 1
  • Italy, Staranzano, 1
  • Italy, Trieste/Trst, 26
  • Italy, Udine/Videm, 3
  • Italy, Venice, 9
  • Japan, Beppu, 3
  • Japan, Fukushima, 1
  • Japan, Kobe, 1
  • Japan, Minamisōma, 1
  • Japan, Osaka, 1
  • Japan, Tokyo, 6
  • Japan, Tsukuba, 1
  • Kosovo, Peć, 2
  • Kosovo, Pristina, 2
  • Kosovo, Prizren, 1
  • Latvia, Cēsis, 1
  • Latvia, Riga, 4
  • Lithuania, Druskininkai, 1
  • Lithuania, Kaunas, 1
  • Lithuania, Vilnius, 4
  • Luxembourg, Luxembourg, 4
  • Malta, Gozo, 2
  • Malta, Valletta, 2
  • Mexico, Guadalajara, 1
  • Mexico, Mexico_City, 2
  • Montenegro, Bar, 1
  • Montenegro, Cetinje, 5
  • Montenegro, Kotor, 2
  • Montenegro, Mojkovac, 2
  • Montenegro, Podgorica, 4
  • Montenegro, Ulcinj, 1
  • Netherlands, Amsterdam, 7
  • Netherlands, Eindhoven, 3
  • Netherlands, Enschede, 1
  • Netherlands, Groningen, 1
  • Netherlands, Midsland, 1
  • Netherlands, Rotterdam, 1
  • Nicaragua, Managua, 1
  • North_Macedonia, Bitola, 4
  • North_Macedonia, Kumanovo, 1
  • North_Macedonia, Ohrid, 1
  • North_Macedonia, Prilep, 1
  • North_Macedonia, Radoviš, 1
  • North_Macedonia, Resen, 1
  • North_Macedonia, Skopje, 13
  • North_Macedonia, Štip, 1
  • North_Macedonia, Struga, 1
  • North_Macedonia, Strumica, 1
  • Norway, Bergen, 3
  • Norway, Harstad, 1
  • Norway, Oslo, 4
  • 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, 2
  • Poland, Lublin, 3
  • Poland, Mikołów, 1
  • Poland, Poznań, 1
  • Poland, Warsaw, 4
  • Poland, Wrocław, 2
  • Portugal, Almada, 1
  • Portugal, Cascais, 4
  • Portugal, Lisbon, 3
  • Portugal, Matosinhos, 1
  • Portugal, Porto, 1
  • Portugal, St._Maria_da_Feira, 1
  • Romania, Bucharest, 10
  • Romania, Giurgiu, 1
  • Romania, Mediaș, 1
  • Romania, Mogoşoaia, 1
  • Romania, Sibiu, 1
  • Russia, Irkutsk, 2
  • Russia, Moscow, 9
  • Russia, Omsk, 1
  • Russia, Perm, 1
  • Russia, Saint_Petersburg, 3
  • Serbia, Belgrade, 40
  • Serbia, Kragujevac, 5
  • Serbia, Niš, 2
  • Serbia, Novi_Sad, 8
  • Serbia, Pančevo, 1
  • Serbia, Smederevo, 1
  • Serbia, Subotica, 2
  • Serbia, Vršac, 1
  • Serbia, Zemun, 1
  • Singapore, Singapore, 4
  • Slovakia, Banská_Bystrica, 2
  • Slovakia, Bardejov, 2
  • Slovakia, Bratislava, 16
  • Slovakia, Košice, 6
  • Slovakia, Kremnica, 2
  • Slovakia, Nitra, 1
  • Slovakia, Trenčín, 1
  • Slovakia, Trnava, 1
  • Slovakia, Žilina, 5
  • South_Africa, Johannesburg, 1
  • South_Korea, Busan, 1
  • South_Korea, Gwacheon, 1
  • South_Korea, Seoul, 3
  • Spain, Alcalá_de_Henares, 2
  • Spain, Barcelona, 2
  • Spain, Getafe, 2
  • Spain, Madrid, 19
  • Spain, Sevilla, 1
  • Spain, Valencia, 1
  • Spain, Valladolid, 1
  • Spain, Vic, 1
  • Sri_Lanka, Colombo, 1
  • Sweden, Gothenburg, 3
  • Sweden, Stockholm, 2
  • Sweden, Umeå, 3
  • Switzerland, Basel, 11
  • Switzerland, Bellinzona, 4
  • Switzerland, Bern, 4
  • Switzerland, Biel/Bienne, 1
  • Switzerland, Chur, 3
  • Switzerland, Geneva, 3
  • Switzerland, Winterthur, 2
  • Switzerland, Zürich, 8
  • Turkey, Ankara, 1
  • Turkey, Istanbul, 3
  • Turkey, Izmir, 4
  • Ukraine, Kharkiv, 2
  • Ukraine, Kyiv, 2
  • United_Arab_Emirates, Dubai, 1
  • United_Kingdom, Aberdeen, 2
  • United_Kingdom, Banchory, 2
  • United_Kingdom, Belfast, 1
  • United_Kingdom, Cardiff, 2
  • United_Kingdom, East_Lothian, 2
  • United_Kingdom, Ebrington, 1
  • United_Kingdom, Findhorn, 2
  • United_Kingdom, Glenrothes, 2
  • United_Kingdom, Guildford, 4
  • United_Kingdom, Isle_of_Mull, 2
  • United_Kingdom, Liverpool, 2
  • United_Kingdom, London, 37
  • United_Kingdom, Manchester, 2
  • United_Kingdom, Newcastle, 1
  • United_Kingdom, North_Lanarkshire, 2
  • 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, 3
  • USA, Los_Angeles, 3
  • USA, Mason_City, 1
  • USA, Milwaukee, 1
  • USA, Minneapolis, 1
  • USA, Munhall, 1
  • USA, Nashville, 1
  • USA, New_York, 21
  • USA, North_Bethesda, 1
  • USA, Orlando, 1
  • USA, Park_City, 1
  • USA, Riverside_(CA), 2
  • USA, Salisbury, 1
  • USA, San_Francisco, 2
  • USA, San_Jose, 1
  • USA, Silver_Spring, 1
  • USA, Washington, 13
  • USA, Washington_D.C., 1
  • USA, Wilmington, 1
  • USA, Youngstown, 1