SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Happy Constancy"/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 Rehearsal

Afterpiece Title: The Fortune Tellers

Song: I: Bright Author of my Present Flame-Lowe; II: Happy Pair-Beard,

Dance: III: A Dutch Dance, as17411114; IV: Sailor's Dance, as17411015; V: The Swiss, as17410926

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Shipwrecked

Song: I: The Early Horn-Lowe; III: Happy Pair-Beard

Dance: II: A Dutch Dance, as17411114; IV: A New Dance The Italian Peasants-the Mechels

Performances

Mainpiece Title: The Double Gallant

Afterpiece Title: Harlequin Shipwrecked

Song: I: Early Horn-Lowe; III: Happy Pair-Beard

Dance: II: Sailor's Dance, as17411015; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: Cato

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: Was ever Nymph like Rosamund-Beard

Dance: II: a Tambourine-Mlle Mechel; IV: Les Matelotes, as17411110, but-the Mechels

Performances

Mainpiece Title: Love Makes A Man

Afterpiece Title: Harlequin Shipwrecked

Song: II: Noontide Air-Lowe; IV: Happy Pair-Beard

Dance: I: Sailor's Dance, as17411015; III: The Swiss, as17410926

Performances

Mainpiece Title: The Twin Rivals

Song: I: New Ballad-Lowe; III: Happy Pair-Lowe

Dance: II: Le Boufon, as17411030; IV: Les Jardiniers Suedois, as17411128

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: Harlequin Shipwrecked

Song: I: New Ballad-Lowe; III: Happy Pair-Lowe

Dance: II: Dutch Dance-Philips, Miss Scott; V: The Swiss-M Mechell, Mlle Mechell

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; II: Early Horn-Lowe

Dance: III: The Drunken Peasant, as17411029; IV: A Dutch Dance, as17411114; V: The Swiss, as17410926

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fortune Tellers

Song: I: Happy Pair-Beard; III: Early Horn-Lowe

Dance: II: A Dutch Dance, as17411114; IV: Matelote Polonnes-Mechel

Performances

Mainpiece Title: As You Like It

Afterpiece Title: Harlequin Shipwrecked

Dance: I: The French Peasants-the Mechels; III: A Dutch Dance, as17411114; IV: Les Matelotes, as17411208

Song: II: Happy Pair-Beard

Performances

Mainpiece Title: Love For Love

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: A Ballad-Lowe

Dance: II: A Sailor's Dance, as17411015; IV: The Swiss-the Mechels

Performances

Mainpiece Title: The Spanish Friar

Song: I: Happy Pair-Beard; III: Bright Author of my Present Flame-Lowe

Dance: II: Le Boufon, as17411030; V: Le Genereux Corsaire, as17411214

Performances

Mainpiece Title: Hamlet

Afterpiece Title: Harlequin Shipwrecked

Song: I: Happy Pair-Beard; III: a Ballad-Lowe

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Committee

Afterpiece Title: The Devil to Pay

Song: I: Was ever Nymph like Rosamond-Beard; III: Happy Pair-Beard

Dance: II: A Concerto, as17420105; IV: The Italian Peasants, as17411205

Performances

Mainpiece Title: The Happy Captive

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: Harlequin Shipwrecked

Song: I: a Ballad-Lowe; III: Happy Pair-Beard

Dance: II: The French Peasants, as17420116; IV: The Swiss, as17420119

Performances

Mainpiece Title: The Alchemist

Song: I: See from the Silent Groves-Beard; IV: Happy Pair-Beard

Dance: II: Les Arlequins-the Fausans; V: Les Matelotes, as17411110

Performances

Mainpiece Title: The Tender Husband

Song: I: Was Ever Nymph like Rosamond-Beard; IV: Happy Pair-Beard

Dance: II: Les Arlequins, as17420212; V: Le Genereux Corsaire, as17420120, but Desse, +Baudoin, _Delemain, Miss _Rayner, Miss _Wright

Performances

Mainpiece Title: All's Well That Ends Well

Song: I: Happy Pair-Beard; III: Bright Author of my Present Flame-Lowe

Dance: II: Le Boufon, as17411030; V: Les Matelotes, as17411110

Performances

Mainpiece Title: The Merchant Of Venice

Dance: II: Les Egyptiens, as17420224

Song: II: Happy Pair-Beard; IV: Early Horn-Beard

Ballet: V: Les Satires Puny. As17420304

Performances

Mainpiece Title: As You Like It

Dance: I: A Concerto, as17420105; III: The Swiss, as17410926; V: Le Boufon, as17411030

Song: II: See from the Silent Groves-Beard; IV: Happy Pair-Beard

Performances

Mainpiece Title: The Relapse

Afterpiece Title: The Devil to Pay

Song: I: Celia has Ten thousand charms-Beard; III: Bright Author of my Present Flame-Lowe; IV: Happy Pair-Lowe

Dance: II: A Concerto, as17420105; V: The French Peasants, as17420116

Performances

Mainpiece Title: The Recruiting Officer

Afterpiece Title: The Cooper Outwitted; or, Harlequin Happy

Song: I: Bumper Squire Jones-Beard; III: The Early Horn-Lowe

Dance: II: Le Boufon, as17420325 IV: The Drunken Peasant-Phillips

Performances

Mainpiece Title: Cato

Afterpiece Title: The King and the Miller of Mansfield

Song: II: Happy Pair-Beard; IV: Bumper Squire Jones-Beard

Dance: I: Running Footman's Dance, as17420428 V: a Hornpipe-Philips

Performances

Mainpiece Title: The Provoked Husband

Afterpiece Title: The King and Miller of Mansfield

Song: I: Let me wander not unseen-Beard; III: Happy Pair-Beard; V: Ellen@a@Roon-Mrs Clive

Dance: II: a Dutch Dance-Phillips; IV: A Hornpipe-Phillips