query-7b81278bc1420fd22a466b61ac250560

rq turtle/ttl

Find duplicate HLS entries SELECT ?hls (COUNT(?hls) AS ?nr_items) (GROUP_CONCAT(?item; separator=";") AS ?all_items) WHERE { ?item wdt:P902 ?hls. # DOB SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } GROUP BY ?hls HAVING(COUNT(?hls) > 1)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Find duplicate HLS entries
SELECT ?hls (COUNT(?hls) AS ?nr_items)  (GROUP_CONCAT(?item; separator=";") AS ?all_items) 
WHERE
{
    ?item wdt:P902 ?hls. # DOB
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?hls
HAVING(COUNT(?hls) > 1)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?_anon_42b5416610844a34809f33a099ae9de1105084") v5("?all_items") v2("?hls"):::projected v1("?item"):::projected v4("?nr_items") a1((" ")) c4(["bd:serviceParam"]):::iri c6(["en"]):::literal f0[[" > '1^^xsd:integer'"]] f0 --> a1 v1 --"wdt:P902"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end bind4[/"count(?hls)"/] v2 --o bind4 bind4 --as--o v3 bind5[/"count(?hls)"/] v2 --o bind5 bind5 --as--o v4 bind6[/"?item"/] v1 --o bind6 bind6 --as--o v5