SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Les Avantures de la Foire St"/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: Cymbeline

Afterpiece Title: Cape St

Song: III: a Masquerade Scene-; with Hark! the Lark at Heaven's Gate sings-Sedgwick, Dignum, Welsh, Master Welsh

Ballet: End: The Labyrinth; or, The Country Madcap. Joseph-Gentili; Robert-Grimaldi; Philip-Master Menage; Rosina-Sga Bossi DelCaro; Countess-Mrs Wild; Lauretta-Miss S. DeCamp

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: Cape St

Song: IV: song [as17970206]-Dignum

Performances

Mainpiece Title: La Modista Raggiratrice

Dance: As17970221

Performances

Mainpiece Title: Cape St

Afterpiece Title: Sylvester Daggerwood

Afterpiece Title: The Purse

Afterpiece Title: Lodoiska

Ballet: End 2nd piece: The Labyrinth. As17970306

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Apprentice

Afterpiece Title: Cape St

Performances

Mainpiece Title: Macbeth

Afterpiece Title: My Grandmother

Afterpiece Title: Cape St

Song: In 1st piece: as17961010, but Mrs Bland_

Performances

Mainpiece Title: Know Your Own Mind

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961219

Performances

Mainpiece Title: Othello

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Cape St

Dance: II: Masquerade-; with a Dance, as17970112

Song: Sigh no more Ladies, as17970112, but Miss Leak, Miss +Granger, Master _Welsh, Mrs _Bland

Ballet: End: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Siege Of Belgrade

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17970104

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: Evelina

Dance: End I: Les Delassements Militaires- as17970124; End Opera: L'Heureux Retour- see17970328

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Cape St

Ballet: The Scotch Ghost. As17961221

Performances

Mainpiece Title: The Will

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The Will

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: L'albero Di Diana

Dance: End I: Les Delassements Militaires, as17970124

Ballet: End Opera: Sapho et Phaon. As17970406

Performances

Mainpiece Title: The Mask'd Friend

Afterpiece Title: The Folly of Age; or, The Accomplished Lady

Afterpiece Title: Barataria

Afterpiece Title: Harlequin's Medley

Dance: In 2nd piece: A la Parisot, Le Pas Russe-Delpini

Song: In 2nd piece: La Verginella, My dear Molly@oh! what Folly (composed by Carter)-Delpini

Entertainment: Vaudeville. In 4th piece: The Farm Yard- (from The Rape of Proserpine), with the Birth of Harlequin, and his Emancipation from the Egg Shell; The favorite Scene from Aladin of Pantaloon's Death-, and the Whimsical Lamentation of Pierrot; A Jump through a Hogshead of Fire-; and the celebrated Dying and Skeleton Scenes-

Performances

Mainpiece Title: The Duenna

Dance: End II: Peggy's Love (by permission of the Proprietors of the king's Theatre), as17970614 End Opera: Cupid and Psyche, as17970614 With Corps de Ballet from the Opera House

Performances

Mainpiece Title: Merope

Dance: End I: Les Delassements Militaires-, as17970124; End Opera: Acis et Galatie, as17970617 but _Gentili

Performances

Mainpiece Title: Nina

Dance: End I: Les Delassements Militaires-, as17970124; End Opera: Acis et Galatie, as17970617

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: A Divertisement

Dance: In afterpiece: a Ballet-Blurton, Mrs Watts, Mlle St.Amand

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: England's Glory; or, The Defeat of the Dutch Fleet by the Gallant Admiral Duncan on the Memorable Eleventh of October

Dance: In Scene V 3rd piece: a Triple Hornpipe-Blurton, Mrs Watts, Mlle St.Amand

Performances

Mainpiece Title: The West Indian

Dance: End II: Les Delassemens Militaires-Mrs Wild, Mme Rose, Mme Hilligsberg, Didelot, Fialon; End: Peggy's Love-Mrs Wild, Mme Rose, Mlle DeLaCroix, Mme Hilligsberg, Didelot, Fialon

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: England's Glory

Dance: End II : Les Delassemens Militaires, as17971021; End 2nd piece: Peggy's Love, as17971021