european_venues2.sql

and
(metadata like "%Camp Nou%" or
metadata like "%Wembley%" or
metadata like "%Croke Park%" or
metadata like "%Twickenham%" or
metadata like "%Signal Iduna Park%" or
metadata like "%Stade de France%" or
metadata like "%Santiago Bernabéu%" or
metadata like "%Luzhniki%" or
metadata like "%San Siro%" or
metadata like "%Atatürk Olympic%" or
metadata like "%Ataturk Olympic%" or
metadata like "%Old Trafford%" or
metadata like "%Spyros Louis Olympic%" or
metadata like "%Allianz%" or
metadata like "%Olympiastadion%" or
metadata like "%Millennium%" or
metadata like "%Stadio Olimpico%" or
metadata like "%NSC Olimpiyskiy%" or
metadata like "%Olympiastadion%" or
metadata like "%Baku National%" or
metadata like "%Krestovsky%" or
metadata like "%Wanda Metropolitano%" or
metadata like "%Stade Vélodrome%" or
metadata like "%Murrayfield%" or
metadata like "%Estádio da Luz%" or
metadata like "%Veltins-Arena%" or
metadata like "%Benito Villamarín%" or
metadata like "%Mercedes-Benz%" or
metadata like "%Celtic Park%" or
metadata like "%Stadio San Paolo%" or
metadata like "%London%" or
metadata like "%Emirates%" or
metadata like "%Parc Olympique Lyonnais%" or
metadata like "%PGE Narodowy%" or
metadata like "%Stadio San Nicola%" or
metadata like "%Olímpico de Sevilla%" or
metadata like "%Olimpico de Sevilla%" or
metadata like "%Volksparkstadion%" or
metadata like "%Estadi Olímpic Lluís Companys%" or
metadata like "%Arena Naţională%" or
metadata like "%Arena Nationala%" or
metadata like "%Stadium Rajko Mitić%" or
metadata like "%Silesian%" or
metadata like "%Etihad%" or
metadata like "%Estadi de Mestalla%" or
metadata like "%Esprit%" or
metadata like "%Vicente Calderón%" or
metadata like "%Vicente Calderon%" or
metadata like "%Boris Paichadze Dinamo%" or
metadata like "%Friends%" or
metadata like "%Hrazdan%" or
metadata like "%Anfield%" or
metadata like "%Borussia-Park%" or
metadata like "%Borussia%" or
metadata like "%Amsterdam%" or
metadata like "%Semple%" or
metadata like "%San Mamés%" or
metadata like "%Ernst Happel Stadion%" or
metadata like "%St James' Park%" or
metadata like "%Türk Telekom%" or
metadata like "%Donbass%" or
metadata like "%Hampden Park%" or
metadata like "%Aviva%" or
metadata like "%De Kuip%" or
metadata like "%Commerzbank-Arena%" or
metadata like "%Commerzbank%" or
metadata like "%İzmir Atatürk%" or
metadata like "%Ibrox%" or
metadata like "%RheinEnergieStadion%" or
metadata like "%Stade Pierre-Mauroy%" or
metadata like "%Estádio José Alvalade%" or
metadata like "%Jose Alvalade%" or
metadata like "%King Baudouin%" or
metadata like "%Estádio do Dragão%" or
metadata like "%do Dragao%" or
metadata like "%Max-Morlock-Stadion%" or
metadata like "%Gaelic Grounds%" or
metadata like "%Fritz-Walter-Stadion%" or
metadata like "%HDI-Arena%" or
metadata like "%Stadium of Light%" or
metadata like "%Şükrü Saracoğlu%" or
metadata like "%Sukru Saracoglu%" or
metadata like "%Stadio Artemio Franchi%" or
metadata like "%Parc des Princes%" or
metadata like "%Volgograd%" or
metadata like "%Otkrytie%" or
metadata like "%Kazan%" or
metadata like "%Panathinaiko%" or
metadata like "%Páirc Uí Chaoimh%" or
metadata like "%Pairc Chaoimh%" or
metadata like "%Rostov%" or
metadata like "%Cosmos%" or
metadata like "%Strelka%" or
metadata like "%Mordovia%" or
metadata like "%Red Bull%" or
metadata like "%Stadion Energa Gdańsk%" or
metadata like "%Vasil Levski National%" or
metadata like "%Bursa Büyüksehir%" or
metadata like "%INEA Stadion%" or
metadata like "%Fitzgerald%" or
metadata like "%Ullevi%" or
metadata like "%Villa Park%" or
metadata like "%Wrocław City%" or
metadata like "%Wroclaw City%" or
metadata like "%Ramón Sánchez Pizjuán%" or
metadata like "%Weserstadion%" or
metadata like "%Torku%" or
metadata like "%Matmut Atlantique%" or
metadata like "%MacHale Park%" or
metadata like "%Stade Geoffroy-Guichard%" or
metadata like "%Vodafone%" or
metadata like "%Stamford Bridge%" or
metadata like "%Ramat Gan%" or
metadata like "%Şenol Güneş%" or
metadata like "%Şenol Gunes%" or
metadata like "%Juventus%" or
metadata like "%Stade Bollaert-Delelis%" or
metadata like "%Fisht Olympic%" or
metadata like "%Dinamo%" or
metadata like "%Helsinki Olympic%" or
metadata like "%Estadi Cornellà-El Prat%" or
metadata like "%Estadi Cornella%" or
metadata like "%Stade Gerland%" or
metadata like "%Stadio San Filippo%" or
metadata like "%Metalist%" or
metadata like "%Hillsborough%" or
metadata like "%Goodison Park%" or
metadata like "%Elland Road%" or
metadata like "%Stadio Renato Dall'Ara%" or
metadata like "%Stadio Renato%" or
metadata like "%Stadio Marcantonio Bentegodi%" or
metadata like "%Manuel Martínez Valero%" or
metadata like "%St. Jakob-Park%" or
metadata like "%St Jakob Park%" or
metadata like "%Stade de la Beaujoire%" or
metadata like "%Telia Parken%" or
metadata like "%Stadio Renzo Barbera%" or
metadata like "%Estádio Nacional%" or
metadata like "%Stadio Arechi%" or
metadata like "%Maksimir%" or
metadata like "%Kazhimukan Munaitpasov%" or
metadata like "%Shymkent%" or
metadata like "%Cebeci İnönü%" or
metadata like "%Cebeci Inonu%" or
metadata like "%Stadio Luigi Ferraris%" or
metadata like "%Stadio Via del Mare%" or
metadata like "%White Hart Lane%" or
metadata like "%St Tiernach's Park%" or
metadata like "%St Tiernachs Park%" or
metadata like "%Central%" or
metadata like "%Yekaterinburg%" or
metadata like "%Asim Ferhatović Hase%" or
metadata like "%Asim Ferhatovic Hase%" or
metadata like "%Allianz Riviera%" or
metadata like "%Gaziantep%" or
metadata like "%Stadium Municipal%" or
metadata like "%Ludwigspark Stadion%" or
metadata like "%Boleyn Ground%" or
metadata like "%Kaliningrad%" or
metadata like "%Riverside%" or
metadata like "%Stadion Poljud%" or
metadata like "%Olympic%" or
metadata like "%Philips Stadion%" or
metadata like "%New Eskişehir%" or
metadata like "%Arena Lviv%" or
metadata like "%Stade Jacques Chaban-Delmas%" or
metadata like "%Stade Jacques Chaban Delmas%" or
metadata like "%Samsun%" or
metadata like "%Riazor%" or
metadata like "%La Romareda%" or
metadata like "%Grotenburg-Stadion%" or
metadata like "%Chornomorets%" or
metadata like "%Opel%" or
metadata like "%Pearse%" or
metadata like "%Gelredome%" or
metadata like "%Pride Park%" or
metadata like "%Karaiskakis%" or
metadata like "%Cardiff City%" or
metadata like "%Stadion Henryka Reymana%" or
metadata like "%Metallurg%" or
metadata like "%Nueva Condomina%" or
metadata like "%Krasnodar%" or
metadata like "%Khimik%" or
metadata like "%Kemerovo%" or
metadata like "%Tele2%" or
metadata like "%Antalya 100.yıl%" or
metadata like "%Izmit%" or
metadata like "%Dan Păltinişanu%" or
metadata like "%Dan Paltinişanu%" or
metadata like "%New Tivoli%" or
metadata like "%Stade de la Mosson%" or
metadata like "%Kadir Has%" or
metadata like "%Estádio Municipal de Aveiro%" or
metadata like "%Municipal de Aveiro%" or
metadata like "%Partizan%" or
metadata like "%Bramall Lane%" or
metadata like "%St Mary's%" or
metadata like "%St. Mary's%" or
metadata like "%St Marys%" or
metadata like "%St. Marys%" or
metadata like "%Ricoh%" or
metadata like "%Philip II%" or
metadata like "%Balaídos%" or
metadata like "%Balaídos%" or
metadata like "%Republican Spartak%" or
metadata like "%Stadio Nereo Rocco%" or
metadata like "%Gran Canaria%" or
metadata like "%Rosenaustadion%" or
metadata like "%Stadio Euganeo%" or
metadata like "%King Power%" or
metadata like "%Anoeta%" or
metadata like "%Glücksgas%" or
metadata like "%Hypo-Arena%" or
metadata like "%Hypo%" or
metadata like "%Spartak%" or
metadata like "%Casement Park%" or
metadata like "%Breffni Park%" or
metadata like "%Stadio Flaminio%" or
metadata like "%Stade de Suisse%" or
metadata like "%Lord's Cricket Ground%" or
metadata like "%U%" or
metadata like "%Ernest Pohl%" or
metadata like "%Polish Army%" or
metadata like "%Tsentralnyi Profsoyuz Stadion%" or
metadata like "%Teddy%" or
metadata like "%Shakhtar%" or
metadata like "%Molineux%" or
metadata like "%Kuban%" or
metadata like "%Schauinsland-Reisen-Arena%" or
metadata like "%Ewood Park%" or
metadata like "%Rewirpowerstadion%" or
metadata like "%Tofiq Bahramov%" or
metadata like "%Roazhon Park%" or
metadata like "%Dnipro-Arena%" or
metadata like "%Stadionul Ion Oblemenco%" or
metadata like "%Sammy Ofer%" or
metadata like "%American Express Community%" or
metadata like "%Impuls%" or
metadata like "%City Ground%" or
metadata like "%Terek%" or
metadata like "%Stadium MK%" or
metadata like "%Carlos Tartiere%" or
metadata like "%Cluj%" or
metadata like "%Portman Road%" or
metadata like "%Estádio Algarve%" or
metadata like "%Algarve%" or
metadata like "%Estádio Municipal de Braga%" or
metadata like "%Municipal%" or
metadata like "%BayArena%" or
metadata like "%De Grolsch Veste%" or
metadata like "%Rhein-Neckar%" or
metadata like "%Central %" or
metadata like "%Volkswagen%" or
metadata like "%Stade de Genève%" or
metadata like "%La Rosaleda%" or
metadata like "%Stade Maurice Dufrasne%" or
metadata like "%St Andrew's%" or
metadata like "%Estádio D. Afonso Henriques%" or
metadata like "%VEB %" or
metadata like "%Anzhi-Arena%" or
metadata like "%Astana%" or
metadata like "%Malmö Stadion%" or
metadata like "%José Rico Pérez%" or
metadata like "%Letzigrund%" or
metadata like "%Tivoli-Neu%" or
metadata like "%Red Bull (Salzburg)%" or
metadata like "%Metalurh%" or
metadata like "%Wildparkstadion%" or
metadata like "%Estádio Cidade de Coimbra%" or
metadata like "%Stade de la Meinau%" or
metadata like "%Millerntor-Stadion%" or
metadata like "%Jan Breydel%" or
metadata like "%El Molinón%" or
metadata like "%Brøndby%" or
metadata like "%DKB-Arena%" or
metadata like "%Şanlıurfa GAP%" or
metadata like "%Lokomotiv (Moscow)%" or
metadata like "%Macron%" or
metadata like "%Sakarya%" or
metadata like "%Toumba%" or
metadata like "%Britannia%" or
metadata like "%Stadionul Steaua%" or
metadata like "%Estádio do Bessa%" or
metadata like "%Constant Vanden Stock%" or
metadata like "%Ukraina%" or
metadata like "%Estádio 1º de Maio%" or
metadata like "%Allianz Stadion%" or
metadata like "%Lefkoşa Atatürk Stadı%" or
metadata like "%Stadio Renato Curi%" or
metadata like "%Ullevaal Stadion%" or
metadata like "%Stadio Olimpico Grande Torino%" or
metadata like "%Stadio Ennio Tardini%" or
metadata like "%Stadio Oreste Granillo%" or
metadata like "%Stadio Erasmo Iacovone%" or
metadata like "%Stadio Mario Rigamonti%" or
metadata like "%Odsal%" or
metadata like "%Schüco Arena%" or
metadata like "%Schuco Arena%" or
metadata like "%MDCC-Arena%" or
metadata like "%Carrow Road%" or
metadata like "%Mikheil Meskhi%" or
metadata like "%The Valley London%" or
metadata like "%Malatya%" or
metadata like "%Ashton Gate%" or
metadata like "%Carl-Benz-Stadion%" or
metadata like "%CarlBenz%" or
metadata like "%Central (Krasnoyarsk)%" or
metadata like "%Krasnoyarsk%" or
metadata like "%O'Moore Park%" or
metadata like "%Pankritio%" or
metadata like "%Kaftanzoglio%" or
metadata like "%Stade Municipal Saint-Symphorien%" or
metadata like "%Stade Municipal Saint Symphorien%" or
metadata like "%The Oval%" or
metadata like "%José Zorrilla%" or
metadata like "%The Hawthorns%" or
metadata like "%Selhurst Park%" or
metadata like "%Stadio Partenio%" or
metadata like "%Ganja City%" or
metadata like "%Stade Guy Boniface%" or
metadata like "%Abe Lenstra Stadion%" or
metadata like "%Stadio del Conero%" or
metadata like "%Welford Road%" or
metadata like "%Yuvileiny%" or
metadata like "%Craven Cottage%" or
metadata like "%RSC Olimpiyskiy%" or
metadata like "%Thomond Park%" or
metadata like "%Slavia%" or
metadata like "%Mersin%" or
metadata like "%KC %" or
metadata like "%Estadi Ciutat de València%" or
metadata like "%Stade Océane%" or
metadata like "%Tsentralnyi Stadion %" or
metadata like "%Mykolaiv%" or
metadata like "%Stadio Friuli%" or
metadata like "%DW %" or
metadata like "%Valley Parade%" or
metadata like "%Edgbaston Cricket Ground%" or
metadata like "%Wexford Park%" or
metadata like "%St Jarlath's Park%" or
metadata like "%Dr. Hyde Park%" or
metadata like "%Stadio Pino Zaccheria%" or
metadata like "%Stadion Rote Erde%" or
metadata like "%Skatbank-Arena%" or
metadata like "%Bijeli Brijeg%" or
metadata like "%CSK %" or
metadata like "%Darlington%" or
metadata like "%MMArena%" or
metadata like "%Stade du Hainaut%" or
metadata like "%Ay-Yıldız%" or
metadata like "%New 4 Eylül%" or
metadata like "%Stadion%" or
metadata like "%Netanya%" or
metadata like "%Groupama Aréna%" or
metadata like "%Pittodrie%" or
metadata like "%Lerkendal Stadion%" or
metadata like "%Eden Aréna%" or
metadata like "%Nagyerdei Stadion%" or
metadata like "%Generali%" or
metadata like "%Štadión Antona Malatinského%" or
metadata like "%Stade Louis II%" or
metadata like "%Loro Borici%" or
metadata like "%Turner%" or
metadata like "%Apostolos Nikolaidis%" or
metadata like "%Podgorica City%" or
metadata like "%Bloomfield%" or
metadata like "%Borisov%" or
metadata like "%Elbasan%" or
metadata like "%Guldfågeln%" or
metadata like "%Aker Stadion%" or
metadata like "%HaMoshava%" or
metadata like "%New Meadow%" or
metadata like "%Haladas%")

group by metadata
order by count desc