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

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

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

Music: End of Part II concerto on the organ by C. Wesley (1st appearance in public)

Performances

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

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 Selection Of Sacred Music From The Works Of Handel

Music: End of Part II concerto on the organ by J. Ashley

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

Performances

Mainpiece Title: A Grand Selection Of Sacred

Music: Principal Vocal Performers, Leader, Organ omitted, but see17940307ART I. As17940312but added: Holy, holy Lord; omitted: o worse than death and Angels ever bright. PART II. As17940312but Eighth Concerto of Corelli in place of Eleventh Grand Concerto; omitted: O sleep. PART III. As17940312athi

Performances

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

Music: End of Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: A Grand Selection Of Sacred

Music: As17940326athi

Performances

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

Music: In Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: A Grand Selection Of Sacred

Music: Principal Vocal Performers, Leader, Organ as17940307ART I. As17940326but added: He was eyes unto the blind; also O worse than death; Angels ever bright (THEODORA); omitted: Grateful hearts; For joys so vast; Happy they. PART II. As17940326but 6th violin concerto (composed by Giardini) by G. Ashley in place of Fourth Organ Concerto; added: Sweet Bird, accompanied on the violin by G. Ashley (L'ALLEGRO); also He rebuked the Red Sea (ISRAEL IN EGYPT); also In sweetest harmony; O fatal day (SAUL); omitted: He was eyes; He led them thro'; Ye sons of Israel; Weep, Israel, weep. PART III. As17940326but added to O liberty: accompanied on the violoncello by C. Ashley; to Let the bright: accompanied on the trumpet by Sarjant; also Sin not O King (SAUL); also So when the last (DRYDEN'S ODE); omitted: O beauteous Queen; The dead shall live

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

Afterpiece Title: A Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music Chiefly From handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

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