SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Trionfo di Camilla"/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 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

Performances

Mainpiece Title: L'allegro [ed] Il Pensieroso 0; Messiah

Afterpiece Title: L'Allegro Il Pensieroso 3

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: Il Consiglio Imprudente

Dance: As17980331

Performances

Mainpiece Title: Il Consiglio Imprudente

Afterpiece Title: Il Capriccio Drammatico

Dance: As17980313

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: End I: A New Divertisement, as17980419; End Opera: La Vengeance de l'Amour-; Pas de Quatre de Panurge-

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: As17980306

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: End I: Peggy's Love, as17980426; End Opera: La Vengeance de l'Amour, as17980421

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Dance: End 1st piece: Peggy's Love, as17980428; End 2nd piece: La Vengeance de l'Amour, as17980324

Performances

Mainpiece Title: An Act Of Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Dance: End: Les Rivaux Genereux, as17980306End 2nd piece: Elisa- [see17980510]

Performances

Mainpiece Title: Il Matrimonio Segreto

Afterpiece Title: Il Capriccio Drammatico

Dance: As17980501