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

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17900219

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3 Entirely selected from The Messiah

Music: As17900219

Performances

Mainpiece Title: Redemption 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

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

Performances

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

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End II: concerto on the violin-Weichsel

Performances

Mainpiece Title: Acis And Galatea 0; Grand Selection 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: PART III

Music: As17910323

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

Mainpiece Title: Redemption 0; Messiah; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17910330

Performances

Mainpiece Title: Redemption 0; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: End II: Da forte morir sapro-Miss Davies (Sarti)

Music: End I: concerto violin-Master Clement

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

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

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

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

Afterpiece Title: Alexander's Feast 3; Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0 Of Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: In Part III: Captivity-Mrs Crouch [, as17930220

Music: End Part I: concerto on the violoncello-C. Ashley

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

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: 6th concerto of Giordani on the violin-C. Ashley

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 Part II: violin concerto by Giardini-G. Ashley

Performances

Mainpiece Title: Alexander's Feast Or, the Power Of Music; Grand Selection 0

Afterpiece Title: Alexander's Feast 3

Music: End Part I: concerto on the harp-Mme Delaval; Beginning Part II: concerto for two violins and violoncello obligato-, as originally composed for this Ode, by Handel and performed in the year 1736; End Part II: concerto on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Afterpiece Title: A Grand Sacred Selection 3

Music: End I: concerto on pedal harp-Miss Dupree (1st appearance in public)

Performances

Mainpiece Title: A Grand Sacred Selection 0; Messiah 0

Afterpiece Title: A Grand Sacred Selection 1

Afterpiece Title: A Grand Sacred Selection 2

Afterpiece Title: A Grand Sacred Selection 3

Music: End II: concerto on Piano Forte-Miss MacArthur

Performances

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

Afterpiece Title: Alexander's Feast 3

Music: End II: a concertante for violin oboe tenor and violoncello-G. Ashley, W. Parke, R. Ashley, C. Ashley

Performances

Mainpiece Title: Acis And Galatea 0; Grand Selection 0

Afterpiece Title: Acis and Galatea 3

Music: End I: a Military Concerto on the new Patent Grand Piano Forte-Mrs Dussek built by Corri and Dussek; with tambourine-; triangle-; End II: concerto on the oboe-W. Parke

Performances

Mainpiece Title: Titus Andronicus

Dance: As17240421

Music: End II: A new Piece of music for the Harpsicord-Eversman; accompanied on the Bassoon-Kenny; III: Cantata-Mrs Chambers; IV: Handel's Water Music with French Horns-

Performances

Mainpiece Title: Love's Last Shift

Dance: new Grand Spanish Dance-Dupre, Pelling, Newhouse, Lanyon, Dupre Jr, Mrs Bullock, Mrs Wall, Mrs Ogden, Mrs Anderson; Shepherd and Shepherdess-Young LeSac, Miss Latour; French Sailor-Salle, Mlle Salle; A new Grand Chacone-Dupre, Lally, Pelling, Dupre Jr, Mrs Bullock, Mrs Wall, Mrs Ogden, Mrs Anderson; A Grand Comic Dance between Two Scaramouches Three Harlequins and Two Punches-

Performances

Mainpiece Title: The Fortune Hunters

Afterpiece Title: Hob

Dance: End I: Scottish Dance-Mrs Bullock; III: Grand Dance of French Sailors-Poitier, Pelling, Newhouse, Dupre, Pagod, Mrs Bullock, Miss Latour, Mrs Anderson, Mrs Ogden; IV: Fingalian-Newhouse, Mrs Ogden; V: A new Grand Dance of Moors-Glover, Pelling, Newhouse, Lanyon, Miss Latour, Mrs Anderson, Mrs Ogden; in which, at the Desire of several Persons of Quality, Kettle Drums-Poitier; End Farce: a new Grand Dance called Lads and Lasses-Poitier, Pelling, Newhouse, Dupre Jr, Mrs Bullock, Mrs Anderson, Miss Latour, Mrs Ogden

Song: II: Mrs Barbier; IV: Two English Ballads-Mrs Barbier