SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "W B Squire"/1) | (@(roleclean,performerclean) "W B Squire")') 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 1698 matches on Performance Comments, 360 matches on Event Comments, 265 matches on Author, 252 matches on Performance Title, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: A 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

Music: End II: Bach's concertante for violin oboe viola and violoncello-Messrs [G., R. and C.] Ashley, W. Parke

Performances

Mainpiece Title: The Secret

Afterpiece Title: Feudal Times

Performances

Mainpiece Title: Five Thousand A Year

Afterpiece Title: The Old Cloathsman

Afterpiece Title: The Tobacconist

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: I Due Svizzeri

Afterpiece Title: Il Principe Spazzacamino

Dance: End: Le Mariage Mexicain, as18000225; End 2nd piece: Telemaque- [see18000619 and 18000621

Performances

Mainpiece Title: What A Blunder

Afterpiece Title: The Deaf Lover