Toggle Sphinx Query
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

?
New Search
707 results for: Keyword - L. Grano
We found 452 matches on Event Comments, 139 matches on Performance Comments, 96 matches on Author, 34 matches on Performance Title, and 0 matches on Roles/Actors.

701
24 March 1789 @ King's Theatre

Performances

Mainpiece Title: La Villana Riconosciuta

Dance: As17890317

702
09 May 1789 @ King's Theatre

Performances

Mainpiece Title: La Vendemmia

Dance: As17890404

703
02 June 1789 @ King's Theatre

Performances

Mainpiece Title: La Generosita Dalessandro

Dance: As17890526

704
11 June 1789 @ King's Theatre

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

705
14 May 1793 @ Drury Lane Theatre

Performances

Mainpiece Title: At Hay King Henry The Eighth

Afterpiece Title: The Devil to Pay

Song: In IV: a song-Master Welsh

706
08 June 1797 @ King's Theatre

Performances

Mainpiece Title: Le Gelosie Villane

Dance: As17970513

Song: End Opera: Pygmalion-Viganoni

Ballet: Sapho et Phaon. As17970513

707
25 March 1799 @ Covent Garden

Performances

Mainpiece Title: A Divertisement

Afterpiece Title: Five Thousand a Year

Afterpiece Title: The Magic Oak