Restoring old revision of "Item:Q439"

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to a user name, among other benefits.

@@ label / en / label / en @@
-What are the 10 most common surnames of soccer players?
@@ aliases / es / 0 / aliases / es / 0 @@
-¿Cuáles son los 10 apellidos más frecuentes de futbolistas?
@@ aliases / en / 0 / aliases / en / 0 @@
-What are the 10 most common family names of football players?
@@ Property / query / Property / query @@
-SELECT ?surname WHERE { ?person wdt:P106 wd:Q937857. ?person wdt:P734 ?surname. } GROUP BY ?surname ORDER BY DESC(COUNT(DISTINCT ?person)) LIMIT 10
+SELECT ?surname WHERE { { SELECT ?surname (COUNT(?person) AS ?count) WHERE { ?person wdt:P106 wd:Q937857. ?person wdt:P734 ?surname. } GROUP BY ?surname } } ORDER BY DESC(?count) LIMIT 10
-dataset: Wikidata
-query language: SPARQL
@@ Property / mention / Property / mention @@
-family names (English)
+family name (English)
@@ Property / mention / Property / mention @@
-apellidos (Spanish)
+apellido (Spanish)
@@ Property / mention: apellidos (Spanish) / qualifier @@
-Wikidata item ID: Q101352
@@ Property / mention @@
-surnames (English)
@@ Property / mention: surnames (English) / rank @@
-Normal rank
@@ Property / mention: surnames (English) / qualifier @@
-Wikidata property ID: P734
@@ Property / mention: surnames (English) / qualifier @@
-Wikidata item ID: Q101352
@@ Property / mention @@
-names (English)
@@ Property / mention: names (English) / rank @@
-Normal rank
@@ Property / mention: names (English) / qualifier @@
-Wikidata item ID: Q82799
@@ Property / imports mentions from @@
-How many football players have the family name Suazo?
-Normal rank
@@ Property / mention @@
+occupation (English)
@@ Property / mention: occupation (English) / rank @@
+Normal rank
@@ Property / mention: occupation (English) / qualifier @@
+Wikidata property ID: P106
@@ Property / mention @@
+ocupación (Spanish)
@@ Property / mention: ocupación (Spanish) / rank @@
+Normal rank
@@ Property / mention: ocupación (Spanish) / qualifier @@
+Wikidata property ID: P106
@@ Property / mention @@
+association football player (English)
@@ Property / mention: association football player (English) / rank @@
+Normal rank
@@ Property / mention: association football player (English) / qualifier @@
+Wikidata item ID: Q937857
@@ Property / mention @@
+futbolista (Spanish)
@@ Property / mention: futbolista (Spanish) / rank @@
+Normal rank
@@ Property / mention: futbolista (Spanish) / qualifier @@
+Wikidata item ID: Q937857

Restoring old revision of "Item:Q439"

Navigation menu

Search