Template:FilteredPerformanceOverviewTables
Documentation
Provides overviews of type "Event by context", "Event by year", "Songs by title", and "Songs by year" for filtered subsets of the performance database. Note that in theory it could be used without filters, however the result would be huge, and transclusion would usually fail due to runtime limits.
Usage
{{FilteredPerformanceOverviewTables|where=SQL expression for WHERE clause}}
The 'where' parameter
'WHERE' clause syntax
The 'where' parameter provides the content of the 'WHERE' clause, which follows usual SQL syntax, with the Cargo extension's "HOLDS" and "HOLDS LIKE"↗, which are applicable for array fields (like "context" and "partners"). For "LIKE" and "HOLDS LIKE" the standard SQL wildcards "%" (any amount of arbitrary characters) and "_" (exactly one arbitrary character) can be used.
Fields you can filter on are those that are contained in the standard query that is used in this template. As of the time of this writing, these are:
Available fields
From "Performances":
songeventcontextdatetypepospartnerscommentperfID
From "Songs":
title, referenced assongTitletype, referenced assongType
Due to the structure of this query, you cannot filter with the "where" argument on fields from the "Videos" table, like "duration", "quality", or "rating".
Examples
{{FilteredPerformanceOverviewTables|where=context HOLDS LIKE 'Talent Show'}}
⇓
By event
By events per context
| Events by context | |||
|---|---|---|---|
| TV : Talent show | |||
| Talent show • America's Got Talent, The Champions 2 [7 Items] | |||
| Talent show • Little Big Shots, Germany [1 Item] | |||
| Talent show • Little Big Shots, UK [1 Item] | |||
| Talent show • Little Big Shots, US [2 Items] | |||
| Talent show • Norway's Got Talent [10 Items] | |||
By events per year
| Events by Year | ||||
|---|---|---|---|---|
| 2014 | ||||
| ◁ Norway's Got Talent [10 Items] | ||||
| 2016 | ||||
| ◁ Little Big Shots [3 Items] | ||||
| 2017 | ||||
| ◁ Little Big Shots [1 Item] | ||||
| 2019 | ||||
| ◁ America's Got Talent [7 Items] | ||||
By song title
Performances by song title
A · B · C · D · E · F · G · H · I · J · K · L · M · N · O · P · Q · R · S · T · U · V · W · X · Y · Z
| Songs | ||||
|---|---|---|---|---|
| B | ||||
| Bang Bang (My Baby Shot Me Down) - Wikipedia↗ [2 Items] | ||||
| Bohemian Rhapsody - Wikipedia↗ [1 Item] | ||||
| F | ||||
| Fly Me to the Moon - Wikipedia↗ [2 Items] | ||||
| G | ||||
| Gloomy Sunday - Wikipedia↗ [2 Items] | ||||
| Goodbye Yellow Brick Road - Wikipedia↗ [2 Items] | ||||
| I | ||||
| I'm a Fool to Want You - Wikipedia↗ [2 Items] | ||||
| I Put a Spell on You - Wikipedia↗ [1 Item] | ||||
| I (Who Have Nothing) - Wikipedia↗ [1 Item] | ||||
| L | ||||
| Let Me Entertain You - Wikipedia↗ [1 Item] | ||||
| S | ||||
| Someone You Loved - Wikipedia↗ [4 Items] | ||||
| Summertime - Wikipedia↗ [1 Item] | ||||
| W | ||||
| What a Diff'rence a Day Made - Wikipedia↗ [1 Item] | ||||
| What a Wonderful World - Wikipedia↗ [1 Item] | ||||
Performances by year and song title
| Songs by year | ||||
|---|---|---|---|---|
| 2014 | ||||
| Bang Bang (My Baby Shot Me Down) - Wikipedia↗ [2 Items] | ||||
| Gloomy Sunday - Wikipedia↗ [2 Items] | ||||
| I'm a Fool to Want You - Wikipedia↗ [2 Items] | ||||
| I (Who Have Nothing) - Wikipedia↗ [1 Item] | ||||
| Let Me Entertain You - Wikipedia↗ [1 Item] | ||||
| Summertime - Wikipedia↗ [1 Item] | ||||
| What a Wonderful World - Wikipedia↗ [1 Item] | ||||
| 2016 | ||||
| Fly Me to the Moon - Wikipedia↗ [2 Items] | ||||
| What a Diff'rence a Day Made - Wikipedia↗ [1 Item] | ||||
| 2017 | ||||
| I Put a Spell on You - Wikipedia↗ [1 Item] | ||||
| 2019 | ||||
| Bohemian Rhapsody - Wikipedia↗ [1 Item] | ||||
| Goodbye Yellow Brick Road - Wikipedia↗ [2 Items] | ||||
| Someone You Loved - Wikipedia↗ [4 Items] | ||||
See also
{{SongsTable}}
