User:TweetsFactsAndQueries/Queries/‘No Way To Prevent This,’ Says Only Nation Where This Regularly Happens articles

From Wikidata
Jump to navigation Jump to search

Originally posted on Twitter and on Mastodon.

#defaultView:Timeline{ "hide": ["?publicationDate"] }
SELECT ?item (?title AS ?itemLabel) ?url ?publicationDate ?subject ?subjectLabel ?dead ?injured WHERE {
  ?item wdt:P179 wd:Q67365338;
        wdt:P1476 ?title;
        wdt:P953 ?url;
        wdt:P577 ?publicationDate;
        wdt:P921 ?subject.
  OPTIONAL {
    ?subject wdt:P1120 ?dead_.
    BIND(STRLANG(CONCAT(IF(wikibase:isSomeValue(?dead_), "unknown", STR(?dead_)), " dead"), "en") AS ?dead)
  }
  OPTIONAL {
    ?subject wdt:P1339 ?injured_.
    BIND(STRLANG(CONCAT(IF(wikibase:isSomeValue(?injured_), "unknown", STR(?injured_)), " injured"), "en") AS ?injured)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!