User:Charles Matthews/Training supporting links3

From Wikidata
Jump to: navigation, search

Training session “The Many Faces of the Wikimedia Universe”, 6 July 2017, Glass Room, Moore Library.

Talk[edit]

#defaultView:BubbleChart
SELECT ?area ?areaLabel ?count
WHERE 
{
  {
    SELECT ?area (COUNT(?item) AS ?count)    
WHERE {
        ?item wdt:P31 wd:Q13442814 .
        ?item wdt:P921 ?subject .
        ?subject wdt:P31 ?area .
        
       }
  GROUP BY ?area 
  }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?count)
LIMIT 100

Try it! }

Hands-on session[edit]

SELECT ?item ?itemLabel ?child ?childLabel
WHERE 
   {
     ?item wdt:P40 ?child .
     ?child wdt:P69 wd:Q192088 .
     SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
   }

Try it!