SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "David"/1) | (@(roleclean,performerclean) "David")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 2885 matches on Author, 457 matches on Roles/Actors, 160 matches on Performance Comments, 100 matches on Event Comments, and 40 matches on Performance Title.

Performances

Mainpiece Title: A Grand Selection 0 Of Music, From The Works Of handel

Afterpiece Title: Grand Selection 1

Performance Comment: Overture and March (Scipio)-; Come ever smiling liberty-Miss Capper (Judas Maccabaeus); Lord of eternity-Chorus; Behold the nations-Sale; O Baal-Chorus (Deborah); Mirth admit me-Bartleman; Haste thee nymph-Incledon, Chorus (L'Allegro); My faith and truth-Miss Poole, Master Elliot (Samson); Lord, remember David-Mme Mara (Sosarme); For unto us a child is born-Chorus (The Messiah).
Cast
Role: remember David Actor: Mme Mara

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Music: As17990215

Performances

Mainpiece Title: Grand Selection 0 Of Sacred Music, From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performance Comment: Fourth Oboe concerto-; Awful pleasing being-Miss Tennant (Joshua); Gentle airs-Incledon; accompanied on the violoncello-Charles Ashley (Athalia); Jehovah crowned-Miss Crosby; He comes-Chorus (Esther); Lord remember David-Mrs Dussek (Redemption); God save the King-Chorus (Coronation Anthems).

Music: End II: concerto on the grand piano@forte-Master Neate