User:MisterSynergy/sports/P641 worklists

From Wikidata
Jump to navigation Jump to search
+/−
MisterSynergy’s work lists

Special:PrefixIndex/User:MisterSynergy/ • User:MisterSynergy/sysop/header • item statistics • patrol • pages with code • activity • jobs

[edit]

Important items

[edit]

Subclasses of sport:

Instances of sport (should not happen): 

SELECT ?item { ?item p:P31 [ ps:P31 wd:Q349 ] . }
Try it!

Queries

[edit]
SELECT ?item ?itemLabel ?sport ?sportLabel WHERE {
  ?item wdt:P641 ?sport . 
  MINUS { ?sport (wdt:P279)* wd:Q349 . }
  MINUS { ?sport (wdt:P279)* wd:Q20037067 . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} ORDER BY ?sportLabel
Try it! 
SELECT ?sport (COUNT(DISTINCT ?item) AS ?number) WHERE {
  ?item wdt:P641 ?sport . 
  MINUS { ?sport (wdt:P279)* wd:Q349 . }
  MINUS { ?sport (wdt:P279)* wd:Q20037067 . }
} GROUP BY ?sport ORDER BY DESC(?number)
Try it!

List

[edit]

P2416

[edit]

Missing field of this occupation (P425) in sportsperson items

[edit]
SELECT ?occupation (COUNT(?occupation) AS ?cnt) {
  ?item wdt:P106 ?occupation .
  ?occupation wdt:P279* wd:Q2066131 .
  MINUS {
    ?occupation wdt:P425 ?field .
  }
} GROUP BY ?occupation ORDER BY DESC(?cnt)
Try it!

Remove P641 in favor of P106 for sportspersons

[edit]

In sportsperson items, P106 has several advantages over P641 and shall preferably be used. In fact, P641 does not add any additional information to an item that has already a corresponding P106 claim. This is a (preliminary) worklist to remove P641 in those cases systematically at some point in the future, without losing any information. 

#SELECT ?item ?sport ?occupation ?field {
SELECT ?sport (COUNT(?sport) AS ?cnt) {
  ?item wdt:P641 ?sport .
  ?item wdt:P106 ?occupation .
  ?occupation (wdt:P279)* wd:Q2066131 .
  ?occupation wdt:P425 ?field .
  FILTER(?field != ?sport) .
} GROUP BY ?sport ORDER BY DESC(?cnt)
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:MisterSynergy/sports/P641_worklists&oldid=990891836"