SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "How To Be Happy"/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: 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

Performances

Mainpiece Title: The Indian Merchant; Or, The Happy Pair; Interspers'd With The Comical Humours Of The intriguing Chambermaid, sir John Oldcastle, And The drunken Colonel

Afterpiece Title: The Miser Bit; or, Harlequin Reveller

Song: I: Bumper Squire Jones-Phillips

Dance: LLa Mason and Sabotiers-Phillips, Mrs Dove

Performances

Mainpiece Title: The Indian Merchant; Or, The Happy Pair

Afterpiece Title: The Miser Bit; or, Harlequin Reveller

Dance: LLes Masons and Sabotiers-Phillips, Mrs Dove

Performances

Mainpiece Title: The Merchant Of Venice

Music: I: a Concerto-Veracini

Song: III: Happy Pair-Lowe

Dance: II: Tyrolean Dance, as17420921; V: Peasant Dance, as17420921

Performances

Mainpiece Title: The Rival Lovers; Or, An Old Man Taught Wisdom

Afterpiece Title: Harlequin Happy at Last

Performances

Mainpiece Title: The Old Batchelor

Afterpiece Title: Old Man Taught Wisdom

Dance: TThe Happy Lovers-Villeneuve, Mrs Delagarde; A New Dance call'd La Villageoise-Dumont, Mlle Auguste, Mrs Delagarde

Performances

Mainpiece Title: The Spanish Fryar; Or, The Double Discovery

Afterpiece Title: Old Man Taught Wisdom

Dance: TThe Happy Lovers, as17421006; La Villageoise, as17421006; Harlequin Dance-Villeneuve, Mlle Auguste