WDscholia / scholia

Wikidata-based scholarly profiles
https://scholia.toolforge.org
Other
222 stars 79 forks source link

Show information for work #238

Closed fnielsen closed 3 years ago

fnielsen commented 6 years ago

Show information for work: author, venue, date of publication, etc.

The following query may be of help the get data from an work item:

SELECT
  DISTINCT ?p ?property_value ?property_valueLabel ?pq ?qv
WHERE {
  wd:Q46993707 ?p ?statement .
  FILTER (STRSTARTS(STR(?p), "http://www.wikidata.org/prop/P"))
  ?statement ?pv ?property_value .
  ?statement rdf:type wikibase:BestRank . 
  FILTER (STRSTARTS(STR(?pv), "http://www.wikidata.org/prop/statement/P"))
  OPTIONAL {
    ?statement ?pq ?qv .  
    FILTER (STRSTARTS(STR(?pq), "http://www.wikidata.org/prop/qualifier/"))
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?p ?qv
fnielsen commented 3 years ago

This has been implemented with a dedicated table using a series of UNIONs. Example: https://scholia.toolforge.org/work/Q107060118