SELECT * FROM london_stages WHERE MATCH('(@(authnameclean,perftitleclean,commentcclean,commentpclean) "2 young Princesses"/1) | (@(roleclean,performerclean) "2 young 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 3282 matches on Performance Comments, 3129 matches on Event Comments, 1063 matches on Performance Title, 750 matches on Author, and 0 matches on Roles/Actors.

Performances

Mainpiece Title: L'allegro Ed Il Penseroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Penseroso 1

Afterpiece Title: L'Allegro ed il Penseroso 2

Afterpiece Title: A Grand Miscellaneous Act

Music: End I: 1st concerto , Op. 3, by Geminiani-G. Ashley

Performances

Mainpiece Title: Idalide

Dance: End I: Amphion et Thalie, as17910409; End Opera: an entire new Ballet in 2 acts (composed by D'Auberval), La Fille Mal Gardee-See17910610

Performances

Mainpiece Title: Redemption 0, Selected From The Works Of handel By dr Arnold

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: End I: concerto on the bassoon-Parkinson; End II: concerto on the violin-Master Bridgetower

Performances

Mainpiece Title: Acis And Galatea 0; Redemption 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: A Miscellaneous Act

Music: End I: concerto on the hautboy-[J.] Parke

Performances

Mainpiece Title: The First Grand Selection 0 Of Sacred Music From The Works Of handel; L'allegro Ed Il Pensieroso 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Acis And Galatea 0; Redemption 0

Afterpiece Title: Acis and Galatea 1

Afterpiece Title: Acis and Galatea 2

Afterpiece Title: A Grand Miscellaneous Act

Music: As17920229

Performances

Mainpiece Title: Alexander's Feast 0; Redemption 0; L'allegro Ed Il Pensieroso 0

Afterpiece Title: Alexander's Feast 1

Performance Comment: 'Twas at the royal feast-Harrison; Happy happy pair-Harrison, Chorus; Timotheus placed on high-Harrison; The song began from Jove-Mrs Second; The list'ning croud-Chorus; With ravish'd ears-Mrs Second; The praise of Bacchus-Harrison; Bacchus ever fair and young-Bartleman; Bacchus' blessings-Chorus; Sooth'd with the sound-Harrison; He chose a mournful muse, He sung Darius-Mrs Billington; With downcast looks the joyless victor sat, Behold Darius great and good-Chorus; The mighty master, Softly sweet in Lydian measure-Mrs Billington; War he sung-Mrs Second; The many rend the skies-Chorus; The prince unable-Mrs Billington; The many rend the skies [repeated]-Chorus.

Afterpiece Title: Alexander's Feast 2

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Second Grand Selection 0 Of Sacred Music From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0

Afterpiece Title: L'Allegro ed il Pensieroso 1

Cast
Role: And young and old Actor: Chorus.

Afterpiece Title: L'Allegro ed il Pensieroso 2

Cast
Role: And young and old Actor: Chorus.

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: Redemption 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Music: As17920229

Performances

Mainpiece Title: A Grand Selection 0of Favourite Songs And Chorusses From The Works Of handel

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0 Principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Cast
Role: And young and old Actor: Chorus

Afterpiece Title: Grand Selection 2

Cast
Role: And young and old Actor: Chorus

Afterpiece Title: Grand Selection 3

Cast
Role: And young and old Actor: Chorus

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso 0; Grand Selection 0

Afterpiece Title: L'Allegro ed il Pensieroso 1

Cast
Role: And young and old Actor: Chorus.

Afterpiece Title: L'Allegro ed il Pensieroso 2

Cast
Role: And young and old Actor: Chorus.

Afterpiece Title: Grand Miscellaneous Act

Performances

Mainpiece Title: A Grand Selection 0principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0principally From The Works Of handel; Redemption 0

Afterpiece Title: Grand Selection 1

Performance Comment: Overture (Esther)-; Tyrants-Mrs Crouch, Chorus [Athalia]; How willing-Sedgwick (Samson); What's sweeter-Miss Hagley, Dignum (Joseph); Let me wander, Or let the merry bells-Master Welsh; And young and old-Chorus (L'Allegro); The Prince-Mrs Bland (Alexander's Feast); Deeper and-Kelly; Waft her angels-Chorus (Jephtha); Lord in thee-Incledon, Chorus (Te Deum).
Cast
Role: And young and old Actor: Chorus

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: End II: Mad Bess-Mrs Crouch (Purcell)

Performances

Mainpiece Title: L'allegro Ed Il Pensieroso

Afterpiece Title: L'Allegro ed il Pensieroso 1

Cast
Role: And young and old Actor: Chorus.

Afterpiece Title: L'Allegro ed il Pensieroso 2

Cast
Role: And young and old Actor: Chorus.

Afterpiece Title: Grand Miscellaneous Act

Cast
Role: And young and old Actor: Chorus.

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Afterpiece Title: The Messiah 1

Afterpiece Title: The Messiah 2

Afterpiece Title: The Messiah 3

Song: End Part I: Captivity (supposed to be sung by the unfortunate Marie Antoinette, Queen of France, during her confinement in the Tower of the Temple; composed by Percy)-Master Welsh

Music: End Part II: concerto on the violin-Janiewicz

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Song: As17930220

Music: End Part II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: A Grand Selection 0

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Performances

Mainpiece Title: Redemption; Grand Selection 0

Afterpiece Title: Redemption 1

Afterpiece Title: Redemption 2

Afterpiece Title: Redemption 3

Performances

Mainpiece Title: A Grand Selection 0 Of Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3

Song: In Part III: Captivity-Mrs Crouch [, as17930220

Music: End Part I: concerto on the violoncello-C. Ashley

Performances

Mainpiece Title: A Grand Selection 0 Of Sacred Music

Afterpiece Title: Grand Selection 1

Afterpiece Title: Grand Selection 2

Afterpiece Title: Grand Selection 3