SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Farmer"/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: The Merry Wives Of Windsor

Afterpiece Title: The Farmer

Performances

Mainpiece Title: He Wou'd Be A Soldier

Afterpiece Title: The Farmer

Dance: End: The Piping Pedlar-

Performances

Mainpiece Title: The Provok'd Wife

Afterpiece Title: The Farmer

Dance: As17871129

Performances

Mainpiece Title: The Tender Husband; Or, The Accomplished Fools

Afterpiece Title: The Farmer

Dance: As17871029

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Farmer

Dance: As17871129

Performances

Mainpiece Title: The Inconstant; Or, The Way To Win Him

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Farmer

Dance: As17871129

Performances

Mainpiece Title: The Inconstant

Afterpiece Title: The Farmer

Dance: As17871029

Performances

Mainpiece Title: Alexander The Great

Afterpiece Title: The Farmer

Song: the Grand Triumphal Entry of Alexander into Babylon, as17871022; Vocal Parts, as17871022, but Bonville, +Janson, Mrs +Gray, Miss +Rowson, Miss +Paye, Mrs +Byrne, _Brown, Mrs _Morton, Miss _Blower

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Farmer

Dance: End: Mirth by Moonshine, as17870928, but _Ratchford, Mrs _Invill

Performances

Mainpiece Title: Much Ado About Nothing

Afterpiece Title: The Farmer

Dance: As17871107

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Farmer

Dance: End: As17880124

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Farmer

Dance: As17880121

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Farmer

Dance: As17871129

Performances

Mainpiece Title: The Man Of The World

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Farmer

Song: As17880204

Performances

Mainpiece Title: The Belle's Stratagem

Afterpiece Title: The Farmer

Dance: As17871129

Performances

Mainpiece Title: The Miser

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Ton

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Midnight Hour

Afterpiece Title: The Farmer

Afterpiece Title: Love a-la-Mode

Performances

Mainpiece Title: The Farmer

Afterpiece Title: Comus

Afterpiece Title: The Positive Man

Song: As17880310