query-fe5f1fc74bac09a9a2512bd9677f8997

rq turtle/ttl

reference url (P854)

IdRef ID (P269)

SELECT DISTINCT ?item ?prop ?statement ?url WHERE { ?item ?prop ?statement. ?statement prov:wasDerivedFrom ?ref. ?ref pr:P854 ?url. FILTER(CONTAINS(LCASE(STR(?url)), "idref.fr")) FILTER(NOT EXISTS { ?ref pr:P269 ?s. }) FILTER(?prop != p:P269) } LIMIT 100

Use at

PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
# reference url (P854)
# IdRef ID (P269)

SELECT DISTINCT ?item ?prop ?statement ?url WHERE {
  ?item ?prop ?statement.
  ?statement prov:wasDerivedFrom ?ref.
  ?ref pr:P854 ?url.
  FILTER(CONTAINS(LCASE(STR(?url)), "idref.fr"))
  FILTER(NOT EXISTS { ?ref pr:P269 ?s. })
  FILTER(?prop != p:P269)
}
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?item"):::projected v1("?prop"):::projected v2("?ref") v3("?s") v6("?statement"):::projected v4("?url"):::projected f0[["?prop != 'p:P269'"]] f0 --> v1 f1[["not "]] subgraph f1e0["Exists Clause"] e0v1 --"p:reference/P269"--> e0v2 e0v1("?ref"):::projected e0v2("?s"):::projected end f1--EXISTS--> f1e0 f1 --> v2 f1 --> c2 f1 --> v3 v2 --"p:reference/P269"--> v3 f2[["contains(lower-case(str(?url)),'idref.fr')"]] f2 --> v4 v5 -->v1--> v6 v6 --"prov:wasDerivedFrom"--> v2 v2 --"p:reference/P854"--> v4