Utente:Galessandroni/Wikidata

Presidenti della Repubblica Italiana

SELECT DISTINCT ?pres ?presLabel ?picture ?start ?end ?days WHERE
{
  ?pres wdt:P31 wd:Q5 ;
        p:P39 ?position_statement .
  ?position_statement ps:P39 ?position ;
                      pq:P580 ?start .
  ?position wdt:P279* wd:Q332711 .
  OPTIONAL { ?position_statement pq:P582 ?x }
  OPTIONAL { ?pres wdt:P18 ?picture }
  bind(if(bound(?x), ?x, NOW()) as ?end )
  bind(floor(?end - ?start) as ?days)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "it" . }
}
ORDER BY ?start

Provala!

Presidenti del Consiglio della Repubblica Italiana

SELECT ?pres ?presLabel ?start WHERE {
   ?pres wdt:P31 wd:Q5 .

   ?pres p:P39 ?position_held_statement .
   ?position_held_statement ps:P39 wd:Q796897 .
   ?position_held_statement pq:P580 ?start .
   

   SERVICE wikibase:label {
    bd:serviceParam wikibase:language "it" .
   }

 } ORDER BY ?start

Provala!