SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "A Medley Concert And Auction"/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: A Medley Concert

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: A Medley Concert

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: A Medley Concert

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: A Medley Concert

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: A Medley Concert

Afterpiece Title: Harlequin's Frolic

Performances

Mainpiece Title: Miss Midnight's Medley Concert

Afterpiece Title: The Farmer Trick'd

Performances

Mainpiece Title: Miss Midnight's Medley Concert

Afterpiece Title: The Farmer Trick'd

Performances

Mainpiece Title: Miss Midnight's Medley Concert

Afterpiece Title: The Farmer Trick'd

Performances

Mainpiece Title: Miss Midnight's Medley Concert

Afterpiece Title: The Farmer Trick'd

Performances

Mainpiece Title: New Medley Concert

Afterpiece Title: Harlequin's Frolic

Song: Kear

Ballet: LLe Carneval de Venice. Dutchman-Dupuis; Harlequin-T. Hussey; Scotchman-Froment; Pierrot-Rainel; Frenchman-Delascey; Punch-Joly; Dutchwoman-Miss Wilkinson; Harliquinette-Mad Stivaux; Scots Lass-Mad Dulisse; Pierotte-Mad Clary; Mademoiselle-Miss Durham; Mlle Ragonsby-Hussey

Performances

Mainpiece Title: New Medley Concert

Afterpiece Title: Harlequin's Frolic

Song: As17571226

Ballet: LLe Carneval de Venice. As17571226

Performances

Mainpiece Title: New Medley Concert

Afterpiece Title: Harlequin's Frolic

Song: As17571226

Ballet: LLe Carneval de Venice. As17571226

Performances

Mainpiece Title: New Medley Concert

Afterpiece Title: Harlequin's Frolic

Ballet: LLe Carneval de Venice. As17571226, but Harlequin-J. Hussey

Performances

Mainpiece Title: L'allegro Ed Il Penseroso

Music: A New Medley Overture-Bates; a new Musical Medley by way of Epilogue-

Performances

Mainpiece Title: Bacchus Festival; Or, A New Medley

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: Concert