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: The Siege Of Damascus

Afterpiece Title: The King and the Miller of Mansfield

Dance: I: French Peasants-Master Ferg, Miss Wright; III: Tambourine-Master Ferg, Miss Wright

Song: BBallad of Mary Scot-Mrs Clive

Performances

Mainpiece Title: The Twin Rivals

Afterpiece Title: The Mock Doctor

Dance: II: Drunken Peasant-Philips; IV: French Peasant-Vallois, Miss Scott; V: Ballet-Muilment, Mrs Walter

Song: In III: J'aime la Liberte-Beard; V: Ballad of Mary Scot-Mrs Clive

Performances

Mainpiece Title: The Albion Queens Or The Death Of Mary Queen Of Scotland

Afterpiece Title: The Rape of Proserpine

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Mock Doctor

Dance: II: Punch Dance-Master Ferg, Miss Wright; IV: Pierots-Master Ferg, Miss Wright; V: Turkish Dance-Muilment

Song: I: Advice to the Tatlers (by Desire)-Mrs Clive; III: Mary Scot-Mrs Clive

Music: Select Pieces-

Performances

Mainpiece Title: The Plain Dealer

Dance: After Overture: a new Grand Ballet-Denoyer, others to the Overture of Flavius, composed by Handel; II: Hungarian Dance (in the Manner of the Country,)-Denoyer, Mrs Walter; IV: Russian Sailors-Denoyer; V: Ball Dance, concluding with a Minuet-Denoyer, Mrs Walter

Song: I: Oh Happy Pair-Beard; III: Mary Scot-Mrs Clive

Performances

Mainpiece Title: The Albion Queen Or The Death Of Mary Queen Of Scotland

Afterpiece Title: The Beggars Wedding

Song: II: Oh Happy Pair-Beard; IV: Mary Scot-Mrs Clive

Music: In V: By particular Desire, the Dead March in the last New Oratorio, called Saul and David, by Mr Handel-

Dance: V: Punches Dance-Master Ferg, Miss Wright

Performances

Mainpiece Title: The Albion Queens Or The Death Of Mary Queen Of Scotland

Afterpiece Title: The Mock Doctor

Dance: II: Comic Ballet-Villeneuve, Miss Oates; IV: Faithful Lovers-Desse, Miss Oates; V: Grand Ballet-Glover, the Younger Mlle Roland

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: The Tragedy of Tragedies

Song: I: Mary Scot-Mrs Clive

Dance: II: Muilment; IV: Russian Sailor-Desnoyer; V: Les Characteres de la Dance-Mlle Chateauneuf; Drunken Peasant-Master Ferg

Performances

Mainpiece Title: Amphitryon

Afterpiece Title: The Devil to Pay

Song: I: The Noon Tide Air-Miss Edwards; III: Mary Scot-Mrs Clive

Dance: II: Le Tambourine-Mlle Chateauneuf; IV: Pierots-Lalauze, Liviez; V: Muilment

Performances

Mainpiece Title: King Henry The Fourth Part I

Afterpiece Title: The Devil to Pay

Dance: II: L'Allemande-Muilment, Mlle Chateauneuf; IV: Shepherds and Shepherdesses-Muilment, Mlle Chateauneuf; V: A new Tambourine-Muilment, Mlle Chateauneuf; end Afterpiece: Grand Ballet-Maltere, Mlle Maltere

Song: III: Mary Scot-Mrs Clive

Performances

Mainpiece Title: Albion Queens Or The Death Of Mary Queen Of Scotland

Dance: As17420125, but Chacone=-_

Performances

Mainpiece Title: Albion Queens Or The Death Of Mary Queen Of Scotland

Afterpiece Title: The Mock Doctor

Performances

Mainpiece Title: Julius Caesar

Afterpiece Title: The Devil to Pay

Song: By Desire, Bumper Squire Jones-Beard; Mary Scot-Mrs Clive

Performances

Mainpiece Title: The Albion Queens Or The Death Of Mary Queen Of Scots

Afterpiece Title: The Maid of the Mill or The Country Revels

Afterpiece Title: Judgment of Paris

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: The Oracle

Song: I: Mary Scot (by particular desire)-Beard; III: A Scots Cantata-Beard; IV: Hooly and Fairly-Beard

Dance: CCountry Amusements, as17540416

Performances

Mainpiece Title: The Albion Queens Or The Death Of Mary Queen Of Scots

Afterpiece Title: Perseus and Andromeda

Performances

Mainpiece Title: The Albion Queens Or The Death Of Mary Queen Of Scots

Afterpiece Title: Harlequin Dr Faustus

Performances

Mainpiece Title: The Albion Queens Or The Death Of Mary Queen Of Scots

Afterpiece Title: The Walking Statue or The Devil in the Wine Cellar

Dance: End: The Irish Lilt, as17680930

Performances

Mainpiece Title: The Albion Queens Or The Death Of Mary Queen Of Scots

Afterpiece Title: A Trip to Scotland

Entertainment: Epilogue End: (By Particular Desire) New Occasional Epilogue-Mrs Bulkley

Dance: Minuet-Aldridge, Mrs Bulkley (playbill) Fisher, Mrs Bulkley (Public Advertiser)

Performances

Mainpiece Title: Illumination

Afterpiece Title: The Albion Queens or The Death of Mary Queen of Scots

Afterpiece Title: The Farmers Return from London

Afterpiece Title: Comus

Performances

Mainpiece Title: The Wonder

Afterpiece Title: Comus

Dance: End: The Irish Fair, as17800930

Song: End II: Kate of Aberdeen-; End IV: Bessy Bell, Mary Gray-DuBellamy

Performances

Mainpiece Title: The Beggars 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: The Clandestine Marriage

Afterpiece Title: The Gentle Shepherd

Song: End of Act II of mainpiece Thou hast stole awa' from me, Mary; End of Act IV Kate of Aberdeen, both by Du-Bellamy

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