query-8daa65ce916fa9bf262a73d897e699e7

rq turtle/ttl

TrilotatInfrastruktur(P1545)series ordinal (P50)author (P2093)author name string

Use at

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