User:TweetsFactsAndQueries/Queries/items with most MusicBrainz IDs
Originally posted on Twitter and on Mastodon.
# items with most MusicBrainz IDs
SELECT ?item ?itemLabel ?itemDescription ?propertyLabel ?count ?hasSingleValueConstraint WITH {
SELECT ?item ?property (COUNT(?musicBrainzIdStatement) AS ?count) WHERE {
?property a wikibase:Property;
wdt:P2378 wd:Q14005;
wikibase:claim ?p.
?item ?p ?musicBrainzIdStatement.
}
GROUP BY ?item ?property
ORDER BY DESC(?count)
LIMIT 100
} AS %results WHERE {
INCLUDE %results.
BIND(EXISTS { ?property wdt:P2302 wd:Q19474404. } AS ?hasSingleValueConstraint)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count)