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: The Captive

Dance: As17690515

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Vintner Trick'd

Dance: As17690515

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Dance: TThe Sailor's Return, as17690825

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Dance: As17690515

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Miss in Her Teens

Dance: The Pedlar-Mas. and Miss West, apprentices to Grimaldi

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Thomasand Sally

Dance: TThe Cowkeeper-Master West, Miss West

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Dance: TThe Cowkeeper, as17700521

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Dance: TThe Nosegay, as17700611

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Dance: TThe Cowkeeper, as17700521

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Damon and Phillida

Dance: End of Play: The Pedlar, as17700718

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Midas

Dance: End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Dance: End of Play: The Pedlar, as17700817

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: hay The Padlock

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: hay The Padlock

Dance: hay End of Play: The Nosegay, as17700611

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: hay The Padlock

Dance: hay End of Play: The Cowkeeper, as17700521

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Miss in Her Teens

Dance: I: The Cowkeepers-Mas. West, Miss West

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Virgin Unmasked

Dance: The Nosegay, as17710531

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Padlock

Dance: As17710517

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Englishman in Paris

Dance: The Nosegay-

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Miss in Her Teens

Dance: As17720518

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Lying Valet

Dance: As17720518

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Cooper

Dance: As17720518

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: The Lying Valet

Dance: As17720615