SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "E C 2"/1) | (@(roleclean,performerclean) "E C 2")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 3120 matches on Event Comments, 1072 matches on Performance Comments, 546 matches on Performance Title, 12 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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

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

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: Redemption 0; Messiah

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End Part II: As17900219; End I: a new concerto on the Piano Forte-Attwood Jun., Musician to his Royal Highness the Prince of Wales

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

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

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Performances

Mainpiece Title: Redemption, Selected From The Great And Favourite Works Of handel That Were Performed In westminster-abbey And At The pantheon [on 26 And 27 May 1784] 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End: concerto on the hautboy-W. Parke; End II: concerto violin-Master Clement

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: PART III

Performances

Mainpiece Title: Redemption 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End I: concerto on the bassoon-Parkinson; End II: concerto violin-Master Clement

Performances

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

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End II: concerto on the violin-Weichsel

Performances

Mainpiece Title: Acis And Galatea 0; Grand Selection 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: PART III

Music: As17910323

Performances

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

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: Redemption 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17910330

Performances

Mainpiece Title: Redemption 0; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: End II: Da forte morir sapro-Miss Davies (Sarti)

Music: End I: concerto violin-Master Clement

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

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

Performances

Mainpiece Title: Idalide

Dance: End I: Amphion et Thalie, as17910409; End Opera: an entire new Ballet in 2 acts (composed by D'Auberval), La Fille Mal Gardee-See17910610

Performances

Mainpiece Title: Acis And Galatea 0; Redemption 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: A Miscellaneous Act

Music: End I: concerto on the hautboy-[J.] Parke

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Acis And Galatea 0; Redemption 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17920229

Performances

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

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act