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 Maid Of The Oaks

Afterpiece Title: The Elopement

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

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Deserter

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

Dance: II: The Pirates, as17750422

Performances

Mainpiece Title: The Tempest

Afterpiece Title: Catharine and Petruchio

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Sultan

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Jubilee

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Spanish Lady

Performances

Mainpiece Title: The Maid Of The Oaks

Afterpiece Title: The Waterman

Song: V: (By Desire) The Soldier Tir'd-Miss Abrams

Performances

Mainpiece Title: The Tempest

Afterpiece Title: The Camp

Dance: Grand Dance, as17781102

Performances

Mainpiece Title: Cymon

Afterpiece Title: The Irish Widow

Dance: I: a Dance of Cupids-; IV: [a Dance of Daemons-; V: Grand Dance [Grand Ballet [sic], as17781102; End I afterpiece: Minuet de la Cour, as17780919; [and Allemande, as17780919

Performances

Mainpiece Title: Cymon

Afterpiece Title: A Peep behind the Curtain

Dance: Dance of Cupids, as17781223; Dance of Daemons, as17781223

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Comus

Dance: In: Grand Dance, as17781102, but _Henry, Grimaldi, Master +Mills, Miss +Grimaldi

Song: As17790413

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800422, but Miss _Andreas; End II: Il Filosofo, as17800509; End Opera: Grand Serious Ballet, as17791127, but _Slingsby, Mme Simonet; with a +Grand Chaconne, as17800422

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800512; End II: La Fete Pastorale, as17800422, but Slingsby; Pas Seul, as17800422; accompanied on the guitar-Noferi; End Opera: +Serious Ballet, as17800422, but Slingsby; +Grand Chaconne, as17800422

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Performances

Mainpiece Title: Rinaldo

Cast
Role: Zelmira Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800527; End II: La Fete Pastorale, as17800520; End Opera: Serious Ballet, as17800527; Grand Chaconne, as17800527; To conclude with: New Allemande-

Performances

Mainpiece Title: Quinto Fabio

Cast
Role: Fausta Actor: Sga Pozzi

Dance: End I: The Rural Sports, as17800527; End II: Il Filosofo, as17800509; To conclude with: New Allemande-; End Opera: New Serious Ballet, as17800516

Song: As 22 Jan

Performances

Mainpiece Title: Mitridate

Cast
Role: Irene Actor: Sga Prudom

Dance: As17810123

Performances

Mainpiece Title: Mitridate

Cast
Role: Irene Actor: Sga Prudom

Dance: As17810123