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: Electra

Afterpiece Title: The Election

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

Afterpiece Title: The Note of Hand

Performances

Mainpiece Title: The Drummer

Afterpiece Title: The Meeting of the Company

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.

Performances

Mainpiece Title: The Gamesters

Afterpiece Title: The Election

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

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Election

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

Afterpiece Title: The Elopement

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Election

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

Afterpiece Title: The Elopement

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

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Election

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

Afterpiece Title: The Elopement

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

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Elopement

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

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Election

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

Afterpiece Title: The Irish Widow

Dance: I: The Irish Fair, as17740917

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Election

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

Afterpiece Title: The Elopement

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

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Election

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

Afterpiece Title: The Deserter

Performances

Mainpiece Title: Isabella

Afterpiece Title: The Election

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

Afterpiece Title: The Elopement

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

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Deserter

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

Dance: III: The Sailors Revels, as17740920

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Genii

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

Dance: III: The Irish Fair, as17740917

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Deserter

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

Performances

Mainpiece Title: The Chances

Afterpiece Title: The Deserter

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

Dance: End: Slingsby, Mad. Hidou

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Genii

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

Dance: II: A New Grand Provencalle Dance-Slingsby, Sga Hidou, with New Dresses, and a view of the Port of Marseilles

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Elopement

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

Performances

Mainpiece Title: The Choleric Man

Afterpiece Title: The Deserter

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

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Deserter

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

Dance: II: The Grand Provencalle Dance, as17741213

Performances

Mainpiece Title: Braganza

Afterpiece Title: The Deserter

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

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Deserter

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

Dance: The Irish Fair, as17740917

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: The Deserter

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

Performances

Mainpiece Title: A Christmas Tale

Afterpiece Title: Lethe

Entertainment: End: New Interlude: Weston's Return from the Universities of Parnassus-Weston

Performances

Mainpiece Title: Measure For Measure

Afterpiece Title: The Deserter

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

Dance: The Sailors Revels, as17740920

Monologue: End of Play: Henry and Emma. Henry-Brereton; Eugenius-Palmer; Venus-Mrs Smith; Emma-Mrs Baddeley

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Deserter

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

Dance: V: The Pirates, as17750422