Untitled query #89644

SQL

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>

SELECT ?human ?image ?gender ?placeOfBirth ?placeOfDeath ?dateOfBirth ?dateOfDeath
       ?givenName ?familyName ?occupation ?nativeName ?citizenship ?father
       ?mother ?sibling ?spouse ?children ?relatives ?nativeLanguage
       ?spokenLanguages ?writingLanguages ?label
WHERE {
  ?human wdt:P31 wd:Q5 .  # Instance of human
  OPTIONAL { ?human wdt:P18 ?image. }  # Image (portrait)
  OPTIONAL { ?human wdt:P21 ?gender. FILTER (?gender IN (
    wd:Q48270, wd:Q48279, wd:Q179294, wd:Q189125, wd:Q207959, wd:Q301702,
    wd:Q350374, wd:Q505371, wd:Q660882, wd:Q746411, wd:Q859614, wd:Q1052281,
    wd:Q1097630, wd:Q1289754, wd:Q1399232, wd:Q2449503, wd:Q3177577,
    wd:Q3277905, wd:Q6581072, wd:Q6581097, wd:Q7130936, wd:Q12964198,
    wd:Q15145778, wd:Q15145779, wd:Q18116794, wd:Q27679684, wd:Q27679766,
    wd:Q52261234, wd:Q93954933, wd:Q93955709, wd:Q96000630, wd:Q25388691,
    wd:Q56315990
  )) }
  OPTIONAL { ?human wdt:P19 ?placeOfBirth. }  # Place of birth
  OPTIONAL { ?human wdt:P20 ?placeOfDeath. }  # Place of death
  OPTIONAL { ?human wdt:P569 ?dateOfBirth. }  # Date of birth
  OPTIONAL { ?human wdt:P570 ?dateOfDeath. }  # Date of death
  OPTIONAL { ?human wdt:P735 ?givenName. }    # Given name
  OPTIONAL { ?human wdt:P734 ?familyName. }   # Family name
  OPTIONAL { ?human wdt:P106 ?occupation. }   # Occupation
  OPTIONAL { ?human wdt:P1559 ?nativeName. }  # Name in native language
  OPTIONAL { ?human wdt:P27 ?citizenship. FILTER EXISTS { ?citizenship wdt:P31 wd:Q6256 }. } # Country of citizenship
  OPTIONAL { ?human wdt:P22 ?father. }        # Father
  OPTIONAL { ?human wdt:P25 ?mother. }        # Mother
  OPTIONAL { ?human wdt:P3373 ?sibling. }     # Sibling
  OPTIONAL { ?human wdt:P26 ?spouse. }        # Spouse
  OPTIONAL { ?human wdt:P40 ?children. }      # Children
  OPTIONAL { ?human wdt:P1038 ?relatives. }   # Relatives
  OPTIONAL { ?human wdt:P103 ?nativeLanguage. FILTER EXISTS { ?nativeLanguage wdt:P31 wd:Q34770 }. } # Native language
  OPTIONAL { ?human wdt:P1412 ?spokenLanguages. FILTER EXISTS { ?spokenLanguages wdt:P31 wd:Q34770 }. } # Spoken languages
  OPTIONAL { ?human wdt:P6886 ?writingLanguages. FILTER EXISTS { ?writingLanguages wdt:P31 wd:Q34770 }. } # Writing language
  OPTIONAL { ?human rdfs:label ?label. FILTER (LANG(?label) = "en") } # Label
}
LIMIT 100
SQL

Checking query status...
