query-cf8ad65d7aa39226769ca145723ddeec

rq turtle/ttl

age des entrées/age of items

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#defaultView:AreaChart
#title:age of items
SELECT ?date ?cumulativecount 
{

    {   SELECT ?milestonep (COUNT(?item) as ?cumulativecount)
        WHERE
        {
          { SELECT ?item { ?item wikibase:statements 0 . [] schema:about ?item ; schema:isPartOf <https://fr.wikipedia.org/> } }
          BIND( xsd:integer( substr(str(?item), 33)) as ?qid)
          wd:Q38074555 p:P1114 ?milestonep .
          ?milestonep ps:P1114 ?milestone 
          FILTER( ?milestone > ?qid ) 
        }
        GROUP BY ?milestonep
    }          
    ?milestonep pq:P585 ?date
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?cumulativecount"):::projected v6("?date"):::projected v3("?item") v1("?milestone") v4("?milestonep") v4("?qid") a1((" ")) c2(["0^^xsd:integer"]):::literal c6(["wd:Q38074555"]):::iri c5([https://fr.wikipedia.org/]):::iri f0[["?milestone > ?qid"]] f0 --> v1 f0 --> v4 v3 --"wikibase:statements"--> c2 a1 --"schema:about"--> v3 a1 --"schema:isPartOf"--> c5 bind1[/"http://www.w3.org/2001/XMLSchema#integer(substring(str(?item),'33^^xsd:integer'))"/] v3 --o bind1 bind1 --as--o v4 c6 --"p:P1114"--> v4 v4 --"p:statement/P1114"--> v1 bind3[/"count(?item)"/] v3 --o bind3 bind3 --as--o v5 v4 --"p:qualifier/P585"--> v6