SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Joshua; Acis And Galatea"/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: Merope

Dance: End I: Peggy's Love-, as17961220; End Opera: Acis et Galatie-, as17970615

Performances

Mainpiece Title: Nina

Dance: End I: Acis et Galatie, as17970615 End Opera: Pizarre, as17970211

Performances

Mainpiece Title: Merope

Dance: End I: Les Delassements Militaires-, as17970124; End Opera: Acis et Galatie, as17970617 but _Gentili

Performances

Mainpiece Title: Nina

Dance: End I: Les Delassements Militaires-, as17970124; End Opera: Acis et Galatie, as17970617

Performances

Mainpiece Title: Merope

Dance: End I: Peggy's Love, as17961220; End Opera: Acis et Galatie, as17970617