Revision 127836685 of "Utente:Sannita (WMIT)/Sandbox" on itwiki

{{Wikidata list
|sparql=SELECT ?item WHERE {
 # seleziona i monumenti partecipanti a WLM nella provincia
 ?item wdt:P131* wd:Q16286 .
 ?item p:P2186 ?wlmst .
 ?wlmst ps:P2186 ?wlmid .
 # seleziona i monumenti partecipanti al concorso IIC
 MINUS {?wlmst ps:P2186 ?wlmid .
 ?wlmst pq:P790 wd:Q85864317.}
 # esclude gli elementi relativi a comuni dalla lista
 MINUS {?item wdt:P31 wd:Q747074.}
 MINUS {?item wdt:P31 wd:Q954172.}
 # esclude i monumenti che hanno una data d'inizio successiva al termine del concorso
 MINUS {
  ?wlmst pqv:P580 [ wikibase:timeValue ?start ; wikibase:timePrecision ?sprec ] .
  FILTER (
   # precisione 9 è anno
   ( ?sprec > 9 && ?start >= "2022-10-01T00:00:00+00:00"^^xsd:dateTime ) ||
   ( ?sprec < 10 && ?start >= "2023-01-01T00:00:00+00:00"^^xsd:dateTime )
  )
 }
 # esclude i monumenti che hanno una data di termine precedente all'inizio del concorso
 MINUS {
  ?wlmst pqv:P582 [ wikibase:timeValue ?end ; wikibase:timePrecision ?eprec ] .
  FILTER (
   ( ?eprec > 9 && ?end < "2022-09-01T00:00:00+00:00"^^xsd:dateTime ) ||
   ( ?eprec < 10 && ?end < "2022-01-01T00:00:00+00:00"^^xsd:dateTime )
  )
 }
 # esclude i monumenti per cui è indicata una data con un anno diverso da quello del concorso
 MINUS {
  ?wlmst pq:P585 ?date .
  FILTER ( ?date < "2022-01-01T00:00:00+00:00"^^xsd:dateTime || ?date >= "2023-01-01T00:00:00+00:00"^^xsd:dateTime )
 }
}
|sort=p2186
|columns=item
|links=text
|section=p131
|min_section=1
|row_template=subst:WLM2022-riga-listeria
|header_template=WLM2022-intestazione-tabella
}}



== Amelia ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q16580551}}
|-
{{WLM2022-riga|Q27987619}}
|-
{{WLM2022-riga|Q27989629}}
|-
{{WLM2022-riga|Q27989630}}
|-
{{WLM2022-riga|Q28000629}}
|-
{{WLM2022-riga|Q28000630}}
|-
{{WLM2022-riga|Q28000632}}
|-
{{WLM2022-riga|Q28000633}}
|-
{{WLM2022-riga|Q28000634}}
|-
{{WLM2022-riga|Q28016651}}
|-
{{WLM2022-riga|Q29885048}}
|-
{{WLM2022-riga|Q29904646}}
|-
{{WLM2022-riga|Q29904647}}
|-
{{WLM2022-riga|Q29904649}}
|-
{{WLM2022-riga|Q29904999}}
|-
{{WLM2022-riga|Q55085591}}
|-
{{WLM2022-riga|Q55085607}}
|-
{{WLM2022-riga|Q55085610}}
|-
{{WLM2022-riga|Q56258360}}
|-
{{WLM2022-riga|Q56258587}}
|-
{{WLM2022-riga|Q99203174}}
|}


== Arrone ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q56323374}}
|-
{{WLM2022-riga|Q98891957}}
|-
{{WLM2022-riga|Q98891963}}
|-
{{WLM2022-riga|Q98891966}}
|-
{{WLM2022-riga|Q98891970}}
|}


== Ferentillo ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q98853878}}
|-
{{WLM2022-riga|Q98853879}}
|-
{{WLM2022-riga|Q98853882}}
|-
{{WLM2022-riga|Q98853883}}
|-
{{WLM2022-riga|Q98853886}}
|}


== Guardea ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q56258567}}
|}


== Lugnano in Teverina ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q55167454}}
|-
{{WLM2022-riga|Q66945041}}
|-
{{WLM2022-riga|Q66945044}}
|-
{{WLM2022-riga|Q66945048}}
|-
{{WLM2022-riga|Q66945050}}
|-
{{WLM2022-riga|Q66945055}}
|-
{{WLM2022-riga|Q66945059}}
|-
{{WLM2022-riga|Q66945061}}
|-
{{WLM2022-riga|Q66945065}}
|}


== Montegabbione ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q55743125}}
|-
{{WLM2022-riga|Q55743130}}
|-
{{WLM2022-riga|Q55743143}}
|-
{{WLM2022-riga|Q55743149}}
|-
{{WLM2022-riga|Q55743150}}
|-
{{WLM2022-riga|Q55743152}}
|-
{{WLM2022-riga|Q55743153}}
|-
{{WLM2022-riga|Q55743154}}
|}


