SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Medley" | "Hippisleys Drunken Man" | "The Medley or Hippisleys Drunken Man" | "Hobs Opera" | "Flora an Opera" | "Hobs Opera" | "A Journey to Bristol" | "The Faithful Welshman" | "A Journey to Bristol" | "The Honest Welch man" | "A Journey to Bristol or The Faithful Welshman" | "Sequel to the Opera of Flora" | "Hobs Wedding" | "A Sequel to the Opera of Flora")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION
Results not only include performances of plays known to be by 'John Hippisley', but also performances of associated titles, including adaptations.

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Deuce Is in Him

Dance: II: Double Hornpipe-Walker, Miss Tetley; End: The Medley, as17641120

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Deuce Is in Him

Dance: End: The Medley, as17641120

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: High Life below Stairs

Dance: End: The Medley, as17641120

Performances

Mainpiece Title: Othello

Afterpiece Title: The Shepherd's Artifice

Dance: II: A Medley Hornpipe, as17650430 End: Rural Love, as17641212

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: Midas

Dance: II: A Medley Hornpipe-Miss Pitt; End: The Sicilian Peasants, as17660311

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Elopement

Dance: III: The Wake, as17680220; IV: By Particular Desire, The Medley (Not perform'd these 3 years)-Shuter, Mrs King

Entertainment: End: Linco's Travels-King with his Particular remarks on London

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Hermit

Related Works
Related Work: The London Hermit; or, Rambles in Doresetshire Author(s): John O'Keeffe

Dance: End: The Medley, as17680416

Entertainment: End: Mr King for that night only will entertain the Audience with a Picture of the Playhouse, or Bucks Have at Ye All-Mr King

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Queen Mab

Dance: II: The Wake, as17680220; IV: The Medley, as17680416

Performances

Mainpiece Title: Theodosius

Afterpiece Title: Like Master Like Man

Related Works
Related Work: Like Master Like Man Author(s): John Vanbrugh

Music: II: By Desire, Concert on Harpsichord-Master Love

Dance: III: The Medley, as17680416

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Absent Man

Dance: End: The Medley, as17680416

Performances

Mainpiece Title: The Orphan

Afterpiece Title: A Peep behind the Curtain

Entertainment: End of play: Linco's Travels (for that Night Only)-King

Dance: End of Interlude: The Medley, as17680416

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Deuce Is in Him

Song: I: A Trio-Vernon, Miss Young, Mrs Dorman; End: The Albion Song-Vernon

Dance: II: A Minuet-Tassoni, Miss Granier , his Apprentice; IV: The Medley-Tassoni, Mrs King

Performances

Mainpiece Title: Othello

Afterpiece Title: Daphne and Amintor

Dance: IV: The Medley-Shuter, Mrs King

Performances

Mainpiece Title: The Stratagem

Afterpiece Title: High Life below Stairs

Dance: IV: The Medley, as17680505

Performances

Mainpiece Title: The School For Lovers

Afterpiece Title: Like Master Like Man

Related Works
Related Work: Like Master Like Man Author(s): John Vanbrugh

Dance: II: By Desire A Minuet, as17680504; End: The Medley, as17680505

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: The Lyar

Dance: III: A Double Hornpipe-Walker, Miss Tetley; End: The Medley, as17680505

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Absent Man

Dance: End: The Medley, as17680416

Performances

Mainpiece Title: The Clandestine Marriage

Afterpiece Title: The Minor

Dance: I: The English Gardeners, as17691206

Entertainment: End: Bucks have at ye all-Palmer

Ballet: IV: A New Medley Dance (1st time) call'd the May Day Garland. Tinker-Atkins; Housemaid-Mrs King

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Elopement

Dance: III: The Medley-scholars of Giorgi

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Miss in Her Teens

Dance: II: The Medley-Scholars of Giorgi

Performances

Mainpiece Title: Romeo And Juliet

Afterpiece Title: The Ladies' Frolick

Dance: III: The Medley-Scholars of Giorgi

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Ladies' Frolick

Dance: The Medley-Scholars of Giorgi

Performances

Mainpiece Title: A Cure For Dotage

Entertainment: Singing-Miss Catley; Medley Cantata-Reinhold, By Particular Desire after the first part; Musical Imitations-Bannister; Song (By Desire) Water Parted from the Sea, after the manner of the original-Miss Catley; Concerto on Organ-Reinhold; Solo on Violin-Reeves

Performances

Mainpiece Title: The Coquet

Entertainment: Medley Cantata-Reinhold; Musical Imitations-Bannister; Singing With Horns and With Hounds, The Soldier Tir'd the favourite song in Comus,-Miss Catley; Sweet Echo-Miss Catley the echo by, a young Gentleman

Performances

Mainpiece Title: The Maid Of Bath

Afterpiece Title: The Virgin Unmask'd

Dance: End: The Medley-scholars of Giorgi