SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "three eldest Princesses"/1) | (@(roleclean,performerclean) "three eldest Princesses")') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=100, commentpclean=75, commentcclean=75, roleclean=100, performerclean=100, authnameclean=100), ranker=sph04

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?
We found 1260 matches on Event Comments, 484 matches on Performance Title, 175 matches on Performance Comments, 0 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Three Weeks after Marriage

Dance: As17841201

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Dance: As17850416

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Lawyers' Panic

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Capricious Lady

Afterpiece Title: Three Weeks after Marriage

Dance: As17850409

Song: In Act II of mainpiece a favourite glee by Davies, Cubitt, Doyle, Darley

Performances

Mainpiece Title: The Way To Keep Him

Afterpiece Title: Three Weeks after Marriage

Dance: End of mainpiece Leap Year, as17851010

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: Three Weeks after Marriage

Dance: As17851112

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: Three Weeks after Marriage

Dance: As17851112

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Dance: As17851112

Performances

Mainpiece Title: The Hypocrite

Afterpiece Title: Three Weeks After Marriage

Dance: As17851103

Performances

Mainpiece Title: The Beaux Stratagem

Afterpiece Title: Three Weeks after Marriage

Dance: As17851007

Performances

Mainpiece Title: Venice Preserv'd

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Mourning Bride

Afterpiece Title: Three Weeks after Marriage

Dance: End of mainpiece The Poney Races [performers not listed]

Performances

Mainpiece Title: Richard Coeur De Lion

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Dance: End: The Wapping Landlady-Blurton, Rayner, Miss Cranfield

Performances

Mainpiece Title: The Chapter Of Accidents

Afterpiece Title: Three Weeks after Marriage

Dance: After Monologue: The Wapping Landlady, as17870131

Entertainment: Monologue End: Lingo's Opinions on Men and Manners, as17870410

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: Three Weeks after Marriage

Dance: As17871029

Performances

Mainpiece Title: Marian

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: The Farmer

Performances

Mainpiece Title: The Highland Reel

Afterpiece Title: Three Weeks after Marriage

Dance: End: a New Dance-Byrne, Mrs Ratchford, Mrs Goodwin

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: The Death of Captain Cook

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Tender Husband

Afterpiece Title: The Death of Captain Cook

Afterpiece Title: Three Weeks after Marriage

Performances

Mainpiece Title: The Beggar's Opera

Afterpiece Title: Three Weeks after Marriage

Afterpiece Title: Don Juan

Dance: In 3rd piece: Dancing, as17890601

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Dance: As17891021

Performances

Mainpiece Title: Rule A Wife And Have A Wife

Afterpiece Title: Three Weeks after Marriage

Dance: As17891125

Performances

Mainpiece Title: The Czar

Afterpiece Title: Three Weeks after Marriage

Song: III: The Prince unable to conceal his Pain, from Alexander's Feast-Mrs Billington. [This was included, as here assigned, in all subsequent performances.

Performances

Mainpiece Title: The Woodman

Afterpiece Title: Three Weeks after Marriage