<btc retrieved="Fri Nov 30 12:15:55 2012" parent-table="works" parent-id="BTC428"><record table="works" id="BTC428"><field name="work_id" type="int(11)"><value>436</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC428</value></field><field name="catno_numeric" type="int(11)"><value>428</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/three_toccatas</value></field><field name="keywords" type="varchar(200)"><value>3</value></field><field name="title" type="varchar(200)"><value>THREE TOCCATAS</value></field><field name="subtitle" type="varchar(200)"><value>For piano</value></field><field name="opus_no" type="varchar(20)"><value>J. op 32</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_commenced" type="varchar(50)"><value>5 Jan 1926</value></field><field name="semantic_composition_commenced" type="int(11)"><value>473</value></field><field name="composition_completed" type="varchar(50)"><value>10 Jan 1926</value></field><field name="semantic_composition_completed" type="int(11)"><value>474</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>1926</value></field><field name="composition_period" type="varchar(25)"><value>5 - 10 Jan 1926</value></field><record table="sub_works" id="100" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>100</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="title" type="text"><value><p>1 (in E flat minor)</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>436/1</value></field><record table="incipits" id="239" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>239</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="sub_work_id" type="int(11)"><value>100</value></field><record table="incipit_resources" id="351" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>351</value></field><field name="incipit_id" type="int(11)"><value>239</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>436_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="101" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>101</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="title" type="text"><value><p>2 (in E flat minor)</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>436/2</value></field><record table="incipits" id="240" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>240</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="sub_work_id" type="int(11)"><value>101</value></field><record table="incipit_resources" id="352" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>352</value></field><field name="incipit_id" type="int(11)"><value>240</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>436_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="102" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>102</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="title" type="text"><value><p>3 (in A flat 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="contrib_audio_incipit" type="tinyint(4)"><value>0</value></field><field name="full_position" type="varchar(10)"><value>436/3</value></field><record table="incipits" id="241" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>241</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="sub_work_id" type="int(11)"><value>102</value></field><record table="incipit_resources" id="353" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>353</value></field><field name="incipit_id" type="int(11)"><value>241</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>436_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="external_records" id="1715" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1715</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="display_order" type="int(11)"><value>0</value></field><field name="external_id" type="varchar(100)"><value>BBM/three_toccatas</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Three toccatas</p></value></field><field name="cache_id" type="int(11)"><value>1715</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="1715" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Three toccatas</value></field><field name="Subtitle" type="varchar(200)"><value>For piano</value></field><field name="OpusNo" type="varchar(30)"><value>J.Op 32
J.OpC 1</value></field><field name="RefNo" type="varchar(100)"><value>BBM/three_toccatas</value></field><field name="Date" type="varchar(50)"><value>5-10 Jan 1926</value></field><field name="Description" type="text"><value><p>Dedicated to Mrs E.R.Britten.</p></value></field><field name="Extent" type="varchar(50)"><value>1 item</value></field><field name="cache_id" type="int"><value>1715</value></field><field name="external_record_id" type="int"><value>1715</value></field><field name="record_id" type="varchar(100)"><value>BBM/three_toccatas</value></field></record></record><record table="external_records" id="1716" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1716</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="display_order" type="int(11)"><value>1</value></field><field name="external_id" type="varchar(100)"><value>BBM/three_toccatas/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>1716</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="1716" 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/three_toccatas/1</value></field><field name="Date" type="varchar(50)"><value>5-10 Jan 1926</value></field><field name="Extent" type="varchar(50)"><value>1 item</value></field><field name="cache_id" type="int"><value>1716</value></field><field name="external_record_id" type="int"><value>1716</value></field><field name="record_id" type="varchar(100)"><value>BBM/three_toccatas/1</value></field></record></record><record table="external_records" id="1717" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1717</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>436</value></field><field name="display_order" type="int(11)"><value>2</value></field><field name="external_id" type="varchar(100)"><value>BBM/three_toccatas/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>1717</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="1717" 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/three_toccatas/1/1</value></field><field name="Date" type="varchar(50)"><value>5-10 Jan 1926</value></field><field name="Description" type="text"><value><p>Britten had added a dedication to 'Mrs E.R.Britten' at the end of the piece.</p></value></field><field name="Extent" type="varchar(50)"><value>6 pages of 48 page manuscript [38v-43r]</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>1717</value></field><field name="external_record_id" type="int"><value>1717</value></field><field name="record_id" type="varchar(100)"><value>BBM/three_toccatas/1/1</value></field></record></record><record table="semantic_dates" id="473" relation="works.semantic_composition_commenced = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>473</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>1926</value></field><field name="month" type="int(11)"><value>1</value></field><field name="day" type="int(11)"><value>5</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>703025</value></field></record><record table="semantic_dates" id="474" relation="works.semantic_composition_completed = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>474</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>1926</value></field><field name="month" type="int(11)"><value>1</value></field><field name="day" 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>703030</value></field></record><record table="works" id="BTC427" relation="previous-work"><field name="work_id" type="int(11)"><value>435</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC427</value></field><field name="catno_numeric" type="int(11)"><value>427</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/suite_no_5_in_e</value></field><field name="title" type="varchar(200)"><value>SUITE NO 5 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 30.2</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>4 Jan 1926</value></field><field name="semantic_composition_completed" type="int(11)"><value>472</value></field><field name="dedication" type="varchar(200)"><value>'Dedicated to Mrs R.V. 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>1926</value></field><field name="composition_period" type="varchar(25)"><value>4 Jan 1926</value></field></record><record table="works" id="BTC429" relation="next-work"><field name="work_id" type="int(11)"><value>437</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC429</value></field><field name="catno_numeric" type="int(11)"><value>429</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/four_etudes_symphoniques</value></field><field name="keywords" type="varchar(200)"><value>4</value></field><field name="title" type="varchar(200)"><value>FOUR ETUDES SYMPHONIQUES</value></field><field name="subtitle" type="varchar(200)"><value>For piano</value></field><field name="opus_no" type="varchar(20)"><value>J. op 33</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_commenced" type="varchar(50)"><value>10 Jan 1926</value></field><field name="semantic_composition_commenced" type="int(11)"><value>475</value></field><field name="composition_completed" type="varchar(50)"><value>12 Jan 1926</value></field><field name="semantic_composition_completed" type="int(11)"><value>476</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>1926</value></field><field name="composition_period" type="varchar(25)"><value>10 - 12 Jan 1926</value></field></record></record></btc>