query-a91da3d6b89a8c947a8fde98b77779bc

rq turtle/ttl

to get items without any statements that have at least a german wikipedia sitelink. I want to accelerate this query to restrict it to certain QIDs. How can I filter the QID or the creation date of this item? but this is not very fast - is it possible to access the QID number diretly? FILTER(xsd:integer(strafter(str(?item),"Q")) < 2000000)I know ? schema:dateCreated like schema:dateModified - is there an alternative to ?item schema:dateModified ?date FILTER (?date < "2015-01-01T00:00:00Z"^^xsd:dateTime)I know 14:57, 29 November 2021 (UTC)) talk (Fidoez--

Use at

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

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
SELECT ?date ?cumulativecount 
{

    {   SELECT ?milestonep (COUNT(?item) as ?cumulativecount)
        WHERE
        {
          { SELECT ?item { ?item wikibase:statements 0 . [] schema:about ?item ; schema:isPartOf <https://de.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

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2021/12