SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Acis and Galatea 2"/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: King Richard Iii

Afterpiece Title: Love In a Mist

Song: LLove a favourite song from Acis and Galatea-; Between the Acts: Songs-a Gentleman

Music: Solo on a German Flute-a Gentleman

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: The Double Dealer

Afterpiece Title: Acis and Galatea

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Acis and Galatea

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Acis and Galatea

Performances

Mainpiece Title: Acis And Galatea

Music: Organ-Stanley; First Violin-Sig Giardini

Performances

Mainpiece Title: Acis And Galatea

Music: Solo on violoncello-Lonzetti; Italian Song=-Signora Galli; Violin Solo-Hallandall

Performances

Mainpiece Title: Acis And Galatea

Music: To conclude with the Coronation Anthem-

Performances

Mainpiece Title: Acis And Galatea

Afterpiece Title: Charlottenburg Festegiante

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Afterpiece Title: The Coronation Anthem

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Music: First Violin-Brown; Second Violin-Froud; First Violoncello-Gordon; Harpsichord-Cooke; Between I and II: a Concerto on Hautboy-Vincent

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Music: CConcerto on the Harpsichord-Stanley; solo on Violin-Hay

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Performances

Mainpiece Title: Acis And Galatea

Music: As17630218

Performances

Mainpiece Title: Acis And Galatea

Music: Between the acts: Solo on Violincello-Chiri; Concerto on Bassoon-Baumgarten; Concerto on Hautboy-Simpson; Solo on Violin-Hay who will lead the performance; To conclude with the Coronation Anthem-

Performances

Mainpiece Title: Acis And Galatea, Dryden's Ode

Music: Concerto on Organ-Stanley

Performances

Mainpiece Title: Acis And Galatea

Music: CConcerto on Violin-Hay

Dance: To conclude with a Ball-

Performances

Mainpiece Title: Acis And Galatea