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-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 (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)

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!

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!