query-8e27f826e1dfedc57a432922b8acb689

rq turtle/ttl

Query to pick up all reference URLs with a specific base URL as my first Wikidata project, so still feel a relative newbie. https://www.wikidata.org/wiki/Wikidata:WikiProject_LSEThesisProjectHi, I'm working on I'm needing to pull out a list of all the items and statements where we've used a reference URL etheses.lse.ac.uk. This will be on theses, author and supervisor Qids. http://etheses.lse.ac.uk/2699/ and then tried the following SPARQL query, but am not getting any results. Would anyone be able to guide me as to what I’m doing wrong and how I could retrieve all the instances of our URLs – an example of a full URL would be https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries#Number_of_references_to_Le_FigaroI looked at

Use at

• https://query.wikidata.org/sparql

PREFIX pr: <http://www.wikidata.org/prop/reference/>
SELECT ?ref ?refURL WHERE {
  ?ref pr:P854 ?refURL .
  FILTER (CONTAINS(str(?refURL),'etheses.lse.ac.uk')) .
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/07