SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "THE MOUNTAINEERS"/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 Mountaineers

Afterpiece Title: Caernarvon Castle

Song: Mainpiece: Vocal Parts, as17930803, but _Little, _Brown, _Hobler, _Horsfall, _Saunders, _Dibble, _Lyons

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Rosina

Song: Mainpiece: Vocal Parts-Kenrick, Walker, Linton, Dorion, Dorion Jun., Miss Dall, Mrs Powell, Mrs Hatton, Mrs Masters, Mrs Bramwell, Mrs Edwin, Mrs Gaudry, Mrs Hale

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Rosina

Song: As17930816

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: As17930816

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: As17930816

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Rosina

Song: As17930816

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Son-in-Law

Song: Vocal Parts, as17930816, but Miss Fontenelle, Miss +DeCamp, Miss +Menage

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Polly Honeycomb

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Who's the Dupe

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: A Mogul Tale

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Caernarvon Castle

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Comus

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Village Lawyer

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Son-in-Law

Song: As17930823

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Who's the Dupe

Song: Vocal Parts, as17930823, but Miss _DeCamp

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Peeping Tom

Song: As17930906

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Agreeable Surprise

Song: Vocal Parts, as17930906, Mrs _Powell, Mrs _Gaudry, Mrs _Hale

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Son-in-Law

Song: As17930911

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Village Lawyer

Song: As17930911

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Who's the Dupe

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Humourist

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Children in the Wood

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The Prize

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: Who's the Dupe