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

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

Performances

Mainpiece Title: La Schiava

Afterpiece Title: L'Uccellatrice

Dance: Gallioti, Sga Guidi

Performances

Mainpiece Title: The Roman Father

Afterpiece Title: The Apprentice

Dance: End: The Reel-Aldridge, Miss Valois, Sga Manesiere. [See17680307.

Performances

Mainpiece Title: Gioas Re Di Giuda

Music: End Act I: Concerto on Violin-LaHaussage; In Act I: Sonata on Violincello-Dupart

Song: II: Song-Sga Guglielmi, accompanied by Dupart

Performances

Mainpiece Title: Cyrus

Afterpiece Title: The Citizen

Dance: End: The Irish Lilt-Aldridge, Sga Manesiere. [See17670921.

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Padlock

Dance: I: A New Comic Dance-Daigville, Sga Vidini