User:Oravrattas/prompts/Northern Ireland Assembly/sparql
Jump to navigation
Jump to search
SELECT DISTINCT ?wikidata ?wikidata_group ?wikidata_area ?gender ?twitter ?facebook WHERE {
?wikidata p:P39 ?mem. ?mem ps:P39 wd:Q37279107. OPTIONAL { ?mem pq:P4100 ?wikidata_group. } OPTIONAL { ?mem pq:P768 ?wikidata_area. } OPTIONAL { ?wikidata wdt:P21 ?raw_gender } OPTIONAL { ?wikidata wdt:P2002 ?twitter } OPTIONAL { ?wikidata wdt:P2013 ?facebook } FILTER NOT EXISTS { ?mem pq:P582 [] } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?raw_gender rdfs:label ?gender . }
}