User:Queryzo

From Wikidata
Jump to navigation Jump to search
Babel user information
de-N Dieser Benutzer spricht Deutsch als Muttersprache.
en-2 This user has intermediate knowledge of English.
fr-1 Cet utilisateur dispose de connaissances de base en français.
Users by language
Wikipedia
Commons

to do: [1] [2] [3]

film festival (Q220505)
film festival edition (Q27787439)

Mix’n’Match

[edit]

Play: LdiF (report), OFDb (report, sync), Filmportal Personen-IDs(report), Filmportal Film-IDs (report, sync), Moviepilot, IMDb (report, sync), ČSFD, SilentEra.com

Top Missing: [4]

Episodes of series: Desperate Housewives (episodes), Land of the Lost, Beverly Hills, 90210 (episodes), Supernatural (episodes), Law & Order (episodes), Prison Break (episodes), Stargate SG-1 (episodes), Charmed (episodes), Sanctuary (episodes), Torchwood (episodes), Stargate Atlantis (episodes), Vampire Diaries (episodes), Law & Order: Special Victims Unit (episodes), Law & Order: Criminal Intent (episodes), Gilmore Girls (episodes), Navy CIS (episodes), Samurai Jack, Avatar: The Last Airbender (episodes), My Little Pony: Friendship Is Magic (episodes), The Twilight Zone, Babylon 5 (episodes), CSI: Miami (episodes), Magnum, P.I. (episodes), Emergency Room (episodes), Doctor Who, Hercules

https://tools.wmflabs.org/mix-n-match/import.php

more episodes

[edit]

The Sopranos (episodes), SpongeBob SquarePants (episodes), Casualty (episodes), Holby City (episodes), Pastewka (episodes), Xena: Warrior Princess (episodes), Szomszédok (episodes), Kaamelott (episodes), Law & Order: Trial by Jury (episodes), Star Wars: The Clone Wars (episodes), Twin Peaks (episodes), The A-Team (episodes), The Kapil Sharma Show (episodes), King of the Hill (episodes), Mayday (episodes), JAG (episodes), Bones (episodes), Vízipók-csodapók (episodes), Two and a Half Men (episodes), Grey’s Anatomy (episodes), Stargate Universe (episodes), Corn and cluck (episodes), CSI: Crime Scene Investigation (episodes), Will & Grace (episodes), Eine für alle – Frauen können’s besser (episodes), Die Biene Maja (episodes), M*A*S*H (episodes), Inspector Rex (episodes), PAW Patrol (episodes), Wacky Races (episodes), Ellen (episodes), Lindenstraße (episodes), NCIS: Los Angeles (episodes), The Flintstones (episodes) 

SELECT ?serie ?serieLabel (COUNT(?episode) AS ?count) WHERE {
  ?episode wdt:P31 wd:Q21191270 .
  ?episode wdt:P179 ?serie
  MINUS { ?episode wdt:P345 [] }
  MINUS { ?episode rdf:type wdno:P345 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} GROUP BY ?serie ?serieLabel ORDER BY DESC(?count)
Try it!

Missing IMDb Ids (and items) by count grouped by series: 

SELECT ?series ?seriesLabel  ((?anzahl-COUNT(?episode)) AS ?count) WHERE {
  ?episode wdt:P31 wd:Q21191270 .
  ?episode wdt:P345 ?imdb .
  ?episode wdt:P179 ?series .
  ?series wdt:P1113 ?anzahl
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} GROUP BY ?series ?seriesLabel ?anzahl ORDER BY DESC(?count)
Try it!

asd 

SELECT ?item ("Den" as ?Dde) (CONCAT("episode of ", ?l) as ?desc) WHERE {
  ?item wdt:P31/wdt:P279* wd:Q21191270 .
  ?item wdt:P179 ?serie .
  ?serie wdt:P31 wd:Q5398426 .
  MINUS { ?item schema:description ?d FILTER (LANG (?d) = "en") .}
  ?serie rdfs:label ?l .
  FILTER(lang(?l) = "en")
} ORDER BY ?desc ?item
Try it!

P973

[edit]

[5]

API

[edit]

https://api.urlmeta.org/?url=https://www.imdb.com/title/tt5212822/

https://query.wikidata.org/#SELECT%20%3Fitem%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ11424%20.%0A%20%20%3Fitem%20wdt%3AP2529%20%5B%5D%20.%0A%20%20MINUS%20%7B%20%3Fitem%20p%3AP345%2Fa%20wdno%3AP345%20.%20%7D%20%20%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP345%20%3Fimdb%20.%20%7D%0A%20%20%7D

To Do

[edit]
  • [6] RT from zhWP (doesn't work)

Constraint violations

[edit]
[edit]

Toolabs

[edit]

Aspect Ratio

[edit]

Search for items with given IMDb id

[edit]
SELECT ?item WHERE {
  ?item wdt:P345 "tt0110912"
}
Try it!

Films without identifier

[edit]
SELECT DISTINCT ?film WHERE {
  ?film wdt:P31/wdt:P279* wd:Q11424 .
  FILTER NOT EXISTS { ?film wdt:P345 [] } .
  ?wde <http://schema.org/about> ?film . ?wde <http://schema.org/inLanguage> "en" .
  ?film wdt:P1562 []
}
Try it! 
SELECT ?film WHERE {
  	?film wdt:P31 wd:Q11424 .
        FILTER NOT EXISTS { ?film wdt:P31 wd:Q20089094}
  MINUS {
    ?film ?p [] .
    ?prop wikibase:directClaim ?p .
    ?prop wdt:P31 wd:Q22964274
  }
}
LIMIT 10000
Try it!

Directors without deLabel

[edit]
SELECT ?item ?itemLabel WHERE {
  ?item wdt:P31/wdt:P279* wd:Q11424 .
  ?item wdt:P3107 ?ldif .
  ?item wdt:P57 ?regisseur .
  FILTER NOT EXISTS {?regisseur rdfs:label ?delabel . FILTER(lang(?delabel) = "de")}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de" }
}
Try it!

kein deutsches Label

[edit]
SELECT ?film ?filmportal WHERE {
  	?film wdt:P31/wdt:P279* wd:Q11424 .
	?film wdt:P2639 ?filmportal
    FILTER NOT EXISTS {?film rdfs:label ?delabel . FILTER(lang(?delabel) = "de")}
} ORDER BY ?film
Try it!

→ User:Queryzo/Filmportal 

SELECT ?film ?ldif WHERE {
  	?film wdt:P31/wdt:P279* wd:Q11424 .
	?film wdt:P3107 ?ldif 
    FILTER NOT EXISTS {?film rdfs:label ?delabel . FILTER(lang(?delabel) = "de")}
} ORDER BY ?film
Try it! 
SELECT ?film ?ofdb WHERE {
  	?film wdt:P31/wdt:P279* wd:Q11424 .
	?film wdt:P3138 ?ofdb 
    FILTER NOT EXISTS {?film rdfs:label ?delabel . FILTER(lang(?delabel) = "de")}
} ORDER BY ?film
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Queryzo&oldid=1444128033"