Connecting Preprints to Peer-reviewed Articles on Wikidata | Biopragmatics

[cthoyt]

Connecting Preprints to Peer-reviewed Articles on Wikidata | Biopragmatics

[egonw]

Try using this SPARQL and copy/paste the output at v2 QuickStatements (the first line should be "qid,P156", the header line:

SELECT ?qid ?P156
WHERE 
{
  VALUES ?author { wd:Q20895241 }
  ?preprint wdt:P31 wd:Q580922 ;
    wdt:P50 ?author ;
    rdfs:label ?preprintLabel .
  ?article wdt:P31 wd:Q13442814 ;
    wdt:P50 ?author ;
    rdfs:label ?label .
  OPTIONAL { ?preprint wdt:P577 ?preprintDate }
  OPTIONAL { ?article wdt:P577 ?articleDate }
  MINUS { ?preprint wdt:P156 ?followedBy }
  FILTER (LCASE(?preprintLabel) = LCASE(?label))
  FILTER (?preprint != ?article)
  FILTER (LANG(?preprintLabel) = "en")
  FILTER (LANG(?label) = "en")
  BIND (CONCAT(SUBSTR(str(?preprint),32),",") AS ?qid)
  BIND (SUBSTR(str(?preprint),32) AS ?P156)
}
ORDER BY DESC(?articleDate)