SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Rival Knights"/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 Winter's Tale

Afterpiece Title: The Rival Knights

Afterpiece Title: The Devil upon Two Sticks

Performances

Mainpiece Title: Lionel And Clarissa

Afterpiece Title: The Rival Knights

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Rival Knights

Afterpiece Title: The Country Mad-Cap

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: (End of Act II) The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: (End of Act I) The Rival Knights

Afterpiece Title: Three Weeks after Marriage

Dance: In Act III of mainpiece Hornpipe by Miss Besford

Performances

Mainpiece Title: Spanish Friar

Afterpiece Title: The Rival Knights

Afterpiece Title: Tom Thumb

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Rival Knights

Afterpiece Title: Tristram Shandy

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Rival Knights

Afterpiece Title: Tristram Shandy

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Dance: As17830922

Song: As17830922, but added: Johnstone; Mrs Chalmers, Mrs Davenett

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: The Rival Knights

Afterpiece Title: 9 Oct

Afterpiece Title: The Flitch of Bacon

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: The Rival Knights

Afterpiece Title: The Wives Revenged

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: St

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Rival Knights

Afterpiece Title: The Positive Man

Dance: As17830922

Song: As17831027, but omitted: Doyle, Mrs Bannister, Mrs Johnstone, Mrs Kennedy

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: The Rival Knights

Afterpiece Title: The Son-in-Law

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Rival Knights

Afterpiece Title: Tristram Shandy

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Rival Knights

Afterpiece Title: Cross Purposes

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Retaliation

Performances

Mainpiece Title: The Duenna

Afterpiece Title: The Rival Knights

Afterpiece Title: Tristram Shandy

Performances

Mainpiece Title: The Capricious Lady

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Rival Knights

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks