SELECT * FROM london_stages WHERE eventid IN (9192, 12714, 14775, 14924, 15569, 18662, 19561, 19765, 19774, 19807, 19822, 19976, 20513, 20545, 20599, 21705, 21729, 22158, 22699, 22740, 22754, 23213, 23263, 23781, 23819, 24675, 25245, 25920, 25934, 25947, 25966, 25973, 26163, 28597, 28598, 28601, 28608, 28612, 28632, 28637, 28640, 28650, 28933, 29973, 29977, 30262, 31265, 31710, 36361, 36464, 36484, 36877, 36929, 36962, 37963, 37965, 37968, 37970, 37972, 37974, 37976, 37978, 37981, 37986, 37988, 37990, 37999, 38004, 38022, 38031, 38038, 38048, 38051, 38057, 38061, 38066, 38068, 38092, 38098, 38106, 38129, 38144, 38152, 38159, 38161, 46000, 46009, 46026, 46527, 46531, 46541, 46554, 46555, 46568, 46569, 46573, 46582, 46583, 46588, 47111, 47112, 47126, 47137, 47141, 47154, 47159, 47171, 47196, 47702, 47712, 47717, 47732, 47741, 47742, 47747, 47756, 47757, 47777, 48231, 48255, 48269, 48273, 48282, 48283, 48297, 48301, 49338, 49340, 49343, 49345, 49348, 49350, 49352, 49354, 49357, 49359, 49362, 49371, 49373, 49376, 49378, 49385, 49387, 49390, 49392, 49399, 49401, 49425, 49432, 49439, 49446, 49452, 49460, 49465, 49473, 49515, 50021, 50024, 50033, 50036, 50059, 51189, 51204, 51213, 51229, 51711, 51723, 51757, 51772, 52324, 52333, 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: The Suspicious Husband

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Fifth Grand Concerto Actor:

Afterpiece Title: Grand Selection 3

Music: End II: As17890227; End Part I: Concerto by Handel on organ-Greatorex

Performances

Mainpiece Title: A Grand Concerto Spirituale 0

Afterpiece Title: Grand Concerto Spirituale 1

Afterpiece Title: Grand Concerto Spirituale 2

Afterpiece Title: Grand Concerto Spirituale 3

Music: As17890311

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Cast
Role: Fourth Hautboy Concerto Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17890306

Performances

Mainpiece Title: A Grand Selection [of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Fifth Grand Concerto Actor:

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the Piano Forte-Clementi

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Fourth Hautboy Concerto Actor:

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Eleventh Grand Concerto Actor:

Afterpiece Title: Grand Selection 3

Music: As17900224

Performances

Mainpiece Title: A Grand Selection From The Works Of handel 0; Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Concerto violin Actor: Weichsel

Afterpiece Title: Grand Selection 3

Cast
Role: Fourth Hautboy Concerto Actor:

Music: End II: concerto on the violin-Weichsel

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Cast
Role: Fifth Grand Concerto Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Fifth Grand Concerto Actor:

Afterpiece Title: Grand Selection 3

Cast
Role: Fifth Grand Concerto Actor:

Music: As17900219

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Cast
Role: Grand Concerto Actor:

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Cast
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3

Music: End II: As17900219; End I: Miserere Mei Deus-, composed by Sg Gregorio Allegri, in the Year 1650, from an authentic Copy brought from Italy by Greatorex. A Translation of this Work (the 51st Psalm in English) will be printed in the Books of the Night

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Cast
Role: Fourth Hautboy Concerto Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Fourth Hautboy Concerto Actor:

Afterpiece Title: Grand Selection 3

Cast
Role: Fourth Hautboy Concerto Actor:

Music: End II: As17900224; End Part I: Miserere Mei Deus, as17900317

Performances

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

Afterpiece Title: Grand Selection 1

Cast
Role: Concerto on the violin Actor: Weichsel
Role: Grand Concerto Actor:

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Cast
Role: Eleventh Grand Concerto Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: Eleventh Grand Concerto Actor:

Afterpiece Title: Grand Selection 3

Cast
Role: Eleventh Grand Concerto Actor:

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Cast
Role: Fifth Grand Concerto Actor:

Afterpiece Title: Grand Selection 2

Cast
Role: First Grand Concerto Actor:
Role: Second Oboe Concerto Actor:

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Music: As17900219

Performances

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

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3