SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "la Riche"/1) | (@(roleclean,performerclean) "la Riche")') 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 2302 matches on Performance Title, 381 matches on Performance Comments, 157 matches on Event Comments, 4 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Moglie Fedele

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliuola

Performances

Mainpiece Title: La Buona Figliola

Performances

Mainpiece Title: La Buona Figliola

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Schiava

Afterpiece Title: L'Uccellatrice

Dance: Gallioti, Sga Guidi

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Passione

Music: I: Solo on French Horn-celebrated M. Rodolphe; II: A solo on the Violincello-the celebrated M. Dupart, Musician to the Prince of Conti

Performances

Mainpiece Title: La Schiava

Performances

Mainpiece Title: La Passione

Music: After 1st Chorus: A solo on French Horn-the celebrated Rodolfe; End Act I: A solo on the Violino-Lahaussage; End of Piece: Solo on Violincello-by the celebratedDupart

Song: After the violincello: The Stabat Mater (music by Pergolesi)-Guadagni, Savoi; The whole performance to conclude with: a Grand Chorus (music by Guglielmi) with a Trio-Miss Dupart, Rodolfe. [Query: the trio instumental?]