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

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

Performances

Mainpiece Title: The Refusal

Afterpiece Title: The Debauchees

Dance: II: Grand Ballet-Sga Paduana, Muilment, Mechel, Mlle Mechel, Salomon's Son

Performances

Mainpiece Title: The Lady's Last Stake

Dance: Two Entertainments-Salomon, Mlle Violette, Muilment, Sga Padouana, Cook, 1st appearance that stage

Performances

Mainpiece Title: Venice Preserved; Or, A Plot Discover'd

Dance: II: Salomon, Mlle Violette, Cook, Salomon's Son; III: Muilment; V: Grand Comic Dance-Salomon, Mlle Violette, Cooke, Sga Padouana

Performances

Mainpiece Title: The Artful Husband

Afterpiece Title: Flora

Dance: Salomon, Sga Padouana, Salomon's Son

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Dragon of Wantley

Dance: Salomon, Sga Padouana, the Mechels

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Dragon of Wantley

Dance: Salomon, Sga Padouana, Muilment, Salomon's Son, the Mechels

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Dragon of Wantley

Dance: Salomon, Cook, Sga Padouana, Muilment, Salomon's Son, the Mechels

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Dragon of Wantley

Dance: New entertainments-Salomon, Sga Padouana, Salomon's son

Performances

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

Afterpiece Title: The Double Disappointment

Song: I: Mrs Mozeen; III: Lowe

Dance: II: The Mechels; IV: Muilment; V: Salomon, Sga Padouana, Salomon's son

Performances

Mainpiece Title: The Artful Husband

Afterpiece Title: The Suspicious Husband Criticized

Dance: Salomon, Sga Padouana, Salomon's Son

Performances

Mainpiece Title: Marry Or Do Worse; Or, No Wit Like A Woman's

Afterpiece Title: The School Boy

Song: I,IV: Lowe

Dance: II: Muilment; III: The Mechels; V: Salomon, Sga Padouana, Salomon's Son

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Lying Valet

Dance: Salomon, Sga Padouana, Muilment, the Mechels, Salomon's son

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The Dragon of Wantley

Dance: Salomon, Sga Padouana, Mlle Mechel, Salomon's Son

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Flora

Dance: Salomon, Sga Padouana, Salomon's Son

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Chrononhotonthologos

Dance: Salomon, Sga Padouana

Performances

Mainpiece Title: The Fine Lady's Airs; Or, An Equipage Of Lovers

Afterpiece Title: The King and the Miller of Mansfield

Song: I: By particular Desire, Arrah my Judy-Barrington

Dance: Salomon, Sga Padouana, Salomon's Son

Performances

Mainpiece Title: The Refusal

Afterpiece Title: The Double Disappointment

Dance: I: The Mechels; III: Sga Padouana; IV: A Minuet-Salomon, Mrs Woffington; V: Comic Dance, as17470410

Song: II: Sullivan; IV: Original Cantata-Lowe

Performances

Mainpiece Title: The Fine Lady's Airs

Afterpiece Title: The Dragon of Wantley

Dance: Salomon, Sga Padouana, the Mechels, Salomon's son

Song: III: A Duet of Purcell's call'd Caesar and Urania-Mrs Clive, Mrs Mozeen

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Miss in Her Teens

Dance: CComic Dance-Master Matthews, Miss Vandersluys; A Grand Ballet-Lalauze, Villeneuve, Sga Campioni; A Ball Minuet-LaLauze, two of LaLauze's scholars of three months learning only, who never appear'd before

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The Double Disappointment

Song: I: Sullivan; End of Farce, By Particular Desire Irish Rorotorio-Mr Barrington

Dance: II: Mechel, Mlle Mechel; IV: Muilment; V: Salomon, Sga Padouana