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

?
New Search
1 results for: Keyword - Ariaja
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.

1
10 April 1750 @ King's Theatre

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-.