SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Capriccio Drammatico"/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: Il Conte Ridicolo

Dance: As17950411

Performances

Mainpiece Title: Il Conte Ridicolo

Dance: As17950411

Performances

Mainpiece Title: Alceste; Or, Il Tronfo Dell' Amor Conjugale

Dance: End Opera: Paul et Virginie, as17950411o other ballet listed]

Performances

Mainpiece Title: Il Conte Ridicolo

Dance: End I: L'Amant Retrouve-, as17950124; End II: Paul et Virginie-, as17950411

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'allegro [ed] Il Pensieroso 0; Messiah

Afterpiece Title: L'Allegro Il Pensieroso 3

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 Barbiere Di Siviglia

Dance: As17980313