Page MenuHomePhabricator

Grouping by sitelink
Closed, DuplicatePublic

Description

Grouping by sitelink could be neat. The groups would have significant overlap but I think it would bring valuable information.

Event Timeline

That seems to work:

SELECT ?grouping (COUNT(DISTINCT ?entity) AS ?count) (SAMPLE(?entity) AS ?sample) WHERE {
  ?entity wdt:P10241 wd:Q41960.
  ?sitelink schema:about ?entity .
  ?sitelink schema:isPartOf ?grouping.
}
GROUP BY ?grouping
HAVING (?count >= 1 )
ORDER BY DESC (?count)
LIMIT 1000