Lombres

Babel user information

it-N	Questo utente può contribuire con un livello madrelingua in italiano.

en-4	This user has near native speaker knowledge of English.

pl-2	Ten użytkownik posługuje się językiem polskim na poziomie średnio zaawansowanym.

de-2	Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau.

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.

ja-0	この利用者は日本語が分かりません (または理解するのがかなり困難です)。

Tools edit

Query service
Harvest Templates
Petscan "categories NOT sparql" or "categories AND sparql"

Queries edit

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!