User:ValterVB/SPARQL

List for complete episods

# List for complete episods
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?series ?seriesLabel ?NmberOfSeason ?season ?seasonLabel ?NumberInTheSeries ?NumberInTheSeason ?pre ?suc ?imdb WHERE {
  VALUES ?istanza { wd:Q21191270 wd:Q653916 wd:Q73622 } 

  ?item wdt:P31 ?istanza .
  ?item wdt:P179 wd:Q438406. #Change here for the series
  
  ?item wdt:P179 ?series.  
  ?item p:P179 ?statement .
  ?statement pq:P1545 ?NumberInTheSeries .
  
  ?item wdt:P4908 ?season.
  ?item p:P4908 ?statement2 .
  ?statement2 pq:P1545 ?NumberInTheSeason .
  
  OPTIONAL {?item wdt:P155 ?pre.}
  optional{?item wdt:P156 ?suc.}
  
  OPTIONAL {?season p:P179 ?statement3 .}
  OPTIONAL {?statement3 pq:P1545 ?NmberOfSeason .}
  
  OPTIONAL { ?item wdt:P345 ?imdb.}

  SERVICE wikibase:label { bd:serviceParam wikibase:language "it". }
}
ORDER BY  ?series xsd:integer(?NumberInTheSeries)

Try it!

Episods without number (P1545)

# Episodi senza numeri

SELECT ?istanzaLabel ?item ?itemLabel ?serie ?serieLabel ?date ?parte ?parteLabel ?seriesW ?seriesW2 WHERE {
  VALUES ?istanza { wd:Q21191270 wd:Q653916 } 

  ?item wdt:P31 ?istanza .
  ?item wdt:P179 ?serie.
  #?item wdt:P361 ?parte.
  ?item wdt:P4908 ?parte.
  ?item p:P179 ?statement .
  #?item p:P361 ?statement2 .
  ?item p:P4908 ?statement2 .
  OPTIONAL {?item wdt:P1191 ?date.}

  OPTIONAL {?statement pq:P1545 ?seriesW .}
  OPTIONAL {?statement2 pq:P1545 ?seriesW2 .}
  
  FILTER (!bound( ?seriesW )).
  FILTER (!bound( ?seriesW2 )).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "it". }
}

ORDER BY  ?serie ?date

Try it!

Item with P31=television series episode, with P179 but without P4908

# Item with P31=television series episode, with P179 but without P4908

SELECT ?item ?label ?_image WHERE {
  ?item wdt:P31 wd:Q21191270.
  ?item wdt:P179 ?serie.
  FILTER NOT EXISTS { ?item wdt:P4908 ?stagione }
  
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

TV series episode or television pilot without P1545

# television series episode or television pilot  without P1545

SELECT ?istanzaLabel ?item ?itemLabel ?serie ?serieLabel ?date ?parte ?parteLabel ?seriesW ?seriesW2 WHERE {
  VALUES ?istanza { wd:Q21191270 wd:Q653916 wd:Q50062923 wd:Q21664088 wd:Q29197 } 

  ?item wdt:P31 ?istanza .
  ?item wdt:P179 ?serie.
  #?item wdt:P361 ?parte.
  ?item wdt:P4908 ?parte.
  ?item p:P179 ?statement .
  #?item p:P361 ?statement2 .
  ?item p:P4908 ?statement2 .
  OPTIONAL {?item wdt:P1191 ?date.}

  OPTIONAL {?statement pq:P1545 ?seriesW .}
  OPTIONAL {?statement2 pq:P1545 ?seriesW2 .}
  
  FILTER (!bound( ?seriesW )).
  FILTER (!bound( ?seriesW2 )).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "it". }
}

ORDER BY  ?serie ?date

Try it!