User:Queryzo

Babel user information
de-N Dieser Benutzer sprichtDeutschalsMuttersprache. en-2 This user hasintermediateknowledge ofEnglish. fr-1 Cet utilisateur dispose de connaissancesde baseenfrançais.
Users by language

	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

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{
?episodewdt:P31wd:Q21191270.
?episodewdt:P179?serie
MINUS{?episodewdt:P345[]}
MINUS{?episoderdf:typewdno:P345}
SERVICEwikibase:label{bd:serviceParamwikibase:language"en".}
}GROUP BY?serie?serieLabelORDER BYDESC(?count)

Try it!

Missing IMDb Ids (and items) by count grouped by series:

SELECT?series?seriesLabel((?anzahl-COUNT(?episode))AS?count)WHERE{
?episodewdt:P31wd:Q21191270.
?episodewdt:P345?imdb.
?episodewdt:P179?series.
?serieswdt:P1113?anzahl
SERVICEwikibase:label{bd:serviceParamwikibase:language"en".}
}GROUP BY?series?seriesLabel?anzahlORDER BYDESC(?count)

Try it!

asd

SELECT?item("Den"as?Dde)(CONCAT("episode of",?l)as?desc)WHERE{
?itemwdt:P31/wdt:P279*wd:Q21191270.
?itemwdt:P179?serie.
?seriewdt:P31wd:Q5398426.
MINUS{?itemschema:description?dFILTER(LANG(?d)="en").}
?serierdfs:label?l.
FILTER(lang(?l)="en")
}ORDER BY?desc?item

Try it!

P973

[5]

API

https://api.urlmeta.org/?url=https:// imdb /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)

• Filmregisseur
• Drehbuchautor
• Filmproduzent
• Kameramann
• Filmeditor
• Kostümbildner
• Maskenbildner
• Filmkomponist
• Szenenbildner

• Prenames

• births
• deaths

• birth date and age

Constraint violations

• 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

• 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

• 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

• 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

SELECT?itemWHERE{
?itemwdt:P345"tt0110912"
}

Try it!

Films without identifier

SELECTDISTINCT?filmWHERE{
?filmwdt:P31/wdt:P279*wd:Q11424.
FILTERNOT EXISTS{?filmwdt:P345[]}.
?wde<http://schema.org/about>?film.?wde<http://schema.org/inLanguage>"en".
?filmwdt:P1562[]
}

Try it!

SELECT?filmWHERE{
?filmwdt:P31wd:Q11424.
FILTERNOT EXISTS{?filmwdt:P31wd:Q20089094}
MINUS{
?film?p[].
?propwikibase:directClaim?p.
?propwdt:P31wd:Q22964274
}
}
LIMIT10000

Try it!

Directors without deLabel

SELECT?item?itemLabelWHERE{
?itemwdt:P31/wdt:P279*wd:Q11424.
?itemwdt:P3107?ldif.
?itemwdt:P57?regisseur.
FILTERNOT EXISTS{?regisseurrdfs:label?delabel.FILTER(lang(?delabel)="de")}
SERVICEwikibase:label{bd:serviceParamwikibase:language"de"}
}

Try it!

kein deutsches Label

SELECT?film?filmportalWHERE{
?filmwdt:P31/wdt:P279*wd:Q11424.
?filmwdt:P2639?filmportal
FILTERNOT EXISTS{?filmrdfs:label?delabel.FILTER(lang(?delabel)="de")}
}ORDER BY?film

Try it!

→User:Queryzo/Filmportal

SELECT?film?ldifWHERE{
?filmwdt:P31/wdt:P279*wd:Q11424.
?filmwdt:P3107?ldif
FILTERNOT EXISTS{?filmrdfs:label?delabel.FILTER(lang(?delabel)="de")}
}ORDER BY?film

Try it!

SELECT?film?ofdbWHERE{
?filmwdt:P31/wdt:P279*wd:Q11424.
?filmwdt:P3138?ofdb
FILTERNOT EXISTS{?filmrdfs:label?delabel.FILTER(lang(?delabel)="de")}
}ORDER BY?film

Try it!