query-81d309e841991b7175a9359e3bc1bd9b

rq turtle/ttl

Abfrage von Finn Årup Nielsen, die nach Personen mit Nachnamen sucht, die der Vergangenheitsform eines dänischen Verbs entsprechen. SELECT (COUNT(?person) AS ?count) ?lexeme ?lemma ?surname (SAMPLE(?person) AS ?example_person) (GROUP_CONCAT(?person_labels; separator=", ") AS ?names) WHERE { hint:Query hint:optimizer "None".

?lexeme dct:language wd:Q9035 . ?lexeme ontolex:lexicalForm ?form . ?form wikibase:grammaticalFeature wd:Q52434448 . ?lexeme wikibase:lemma ?lemma . ?form ontolex:representation ?word . BIND(STRLANG(CONCAT(UCASE(SUBSTR(STR(?word), 1, 1)), SUBSTR(STR(?word), 2)), "en") AS ?surname) ?surname_item rdfs:label ?surname . ?person wdt:P734 ?surname_item . ?person rdfs:label ?person_labels . FILTER(LANG(?person_labels) = "en") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?lexeme ?lemma ?surname ORDER BY DESC(?count) LIMIT 100

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Abfrage von Finn Årup Nielsen, die nach Personen mit Nachnamen sucht, die der Vergangenheitsform eines dänischen Verbs entsprechen.
SELECT 
  (COUNT(?person) AS ?count)
  ?lexeme ?lemma ?surname
  (SAMPLE(?person) AS ?example_person)
  (GROUP_CONCAT(?person_labels; separator=", ") AS ?names)
WHERE {


  ?lexeme dct:language wd:Q9035 .
  ?lexeme ontolex:lexicalForm ?form .
  ?form wikibase:grammaticalFeature wd:Q52434448 .
  ?lexeme wikibase:lemma ?lemma .
  ?form ontolex:representation ?word .
  BIND(STRLANG(CONCAT(UCASE(SUBSTR(STR(?word), 1, 1)), SUBSTR(STR(?word), 2)), "en") AS ?surname)
  ?surname_item rdfs:label ?surname .
  ?person wdt:P734 ?surname_item  .
  ?person rdfs:label ?person_labels . FILTER(LANG(?person_labels) = "en")
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?lexeme ?lemma ?surname
ORDER BY DESC(?count) 
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?count") v10("?example_person") v4("?form") v5("?lemma"):::projected v3("?lexeme"):::projected v11("?names") v9("?person"):::projected v2("?person_labels"):::projected v7("?surname"):::projected v8("?surname_item") v6("?word") c3(["wd:Q9035"]):::iri c12(["bd:serviceParam"]):::iri c14(["#91;AUTO_LANGUAGE#93;,en"]):::literal c6(["wd:Q52434448"]):::iri f0[["?person_labels = 'en'"]] f0 --> v2 v3 --"dct:language"--> c3 v3 --"ontolex:lexicalForm"--> v4 v4 --"wikibase:grammaticalFeature"--> c6 v3 --"wikibase:lemma"--> v5 v4 --"ontolex:representation"--> v6 bind1[/"STRLANG(concat(upper-case(substring(str(?word),'1^^xsd:integer','1^^xsd:integer')),substring(str(?word),'2^^xsd:integer')),'en')"/] v6 --o bind1 bind1 --as--o v7 v8 --"rdfs:label"--> v7 v9 --"wdt:P734"--> v8 v9 --"rdfs:label"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end bind5[/"count(?person)"/] v9 --o bind5 bind5 --as--o v10 bind6[/"sample(?person)"/] v9 --o bind6 bind6 --as--o v10 bind7[/"?person_labels"/] v2 --o bind7 bind7 --as--o v11