SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Magic Cavern"/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 Magic Girdle

Performances

Mainpiece Title: The Magic Girdle

Performances

Mainpiece Title: The Magic Girdle

Performances

Mainpiece Title: The Magic Girdle

Performances

Mainpiece Title: The Magic Girdle

Performances

Mainpiece Title: The Magic Girdle

Performances

Mainpiece Title: The Magic Girdle

Performances

Mainpiece Title: The Magic Girdle

Music: marly First Violin and a Concerto by Barthelemon

Performances

Mainpiece Title: Harlequin, Prince By Magic Art

Performances

Mainpiece Title: The Magic Girdle

Music: Solo Concerto on Basson-the celebrated M. LeCouteux, first performance in this kingdom; Concerto on Violin-Barthelemon; Comic act-Three Italian Musicians blind from birth

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Song: In Act II of mainpiece a Grand Chorus [Crowned with conquest] by Bannister, Reinhold, Johnstone, Mattocks, Brett, Mahon, Doyle, Darley; Mrs Bannister, Mrs Johnstone, Mrs Martyr, Mrs Morton, Miss Stuart, Mrs Davenett, Mrs Kennedy. [For songs, see below.]

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Song: As17831108

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Song: As17831108

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Song: As17831108, but omitted: Doyle

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Quaker

Song: As17831121

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: The Poor Soldier

Song: As17831121

Performances

Mainpiece Title: The Magic Picture

Afterpiece Title: Friar Bacon

Song: As17831121, but omitted: Mrs Bannister, Mrs Johnstone

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: Harlequin Junior; or, The Magic Cestus

Dance: End of Act IV of mainpiece The Sportsmen's Return, as17840916

Performances

Mainpiece Title: Henry The Second; Or, The Fall Of Rosamond

Afterpiece Title: Harlequin Junior; or, The Magic Cestus

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Harlequin Junior; or, The Magic Cestus

Performances

Mainpiece Title: Love In Many Masks

Afterpiece Title: Harlequin Junior; or, The Magic Cestus

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Harlequin and Quixotte; or, The Magic Arm

Performances

Mainpiece Title: Lover's Vows

Afterpiece Title: The Magic Oak; or, Harlequin Woodcutter

Music: End I afterpiece: A Medley Overture on the Union Pipes and Pedal Harp-Murphy, Weippert

Performances

Mainpiece Title: The Votary Of Wealth

Afterpiece Title: The Magic Oak

Music: Afterpiece: The Overture-; accompanied on the Union Pipes-Murphy; accompanied on the Pedal Harp-Weippert

Performances

Mainpiece Title: Laugh When You Can

Afterpiece Title: The Magic Oak

Music: As17990131