SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "A Grand Selection 0 Composed By g"/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: Judas Maccabaeus; Grand Selection 0

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: 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: 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: The Messiah; Grand Selection 0

Performances

Mainpiece Title: Israel In Egypt; Messiah; Grand Selection 0

Afterpiece Title: A New Selection

Performances

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

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: The Brothers

Afterpiece Title: Alexander the Little; or, The Rival Queans

Dance: End: The Jockies-Ratchford, Platt, Jackson, Mrs Goodwin

Song: End II: song-Incledon; Afterpiece: The Tragedy will be interspersed with Airs, Duets, Glees, composed by Arne, Arnold, Fischer, Dibdin, with a Grand Overture(A Finale, composed by Shield), Triumphal Entry of Alexander-

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: 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: Il Barbiere Di Siviglia

Dance: End I: a new Divertisement (composed by Noverre)-Mlle Millerd (from the Grand Opera in Paris; 1st appearance in this country), Mlle Hilligsberg, Favre Gardel, Nivelon; End Opera: Les Caractres de la Danse-; a new divertisement (composed by Noverre), Les Epoux du Tempe-Mlle Hilligsberg, Mlle Millerd, Nivelon, Favre Gardel

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 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 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: Alexander's Feast; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

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

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: L'allegro Ed Il Pensieroso; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

Music: As17930220

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3