query-246a42668a2448765067b560ab867ddb

rq turtle/ttl

Maintenance query (P4846)Lemon Amiga ID but no (P4671)Hall of Light ID Games with

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?itemLabel ?item ?url
{
    wd:P4671 wdt:P1630 ?formatterurl .
    ?item wdt:P4671 ?value .
    OPTIONAL { ?item wdt:P4846 ?lemon . }
    FILTER(!BOUND(?lemon))
    BIND(IRI(CONCAT(STR(IRI(REPLACE(?value, '^(.+)$', ?formatterurl))), "/weblink")) AS ?url).
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en,en"  }    
}
LIMIT 1000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?formatterurl") v3("?item"):::projected v1("?lemon") v5("?url"):::projected v4("?value") c1(["wd:P4671"]):::iri c6(["bd:serviceParam"]):::iri c8(["en,en"]):::literal f0[["not bound(?lemon)"]] f0 --> v1 c1 --"wdt:P1630"--> v2 v3 --"wdt:P4671"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P4846".-> v1 end bind1[/"concat(str(replace(?value,'^(.+)$',?formatterurl)),'/weblink')"/] v4 --o bind1 v2 --o bind1 bind1 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end