SELECT * FROM london_stages WHERE eventid IN (47112, 47122, 47126, 47137, 47142, 47154, 47159, 47171, 47177, 47190, 47196, 47702, 47712, 47717, 47727, 47732, 47742, 47747, 47757, 47762, 47772, 47777, 48231, 48241, 48245, 48255, 48259, 48269, 48273, 48283, 48287, 48297, 48301, 48898, 48908, 48912, 48922, 48926, 48937, 48941, 48951, 49446, 49459, 49469, 49473, 49486, 49511, 49515, 50024, 50036, 50059, 50633, 50669, 50682, 51180, 51189, 51192, 51204, 51213, 51216, 51225, 51229, 51239, 51242, 51711, 51723, 51732, 51748, 51757, 51772, 52324, 52357) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music, From The Works Of Handel

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grandselection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Performances

Mainpiece Title: L'allegro Ed Il Penseroso; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Cast
Role: Concerto Violin Actor: G. Ashley

Performances

Mainpiece Title: A Second Grand Selection 0 Of Sacred Music, From The Works Of Handel

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Cast
Role: Concerto Violin Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Penseroso 2

Cast
Role: Concerto Violin Actor: G. Ashley

Afterpiece Title: A Grand Miscellaneous Act

Cast
Role: Concerto Violin Actor: G. Ashley

Music: End II: concerto on the violin-Weichsel

Performances

Mainpiece Title: A Grand Selection 0of Sacred Music From The Works Of Handel

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Penseroso 1

Cast
Role: Concerto Violin Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Penseroso 2

Cast
Role: Concerto Violin Actor: G. Ashley

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Performances

Mainpiece Title: The First Act Of Alexander's Feast; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: A Selection from Acis and Galatea

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Penseroso 1

Cast
Role: Concerto Violin Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Penseroso 2

Cast
Role: Concerto Violin Actor: G. Ashley

Afterpiece Title: A Grand Miscellaneous Act

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

Cast
Role: Geminiani Actor: G. Ashley.

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: L'Alegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: The Coronation Anthem

Afterpiece Title: The Messiah; L'Allegro ed il Pensieroso 0

Performances

Mainpiece Title: The First Grand Selection 0 Of Sacred Music From The Works Of handel; L'allegro Ed Il Pensieroso 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast 0; Redemption 0; L'allegro Ed Il Pensieroso 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Second Grand Selection 0 Of Sacred Music From The Works Of handel

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0of Favourite Songs And Chorusses From The Works Of handel

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Alexander's Feast 0; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: Alexander's Feast 3; Grand Miscellaneous Act

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: The Coronation Anthem

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Cast
Role: Leader of the Band Actor: G. Ashley

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley
Role: Organ Actor: J. Ashley.

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley
Role: Organ Actor: J. Ashley.

Afterpiece Title: A Grand Miscellaneous Act

Music: End II oratorio: concerto on the violin-Mme Gautherot

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso; Grand Selection 0

Cast
Role: Leader of the Band Actor: G. Ashley
Role: Organ Actor: J. Ashley.

Afterpiece Title: A Grand Miscellaneous Act

Music: As17930220