SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Devil Upon Two Sticks"/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 Devil Upon Two Sticks

Afterpiece Title: Cupid's Revenge

Dance: As17720615

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Mock Doctor

Dance: As17720817

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Virgin Unmask'd

Dance: As17730618

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Damon and Phillida

Dance: New Tambourine Dance-Giorgi's scholars

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Tobacconist

Entertainment: I: A Variety of Imitations Rhetorical and Vocal-Hutton; II: O What a Charming Thing's a Battle-Bannister; End: A New Song-Miss Wilde

Dance: End Interlude: A Tambourine Dance-Giorgi's Scholars

Monologue: Between Play and Entertainment: A Comic Interlude (taken from the Primitive Puppet Show) call'd A Sentimental Comedy; or, Piety in Pattens. Butler-Weston; Squire-Fearon; Mrs Candy-Mrs Palmer; Polly Pattens-Mrs Jewell

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Lying Valet

Dance: As17740516

Monologue: End: Piety in Pattens. As 1 June

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Cross Purposes

Dance: As17740613

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Cross Purposes

Dance: As17740613

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Devil to Pay

Dance: As17740613

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Devil to Pay

Monologue: Interlude. Piety in Pattens. As 1 June

Entertainment: End I: Imitations, vocal and rhetorical-Bannister; After Interlude: Abel Drugger's Return from the Fete Champetre at Marybone-Weston

Dance: Giorgi's Scholars

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: A Trip to Portsmouth

Dance: As17740810

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Author

Dance: End: A Dance-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Author

Dance: As17750515

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Author

Dance: End: A Dance-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Medley-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Medley-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Dutchman

Dance: The Medley-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Contract

Dance: Tambourine Dance-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Lyar

Dance: The Coopers-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Catherine and Petruchio

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Lyar

Dance: The Merry Lasses-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Waterman

Dance: The Venetian Regatta-