<btc retrieved="Thu Nov 15 09:05:08 2012" parent-table="works" parent-id="BTC336"><record table="works" id="BTC336"><field name="work_id" type="int(11)"><value>345</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC336</value></field><field name="catno_numeric" type="int(11)"><value>336</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/six_themas</value></field><field name="keywords" type="varchar(200)"><value>6</value></field><field name="title" type="varchar(200)"><value>SIX THEMAS</value></field><field name="subtitle" type="varchar(200)"><value>For piano</value></field><field name="opus_no" type="varchar(20)"><value>J. op 23b</value></field><field name="other_opus_nos" type="varchar(200)"><value>J. opC 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_completed" type="varchar(50)"><value>16 Oct 1925</value></field><field name="semantic_composition_completed" type="int(11)"><value>378</value></field><field name="dedication" type="varchar(200)"><value>'Dedicated to Mrs E.R. Britten'</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>1925</value></field><field name="composition_period" type="varchar(25)"><value>16 Oct 1925</value></field><record table="sub_works" id="47" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>47</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="title" type="text"><value><p>1 (in D major)</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="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>345/1</value></field><record table="incipits" id="803" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>803</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="sub_work_id" type="int(11)"><value>47</value></field><record table="incipit_resources" id="1049" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>1049</value></field><field name="incipit_id" type="int(11)"><value>803</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>345_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="48" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>48</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="title" type="text"><value><p>2 (in B flat major)</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="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>345/2</value></field><record table="incipits" id="804" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>804</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="sub_work_id" type="int(11)"><value>48</value></field><record table="incipit_resources" id="1050" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>1050</value></field><field name="incipit_id" type="int(11)"><value>804</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>345_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="49" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>49</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="title" type="text"><value><p>3 (in G minor)</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>Material later used in <a href="http://www.brittenproject.org/works/work?id=409">Untitled piece in G minor</a> (ca. 1926).</p></value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>345/3</value></field><record table="incipits" id="805" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>805</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="sub_work_id" type="int(11)"><value>49</value></field><record table="incipit_resources" id="1051" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>1051</value></field><field name="incipit_id" type="int(11)"><value>805</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>345_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="50" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>50</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="title" type="text"><value><p>4 (in B flat major)</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="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>345/4</value></field><record table="incipits" id="806" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>806</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="sub_work_id" type="int(11)"><value>50</value></field><record table="incipit_resources" id="1052" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>1052</value></field><field name="incipit_id" type="int(11)"><value>806</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>345_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="sub_works" id="51" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>51</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="title" type="text"><value><p>5 (in C major)</p></value></field><field name="position" type="int(11)"><value>5</value></field><field name="discarded" type="tinyint(4)"><value>0</value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>345/5</value></field><record table="incipits" id="807" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>807</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="sub_work_id" type="int(11)"><value>51</value></field><record table="incipit_resources" id="1053" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>1053</value></field><field name="incipit_id" type="int(11)"><value>807</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>345_5-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="52" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>52</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="title" type="text"><value><p>6 (in D flat major)</p></value></field><field name="position" type="int(11)"><value>6</value></field><field name="discarded" type="tinyint(4)"><value>0</value></field><field name="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>345/6</value></field><record table="incipits" id="808" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>808</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="sub_work_id" type="int(11)"><value>52</value></field><record table="incipit_resources" id="1054" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>1054</value></field><field name="incipit_id" type="int(11)"><value>808</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>345_6-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="1437" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1437</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="display_order" type="int(11)"><value>0</value></field><field name="external_id" type="varchar(100)"><value>BBM/six_themas</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Six themas</p></value></field><field name="cache_id" type="int(11)"><value>1437</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="1437" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Six themas</value></field><field name="Subtitle" type="varchar(200)"><value>For piano</value></field><field name="OpusNo" type="varchar(30)"><value>J.Op 23b
J.OpC 1</value></field><field name="RefNo" type="varchar(100)"><value>BBM/six_themas</value></field><field name="Date" type="varchar(50)"><value>16 Oct 1925</value></field><field name="Description" type="text"><value><p>Dedicated to Mrs E.R.Britten. Musical material of no. 3  later used in 'Untitled piece in G minor' of 1926.</p></value></field><field name="Extent" type="varchar(50)"><value>1 item</value></field><field name="cache_id" type="int"><value>1437</value></field><field name="external_record_id" type="int"><value>1437</value></field><field name="record_id" type="varchar(100)"><value>BBM/six_themas</value></field></record></record><record table="external_records" id="1438" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1438</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="display_order" type="int(11)"><value>1</value></field><field name="external_id" type="varchar(100)"><value>BBM/six_themas/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>1438</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="1438" 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/six_themas/1</value></field><field name="Date" type="varchar(50)"><value>16 Oct 1925</value></field><field name="Extent" type="varchar(50)"><value>1 item</value></field><field name="cache_id" type="int"><value>1438</value></field><field name="external_record_id" type="int"><value>1438</value></field><field name="record_id" type="varchar(100)"><value>BBM/six_themas/1</value></field></record></record><record table="external_records" id="1439" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1439</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>345</value></field><field name="display_order" type="int(11)"><value>2</value></field><field name="external_id" type="varchar(100)"><value>BBM/six_themas/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>1439</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="1439" 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/six_themas/1/1</value></field><field name="Date" type="varchar(50)"><value>16 Oct 1925</value></field><field name="Description" type="text"><value><p>Britten had added a dedication to 'Mrs E.R.Britten', for this piece and the previous piece in this manuscript book,  at the end of the piece.</p></value></field><field name="Extent" type="varchar(50)"><value>2 pages of 48 page manuscript [17r-18v]</value></field><field name="PhysicalDescription" type="text"><value><p>Black ink; 22.7 x 31cm. Shares a volume with other sources. See Related Records and Title Page of Collected Volume. Paper manufacturer's catalogue No. =  RC1</p></value></field><field name="TitlePageOfCollectedVolume" type="text"><value><p>'Edward Benjamin Britten/ 5.9.25/ [contents listed]/ FINIS'.</p></value></field><field name="cache_id" type="int"><value>1439</value></field><field name="external_record_id" type="int"><value>1439</value></field><field name="record_id" type="varchar(100)"><value>BBM/six_themas/1/1</value></field></record></record><record table="semantic_dates" id="378" relation="works.semantic_composition_completed = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>378</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>1925</value></field><field name="month" type="int(11)"><value>10</value></field><field name="day" type="int(11)"><value>16</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>702941</value></field></record><record table="works" id="BTC335" relation="previous-work"><field name="work_id" type="int(11)"><value>344</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC335</value></field><field name="catno_numeric" type="int(11)"><value>335</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/two_scherzo_tarantellas</value></field><field name="keywords" type="varchar(200)"><value>2</value></field><field name="title" type="varchar(200)"><value>TWO SCHERZO TARANTELLAS</value></field><field name="subtitle" type="varchar(200)"><value>For piano</value></field><field name="opus_no" type="varchar(20)"><value>J. op 23a</value></field><field name="other_opus_nos" type="varchar(200)"><value>J. opC 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_completed" type="varchar(50)"><value>15 Oct 1925</value></field><field name="semantic_composition_completed" type="int(11)"><value>377</value></field><field name="dedication" type="varchar(200)"><value>'Dedicated to Mrs E.R. Britten'</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>1925</value></field><field name="composition_period" type="varchar(25)"><value>15 Oct 1925</value></field></record><record table="works" id="BTC337" relation="next-work"><field name="work_id" type="int(11)"><value>346</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC337</value></field><field name="catno_numeric" type="int(11)"><value>337</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/suite_no_1_in_E</value></field><field name="title" type="varchar(200)"><value>SUITE NO 1 IN E</value></field><field name="subtitle" type="varchar(200)"><value>For piano</value></field><field name="opus_no" type="varchar(20)"><value>J. op 24.1</value></field><field name="other_opus_nos" type="varchar(200)"><value>J. opC 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_completed" type="varchar(50)"><value>18 Oct 1925</value></field><field name="semantic_composition_completed" type="int(11)"><value>379</value></field><field name="dedication" type="varchar(200)"><value>'Dedicated to Mrs E.R. Britten'</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>1925</value></field><field name="composition_period" type="varchar(25)"><value>18 Oct 1925</value></field></record></record></btc>