Babel user information
it-N Questo utente può contribuire con un livello madrelingua in italiano.
en-3 This user has advanced knowledge of English.
de-2 Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau.
pl-1 Ten użytkownik posługuje się językiem polskim na poziomie podstawowym.
la-1 Hic usor simplici lingua Latina conferre potest.
eml-1 Cl'utèint ché al pōl dêr 'na mân cun un livèl bâs d' Emiliàn e rumagnòl.
fr-0 Cet utilisateur n’a aucune connaissance en français (ou le comprend avec de grandes difficultés).
ja-0 この利用者は日本語分かりません (または理解するのがかなり困難です)。
ang-0 Þes brūcere ne cann sprecan Englisce (oððe cann undergietan hit efne swīðe earfoðe).
non-0 This user has no knowledge of Old Norse (or understands it with considerable difficulty).
Users by language

I'm mainly active on the Italian Wikipedia (my user page), but you can write to me here as well.

ToolsEdit

QueriesEdit

People with a Media Art Database Mangaka ID:

SELECT ?item ?itemLabel ?kana ?value (URI(CONCAT("https://mediaarts-db.bunka.go.jp/mg/authorities/",?value,"?locale=ja")) AS ?valueUrl)
WHERE {
	?item wdt:P3231 ?value .
    OPTIONAL { ?item wdt:P1814 ?kana . }
	SERVICE wikibase:label { bd:serviceParam wikibase:language "ja" } 
}
ORDER BY ASC (?value)

Try it!

Women directors in Anime News Network (quite few, or don't they have the value "director" on Wikidata?):

SELECT ?item ?itemLabel (group_concat(distinct ?occupationLabel;separator=", ") as ?occupations) ?dateofbirth ?dateofdeath  (URI(CONCAT("https://www.animenewsnetwork.com/encyclopedia/people.php?id=",?ANNid)) AS ?ANN)
WHERE {
  ?item wdt:P31 wd:Q5 .
  ?item wdt:P21 wd:Q6581072 .
  ?item wdt:P1982 ?ANNid .
  { ?item wdt:P106 wd:Q3455803 } UNION { ?item wdt:P106 wd:Q2059704 } UNION { ?item wdt:P106 wd:Q11284414 } UNION { ?item wdt:P106 wd:Q2526255 }
  ?item wdt:P106 ?occupation
#exclude Americans and Canadians
  MINUS { ?item wdt:P27 wd:Q30 }
  MINUS { ?item wdt:P27 wd:Q16 }
  OPTIONAL { ?item wdt:P569 ?dateofbirth . }
  OPTIONAL { ?item wdt:P570 ?dateofdeath . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,ja" .
                         ?occupation rdfs:label ?occupationLabel .
                         ?item rdfs:label ?itemLabel .}
} group by ?item ?itemLabel ?dateofbirth ?dateofdeath ?ANNid

Try it!

(Thanks to user:Tagishsimon)

Women screenwriters in Anime News Network:

SELECT ?item ?itemLabel ?dateofbirth ?dateofdeath (URI(CONCAT("https://www.animenewsnetwork.com/encyclopedia/people.php?id=",?ANNid)) AS ?ANN)
WHERE {
  ?item wdt:P31 wd:Q5 .
  ?item wdt:P21 wd:Q6581072 .
  ?item wdt:P1982 ?ANNid .
  ?item wdt:P106 wd:Q28389 .
#exclude Americans and Canadians
  MINUS { ?item wdt:P27 wd:Q30 }
  MINUS { ?item wdt:P27 wd:Q16 }
  OPTIONAL { ?item wdt:P569 ?dateofbirth . }
  OPTIONAL { ?item wdt:P570 ?dateofdeath . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,ja" }
}

Try it!

All female mangaka:

SELECT ?item ?itemLabel ?dateofbirth ?dateofdeath (URI(CONCAT("https://mediaarts-db.bunka.go.jp/mg/authorities/",?MAD,"?locale=en")) AS ?Media_Art_Database)
WHERE {
  ?item wdt:P31 wd:Q5 .
  ?item wdt:P21 wd:Q6581072 .
  ?item wdt:P106 wd:Q191633 .
  OPTIONAL { ?item wdt:P3231 ?MAD . }
  OPTIONAL { ?item wdt:P569 ?dateofbirth . }
  OPTIONAL { ?item wdt:P570 ?dateofdeath . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,ja" }
}

Try it!