query-4a5ccce6c76234ba5ade1d0c26293d5a

added November 1, 2020 (76 ids then)

TEMPLATE={ "template":"Identifiers present on the item for Penelope Cruz, but not on the item for Sean Connery"}

SELECT ?p ?pLabel (SAMPLE(?url) as ?url_comp2) WHERE { hint:Query hint:optimizer "None". BIND( wd:Q4573 as ?comp1) BIND( wd:Q39666 as ?comp2) { ?comp2 ?wdt ?v . ?p wikibase:directClaim ?wdt ; wikibase:propertyType wikibase:ExternalId . FILTER NOT EXISTS { ?comp1 ?wdt [] } OPTIONAL { ?p wdt:P1630 ?f } BIND(uri(REPLACE(?f,"\$1",?v)) as ?url) } UNION { BIND(wd:Q4573 as ?p) } UNION { BIND(wd:Q39666 as ?p) } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } GROUP BY ?p ?pLabel ORDER BY ?url_comp2 added November 1, 2020 (76 ids then)

TEMPLATE={ "template":"Identifiers present on the item for Penelope Cruz, but not on the item for Sean Connery"}

Use at

https://query.wikidata.org/sparql

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#>
#added November 1, 2020 (76 ids then)
#TEMPLATE={ "template":"Identifiers present on the item for Penelope Cruz, but not on the item for Sean Connery"}
SELECT
  ?p ?pLabel
  (SAMPLE(?url) as ?url_comp2)
WHERE
{

    BIND( wd:Q4573 as ?comp1)
    BIND( wd:Q39666 as ?comp2)
    {
        ?comp2 ?wdt ?v .
        ?p wikibase:directClaim ?wdt ; wikibase:propertyType wikibase:ExternalId .
        FILTER NOT EXISTS { ?comp1 ?wdt [] }
        OPTIONAL { ?p wdt:P1630 ?f }
        BIND(uri(REPLACE(?f,"\\$1",?v)) as ?url)
    }
    UNION { BIND(wd:Q4573 as ?p) }
    UNION { BIND(wd:Q39666 as ?p) }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
GROUP BY ?p ?pLabel
ORDER BY ?url_comp2

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?comp1") v3("?comp2") v7("?f") v9("?p"):::projected v8("?url"):::projected v9("?url_comp2") v5("?v") v4("?wdt") a1((" ")) c6(["bd:serviceParam"]):::iri c3(["wikibase:ExternalId"]):::iri c8(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal bind0[/"'wd:Q4573'"/] bind0 --as--o v2 bind1[/"'wd:Q39666'"/] bind1 --as--o v3 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; bind2[/"'wd:Q39666'"/] bind2 --as--o v9 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; bind3[/"'wd:Q4573'"/] bind3 --as--o v9 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; f4[["not "]] subgraph f4e0["Exists Clause"] e0v1 -->e0v2--> e0a1 e0v1("?comp1"):::projected e0v2("?wdt"):::projected e0a1((" ")):::projected end f4--EXISTS--> f4e0 f4 --> v2 f4 --> v4 f4 --> a1 v2 -->v4--> a1 v3 -->v4--> v5 v9 --"wikibase:directClaim"--> v4 v9 --"wikibase:propertyType"--> c3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v9 -."wdt:P1630".-> v7 end bind5[/"replace(?f,'\$1',?v)"/] v7 --o bind5 v5 --o bind5 bind5 --as--o v8 end union0r <== or ==> union0l end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end bind7[/"sample(?url)"/] v8 --o bind7 bind7 --as--o v9