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