SELECT * FROM london_stages WHERE eventid IN (44937, 44942, 44947, 44962, 44967, 44976, 44981, 44987, 44999, 45005, 45014, 45033, 45042, 45046, 45052, 45058, 45061, 45066, 45072, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45322, 45331, 45336, 45345, 45350, 45357, 45362, 45366, 45370, 45375, 45382, 45387, 45391, 45395, 45400, 45404, 45408, 45413, 45417, 45421, 45426, 45430, 45434, 45447, 45452, 45467, 45507, 45527, 45545, 45570, 45585, 45598, 47251, 47268, 47281, 47293, 47311, 47325, 47328, 47333, 47337, 47348, 47351, 47355, 47359, 47365, 47369, 47372, 47377, 47711, 47726, 47741, 47756, 47761, 47771, 47776, 47804, 48195, 48230, 48240, 48253, 48262, 48267, 48272, 48276, 48281, 48282, 48286, 48290, 48296, 48300, 48323, 48350, 48364, 48378, 48392, 48399, 48405, 48414, 48419, 48428, 48441, 48455, 48460, 48463, 48468, 48795, 48800, 48809, 48814, 48823, 48834, 48839, 48848, 48853, 48862, 48867, 48876, 48881, 48889, 48894, 48901, 48906, 48915, 48920, 48929, 48935, 48944, 48949, 48958, 48963, 48972, 49034, 49039, 49054, 49059, 49064, 49070, 49075, 49084, 49098, 49104, 49113, 49369, 49374, 49383, 49388, 49397, 49402, 49409, 49442, 49450, 49455, 49468, 49496, 49523, 49537, 49546, 49561, 49566, 49595, 49600, 49623, 49628, 49638, 49652, 49676, 49684, 49692, 49884, 49889, 49898, 49903, 49908, 49913, 50007, 50014, 50020, 50027, 50049, 50071, 50109, 50114, 50119, 50149, 50227, 50233, 50244, 50274, 50281, 50431, 50436, 50445, 50478, 50485, 50490, 50499, 50504, 50513, 50589, 50629, 50641, 50648, 50653, 50681, 50691, 50798, 50822, 50855, 51122, 51131, 51157, 51200, 51207, 51224, 51228, 51232, 51250, 51259, 51275, 51281, 51296, 51325, 51339, 51366, 51374, 51379, 51401, 51406, 51417, 51625, 51651, 51719, 51780, 51790, 51804, 51809, 51818, 51823, 51829, 51880, 51891, 51896, 51905, 51910, 51965, 51974, 51990, 51998, 52232, 52237, 52246, 52251, 52260, 52265, 52272, 52278, 52306, 52315, 52320, 52339, 52344, 52351, 52363, 52375, 52440, 52450, 52459, 52464, 52487, 52493, 52507, 52523, 52533, 52541, 52557, 52565, 52573) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: I Due Svizzeri

Dance: As18000513

Performances

Mainpiece Title: I Due Svizzeri

Dance: As18000513

Performances

Mainpiece Title: I Due Svizzeri

Afterpiece Title: Il Capriccio Drammatico

Dance: End: new Divertisement Bayadaire, as18000529; End 2nd piece: Rinaldo e Leonora- see18000624

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: The 1st Act of I Due Fratelli Rivali

Dance: As18000530

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: The 1st Act of I Due Fratelli Rivali

Dance: End: Le Mariage Mexicain, as18000225; End 2nd piece: Rinaldo e Leonora, as18000530

Performances

Mainpiece Title: I Due Svizzeri

Afterpiece Title: Il Principe Spazzacamino

Dance: End: Le Mariage Mexicain, as18000225; End 2nd piece: Telemaque- [see18000619 and 18000621

Performances

Mainpiece Title: I Zingari In Fiera

Dance: End I: Laura et Lenza, as18000513; End Opera: Rinaldo e Leonora-Deshayes, Laborie, Didelot, Mme Hilligsberg, Mme Laborie, Mlle Parisot

Performances

Mainpiece Title: I Due Svizzeri

Dance: End 1st piece: Laura et Lenza, as18000513; End 2nd piece: Telemaque, as18000619

Performances

Mainpiece Title: The 1st Act Of I Zingari In Fiera

Dance: End 1st piece: Le Mariage Mexicain, as18000225; End 2nd piece: Laura et Lenza, as18000628

Performances

Mainpiece Title: Il Capriccio Drammatico

Afterpiece Title: The last Act of I Due Fratelli Rivali

Dance: As18000715

Performances

Mainpiece Title: I Zingari In Fiera

Dance: End I: Divertisement, as18000508; End Opera: Rinaldo e Leonora, as18000712