SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Marchese Tulipano"/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 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: Il Barbiere Di Siviglia

Dance: End I: a new Divertisement (composed by Noverre)-Mlle Millerd (from the Grand Opera in Paris; 1st appearance in this country), Mlle Hilligsberg, Favre Gardel, Nivelon; End Opera: Les Caractres de la Danse-; a new divertisement (composed by Noverre), Les Epoux du Tempe-Mlle Hilligsberg, Mlle Millerd, Nivelon, Favre Gardel

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Dance: As17930126

Performances

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

Afterpiece Title: A Grand Miscellaneous Act

Music: As17930220

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Dance: As17930216

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: Il Matrimonio Segreto

Dance: End of Act I a new Divertisement, composed by Noverre [performers not listed]; End of Act II a new Pantomimic Ballet, composed by Noverre, Adelaide; ou, La Bergere des Alpes, by Aumer, Gentili, Mme Del Caro, Mlle Hilligsberg, Mme M. L. Hilligsberg Sen

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: As17940111 throughout

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: End of Act I Divertisement, as17940111; End of Act II Adelaide [performers not listed, but see17940111]

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: As17940118 throughout

Performances

Mainpiece Title: Il Matrimonio Segreto

Dance: As17940118 throughout

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: DON GIOVANNI

Dance: End of 1st piece a new Ballet, composed by Noverre, L' Union des Bergeres [performers not listed, but see17940304 In 2nd piece Dances connected with the opera, composed by Noverre, by Aumer, Lahante, Gentili, Favre Guiardele, Mlle Hilligsberg, Mme Del Caro, Mlle Guiardele, Mme Hilligsberg

Opera: [It was sung by Pasquariello.]

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: DON GIOVANNI

Dance: As17940301hroughout, but omitted: Lahante, Mlle Guiardele

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: LA BELLA PESCATRICE

Dance: As17940311hroughout

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Music: As17940319athi