SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Redemption 0 Messiah Grand Selection 0"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Acis And Galatea 0 Redemption 0

Afterpiece Title: Acis and Galatea 3 i

Performances

Mainpiece Title: Acis And Galatea 0 Redemption 0

Afterpiece Title: Acis and Galatea 3 i

Performances

Mainpiece Title: A Grand Selection 0 of Sacred Music From The Works Of handel Chiefly Performed At westminster abbey At The handel Commemoration 26 May 1784 Messiah

Afterpiece Title: The Coronation Anthem God save the King

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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

Performances

Mainpiece Title: A Prelude

Afterpiece Title: Redemption 0 Triumph of Truth 0

Music: End I oratorio: serenata solo on harp, as17890306End II: a new Grand Concerto on the harp-Mme Krumpholtz; Conclude: God save Great George our King-

Performances

Mainpiece Title: Redemption 0 Triumph Of Truth 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17890311

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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

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

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

Performances

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

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 Messiah

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900224

Performances

Mainpiece Title: Judas Maccabaeus Grand Selection 0 Messiah

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

Afterpiece Title: Grand Selection 3

Music: End II: concerto on the violin-Weichsel

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah Grand Selection 0

Performances

Mainpiece Title: The Messiah Grand Selection 0

Performances

Mainpiece Title: Israel In Egypt Messiah Grand Selection 0

Afterpiece Title: A New Selection

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: 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: A Grand Selection 0principally From The Works Of handel Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah Grand Selection 0

Afterpiece Title: The Coronation Anthem

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: End II: Mad Bess-Mrs Crouch (Purcell)

Performances

Mainpiece Title: The Messiah Grand Selection 0

Afterpiece Title: The Messiah 1

Afterpiece Title: The Messiah 2

Afterpiece Title: The Messiah 3

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

Music: End Part II: concerto on the violin-Janiewicz

Performances

Mainpiece Title: Redemption Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: As17930220

Music: End Part II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: Redemption Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3