Miraclepine
Joined 21 August 2018
Babel user information | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Users by language |
Hi, I am ミラP@Miraclepine, a dedicated member of the Wikimedia movement. I'm a "he" (not a she or they) but not necessarily male.
BookmarksEdit
- My sandbox
- Wikidata:WikiProject Authority control/The Peerage errors
- Wikidata:Database_reports/Constraint_violations/P1855#"Multi_value"_violations
- Wikidata:Database reports/Constraint violations/P2949
- Wikidata:Database reports/Constraint violations/P4638
- Relator
- These should produce a wealth of people items:
QueriesEdit
SELECT ?item ?itemLabel ?surnameLabel ?dob ?oxford_collegeLabel
WHERE
{
{ ?item wdt:P69 wd:Q34433 . }
UNION { ?item wdt:P69 ?oxford_college .
?oxford_college wdt:P31 wd:Q2581649 . }
?item wdt:P31 wd:Q5 .
?item wdt:P734 ?surname .
?item wdt:P569 ?dob . hint:Prior hint:rangeSafe true .
FILTER("1685-00-00T00:00:00Z"^^xsd:dateTime <= ?dob && ?dob < "1868-00-00T00:00:00Z"^^xsd:dateTime)
FILTER NOT EXISTS { ?item wdt:P1343 wd:Q19036877 }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?surnameLabel
# may be useful for creating Wikisource author pages
SELECT ?item ?itemLabel ?value ?sl
{
{
SELECT *
{
?item wdt:P31 wd:Q5 .
?item wdt:P27 wd:Q174193 .
?item wdt:P1343 wd:Q15987216 .
?item wdt:P648 ?value ; wikibase:sitelinks ?sl
FILTER NOT EXISTS { [] schema:about ?item ; schema:isPartOf <https://en.wikisource.org/> }
}
ORDER BY DESC(?sl) ?item
LIMIT 1000
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?sl) ?item
# Fellows of the American Society of Genealogists
SELECT ?item ?itemLabel ?date ?nom
WHERE
{
?item wdt:P31 wd:Q5.
?item p:P166 ?fellow.
?fellow ps:P166 wd:Q19604396.
?fellow a wikibase:BestRank.
OPTIONAL { ?fellow pq:P585 ?date. }
OPTIONAL { ?fellow pq:P1545 ?nom. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}