SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Goliath"/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 True, Famous And Ancient History Of King Saul, And The Witch Of Endor; Containing The Death Of Gyant Goliath, The Friendship Of David And Jonathan, And The Defeat Of King Saul And His Host, By The Philistine Army; With The Comical Humours Of Dame Double-dabber, Weezel Her Son, And Corporal Bowling-pin

Song: Ray, Mrs Bowman

Dance: The best Masters

Performances

Mainpiece Title: Goliath

Music: First Violin, a Concerto-Barthelemon

Performances

Mainpiece Title: Goliath

Music: As17730423

Song: Between I and II: by particular desire an Italian song, composed by Trajetta-Mrs Barthelemon