SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sga Girelli"/1) | (@(roleclean,performerclean) "Sga Girelli")') 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, 647 matches on Performance Title, 217 matches on Event Comments, 5 matches on Roles/Actors, and 0 matches on Author.
Event Comment: Benefit Jones, Mrs Bland, Mrs Gondou, Miss Ferguson, Miss Morrison (General Advertiser). Benefit Charles Jones, son of the late Jere Jones who formerly kept the Selectation Tavern at Billingsgate (Daily Advertiser)

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: The Devil to Pay

Dance: Cooke, Sga Campioni; also Scotch Dance, as17441012

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: Tragedy of Tragedies

Dance: III: Sga Bettini

Song: I: Gentle Shepherd-Mrs Arne; V: Early Horn-Lowe

Music: IV: Concerto on the Bassoon-; End Farce: Preamble on the Kettle Drums-Woodbridge; concluding with Handel's Water Music-

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Flora

Dance: Cooke, Sga Campioni; Also Scotch Dance, as17450507

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