query-e0a5b3ca51c32d4401486aac25ab33df

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-- } ?date P585:pq ?milestonep } ?milestonep GROUP BY } ) ?qid > ?milestone (FILTER ?milestone P1114:ps ?milestonep . ?milestonep P1114:p Q38074555:wd )?qid as ))33 ),?item(str(substr (integer:xsd (BIND } } https://de.wikipedia.org/ isPartOf:schema ; ?item about:schema [] . 0 statements:wikibase ?item { ?item SELECT { { WHERE )?cumulativecount as )?item(COUNT( ?milestonep SELECT { ."None" optimizer:hint Query:hint { ?cumulativecount ?date SELECT #defaultView:AreaChart 15:03, 29 November 2021 (UTC) Jura Gets you a chart comparing QIDs to milestones in item creation. It suggests that items without claims with a sitelink to dewiki are either very old or recent. --- "It suggests that items without claims with a sitelink to dewiki are either very old or recent." YES, you are right. It is because I am working on these item and started at item numbers < 105000000. Now I reached number around 1500000. 16:43, 29 November 2021 (UTC)) talk (Fidoez--How can I restrict the query?Your proposal is a nice presentation but is not a solution for my problem.

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
SELECT * 
{
   ?item wikibase:statements 0 .
   FILTER( REGEX(str(?item), "^http://www.wikidata.org/entity/Q109\\d{6}") ) 
}
LIMIT 100

Query found at

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