User:Most2dot0/Test3

From Angelina Jordan Wiki

Cargo query to count live occurrences of songs

This counts several segments of the same occurrence only as 1 performance. This works quite well, as the individual concert in a tour is represented as a segment (while the year is the occurrence), e.g., for the 2017 Christmas tour, or the 2017, '19, and '22 summer concerts. It also counts only one of the two 2024 Vegas concerts. It's a like bit skewed in some cases, e.g. that Kongsberg 2022 is in the database not part of the 2022 summer tour, though from the setlist and band it's of the same kind.

The list is then sorted by number of such capped occurrences and then by it's first live performance date, showing only the first live performance for each title.

27

18

13

11

    Bohemian Rhapsody

    • TV • Talent show • America's Got Talent • The Champions 2 (date: 2019-10-03)

10

    Summertime

    • TV • Talent show • Norway's Got Talent (date: 2014-05-23)

9

8

    At Last

    • Live • Guest appearance • Bystasjonen Mall, Sandnes (date: 2014-10)

    Unchained Melody

    • Concert • Festival • Nattjazz Festival (date: 2015-05-31)

7

6

    I Put a Spell on You

    • Concert • Guest appearance • New Year's concert • 2017 (date: 2017-01-08)

    Valerie

    • Concert • Kongsberg Jazz Festival • 2018 • Kongsberg Musikkteater (date: 2018-07-07)

5

    All of Me (jazz standard)

    • Concert • Christmas • Christmas concerts • 2018 (date: 2018-12-20)

    When We Were Young

    • Concert • Summer concert tour • 2019 • Prøysenhuset (date: 2019-07-12)

    I Have Nothing

    • TV • Guest appearance • Allsang på Grensen • 2022 (date: 2022-06-22)

    Suspicious Minds

    • Concert • Summer concert tour • 2022 • July 1st - Sandjeford (date: 2022-07-01)

    Love Don't Let Me Go

    • TV • Guest appearance • A tribute to Narges Mohammadi (date: 2023-12-11)

    If I Were a Boy

    • Live • Guest appearance • Jesse & Friends @ The Hotel Cafe (date: 2024-05-16)

4

3

2

1

    Rolling in the Deep

    • - • unsorted • School event • 2013 (date: 2013-06)

    I Have a Dream

    • Live • Guest appearance • Rådmannsgården art exhibition (date: 2013-10-04 ?)

    Hurt

    • Concert • Festival • VAD-festivalen • 2013 (date: 2013-12-01)

    Gloomy Sunday

    • TV • Talent show • Norway's Got Talent (date: 2014-01-25)

    Let Me Entertain You

    • TV • Talent show • Norway's Got Talent (date: 2014-05-23)

    You Raise Me Up

    • Conference • Guest appearance • Rotary Club Convention • 2016, Seoul (date: 2016-06-01)

    La Vie en rose

    • Livestream • Instagram Live Stream (date: 2016-06-18)

    Sing Me to Sleep

    • Concert • Guest appearance • Alan Walker Is Heading Home (date: 2016-12-22)

    Kawa no nagare no yō ni

    • Concert • Dojima River Forum (date: 2017-03-30)

    I Just Want to Make Love to You

    • Concert • Summer concert tour • 2017 • Sandefjord (date: 2017-07-12)

    Strangers in the Night

    • Concert • Summer concert tour • 2017 • Larkollen (date: 2017-07-19)

    Million Years Ago

    • Concert • Concert in LA (date: 2018)

    Cheek to Cheek

    • Concert • It's Magic concert (date: 2018-06-16)

    It's Magic

    • Concert • It's Magic concert (date: 2018-06-16)

    La Bohème

    • Concert • It's Magic concert (date: 2018-06-16)

    Mr. Lonely

    • Concert • It's Magic concert (date: 2018-06-16)

    Man in the Mirror

    • Concert • Guest appearance • Quincy Jones 85th birthday concert (date: 2018-06-27)

    Born to Die

    • Concert • Kongsberg Jazz Festival • 2018 • Kongsberg Musikkteater (date: 2018-07-07)

    Rehab

    • Concert • Kongsberg Jazz Festival • 2018 • Kongsberg Musikkteater (date: 2018-07-07)

    Unchain My Heart

    • Concert • Kongsberg Jazz Festival • 2018 • Kongsberg Musikkteater (date: 2018-07-07)

    Over the Rainbow

    • Concert • Christmas • Christmas concerts • 2018 (date: 2018-12-20)

    Santa Claus Is Comin' to Town

    • Concert • Christmas • Christmas concerts • 2018 (date: 2018-12-21)

    Someone You Loved

    • TV • Talent show • America's Got Talent • The Champions 2 (date: 2019-10-21)

    Bad Romance

    • Concert • Summer concert tour • 2022 • July 1st - Sandjeford (date: 2022-07-01)

    I'm Not the Only One

    • Concert • Summer concert tour • 2022 • July 1st - Sandjeford (date: 2022-07-01)

    These Boots Are Made for Walkin'

    • Concert • Summer concert tour • 2022 • July 1st - Sandjeford (date: 2022-07-01)

    We're the Best

    • TV • Guest appearance • The Best FIFA Football Awards™ • 2022 (date: 2023-02-27)

    Careless Whisper

    • Concert • US concert • Portsmouth • 2023 (date: 2023-09-22)

    All I Ask

    • Concert • Las Vegas • 2024 • 9:30pm (date: 2024-02-29)

    Diamond

    • Concert • Las Vegas • 2024 • 7pm (date: 2024-02-29)

    Hero

    • Concert • Las Vegas • 2024 • 7pm (date: 2024-02-29)

    Moon River

    • Concert • Las Vegas • 2024 • 7pm (date: 2024-02-29)

    All of Me (John Legend song)

    • Concert • US concert • Alex Theater, Glendale • 2024 (date: 2024-09-20)

    I'd Rather Go Blind

    • Concert • US concert • Alex Theater, Glendale • 2024 (date: 2024-09-20)

    Right Here Waiting

    • Concert • US concert • Alex Theater, Glendale • 2024 (date: 2024-09-20)

    Set Fire to the Rain

    • Concert • US concert • Alex Theater, Glendale • 2024 (date: 2024-09-20)

    What Am I to You

    • Concert • US concert • Alex Theater, Glendale • 2024 (date: 2024-09-20)

    Driving Home for Christmas

    • Concert • Christmas • Christmas Special • 2024 (date: 2024-12-14)

    I Will Always Love You

    • Concert • Christmas • Christmas Special • 2024 (date: 2024-12-14)

    Jingle Bell Rock

    • Concert • Christmas • Christmas Special • 2024 (date: 2024-12-14)

    Last Christmas

    • Concert • Christmas • Christmas Special • 2024 (date: 2024-12-14)

    Bel Air

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Home

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Memories

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Mi Amor

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    No One Can Hear My Heart

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Play No Game

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Purple Rain

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Run to You

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    So Peaceful Beside You

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Still Standing

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Summer Wind

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    Tennessee Whiskey

    • Concert • Las Vegas • 2026 (date: 2026-01-31)

    You Know When It's Gone

    • Concert • Las Vegas • 2026 (date: 2026-01-31)
Retrieved from "https://www.angelina-jordan.net/w/index.php?title=User:Most2dot0/Test3&oldid=13836"