query-c2dafb85487a892ec001e21cc3e0c54d
added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10 added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?name ?nameLabel ORDER BY DESC(?count) LIMIT 10
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#added before 2016-10
SELECT ?name ?nameLabel (COUNT(?otherName) AS ?count)
WHERE
{
?name wdt:P31 wd:Q202444;
wdt:P460 ?otherName.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?name ?nameLabel
ORDER BY DESC(?count)
LIMIT 10
Query found at
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/hy
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/tr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/uk
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/advanced/zh