<btc retrieved="Sat Nov 17 09:13:53 2012" parent-table="works" parent-id="BTC723"><record table="works" id="BTC723"><field name="work_id" type="int(11)"><value>727</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC723</value></field><field name="catno_numeric" type="int(11)"><value>723</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/two_pieces_2</value></field><field name="keywords" type="varchar(200)"><value>2</value></field><field name="title" type="varchar(200)"><value>TWO PIECES</value></field><field name="subtitle" type="varchar(200)"><value>For violin and piano</value></field><field name="is_complete" type="tinyint(4)"><value>1</value></field><field name="genre" type="varchar(100)"><value>Solo instrumental</value></field><field name="composition_commenced" type="varchar(50)"><value>29 Jun 1931</value></field><field name="semantic_composition_commenced" type="int(11)"><value>827</value></field><field name="composition_completed" type="varchar(50)"><value>30 Jun 1931</value></field><field name="semantic_composition_completed" type="int(11)"><value>828</value></field><field name="dedication" type="varchar(200)"><value>'For Remo Lauricella'</value><note><p>Remo Lauricella (1912-2003), English violinist and composer, and fellow-student of Britten's at the Royal College of Music</p></note></field><field name="notes" type="text"><value><p>Published in 2010 by EBB Music Publishing.
</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="year" type="varchar(4)"><value>1931</value></field><field name="composition_period" type="varchar(25)"><value>29 - 30 Jun 1931</value></field><record table="sub_works" id="225" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>225</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="title" type="text"><value><p>The Moon</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>Based on 'The Moon' by Percy Bysshe Shelley. Britten had set the text of this poem earlier: see <a href="http://www.brittenproject.org/works/work?id=591">The waning moon</a> (Jun 1928).</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>727/1</value></field><record table="incipits" id="743" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>743</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="sub_work_id" type="int(11)"><value>225</value></field><record table="incipit_resources" id="976" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>976</value></field><field name="incipit_id" type="int(11)"><value>743</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>727_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 table="incipit_resources" id="977" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>977</value></field><field name="incipit_id" type="int(11)"><value>743</value></field><field name="incipit_type" type="varchar(10)"><value>audio</value></field><field name="file_name" type="varchar(100)"><value>727_1-incipit.mp3</value></field><field name="mime_type" type="varchar(20)"><value>audio/mpeg</value></field><field name="sequence_number" type="int(11)"><value>1</value></field><field name="caption" type="text"><value><p>Morganne Aaberg (violin) and Doug Lima (piano)</p></value></field></record></record></record><record table="sub_works" id="224" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>224</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="title" type="text"><value><p>Going down hill on a bicycle</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>Based on <span style="font-style:italic">Going downhill on a bicycle</span> by Henry Charles Beeching. <a href="http://www.brittenproject.org/works/work?id=708">With feet lifted (unfinished)</a> (ca. Jan 1931) was also based on this poem.</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>727/2</value></field><record table="incipits" id="744" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>744</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="sub_work_id" type="int(11)"><value>224</value></field><record table="incipit_resources" id="978" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>978</value></field><field name="incipit_id" type="int(11)"><value>744</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>727_2_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 table="incipit_resources" id="2580" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>2580</value></field><field name="incipit_id" type="int(11)"><value>744</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>727_2_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>2</value></field></record><record table="incipit_resources" id="2581" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>2581</value></field><field name="incipit_id" type="int(11)"><value>744</value></field><field name="incipit_type" type="varchar(10)"><value>audio</value></field><field name="file_name" type="varchar(100)"><value>727_2-incipit.mp3</value></field><field name="mime_type" type="varchar(20)"><value>audio/mpeg</value></field><field name="sequence_number" type="int(11)"><value>1</value></field><field name="caption" type="text"><value><p>
Morganne Aaberg (violin) and Doug Lima (piano)</p></value></field></record></record></record><record table="external_records" id="1022" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1022</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="display_order" type="int(11)"><value>0</value></field><field name="external_id" type="varchar(100)"><value>BBM/two_pieces_2</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Two pieces</p></value></field><field name="cache_id" type="int(11)"><value>1022</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="1022" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Two pieces</value></field><field name="Subtitle" type="varchar(200)"><value>For violin and piano</value></field><field name="RefNo" type="varchar(100)"><value>BBM/two_pieces_2</value></field><field name="Date" type="varchar(50)"><value>29-30 Jun 1931</value></field><field name="Description" type="text"><value><p>Based on 'The Moon' by Percy Bysshe Shelley and 'Going down hill on a bicycle' by Henry Charles Beeching. Written for 'Remo Lauricella'.</p></value></field><field name="Extent" type="varchar(50)"><value>2 items</value></field><field name="cache_id" type="int"><value>1022</value></field><field name="external_record_id" type="int"><value>1022</value></field><field name="record_id" type="varchar(100)"><value>BBM/two_pieces_2</value></field></record></record><record table="external_records" id="1023" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1023</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="display_order" type="int(11)"><value>1</value></field><field name="external_id" type="varchar(100)"><value>BBM/two_pieces_2/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>1023</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="1023" 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/two_pieces_2/1</value></field><field name="Date" type="varchar(50)"><value>29-30 Jun 1931</value></field><field name="Extent" type="varchar(50)"><value>2 items</value></field><field name="cache_id" type="int"><value>1023</value></field><field name="external_record_id" type="int"><value>1023</value></field><field name="record_id" type="varchar(100)"><value>BBM/two_pieces_2/1</value></field></record></record><record table="external_records" id="1024" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1024</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="display_order" type="int(11)"><value>2</value></field><field name="external_id" type="varchar(100)"><value>BBM/two_pieces_2/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>1024</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="1024" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Fair copy</value></field><field name="RefNo" type="varchar(100)"><value>BBM/two_pieces_2/1/1</value></field><field name="Date" type="varchar(50)"><value>29-30 Jun 1931</value></field><field name="Description" type="text"><value><p>Fair copy with dates, signatures and some annotations.</p></value></field><field name="Extent" type="varchar(50)"><value>1 manuscript; 6 pages [1r-6r]</value></field><field name="PhysicalDescription" type="text"><value><p>Pencil; 26.3 x 35.5 cm. Paper manufacturer = A L. See Title Page of Collected Volume.</p></value></field><field name="TitlePageOfCollectedVolume" type="text"><value><p>' Written for Remo Lauricella / TWO PIECES / for / Violin &amp; Pianoforte / [signature] / 1 The Moon (after P.B.Shelley) / 2 Going down Hill on a Bicycle (after H.C.Beeching)'.</p></value></field><field name="cache_id" type="int"><value>1024</value></field><field name="external_record_id" type="int"><value>1024</value></field><field name="record_id" type="varchar(100)"><value>BBM/two_pieces_2/1/1</value></field></record></record><record table="external_records" id="1025" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1025</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>727</value></field><field name="display_order" type="int(11)"><value>3</value></field><field name="external_id" type="varchar(100)"><value>BBM/two_pieces_2/1/2</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Instrumental part</p></value></field><field name="cache_id" type="int(11)"><value>1025</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="1025" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Instrumental part</value></field><field name="Subtitle" type="varchar(200)"><value>Violin part only</value></field><field name="RefNo" type="varchar(100)"><value>BBM/two_pieces_2/1/2</value></field><field name="Date" type="varchar(50)"><value>circa 29-30 Jun 1931</value></field><field name="Description" type="text"><value><p>Violin part with signatures. Britten has pasted a revised section over the bottom four lines of page 1v.</p></value></field><field name="Extent" type="varchar(50)"><value>1 manuscript; 2 pages [1r-2r]</value></field><field name="PhysicalDescription" type="text"><value><p>Black ink; 26.3 x 35.5 cm. Paper manufacturer = A L.</p></value></field><field name="cache_id" type="int"><value>1025</value></field><field name="external_record_id" type="int"><value>1025</value></field><field name="record_id" type="varchar(100)"><value>BBM/two_pieces_2/1/2</value></field></record></record><record table="semantic_dates" id="827" relation="works.semantic_composition_commenced = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>827</value></field><field name="century" type="int(11)"><value>19</value></field><field name="decade" type="int(11)"><value>30</value></field><field name="year" type="int(11)"><value>1931</value></field><field name="month" type="int(11)"><value>6</value></field><field name="day" type="int(11)"><value>29</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>705024</value></field></record><record table="semantic_dates" id="828" relation="works.semantic_composition_completed = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>828</value></field><field name="century" type="int(11)"><value>19</value></field><field name="decade" type="int(11)"><value>30</value></field><field name="year" type="int(11)"><value>1931</value></field><field name="month" type="int(11)"><value>6</value></field><field name="day" type="int(11)"><value>30</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>705025</value></field></record><record table="works" id="BTC722" relation="previous-work"><field name="work_id" type="int(11)"><value>725</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC722</value></field><field name="catno_numeric" type="int(11)"><value>722</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/three_small_songs</value></field><field name="keywords" type="varchar(200)"><value>3</value></field><field name="title" type="varchar(200)"><value>THREE SMALL SONGS</value></field><field name="subtitle" type="varchar(200)"><value>For soprano 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_commenced" type="varchar(50)"><value>9 Jun 1931</value></field><field name="semantic_composition_commenced" type="int(11)"><value>823</value></field><field name="composition_completed" type="varchar(50)"><value>18 Jun 1931</value></field><field name="semantic_composition_completed" type="int(11)"><value>824</value></field><field name="text_set" type="varchar(200)"><value>See under individual movements</value></field><field name="notes" type="text"><value><p>Subsequently arranged for voice and orchestra (see 'Related works').</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>1931</value></field><field name="composition_period" type="varchar(25)"><value>9 - 18 Jun 1931</value></field></record><record table="works" id="BTC724" relation="next-work"><field name="work_id" type="int(11)"><value>1112</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC724</value></field><field name="catno_numeric" type="int(11)"><value>724</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/BTCwhereisfancybred</value></field><field name="title" type="varchar(200)"><value>Where is fancy bred? [Missing]</value></field><field name="subtitle" type="varchar(200)"><value>For mixed voices</value></field><field name="is_complete" type="tinyint(4)"><value>1</value></field><field name="genre" type="varchar(100)"><value>Choral (unaccompanied)</value></field><field name="category" type="varchar(200)"><value>missing</value></field><field name="composition_completed" type="varchar(50)"><value>17 Jul 1931</value></field><field name="semantic_composition_completed" type="int(11)"><value>1375</value></field><field name="text_set" type="varchar(200)"><value>William Shakespeare (1564-1616)</value></field><field name="notes" type="text"><value><p>Britten set this work as a madrigal during an exam at the Royal College of Music, describing it in his diary as 'v. weak'. The text is the same as that in <a href="http://www.brittenproject.org/works/work?id=1020">Fancie</a> (May 1961). </p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="hidden" type="tinyint(4)"><value>0</value></field><field name="year" type="varchar(4)"><value>1931</value></field><field name="composition_period" type="varchar(25)"><value>17 Jul 1931</value></field></record></record></btc>