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: The Merry Wives Of Windsor

Afterpiece Title: The Apprentice

Dance: End: The Tartars-Fishar, Sga Manesiere. [See17680505.

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Apprentice

Dance: I: The Dutch Milkmaid, as17680928; II: The Garland-Fishar, Sga Manesiere. [See17671214.

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Upholsterer

Dance: End: A New Comic Dance call'd The Lamplighters-Aldridge, Sga Manesiere. [See17600318.

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: QQueen Mab

Dance: I: A New Turkish Dance-; II: A New Pantomime Dance-Dagueville, Sga Vidini

Performances

Mainpiece Title: The Provok'd Husband; Or, A Journey To London

Afterpiece Title: The Padlock

Dance: II: Turkish Dance-Dagueville, Sga Vidini

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Fortunatus

Dance: III: New Comic Dance-Dagueville, Sga Vidini

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: Harlequin Dr Faustus

Dance: II: A Dance call'd The Reel-Aldridge, Miss Valois, Sga Manesiere. [See17680307.

Performances

Mainpiece Title: Zingis

Afterpiece Title: High Life below Stairs

Dance: -D-Dagueville, Sga Vidini. [See17681210.

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Queen Mab

Dance: III: A New Pierrot's Dance-Dagueville, Sga Vidini

Performances

Mainpiece Title: The Roman Father

Afterpiece Title: The Apprentice

Dance: End: The Tambourine-Aldridge, Sga Manesiere. [See17671119.

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: Thomasand Sally

Dance: I: (By Particular Desire) a Minuet-Aldridge, Mrs Bulkley; III: The Tambourine, as17690314 End: A New Dance call'd the Whim-Aldridge, Sga Manesiere

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: High Life below Stairs

Dance: II: A New Dance-Tassoni, Sga Giorgi

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: The Devil to Pay

Dance: IV: The Wake, as17680929, but Sga Giorgi, Mrs _King

Performances

Mainpiece Title: Love In A Village

Afterpiece Title: The Miller of Mansfield

Dance: II: A Comic Dance-Fishar, Sga Manesiere [See17671106]

Performances

Mainpiece Title: George Barnwell

Afterpiece Title: The Dragon of Wantly

Dance: End: Rural Love-Fishar, Miss Valois, Sga Manesiere. [See17641212 ff.

Performances

Mainpiece Title: The School For Rakes

Afterpiece Title: Queen Mab

Dance: I: Comic Dance-Daigueville, Sga Vidini

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Ode

Dance: III: A Dance-Dagueville, Sga Vidini

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: The Dragon of Wantly

Dance: IV: The Lamplighters-Aldridge, Sga Manesiere. [See17681101.

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Jubilee

Dance: Dagueville, Sga Vidini

Performances

Mainpiece Title: The Wonder

Afterpiece Title: The Padlock

Dance: I: A New Pantomime Dance-Daiguville, Sga Vidini

Performances

Mainpiece Title: The Way To Keep Him

Dance: III: A New Dance call'd The Whim-Aldridge, Sga Manesiere. [See17690427]

Performances

Mainpiece Title: The Brothers

Afterpiece Title: The Englishman in Paris

Dance: End: The Tartars-Fishar, Sga Manesiere. [See17680416.

Performances

Mainpiece Title: Amintas

Afterpiece Title: The Englishman in Paris

Dance: I: A New Pastoral Dance-Fishar, Sga Manesiere

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Jubilee

Dance: III: A New Comic Dance call'd The Rabbit Sellers-the Daigvilles, Sga Vidini

Performances

Mainpiece Title: Cymbeline

Afterpiece Title: The Jubilee

Dance: III: Comic Dance-the Daiguevilles, Sga Vidini