Queryzo

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.

	Wikipedia
	Commons

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

film festival (Q220505)
full list (active) this month	Tools without month without location country categories editions without year editions without festival most statements
film festival edition (Q27787439)

Mix’n’Match

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

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

[5]

API

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

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

Prenames

birth date and age

Constraint violations

Links

Toolabs

Quick Statements (neu)
Live Stream
Persondata Challenge
The Distributed Game
The Wikidata Game
Harvest Templates
PetScan
Query Service
SQID
[/N|B%20[/]%20N)$&columns=tipocolore&limit=3000&regexp=yes TemplateTiger]

Aspect Ratio

Search for items with given IMDb id

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

Try it!

Films without identifier

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

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

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!