query-e7016a658a186c8cceea095a2644344a

rq turtle/ttl

TODO

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 ?uno ?unoLabel ?item ?itemLabel ?duos ?count
where {
  {
    select ?uno ?item
      (group_concat(distinct substr(str(?duo), 32); separator="; ") as ?duos)
      (count(distinct *) as ?count)
    where {
       {
  select ?uno ?duo ?duo_st where {
    ?uno p:P2738 ?duo_st .
    ?duo_st a wikibase:BestRank .
    ?duo_st ps:P2738 wd:Q23766486 .
    ?duo_st pq:P11260 ?duo .
  }
}      ?item wdt:P279 ?duo . # First order subclasses only
      #?item wdt:P279/wdt:P279? ?duo . # To include second order subclasses, uncomment this line and comment out the preceding line
    }
    group by ?uno ?duo_st ?item
    having (?count > 1)
    #limit 1000
  }
  service wikibase:label { bd:serviceParam wikibase:language "en" . }
}
order by desc(?count)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2023/03