SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "A Grand Selection 0of Sacred Music From The Works Of handel"/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: 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

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Song: End oratorio: Captivity [see17930220]-Incledon

Music: End Part II: the favourite concerto of Geminiani on the violin-G. Ashley

Performances

Mainpiece Title: L'allegro Ed Il Penseroso [, Part I Only]; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Song: In 1st piece: Sweet bird-Mrs Ferguson (her 1st performance); accompanied on the violin-Shaw; End 2nd piece: an Italian Scena-Mrs Ferguson

Performances

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

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Performances

Mainpiece Title: Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah , Part I; Grand Selection 0

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Song: End 2nd piece: Ye spotted Snakes-(Stevens)

Performances

Mainpiece Title: The Messiah; Grand Selection 0

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

Performances

Mainpiece Title: The Messiah

Afterpiece Title: The Resurrection

Afterpiece Title: A New Grand Selection

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part II: a trio for violin viola and violoncello-G. and R. and C. Ashley

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part I: Sixth concerto of Geminiani on the violin-G. Ashley

Performances

Mainpiece Title: A Grand Selection

Afterpiece Title: ACIS AND GALATEA

Music: End of Part I of oratorio concerto on violin by Giornovichi

Performances

Mainpiece Title: A Grand Selec Tion Of Music From The Most Eminent Masters

Afterpiece Title: THE GRAND TE DEUM, composed by Paisiello, upon the return of his Majesty the King of the Two Sicilies, from Vienna to Naples, in the summer of 1791

Performances

Mainpiece Title: La Serva Padrona

Dance: End of opera concerto, as17940603 after which La Vittoria (a Grand Cantata, composed by Paisiello, and performed by Mme Banti at Naples, adapted [by Da Ponte] to the glorious occasion of the triumph of the British flag [on 1 June 1794]), The Goddess of Victory-Mme Banti, accompanied by Chorusses, and a grand Allegorical Ballet, composed by Noverre; to conclude with Rule Britannia by Mme Banti

Performances

Mainpiece Title: Alexander's Feast; Grand Selection 0

Afterpiece Title: A Grand Miscellaneous Act

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Music: End Part II: 3rd concerto of Giardini on the violin-G. Ashley

Performances

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

Afterpiece Title: L'Allegro ed Il Pensieroso 3; Alexander's Feast 3

Music: End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: The Messiah; Alexander's Feast; Grand Selection 0

Music: End Part I: 3rd concerto of Giardini on the violin-G. Ashley; End Part II: concerto on the Piano Forte-Dussek