SPARQL Query: All video works that are parts of other works

Note: Try this query as a TABLE visualization as well from the menu on the left-hand side in this window in order to see individual counts.



Query:

To run this query yourself, copy and paste the code below in the gray box into the Wikidata Query Service. Click here for a tutorial and notes on how to modify this query or write your own!

 

Query source code:

#defaultView:BubbleChart
SELECT ?other_worksLabel (COUNT (?item) as ?count)
WHERE
{
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item wdt:P1343 wd:Q91439317;
    wdt:P31 wd:Q838948.
  FILTER ( ?item != wd:Q95099146)
  FILTER ( ?item != wd:Q94993998)
  ?item wdt:P527 ?other_works.
  ?other_works wdt:P31 wd:Q20742776.
}
GROUP BY ?other_worksLabel 
ORDER BY DESC (?count)