query-715f52b45c7ee15f2e814157c4f34d10

rq turtle/ttl

Source 10:39, 16 December 2017 (UTC)) talk (Xaris333. (P854)reference URL as a qualifier, but the source has no (Q253414)FIFA --> (P447)review score by with any value and with (P1352)ranking Hello. I need a query that finds items with Source. (P854)reference URL as a qualifier, but the source has no (Q253414)FIFA --> (P447)review score by with any value and with (P1352)ranking Items with

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?rankingValue ?pointInTime WHERE {
  ?item p:P1352 ?s .
  ?s ps:P1352 ?rankingValue; pq:P447 wd:Q253414 .
  OPTIONAL { ?s pq:P585 ?pointInTime }
  MINUS { ?s prov:wasDerivedFrom [ pr:P854 [] ] }
  SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE],en' }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?item"):::projected v4("?pointInTime"):::projected v3("?rankingValue"):::projected v2("?s") a2((" ")) a1((" ")) c9(["bd:serviceParam"]):::iri c4(["wd:Q253414"]):::iri c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal v1 --"p:P1352"--> v2 v2 --"p:statement/P1352"--> v3 v2 --"p:qualifier/P447"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:qualifier/P585".-> v4 end subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; a1 --"p:reference/P854"--> a2 v2 --"prov:wasDerivedFrom"--> a1 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end