SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "THE GLORIOUS FIRST OF JUNE"/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: Inkle And Yarico

Afterpiece Title: The Follies of a Day

Dance: As17910428

Song: End: Catches and Glees: When Arthur first in court began, Jack thou'rt a toper-Incledon, Reeve, Blanchard; To be jovial and gay-Johnstone; The Siege of Troy (Dibdin)-Johnstone; Goody Groaner (Dr Harington)-Incledon, Reeve, Blanchard; Sir you're a comical fellow-; Let's sing old Rose and burn the Bellows-

Performances

Mainpiece Title: Thomas And Sally

Afterpiece Title: Wild Oats

Afterpiece Title: Tippoo Saib

Song: 3rd piece: as in 2nd piece, 6 June Poor Orra tink on Yanco dear, as17910606 The Gallant Soldier born to Arms, as17910606 Indian War Song, as17910606 The Tobacco Box, as17910606

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Hob in the Well

Afterpiece Title: Tippoo Saib

Song: End II: Black Eyed Susan-Incledon; In 3rd piece: as in 2nd piece, 6 June Poor Orra tink on Yanco dear, as17910606 The Gallant Soldier born to Arms, as17910606 Indian War Song, as17910606 The Tobacco Box, as17910606

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Wives Revenged

Afterpiece Title: Tippoo Saib

Song: End II: Stand to your Guns-Bannister; In 3rd piece: as in 2nd piece, 6 June Poor Orra tink on Yanco dear-Mrs Mountain; The Gallant Soldier born to Arms-Incledon

Performances

Mainpiece Title: The Woodman

Afterpiece Title: Tippoo Saib

Afterpiece Title: Two Strings to Your Bow

Song: In 2nd Piece:as in 3rd piece, 10 June Poor Orra tink on Yanco dear-Mrs Mountain; The Gallant Soldier born to Arms-Incledon

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Prussian Festival

Afterpiece Title: The First Part of King Henry the Fourth

Afterpiece Title: Oscar and Malvina

Music: As17911122

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The First Floor

Song: Vocal Parts, as17911125, but Cooke; The Masque of Neptune and Amphitrite, as17911125

Performances

Mainpiece Title: Cymon

Afterpiece Title: The First Floor

Performances

Mainpiece Title: Cymon

Afterpiece Title: The First Floor

Performances

Mainpiece Title: Cymon

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The First Grand Selection 0 Of Sacred Music From The Works Of handel; L'allegro Ed Il Pensieroso 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Winter's Tale

Afterpiece Title: The Irishman in London

Afterpiece Title: The Golden Pippin

Song: In 2nd piece: As17920421; End II: a Selection of the most favourite Catches and Glees from Harrison and Knyvett's Vocal Concert-; O let the merry peal go on-(Danby); When Arthur first in Court began-(Callcott); Tweedside What beauties does Flora-(Corfe); Come let us all a Maying go-(Hilton)

Performances

Mainpiece Title: Cymon

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Heiress

Afterpiece Title: The First Floor

Performances

Mainpiece Title: At King's The Pirates

Afterpiece Title: The First Floor

Performances

Mainpiece Title: At King's Cymon

Afterpiece Title: The First Floor

Performances

Mainpiece Title: At King's The Siege Of Belgrade

Afterpiece Title: The First Floor

Performances

Mainpiece Title: Piety In Pattens

Afterpiece Title: The London Hermit; or, Rambles in Dorsetshire

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Mountaineers

Afterpiece Title: THE FIRST FLOOR