query-f0fac7f558233181a08d8bfff771b0a5

rq turtle/ttl

All terrorist organizations

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT
  (SAMPLE(?item) as ?item)
  (SAMPLE(COALESCE(?en_label, ?any_label)) as ?name)
  (SAMPLE(?inception) as ?inception)
  (SAMPLE(?end) as ?end)
  (SAMPLE(?organization) as ?organization)
  (SAMPLE(?allegiance) as ?allegiance)
  (SAMPLE(?image) as ?image)
  (SAMPLE(?class) as ?class)
WHERE {
  ?class wdt:P279* wd:Q17127659.
  ?item p:P31/ps:P31 ?class. # Occupation: terrorist organization and its potential sub-classes.
  OPTIONAL {?item rdfs:label ?en_label. FILTER(LANG(?en_label) = "en")} OPTIONAL {?item rdfs:label ?any_label}
  OPTIONAL {?item wdt:P571 ?inception}
  OPTIONAL {?item wdt:P582 ?end}
  OPTIONAL {?item wdt:P463 ?organization}
  OPTIONAL {?item wdt:P945 ?allegiance}
  OPTIONAL {?item wdt:P18 ?image}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?item ORDER BY DESC(?inception)

Query found at