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

Performances

Mainpiece Title: The Distrest Mother

Dance: TTambourine-Cooke; Characters of Dancing, as17421025; Les Savoyards-Villeneuve, Sga Domitilla; La Provencale, as17421105

Performances

Mainpiece Title: The Stratagem

Dance: II: a New Comic Dance call'd Neopolitan Punch-Checo Torinese, Sga Chiaretta Aquilanti, Boromeo, Mlle Bonneval; IV: A New Comic Dance call'd Italian Gardeners-Checo, Chiaretta

Performances

Mainpiece Title: The Beggar's Opera

Dance: I: Neopolitan Punch-Chico, Sga Chiaretta, Mlle Bonneval; II: Italian Gardeners, as17421231

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Italian Gardeners, as17421231; III: a New Serious Dance-Sga Aquilanti; V: A New Sicilian Peasant-Checo, Chiaretta

Performances

Mainpiece Title: The Revenge

Afterpiece Title: The Virgin Unmask'd

Dance: Entertainments-Cooke, Lalauze, Sga Campioni (being her 1st appearance on that stage)

Performances

Mainpiece Title: The Gamester

Afterpiece Title: The Anatomist

Song: I, III: Lowe

Dance: II: A Grand Comic Dance-Leonardi, Sga Bettini; IV: Grand Dance-Muilment

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Devil to Pay

Dance: III: Leonardi, Sga Bettini; IV: Grand Dance, as17441217

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Mock Doctor

Song: I, IV: Lowe

Dance: V: Grand Dance-Sga Bettini

Performances

Mainpiece Title: Richard Iii

Afterpiece Title: The Devil to Pay

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Distressed Mother

Afterpiece Title: The Mock Doctor

Dance: III: Grand Dance, as17441217; V: Sga Bettini

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Temple of Dulness

Cast
Role: Sga Dorinna Actor: Mrs Arne

Dance: II: Muilment; IV: Sga Bettini

Performances

Mainpiece Title: The Committee

Afterpiece Title: Temple of Dulness

Cast
Role: Sga Dorinna Actor: Mrs Arne

Dance: II: Serious Dance-Sga Bettini; IV: Grand Dance, as17441217

Performances

Mainpiece Title: Volpone; Or, The Fox

Afterpiece Title: Pyramus and Thisbe

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: Rosamond

Dance: II: Sga Bettini; III: Shepherd's Dance-Muilment

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Mock Doctor

Song: II: Lowe

Dance: III: Grand Dance-Muilment; V: Comic Dance-Sga Bettini

Performances

Mainpiece Title: Mariamne

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Gamester

Afterpiece Title: Rosamond

Dance: III: Muilment; IV: Sga Bettini

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Anatomist

Song: II: Lowe

Dance: III: Muilment; V: Sga Bettini

Performances

Mainpiece Title: The Lady's Last Stake; Or, The Wife's Resentment

Afterpiece Title: The Devil to Pay

Song: II: Wanton Breezes, from the Oratorio Love and Friendship-Miss Edwards; IV: (by particular desire) the Irish Song Ellen a Roon-Mrs Clive; V: The Favourite Duette Let Caesar and Urania Live (compos'd by the late Henry Purcell)-Mrs Clive, Miss Edwards

Dance: III: Cooke, Sga Campioni

Performances

Mainpiece Title: The Way Of The World

Afterpiece Title: The Lottery

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: Don Sebastian

Afterpiece Title: The Schoolboy

Song: ( B By desire )Mad Bess-Beard; The Charms of Polly Willis-Mrs Clive

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: Tragedy of Tragedies; or, Tom Thumb the Great

Song: I: Nanny O-Lowe; III: Gentle Shepherd-Mrs Arne; IV: Early Horn-Lowe

Dance: II: Sga Bettini; V: Muilment

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: Tragedy of Tragedies

Dance: II: Muilment; V: Sga Bettini

Song: III: Lowe; IV: Mrs Arne

Performances

Mainpiece Title: The Provoked Wife

Afterpiece Title: The Lying Valet

Dance: II: Muilment; III: Sga Bettini

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Tragedy of Tragedies

Dance: I: Sga Bettini; III: Muilment

Song: II: Lowe; V: Nanny O (By Desire)-Lowe