SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Giovanni de Gamerra"/1) | (@(roleclean,performerclean) "Giovanni de Gamerra")') 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 999 matches on Performance Title, 991 matches on Author, 446 matches on Performance Comments, 180 matches on Event Comments, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: Love Makes A Man

Dance: II: Grand Comic Dance, as17421117; IV: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Constant Couple

Song: As17421126

Music: II: Concerto on Violincello-Cervetti

Dance: IV: Les Moisoneurs de la Styrie, as17421126

Performances

Mainpiece Title: The Twin Rivals

Song: As17430120

Dance: II: Les Moisoneurs de la Styrie, as17421122; IV: The Italian Gardeners, as17421231

Performances

Mainpiece Title: The Rehearsal

Dance: I: The Italian Gardeners-Checa, Siga Chiaretta, Mlle Bonneval; III: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Wedding Day

Dance: II: Les Chasseurs-Checo Torinese, Chiaretta Aquilanti, Mlle Bonneval; IV: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Rehearsal

Dance: II: Les Chasseurs, as17430226; IV: Les Moisoneurs de la Styrie, as17421201

Performances

Mainpiece Title: The Constant Couple

Afterpiece Title: The Lying Valet

Dance: I: The Sicilian Peasant, as17430310 III: La Mascarade de Florana-Checo, Chiaretta; V: Italian Gardeners, as17421231

Performances

Mainpiece Title: The Constant Couple

Song: As17430120

Dance: II: La Mascarade de Florana, as17430319 IV: Italian Gardeners, as17421231

Performances

Mainpiece Title: The Spanish Fryar

Dance: I: Scotch Dance-Delamain, Anne Auretti; II: Tambourine-Anne Auretti; III: Characters of Dancing, as17421025; IV: Un Pas de Deux-Anne and Janneton Auretti; V: L'Aimable Vainqueur, Minuet-Picq, Anne Auretti

Performances

Mainpiece Title: Cato

Afterpiece Title: The Virgin Unmask'd

Dance: I: Italian Dance-Delamaine, Mlle Auguste; II: a Harlequin-Anne Auretti; III: Louvre-Delamaine; IV: Un Pas de Deux, as17430406 V: a Minuet-Delamaine, Janneton Auretti

Performances

Mainpiece Title: The Alchemist

Afterpiece Title: The Devil to Pay

Song: I: Lowe; IV: Beard

Dance: II: Les Moisoneurs de la Styrie, as17421201; La Florana, as17430408

Performances

Mainpiece Title: Don Quixote De Le Mancha

Afterpiece Title: Harlequin Captive

Song: Convers, Miss Clarke

Performances

Mainpiece Title: The Wandering Prince Of Troy

Afterpiece Title: Le Mariage de Pesant

Dance: LLe Badinage de Chaupetre-

Performances

Mainpiece Title: La Caduta De Giganti

Performances

Mainpiece Title: La Caduta De Giganti

Performances

Mainpiece Title: La Caduta De Giganti

Performances

Mainpiece Title: La Caduta De Giganti

Performances

Mainpiece Title: La Caduta De Giganti

Performances

Mainpiece Title: La Forza De L'amore

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: The Anatomist

Dance: I: Muilment; II: The Peasant and Sabotiere-Mechel, Young Mechel; III: Les Characteres de la Dance-Miss Mechel; I of Farce: Minuet, Louvre-the Mechels; End of Farce: Swiss Dance-the Mechels

Performances

Mainpiece Title: The Miser

Afterpiece Title: Sir Roger de Coverly; or, the Merry Christmas

Song: III: Lowe

Performances

Mainpiece Title: As You Like It

Dance: I: Les Caprices de la Dance-Sga Auretti; III: Grand Ballet-Cooke, Janeton Auretti; V: Polish Dance-Cooke, Sga Auretti, Leviez, Mathews, Shawford, Royer, Pelling, Mrs Addison, Mrs Shawford, Miss Cole, Miss Thompson

Performances

Mainpiece Title: The Stratagem

Dance: II: Les Caprices de la Dance-Anne Auretti; III: Grand Ballet-; IV: Polish Dance, as17471102

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Devil to Pay

Dance: I: Le Charactere de la Dance-Anne Auretti; III: The Savage Dance-Cooke, Matthews, Anne Auretti; IV: Dutch Dance, as17471128; V: Hymen's Temple-Cooke, Janeton Auretti; End of Farce: a Minuet, Louvre-Cooke, Anne Auretti

Performances

Mainpiece Title: The Alchymist

Afterpiece Title: The Dragon of Wantly

Dance: II: Pastoral Dance, as17480326 III: Savoyards, as17471215; V: By Desire Les Characters de la Dance-Anne Auretti