== Orvieto ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q3328376}}
|}


== Otricoli ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q3073505}}
|-
{{WLM2022-riga|Q55354217}}
|}


== Polino ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q56459164}}
|}


== San Gemini ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q55186486}}
|-
{{WLM2022-riga|Q55354222}}
|-
{{WLM2022-riga|Q96196072}}
|-
{{WLM2022-riga|Q96196086}}
|-
{{WLM2022-riga|Q96196101}}
|-
{{WLM2022-riga|Q96196268}}
|}


== San Venanzo ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q55354223}}
|-
{{WLM2022-riga|Q55673048}}
|}


== Terni ==
{{WLM2022-intestazione-tabella}}
{{WLM2022-riga|Q38580}}
|-
{{WLM2022-riga|Q519033}}
|-
{{WLM2022-riga|Q778186}}
|-
{{WLM2022-riga|Q3215512}}
|-
{{WLM2022-riga|Q3670098}}
|-
{{WLM2022-riga|Q7127006}}
|-
{{WLM2022-riga|Q21196049}}
|-
{{WLM2022-riga|Q21208463}}
|-
{{WLM2022-riga|Q27987493}}
|-
{{WLM2022-riga|Q27989568}}
|-
{{WLM2022-riga|Q27989570}}
|-
{{WLM2022-riga|Q27989571}}
|-
{{WLM2022-riga|Q27989572}}
|-
{{WLM2022-riga|Q27994123}}
|-
{{WLM2022-riga|Q27994828}}
|-
{{WLM2022-riga|Q27998844}}
|-
{{WLM2022-riga|Q29896584}}
|-
{{WLM2022-riga|Q55354230}}
|-
{{WLM2022-riga|Q55673069}}
|-
{{WLM2022-riga|Q55677454}}
|-
{{WLM2022-riga|Q55743155}}
|-
{{WLM2022-riga|Q55743156}}
|-
{{WLM2022-riga|Q55743157}}
|-
{{WLM2022-riga|Q55743159}}
|-
{{WLM2022-riga|Q55743160}}
|-
{{WLM2022-riga|Q55743161}}
|-
{{WLM2022-riga|Q55743162}}
|-
{{WLM2022-riga|Q55743164}}
|-
{{WLM2022-riga|Q55743165}}
|-
{{WLM2022-riga|Q55743166}}
|-
{{WLM2022-riga|Q55743167}}
|-
{{WLM2022-riga|Q55743168}}
|-
{{WLM2022-riga|Q55743169}}
|-
{{WLM2022-riga|Q55743170}}
|-
{{WLM2022-riga|Q55743171}}
|-
{{WLM2022-riga|Q55743172}}
|-
{{WLM2022-riga|Q55743173}}
|-
{{WLM2022-riga|Q55743174}}
|-
{{WLM2022-riga|Q55743175}}
|-
{{WLM2022-riga|Q55743176}}
|-
{{WLM2022-riga|Q55743177}}
|-
{{WLM2022-riga|Q55743178}}
|-
{{WLM2022-riga|Q55743179}}
|-
{{WLM2022-riga|Q55743180}}
|-
{{WLM2022-riga|Q55743181}}
|-
{{WLM2022-riga|Q55743182}}
|-
{{WLM2022-riga|Q55743183}}
|-
{{WLM2022-riga|Q55743184}}
|-
{{WLM2022-riga|Q55743185}}
|-
{{WLM2022-riga|Q55743186}}
|-
{{WLM2022-riga|Q55743187}}
|-
{{WLM2022-riga|Q55743189}}
|-
{{WLM2022-riga|Q55743190}}
|-
{{WLM2022-riga|Q55743191}}
|-
{{WLM2022-riga|Q55743192}}
|-
{{WLM2022-riga|Q55743193}}
|-
{{WLM2022-riga|Q55743194}}
|-
{{WLM2022-riga|Q56258114}}
|-
{{WLM2022-riga|Q56258342}}
|-
{{WLM2022-riga|Q56258812}}
|-
{{WLM2022-riga|Q56258814}}
|-
{{WLM2022-riga|Q85862816}}
|-
{{WLM2022-riga|Q87813507}}
|-
{{WLM2022-riga|Q106254008}}
|-
{{WLM2022-riga|Q110280627}}
|-
{{WLM2022-riga|Q110280628}}
|-
{{WLM2022-riga|Q110280629}}
|-
{{WLM2022-riga|Q110280630}}
|-
{{WLM2022-riga|Q110280713}}
|-
{{WLM2022-riga|Q110280714}}
|}
{{Wikidata list end}}