SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sga Crespi"/1) | (@(roleclean,performerclean) "Sga Crespi")') 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 903 matches on Performance Comments, 650 matches on Performance Title, 218 matches on Event Comments, 154 matches on Roles/Actors, and 0 matches on Author.

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Quaker

Dance: I: Dance of Spirits, as17791103; III: a Dance of Fantastic Spirits, as17791103; IV: Grand New Dance, as17800228, but Sga _Crespi

Performances

Mainpiece Title: Alfred

Afterpiece Title: Catharine and Petruchio

Performances

Mainpiece Title: Alfred

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: Alfred

Afterpiece Title: A Trip to Scotland

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Mayor of Garratt

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Padlock

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Deuce is in Him

Performances

Mainpiece Title: Alfred

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17730918

Performances

Mainpiece Title: The Fashionable Lover

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Maid Of The Mill

Afterpiece Title: The Genii

Dance: I: The Sailors Revels, as17730928

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Fashionable Lover

Afterpiece Title: The Genii

Dance: II: The Irish Fair, as17730918

Performances

Mainpiece Title: Theodosius

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Genii

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Genii

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Deuce Is in Him

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: Miss in Her Teens

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Citizen

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: Catharine and Petruchio

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: A Trip to Scotland