SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "A Grand Sacred Selection 1"/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: Life's Vagaries

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: Life's Vagaries

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: England Preserv'd

Afterpiece Title: The Irish Mimick; or, Blunders at Brighton

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Busy Body

Afterpiece Title: The Irish Mimick

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Deserted Daughter

Afterpiece Title: Windsor Castle 1

Afterpiece Title: Windsor Castle 2

Performances

Mainpiece Title: The Follies Of A Day

Afterpiece Title: The Irish Widow

Afterpiece Title: A Masque, In Honor of the Nuptials of His Royal Highness [the Prince of Wales with Caroline Princess of Brunswick on 8 April 1795]

Afterpiece Title: The Poor Soldier

Dance: In 3rd piece: a Grand Dance-Byrn, Holland, Mlle St.Amand, Mme Rossi

Song: End I 2nd piece: The Richmond Primrose Girl (Music by Spofforth-Poetry by William Pearce, Esq.) sung in character-Mrs Clendining

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: Cymon

Dance: In I: a Grand Masquerade-; the Minuet de la Cour and Allemande-Byrn, Mlle St.Amand; afterpiece to conclude with: Dance-

Song: End IV: the Funeral Procession of Juliet to the Monument of the Capulets, in which a favorite Elegy-; (composed by Dr Arne) Solemn Dirge-; Vocal Parts-Johnstone, Incledon, Bowden, Townsend, Haymes, Linton, Williamson, Blurton, Street, Abbot, Holland, Rees, Lee, Little, Sawyer, Tett, Mrs Mountain, Mrs Clendining, Miss Stuart, Mrs Lloyd, Mrs Follett, Mrs Castelle, Miss Kirton, Mrs Masters, Miss Ives, Mrs Blurton, Mrs Norton, Mrs Watts, Miss Leserve, Miss Walcup, Mrs Martyr

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: My Grandmother

Song: In II: Alexander's Triumphal Entry into Babylon-; The Grand Chorus of Priests Youths Virgins-Bannister, Sedgwick, Dignum, Wathen, Welsh, Wentworth, Trueman, Cooke, Danby, Evans, Fisher, Master Welsh, Master DeCamp, Master Gregson, Mrs Bland, Miss Leak, Miss DeCamp, Miss Arne, Miss Mellon, Mrs Bramwell, Mrs Boimaison, Mrs Maddocks, Miss Menage, Miss Jackson, Miss Granger, Miss Chatterley, Miss Wentworth, Mrs Butler

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: The Son-in-Law

Song: As17951123, but Grand Chorus of Priests Youths Virgins-_Cooke, _Danby, _Evans, _Fisher, Master _Welsh, Master _DeCamp, Master _Gregson, Miss _Chatterley, Miss _Wentworth, Mrs _Butler

Performances

Mainpiece Title: Speculation

Afterpiece Title: Harlequin's Treasure 0; or, Jewels New Set

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Lie Of The Day; Or, A Party At Hampton Court

Afterpiece Title: Catharine and Petruchio

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: Speculation

Afterpiece Title: Harlequin Captive

Song: As17960312

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Lie Of The Day

Afterpiece Title: Lock and Key

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Merry Wives Of Windsor

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Lie Of The Day

Afterpiece Title: Lock and Key

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Lad Of The Hills

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: King Henry The Fourth, First Part

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2

Performances

Mainpiece Title: The Widow Of Malabar

Afterpiece Title: The Doldrum

Afterpiece Title: Harlequin's Treasure 0

Afterpiece Title: Harlequin's Treasure 1

Afterpiece Title: Harlequin's Treasure 2