query-ec048cfc5e681086da4bbbac3f6f9e36

rq turtle/ttl

Propertiesoccupation (P106)sex or gender (P21)female form of label (P2521)instance of (P31)

Use at

• https://query.wikidata.org/sparql

PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>

SELECT ?occup ?occupLabel ?count
{
    {
    SELECT ?occup (COUNT(?person) as ?count)
    {
        ?person wdt:P106 ?occup.
        ?person wdt:P21 wd:Q6581072
        OPTIONAL { ?occup wdt:P2521 ?flabel . BIND(lang(?flabel) as ?lang) . FILTER(?lang="or")} . FILTER(!BOUND(?lang))
        ?person wdt:P31 wd:Q5
    }
    GROUP BY ?occup 
    ORDER BY DESC(?count)
    LIMIT 100
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } 
}
ORDER BY DESC(?count)

Query found at

• https://www.wikidata.org/wiki/User:MKar/Query