User:Queryzo

From Wikidata
Jump to: navigation, 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-logo-v2.svg Wikipedia
Commons-logo.svg Commons

to do: [1] [2]

film festival (Q220505)
film festival edition (Q27787439)

Mix’n’Match[edit]

Play: LdiF, OFDb, Filmportal Personen-IDs, Filmportal Film-IDs

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, Vampire Diaries (episodes), Law & Order: Special Victims Unit (episodes), Law & Order: Criminal Intent, 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

The Sopranos (episodes)

SpongeBob SquarePants (episodes)

Casualty (episodes)

Holby City (episodes)

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

SELECT ?serie ?serieLabel (COUNT(?episode) AS ?count) WHERE {
  ?episode wdt:P31 wd:Q21191270 .
  ?episode wdt:P179 ?serie
  FILTER NOT EXISTS {?episode wdt:P345 ?imdb}
  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!

To Do[edit]

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

Constraint violations[edit]

Links[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 ?imdb } 
}

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!