SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "G"/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: She Wou'd And She Wou'd Not

Afterpiece Title: My Grandmother

Dance: End: La Provencale-Fialon, G. D'Egville, Mrs Fialon, Miss F. D'Egville, Miss Menage

Song: End II: a favourite song (composed by Ross)-Master Welsh

Performances

Mainpiece Title: The Messiah; Alexander's Feast; Grand Selection 0

Music: End Part I: 3rd concerto of Giardini on the violin-G. Ashley; End Part II: concerto on the Piano Forte-Dussek

Performances

Mainpiece Title: A 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

Music: End Part I: concerto on the violin-G. Ashley; End Part II: concerto on the Grand Piano Forte-Miss M'Arthur

Performances

Mainpiece Title: The Messiah; Grand Selection 0

Music: End Part I: concerto on the violin-G. Ashley

Performances

Mainpiece Title: The Village Fete

Afterpiece Title: The School for Wives

Afterpiece Title: Oscar and Malvina

Song: In: Chorusses, as17970518; End II 2nd piece: The Sea Storm by G. A. Stevens (Cease rude Boreas blust'ring railer)-; End IV: Black Ey'd Susan-Incledon; In 3rd piece: Come every jovial Fellow-Gray, Mrs Martyr, Mrs Mountain; O ever in my bosom live-Mrs Martyr, Mrs Mountain

Entertainment: End 2nd piece: a variety of Imitations-Rees (1st appearance this season [i.e. as imitator])

Performances

Mainpiece Title: Acis And Galatea 0

Afterpiece Title: Acis and Galatea 3 [i

Music: End I: serenata concerto on violin-G. Ashley; End II: a new concerto, with a military rondo, on the Grand Piano Forte-Dussek

Performances

Mainpiece Title: A 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

Music: End II: Bach's concertante for violin oboe viola and violoncello-Messrs [G., R. and C.] Ashley, W. Parke

Performances

Mainpiece Title: The Way To Get Married

Afterpiece Title: The Vanguard

Afterpiece Title: The Virgin Unmask'd

Song: End II: The Storm-Incledon (written by G. A. Stevens); Black Ey'd Susan-Incledon; Sally in our Alley-Incledon

Entertainment: Monologue End: An Occasional Address-H. Johnston; Imitations-Rees

Performances

Mainpiece Title: Alexander's Feast 0; The Messiah; Grand Selection 0

Afterpiece Title: Alexander's Feast 3

Music: End II: a concertante for violin oboe tenor and violoncello-G. Ashley, W. Parke, R. Ashley, C. Ashley

Performances

Mainpiece Title: The Creation; Grand Selection 0

Music: End I: concerto on the Grand Piano Forte-Master Neate; End II: cobcerto on the violin-G. Ashley

Performances

Mainpiece Title: The Woodman

Afterpiece Title: The Rendezvous

Afterpiece Title: The Jew and the Doctor

Song: End I: The Storm (by G. A. Stevens)-Incledon; In course Evening: an entire new Glee, composed by King, The Witches[, the Words from the First Scene of Shakspeare's Macbeth, -Incledon, Townsend, Linton, Chorus; [Also Black Ey'd Susan-; Old Towler- [Incledon]

Performances

Mainpiece Title: Douglas

Afterpiece Title: Lovers' Quarrels

Afterpiece Title: The Deserter of Naples

Entertainment: Vaudeville In course Evening: an entire New Song, The Seaman's Lamentation for the Loss of the Royal Charlotte (The Words by G. S. Carey, and composed by Mazzinghi)-Incledon; Dancing-Mr and Master Michell (from the Theatre Royal, Edinburgh; 1st appearance)

Performances

Mainpiece Title: Theodosius

Dance: g's The German Camp-Salomon, Mlle Violette, Mechel, Salomon's Son; The Vintage-Salomon, Mlle Violette, Muilment, Mechel