query-600edfe006fb9660a24415c88d67cf69
Proliferate external-IDs from qualifiers and references to main statement (2021-07-06) Vladimir Alexiev: Request date: 6 July 2021, byLink to discussions justifying the requestparticipants of WikiProject Authority control Notified Chado07 Ecravo Lovelano מקף) talk (Hiperterminal S.v.Mering MrBenjo 沈澄心 Rhagfyr M.roszkowski AfricanLibrarian Back ache Silviafanti JordanTimothyJames Ahatd Pierre Tribhou NGOgo MasterRus21thCentury Jason.nlw RShigapov Kolja21 AhavaCohen moz Songceci CamelCaseNick Alessandra.Moi 1-Byte Silva Selva Uomovariabile Msuicat Matlin Pablo Busatto Carlobia Bargioni Sotho Tal Ker Epìdosis Iwan.Aucamp Daniel Mietchen Fuzheado Ettorerizza PKM ArthurPSmith Wikidelo Sic19 Jneubert Andy Mabbett Jonathan Groß Vladimir Alexiev none yet: Task description says that 22.7% of uses are as reference, and 0.1% as qualifier. Property_talk:P496Take a prop like ORCID: I bet that some of those uses are not reflected as main statement. I tried to make a query to find refs using external-ID that are not reflected as main statement, but hit timeouts. If you uncomment the first commented-out line below, you get a timeout, even though ?statement has only one incoming link: has no ORCID stated.(Q56085877)Ginny Hendricks states the ORCID iD of author ordinal 1 as 0000-0002-0353-2702, but that author (Q86246932)Crossref: The sustainable source of community-owned scholarly metadata Eg the paper
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?itemLabel ?wdt ?wdLabel ?id { # ?ref ?wdr ?statement {
?wd wikibase:propertyType wikibase:ExternalId; wikibase:directClaim ?wdt; wikibase:reference ?wdr.
?ref ?wdr ?id.
?statement prov:wasDerivedFrom ?ref.
# ?item ?prop ?statement
# filter not exists {?item ?wdt ?id}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} limit 10