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-logo-v2.svg Wikipedia
Commons-logo.svg Commons

to do: [1] [2]

Mix’n’MatchEdit

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

Top Missing: [3]

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 episodesEdit

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!

P973Edit

[4]

APIEdit

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 DoEdit

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

Constraint violationsEdit

LinksEdit

ToolabsEdit

Aspect RatioEdit

Search for items with given IMDb idEdit

SELECT ?item WHERE {
  ?item wdt:P345 "tt0110912"
}

Try it!

Films without identifierEdit

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 deLabelEdit

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 LabelEdit

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!