SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,authname,perftitleclean,commentcclean,commentpclean) "George Frederic Handel"/1) | (@(roleclean,performerclean) "George Frederic Handel")') 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 5289 matches on Author, 868 matches on Event Comments, 845 matches on Performance Comments, 379 matches on Performance Title, and 0 matches on Roles/Actors.

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

Performance Comment: Overture-(Ariadne); From wave to wave-Sale; Thy right hand O Lord-Chorus (Israel in Egypt); Pleasure my former ways resigning-Harrison; Happy if still we reign-Chorus (Time and Truth); Pious Orgies-Miss Cantelo [Judas Maccabaeus]; But bright Cecilia-Sga Storace; As from the power of sacre lays-Chorus (Dryden's Ode); God save Great George our King-Greatorex.

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

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Redemption A Sacred Oratorio Selected From The Great And Favourite Works Of handel That Were Performed At His Commemoration In westminster abbey And At The pantheon On 26 And 27 May 1784 0 Messiah

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17900219

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 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: 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 From The Works Of handel 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Marian

Song: In: Mad Bess (composed by Purcell)-Mrs Billington; accompanied-Knyvett; In afterpiece: Sweet Bird (from L'Allegro il Penseroso, by Handel)-Mrs Billington; accompanied on the violin (for that night only)-Weichsel

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: A 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: 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 Second Grand Selection 0 Of Sacred Music From The Works Of Handel

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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: 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: Redemption 0 Selected From The Works Of handel By dr Arnold

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

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

Performances

Mainpiece Title: The First Grand Selection 0 Of Sacred Music From The Works Of handel Lallegro Ed Il Pensieroso 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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: A Grand Selection 0of Favourite Songs And Chorusses From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Performance Comment: Hautboy concerto (Handel)-; Blooming virgins-Incledon (Athalia); And in that air Behold! God is my salvation-Reinhold; Therefore with joy-Reinhold; And in that Day-Mrs Bland; Call upon his name-Mrs Bland; Sing unto the Lord-Mrs Crouch, Reinhold; Cry out and shout-Chorus (New Anthem, Shaw); Fair Rosale-Master Welsh (Linley); Let's imitate-Dignum, Miss Hagley (Alexander's Feast); What though I trace-Mrs Crouch (Solomon); Zadock the Priest-Chorus (Coronation Anthems).

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

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

Performances

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

Performances

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