SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Messiah"/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: The Messiah; Grand Selection 0

Afterpiece Title: Messiah 1

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

Performances

Mainpiece Title: The Messiah; A Grand Selection 0

Music: As17990215

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Music: End II: duet on the harp and grand piano forte-Mrs Dussek, Cimadoro

Performances

Mainpiece Title: Alexander's Feast 0; The Messiah; Grand Selection 0

Afterpiece Title: Alexander's Feast 3

Music: End II: a concertante for violin oboe tenor and violoncello-G. Ashley, W. Parke, R. Ashley, C. Ashley

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Music: End II: concerto on the pedal harp-Mrs Dussek

Performances

Mainpiece Title: The Creation; The Messiah; Grand Selection 0