SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sg Lampugnani"/1) | (@(roleclean,performerclean) "Sg Lampugnani")') 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 175 matches on Performance Title, 98 matches on Performance Comments, 66 matches on Event Comments, 3 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: La Vendemmia

Cast
Role: Il Conte Zefiro Actor: Benucci
Role: Cardone Actor: Borselli
Role: Don Achille Actor: Giuseppe Forlivesi
Role: Don Fausto Actor: Fineschi
Role: Artemisia Actor: Sga Sestini
Role: Lauretta Actor: Sga Borselli
Role: Agatina Actor: Sga Storace.

Dance: As17890404