query-dc0f80a7223cb52b6f87178f67383008

rq turtle/ttl

Created by User:naveenpf

2021 MLAs below 40 years

SELECT ?age ?item ?itemLabel ?partyLabel ?party_groupLabel ?dob ?districtLabel ?start ?end WHERE { ?item p:P39 ?statement. ?statement ps:P39 :b1; pq:P2715 wd:Q85737920. :b1 (wdt:P279*) wd:Q19468152. ?item wdt:P569 ?dob. BIND(2021 - (YEAR(?dob)) AS ?age) OPTIONAL { ?statement pq:P580 ?start. } OPTIONAL { ?statement pq:P582 ?end. } OPTIONAL { ?statement pq:P768 ?district. } OPTIONAL { ?statement pq:P4100 ?party_group. } OPTIONAL { ?statement pq:P102 ?party. } OPTIONAL { ?statement pq:P1365 ?precededby. } OPTIONAL { ?statement pq:P1366 ?succeededby. } OPTIONAL { ?statement pq:P2715 ?electedin. } FILTER(?age <= 40 ) SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY (?age)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Created by User:naveenpf
# 2021 MLAs below 40 years

SELECT ?age ?item ?itemLabel ?partyLabel ?party_groupLabel ?dob ?districtLabel ?start ?end WHERE {
  ?item p:P39 ?statement.
  ?statement ps:P39 _:b1;
    pq:P2715 wd:Q85737920.
  _:b1 (wdt:P279*) wd:Q19468152.
  ?item wdt:P569 ?dob.
  BIND(2021  - (YEAR(?dob)) AS ?age)
  OPTIONAL { ?statement pq:P580 ?start. }
  OPTIONAL { ?statement pq:P582 ?end. }
  OPTIONAL { ?statement pq:P768 ?district. }
  OPTIONAL { ?statement pq:P4100 ?party_group. }
  OPTIONAL { ?statement pq:P102 ?party. }
  OPTIONAL { ?statement pq:P1365 ?precededby. }
  OPTIONAL { ?statement pq:P1366 ?succeededby. }
  OPTIONAL { ?statement pq:P2715 ?electedin. }
  FILTER(?age <= 40 )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY (?age)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?age"):::projected v7("?district") v4("?dob"):::projected v12("?electedin") v6("?end"):::projected v2("?item"):::projected v9("?party") v8("?party_group") v10("?precededby") v5("?start"):::projected v3("?statement") v11("?succeededby") a1((" ")) c7(["wd:Q19468152"]):::iri c5(["wd:Q85737920"]):::iri c19(["en"]):::literal c17(["bd:serviceParam"]):::iri f0[["?age <= '40^^xsd:integer'"]] f0 --> v5 v2 --"p:P39"--> v3 v3 --"p:statement/P39"--> a1 v3 --"p:qualifier/P2715"--> c5 a1 --"p:direct/P279"--> c7 v2 --"p:direct/P569"--> v4 bind1[/"'2021^^xsd:integer' - year-from-dateTime(?dob)"/] v4 --o bind1 bind1 --as--o v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P580".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P582".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P768".-> v7 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P4100".-> v8 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P102".-> v9 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P1365".-> v10 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P1366".-> v11 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P2715".-> v12 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c17 --"wikibase:language"--> c19 end