<btc retrieved="Wed Nov 21 07:59:21 2012" parent-table="works" parent-id="BTC218"><record table="works" id="BTC218"><field name="work_id" type="int(11)"><value>217</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC218</value></field><field name="catno_numeric" type="int(11)"><value>218</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/sonata_1</value></field><field name="title" type="varchar(200)"><value>Sonata</value></field><field name="subtitle" type="varchar(200)"><value>For piano</value></field><field name="opus_no" type="varchar(20)"><value>J.Op 1</value></field><field name="other_opus_nos" type="varchar(200)"><value>J.OpC 2.1</value></field><field name="is_complete" type="tinyint(4)"><value>1</value></field><field name="genre" type="varchar(100)"><value>Solo piano</value></field><field name="composition_commenced" type="varchar(50)"><value>Oct 1924</value></field><field name="semantic_composition_commenced" type="int(11)"><value>219</value></field><field name="composition_completed" type="varchar(50)"><value>Nov 1924</value></field><field name="semantic_composition_completed" type="int(11)"><value>220</value></field><field name="notes" type="text"><value><p>This sonata comprises four earlier pieces: see individual movements for details.</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>1</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="year" type="varchar(4)"><value>1924</value></field><field name="composition_period" type="varchar(25)"><value> Oct -  Nov 1924</value></field><record table="sub_works" id="530" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>530</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="title" type="text"><value><p>[Allegro ma non troppo]</p></value></field><field name="position" type="int(11)"><value>1</value></field><field name="discarded" type="tinyint(4)"><value>0</value></field><field name="notes" type="text"><value><p>Uses <a href="http://www.brittenproject.org/works/work?id=116">Untitled piece in E flat major</a> (1923).</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>217/1</value></field><record table="incipits" id="430" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>430</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="sub_work_id" type="int(11)"><value>530</value></field><record table="incipit_resources" id="588" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>588</value></field><field name="incipit_id" type="int(11)"><value>430</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>217_1-incipit.jpg</value></field><field name="mime_type" type="varchar(20)"><value>image/jpeg</value></field><field name="sequence_number" type="int(11)"><value>1</value></field></record></record></record><record table="sub_works" id="531" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>531</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="title" type="text"><value><p>[Larghetto]</p></value></field><field name="position" type="int(11)"><value>2</value></field><field name="discarded" type="tinyint(4)"><value>0</value></field><field name="notes" type="text"><value><p>Uses <a href="http://www.brittenproject.org/works/work?id=126">Untitled piece in E flat minor</a> (1923).</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>217/2</value></field><record table="incipits" id="431" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>431</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="sub_work_id" type="int(11)"><value>531</value></field><record table="incipit_resources" id="589" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>589</value></field><field name="incipit_id" type="int(11)"><value>431</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>217_2-incipit.jpg</value></field><field name="mime_type" type="varchar(20)"><value>image/jpeg</value></field><field name="sequence_number" type="int(11)"><value>1</value></field></record></record></record><record table="sub_works" id="532" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>532</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="title" type="text"><value><p>[Allegro ma non troppo]</p></value></field><field name="position" type="int(11)"><value>3</value></field><field name="discarded" type="tinyint(4)"><value>0</value></field><field name="notes" type="text"><value><p>Uses <a href="http://www.brittenproject.org/works/work?id=82">Untitled piece in G flat major</a> (ca. 1923).</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>217/3</value></field><record table="incipits" id="432" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>432</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="sub_work_id" type="int(11)"><value>532</value></field><record table="incipit_resources" id="590" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>590</value></field><field name="incipit_id" type="int(11)"><value>432</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>217_3-incipit.jpg</value></field><field name="mime_type" type="varchar(20)"><value>image/jpeg</value></field><field name="sequence_number" type="int(11)"><value>1</value></field></record></record></record><record table="sub_works" id="533" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>533</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="title" type="text"><value><p>[Presto]</p></value></field><field name="position" type="int(11)"><value>4</value></field><field name="discarded" type="tinyint(4)"><value>0</value></field><field name="notes" type="text"><value><p>Uses <a href="http://www.brittenproject.org/works/work?id=193">Untitled piece in E flat major</a> (1924).</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>217/4</value></field><record table="incipits" id="433" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>433</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="sub_work_id" type="int(11)"><value>533</value></field><record table="incipit_resources" id="591" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>591</value></field><field name="incipit_id" type="int(11)"><value>433</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>217_4-incipit.jpg</value></field><field name="mime_type" type="varchar(20)"><value>image/jpeg</value></field><field name="sequence_number" type="int(11)"><value>1</value></field></record></record></record><record table="external_records" id="694" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>694</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="display_order" type="int(11)"><value>0</value></field><field name="external_id" type="varchar(100)"><value>BBM/sonata_1</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Sonata</p></value></field><field name="cache_id" type="int(11)"><value>694</value></field><field name="show_cache" type="tinyint(4)"><value>1</value></field><field name="hidden" type="tinyint(4)"><value>1</value></field><field name="datasource_name" type="varchar(100)"><value>ms-sources</value></field><field name="datasource_title" type="varchar(100)"><value>Manuscript Sources</value></field><record table="DS_ms_sources" id="694" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Sonata</value></field><field name="Subtitle" type="varchar(200)"><value>For piano</value></field><field name="OpusNo" type="varchar(30)"><value>J.Op 1
J.OpC 2.1</value></field><field name="RefNo" type="varchar(100)"><value>BBM/sonata_1</value></field><field name="Date" type="varchar(50)"><value>Oct-Nov 1924</value></field><field name="Description" type="text"><value><p>First movement from 'Untitled piece in E flat major[1]' of 1923. Second movement from 'Untitled piece in E flat minor ' of 1923. Third movement from 'Untitled piece in F sharp Major' of 1922. Fourth movement from 'Untitled piece in E flat major [27] (unfinished)' of 1924.</p></value></field><field name="Extent" type="varchar(50)"><value>2 items</value></field><field name="cache_id" type="int"><value>694</value></field><field name="external_record_id" type="int"><value>694</value></field><field name="record_id" type="varchar(100)"><value>BBM/sonata_1</value></field></record></record><record table="external_records" id="695" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>695</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="display_order" type="int(11)"><value>1</value></field><field name="external_id" type="varchar(100)"><value>BBM/sonata_1/1</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Holographs</p></value></field><field name="cache_id" type="int(11)"><value>695</value></field><field name="show_cache" type="tinyint(4)"><value>1</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="datasource_name" type="varchar(100)"><value>ms-sources</value></field><field name="datasource_title" type="varchar(100)"><value>Manuscript Sources</value></field><record table="DS_ms_sources" id="695" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Holographs</value></field><field name="RefNo" type="varchar(100)"><value>BBM/sonata_1/1</value></field><field name="Date" type="varchar(50)"><value>Oct-Nov 1924</value></field><field name="Extent" type="varchar(50)"><value>2 items</value></field><field name="cache_id" type="int"><value>695</value></field><field name="external_record_id" type="int"><value>695</value></field><field name="record_id" type="varchar(100)"><value>BBM/sonata_1/1</value></field></record></record><record table="external_records" id="696" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>696</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="display_order" type="int(11)"><value>2</value></field><field name="external_id" type="varchar(100)"><value>BBM/sonata_1/1/1</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Fair copy</p></value></field><field name="cache_id" type="int(11)"><value>696</value></field><field name="show_cache" type="tinyint(4)"><value>1</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="datasource_name" type="varchar(100)"><value>ms-sources</value></field><field name="datasource_title" type="varchar(100)"><value>Manuscript Sources</value></field><record table="DS_ms_sources" id="696" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Fair copy</value></field><field name="Subtitle" type="varchar(200)"><value>First three lines only</value></field><field name="RefNo" type="varchar(100)"><value>BBM/sonata_1/1/1</value></field><field name="Date" type="varchar(50)"><value>Oct-Nov 1924</value></field><field name="Description" type="text"><value><p>Fair copy marked 'Allegro ma non Troppo' with a metronome marking of crotchet=105.</p></value></field><field name="Extent" type="varchar(50)"><value>1 page of 19 page manuscript [2r]</value></field><field name="PhysicalDescription" type="text"><value><p>Black ink; 23.4 x 30.5 cm.  Shares a volume with other sources. See Related Records and Title Page of Collected Volume. Paper manufacturer's catalogue No. =  RC2</p></value></field><field name="TitlePageOfCollectedVolume" type="text"><value><p>'June 1925 E.B.Britten/ Book I/ Piano Sonata in Eb major no 4 [4 written over 'I']/ op.1. E.Benjamin Britten/ and part of [crossed out] Piano Sonata in C major no 5 [5 written over 3]/ op.2. E.Benjamin Britten'.</p></value></field><field name="cache_id" type="int"><value>696</value></field><field name="external_record_id" type="int"><value>696</value></field><field name="record_id" type="varchar(100)"><value>BBM/sonata_1/1/1</value></field></record></record><record table="external_records" id="697" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>697</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>217</value></field><field name="display_order" type="int(11)"><value>3</value></field><field name="external_id" type="varchar(100)"><value>BBM/sonata_1/1/2</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Fair copy</p></value></field><field name="cache_id" type="int(11)"><value>697</value></field><field name="show_cache" type="tinyint(4)"><value>1</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="datasource_name" type="varchar(100)"><value>ms-sources</value></field><field name="datasource_title" type="varchar(100)"><value>Manuscript Sources</value></field><record table="DS_ms_sources" id="697" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Fair copy</value></field><field name="Subtitle" type="varchar(200)"><value>Complete</value></field><field name="RefNo" type="varchar(100)"><value>BBM/sonata_1/1/2</value></field><field name="Date" type="varchar(50)"><value>Oct-Nov 1924</value></field><field name="Description" type="text"><value><p>Britten has written 'Op 1.2' at the top of the page which contradicts the Op 1 reference on the front cover.</p></value></field><field name="Extent" type="varchar(50)"><value>5 pages of 19 page manuscript [3r-7v]</value></field><field name="PhysicalDescription" type="text"><value><p>Black ink and pencil; 23.4 x 30.5 cm.  Shares a volume with other sources. See Related Records and Title Page of Collected Volume. Paper manufacturer's catalogue No. =  RC2</p></value></field><field name="TitlePageOfCollectedVolume" type="text"><value><p>'June 1925 E.B.Britten/ Book I/ Piano Sonata in Eb major no 4 [4 written over 'I']/ op.1. E.Benjamin Britten/ and part of [crossed out] Piano Sonata in C major no 5 [5 written over 3]/ op.2. E.Benjamin Britten'.</p></value></field><field name="cache_id" type="int"><value>697</value></field><field name="external_record_id" type="int"><value>697</value></field><field name="record_id" type="varchar(100)"><value>BBM/sonata_1/1/2</value></field></record></record><record table="semantic_dates" id="219" relation="works.semantic_composition_commenced = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>219</value></field><field name="century" type="int(11)"><value>19</value></field><field name="decade" type="int(11)"><value>20</value></field><field name="year" type="int(11)"><value>1924</value></field><field name="month" type="int(11)"><value>10</value></field><field name="approx" type="tinyint(4)"><value>0</value></field><field name="pre" type="tinyint(4)"><value>0</value></field><field name="post" type="tinyint(4)"><value>0</value></field><field name="range" type="tinyint(4)"><value>0</value></field><field name="range_end_approx" type="tinyint(4)"><value>0</value></field><field name="range_end_pre" type="tinyint(4)"><value>0</value></field><field name="range_end_post" type="tinyint(4)"><value>0</value></field><field name="n_days" type="int(11)"><value>702560</value></field></record><record table="semantic_dates" id="220" relation="works.semantic_composition_completed = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>220</value></field><field name="century" type="int(11)"><value>19</value></field><field name="decade" type="int(11)"><value>20</value></field><field name="year" type="int(11)"><value>1924</value></field><field name="month" type="int(11)"><value>11</value></field><field name="approx" type="tinyint(4)"><value>0</value></field><field name="pre" type="tinyint(4)"><value>0</value></field><field name="post" type="tinyint(4)"><value>0</value></field><field name="range" type="tinyint(4)"><value>0</value></field><field name="range_end_approx" type="tinyint(4)"><value>0</value></field><field name="range_end_pre" type="tinyint(4)"><value>0</value></field><field name="range_end_post" type="tinyint(4)"><value>0</value></field><field name="n_days" type="int(11)"><value>702590</value></field></record><record table="works" id="BTC217" relation="previous-work"><field name="work_id" type="int(11)"><value>216</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC217</value></field><field name="catno_numeric" type="int(11)"><value>217</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/untitled_piece_in_f_major_6</value></field><field name="title" type="varchar(200)"><value>Untitled piece in F major</value></field><field name="subtitle" type="varchar(200)"><value>For piano</value></field><field name="is_complete" type="tinyint(4)"><value>1</value></field><field name="genre" type="varchar(100)"><value>Solo piano</value></field><field name="composition_completed" type="varchar(50)"><value>ca. Nov 1924</value></field><field name="semantic_composition_completed" type="int(11)"><value>218</value></field><field name="date_note" type="text"><value><p>The earliest source shares a volume with the manuscript source for <a href="http://www.brittenproject.org/works/work?id=219">The march of the Gods into paridise</a>, which was written in Nov 1924.</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>1</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="year" type="varchar(4)"><value>1924</value></field><field name="composition_period" type="varchar(25)"><value>ca. Nov 1924</value></field></record><record table="works" id="BTC219" relation="next-work"><field name="work_id" type="int(11)"><value>218</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC219</value></field><field name="catno_numeric" type="int(11)"><value>219</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/cuckoo</value></field><field name="title" type="varchar(200)"><value>Cuckoo</value></field><field name="subtitle" type="varchar(200)"><value>For voice and piano</value></field><field name="is_complete" type="tinyint(4)"><value>1</value></field><field name="genre" type="varchar(100)"><value>Solo vocal</value></field><field name="composition_completed" type="varchar(50)"><value>11  Nov 1924</value></field><field name="semantic_composition_completed" type="int(11)"><value>222</value></field><field name="text_set" type="varchar(200)"><value>William Wordsworth (1770-1850)</value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>1</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="year" type="varchar(4)"><value>1924</value></field><field name="composition_period" type="varchar(25)"><value>11  Nov 1924</value></field></record></record></btc>