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: Antigona

Dance: End I: Little Peggy's Love, as17960421; in which the Pas de Trois as danced at the conclusion of L'Heureux Naufrage-Didelot, Mme Hilligsberg, Mme Rose; End Opera: Flore et Zephire, as17960709

Performances

Mainpiece Title: Zemira E Azor

Dance: With Dances incidental to the Opera-Didelot, Mlle Parisot, Mme Hilligsberg, Mme Rose; End Opera: Little Peggy's Love, as17960716 Pas de Trois-

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: Richard Coeur de Lion

Dance: III afterpiece: Dance-Master and Miss Menage

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: A Trip To Scarborough

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Song: As17960927

Performances

Mainpiece Title: The Rivals

Afterpiece Title: Richard Coeur de Lion

Dance: III afterpiece: Dance, as17961019

Ballet: End: The Scotch Ghost. As17961029, but The Lady of Dunblain-_; Villagers-_

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Richard Coeur de Lion

Dance: In III afterpiece: Dance, as17961019

Ballet: End: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: The Child of Nature

Afterpiece Title: The Apprentice

Dance: III 1st piece: Dance, as17961019

Ballet: End 2nd piece: The Scotch Ghost. As17961112

Performances

Mainpiece Title: The Force Of Ridicule

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: Who's the Dupe

Afterpiece Title: Robinson Crusoe

Ballet: End: The Scotch Ghost. As17961221

Performances

Mainpiece Title: La Modista Raggiratrice

Dance: End I: Divertissement-, as17970103; End Opera: Flore et Zephire, as17961126

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Richard Coeur de Lion

Dance: As17961019

Performances

Mainpiece Title: The Chances

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: Evelina

Dance: End I: Les Delassements Militaires-Mme Rose, Didelot, Mme Hilligsberg, Mlle Parisot, Marcadet (1st appearance)

Ballet: End Opera: L'Amour et Psiche. As17961213, but Tisiphone (1st time)-Marcadet

Performances

Mainpiece Title: Evelina

Dance: End I: Les Delassements Militaires- [see17970117]; End Opera: L'Amour et Psiche, as17961220

Performances

Mainpiece Title: Theodosius

Afterpiece Title: Richard Coeur de Lion

Song: As17970120

Performances

Mainpiece Title: Evelina

Dance: End I: Les Delassements Militaires, as17970124; End Opera: Apollon Berger, as17961227

Performances

Mainpiece Title: The 1st Act Of La Modista Raggiratrice

Afterpiece Title: Il Consiglio Imprudente

Dance: End 1st piece: Les Delassements Militaires- As17970124

Ballet: End 2nd piece: Pizarre; ou, La Conquete du Perou (1st time; composed by Gallet [with music by Mazzinghi]). Pizarre-Gallet; the other characters-Mme Rose, Didelot, Mme Hilligsberg, Mlle Parisot, Marcadet, Gentili

Performances

Mainpiece Title: The 1st Act Of La Modista Raggiratrice

Afterpiece Title: Il Consiglio Imprudente

Dance: End 1st piece: Les Delassements Militaires- as17970124; End 2nd piece: Pizarre [see17970207]-

Performances

Mainpiece Title: La Modista Raggiratrice

Dance: End I: Peggy's Love, as17961220; End Opera: Pizarre, as17970211

Performances

Mainpiece Title: Alceste

Dance: Dances Incidental, as17970225; End Opera: Apollon Berger, as17961227

Song: Between I and II: upon the Present happy Occasion [the naval victory off Cape St. Vincent, 14 Feb. 1797,] God save the King, Rule Britannia-Mme Banti