SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "He Woud Be A Soldier"/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 School For Wives

Afterpiece Title: The Poor Soldier

Song: Stand to your Guns my Hearts of Oak-Bannister

Opera: In course Evening: The Tobacco Box; or, The Soldier's Farewell. Thomas-Mrs Martyr; Kate-Mrs Mountain

Performances

Mainpiece Title: Annette And Lubin

Afterpiece Title: The Pharo Table

Afterpiece Title: The Soldier's Festival

Afterpiece Title: Patrick in Prussia i

Performances

Mainpiece Title: The First Part Of King Henry The Fourth

Afterpiece Title: The Poor Soldier

Song: End II: The Lamp Lighter (written and composed by Dibdin)-Reeve; End IV: The Doctrine of an Israelite (written by Collins, author of The Brush) sung in character-Reeve; End: a favorite song a Gentleman (1st appearance on any stage)

Performances

Mainpiece Title: Othello

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Lying Valet

Afterpiece Title: The Poor Soldier

Afterpiece Title: Harlequin's Chaplet

Dance: Preceding: As17891113

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The German Hotel

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: The School For Arrogance

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Lorenzo

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Ild Oats

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: The Soldier's Festival; or, The Night before the Battle

Afterpiece Title: The Intriguing Chambermaid

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: The Soldier's Festival

Afterpiece Title: The Wives Revenged

Performances

Mainpiece Title: National Prejudice

Afterpiece Title: The Poor Soldier

Entertainment: Imitations End II: (for that Night only some) Comic Imitations-Mrs Wells; End: instead of an Epilogue, some Tragic Imitations-Mrs Wells

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: The Soldier's Festival

Afterpiece Title: Rose and Colin

Performances

Mainpiece Title: Fontainbleau

Afterpiece Title: The Poor Soldier

Song: End I: Had I a Heart for Falsehood framed-Marshall in imitation of Leoni; After Monologue: a New Song-Incledon

Entertainment: Monologue. End: A Dissertation on Hobby@Horses, as17910524 but Mr Brandon's Hobby in place of Mrs Mountain's Hobby; The Lawyer's Hobby-Marshall (in the character of a Jockey)

Performances

Mainpiece Title: Double Falsehood; Or, The Distrest Lovers

Afterpiece Title: Tippoo Saib; or, British Valour in India

Afterpiece Title: Barnaby Brittle

Dance: In 2nd piece: Battle Dance-, and a Representation of English and British Grand Martial Procession

Song: I: Hark the Lark at Heaven's Gate sings (set by Dr Cooke)-Bannister, Johnstone, Incledon, Mrs Mountain; End II: Black Eyed Susan-Incledon; IV: Fond Echo Forbear thy fond sigh (written by Shakspeare [recte Lewis Theobald], and composed new for the Evening's Performance by Shield)-Mrs Mountain; In Pantomime: Poor Orra tink on Yanco dear (the music by Dibdin)-Mrs Mountain; The Gallant Soldier born to Arms (composed by Hook)-Incledon; Indian War Song-Bannister; The Tobacco Box: Tho' the Fate of Battle on Tomorrow wait-Johnstone, Mrs Warrell

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: Wild Oats

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Notoriety

Afterpiece Title: The Poor Soldier

Performances

Mainpiece Title: Notoriety

Afterpiece Title: The Prussian Festival

Afterpiece Title: The Poor Soldier