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: Perseo

Dance: I: Ballet, Chaconne-Fierville; II: Ballet-Mariottini, Sga Mazzoni; End Opera: L'Embarass du choix, as17740505

Performances

Mainpiece Title: L'olimpiade

Performance Comment: Parts-Millico, Schiroli, Sga Galli, Michelli, Sga Marchetti, Cecelia Davies.

Dance: I: L'Embarass du choix, as17740505; II: A New Field Dance-Mariottini, Sga Mazzoni; III: Ballet-Fierville, Nina Favier

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Sylphs

Dance: III: A New Grand Ballet, call'd The Vintage Festival-Daguville, Sga Vidini, [first time on that stage, and Mr Helm[, first appearance in England. [See dl 11 Oct. 1766.

Performances

Mainpiece Title: The Grecian Daughter

Afterpiece Title: The Country Madcap

Dance: End: A New Comic Dance, call'd The Portraits A@la@Mode-Dagueville, Helme, Sga Vidini

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Romance of an Hour

Dance: I: The Generous Pirate-Dagueville, Helme, Sga Vidini; End Opera: The Frolick, as17741214

Performances

Mainpiece Title: Braganza

Afterpiece Title: The Note of Hand

Dance: Slingsby, Sga Hidou, not title expressed

Performances

Mainpiece Title: The Fair Quaker

Afterpiece Title: Harlequin's Jacket

Dance: Slingsby, Sga Hidou. [Title unspecified.

Performances

Mainpiece Title: Braganza

Afterpiece Title: Harlequin's Jacket

Dance: II: The Grand Garland Dance-Slingsby, Sga Hidou

Performances

Mainpiece Title: The Rivals

Afterpiece Title: The Druids

Dance: III: A Double Hornpipe-Leoni, Miss Bassan; IV: An Allemande-Holloway, Sga Daguville

Performances

Mainpiece Title: She Stoops To Conquer

Afterpiece Title: St Patrick's Day

Dance: II: A New Grand Ballet, The Italian Gardeners-; End Comedy: [A New Dance call'd The Gamesters-Sg and Sga Zuchelli[, being their first appearance in England. [For Italian Gardeners see17740919.

Performances

Mainpiece Title: Zara

Afterpiece Title: The Two Misers

Dance: End Tragedy: The Gamesters-Sg and Sga Zuchelli

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Cross Purposes

Dance: End Opera: The Vintage Festival-Dagueville, Sga Vidini. [See17741007.

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Commissary

Dance: End: a New Ballet, The Gardeners-Sg and Sga Zuchelli [see17690114]

Performances

Mainpiece Title: La Sposa Fedele

Dance: I: Il Filosofo Amoroso-Paladini (first appearance), Sga Tinti; II: Apollon e Daphne, as17751031; End Opera: Pigmalion, as17751031

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: The Commissary

Dance: End Opera: A New Comic Dance (Never Performed)-Dagueville, Sga Vidini, Mas. Holland, Harris, Miss Mathews, Miss Ross, etc

Performances

Mainpiece Title: La Sposa Fedele

Dance: Le Triomphe-; Il Filosofo-Paladini, Sga Tinti, Helm; Pigmalion, as17751116

Performances

Mainpiece Title: The Duenna

Afterpiece Title: Miss in Her Teens

Dance: End Opera: a New Comic Dance call'd La Soiree A@la@mode-Dagueville, Sga Vidini, Mas. Holland, Harris, Miss Ross, a girl only 5 years old, scholar to Dagueville

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Jubilee

Dance: I: A New Comic Dance call'd The Gardeners-Sg Martini, first appearance on the English Stage, and Sga Paccini

Performances

Mainpiece Title: Epicoene

Afterpiece Title: The Jubilee

Dance: II: A New Dance call'd The Jealous Harlequin-Martini, Sga Paccini

Performances

Mainpiece Title: The Discovery

Afterpiece Title: The Author

Dance: Martini, Sga Paccini. [Title unspecified on playbill.

Performances

Mainpiece Title: Artaxerxes

Afterpiece Title: Catherine and Petruchio

Dance: End Opera: The Frolick-Aldridge, Miss Besford, Sga Vidini. [See17741214.

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village-Vallouy, Mme Vallouy, Helm, Mlle Sophie, Sga Tinti; End Opera: Pigmalion Amoureuse de La Statue, as17751031

Performances

Mainpiece Title: Medea

Afterpiece Title: The Deserter

Dance: End: The Grand Garland Dance-, as17760302 but Sga _Pacini

Performances

Mainpiece Title: L'isola D'amore

Dance: After the Overture: A New Ballet Incident to the Opera call'd Le Retour des Matelotes-Helm, Mlle Sophie, Sga Tinti; End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: Twelfth Night

Afterpiece Title: The Man of Quality

Dance: End: The Grand Garland Dance, as17760311 but Sga Pacini