query-1f684f3f8f3f6ae1ed435d8b24cb47aa

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
  ?item ?itemLabel ?itemDescription 
  (SAMPLE(?d) as ?d) (SAMPLE(?tp) as ?tp) 
  (GROUP_CONCAT(DISTINCT ?an; separator=", ") as ?ann) (GROUP_CONCAT(DISTINCT ?al; separator=", ") as ?all) 
WHERE
{
    ?item wdt:P921 wd:Q33057 ; wdt:P31 wd:Q13442814 
    OPTIONAL { ?item p:P577 / psv:P577 [ wikibase:timeValue ?d ; wikibase:timePrecision ?tp ] }
    OPTIONAL { ?item wdt:P2093 ?an } 
    OPTIONAL { ?item wdt:P50 / rdfs:label ?al . FILTER( lang(?al)="en" ) }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?item ?itemLabel ?itemDescription
ORDER BY DESC(?d)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?al"):::projected v7("?all") v5("?an"):::projected v6("?ann") v6("?d"):::projected v3("?item"):::projected v6("?tp"):::projected a2((" ")) a1((" ")) a3((" ")) c5(["wd:Q13442814"]):::iri c14(["bd:serviceParam"]):::iri c3(["wd:Q33057"]):::iri c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal v3 --"p:direct/P921"--> c3 v3 --"p:direct/P31"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; a1 -."wikibase:timeValue".-> v6 a1 --"wikibase:timePrecision"--> v6 v3 --"p:P577"--> a2 a2 --"p:statement/value/P577"--> a1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P2093".-> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P50".-> a3 a3 --"rdfs:label"--> v2 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end bind4[/"sample(?d)"/] v6 --o bind4 bind4 --as--o v6 bind5[/"sample(?tp)"/] v6 --o bind5 bind5 --as--o v6 bind6[/"?an"/] v5 --o bind6 bind6 --as--o v6 bind7[/"?al"/] v2 --o bind7 bind7 --as--o v7