SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "MY GRANDMOTHER"/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: Macbeth

Afterpiece Title: My Grandmother

Song: In: Chorus of Witches and Spirits-Sedgwick, Dignum, Miss Leak, Miss DeCamp, Miss Arne, Miss Wentworth

Performances

Mainpiece Title: A Word For Nature

Afterpiece Title: My Grandmother

Ballet: End: The Scotch Ghost. As17981206

Performances

Mainpiece Title: The School For Scandal

Afterpiece Title: My Grandmother

Song: As17990108

Performances

Mainpiece Title: The Secret

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Stranger

Afterpiece Title: My Grandmother

Music: To welcome mirth and harmless glee, as17980915, but Mrs _Bland, Miss Jackson; +I have a silent sorrow here-Miss Jackson

Dance: As17980915

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: Vocal Parts-Kelly, Sedgwick, Dignum, Trueman, Danby, Brown, Cook, Tett, Caulfield Jun., Sawyer, Danby Jun., Aylmer, Willoughby, Bardoleau, Clark, Mead, Elliot, Ms Crouch, Ms DeCamp, Ms Stephens, Ms Leak, Ms Dufour, Ms Arne, Ms Menage, Ms Roffey, Ms Menage Jun., Ms Jackson, Ms Wentworth, Ms Chippendale, Ms Jacobs, Ms Butler, Ms Bowyer, Ms Williams, Ms Saunders, Ms Gaudry, Ms Benson, Mrs Illingworth, Mrs Coates

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: As17990529

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: As17990529

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: My Grandmother

Entertainment: Monologue. As17990622

Performances

Mainpiece Title: The Jew

Afterpiece Title: My Grandmother

Afterpiece Title: Blue Devils

Performances

Mainpiece Title: Sighs

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Battle Of Hexham

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Red-cross Knights

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Secret

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: As17991213

Performances

Mainpiece Title: Pizarro

Afterpiece Title: My Grandmother

Song: As17991228

Performances

Mainpiece Title: A Bold Stroke For A Wife

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: The Heir At Law

Afterpiece Title: My Grandmother