query-763febf032e4e686941ee4e8a4f93362

rq turtle/ttl

Show comedians that are alive and British citizens

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  {
    SELECT DISTINCT ?item WHERE {
      ?item p:P106 ?statement0.
      ?statement0 (ps:P106/(wdt:P279*)) wd:Q245068.
      ?item p:P27 ?statement1.
      ?statement1 (ps:P27/(wdt:P279*)) wd:Q145.
      MINUS {
        ?item p:P12627 ?statement2.
        ?statement2 (ps:P12627) _:anyValueP12627.
      }
      MINUS {
        ?item p:P570 ?statement_3.
        ?statement_3 psv:P570 ?statementValue_3.
        ?statementValue_3 wikibase:timeValue ?P570_3.
      }
    }
    LIMIT 100
  }
}

Query found at

• https://www.wikidata.org/wiki/Property_talk:P12627