Property talk:P4908
Jump to navigation
Jump to search
Documentation
season
season of a series (televison, web, podcast)
season of a series (televison, web, podcast)
[create Create a translatable help page (preferably in English) for this property to be included here]
Type “television series episode (Q21191270), serial drama (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), television special (Q1261214)”: item must contain property “instance of (P31)” with classes “television series episode (Q21191270), serial drama (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), television special (Q1261214)” or their subclasses (defined using subclass of (P279)). (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#Type Q21191270, Q7724161, Q1464125, Q506240, Q61855877, Q93992677, Q106942341, Q29555881, Q1261214, SPARQL
Value type “television series season (Q3464665), web series season (Q61704031), podcast series season (Q69154911), part of television season (Q93992677)”: This property should use items as value that contain property “instance of (P31)”. On these, the value for instance of (P31) should be an item that uses subclass of (P279) with value television series season (Q3464665), web series season (Q61704031), podcast series season (Q69154911), part of television season (Q93992677) (or a subclass thereof). (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#Value type Q3464665, Q61704031, Q69154911, Q93992677, 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
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
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). Replacement property:
Replacement values: (Help)
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:
List of this constraint violations: Database reports/Complex constraint violations/P4908#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:
List of this constraint violations: Database reports/Complex constraint violations/P4908#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:
List of this constraint violations: Database reports/Complex constraint violations/P4908#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:
List of this constraint violations: Database reports/Complex constraint violations/P4908#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:
List of this constraint violations: Database reports/Complex constraint violations/P4908#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:
List of this constraint violations: Database reports/Complex constraint violations/P4908#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)
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?
Categories:
- All Properties
- Properties with wikibase-item-datatype
- Properties used on 100000+ items
- Properties with distinct value counts
- Properties with constraints on type
- Properties with single best value constraints
- Properties with qualifiers constraints
- Properties with scope constraints
- Properties with constraints on items using them
- Properties with none-of constraints
- Properties with conflicts with constraints
- Properties with required qualifiers constraints
- Properties with entity type constraints
- Properties with complex constraints
- Podcasting properties