SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Mercato Del 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: Il Mercato

Performances

Mainpiece Title: Il Mercato

Performances

Mainpiece Title: Il Mercato

Performances

Mainpiece Title: Il Mercato

Performances

Mainpiece Title: Il Mercato

Performances

Mainpiece Title: Il Mercato

Performances

Mainpiece Title: Il Mercato

Performances

Mainpiece Title: Il Mercato

Performances

Mainpiece Title: Il Padre E Il Figlio Rivali

Performances

Mainpiece Title: Il Padre E Il Figlio Rivali

Performances

Mainpiece Title: Il Padre E Il Figlio Rivalli

Performances

Mainpiece Title: L'allegro, Il Penseroso, Il Moderato; Alexander's Feast

Music: As17810307

Performances

Mainpiece Title: L'allegro, Il Penseroso, Il Moderato; Alexander's Feast

Music: As17810302

Performances

Mainpiece Title: L'olimpiade

Dance: End of Act II Il Riposo del Campo, as17830313End of Act III Le Tuteur Trompe, as17830128

Song: New set of Airs, as17830306athi

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: End of Act I Il Riposo del Campo, as17830313End of Act II La Bigueule, as17830313but omitted: Mlle Theodore, Mme Simonet

Performances

Mainpiece Title: Zemira And Azor

Dance: End of Act I Il Riposo del Campo, as17830313but omitted: Slingsby; End of Act II La Bigueule, as17830320athi

Performances

Mainpiece Title: Zemira And Azor

Dance: End of Act I La Begueule, as17830320End of Act II Il Riposo del Campo, as17830322athi

Performances

Mainpiece Title: I Vecchi Burlati

Dance: End of Act I Le Tuteur Trompe, as17830128; End of Act II Il Riposo del Campo, as17830322athi

Performances

Mainpiece Title: Zemira And Azor

Dance: End of Act II New Divertisement, as17821130; End of Act III Il Riposo del Campo, as17830322athi

Performances

Mainpiece Title: I Vecchi Burlati

Dance: End of Act I Le Tuteur Trompe, as17830128; End of Act II Il Riposo del Campo, as17830412, but omitted: Sga Crespi

Performances

Mainpiece Title: Creusa In Delfo

Dance: End of Act I Il Riposo del Campo, as17830424; End of Act II Le Tuteur Trompe, as17830426, but omitted: Slingsby

Performances

Mainpiece Title: I Vecchi Burlati

Dance: End of Act I Il Riposo del Campo, as17830424, but omitted: Mlle Theodore; End of Act II Le Tuteur Trompe, as17830503, but omitted: Mlle Theodore

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: End of Act I Il Riposo del Campo, as17830424; End of Act II La Bigueule, as17830313but omitted: Slingsby, Mme Simonet

Performances

Mainpiece Title: I Vecchi Burlati

Dance: End of Act I Il Riposo del Campo, as17830506; End of Act II La Begueule, as17830510

Performances

Mainpiece Title: La Buona Figliuola

Dance: End of Act I Il Riposo del Campo, as17830313but omitted: Slingsby, Mlle Theodore, La Recrue par Force; End of Act III he Tuteur Trompe, as17830506, with a Pas de Deux by Slingsby and Mme Simonet