SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Spanish Rivals"/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 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: The Castle Of Andalusia

Afterpiece Title: The Positive Man

Dance: End of mainpiece new Pastoral Ballet (composed by Harris), The Rival Nymphs, by Byrn, Ratchford, Harris, Miss Byrn, Miss Matthews

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

Performances

Mainpiece Title: Tancred And Sigismunda

Afterpiece Title: The Rival Knights

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Zara

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Rival Knights

Afterpiece Title: The Sultan

Dance: As17840306athi

Performances

Mainpiece Title: Which Is The Man

Afterpiece Title: The Rival Knights

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Rosin a

Dance: End of Act III of mainpiece, as17830917; End of Act IV The Rival Symphs, as17831119, but Mrs Goodwin [i.e. formerly Miss Byrn]