SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Rover Part II"/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 the hautboy, as17810307End Part II: concerto on the violin, as17810302

Song: As17810328

Performances

Mainpiece Title: L'omaggio

Dance: As17810605

Music: End Part I: a concerto on the hautboy-LeBrun; End Part II: a concerto on the violin-Cramer

Performances

Mainpiece Title: L'allegro Ii Penseroso

Afterpiece Title: The Choice of Hercules

Music: End of Part I of oratorio concerto on the violoncello by Crosdill; End of Part II concerto on the hautboy by Parke

Performances

Mainpiece Title: Judas Maccabaeus

Music: End of Part I concerto on the organ by Stanley; End of Part II concerto on the violin by Pieltain (1st time of his performing in public in England)

Performances

Mainpiece Title: Solomon

Music: End of Part I concerto on the organ by Stanley; End of Part II concerto on the hautboy by Parke

Performances

Mainpiece Title: The Messiah

Music: End of Part I concerto on the flute by Ashe; End of Part II concerto on the violin by Giornovichi

Performances

Mainpiece Title: A 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

Music: End Part I: concerto on the Piano Forte-Miss M'Arthur; End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Conquest Of Granada, Part Ii

Performances

Mainpiece Title: The Destruction Of Jerusalem By Titus Vespasian, Part Ii

Performances

Mainpiece Title: The Siege Of Rhodes, Part Ii

Performances

Mainpiece Title: The Second Part Of The Rover

Performances

Mainpiece Title: The Destruction Of Jerusalem By Titus Vespasian, Part Ii