query-e7a6497cc694fc34e1e0381fc878f5ab

rq turtle/ttl

List ten people with an occupation of Journalist without a death date or an ID for the site Muckrack

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:Q1930187.
      MINUS {
        ?item p:P570 ?statement_1.
        ?statement_1 psv:P570 ?statementValue_1.
        ?statementValue_1 wikibase:timeValue ?P570_1.
      }
      MINUS {
        ?item p:P6005 ?statement2.
        ?statement2 (ps:P6005) _:anyValueP6005.
      }
    }
    LIMIT 10
  }
}

Query found at

• https://www.wikidata.org/wiki/Talk:Q1930187