SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "The Double Disappointment"/1)') GROUP BY eventid ORDER BY weight() desc, eventdate asc OPTION field_weights=(perftitleclean=150, performancetitle=100), ranker=wordcount

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Double Disappointment

Song: III: Sullivan

Dance: V: Comic Dance, as17480314

Performances

Mainpiece Title: King Lear And His Three Daughters

Afterpiece Title: The Double Disappointment

Dance: Cooke, Anne Auretti, Matthews, Mrs Addison

Performances

Mainpiece Title: The Merchant Of Venice

Afterpiece Title: The Double Disappointment

Dance: III: Savoyards, as17471215; IV: Pastoral Dance, as17480326

Performances

Mainpiece Title: Venice Preserved

Afterpiece Title: The Double Disappointment

Dance: III: Tambourine-Anne Auretti; V: Dutch Dance, as17471128

Performances

Mainpiece Title: The Fair Penitent

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: Macbeth

Afterpiece Title: The Double Disappointment

Music: II: Concerto on Bassoons-Monsieur Karmazin first time in England

Performances

Mainpiece Title: The Careless Husband

Afterpiece Title: The Double Disappointment

Dance: Several New Entertainments, particularly: Les Bucherons-M Devisse, M Ferrere; Le Matelot Basque, as17521005; Les Tonneliers de Strasburgh-Devisse, Mad Auretti, Piettro, Miss Rayner

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Double Disappointment

Dance: Several entertainments-Devisse, Mad Auguste, Ferrere, Mad Auretti

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Double Disappointment

Dance: II: A Dutch Dance, as17521125; IV: The Hungarian Peasants, as17521125

Performances

Mainpiece Title: Don Sebastian, King Of Portugal

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: The Rehearsal

Afterpiece Title: The Double Disappointment

Dance: As17521208

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: Love's Last Shift

Afterpiece Title: The Double Disappointment

Dance: New Dance call'd% The Italian Gardeners-Devisse, Mlle Auguste; The Hungarian Peasants, as17521125

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: The Non-juror

Afterpiece Title: The Double Disappointment

Dance: II: A Hornpipe-the Little Swiss; V: L'Entree de Flore, as17521122

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Double Disappointment

Dance: Mlle Auretti

Performances

Mainpiece Title: The Suspicious Husband

Afterpiece Title: The Double Disappointment

Song: I: Cymon and Iphigenia a Cantata by Mr Arne-Beard; II: The School of Anacreon a New Cantata by Arne-Beard; IV: (By Desire) The Lass of the Mill-Beard; accompany'd on the Harp-Mr Parry

Music: III: A Piece on the Welch Harp-Parry

Performances

Mainpiece Title: Every Man In His Humour

Afterpiece Title: The Double Disappointment

Dance: I: Les Caprices de la Dance-Mlle Auretti; II: A Hornpipe-Matthews, a child of five years old his scholar; IV: The Matelot Basque-Mons Ferrere; V: The Louvre, Minuet-M Devisse, Mlle Auretti

Ballet: III: La Chacone des Characters. Harlequin-Mlle Auretti; Punch-Devisse; The Peasant-Mons Gerard (from Paris)

Performances

Mainpiece Title: Merope

Afterpiece Title: The Double Disappointment

Performances

Mainpiece Title: King Richard Iii

Afterpiece Title: The Double Disappointment

Song: Wilder

Performances

Mainpiece Title: The Conscious Lovers

Afterpiece Title: The Double Disappointment

Dance: II: A Comic Dance-Morris, Miss Shawford; IV: A Hornpipe-Morris; V: Minuet-Morris, Miss Shawford

Performances

Mainpiece Title: The Relapse

Afterpiece Title: The Double Disappointment

Dance: III: A Hornpipe-Walker; V: A Comic Dance, as17530514

Song: II: Wilder; IV: Love's a sweet passion-Wilder

Performances

Mainpiece Title: Love For Love

Afterpiece Title: The Double Disappointment

Song: II: Wilder

Dance: V: A Comic Dance, as17530514