SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Il Trionfo Della Costazza"/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 Trionfo Della Costazza

Music: After I: Solo on Hautboy-Fischer; End Opera: Solo on Violincello-Crosdell, to conclude with a Grand Overture

Performances

Mainpiece Title: Il Trionfo Del Tempo E Della Verita

Music: WithConcertos on the Organ-and other Instruments

Performances

Mainpiece Title: Il Trionfo Del Tempo E Della Verita

Music: As17370323

Performances

Mainpiece Title: Il Trionfo Del Tempo E Della Verita

Music: As17370323

Performances

Mainpiece Title: Il Trionfo Del Tempo E Della Verita

Music: As17370323

Performances

Mainpiece Title: Il Trionfo Del Tempo & Della Verita

Music: With several Concertos on the Organ-; other Instruments-

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Continenza

Performances

Mainpiece Title: Il Trionfo Della Gloria

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: End of Act I New Divertisement, as17821102, but Sga Crespi in place of Sga Sala; added: Pas de Deux, as17821210 End of Act II Apelles and Campaspe, as17821102

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: As17821219 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: End of Act I Apelles and Campaspe, as17821102; End of Opera New Divertisement, as17821102, with Passacaille, as17821109

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: End of Act I New Divertisement, as17821102, but Sga Crespi in place of Sga Sala; End of Opera Il Ratio delle Sabine, as17821212

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: As17821212 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: As17830111 throughout

Performances

Mainpiece Title: Il Trionfo Della Costanza

Dance: As17830116 throughout