SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Rival Soldiers"/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: Every One Has His Fault

Afterpiece Title: The Rival Soldiers

Afterpiece Title: The Positive Man

Song: In the course of the Evening: The Life of Poor Jack (composed by Dibdin), Admiral Benbow-Incledon; Honesty in Tatters-Townsend; Arthur O'Bradley (1st time, written by O'Keeffe)-Munden

Performances

Mainpiece Title: Half An Hour After Supper

Afterpiece Title: The Chapter of Accidents

Afterpiece Title: The Rival Soldiers

Performances

Mainpiece Title: The Rival Soldiers

Afterpiece Title: Rule a Wife and Have a Wife

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: Inkle And Yarico

Afterpiece Title: The Rival Soldiers

Afterpiece Title: The Honest Thieves

Song: In I 1st piece: the original Duet-Mr and Mrs Pope

Entertainment: Monologue. End 2nd piece: [Collins' Ode on the Passions-Mrs Pope (1st and only Time [see17980515])

Performances

Mainpiece Title: The Rival Ladies

Performances

Mainpiece Title: The Rival Ladies

Performances

Mainpiece Title: The Rivals

Performances

Mainpiece Title: The Rivals

Performances

Mainpiece Title: The Rivals

Performances

Mainpiece Title: The Rivals

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Performances

Mainpiece Title: The Rival Kings; Or, The Loves Of Oroondates And Statira

Performances

Mainpiece Title: The Rival Queens; Or, Alexander The Great

Performances

Mainpiece Title: The Soldier's Fortune

Performances

Mainpiece Title: The Soldier's Fortune

Performances

Mainpiece Title: The Rival Queens; Or, Alexander The Great

Performances

Mainpiece Title: The Soldiers' Fortune

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Performances

Mainpiece Title: The Rival Queens; Or, Alexander The Great

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Performances

Mainpiece Title: The Rival Sisters; Or, The Violence Of Love

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Performances

Mainpiece Title: The Rival Queens; Or, The Death Of Alexander The Great

Performances

Mainpiece Title: The Rival Queens