SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Mercato di Malmantile"/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: L'allegro Ed Il Penseroso; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: PART III

Performances

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

Afterpiece Title: Allegro ed il Penseroso 1 PART I

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End II: concerto on the violin-Weichsel

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17910330

Performances

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

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Afterpiece Title: L'Alegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: The Coronation Anthem

Afterpiece Title: The Messiah; L'Allegro ed il Pensieroso 0

Performances

Mainpiece Title: The First Grand Selection 0 Of Sacred Music From The Works Of handel; L'allegro Ed Il Pensieroso 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Alexander's Feast 0; Redemption 0; L'allegro Ed Il Pensieroso 0

Afterpiece Title: Alexander's Feast 1

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

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

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Afterpiece Title: L'Allegro ed il Pensieroso 1

Afterpiece Title: L'Allegro ed il Pensieroso 2

Afterpiece Title: Grand Miscellaneous Act

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Music: As17930220

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: End I: Les Epoux du Tempe, as17930126

Ballet: End Opera: an entire new Heroic Pantomime Ballet Venus and Adonis (composed by Noverre). Cupid-Nivelon; Adonis-Favre Gardel; Mercury-Gentili; Jupiter-D'Egville; Hebe-Mlle Hilligsberg; The Graces-Mlle Bourgeois, Mlle Vedie, Mlle Droma; Venus-Mlle Millerd; Nymphs, Chasseurs-the Corps de Ballet

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: As17930226

Ballet: Venus and Adonis. As17930226

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: End I: Divertisement, as17930216

Ballet: End Opera: Venus and Adonis. As17930226

Performances

Mainpiece Title: L'allegro Ed Il Penseroso [, Part I Only]; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Song: In 1st piece: Sweet bird-Mrs Ferguson (her 1st performance); accompanied on the violin-Shaw; End 2nd piece: an Italian Scena-Mrs Ferguson

Performances

Mainpiece Title: L'allegro Ed Il Penseroso , Part I; Grand Selection 0

Afterpiece Title: Acis and Galatea

Afterpiece Title: A New Grand Selection

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: As17930305

Ballet: Venus and Adonis. As17930305

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: As17930305

Ballet: Venus and Adonis. As17930305

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: As17930305

Ballet: Venus and Adonis. As17930305

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: End I: Le Faune Infidele, as17930406, but Gentili

Ballet: End Opera: Venus and Adonis. As17930226

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: End I: Les Epoux du Tempe- [See17930205]

Ballet: End Opera: the Grand Historical Ballet in 4 Parts, which has been so long in preparation, Iphiginia in Aulide; or, The Sacrifice of Iphiginia composed by Noverre. Iphiginia-Mlle Hilligsberg; Clytemnestra-Mlle Millerd; Agamemnon-D'Egville; Achilles-Nivelon; Egisthus-Favre Gardel; Young Orestes-Mlle Menage; Lesbian-Gentili; Warriors, Lesbian Slaves, High Priests, Priests, Priestesses-the Corps de Ballet

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: End I: Le Faune Infidele, as17930420

Ballet: End Opera: Iphiginia in Aulide. As17930423

Performances

Mainpiece Title: Le Nozze Di Dorina

Dance: End I: Divertisement- [See17930126]

Ballet: End Opera: Iphiginia in Aulide. As17930423

Performances

Mainpiece Title: Le Nozze Di Dorina And I Zingari In Fiera

Dance: As17930622

Ballet: Iphiginia in Aulide. As17930622