query-04678ae47f66168240665e1a867532ec

rq turtle/ttl

16:19, 20 January 2016 (UTC)) talk (Srittau.) --(P31)instance of , though. (Although I don't think we use sub-classes of it for (Q5)human gives me 3 051 918 results. This does not include sub-classes of statement on the innermost query, to put a limit the number of statements looked at, otherwise the query will try to look at them all and won't complete. Here's a version of your query set to look at 4 million statements, which is about as many as can be asked for without hitting the query time out. It turns out that that corresponds to statements on 55,623 items -- i.e. more or less the number that Magnus's tool is limited to, although his WDQ is a bit faster than SPARQL.LIMIT: You need to put the Edgars2007@

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?prop ?propLabel ?count WHERE {
    {
        SELECT ?prop (COUNT(DISTINCT ?item) AS ?count) WHERE {


           {
               SELECT ?item ?p WHERE {
                   ?item wdt:P31 wd:Q5 .
                   ?item ?p ?id .
               } LIMIT 4000000
           }
           ?prop wikibase:directClaim ?p .

        }  GROUP BY ?prop
    }

    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
    }

} ORDER BY DESC (?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?count"):::projected v4("?id") v2("?item") v3("?p") v5("?prop"):::projected c5(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c7(["en"]):::literal v2 --"wdt:P31"--> c2 v2 -->v3--> v4 v5 --"wikibase:directClaim"--> v3 bind1[/"count(?item)"/] v2 --o bind1 bind1 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end