SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "Sga Casentini"/1) | (@(roleclean,performerclean) "Sga Casentini")') 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 903 matches on Performance Comments, 647 matches on Performance Title, 218 matches on Event Comments, 96 matches on Roles/Actors, and 0 matches on Author.

Performances

Dance: As17910322

Ballet: Telemachus in the Island of Calypso. As17910322

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: End I: La Fille Mal Gardee, as17910430

Ballet: End Opera: Le Siege de Cythere. As17910517

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910510

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: End I: Divertisement, as17910217; End Opera: Telemachus in the Island of Calypso, as17910414

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910531

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910517

Ballet: Le Siege de Cythere. As17910517

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: End I: Le Triomphe de la Folie, as17910503; End Opera: The Deserter, as17910428

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910610

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910430

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: End I: La Fille Mal Gardee, as17910430; End Opera: Le Siege de Cythere, as17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910616

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910322

Ballet: Telemachus in the Island of Calypso. As17910322

Performances

Mainpiece Title: La Molinarella

Cast
Role: Rachelina Actor: Sga Casentini
Role: Donna Eugenia Actor: Sga Calvesi.

Dance: As17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910616

Performances

Mainpiece Title: La Locanda

Cast
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti
Role: Guerina Actor: Sga Casentini.

Dance: As17910623

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: Le Trame Deluse

Cast
Role: Ortensia Actor: Sga Casentini
Role: Dorinda Actor: Sga Calvesi
Role: Olimpia Actor: Sga Salimbeni.

Dance: As17920214

Performances

Mainpiece Title: La Locanda

Cast
Role: Guerina Actor: Sga Casentini
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti.

Dance: As17920214

Performances

Mainpiece Title: La Locanda

Cast
Role: Guerina Actor: Sga Casentini
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti.

Dance: As17920214

Performances

Mainpiece Title: La Locanda

Cast
Role: Guerina Actor: Sga Casentini
Role: Marinetta Actor: Sga Calvesi
Role: Rosaura Actor: Sga Schinotti.

Dance: As17920214