SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Knight of the Burning Pestle"/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 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: The Merry Wives Of Windsor

Afterpiece Title: The Rival Knights

Afterpiece Title: Comus

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

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

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Rival Knights

Afterpiece Title: The Poor Soldier

Dance: As17830922

Song: As17840119, but omitted: Mahon

Performances

Mainpiece Title: The Two Gentlemen Of Verona

Afterpiece Title: The Rival Knights

Afterpiece Title: Tom Thumb

Song: In Act V of mainpiece A Frightened Song by Quick

Monologue: 1784 04 13 End of mainpiece a new Occasional Address spoken by Quick, riding on an Elephant

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Rival Knights

Afterpiece Title: Rosina

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Rival Knights

Afterpiece Title: The Sultan

Dance: As17840306athi

Performances

Mainpiece Title: The Castle Of Andalusia

Afterpiece Title: The Rival Knights

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Rival Knights

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Rival Knights

Afterpiece Title: The Maid of the Oaks

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: The Rival Knights

Afterpiece Title: Rose and Colin

Dance: End of Act II of mainpiece a Dramatic Romance, Adelaide de Brabant; or, The Triumph of Virtue. Principal Characters by Bithmere, Le Boeuf, Mme Bithmere. ["An infant son of Grimaldi (i.e. Joseph, aged 6) performs in an astonishing manner" (Gazetteer, 12 May).] End of Act IV an Allemande and Dance, called Malbrough (composed by Vestris Jun.) by Le Boeuf and Mme Bithmere

Performances

Mainpiece Title: Robin Hood

Afterpiece Title: The Rival Knights

Afterpiece Title: Barnaby Brittle

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: High Life below Stairs

Dance: In afterpiece: Mock Minuet-Mr and Mrs Knight

Entertainment: Singing and Monologues.End: a Dialogue Duet (1st time), The Pledge of Love; or, British Tar's Farewell-Incledon, Mrs Mountain (the Music entirely New); The Barber's Petition, with a song in character, Wigs (including his Own Wig, The Doctor's Wig, Counsellor's Wig, The Lover's Wig, Coachman's Wig, etc.)-Knight; Ode on the Passions-Mrs Pope; Old Towler-Incledon

Performances

Mainpiece Title: Seeing Is Believing

Afterpiece Title: The Red-Cross Knights

Afterpiece Title: The Purse

Performances

Mainpiece Title: The Red-cross Knights

Afterpiece Title: The Follies of a Day

Performances

Mainpiece Title: The Red-cross Knights

Afterpiece Title: High Life below Stairs

Dance: In II afterpiece: Mock Minuet-Palmer, Miss DeCamp

Performances

Mainpiece Title: The Red-cross Knights

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Red-cross Knights

Afterpiece Title: Fortune's Frolick

Performances

Mainpiece Title: The Red-cross Knights

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Red-cross Knights

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Castle Of Sorrento

Afterpiece Title: The Red-Cross Knights

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Hartford Bridge

Song: End II: A New Hunting Song- (never [previously] performed, composed by Davy); End III: Sally in our Alley-Incledon; End: The Red Cross Knight, as18000426; End I afterpiece: The Sailor's Journal-Incledon