SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Squire of Alsatia"/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 Squire Of Alsatia

Performances

Mainpiece Title: The Squire Of Alsatia

Song: Randal, Mrs Fitzgerald

Dance: As17151104

Performances

Mainpiece Title: The Squire Of Alsatia

Song: As17151006

Dance: Moreau, Thurmond Jr, delaGarde, Mrs Bullock, Mrs Cross, Mrs Schoolding

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: Dutch Skipper, Spanish Entry-Salle, Mlle Salle

Performances

Mainpiece Title: The Squire Of Alsatia

Song: As17170204

Dance: As17170125; La Folie-Moreau, Mrs Bullock

Performances

Mainpiece Title: The Squire Of Alsatia

Song: As17170204

Dance: As17170325

Performances

Mainpiece Title: The Squire Of Alsatia

Afterpiece Title: The Cheats

Dance: Shaw, Thurmond Jr, Miss Smith

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: Moreau, Mrs Bullock

Performances

Mainpiece Title: The Squire Of Alsatia

Afterpiece Title: The School of Folly

Afterpiece Title: Harlequin Executed; or, The Farmer Disappointed

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: As17190209

Performances

Mainpiece Title: The Squire Of Alsatia

Song: Leveridge, Mrs Barbier, Mrs Fletcher

Dance: As17190430

Performances

Mainpiece Title: The Squire Of Alsatia

Dance:

Performances

Mainpiece Title: The Squire Of Alsatia

Dance:

Performances

Mainpiece Title: The Squire Of Alsatia

Dance:

Performances

Mainpiece Title: The Squire Of Alsatia

Performances

Mainpiece Title: The Squire Of Alsatia

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: Shaw, Boval, Lally, Mrs Booth, Mrs Bicknell, Mrs Bullock, Miss Tenoe

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: As17201018

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: As17201018

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: As17201018

Performances

Mainpiece Title: The Squire Of Alsatia

Dance: Desnoyer, Boval, Mrs Bicknell, Mrs Bullock, Miss Tenoe

Performances

Mainpiece Title: The Squire Of Alsatia

Performances

Mainpiece Title: The Squire Of Alsatia

Dance:

Performances

Mainpiece Title: The Squire Of Alsatia

Performances

Mainpiece Title: The Squire Of Alsatia