The London Stage Database team will be retiring the Legacy Search on May 1, 2025. Please take a moment before that date to reproduce any pre-2021 searches and export any resulting datasets you may wish to preserve for future use. We are making this change in order to free up computational resources for new features and data, currently in development with support from the National Endowment for the Humanities. Watch this space for more updates and, coming soon, new ways to keep up with the latest project developments!
SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Ariaja"/1) | (@(roleclean,performerclean) "Ariaja")') 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 1 matches on Performance Comments, 0 matches on Performance Title, 0 matches on Author, 0 matches on Event Comments, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: Entertainment Of Vocal And Instrumental Music

Performance Comment: Part I: A New Overture by Chiampi-; Jo Son quell Pellegrino (Terradellas)-Sga Giacomazzi; Dille che d'altra Face (Cocchi)-Laschi; Questo core amato bene (Ariaja)-Sga Galli; Concerto-Pasqualino; Le Dolcezze dell' Amor (Chiampi)-Guadagni; Infelice Van milagno (Chiampi)-Sga Frasi; Part II: Concerto-Dubourg; Qual Nocchiero (Chiampi)-Sga Mellini; Dal Labro (Chiampi)-Sga Giacomazzi; Oh dio mancar mi Sento (Chiampi)-Sga Frasi; Concerto-Miller; Son sventurato (Chiampi)-Guadagni; Fair and Comely is my Love (Handel)-Sga Galli; Part III: Concerto-Vincent; Crudo Amore (Fini)-Laschi; Alla selva al prato (Fini)-Mellini; Se torna il gelo usato (Pulli)-Sga Giacomazzi; So che per Gioco (Pulli)-Sga Galli; Duet O Fairest of Ten Thousand Fair (Handel)-Sga Frasi, Guadagni; A Grand Concerto by Handel-.