SELECT * FROM london_stages WHERE MATCH('(@(perftitleclean,performancetitle) "First Violin Concerto"/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: Lodoiska

Afterpiece Title: HIGH LIFE BELOW STAIRS

Afterpiece Title: THE GLORIUS FIRST OF JUNE

Dance: As17940625

Performances

Mainpiece Title: Lodoiska

Afterpiece Title: THE LIAR

Afterpiece Title: THE GLORIOUS FIRST OF JUNE

Performances

Mainpiece Title: Lodoiska

Afterpiece Title: THE IRISH WIDOW

Afterpiece Title: THE GLORIOUS FIRST OF JUNE

Performances

Mainpiece Title: Lodoiska

Afterpiece Title: ALL THE WORLD'S A STAGE

Afterpiece Title: THE GLORIOUS FIRST OF JUNE

Performances

Mainpiece Title: Jane Shore

Afterpiece Title: The Glorious First of June

Song: In afterpiece: Choruses-Cooke, Danby, Lyons, Maddocks, Welsh, Mrs Bramwell, Miss Granger, Miss Chatterley

Performances

Mainpiece Title: King Henry The Eighth

Afterpiece Title: The Glorious First of June

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: In Part II: 1st concerto [of Geminiani]-G. Ashley

Performances

Mainpiece Title: The Messiah

Music: End Part II: 8th concerto of Corelli-

Performances

Mainpiece Title: First Love

Afterpiece Title: The Adopted Child

Performances

Mainpiece Title: First Love

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: First Love

Afterpiece Title: My Grandmother

Performances

Mainpiece Title: La Scola Dei Maritati

Afterpiece Title: Ati e Cibele

Dance: End I: L'Amant Retrouve, as17950120, but Mme Bossi [DelCaro], Mlle _Rosine [no other ballet listed]

Music: End II: concerto on the hautboy-Harrington

Performances

Mainpiece Title: First Love

Afterpiece Title: The Adopted Child

Performances

Mainpiece Title: The Bank Note

Afterpiece Title: The Death of Captain Faulknor

Afterpiece Title: Sprigs of Laurel

Song: In course of 2nd piece: As17950506; Incidental to 1st piece: The Irishman's Peep at the Continent-Johnstone; In course of entertainments: Black Eyed Susan-Incledon; Old Towler-Incledon

Music: 3rd piece: With the favorite Overture by Shield for Arrived at Portsmouth-; with a violin and oboe obligato-Mountain, W. Parke

Performances

Mainpiece Title: First Love

Afterpiece Title: No Song No Supper

Ballet: End: The Deserter. As17950520

Performances

Mainpiece Title: First Love

Afterpiece Title: The Adopted Child

Performances

Mainpiece Title: L'isola Del Piacere

Afterpiece Title: Le Nozze dei Contadini Spagnuoli

Dance: End II: Paul et Virginie, as17950411; In intermezzo: The Fandango-Mme DelCaro, Aumer

Music: End I: a concerto

Performances

Mainpiece Title: A Quarter Of An Hour Before Dinner

Afterpiece Title: First Love

Afterpiece Title: The Prize

Dance: End 2nd piece: New Dance-; in which The Princess of Wales's New Minuet and Gavot-J. and Miss D'Egville; and to conclude with a New Reel-Miss and Master Menage, Miss Phillips, Mrs Fialon, Miss S. and G. D'Egville

Performances

Mainpiece Title: First Love

Afterpiece Title: My Grandmother

Dance: End: As17950601 but New Reel-Mrs _Fialon

Performances

Mainpiece Title: First Love

Afterpiece Title: No Song No Supper

Performances

Mainpiece Title: First Love

Afterpiece Title: The Village Lawyer

Performances

Mainpiece Title: First Love

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: First Love

Afterpiece Title: Peeping Tom

Performances

Mainpiece Title: First Love

Afterpiece Title: The Prize

Performances

Mainpiece Title: First Love

Afterpiece Title: Lodoiska