User:TweetsFactsAndQueries/Queries/‘No Way To Prevent This,’ Says Only Nation Where This Regularly Happens articles
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". }
}