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: A Christmas Tale

Afterpiece Title: The Register Office

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17730918

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Deuce Is in Him

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: Neck or Nothing

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Genii

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Guardian

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Genii

Dance: III: The Sailors Revels, as17730928

Performances

Mainpiece Title: The West Indian

Afterpiece Title: The Genii

Performances

Mainpiece Title: King John

Afterpiece Title: The Genii

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Male Coquette

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: The Genii

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: Neck or Nothing

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: The Genii

Performances

Mainpiece Title: The School For Wives

Afterpiece Title: The Genii

Performances

Mainpiece Title: The Maid Of Kent

Afterpiece Title: Florizel and Perdita

Dance: End: The Taylors, as17740428

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: The Genii

Song: End Act III: Ode to Masonry-Vernon, Dodd, Bannister

Entertainment: Imitations-Bannister (last time this season)

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Genii

Cast
Role: Dancing Actor: Como, Atkins, Giorgi, Sga Crespi.

Dance: III: The Sailors Revels, as17740920

Performances

Mainpiece Title: As You Like It

Afterpiece Title: The Election

Afterpiece Title: The Genii

Cast
Role: Dancing Actor: Como, Atkins, Giorgi, Sga Crespi.

Dance: Giorgi's Scholars

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Election

Cast
Role: Dancing Actor: Como, Atkins, Giorgi, Sga Crespi.

Afterpiece Title: The Genii

Cast
Role: Dancing Actor: Como, Atkins, Giorgi, Sga Crespi.