SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Elfrid or The Fair Inconstant"/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 Fair Circassian

Afterpiece Title: Lun's Ghost

Dance: As17820112

Performances

Mainpiece Title: The Fair Circassian

Afterpiece Title: The Maid of the Oaks

Dance: As17820123

Performances

Mainpiece Title: The Fair Circassian

Afterpiece Title: The Gentle Shepherd

Performances

Mainpiece Title: The Fair Circassian

Afterpiece Title: Robinson Crusoe

Performances

Mainpiece Title: The Fair Circassian

Afterpiece Title: The Divorce

Dance: As17820318athi

Performances

Mainpiece Title: The Fair Circassian

Afterpiece Title: The LYAR

Dance: As17820302athi

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Chaplet

Dance: After song at end of mainpiece The Irish Fair, as17820406

Song: End of Act II of mainpiece How sweet in the Woodlands by Bannister and Miss Phillips; End of mainpiece The Soldier tir'd of War's Alarms by Miss Phillips

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Henry and Emma

Afterpiece Title: The Capricious Lovers

Dance: End of Act I of afterpiece The Irish Fair, as17820406

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Irish Widow

Dance: End of Act I of mainpiece a Hornpipe, as17820314nd of mainpiece a Minuet by Brigg and A Young Lady (his Scholar [unidentified]); End of Act I of afterpiece The Irish Fair, as17820406

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Fair American

Afterpiece Title: Robinson Crusoe

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Divorce

Dance: As17820302athi

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Fair American

Afterpiece Title: The Critic

Performances

Mainpiece Title: The Fair American

Afterpiece Title: Catherine and Petruchio

Dance: As17820302athi

Performances

Mainpiece Title: The Fair American

Afterpiece Title: The Critic

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: All the World's a Stage

Dance: End of mainpiece The Irish Fair, as17820406

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Irish Widow

Dance: End of Act I of mainpiece, as17820223; End of Act I of afterpiece The Irish Fair, as17820406

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Harlequin Teague

Dance: As17820817, but added: Miss Francis

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Harlequin Teague

Dance: AS 26 Aug

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Tom Thumb

Dance: End of mainpiece, as17820925

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Capricious Lovers

Dance: End of Act I of afterpiece The Irish Fair by Blurton, Miss M. Stageldoir

Performances

Mainpiece Title: Fair Penitent

Afterpiece Title: The Gentle Shepherd

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Robinson Crusoe

Dance: As17820921

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Englishman in Paris

Dance: In afterpiece a Minuet by Williamson and Miss Collett