SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "At Hay The Country Girl"/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: La Generosita D'alessandro

Dance: End I: Divertisement, Pas Russe- [See17900422 at hay]; in which the Minuet de la Cour and Gavot-Labourie, Mlle Hilligsberg; End Opera: La Begere des Alpes [See17900107 at hay]-; Dancing-Labourie, Mlle Hilligsberg

Performances

Mainpiece Title: L'usurpator Innocente

Dance: End I: Divertisement, as17900515 at hay; End Opera: La Bergere des Alpes, as17900107 at hay; after which a variety of new Dances-

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Liar

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Sultan; or, A Peep into the Seraglio

Dance: In afterpiece: Grand Dance-Hamoir, Miss Blanchet

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Fairy Favour

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Fairy Favour

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Pannel

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Citizen

Dance: End: As17910429

Song: End II: song-Sedgwick

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: Poor Old Drury

Afterpiece Title: The Country Girl

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Cave of Trophonius

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The First Floor

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Doctor and the Apothecary

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Apprentice

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Village Coquette

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Who's the Dupe

Afterpiece Title: The Deserter of Naples; or, Royal Clemency

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: Who's the Dupe

Song: End I: song-a Young Lady; End II: song-Incledon; End III: song-a Lady; End IV: song-Johannot

Entertainment: Monologues End: Roxana's Epilogue-; British Loyalty; or, A Squeeze to St. Paul's-Lyon

Performances

Mainpiece Title: At King's The Country Girl

Afterpiece Title: Richard Coeur de Lion

Performances

Mainpiece Title: At King's The Country Girl

Afterpiece Title: The Mariners

Performances

Mainpiece Title: The Country Girl

Afterpiece Title: The Fairy Favour