query-338a475f6fd1a539cff93a91658edfa6
Suspicous items (WIP)
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 bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?given
WHERE {
{
SELECT ?item ?given
WHERE {
?item wdt:P21 wd:Q6581072 . # is female
?item wdt:P735 ?given .
?given wdt:P31 wd:Q12308941 . # has male given name'
FILTER NOT EXISTS { ?given wdt:P31 wd:Q11879590 . }
FILTER (?given NOT IN (
wd:Q6410090, # Kimi - needs a new item for female given name
wd:Q533503, # Edy - usually a hypocorism, may need female given name
wd:Q416744, # Willy
wd:Q263116, # Micha - needs a new item for female given name
wd:Q256463 # Pascal - needs a new item for female given name
))
# filter out The Peerage entries, too many wrong entries
FILTER NOT EXISTS { ?item wdt:P4638 ?thepeerageid . }
}
LIMIT 200
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?given"):::projected
v1("?item"):::projected
v2("?thepeerageid")
c8(["wd:Q11879590"]):::iri
c10(["wd:Q6581072"]):::iri
c12(["wd:Q12308941"]):::iri
c14(["bd:serviceParam"]):::iri
c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P4638"--> e0v2
e0v1("?item"):::projected
e0v2("?thepeerageid"):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> v2
v1 --"wdt:P4638"--> v2
f1[["?given != 'wd:Q6410090'?given != 'wd:Q533503'?given != 'wd:Q416744'?given != 'wd:Q263116'?given != 'wd:Q256463'"]]
f1 --> v3
f2[["not "]]
subgraph f2e1["Exists Clause"]
e1v1 --"wdt:P31"--> e1c2
e1v1("?given"):::projected
e1c2(["wd:Q11879590"]):::iri
end
f2--EXISTS--> f2e1
f2 --> v3
f2 --> c7
f2 --> c8
v3 --"wdt:P31"--> c8
v1 --"wdt:P21"--> c10
v1 --"wdt:P735"--> v3
v3 --"wdt:P31"--> c12
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c14 --"wikibase:language"--> c16
end