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

Music: As17660214

Performances

Mainpiece Title: The Messiah

Music: As17660226

Performances

Mainpiece Title: The Messiah

Music: As17670306

Performances

Mainpiece Title: The Messiah

Music: As17670306

Performances

Mainpiece Title: The Messiah

Music: Instrumental parts-Hay, the most capital performers; with a solo on the violin-Hay

Performances

Mainpiece Title: The Messiah

Music: VViolin Solo-Barthelemon; Concerto on Hautboy-Simpson

Performances

Mainpiece Title: The Messiah

Music: As17680309

Performances

Mainpiece Title: The Messiah

Performances

Mainpiece Title: The Messiah

Music: As17680309

Performances

Mainpiece Title: The Messiah

Performances

Mainpiece Title: The Messiah

Music: As17680318

Performances

Mainpiece Title: The Messiah

Music: Between the acts: a Concerto on the Hautboy-Fisher; solo on the Violin-Pinto

Performances

Mainpiece Title: The Messiah

Music: As17690215

Performances

Mainpiece Title: The Messiah

Music: As17690215

Performances

Mainpiece Title: The Messiah

Music: CConcerto on Violin-Giardini; Concerto on Hautboy-Simson

Performances

Mainpiece Title: The Messiah

Music: CConcerto on Hautboy-Fischer

Performances

Mainpiece Title: The Messiah

Music: Serenata Geminiane, Third Opera,-Sg Paganini

Performances

Mainpiece Title: The Messiah

Music: As17690310

Performances

Mainpiece Title: The Messiah

Music: FFirst Violin, a Solo-Giardini; Concerto on French Horns-Sg Rodolpho

Performances

Mainpiece Title: The Messiah

Music: As17700307

Performances

Mainpiece Title: The Messiah

Music: As17700321 Concerto on the Hautboy-Fischer

Performances

Mainpiece Title: The Messiah

Music: As17700328

Performances

Mainpiece Title: The Messiah

Music: CConcerto on Hautboy-Fischer; Solo on Violincello-Duport

Performances

Mainpiece Title: The Messiah

Music: Violin Solo-Sga Lombardini Sirmen; Concerto on German Flute-Florio

Performances

Mainpiece Title: The Messiah