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.

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

Performances

Mainpiece Title: Richard Iii

Afterpiece Title: What D'ye Call It

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Orphan

Afterpiece Title: Tragedy of Tragedies

Dance: I: Sga Bettini; III: Muilment

Song: II, IV: Lowe

Performances

Mainpiece Title: As You Like It

Dance: II: Cooke, LaLauze, Picq; IV: Cooke, Sga Campioni

Song: I: By Desire a Song call'd Old England Forever-; with a chorus-; III: The Miser's Passport-

Performances

Mainpiece Title: King Henry The Fifth

Afterpiece Title: Pyramus and Thisbe

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Anatomist

Dance: I: Sga Bettini; III: Muilment

Song: II: Gentle Shepherd-Mrs Arne; IV: Mrs Arne

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Tragedy of Tragedies

Song: II: Mrs Arne; IV: Nanny O-Lowe; V: Early Horn-Lowe

Dance: I: Sga Bettini; III: Muilment

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: Chrononhotonthologos

Song: I: a Cantata-Lowe

Dance: II: Muilment; III: Sga Bettini

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Lying Valet

Song: I: Early Horn-Lowe

Dance: II: Sga Bettini; III: Muilment

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Damon and Phillida

Song: The Songs in Masonry-Leveridge, Stoppelaer, Bencraft

Dance: Cooke, Sga Campioni

Performances

Mainpiece Title: Henry Viii

Dance: Cooke, LaLauze, Villeneuve, Mrs Delagarde, Sga Campioni

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Rosamond

Song: I: Cantata-Lowe; III: Gentle Shepherd-Mrs Arne

Dance: II: Muilment; IV: Sga Bettini

Performances

Mainpiece Title: The Country Wife

Afterpiece Title: Tragedy of Tragedies

Song: I, III: Lowe

Dance: II: Sga Bettini