query-338a475f6fd1a539cff93a91658edfa6

rq turtle/ttl

Suspicous items (WIP)

Use at

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