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: Zara

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: Rosina

Dance: End of mainpiece, as17830917

Song: In Act I of afterpiece a favourite song by Sga Sestini; In Act II she will introduce the celebrated tune of Marlborough, with English words adapted to it

Performances

Mainpiece Title: The Heroine Of The Cave

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Song: In Act II of mainpiece an Anthem (singers not listed)

Performances

Mainpiece Title: Cymon

Afterpiece Title: Rosina

Dance: In Act I of mainpiece a Dance of Cupids; In Act IV a Dance of Daemons; In Act V a Grand Ballet (performers not listed)

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Song: End of mainpiece September the Thirteenth proud Bourbon may mourn, from Gretna Green (composed by Dr Arnold) by Bannister

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: Cymon

Afterpiece Title: Rosina

Dance: End of mainpiece The Rival Nymphs, as17840318athi

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Rosina

Dance: In Act III of mainpiece, as17831014; End of mainpiece The Poney Races, as17840428

Song: End of Act I of mainpiece a favourite song by Leoni; End of Act II When Phoebus the tops of the bills does adorn by Leoni and Brett

Performances

Mainpiece Title: Too Loving By Half

Afterpiece Title: The Winter's Tale

Afterpiece Title: Rosina

Dance: End of 2nd piece Adelaide de Brabant, as17840508

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: Rosina

Dance: End of mainpiece The Charms of a Camp, as17840521

Song: End of Act II of mainpiece Tally Ho! by Mrs Martyr; End of Act iv Poor ThomasDay by Edwin, Davies, Brett

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: RosiNA

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: Rosina

Song: End of mainpiece Edwin's favorite song in The Castle of Andalusia, A Master I have, by Master Sestini

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Rosina

Song: In Act III of mainpiece a sons by Brett

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Rosina

Song: As17841112

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Rosina

Song: As17841112, but omitted: Mrs Sharpe

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Rosina

Song: As17841108, but added: Miss Francis

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Follies Of A Day

Afterpiece Title: Rosina

Dance: As17841022

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Follies Of A Day

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Follies Of A Day

Afterpiece Title: Rosina

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: Rosina

Performances

Mainpiece Title: The Arab

Afterpiece Title: Rosina

Dance: As17841116