SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "A Medley Concert And Auction"/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: Concert

Dance: Miss Capitani, Master Rogers

Performances

Mainpiece Title: A Concert Of Vocal And Instrumental Musick

Music: FFirst Violin solo-Barthelemon; Violincello Concerto-Ciri; Harpsichord and Organ-Miss Mozart, Master Mozart

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: The Genii

Dance: II: A New Entertainment call'd The Medley-Slingsby, Miss Baker

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Genii

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Deuce is in Him

Dance: End: The Medley, as17641120

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The Genii

Dance: III: The Medley, as17641120

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Queen Mab

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: Queen Mab

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Queen Mab

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: The London Merchant

Afterpiece Title: Queen Mab

Dance: III: The Medley, as17641120

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: Queen Mab

Dance: III: The Medley, as17641120

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Queen Mab

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: All In The Wrong

Afterpiece Title: Queen Mab

Dance: I: The Irish Lilt, as17641011; III: The Medley, as17641120

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: Queen Mab

Dance: III: The Medley, as17641120

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Queen Mab

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: The Miser

Afterpiece Title: Queen Mab

Dance: II: The Millers-Grimaldi, Lauchery, Sga Giorgi, Miss Baker; IV: The Medley, as17641120

Performances

Mainpiece Title: The Platonic Wife

Afterpiece Title: The Lying Valet

Dance: II: A Comic Dance, as17641213; IV: The Medley, as17641120

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Rites of Hecate

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The Tutor

Dance: End: The Medley, as17641120

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Queen Mab

Dance: II: The Medley, as17641120

Performances

Mainpiece Title: The Jealous Wife

Afterpiece Title: Polly Honeycombe

Dance: II: The Irish Lilt, as17641011; End: The Medley, as17641120

Performances

Mainpiece Title: Concert

Performances

Mainpiece Title: The Rival Queens

Afterpiece Title: The Fairy Tale

Dance: I: A New Dance call'd The Irish Milkmaids-Miss Ford; End: The Medley, as17641120

Performances

Mainpiece Title: The Orphan

Afterpiece Title: The Choice

Dance: I: The Medley, as17641120; End: The Irish Lilt, as17641011

Performances

Mainpiece Title: King Lear

Afterpiece Title: The Capricious Lovers

Dance: I of Entertainment: The Irish Milkmaids, as17650321 End: The Medley, as17641120