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

Performances

Mainpiece Title: La Sposa Fedele

Dance: Le Triomphe-; Il Filosofo-Paladini, Sga Tinti, Helm; Pigmalion, as17751116

Performances

Mainpiece Title: La Sposa Fedele

Dance: Apollon e Daphne, as17751031; Il Filosofo, as17751128; Pigmalion, as17751128

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17751128

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17751128

Performances

Mainpiece Title: La Sposa Fedele

Dance: As17751128

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: Ballet Pastoral, as17760120; End of Opera: A Divertissement-Mlle Baccelli, Mlle Sophie

Performances

Mainpiece Title: La Vestale

Dance: Les Deux Soeurs, as17760206; End II: Les Evenemens Imprevues-; A Divertissement, as17760206

Performances

Mainpiece Title: La Vestale

Dance: I: Divertissement-Fierville, Mlle Bacelli; II: Ballet Pastoral, as17760120; End Opera: Pigmalion Amoureuse de La Statue, as17760120

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village-Vallouy, Mme Vallouy, Helm, Mlle Sophie, Sga Tinti; End Opera: Pigmalion Amoureuse de La Statue, as17751031

Performances

Mainpiece Title: La Vestale

Dance: As17760224 (Les Deux Soeurs, La Fete du Village, and Pigmalion.

Performances

Mainpiece Title: La Vestale

Dance: Les Deux Soeurs, as17760224; La Fete du Village, as17760224; Pigmalion, as17760307

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village, as17760312

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village, as17760224

Ballet: III: Astolphe. As17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: Ballet Pastoral, as17760328

Ballet: III: Astolphe. As17760312

Performances

Mainpiece Title: La Vestale

Dance: I: Les Deux Soeurs, as17760203; II: Le Fete du Village, as17760224

Ballet: III: Astolphe. As17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: La Fete du Village, as17760224

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: La Sposa Fedele

Dance: I: New Grand Chaconne-Miss Baccelli; Pas de Deux-Mlle Sophie, Helm; II: La Fete du Village, as17760224; III: A Grand Serious Ballet with various Divertissements-Helm, Mlle Sophie, Fierville, Miss Baccelli

Performances

Mainpiece Title: La Serva Padrona

Afterpiece Title: L'Isola D'Amore

Dance: After the Intermezzo: Le Retour des Matelotes, as17760319 End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: La Vestale

Dance: Apollon e Daphne, as17751031; Minuet de la Cour-the two Vallouys; End II: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: The Recruiting Serjeant

Afterpiece Title: La Serva Padrona

Entertainment: Piety in Pattens-

Song: The Catch Club-

Performances

Mainpiece Title: The Recruiting Serjeant

Afterpiece Title: La Serva Padrona

Entertainment: Piety in Pattens, and the Spouting Club-

Performances

Mainpiece Title: La Buona Figliuola

Dance: As17760516

Ballet: Astolphe. As17760312

Performances

Mainpiece Title: La Buona Figliuola

Dance: I: Le Retour des Matelotes, as17760319 II: Diane et Endymion, as17760312

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: La Fraschetana

Dance: As17761102

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amusemens Champetres, as17761102; End II: Grand Serious Ballet, as17761102; End Opera: a new Ballet, Demi-caractere, Les Chasseurs-Mons Vallouy, Mme Vallouy, Sg and Sga Zuchelli, Simonin Vallouy?@le@cadet