query-dc9b57b6869b0ac3080d180f3e7574f3
Name of fictional human 18:13, 1 April 2018 (UTC)) talk (ValterVB but for an italian reader isn't correct. Maybe need something like "original name"? --(Q1469911)Fran = (P735)given name was "translated" in "Francesca Cacace" the item about the character have Fran Fine the name of (Q464865)The Nanny How to manage the name of fictional human? Example in
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?lang ?langLabel ?familyname ?familynameLabel (COUNT(DISTINCT ?person) as ?ct) (SAMPLE(?person) as ?sample)
{
?item wdt:P361 wd:Q1756503 ; p:P734 [ ps:P734 ?familyname ; pq:P407 ?lang ] .
OPTIONAL { ?person wdt:P734 ?familyname ; wdt:P31 wd:Q5 }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
GROUP BY ?familyname ?familynameLabel ?lang ?langLabel
ORDER BY ?langLabel ?familynameLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?ct")
v4("?familyname"):::projected
v2("?familynameLabel"):::projected
v3("?item")
v5("?lang"):::projected
v1("?langLabel"):::projected
v6("?person"):::projected
v8("?sample")
a1((" "))
c2(["wd:Q1756503"]):::iri
c10(["bd:serviceParam"]):::iri
c8(["wd:Q5"]):::iri
c12(["en"]):::literal
v3 --"p:direct/P361"--> c2
a1 --"p:statement/P734"--> v4
a1 --"p:qualifier/P407"--> v5
v3 --"p:P734"--> a1
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v6 -."p:direct/P734".-> v4
v6 --"p:direct/P31"--> c8
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end
bind2[/"count(?person)"/]
v6 --o bind2
bind2 --as--o v7
bind3[/"sample(?person)"/]
v6 --o bind3
bind3 --as--o v8