SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "LAllegro ed Il Pensieroso 3"/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: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

Afterpiece Title: The Messiah 2

Afterpiece Title: The Messiah 3

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

Music: End Part II: concerto on the violin-Janiewicz

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: As17930220

Music: End Part II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: Il Barbiere Di Siviglia

Dance: As17930216

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Performances

Mainpiece Title: A Grand Selection 0 Of Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: In Part III: Captivity-Mrs Crouch [, as17930220

Music: End Part I: concerto on the violoncello-C. Ashley

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part II: a trio for violin viola and violoncello-G. and R. and C. Ashley

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: End Part I: Sixth concerto of Geminiani on the violin-G. Ashley

Performances

Mainpiece Title: Peeping Tom

Afterpiece Title: The Prize; or, 2, 5, 3, 8

Afterpiece Title: The Village Lawyer

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: Il Capriccio Drammatico

Afterpiece Title: LA BELLA PESCATRICE

Dance: End of 1st piece New Divertisement, as17940311End of 2nd piece L' Union des Bergeres, as17940304but omitted: Mlle Guiardele, Mme Hilligsberg

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: LA BELLA PESCATRICE

Dance: As17940322hroughout