query-df9005f37a7c703a8e63e7f92b201eac

rq turtle/ttl

are either same year"). (P582)end time and (P582)end time : This is a query for your first request. The later question is too vague to make a query. There are over 100,000 results so I added a LIMIT. I also dropped the condition "or (same month+same year)" because it will not give any results which are not already found by the first part ("Bouzinac@ 23:16, 27 November 2020 (UTC) 💛●✒️●💬 Bouzinac are perfect]. How to find/filter to get them ? (P582)end time and (P580)start time ] , not a temporal process [which means (P585)point in time Yes, in the paper, it answers the need but when looking at the results, I wonder how to get only items whose P31 suggest it should be a certain point in time [should be better a 22:54, 27 November 2020 (UTC) Jurashould give you part of it. ---

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?instance ?instanceLabel ?count
WHERE
{

{
  SELECT ?instance (COUNT(*) as ?count) 
  WHERE
  {
    ?item wdt:P580 ?from; wdt:P582 ?to . 
    FILTER NOT EXISTS { ?item wdt:P585 [] } . 
    FILTER( YEAR(?from) = YEAR(?to) )
    ?item wdt:P31 ?instance 
  }
  GROUP BY ?instance
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}  
ORDER BY DESC(?count) 
LIMIT 300

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?count"):::projected v2("?from") v5("?instance"):::projected v4("?item") v3("?to") a1((" ")) c6(["bd:serviceParam"]):::iri c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["year-from-dateTime(?from) = year-from-dateTime(?to)"]] f0 --> v2 f0 --> v3 f1[["not "]] subgraph f1e0["Exists Clause"] e0v1 --"wdt:P585"--> e0a1 e0v1("?item"):::projected e0a1((" ")):::projected end f1--EXISTS--> f1e0 f1 --> v4 f1 --> c1 f1 --> a1 v4 --"wdt:P585"--> a1 v4 --"wdt:P580"--> v2 v4 --"wdt:P582"--> v3 v4 --"wdt:P31"--> v5 bind3[/"count(*)"/] bind3 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end