SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "An Unhappy Choice"/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 Earl Of Essex; Or, The Unhappy Favourite

Afterpiece Title: The Crusade

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Afterpiece Title: Oscar and Malvina

Music: As17911024

Performances

Mainpiece Title: The Earl Of Essex; Or, The Unhappy Favorite

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Afterpiece Title: Harlequin's Museum

Dance: Not listed on playbill or thereafter, but probably as17921226.

Performances

Mainpiece Title: The Earl Of Essex; Or, The Unhappy Favorite

Afterpiece Title: HARLEQUIN AND FAUSTUS

Performances

Mainpiece Title: The Earl Of Essex; Or, The Unhappy Favourite

Afterpiece Title: The Picture of Paris

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Afterpiece Title: A Divertisement

Dance: Ballet, as17971002, but Mrs _Watts

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Orphan; Or, The Unhappy Marriage

Afterpiece Title: The Naval Pillar

Dance: As17991007

Song: In afterpiece: As17991007

Performances

Mainpiece Title: The Earl Of Essex; Or, The Unhappy Favorite

Afterpiece Title: The Volcano; or, The Rival Harlequins