SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Le Mary Retrouve"/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: 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: Every One Has His Fault

Afterpiece Title: The Pad

Afterpiece Title: The Shipwreck or French Ingratitude

Song: End: Captivity (Supposed to be sung by an Unfortunate Queen [Marie Antoinette] during her confinement)-; End 2nd piece: Black Eyed Susan-; In 3rd piece: Farewell to old England dear Mary adieu-Incledon

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Afterpiece Title: The Shipwreck

Song: In 3rd piece: Farewell to old England dear Mary adieu, as17930527

Performances

Mainpiece Title: Columbus

Afterpiece Title: The Pad

Afterpiece Title: The Shipwreck

Song: End of 1st piece: Dibdin's song; The Lucky Escape; or, The Ploughboy's Return from Sea in character-Mrs Harlowe; End of 2nd piece: Sally in our Alley-Marshall; In 3rd piece: Farewell to old England dear Mary adieu-Incledon; Rule Britannia-Marshall, full Chorus; In the course of the Evening: Black eyed Susan-Incledon

Performances

Mainpiece Title: I Zingari In Fiera

Dance: End I: Divertisement, as17941220; End II: a new Ballet by Onorati L'Amant Retrouve-Gentili, Lahante, Aumer, Mlle Rosine, Mme DelCaro, Mme Hilligsberg

Performances

Mainpiece Title: I Zingari In Fiera

Dance: End I: L'Espiegle Soubrette- see17941220; End II: L'Amant Retrouve- see17950120

Performances

Mainpiece Title: La Scola Dei Maritati

Dance: End I: New Divertisement, as17950228; End II: L'Amant Retrouve, as17950124

Performances

Mainpiece Title: Il Conte Ridicolo

Dance: End I: L'Amant Retrouve-, as17950124; End II: Paul et Virginie-, as17950411

Performances

Mainpiece Title: La Scola Dei Maritati

Afterpiece Title: Ati e Cibele

Dance: End I: L'Amant Retrouve, as17950120, but Mme Bossi [DelCaro], Mlle _Rosine [no other ballet listed]

Music: End II: concerto on the hautboy-Harrington

Performances

Mainpiece Title: Semiramide

Dance: End I: Divertisement, as17941220; End II: L'Amant Retrouve, as17950124

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Spoild Child

Afterpiece Title: No Song No Supper

Song: End I: Within a mile of Edinburgh-Dignum; End II: I never lov'd any dear Mary but you (composed by Hook)-Dignum; End I 2nd piece: Sally in our Alley-Dignum; End 2nd piece I that once was a Ploughman a Sailor am now (composed by Dibdin)-Dignum

Performances

Mainpiece Title: Le Nozze Di Dorina

Afterpiece Title: Semiramide Act II only

Dance: End 1st piece: L'Amant Retrouve, as17950124; End 2nd piece: L'Odio vinto dall' Eroismo, as17950613

Music: End I 2nd piece: Preserving the favourite trio-; and with an additional new song here for the occasion by Bianchi-Mme Banti; accompanied by the English horn-Ferlendis; violoncello-Lindley; French Horns-the Leanders; bassoon obligato-Holmes

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: Harlequin Captive

Performances

Mainpiece Title: Mary Queen Of Scots

Afterpiece Title: Robinson Crusoe

Performances

Mainpiece Title: The Child Of Nature

Afterpiece Title: The Critic

Afterpiece Title: The Shipwreck

Song: End II 1st piece: I never lov'd any dear Mary but you-Dignum (composed by Hook); End 1st piece: The Fight off Camperdown-Dignum; End I 2nd piece: The Town and Country-Dignum (composed [i.e. words] by Capt. Morris); End 2nd piece: an Answer to the above, Country and Town-Dignum

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Twins or Is It He or his Brother

Song: By permission of Dibdin End I: Advice; or, Old Mary and John-Bannister Jun; End II: The Country Club-Bannister Jun; III: Tom Tough-Bannister Jun

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Englishman in Paris

Dance: As17831004

Song: End of Act II of mainpiece fifteen Mary's Lamentations; End of mainpiece The Soldier tir'd of War's Alarms, both by Miss George