soccer - Quarry

This query is marked as a draft This query has been published by Edgars2007.

https://petscan.wmflabs.org/?psid=645198
"Arsenal_F.C._squad", "Tottenham_Hotspur_F.C._squad", "Liverpool_F.C._squad", "FC_Barcelona_squad", "Chelsea_F.C._squad", "A.C._Milan_squad", "Manchester_United_F.C._squad", "Real_Madrid_C.F._squad", "FC_Bayern_Munich_squad", "Hamburger_SV_squad", "Inter_Milan_squad", "Paris_Saint-Germain_F.C._squad", "Juventus_F.C._squad", "Olympique_Lyonnais_squad", "West_Ham_United_F.C._squad", "Villarreal_CF_squad", "Everton_F.C._squad", "Atlético_Madrid_squad", "Borussia_Dortmund_squad", "Olympique_de_Marseille_squad", "Cagliari_Calcio_squad", "Bayer_04_Leverkusen_squad", "VfL_Bochum_squad", "ACF_Fiorentina_squad", "A.S._Roma_squad", "S.S._Lazio_squad", "Watford_F.C._squad", "AS_Monaco_FC_squad", "U.S._Città_di_Palermo_squad", "Middlesbrough_F.C._squad", "U.C._Sampdoria_squad", "FC_Schalke_04_squad", "Manchester_City_F.C._squad", "Southampton_F.C._squad", "SV_Werder_Bremen_squad", "Burnley_F.C._squad", "Hertha_BSC_squad", "Eintracht_Frankfurt_squad", "Vicenza_Calcio_squad", "A.C._ChievoVerona_squad", "Ascoli_Picchio_F.C._1898_squad", "Calcio_Catania_squad", "Empoli_F.C._squad", "U.S._Lecce_squad", "Atalanta_B.C._squad", "A.S._Livorno_Calcio_squad", "Parma_Calcio_1913_squad", "U.S._Reggina_1914_squad", "Torino_F.C._squad", "Udinese_Calcio_squad", "Stade_Rennais_F.C._squad", "Hull_City_A.F.C._squad", "Sevilla_FC_squad", "Crystal_Palace_F.C._squad", "Sunderland_A.F.C._squad", "West_Bromwich_Albion_F.C._squad", "Leicester_City_F.C._squad", "Stoke_City_F.C._squad", "Chamois_Niortais_F.C._squad", "A.F.C._Bournemouth_squad", "SC_Freiburg_squad", "Swansea_City_A.F.C._squad", "RC_Strasbourg_squad", "VfB_Stuttgart_squad", "Valencia_CF_squad", "Athletic_Bilbao_squad", "FC_Girondins_de_Bordeaux_squad", "Real_Betis_squad", "S.S.C._Napoli_squad", "U.C._AlbinoLeffe_squad", "Celta_de_Vigo_squad", "AJ_Auxerre_squad", "Le_Mans_FC_squad", "FC_Sochaux-Montbéliard_squad", "Troyes_AC_squad", "Angers_SCO_squad", "FC_Lorient_squad", "Deportivo_de_La_Coruña_squad", "AS_Saint-Étienne_squad", "AS_Nancy_squad", "Real_Sociedad_squad", "1._FC_Nürnberg_squad", "1._FSV_Mainz_05_squad", "CS_Sedan_Ardennes_squad", "Hannover_96_squad", "Borussia_Mönchengladbach_squad", "Karlsruher_SC_squad", "Arminia_Bielefeld_squad", "VfL_Wolfsburg_squad", "Genoa_C.F.C._squad", "RCD_Espanyol_squad", "FC_Nantes_squad", "CA_Osasuna_squad", "RC_Lens_squad", "OGC_Nice_squad", "FC_Metz_squad", "SC_Bastia_squad", "Toulouse_FC_squad", "Valenciennes_FC_squad", "AC_Ajaccio_squad", "1._FC_Köln_squad", "MSV_Duisburg_squad", "Bologna_F.C._1909_squad", "Málaga_CF_squad", "Montpellier_HSC_squad", "1._FC_Kaiserslautern_squad", "Dynamo_Dresden_squad", "SM_Caen_squad", "Stade_Laval_squad", "F.C._Hansa_Rostock_squad", "Mantova_F.C._squad", "Le_Havre_AC_squad", "Lille_OSC_squad", "Grenoble_Foot_38_squad", "TSG_1899_Hoffenheim_squad", "Delfino_Pescara_1936_squad", "TSV_1860_Munich_squad", "Sporting_de_Gijón_squad", "SV_Werder_Bremen_II_squad", "FC_Ingolstadt_04_squad", "U.S._Avellino_1912_squad", "Frosinone_Calcio_squad", "SpVgg_Greuther_Fürth_squad", "Brescia_Calcio_squad", "FC_Augsburg_squad", "1._FC_Union_Berlin_squad", "US_Boulogne_squad", "VfL_Osnabrück_squad", "SV_Wehen_Wiesbaden_squad", "FC_St._Pauli_squad", "FSV_Frankfurt_squad", "FC_Erzgebirge_Aue_squad", "VfR_Aalen_squad", "F.C._Bari_1908_squad", "Deportivo_Alavés_squad", "Amiens_SC_squad", "Fortuna_Düsseldorf_squad", "SSV_Jahn_Regensburg_squad", "Modena_F.C._squad", "UD_Las_Palmas_squad", "SC_Paderborn_07_squad", "Borussia_Dortmund_II_squad", "VfB_Stuttgart_II_squad", "Olympique_Lyonnais_(Ladies)_squad", "Paris_Saint-Germain_Féminines_squad", "A.C._Cesena_squad", "Stade_Brestois_29_squad", "Clermont_Foot_squad", "U.S._Alessandria_Calcio_1912_squad", "RB_Leipzig_squad", "Hallescher_FC_squad", "SV_Sandhausen_squad", "Chemnitzer_FC_squad", "Montpellier_HSC_Ladies_squad", "FCF_Juvisy_squad", "Tours_FC_squad", "Granada_CF_squad", "AS_Saint-Étienne_(Ladies)_squad", "Novara_Calcio_squad", "F.C._Crotone_squad", "Eintracht_Braunschweig_squad", "LB_Châteauroux_squad", "Dijon_FCO_squad", "Hellas_Verona_F.C._squad", "SC_Preußen_Münster_squad", "En_Avant_de_Guingamp_squad", "Stade_de_Reims_squad", "1._FC_Heidenheim_squad", "FC_Rot-Weiß_Erfurt_squad", "SV_Darmstadt_98_squad", "Gazélec_Ajaccio_squad", "Ternana_Calcio_squad", "Nîmes_Olympique_squad", "FSV_Zwickau_squad", "S.S._Juve_Stabia_squad", "Sportfreunde_Lotte_squad", "SC_Fortuna_Köln_squad", "A.S._Cittadella_squad", "Calcio_Padova_squad", "F.C._Pro_Vercelli_1892_squad", "U.S._Sassuolo_Calcio_squad", "Spezia_Calcio_squad", "CA_Bastia_squad", "Holstein_Kiel_squad", "Carpi_F.C._1909_squad", "Trapani_Calcio_squad", "U.S._Latina_Calcio_squad", "SD_Eibar_squad", "SG_Sonnenhof_Großaspach_squad", "US_Créteil-Lusitanos_squad", "1._FSV_Mainz_05_II_squad", "CD_Leganés_squad", "A.C._Perugia_Calcio_squad", "Virtus_Entella_squad", "US_Orléans_squad", "Red_Star_F.C._squad", "Paris_FC_squad", "U.S._Salernitana_1919_squad", "Calcio_Como_squad", "Matera_Calcio_squad", "S.S._Akragas_squad", "S.S._Robur_Siena_squad", "1._FC_Magdeburg_squad", "Football_Bourg-en-Bresse_Péronnas_01_squad", "ASPTT_Albi_squad", "Würzburger_Kickers_squad", "A.C._Pisa_1909_squad", "Benevento_Calcio_squad"

