SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Mr Cramer"/1) | (@(roleclean,performerclean) "Mr Cramer")') 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 4229 matches on Event Comments, 1144 matches on Performance Comments, 548 matches on Performance Title, 18 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The West Indian

Afterpiece Title: Harlequin's Jacket

Dance: II: Grand Provencalle Dance, as17750202

Performances

Mainpiece Title: Othello

Afterpiece Title: The Elopement

Performances

Mainpiece Title: Othello

Afterpiece Title: The Elopement

Dance: II: The Merry Peasants, as17751018

Performances

Mainpiece Title: Zara

Afterpiece Title: The Rival Candidates

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: May Day

Dance: II: The Merry Peasants, as17751018

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Devil to Pay

Performances

Mainpiece Title: The Roman Father (with Alterations)

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: La Cosa Rara

Dance: End I: New Divertissement, as17890110, but _Didelot; End Opera: Les Fetes Provencales, as17890207, but _Didelot, Mlle _Normand

Performances

Mainpiece Title: Macbeth

Afterpiece Title: Albert and Adelaide

Dance: As17981211

Song: Mainpiece: Vocal Parts-Incledon, Johnstone, Townsend, Hill, Linton, Blurton, Street, Gray, Little, Lee, Sawyer, Tett, Dyke, Mrs Chapman, Miss Mitchell, Miss Wheatley, Mrs Iliff, Miss Sims, Mrs Whitmore, Mrs Watts, Mrs Follett, Miss Leserve, Mrs Castelle, Mrs Norton, Mrs Gilbert, Mrs Masters, Mrs Lloyd, Mrs Blurton, Miss Walcup, Miss Gray, Miss Burnett, Mrs Martyr

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: As17990529

Performances

Mainpiece Title: Pizarro

Afterpiece Title: The Lying Valet

Ballet: The Scotch Ghost. As17990628

Song: As17990628

Performances

Mainpiece Title: The Messiah

Music: I: New Concerto (Bach)-Tacet, Cramer, Cervetto, Fisher; II: Concerto on Violin-Cramer

Performances

Mainpiece Title: Judas Maccabaeus

Music: I: Concerto (Abel)-Crosdell, Cramer, Fisher; II: Concerto (Bach)-Tacet, Crosdell, Fisher, Cramer

Performances

Mainpiece Title: The Messiah

Music: I: Concerto (Abel)-Cramer, Cervetto, Fisher; II: Concerto on Violin-Cramer

Performances

Mainpiece Title: Samson

Music: I: New Concerto-Tacet, Fisher, Cramer, Crosdell (Composed by Bach); II: New Concerto on the Organ by Bach-

Performances

Mainpiece Title: The Messiah

Music: I: Concerto on Violincello-Cervetto; II: Concerto on Violin-Cramer

Performances

Mainpiece Title: Samson

Music: I: Solo on Violincello-Crosdell; II: Concerto (Bach)-Crosdell, Cramer, Fisher

Performances

Mainpiece Title: Alexander's Feast

Music: I: Bach Concerto-Tacet, Cramer, Cervetto, Fisher; II: Concerto for Two Violins and a Violin@cello by Bach-

Performances

Mainpiece Title: Judas Maccabaeus

Music: I: Bach Concerto-Tacet, Cramer, Crosdell, Fisher; II: Concerto on Hautboy-Fisher

Performances

Mainpiece Title: Alexander's Feast

Music: I: New Concerto for two Violins-; a Violincello by Bach-; II: Concerto on Violin-Cramer

Performances

Mainpiece Title: Creso

Dance: As17780203 throughout

Song: II: a new song by Sacchini-Roncaglia; accompanied on the violin-Cramer

Performances

Mainpiece Title: La Clemenza Di Scipione

Dance: End I: Divertisement, as17780207; End Opera: new grand Serious Ballet, Les Amans unis par l'Hymen-Simonet, Mlle Baccelli, Sg and Sga Zuchelli, Vallouy@le@cadet

Song: II: an air-Sga Danzi; [accompanied on the violin-Cramer; violoncello-Cervetto; German flute-Florio; hautboy-LeBrun. [This was sung, as here assigned, in all subsequent performances.

Ballet: End II: La Surprize de Daphnis et Cephise. As17780331

Performances

Mainpiece Title: Judas Maccabaeus

Music: End Part I: concerto on the organ-Stanley; End Part II: concerto on the violin-Cramer

Performances

Mainpiece Title: Demofoonte

Dance: End of new song: Les Oiseleurs, as17790123; End II: Les Moissonneurs, as17781229; End Opera: New Ballet, as17790227

Song: End I: a new song-Pacchierotti; with violin obligato composed by Bertoni-Cramer; In III: an additional song composed by Handel-Pacchierotti

Performances

Mainpiece Title: Alexander's Feast

Afterpiece Title: Dryden's Ode On St

Music: End I Oratorio: concerto on the organ-Stanley; End II: concerto on the violin-Cramer