SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Misses Scot"/1) | (@(roleclean,performerclean) "Misses Scot")') 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
We found 13828 matches on Performance Comments, 4588 matches on Performance Title, 1750 matches on Event Comments, 122 matches on Author, and 2 matches on Roles/Actors.

Performances

Mainpiece Title: The Distrest Mother

Dance: I: Tambourine-Master Ferg, Miss Wright; II: Maggot-Haughton, Mrs Walter; III: Punch-Master Ferg; IV: La Pieraite-Livier, Miss Thompson

Song: V: The Lady's Lamentation for the Loss of Senesino-Mrs Clive

Performances

Mainpiece Title: The Man Of Mode

Afterpiece Title: The Devil to Pay

Dance: II: Flanderkins-Master Ferg, Miss Wright; IV: Ballet-Haughton, Mrs Walter; IV: Punch-Master Ferg; V: La Pieraite-Livier, Miss Thompson

Performances

Mainpiece Title: Oroonoko

Afterpiece Title: The Lucky Discovery; or, The Tanner of York

Dance: CComic Dance-Tench, Miss Cantrel; Je ne scai quoi-Tench, Villeneuve, Miss Oates; French Sailors-Lalauze, Mlle Roland

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: The Lovers Opera

Dance: I: Tambourine-Master Ferg, Miss Wright; II: Maggot-Haughton, Mrs Walter; III: Punch-Master Ferg; V: La Pieraite-Livier, Miss Thompson

Performances

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

Afterpiece Title: The Royal Chace

Dance: JJe ne scai quoi-Tench, Villeneuve, Miss Oates; A new dance-Desse, Miss Kilby

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Beggar's Wedding

Dance: JJe ne scai quoy-Tench, Villeneuve, Miss Oates; Pantomime Dance-Nivelon, Mrs LeBrun; Serious Dance-Nivelon, Miss Oates

Music: H$Handel's Water Musick-; with a Preamble on the Kettle Drums-Jo. Woodbridge

Performances

Mainpiece Title: The Mistake

Afterpiece Title: The Honest Yorkshireman

Music: Between the Acts: Select Pieces-

Dance: I: Je ne scai quoi-Tench, Villeneuve, Miss Oates; III: Two Pierrots-Lalauze, Nivelon; V: Serious Dance-Villeneuve, Miss Oates

Song: II: Cantata-Roberts; IV: Leveridge, Laguerre

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Flora

Dance: I: Comic Dance-Richardson, Miss Cantrel; II: Serious Dance-Villeneuve, Miss Oates; IV: Comic Dance-Nivelon, Mrs LeBrun; V: French Sailors-Lalauze, Mlle Roland

Song: III: Leveridge, Laguerre

Performances

Mainpiece Title: Love's Last Shift

Afterpiece Title: The Mock Lawyer

Dance: SSerious Dance-Villeneuve, Miss Oates; A new Pantomime Dance-Nivelon, Mrs LeBrun; Comic Dance-Richardson, Miss Cantrel

Performances

Mainpiece Title: Theodosius

Afterpiece Title: The Contrivances

Dance: A Comic Dance-Richardson, Miss Cantrel; Je ne scai quoi-Tench, Villeneuve, Miss Oates; French Sailors-Lalauze, Mlle Roland; Grecian Sailors-Glover

Song: A New Cantata-Roberts; The Roast Beef of Old England-Leveridge

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Beggar's Wedding

Dance: I: Comic Dance-Richardson, Miss Cantrel; II: Je ne scai quoy-Tench, Villeneuve, Miss Oates; III: Serious Dance-Mlle Roland; IV: Pantomime Dance-Nivelon, Mrs LeBrun; V: Grecian Sailors-Glover

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Honest Yorkshireman

Dance: SSerious Dance-Villeneuve, Miss Oates; Pantomime Dance-Nivelon, Mrs LeBrun; Comic Dance-Tench, Miss Cantrel

Song: SSince Times are so bad (Purcell)-Leveridge, Salway

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Honest Yorkshireman

Dance: I: Comic Dance-Richardson, Miss Cantrel; II: Two Pierrots-Nivelon, Lalauze; III: Je ne scai quoy-Tench, Villeneuve, Miss Oates; IV: Pantomime Dance-Nivelon, Mrs LeBrun; V: Grecian Sailors-Glover

Song: III: Chancon a Boire-Leveridge, Laguerre

Performances

Mainpiece Title: The Fair Quaker Of Deal

Afterpiece Title: The Beggar's Wedding

Dance: I: Serious Dance-Villeneuve, Miss Oates; II: Pantomime-Nivelon, Mrs LeBrun; II: Je ne scai quoy-Tench, Villeneuve, Miss Oates

Performances

Mainpiece Title: King Richard The Third

Afterpiece Title: The Devil to Pay

Dance: I: Flanderkins-Master Ferg, Miss Wright; II: Two Pierrots-Vallois, Pelling; III: Punch-Master Ferg; IV: Comic Dance-younger Miss Scott

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: The Lovers Opera

Dance: I: Punch-Master Ferg; III: Minuet, The Bretagne-Miss Wright, Miss Morrison; V: La Pierraite-Leviez, Mrs Thompson

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The King and the Miller of Mansfield

Dance: I: A new dance-Miss Wright, Miss Morrison; II: Punch-Master Ferg; III: Drunken Peasant-Phillips; V: A new Sailor's Dance-Phillips

Performances

Mainpiece Title: The Double Gallant; Or, The Sick Lady's Cure

Afterpiece Title: The Dragon of Wantley

Dance: CComic Dance-Richardson, Miss Cantrel; Serious Dance-Villeneuve, Miss Oates; Grecian Sailors, others-

Performances

Mainpiece Title: Volpone; Or, The Fox

Afterpiece Title: The Lucky Discovery

Dance: CComic Dance-Richardson, Miss Cantrel; Serious Dance-Villeneuve, Miss Oates; Grand Ballet-Glover, Mlle Roland

Performances

Mainpiece Title: The Provok'd Husband

Afterpiece Title: The Toy Shop

Dance: CComic Dance-Richardson, Miss Cantrel; Serious Dance-Villeneuve, Miss Oates

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Lucky Discovery

Song: Roberts; Since Times are so bad-Leveridge, Salway

Dance: CComic Dance-Richardson, Miss Cantrel; Serious Dance-Villeneuve, Miss Oates; Grand Ballet-Glover, Mlle Roland

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Margery; or, A Worse Plague than the Dragon : Being the Sequel to the Dragon of Wantley

Dance: With Dances, incident to the Opera,-Glover, Lalauze, Haughton, Mlle Roland, Villeneuve, Richardson, Dupre, Thompson, Miss Oates, Miss Norman, Mrs LeBrun, Mrs Bullock

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Honest Yorkshireman

Dance: A new dance-Richardson, Miss Cantrel; A Comic Dance-Villeneuve, Miss Oates; A Serious Dance-Mlle Roland

Performances

Mainpiece Title: The Fair Quaker Of Deal

Afterpiece Title: Margery

Dance: Glover, Mlle Roland, Villeneuve, Richardson, Dupre, Miss Oates, Miss Norman, Mrs LeBrun

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: Margery

Dance: Dancing-Glover, Mlle Roland, Villeneuve, Richardson, Dupre, Miss Oates, Miss Norman, Mrs LeBrun but see17390215

Song: CChancon a Boire-Leveridge, Laguerre