SQL

select now();

use enwiki_p;
select p.page_title, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where  l.ll_from in (select tl.tl_from from templatelinks tl
						where tl.tl_title in ("Arsenal_F.C._squad", "Tottenham_Hotspur_F.C._squad", "Liverpool_F.C._squad", "FC_Barcelona_squad", "Chelsea_F.C._squad", "A.C._Milan_squad", "Manchester_United_F.C._squad", "Real_Madrid_C.F._squad", "FC_Bayern_Munich_squad", "Hamburger_SV_squad", "Inter_Milan_squad", "Paris_Saint-Germain_F.C._squad", "Juventus_F.C._squad", "Olympique_Lyonnais_squad", "West_Ham_United_F.C._squad", "Villarreal_CF_squad", "Everton_F.C._squad", "Atlético_Madrid_squad", "Borussia_Dortmund_squad", "Olympique_de_Marseille_squad", "Cagliari_Calcio_squad", "Bayer_04_Leverkusen_squad", "VfL_Bochum_squad", "ACF_Fiorentina_squad", "A.S._Roma_squad", "S.S._Lazio_squad", "Watford_F.C._squad", "AS_Monaco_FC_squad", "U.S._Città_di_Palermo_squad", "Middlesbrough_F.C._squad", "U.C._Sampdoria_squad", "FC_Schalke_04_squad", "Manchester_City_F.C._squad", "Southampton_F.C._squad", "SV_Werder_Bremen_squad", "Burnley_F.C._squad", "Hertha_BSC_squad", "Eintracht_Frankfurt_squad", "Vicenza_Calcio_squad", "A.C._ChievoVerona_squad", "Ascoli_Picchio_F.C._1898_squad", "Calcio_Catania_squad", "Empoli_F.C._squad", "U.S._Lecce_squad", "Atalanta_B.C._squad", "A.S._Livorno_Calcio_squad", "Parma_Calcio_1913_squad", "U.S._Reggina_1914_squad", "Torino_F.C._squad", "Udinese_Calcio_squad", "Stade_Rennais_F.C._squad", "Hull_City_A.F.C._squad", "Sevilla_FC_squad", "Crystal_Palace_F.C._squad", "Sunderland_A.F.C._squad", "West_Bromwich_Albion_F.C._squad", "Leicester_City_F.C._squad", "Stoke_City_F.C._squad", "Chamois_Niortais_F.C._squad", "A.F.C._Bournemouth_squad", "SC_Freiburg_squad", "Swansea_City_A.F.C._squad", "RC_Strasbourg_squad", "VfB_Stuttgart_squad", "Valencia_CF_squad", "Athletic_Bilbao_squad", "FC_Girondins_de_Bordeaux_squad", "Real_Betis_squad", "S.S.C._Napoli_squad", "U.C._AlbinoLeffe_squad", "Celta_de_Vigo_squad", "AJ_Auxerre_squad", "Le_Mans_FC_squad", "FC_Sochaux-Montbéliard_squad", "Troyes_AC_squad", "Angers_SCO_squad", "FC_Lorient_squad", "Deportivo_de_La_Coruña_squad", "AS_Saint-Étienne_squad", "AS_Nancy_squad", "Real_Sociedad_squad", "1._FC_Nürnberg_squad", "1._FSV_Mainz_05_squad", "CS_Sedan_Ardennes_squad", "Hannover_96_squad", "Borussia_Mönchengladbach_squad", "Karlsruher_SC_squad", "Arminia_Bielefeld_squad", "VfL_Wolfsburg_squad", "Genoa_C.F.C._squad", "RCD_Espanyol_squad", "FC_Nantes_squad", "CA_Osasuna_squad", "RC_Lens_squad", "OGC_Nice_squad", "FC_Metz_squad", "SC_Bastia_squad", "Toulouse_FC_squad", "Valenciennes_FC_squad", "AC_Ajaccio_squad", "1._FC_Köln_squad", "MSV_Duisburg_squad", "Bologna_F.C._1909_squad", "Málaga_CF_squad", "Montpellier_HSC_squad", "1._FC_Kaiserslautern_squad", "Dynamo_Dresden_squad", "SM_Caen_squad", "Stade_Laval_squad", "F.C._Hansa_Rostock_squad", "Mantova_F.C._squad", "Le_Havre_AC_squad", "Lille_OSC_squad", "Grenoble_Foot_38_squad", "TSG_1899_Hoffenheim_squad", "Delfino_Pescara_1936_squad", "TSV_1860_Munich_squad", "Sporting_de_Gijón_squad", "SV_Werder_Bremen_II_squad", "FC_Ingolstadt_04_squad", "U.S._Avellino_1912_squad", "Frosinone_Calcio_squad", "SpVgg_Greuther_Fürth_squad", "Brescia_Calcio_squad", "FC_Augsburg_squad", "1._FC_Union_Berlin_squad", "US_Boulogne_squad", "VfL_Osnabrück_squad", "SV_Wehen_Wiesbaden_squad", "FC_St._Pauli_squad", "FSV_Frankfurt_squad", "FC_Erzgebirge_Aue_squad", "VfR_Aalen_squad", "F.C._Bari_1908_squad", "Deportivo_Alavés_squad", "Amiens_SC_squad", "Fortuna_Düsseldorf_squad", "SSV_Jahn_Regensburg_squad", "Modena_F.C._squad", "UD_Las_Palmas_squad", "SC_Paderborn_07_squad", "Borussia_Dortmund_II_squad", "VfB_Stuttgart_II_squad", "Olympique_Lyonnais_(Ladies)_squad", "Paris_Saint-Germain_Féminines_squad", "A.C._Cesena_squad", "Stade_Brestois_29_squad", "Clermont_Foot_squad", "U.S._Alessandria_Calcio_1912_squad", "RB_Leipzig_squad", "Hallescher_FC_squad", "SV_Sandhausen_squad", "Chemnitzer_FC_squad", "Montpellier_HSC_Ladies_squad", "FCF_Juvisy_squad", "Tours_FC_squad", "Granada_CF_squad", "AS_Saint-Étienne_(Ladies)_squad", "Novara_Calcio_squad", "F.C._Crotone_squad", "Eintracht_Braunschweig_squad", "LB_Châteauroux_squad", "Dijon_FCO_squad", "Hellas_Verona_F.C._squad", "SC_Preußen_Münster_squad", "En_Avant_de_Guingamp_squad", "Stade_de_Reims_squad", "1._FC_Heidenheim_squad", "FC_Rot-Weiß_Erfurt_squad", "SV_Darmstadt_98_squad", "Gazélec_Ajaccio_squad", "Ternana_Calcio_squad", "Nîmes_Olympique_squad", "FSV_Zwickau_squad", "S.S._Juve_Stabia_squad", "Sportfreunde_Lotte_squad", "SC_Fortuna_Köln_squad", "A.S._Cittadella_squad", "Calcio_Padova_squad", "F.C._Pro_Vercelli_1892_squad", "U.S._Sassuolo_Calcio_squad", "Spezia_Calcio_squad", "CA_Bastia_squad", "Holstein_Kiel_squad", "Carpi_F.C._1909_squad", "Trapani_Calcio_squad", "U.S._Latina_Calcio_squad", "SD_Eibar_squad", "SG_Sonnenhof_Großaspach_squad", "US_Créteil-Lusitanos_squad", "1._FSV_Mainz_05_II_squad", "CD_Leganés_squad", "A.C._Perugia_Calcio_squad", "Virtus_Entella_squad", "US_Orléans_squad", "Red_Star_F.C._squad", "Paris_FC_squad", "U.S._Salernitana_1919_squad", "Calcio_Como_squad", "Matera_Calcio_squad", "S.S._Akragas_squad", "S.S._Robur_Siena_squad", "1._FC_Magdeburg_squad", "Football_Bourg-en-Bresse_Péronnas_01_squad", "ASPTT_Albi_squad", "Würzburger_Kickers_squad", "A.C._Pisa_1909_squad", "Benevento_Calcio_squad") and tl_namespace=10 and tl.tl_from_namespace=0)
and 
p.page_namespace=0 and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
group by l.ll_from
order by count(l.ll_lang) desc

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...