query-a722a68a95b392f806fd7ec3ff2ddcd7

Fathers with non-existent or unusual gender statements

SELECT (?father as ?father_id) ?father_name ?father_is_a ?father_gender (?child as ?child_id) ?child_name ?child_is_a WHERE { ?child wdt:P22 ?father . ?father wdt:P31 ?f_is_a . #?father wdt:P31 wd:Q5 . ?child wdt:P31 ?c_is_a . #?child wdt:P31 wd:Q5 . OPTIONAL { ?father wdt:P21 ?f_gender . }

# Aliases for the headings in the results table. Must be done this way because # SELECT (?var as ?varAlias) works, but (?varLabel as ?varLabelAlias) doesn't. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . ?father rdfs:label ?father_name . ?f_is_a rdfs:label ?father_is_a . ?f_gender rdfs:label ?father_gender . ?child rdfs:label ?child_name . ?c_is_a rdfs:label ?child_is_a . }

# Show only results where the father's gender: FILTER( # ...is not set NOT EXISTS { ?father wdt:P21 [] } # ...or is set to something other than "male" or "male organism", or "unknown value" || ?f_gender NOT IN(wd:Q6581097, wd:Q44148) && !wikibase:isSomeValue(?f_gender) ) } ORDER BY DESC(?f_gender) Fathers with non-existent or unusual gender statements

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Fathers with non-existent or unusual gender statements

SELECT
  (?father as ?father_id) ?father_name ?father_is_a ?father_gender
  (?child  as ?child_id)  ?child_name  ?child_is_a
WHERE {
  ?child  wdt:P22 ?father .
  ?father wdt:P31 ?f_is_a . #?father wdt:P31 wd:Q5 . 
  ?child  wdt:P31 ?c_is_a . #?child wdt:P31 wd:Q5 .
  OPTIONAL { ?father wdt:P21 ?f_gender . }

  # Aliases for the headings in the results table. Must be done this way because
  # SELECT (?var as ?varAlias) works, but (?varLabel as ?varLabelAlias) doesn't.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
    ?father   rdfs:label ?father_name .
    ?f_is_a   rdfs:label ?father_is_a .
    ?f_gender rdfs:label ?father_gender .
    ?child    rdfs:label ?child_name .
    ?c_is_a   rdfs:label ?child_is_a .
  }

  # Show only results where the father's gender:
  FILTER( 
    # ...is not set
    NOT EXISTS { ?father wdt:P21 [] }
    # ...or is set to something other than "male" or "male organism", or "unknown value"
    || ?f_gender NOT IN(wd:Q6581097, wd:Q44148) && !wikibase:isSomeValue(?f_gender)
  )
}
ORDER BY DESC(?f_gender)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?c_is_a") v3("?child"):::projected v12("?child_id") v10("?child_is_a"):::projected v9("?child_name"):::projected v1("?f_gender") v4("?f_is_a") v2("?father"):::projected v8("?father_gender"):::projected v11("?father_id") v7("?father_is_a"):::projected v6("?father_name"):::projected a1((" ")) c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["(not || ?f_gender != 'wd:Q6581097'?f_gender != 'wd:Q44148'not http://wikiba.se/ontology#isSomeValue(?f_gender))"]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P21"--> e0a1 e0v1("?father"):::projected e0a1((" ")):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> a1 f0 --> v1 v2 --"wdt:P21"--> a1 v3 --"wdt:P22"--> v2 v2 --"wdt:P31"--> v4 v3 --"wdt:P31"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P21".-> v1 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 v2 --"rdfs:label"--> v6 v4 --"rdfs:label"--> v7 v1 --"rdfs:label"--> v8 v3 --"rdfs:label"--> v9 v5 --"rdfs:label"--> v10 end bind1[/"?father"/] v2 --o bind1 bind1 --as--o v11 bind2[/"?child"/] v3 --o bind2 bind2 --as--o v12