Main Page: Difference between revisions

no edit summary
No edit summary
No edit summary
Line 14: Line 14:
SELECT ?instance ?instanceLabel ?count { {
SELECT ?instance ?instanceLabel ?count { {
     SELECT ?instance (COUNT(DISTINCT ?item) as ?count) {
     SELECT ?instance (COUNT(DISTINCT ?item) as ?count) {
           {?item wdt:P131 wd:Q25 . }
           ?item wdt:P45 wd:Q1368 .  
  UNION { ?item wdt:P131 ?pob . ?pob wdt:P131* wd:Q25 }
           ?item  wdt:P31 ?instance.
           ?item  wdt:P31 ?instance.}
     GROUP BY ?instance
     GROUP BY ?instance
     HAVING (?count > 100)}
     HAVING (?count > 100)}