SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "ROSINA"/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 Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Mysterious Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Rosina

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: King John

Afterpiece Title: Rosina

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: Rosina

Dance: As17820927

Performances

Mainpiece Title: A Bold Stroke For A Husband

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Rosina

Song: In Act II of mainpiece song by Brett

Performances

Mainpiece Title: King Richard The Third

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

Afterpiece Title: Rosina

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Rosina

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: The Grecian Daughter

Afterpiece Title: Rosina

Performances

Mainpiece Title: More Ways Than One

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Man Of Theworld

Afterpiece Title: Rosina