User:Queryzo
Babel user information | ||||
---|---|---|---|---|
| ||||
Users by language |
![]() |
Wikipedia |
![]() |
Commons |
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)
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)
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
P973
[edit]API
[edit]https://api.urlmeta.org/?url=https://www.imdb.com/title/tt5212822/
To Do
[edit]- [6] RT from zhWP (doesn't work)
- Filmregisseur
- Drehbuchautor
- Filmproduzent
- Kameramann
- Filmeditor
- Kostümbildner
- Maskenbildner
- Filmkomponist
- Szenenbildner
Constraint violations
[edit]- IMDb ID (P345): Link, complex, human
- TMDB person ID (P4985): [7]
- Rotten Tomatoes ID (P1258): Link
- Filmportal ID (P2639): Link, human
- FSK film rating (P1981): Link
- LdiF ID (P3107): Link
- OFDb film ID (P3138): Link
- AlloCiné film ID (P1265): Link
- GECD film ID (P3367): Link
Links
[edit]- Wikidata:WikiProject Movies
- Wikidata:Forum, WD:PC
- Special:Contributions/KasparBot
- Special:Contributions/Goo1Bot
- Special:Contributions/BotMultichill
- Special:Contributions/QuickStatementsBot
- top missing properties by number of sitelinks
Toolabs
[edit]- 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®exp=yes TemplateTiger]
Aspect Ratio
[edit]- 16:9 (Q1383069)
- Academy ratio (Q1541540) (1,37:1)
- 1.66:1 (Q10397024)
- 3:2 (Q20970431)
- 4:3 (Q20970432)
- 1.85:1 (Q21037379)
- 2.35:1 (Q21062414)
- 16:10 (Q3077333)
- 2.39:1 (Q24668302)
Search for items with given IMDb id
[edit]SELECT ?item WHERE {
?item wdt:P345 "tt0110912"
}
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 []
}
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
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" }
}
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
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
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