User:Reosarevok/Wikidata Example Queries: Difference between revisions
From MusicBrainz Wiki
Jump to navigationJump to search
Reosarevok (talk | contribs) No edit summary |
Reosarevok (talk | contribs) m (Add language to operas) |
||
Line 54: | Line 54: | ||
[https://query.wikidata.org/#%23Select%20operas%20that%20don%27t%20have%20a%20MusicBrainz%20ID%20stored%0ASELECT%20%3FentityLabel%20%3Fentity%20%7B%0A%09%3Fentity%20wdt%3AP31%20wd%3AQ1344%20.%0A%20%20%09MINUS%20%7B%20%3Fentity%20wdt%3AP435%20%5B%5D%20%7D%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D Operas that don't have a MusicBrainz ID stored] |
[https://query.wikidata.org/#%23Select%20operas%20that%20don%27t%20have%20a%20MusicBrainz%20ID%20stored%0ASELECT%20%3FentityLabel%20%3Fentity%20%3FlanguageLabel%20%7B%0A%09%3Fentity%20wdt%3AP31%20wd%3AQ1344%20.%0A%20%20%09MINUS%20%7B%20%3Fentity%20wdt%3AP435%20%5B%5D%20%7D%20.%0A%20%20%20%20OPTIONAL%20%7B%20%3Fentity%20wdt%3AP407%20%3Flanguage%20%7D%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D Operas that don't have a MusicBrainz ID stored] |
||
<nowiki> |
<nowiki> |
||
SELECT ?entityLabel ?entity { |
SELECT ?entityLabel ?entity ?languageLabel { |
||
?entity wdt:P31 wd:Q1344 . |
?entity wdt:P31 wd:Q1344 . |
||
MINUS { ?entity wdt:P435 [] } . |
MINUS { ?entity wdt:P435 [] } . |
||
OPTIONAL { ?entity wdt:P407 ?language } . |
|||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } |
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } |
||
} |
} |
Latest revision as of 17:00, 14 November 2017
These are example queries for the Wikidata SPARQL endpoint
All composers who don't have a MusicBrainz ID stored
For "musicians" instead of "composers", change Q36834 to Q639669.
SELECT ?entityLabel ?entity { ?entity wdt:P106 wd:Q36834 . MINUS { ?entity wdt:P434 [] } . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } }
Female composers who don't have a MusicBrainz ID stored
SELECT ?entityLabel ?entity { ?entity wdt:P106 wd:Q36834 . ?entity wdt:P21 wd:Q6581072 . MINUS { ?entity wdt:P434 [] } . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } }
Composers born somewhere in Germany who don't have a MusicBrainz ID stored
SELECT ?entityLabel ?entity { ?entity wdt:P106 wd:Q36834 . ?entity wdt:P19 ?place . ?place wdt:P17 wd:Q183 . MINUS { ?entity wdt:P434 [] } . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } }
SELECT (COUNT(?composition) AS ?count) ?composerLabel ?composer WHERE { ?composition wdt:P86 ?composer . ?composer wdt:P106 wd:Q639669 . MINUS { ?composer wdt:P434 [] } . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?composerLabel ?composer ORDER BY DESC(?count)
Operas that don't have a MusicBrainz ID stored
SELECT ?entityLabel ?entity ?languageLabel { ?entity wdt:P31 wd:Q1344 . MINUS { ?entity wdt:P435 [] } . OPTIONAL { ?entity wdt:P407 ?language } . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } }