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

Performances

Mainpiece Title: The Beggar's Opera

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Orpheus and Eurydice

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: The Virgin Unmask'd

Song: Beard

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Man Of Mode; Or, Sir Fopling Flutter

Dance: Cooke, Sga Campioni, Sodi (being the first time of his appearing on that stage)

Performances

Mainpiece Title: Sir Courtly Nice

Afterpiece Title: Pyramus and Thisbe

Song: TThe Flocks shall leave the Mountains, as17460125; Occasional Ballad, Over the Hills and Far away-Beard

Dance: Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: Papal Tyranny In The Reign Of King John

Afterpiece Title: The Royal Chace

Dance: Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: The Beggar's Opera

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Man Of Mode

Afterpiece Title: The Mock Doctor

Dance: Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: The Confederacy

Afterpiece Title: Duke and No Duke

Dance: Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: The Silent Woman

Afterpiece Title: Pyramus and Thisbe

Dance: Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: Phebe; or, The Beggar's Wedding

Dance: A Peasant-Cooke; Grand Comic Ballet-Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: The Relapse

Afterpiece Title: Phebe

Dance: Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: Henry V

Afterpiece Title: Phebe

Dance: DDrunken Tyrolese-Sodi; New Comic Ballet (never performed) call'd The Italian Peasants-Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Phebe

Song: III: Song of Diana, as17460313 IV: (By Particular Desire,)A French Song-Beard

Dance: II: Peasant-Cooke; V:(By Desire,) Minuet-Cooke, Sga Campioni

Performances

Mainpiece Title: She Wou'd And She Wou'd Not

Afterpiece Title: The Lying Valet

Dance: PPeasant-Cooke; Comic Ballet-Cooke, Sga Campioni

Song: SSong of Diana, as17460313 Genius of England-Beard

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Orpheus and Eurydice

Dance: DDrunken Tyrolese-Sodi; also Comic Ballet call'd the Bird Catchers-Cooke, Sga Campioni, Sodi

Performances

Mainpiece Title: Lady's Last Stake

Afterpiece Title: Phebe

Dance: I: New Grand Ballet-Cooke; II: Drunken Tyrolese-Cooke; V: Louvre, Minuet-Cooke, Sga Campioni

Performances

Mainpiece Title: Sir Courtly Nice

Afterpiece Title: Duke and no Duke

Song: In III: The Flocks shall leave the Mountains, as17460125

Dance: III: Peasant-Cooke; V: Comic Ballet-Cooke, Sga Campioni

Performances

Mainpiece Title: Cymbeline, King Of Britain

Afterpiece Title: The Royal Chace

Dance: BBird Catchers-Cooke, Sga Campioni

Performances

Mainpiece Title: The Beggar's Opera

Dance: DDrunken Tyrolese-Sodi; New Ballet never performed before, call'd The Flemish Peasant's Wedding-Sodi, Sga Campioni; Pigmalion, as17460409

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: Jealous Husband Deceiv'd

Dance: MMinuet(by Desire)-Lalauze, Sga Campioni; Pigmalion, as17460409

Song: GGenius of England-Beard

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Rape of Proserpine

Dance: LLouvre, Minuet-Villeneuve, Sga Campioni

Performances

Mainpiece Title: King Henry V

Afterpiece Title: The Lying Valet

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: Sir Courtly Nice

Afterpiece Title: Orpheus and Eurydice

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The True And Ancient History Of King Lear And His Three Daughters

Dance: Cooke, Sga Campioni