SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Les Trois Freres Riveaux et Pierot Chantera"/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: Le Traitant De France

Afterpiece Title: Les Trois Freres Riveaux et Pierot Chantera

Performances

Mainpiece Title: Rhadamisthe

Afterpiece Title: Les Trois Freres Riveaux

Performances

Mainpiece Title: Arlequin Hulla

Afterpiece Title: Les Trois Freres Riveaux

Music:

Dance:

Performances

Mainpiece Title: The Busy Body

Song: I: New Ballad-Lowe; III: The Early Horn-Lowe

Dance: II: Les Matelotes, as17411208 but-the Fausans; V: Les Masons et Les Sabotiers-Fausan, Signora Fausan, LeCroix, Delemain, Dumont, Constantini, Mrs Walter, Mrs Thompson, Mrs Rayner, Miss Wright

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Cheats of Scapin

Dance: I: Hornpipe-LeCointe; II: New Dance call'd Les Paisans Iriquois-M Bienfait, Lucas; III: Minuet-Guerin, Mrs Rowland, a girl 7 years old, a scholar of Mlle Capdeville; IV: Pas de Trois, call'd Les Paisans Allemandes-Guerin, Bienfait, Lucas; V: A New Dance call'd Les Savetiers-Guerin, Bienfait, Mrs Rowland

Performances

Mainpiece Title: The Merchant Of Venice

Dance: I: A new dance-Muilment; II: La Tambourine-Mlle Chateauneuf; II: Les Masons & Les Sabotiers-Fausan, Signora Fausan, Muilment, Mlle Chateauneuf; IV: La Provencale-Mlle Chateauneuf; V: Les Jardiniers Suedois, as17410302

Performances

Mainpiece Title: Love For Love

Dance: Comic Ballet, call'd% Les Masons et Les Sabotiers-Sg and Sga Fausan, Dumont, Desse, Boudouin, Mrs Walter, Mrs Thompson, Mrs Rayner, Leviez; Le Genereux Corsaire, as17411021

Performances

Mainpiece Title: The Merchant Of Venice

Dance: V: Les Masons et Les Sabotiers-the two Fausans only, but see17411027

Performances

Mainpiece Title: Love For Love

Dance: I: Les Masons et Les Sabotiers, as17411103; V: Le Genereux Corsaire, as17411102

Song: III: a Duet-Beard, Lowe

Performances

Mainpiece Title: The Merchant Of Venice

Dance: I: Les Masons et Les Sabotiers, as17411103; V: Le Genereux Corsaire, as17411102

Performances

Mainpiece Title: The Provoked Wife

Dance: LLe Boufon, as17411030; Les Masons et Les Sabotiers, as17411103, but Desse

Performances

Mainpiece Title: The Rehearsal

Dance: LLe Boufon, as17411030; Les Masons et Les Sabotiers, as17411120

Performances

Mainpiece Title: Comus

Dance: LLe Boufon, as17411030; Les Masons et Les Sabotiers, as17411218

Performances

Mainpiece Title: The Miser

Song: I: See from the Silent Groves-Beard; III: Ballad-Lowe

Dance: II: Le Boufon, as17411030; V: Les Masons et Les Sabotiers, as17411218

Performances

Mainpiece Title: The Tender Husband

Song: I: Was Ever Nymph like Rosamond-Beard; IV: Bright Author of my Present Flame-Lowe

Dance: II : Les Masons et Les Sabotiers, as17411218; V: Le Genereux Corsaire, as17420120

Performances

Mainpiece Title: Artaserse

Dance: End I: new Ballet, Les Oiseleurs-Sg Zuchelli, Sga Zuchelli, Mlle Vidini, LeDet; End II: Les Moissonneurs, as17781229; End: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: Artaserse

Dance: End I: Les Oiseleurs, as17790123, but Sga _Zuchelli, Sga Tinti; End II: +Les Moissonneurs, as17781229; End Opera: Les Nymphes de Diane, as17781124

Performances

Mainpiece Title: I Giuochi D'agrigento

Dance: End: Les Epoux du Tempe, as17930205; End Opera: Divertisement, as17930126; but to conclude with a Pas de Trois et de Quatre-to the favourite air of God save the King, with variations

Performances

Mainpiece Title: Piramo E Tisbe

Dance: End I: Le Bouquet (performed for the first time on Tuesday last) in which a Pas Deux, a Pas Trois by Didelot-Didelot, Mme Hilligsberg, Mme Rose; End Opera: Les Trois Sultanes, as17960301

Performances

Mainpiece Title: Pierot Maitre Valet Et L'opera De Campagne; Ou, La Critique De L'opera De Paris

Entertainment: Vaulting, Tumbling-

Performances

Mainpiece Title: Pierot Maitre Valet Et L'opera De Campagne

Entertainment: Vaulting, Tumbling-

Performances

Mainpiece Title: L S Bains De La Porte St

Afterpiece Title: Les Adieux D'Arlequin, Pierrot et Colombine

Dance: As17200531

Performances

Mainpiece Title: Les Deux Arlequin & Les Enchantemens D'arlequin & D'arlequine Danse Comique

Afterpiece Title: La Baron de la Grasse

Afterpiece Title: The Hat

Dance:

Performances

Mainpiece Title: Les Menechmes; Ou, Les Jumeau,

Afterpiece Title: Crispin Rival De Son Maitre

Dance:

Performances

Mainpiece Title: Les Menechmes; Ou, Les Freves Jumeaux

Afterpiece Title: Les Vacances

Dance: