SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Burbero Di Buon Cuore"/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 Nozze Di Dorina

Afterpiece Title: Semiramide (Act II only)

Dance: As17950522

Music: As17950616

Performances

Mainpiece Title: Semiramide; Or, La Vendetta Di Nino

Dance: Dances-

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso; Grand Selection 0

Afterpiece Title: L'Allegro ed Il Pensieroso 3; Alexander's Feast 3

Music: End Part II: concerto on the harp-Mme Delaval

Performances

Mainpiece Title: Il Tesoro

Dance: As17960607

Ballet: The Caravan at Rest. As17960607

Performances

Mainpiece Title: Il Tesoro

Dance: As17960607

Ballet: The Caravan at Rest. As17960607

Performances

Mainpiece Title: Il Tesoro

Dance: As17960607

Ballet: The Caravan at Rest. As17960607

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: End: Peggy's Love- [see17961206]; End 2nd piece: L'Amour et Psiche- [see17961213]

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: End: Peggy's Love-, as17961220

Ballet: End 2nd piece: L'Amour et Psiche. As17961213, but unassigned-Mlle _Parisot

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: End: a new Divertisement Ballet, composed by Gallet [with music by Viotti] Apollon Berger- [see17970110]

Ballet: End 2nd piece: L'Amour et Psiche. As17961213

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: As17961227

Ballet: L'Amour et Psiche. As17961227

Performances

Mainpiece Title: The 1st Act Of L'amor Fra Le Vendemmie

Afterpiece Title: Il Consiglio Imprudente

Dance: End: a new Divertissement- [see17970110]

Ballet: End 2nd piece: L'Amour et Psiche. As17961213

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: Il Consiglio Imprudente

Afterpiece Title: Le Nozze del Tamigi e Bellona

Dance: End I: Peggy's Love-, as17961220

Ballet: Ballet succeeding to and analogous to the Cantata. Doris-Mme Rose; Nerid-Didelot; Ocean-Gentili; Amphitrite-Mlle Parisot; Thetis-Mme Hilligsberg

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: L'Allegro ed Il Penseroso 3

Music: End I: concerto on the Grand Piano Forte-Miss MacArthur; End II: concerto on the clarionet-John Mahon

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Afterpiece Title: A Grand Selection of Sacred Music 3

Music: End I: concerto on the oboe-W. Parke; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: Acis And Galatea 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: Acis and Galatea 3

Music: End I: Handel's 4th concerto on the organ-J. Ashley; End II: concerto on Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection Of Sacred Music 0; L'allegro Ed Il Penseroso 0; Messiah 0

Afterpiece Title: A Grand Selection of Sacred Music 1

Afterpiece Title: A Grand Selection of Sacred Music 2

Afterpiece Title: A Grand Selection of Sacred Music 3

Music: As17970315

Performances

Mainpiece Title: L'albero Di Diana

Dance: As17970131

Performances

Mainpiece Title: L'albero Di Diana

Dance: As17970211

Performances

Mainpiece Title: L'albero Di Diana

Dance: End I: Apollon Berger, as17961227; End Opera: Le Trompeur Trompe-Mme Rose, Didelot, Mme Hilligsberg, Mlle Parisot, Gentili

Performances

Mainpiece Title: L'arbero Di Diana

Dance: As17961220

Performances

Mainpiece Title: L'albero Di Diana

Dance: As17970131

Performances

Mainpiece Title: L'albero Di Diana

Dance: End I: Les Delassements Militaires, as17970124

Ballet: End Opera: Sapho et Phaon. As17970406

Performances

Mainpiece Title: L'albero Di Diana

Dance: As17970513

Ballet: Sapho et Phaon. As17970513