SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Sauny the Scot"/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 Beggar's Opera

Afterpiece Title: The Dragon of Wantley

Dance: End of mainpiece The Gala, as17820402, but omitted: Dumay, Miss Matthews

Song: End of Act I of mainpiece The Early Horn; End of Act I of afterpiece The Lamentation of Mary Queen of Scots; End of Act II Auld Robin Grey, all three sung by Mrs Kennedy

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Deserter

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Pannel

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: Miss in her Teens

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Minor

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: The Lyar

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: At Hay Mary Queen Of Scots

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: Harlequin Captive

Performances

Mainpiece Title: Mahmoud

Afterpiece Title: A Dramatic Cento

Afterpiece Title: The Sultan

Dance: End I: (by permission of the Proprietor of the king's Theatre) the new favorite Ballet, in the Scots' Stile, Little Peggy's Love- The Pantomime, Principal Steps by Didelot; the Principal Characters the Dancers of the Opera House: Didelot, Gentili, Ms Vidi, Ms Bossi, Ms Barre, Ms Parisot, Ms Hilligsberg, Ms Rose

Song: End 3rd piece: the Finale to The Iron Chest, Harmony Harmony- being the last Composition of Storace

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: Robinson Crusoe