Property talk:P4908

Latest comment: 3 years ago by Husky in topic Title constraint?

Documentation

season
season of a series (televison, web, podcast)
Representstelevision series season (Q3464665), web series season (Q61704031), podcast series season (Q69154911), creative work season (Q70990126)
Has qualitycomplex constraint value label template (Q100883797), complex constraint value label template (Q100883797), complex constraint value label template (Q100883797), complex constraint value label template (Q100883797), complex constraint value label template (Q100883797)
Data typeItem
Template parameterseason_article Template:Infobox television episode
Domaintelevision series episode (Q21191270), television serial (Q7724161), web series episode (Q1464125), television film (Q506240), podcast episode (Q61855877), part of television season (Q93992677), talk show episode (Q106942341), segment of a television episode (Q29555881) or television special (Q1261214)
ExampleA Boy in a Tree (Q4279587)Bones, season 1 (Q909494)
Asylum of the Daleks (Q1574878)Doctor Who, series 7 (Q964428)
Keep Calm and Carry On (Q27685006)Supernatural, season 12 (Q26740166)
Tracking: usageCategory:Pages using Wikidata property P4908 (Q53958219)
Lists
Proposal discussionProposal discussion
Current uses
Total159,582distinct valuesratio
Main statement159,35899.9% of uses8,71218.3
Qualifier2020.1% of uses
Reference22<0.1% of uses
Search for values
[create Create a translatable help page (preferably in English) for this property to be included here]
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#Type Q21191270, Q7724161, Q1464125, Q506240, Q61855877, Q93992677, Q106942341, Q29555881, Q1261214, SPARQL
Single best value: this property generally contains a single value. If there are several, one would have preferred rank (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Kali (Q1103476), Shockwave (Q2086809), The Best of Both Worlds (Q722293), Redemption (Q7305751), Time's Arrow (Q7804770), Descent (Q390014), Basics (Q4867063), Scorpion (Q3511648), Equinox (Q1329701), Unimatrix Zero (Q3549975), The Siege (Q7764113), The Originals (Q16639702)
List of violations of this constraint: Database reports/Constraint violations/P4908#single best value, SPARQL
Qualifiers “series ordinal (P1545), follows (P155), followed by (P156), reason for deprecated rank (P2241), reason for preferred rank (P7452), country (P17): this property should be used only with the listed qualifiers. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#allowed qualifiers, SPARQL
Scope is as main value (Q54828448), as qualifier (Q54828449): the property must be used by specified way only (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#Scope, SPARQL
Item “title (P1476): Items with this property should also have “title (P1476)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#Item P1476, SPARQL
None of 1 (Q199), 2 (Q200), 3 (Q201), 4 (Q202), 5 (Q203), 6 (Q23488): value must not be any of the specified items.
Replacement property:
Replacement values: (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#none of, SPARQL
Conflicts with “series ordinal (P1545): this property must not be used with the listed properties and values. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#Conflicts with P1545, search, SPARQL
Required qualifier “series ordinal (P1545): this property should be used with the listed qualifier. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#mandatory qualifier, SPARQL
Item “part of the series (P179): Items with this property should also have “part of the series (P179)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#Item P179, search, SPARQL
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P4908#Entity types
 
Ordinal qualifier would generally be unique within season
define exceptions when needed (Help)
Violations query: SELECT ?item ?itemLabel ?season ?seasonLabel ?ordinal WITH { SELECT ?season ?ordinal (COUNT(DISTINCT ?ep) as ?ct) { ?ep p:P4908 [ ps:P4908 ?season ; pq:P1545 ?ordinal ] ; wdt:P31 wd:Q21191270 } GROUP BY ?season ?ordinal HAVING ( ?ct > 1) } as %find WHERE { INCLUDE %find ?item p:P4908 [ ps:P4908 ?season ; pq:P1545 ?ordinal ] SERVICE wikibase:label { bd:serviceParam wikibase:language "en,it". } } ORDER BY ?season xsd:integer(?ordinal)
List of this constraint violations: Database reports/Complex constraint violations/P4908#Ordinal qualifier would generally be unique within season
 
Ordinal qualifier on series statement would generally be unique within series
define exceptions when needed (Help)
Violations query: SELECT ?item ?itemLabel ?series ?seriesLabel ?ordinal WITH { SELECT ?series ?ordinal (COUNT(DISTINCT ?ep) as ?ct) { ?ep wdt:P4908 [] ; wdt:P31 wd:Q21191270; p:P179 [ps:P179 ?series ; pq:P1545 ?ordinal ] } GROUP BY ?series ?ordinal HAVING ( ?ct > 1) } as %find WHERE { INCLUDE %find ?item p:P179 [ ps:P179 ?series ; pq:P1545 ?ordinal ] ; wdt:P31 wd:Q21191270 SERVICE wikibase:label { bd:serviceParam wikibase:language "en,it". } } ORDER BY ?series xsd:integer(?ordinal) ?item
List of this constraint violations: Database reports/Complex constraint violations/P4908#Ordinal qualifier on series statement would generally be unique within series
 
Episode titles are generally unique
Currently checks English labels. Excludes a few series with repeating titles (Help)
Violations query: SELECT ?item ?l ?itemDescription ?item2 ?item2Description ?series ?seriesLabel WITH { SELECT ?series ?l (COUNT(DISTINCT ?ep) as ?ct) { ?ep wdt:P4908 [ ] ; wdt:P179 ?series ; wdt:P31 wd:Q21191270 ; rdfs:label ?l . FILTER( lang(?l) = "en" ) } GROUP BY ?series ?l HAVING ( ?ct > 1) } as %findmore WHERE { INCLUDE %findmore FILTER( ?series NOT IN ( wd:Q326180 , wd:Q2316316 , wd:Q2610941 ) ) hint:Query hint:optimizer "None". ?item wdt:P179 ?series ; rdfs:label ?l ; wdt:P31 wd:Q21191270 . ?item2 wdt:P179 ?series ; rdfs:label ?l ; wdt:P31 wd:Q21191270 . FILTER(str(?item) > str(?item2) ) MINUS { ?item wdt:P1889 ?item2 } MINUS { ?item2 wdt:P1889 ?item } MINUS { ?item wdt:P361 ?item2 } MINUS { ?item2 wdt:P361 ?item } FILTER NOT EXISTS { ?item wdt:P179 wd:Q1248101 } FILTER NOT EXISTS { ?item wdt:P179 wd:Q29474217 } FILTER NOT EXISTS { ?item wdt:P179 wd:Q786306 } FILTER NOT EXISTS { ?item wdt:P179 wd:Q16949801 ; rdfs:label "Justice Served"@en } FILTER NOT EXISTS { ?item wdt:P179 wd:Q2155230 ; rdfs:label "A Child Is Born"@en } SERVICE wikibase:label { bd:serviceParam wikibase:language "en,it". } } ORDER BY ?series ?l ?item
List of this constraint violations: Database reports/Complex constraint violations/P4908#Episode titles are generally unique
 
Label of season should be different from series
Seasons generally have a label in the format "[name of series], season [number]". Sometimes bot create items stripping the season number. Limited to English. See Wikidata:WikiProject_Movies/reports/TV_seasons/label/as_series. (Help)
Violations query: SELECT ?item ?series ?l WHERE { [ ] wdt:P4908 ?item . ?item wdt:P31 wd:Q3464665 ; wdt:P179 ?series ; rdfs:label ?l . ?series rdfs:label ?l . FILTER(lang(?l)="en") filter ( ?item != ?series) }
List of this constraint violations: Database reports/Complex constraint violations/P4908#Label of season should be different from series
 
Episodes generally have this property
Episodes of television series with multiple seasons generally have this property. Limited to 500. (Help)
Violations query: SELECT ?item ?itemLabel ?seriesLabel WHERE { ?item wdt:P31 wd:Q21191270 ; wdt:P179 ?series . ?series wdt:P2437 ?seasons . FILTER ( xsd:integer(?seasons) > 1 ) . FILTER NOT EXISTS { ?item wdt:P4908 [] } SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr,it,es" } } LIMIT 500
List of this constraint violations: Database reports/Complex constraint violations/P4908#Episodes generally have this property
 
Episodes generally have this property (count by series)
Series with most episodes lacking P4908. Limited to 100. (Help)
Violations query: SELECT ?item (COUNT(?ep) as ?ct) WHERE { ?ep wdt:P31 wd:Q21191270 ; wdt:P179 ?item . ?item wdt:P2437 ?seasons . FILTER ( xsd:integer(?seasons) > 1 ) . FILTER NOT EXISTS { ?ep wdt:P4908 [] } SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr,it,es" } } GROUP BY ?item ORDER BY DESC(?ct) LIMIT 50
List of this constraint violations: Database reports/Complex constraint violations/P4908#Episodes generally have this property (count by series)
 
This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Title constraint? edit

This property has a title (P1476) statement constraint, which seems a bit too strict to me. Some television shows (e.g. talk shows) don't really have a title, and just get a 'Talk show x featuring guest y' label. Of course, this is different for episodic dramatised television series. I've adapted this constraint to be a suggestion instead of an issue. Husky (talk) 20:04, 7 August 2020 (UTC)Reply

original language of film or TV show (P364) edit

If the item has "part of the series" and that series has a original language, isn't that sufficient?

Return to "P4908" page.