SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sg Piettro"/1) | (@(roleclean,performerclean) "Sg Piettro")') 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 182 matches on Performance Title, 97 matches on Performance Comments, 58 matches on Event Comments, 8 matches on Roles/Actors, and 0 matches on Author.

Performances

Mainpiece Title: Rinaldo

Dance: Three new Ballets composed by Favre Guiardele. End I: The Rural Sports-Sg and Sga Zuchelli, Henry, Miss Andreas, Miss Simonet, Sga Crespi; End II: La Fete Pastorale-Favre Guiardele, Mme Simonet, Sga Tantini; with a Pas Seul-Mlle Baccelli; accompanied on the guitar-Noferi; End Opera: Serious Ballet, as17800122, but Mme Simonet, Sga +Tantini; +Grand Chaconne by Floquet-

Performances

Mainpiece Title: Mitridate

Dance: End I: The Pert Country Maid, as17810113; End II: a new serious Ballet (composed by Simonet) The Nymphs of Diana-Vestris? Jun., Mlle Baccelli, Sg and Sga Zuchelli, Henry, Sga Crespi, Miss Simonet, Mme Simonet; End Opera: a new grand Ballet half-character (composed by Simonet) The Rural Sports-Vestris? Jun., Mlle Baccelli, Henry, Sga Crespi, Traffieri, Slingsby, Sga Tantini

Performances

Mainpiece Title: The Hypocrite

Afterpiece Title: A Fete

Afterpiece Title: Bon Ton

Performances

Mainpiece Title: A Preludio

Afterpiece Title: The Beggar's Opera

Afterpiece Title: Medea and Jason

Dance: In Act III of mainpiece a Hornpipe by Master Byrn. [This was danced, as here assigned, in all subsequent performances.]

Performances

Mainpiece Title: The Beggar's Opera

Dance: I: The French Peasants, as17420116; II: A Dutch Dance, as17411114; III: The Swiss, as17420119; In III: a Hornpipe-Phillips

Performances

Mainpiece Title: Adriano In Siria

Dance: End of Opera:

Performances

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

Afterpiece Title: Lethe

Song: Master Mattocks

Dance: Mathews, Mad Camargo, McNeil

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: Harlequin Ranger

Dance: Mad Auretti

Performances

Mainpiece Title: The Revenge

Afterpiece Title: Harlequin Ranger

Performances

Mainpiece Title: The Old Woman's Oratory

Performances

Mainpiece Title: The Old Woman's Oratory

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Triumphs of Hibernia

Dance: I: Grand Comic Ballet, as17511216; III: Venetian Gardeners-Grandchamps, Madem Camargo; End of Play: Louvre, Minuet-Grandchamps, Madem Camargo

Performances

Mainpiece Title: The City Wive's Confederacy

Afterpiece Title: Perseus and Andromeda; or, The Cheats of Harlequin

Performances

Mainpiece Title: The Old Woman's Oratory; Mrs Midnight's Concert And Oratory

Entertainment: Bombasto

Performances

Mainpiece Title: The Distrest Mother

Afterpiece Title: Harlequin Skeleton

Performances

Mainpiece Title: Tamerlane

Afterpiece Title: The Schoolboy

Performances

Mainpiece Title: La Famiglia De Bertholdi, Alla Corte Del Re Alboino

Dance: [Unspecified.]

Performances

Mainpiece Title: Siroe

Performances

Mainpiece Title: La Serva Padrona

Music: First violin-Marella; The rest-the best hands in town

Performances

Mainpiece Title: The Fairies

Dance: CComic Dance-Sabatini, Sga Sabatini, Sabatini jun, his first time

Performances

Mainpiece Title: Ricimero

Performances

Mainpiece Title: Ezio

Dance: new Dew Dances-

Performances

Mainpiece Title: Ezio

Performances

Mainpiece Title: Merope

Afterpiece Title: A Duke and no Duke