query-8daa65ce916fa9bf262a73d897e699e7
TrilotatInfrastruktur(P1545)series ordinal (P50)author (P2093)author name string
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 (GROUP_CONCAT(?authLabel; separator="; ") AS ?author_labels)
(GROUP_CONCAT(?authstr; separator="; ") AS ?author_strings)
?ord (COUNT(?ord) AS ?count)
WHERE
{
{
VALUES ?item { wd:Q56742969 }
?item p:P50 ?auth_st .
?auth_st ps:P50 ?auth .
?auth_st pq:P1545 ?ord .
}
UNION
{
VALUES ?item { wd:Q56742969 }
?item p:P2093 ?authstr_st .
?authstr_st ps:P2093 ?authstr .
?authstr_st pq:P1545 ?ord .
}
SERVICE wikibase:label
{
bd:serviceParam wikibase:language "en" .
?auth rdfs:label ?authLabel .
}
}
GROUP BY ?ord
HAVING (?count > 1)
ORDER BY xsd:integer(?ord)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?auth")
v8("?authLabel"):::projected
v4("?auth_st")
v9("?author_labels")
v10("?author_strings")
v7("?authstr"):::projected
v6("?authstr_st")
v11("?count")
v6("?item")
v1("?ord"):::projected
c8(["bd:serviceParam"]):::iri
c10(["en"]):::literal
f0[["?count > '1^^xsd:integer'"]]
f0 --> v11
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
bind1[/VALUES ?item/]
bind1-->v6
bind10(["wd:Q56742969"])
bind10 --> bind1
v6 --"p:P2093"--> v6
v6 --"p:statement/P2093"--> v7
v6 --"p:qualifier/P1545"--> v1
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
bind2[/VALUES ?item/]
bind2-->v6
bind20(["wd:Q56742969"])
bind20 --> bind2
v6 --"p:P50"--> v4
v4 --"p:statement/P50"--> v5
v4 --"p:qualifier/P1545"--> v1
end
union0r <== or ==> union0l
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
v5 --"rdfs:label"--> v8
end
bind6[/"?authLabel"/]
v8 --o bind6
bind6 --as--o v9
bind7[/"?authstr"/]
v7 --o bind7
bind7 --as--o v10
bind8[/"count(?ord)"/]
v1 --o bind8
bind8 --as--o v11