SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Second Part of the Rover"/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

Music: End Part I: Concerto on Organ-Stanley; Part II: Hautboy Concerto-Vincent

Performances

Mainpiece Title: The Messiah

Music: End Part I: Concerto on Violincello-Paxton; Part II: Violin Concerto-Barthelemon

Performances

Mainpiece Title: The Messiah; Judas Maccabaeus

Music: First Violin, as17760223; End Part I: Concerto on 3 Chromatic French Horns, as17760223; End Part II: Violin Concerto-Lamotte

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: The Coronation Anthems

Music: End Part I: concerto on the organ-Stanley; End Part II: concerto on the violin-Linley Jun

Performances

Mainpiece Title: Judas Maccabaeus

Music: End of Part I: concerto on the violoncello-Cervetto; End of Part II: concerto on the violin-Lamotte

Performances

Mainpiece Title: The Messiah; Judas Maccabaeus

Music: End Part I: a duetto on the tenor and violin-Stamitz, Lamotte; End Part II: concerto on the violin, as17770214

Performances

Mainpiece Title: Omnipotence; Judas Maccabaeus

Music: End Part I: solo on the pedal harp-Renaudin (1st public performance); End Part II: concerto on the violin, as17770214

Performances

Mainpiece Title: The Prodigal Son; Judas Maccabaeus

Song: With additional airs-

Music: End Part I: solo on the German flute-DeCamp; End Part II: concerto on the violin, as17770214

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Afterpiece Title: Daphne and Amintor

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Afterpiece Title: Comus

Performances

Mainpiece Title: Acis And Galatea

Afterpiece Title: Dryden's Ode

Song: Between: As there are very few songs in Acis and Galatea that can be adapted for Mrs Farrell's voice, she will sing a cantata The rosy morn with crimson dye=-Mrs Farrell

Music: End Part I: concerto on the organ-Stanley; End Part II: concerto on the violin-probably Linley Jun

Performances

Mainpiece Title: Acis And Galatea

Afterpiece Title: Sacred Canons

Music: End Part I: concerto on the German flute-Florio; End of Part III: concerto on the piano forte-Miss Weichsel; concerto on the hautboy-LeBrun; concerto on the violin-Master Weichsel

Performances

Mainpiece Title: Judas Maccabaeus; Acis And Galatea

Music: End Part I: concerto on the hautboy-Parke; End Part II: concerto on the violin, as17780306

Performances

Mainpiece Title: The Messiah; Acis And Galatea

Music: End Part I: concerto on the piano forte, as17780306End Part II: concerto on the violin, as17780306

Performances

Mainpiece Title: The Ascension; Acis And Galatea

Music: End Part I: concerto on the hautboy, as17780306End Part II: quartetto for the violin German flute tenor and piano forte-Master Weichsel, Florio, Stamitz, Miss Weichsel

Performances

Mainpiece Title: Omnipotence; Acis And Galatea

Music: End Part I: concerto on the violin, as17780306End Part II: concerto on the piano forte, as17780306

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Afterpiece Title: The Padlock

Dance: End IV: The Irish Fair-the Miss Stageldoirs

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Afterpiece Title: The Camp

Dance: End IV: The Force of Love, as17781003

Performances

Mainpiece Title: Judas Maccabaeus

Music: End Part I: concerto on the organ-Stanley; End Part II: concerto on the violin-Cramer

Performances

Mainpiece Title: Esther; Judas Maccabaeus

Music: End Part I: concerto on the organ, as17790219; End Part II: concerto on the hautboy-Parke

Performances

Mainpiece Title: Omnipotence; Messiah

Music: End Part I: concerto on the hautboy-Sharp; End Part II: concerto on the violin, as17790303

Performances

Mainpiece Title: The Messiah

Music: End of Part I: concerto on the trumpet, as17790319End of Part II: concerto on the violin, as17790303

Performances

Mainpiece Title: The Second Part Of King Henry The Fourth

Afterpiece Title: The Register Office

Dance: End IV: As17780919

Performances

Mainpiece Title: L'allegro, Penseroso Ed Il Moderato; Alexander's Feast

Music: End of Part I: concerto on the violin, as17800211; End of Part II: concerto on the hautboy, as17800216