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

Performances

Mainpiece Title: New Brooms

Afterpiece Title: Braganza

Afterpiece Title: The Rival Candidates

Performances

Mainpiece Title: The Fathers; Or, The Good Natur'd Man

Afterpiece Title: The Irish Widow

Dance: As17780919

Performances

Mainpiece Title: The Wonder

Afterpiece Title: A Fete

Afterpiece Title: High Life below Stairs

Performances

Mainpiece Title: A New Pantomime [don Juan]

Afterpiece Title: The Deserter

Performances

Mainpiece Title: La Villana Riconosciuta

Dance: As17890317

Performances

Mainpiece Title: La Vendemmia

Dance: As17890404

Performances

Mainpiece Title: La Generosita D'alessandro

Dance: As17890526

Performances

Mainpiece Title: Il Barbiere Di Siviglia; Or, The Spanish Barber

Dance: End II: New Divertissement-[See17890110]; End Opera: La Nymphe et le Chasseur, as17890606

Music: End I: a Trio for Piano Forte Violin and Violoncello-Clementi, Cramer, Cervetto

Performances

Mainpiece Title: At Hay King Henry The Eighth

Afterpiece Title: The Devil to Pay

Song: In IV: a song-Master Welsh

Performances

Mainpiece Title: Le Gelosie Villane

Dance: As17970513

Song: End Opera: Pygmalion-Viganoni

Ballet: Sapho et Phaon. As17970513

Performances

Mainpiece Title: A Divertisement

Afterpiece Title: Five Thousand a Year

Afterpiece Title: The Magic Oak