query-928270b64b0eff80f23c61a2d120a8a5

rq turtle/ttl

title: List of properties which have instances or subclass of humans as possible value with male and female form in French SELECT ?property ?propertyLabel ?maleform ?femaleform (GROUP_CONCAT(?alias; SEPARATOR = ", ") AS ?aliases) WHERE { ?property p:P2302 ?statement. ?statement ps:P2302 wd:Q21510865; pq:P2308 wd:Q5; pq:P2309 ?relation. ?property rdfs:label ?propertyLabel. OPTIONAL { ?property skos:altLabel ?alias. FILTER((LANG(?alias)) = "fr") } FILTER((LANG(?propertyLabel)) = "fr") OPTIONAL { ?property wdt:P2521 ?femaleform. FILTER((LANG(?femaleform)) = "fr") } OPTIONAL { ?property wdt:P3321 ?maleform. FILTER((LANG(?maleform)) = "fr") } } GROUP BY ?property ?propertyLabel ?maleform ?femaleform

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#title: List of properties which have instances or subclass of humans as possible value with male and female form in French
SELECT ?property ?propertyLabel ?maleform ?femaleform (GROUP_CONCAT(?alias; SEPARATOR = ", ") AS ?aliases) WHERE {
  ?property p:P2302 ?statement.
  ?statement ps:P2302 wd:Q21510865;
    pq:P2308 wd:Q5;
    pq:P2309 ?relation.
  ?property rdfs:label ?propertyLabel.
  OPTIONAL {
    ?property skos:altLabel ?alias.
    FILTER((LANG(?alias)) = "fr")
  }
  FILTER((LANG(?propertyLabel)) = "fr")
  OPTIONAL {
    ?property wdt:P2521 ?femaleform.
    FILTER((LANG(?femaleform)) = "fr")
  }
  OPTIONAL {
    ?property wdt:P3321 ?maleform.
    FILTER((LANG(?maleform)) = "fr")
  }
}
GROUP BY ?property ?propertyLabel ?maleform ?femaleform

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?alias"):::projected v8("?aliases") v3("?femaleform"):::projected v1("?maleform"):::projected v5("?property"):::projected v2("?propertyLabel"):::projected v7("?relation") v6("?statement") c6(["wd:Q5"]):::iri c4(["wd:Q21510865"]):::iri f0[["?propertyLabel = 'fr'"]] f0 --> v2 v5 --"p:P2302"--> v6 v6 --"p:statement/P2302"--> c4 v6 --"p:qualifier/P2308"--> c6 v6 --"p:qualifier/P2309"--> v7 v5 --"rdfs:label"--> v2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."skos:altLabel".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P2521".-> v3 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P3321".-> v1 end bind2[/"?alias"/] v4 --o bind2 bind2 --as--o v8