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

Performances

Mainpiece Title: King Henry Iv, Part Ii

Afterpiece Title: A Trip to Scotland

Performances

Mainpiece Title: King Henry Iv, Part Ii

Afterpiece Title: A Trip to Scotland

Performances

Mainpiece Title: Wild Oats

Afterpiece Title: The Soldier's Festival

Afterpiece Title: Rose and Colin

Performances

Mainpiece Title: La Molinarella

Dance: End I: La Fille Mal Gardee, as17910430

Ballet: End Opera: Le Siege de Cythere. As17910517

Performances

Mainpiece Title: La Bella Pescatrice

Dance: As17910517

Ballet: Le Siege de Cythere. As17910517

Performances

Mainpiece Title: La Molinarella

Dance: As17910517

Ballet: Le Siege de Cythere. As17910517

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor

Performances

Mainpiece Title: Every One Has His Fault

Afterpiece Title: The Governor

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: The Governor

Performances

Mainpiece Title: How To Grow Rich

Afterpiece Title: Sprigs of Laurel

Afterpiece Title: The Shipwreck

Song: In 3rd piece: Farewell to old England dear Mary adieu, as17930527

Performances

Mainpiece Title: Columbus

Afterpiece Title: The Pad

Afterpiece Title: The Shipwreck

Song: End of 1st piece: Dibdin's song; The Lucky Escape; or, The Ploughboy's Return from Sea in character-Mrs Harlowe; End of 2nd piece: Sally in our Alley-Marshall; In 3rd piece: Farewell to old England dear Mary adieu-Incledon; Rule Britannia-Marshall, full Chorus; In the course of the Evening: Black eyed Susan-Incledon

Performances

Mainpiece Title: The Road To Ruin

Afterpiece Title: ROSINA

Afterpiece Title: THE SHIPWRECK

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Shipwreck

Dance: In afterpiece: a Dance-Byrn, Mlle St.Amand

Song: As17951019

Performances

Mainpiece Title: The Wives Revenged

Afterpiece Title: The Secret Tribunal

Afterpiece Title: The Shipwreck

Dance: In 3rd piece: Dance, as17951026

Performances

Mainpiece Title: The Wives Revenged

Afterpiece Title: The Secret Tribunal

Afterpiece Title: A Divertisement

Performances

Mainpiece Title: The Days Of Yore

Afterpiece Title: Lock and Key

Afterpiece Title: The Shipwreck

Dance: As17951031

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: Speculation

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Lock and Key