query-2743d0a28e2c2663e86b333e83955d4a

rq turtle/ttl

Duplicate IMO numbers

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?imo (GROUP_CONCAT(?itemLabelEN; separator=',') as ?names) (COUNT(?item) AS ?ccount) (MIN(?item) AS ?min_item) (MAX(?item) AS ?max_item)
WHERE  {
  ?item wdt:P458 ?imo.
  OPTIONAL {
    ?item rdfs:label ?itemLabelEN.
    FILTER(LANG(?itemLabelEN) = 'en')
  }
}
GROUP BY ?imo
HAVING (COUNT(?item) > 1)
ORDER BY ?imo

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?_anon_d00291b7e9a143df8ec0be8c8ebd714c137848") v6("?ccount") v1("?imo"):::projected v3("?item"):::projected v2("?itemLabelEN"):::projected v8("?max_item") v7("?min_item") v5("?names") a1((" ")) f0[[" > '1^^xsd:integer'"]] f0 --> a1 v3 --"wdt:P458"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."rdfs:label".-> v2 end bind6[/"count(?item)"/] v3 --o bind6 bind6 --as--o v4 bind7[/"?itemLabelEN"/] v2 --o bind7 bind7 --as--o v5 bind8[/"count(?item)"/] v3 --o bind8 bind8 --as--o v6 bind9[/"min(?item)"/] v3 --o bind9 bind9 --as--o v7 bind10[/"max(?item)"/] v3 --o bind10 bind10 --as--o v8