SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "Alzira"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: Alzira; Or, The Americans

Dance: By Vallois and Mrs Bullock

Performances

Mainpiece Title: Alzira

Dance: As17360618

Performances

Mainpiece Title: Alzira

Dance: As17360618

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Chymical Counterfeits

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Chymical Counterfeits

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Chymical Counterfeits

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Chymical Counterfeits

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Chymical Counterfeits

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Chymical Counterfeits

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Worm Doctor

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Devil to Pay

Dance: III: Clown-Vallois; V: French Peasants-Master Oates, Miss Oates

Song: IV: Singing in Italian-Mrs Chambers

Performances

Mainpiece Title: Alzira; Or, Spanish Insult Repented

Afterpiece Title: The Anatomist

Dance: III: Mlle Auguste

Performances

Mainpiece Title: Alzira

Afterpiece Title: Taste

Dance: Comic Entertainment-Poitier, Mlle Capdeville

Performances

Mainpiece Title: Alzira

Afterpiece Title: Orpheus and Eurydice

Performances

Mainpiece Title: Alzira

Afterpiece Title: A Duke and no Duke

Dance: LLes Paisans Gallants, as17551203

Performances

Mainpiece Title: Alzira

Afterpiece Title: Harlequin Sorcerer

Performances

Mainpiece Title: Alzira

Afterpiece Title: The Englishman Returned from Paris

Ballet: The Judgment of Paris. As17571217

Dance: As17571217

Performances

Mainpiece Title: Alzira

Afterpiece Title: Harlequin Statue; or, The Jealous Farmer Deceiv'd

Dance: I: Fingalian Dance-Miss Toogood, Apprentice to Lalauze; III: The Provincial Sailors, as17580408 IV: By Desire, Louvre, Minuet-Lalauze, Miss Toogood; V: Savoyards, as17580408