FIRST / LAST

FIRST and LAST answer the simplest historical question: when did this song first appear, and when did it say goodbye?


Synopsis

FIRST "Song Name";
LAST "Song Name";
▶ Try it in sandbox →

Returns a single show — the first or last time that song was performed.


Examples

FIRST "Help on the Way";
LAST "Saint Stephen";
LAST "Dark Star";  -- March 30, 1994
FIRST "Touch of Grey";
▶ Try it in sandbox →

Tips

  • The result is a show (date, venue, city) — the same format as SHOWS results.
  • For a full list of every performance, use PERFORMANCES OF "Song" ORDER BY DATE instead.