<btc retrieved="Tue Nov 27 07:24:11 2012" parent-table="works" parent-id="BTC320"><record table="works" id="BTC320"><field name="work_id" type="int(11)"><value>329</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC320</value></field><field name="catno_numeric" type="int(11)"><value>320</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/scherzo_trio</value></field><field name="title" type="varchar(200)"><value>SCHERZO AND TRIO</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>Jun 1925</value></field><field name="semantic_composition_completed" type="int(11)"><value>351</value></field><field name="date_note" type="text"><value><p>The date is written on the front of the manuscript volume.</p></value></field><field name="notes" type="text"><value><p>This piece was later used in <a href="http://www.brittenproject.org/works/work?id=332">Grande sonata</a> (Jul-Aug 1925). The scherzo only was the basis of the 'Playful pizzicato' movement of <a href="http://www.brittenproject.org/works/work?id=754">Simple symphony</a>, op. 4.</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>1925</value></field><field name="composition_period" type="varchar(25)"><value>Jun 1925</value></field><record table="incipits" id="341" relation="works.work_id = incipits.work_id"><field name="incipit_id" type="int(11)"><value>341</value></field><field name="work_id" type="int(11)"><value>329</value></field><record table="incipit_resources" id="477" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>477</value></field><field name="incipit_id" type="int(11)"><value>341</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>329_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 table="external_records" id="1382" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1382</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>329</value></field><field name="display_order" type="int(11)"><value>0</value></field><field name="external_id" type="varchar(100)"><value>BBM/scherzo_trio</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Scherzo and trio</p></value></field><field name="cache_id" type="int(11)"><value>1382</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="1382" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Scherzo and trio</value></field><field name="Subtitle" type="varchar(200)"><value>For piano</value></field><field name="RefNo" type="varchar(100)"><value>BBM/scherzo_trio</value></field><field name="Date" type="varchar(50)"><value>Jun 1925</value></field><field name="Description" type="text"><value><p>Scherzo later used in 'Playful pizzicato' from 'Simple symphony' of 1934.  The Scherzo and trio were both used in  'Grande Sonata' of 1925.</p></value></field><field name="Extent" type="varchar(50)"><value>4 items</value></field><field name="cache_id" type="int"><value>1382</value></field><field name="external_record_id" type="int"><value>1382</value></field><field name="record_id" type="varchar(100)"><value>BBM/scherzo_trio</value></field></record></record><record table="external_records" id="1383" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1383</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>329</value></field><field name="display_order" type="int(11)"><value>1</value></field><field name="external_id" type="varchar(100)"><value>BBM/scherzo_trio/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>1383</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="1383" 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/scherzo_trio/1</value></field><field name="Date" type="varchar(50)"><value>1925</value></field><field name="Extent" type="varchar(50)"><value>4 items</value></field><field name="cache_id" type="int"><value>1383</value></field><field name="external_record_id" type="int"><value>1383</value></field><field name="record_id" type="varchar(100)"><value>BBM/scherzo_trio/1</value></field></record></record><record table="external_records" id="1384" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1384</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>329</value></field><field name="display_order" type="int(11)"><value>2</value></field><field name="external_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Composition draft</p></value></field><field name="cache_id" type="int(11)"><value>1384</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="1384" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Composition draft</value></field><field name="RefNo" type="varchar(100)"><value>BBM/scherzo_trio/1/1</value></field><field name="Date" type="varchar(50)"><value>Jun 1925</value></field><field name="Description" type="text"><value><p>The three parts of this composition draft have been separated and are in different locations.</p></value></field><field name="Extent" type="varchar(50)"><value>3 items</value></field><field name="cache_id" type="int"><value>1384</value></field><field name="external_record_id" type="int"><value>1384</value></field><field name="record_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1</value></field></record></record><record table="external_records" id="1385" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1385</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>329</value></field><field name="display_order" type="int(11)"><value>3</value></field><field name="external_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1/1</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Composition draft</p></value></field><field name="cache_id" type="int(11)"><value>1385</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="1385" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Composition draft</value></field><field name="Subtitle" type="varchar(200)"><value>First part of scherzo</value></field><field name="RefNo" type="varchar(100)"><value>BBM/scherzo_trio/1/1/1</value></field><field name="Date" type="varchar(50)"><value>Jun 1925</value></field><field name="Description" type="text"><value><p>Composition draft containing additions by Britten in ink.</p></value></field><field name="Extent" type="varchar(50)"><value>1 page of 19 page manuscript [18v]</value></field><field name="PhysicalDescription" type="text"><value><p>Pencil; blue ink;black ink; 23.4 x 30.4 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/ Book I/ Piano Sonata in Eb major no 4/ op.1. E.Benjamin Britten/ and part of [crosssed out] Piano Sonata in C major no 5/ op.2. E.Benjamin Britten'.</p></value></field><field name="cache_id" type="int"><value>1385</value></field><field name="external_record_id" type="int"><value>1385</value></field><field name="record_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1/1</value></field></record></record><record table="external_records" id="1386" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1386</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>329</value></field><field name="display_order" type="int(11)"><value>4</value></field><field name="external_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1/2</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Composition draft</p></value></field><field name="cache_id" type="int(11)"><value>1386</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="1386" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Composition draft</value></field><field name="Subtitle" type="varchar(200)"><value>Second part of scherzo and beginning of trio</value></field><field name="RefNo" type="varchar(100)"><value>BBM/scherzo_trio/1/1/2</value></field><field name="Date" type="varchar(50)"><value>Jun 1925</value></field><field name="Description" type="text"><value><p>Composition draft containing additions by Britten in ink.</p></value></field><field name="Extent" type="varchar(50)"><value>1 page of 2 page manuscript [2r-2v]</value></field><field name="PhysicalDescription" type="text"><value><p>Pencil;black ink; 23.4 x 30.4 cm. Shares a volume with other sources. See Related Records.  Paper manufacturer's catalogue No. =  RC2</p></value></field><field name="cache_id" type="int"><value>1386</value></field><field name="external_record_id" type="int"><value>1386</value></field><field name="record_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1/2</value></field></record></record><record table="external_records" id="1387" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1387</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>329</value></field><field name="display_order" type="int(11)"><value>5</value></field><field name="external_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1/3</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Composition draft</p></value></field><field name="cache_id" type="int(11)"><value>1387</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="1387" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Composition draft</value></field><field name="Subtitle" type="varchar(200)"><value>Last four bars of trio</value></field><field name="RefNo" type="varchar(100)"><value>BBM/scherzo_trio/1/1/3</value></field><field name="Date" type="varchar(50)"><value>Jun 1925</value></field><field name="Description" type="text"><value><p>Composition draft situated at the top of the page.</p></value></field><field name="Extent" type="varchar(50)"><value>1 page of 6 page manuscript [4r]</value></field><field name="PhysicalDescription" type="text"><value><p>Pencil;black ink; 23.4 x 30.4 cm. Shares a volume with other sources. See Related Records. Paper manufacturer's catalogue No. =  RC2</p></value></field><field name="cache_id" type="int"><value>1387</value></field><field name="external_record_id" type="int"><value>1387</value></field><field name="record_id" type="varchar(100)"><value>BBM/scherzo_trio/1/1/3</value></field></record></record><record table="external_records" id="1388" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1388</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>329</value></field><field name="display_order" type="int(11)"><value>6</value></field><field name="external_id" type="varchar(100)"><value>BBM/scherzo_trio/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>1388</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="1388" 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/scherzo_trio/1/2</value></field><field name="Date" type="varchar(50)"><value>post Aug 1925</value></field><field name="Extent" type="varchar(50)"><value>2 pages of  15 page manuscript [7r-8v]</value></field><field name="PhysicalDescription" type="text"><value><p>Black ink; 23.5 x 29.4 cm. Shares a volume with other sources. See Related Records.</p></value></field><field name="cache_id" type="int"><value>1388</value></field><field name="external_record_id" type="int"><value>1388</value></field><field name="record_id" type="varchar(100)"><value>BBM/scherzo_trio/1/2</value></field></record></record><record table="semantic_dates" id="351" relation="works.semantic_composition_completed = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>351</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>6</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>702805</value></field></record><record table="works" id="BTC319" relation="previous-work"><field name="work_id" type="int(11)"><value>328</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC319</value></field><field name="catno_numeric" type="int(11)"><value>319</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/the_elected_knight</value></field><field name="title" type="varchar(200)"><value>THE ELECTED KNIGHT</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>Jun 1925</value></field><field name="semantic_composition_completed" type="int(11)"><value>347</value></field><field name="date_note" type="text"><value><p>The date is on the front of the manuscript volume.</p></value></field><field name="text_set" type="varchar(200)"><value>Henry W Longfellow  (1807-1882)</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>Jun 1925</value></field></record><record table="works" id="BTC321" relation="next-work"><field name="work_id" type="int(11)"><value>330</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC321</value></field><field name="catno_numeric" type="int(11)"><value>321</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/Scroggam</value></field><field name="title" type="varchar(200)"><value>SCROGGAM</value></field><field name="subtitle" type="varchar(200)"><value>For voice and piano</value></field><field name="is_complete" type="tinyint(4)"><value>0</value></field><field name="genre" type="varchar(100)"><value>Solo vocal</value></field><field name="category" type="varchar(200)"><value>unfinished</value></field><field name="composition_completed" type="varchar(50)"><value>Jun 1925</value></field><field name="semantic_composition_completed" type="int(11)"><value>352</value></field><field name="text_set" type="varchar(200)"><value>Robert Burns (1759-1796)</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>Jun 1925</value></field></record></record></btc>