<btc retrieved="Tue Nov 13 17:42:49 2012" parent-table="works" parent-id="BTC722"><record table="works" id="BTC722"><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 table="sub_works" id="218" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>218</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="title" type="text"><value><p>Love is a sickness (Samuel Daniel, 1562-1619)</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>725/1</value></field><record table="incipits" id="475" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>475</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="sub_work_id" type="int(11)"><value>218</value></field><record table="incipit_resources" id="652" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>652</value></field><field name="incipit_id" type="int(11)"><value>475</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>725_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="219" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>219</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="title" type="text"><value><p>Aspatia's song (John Fletcher, 1579-1625)</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>725/2</value></field><record table="incipits" id="476" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>476</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="sub_work_id" type="int(11)"><value>219</value></field><record table="incipit_resources" id="653" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>653</value></field><field name="incipit_id" type="int(11)"><value>476</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>725_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="220" relation="works.work_id = sub_works.work_id"><field name="sub_work_id" type="int(11)"><value>220</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="title" type="text"><value><p>Hymn to Pan (John Fletcher, 1579-1625)</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>725/3</value></field><record table="incipits" id="477" relation="sub_works.sub_work_id = incipits.sub_work_id"><field name="incipit_id" type="int(11)"><value>477</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="sub_work_id" type="int(11)"><value>220</value></field><record table="incipit_resources" id="654" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>654</value></field><field name="incipit_id" type="int(11)"><value>477</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>725_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="1016" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1016</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="display_order" type="int(11)"><value>0</value></field><field name="external_id" type="varchar(100)"><value>BBM/three_small_songs</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Three small songs</p></value></field><field name="cache_id" type="int(11)"><value>1016</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="1016" relation="external_records.cache_id = DS_ms_sources.cache_id"><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="RefNo" type="varchar(100)"><value>BBM/three_small_songs</value></field><field name="Date" type="varchar(50)"><value>9-18 Jun 1931</value></field><field name="Description" type="text"><value><p>1) Love is a sickness [text by Samuel Daniel]2) Aspatia's song [text by John Fletcher]3) Hymn to Pan [text by John Fletcher]Material later used for 'Three small songs' for soprano and small orchestra [19-24 Jun 1931].</p></value></field><field name="Extent" type="varchar(50)"><value>1 items</value></field><field name="cache_id" type="int"><value>1016</value></field><field name="external_record_id" type="int"><value>1016</value></field><field name="record_id" type="varchar(100)"><value>BBM/three_small_songs</value></field></record></record><record table="external_records" id="1017" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1017</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="display_order" type="int(11)"><value>1</value></field><field name="external_id" type="varchar(100)"><value>BBM/three_small_songs/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>1017</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="1017" 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_small_songs/1</value></field><field name="Date" type="varchar(50)"><value>9-18 Jun 1931</value></field><field name="Extent" type="varchar(50)"><value>1 item</value></field><field name="cache_id" type="int"><value>1017</value></field><field name="external_record_id" type="int"><value>1017</value></field><field name="record_id" type="varchar(100)"><value>BBM/three_small_songs/1</value></field></record></record><record table="external_records" id="1018" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>1018</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>725</value></field><field name="display_order" type="int(11)"><value>2</value></field><field name="external_id" type="varchar(100)"><value>BBM/three_small_songs/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>1018</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="1018" 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/three_small_songs/1/1</value></field><field name="Date" type="varchar(50)"><value>9-18 Jun 1931</value></field><field name="Description" type="text"><value><p>Draft with date and signatures. The top two systems of page 3v are not part of this source.</p></value></field><field name="Extent" type="varchar(50)"><value>1 manuscript; 5 pages [1v-5r]</value></field><field name="PhysicalDescription" type="text"><value><p>Pencil; 26.3 x 35.7 cm. Paper manufacturer = A L. Shares a volume with other sources. See Related Records.</p></value></field><field name="cache_id" type="int"><value>1018</value></field><field name="external_record_id" type="int"><value>1018</value></field><field name="record_id" type="varchar(100)"><value>BBM/three_small_songs/1/1</value></field></record></record><record table="semantic_dates" id="823" relation="works.semantic_composition_commenced = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>823</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>9</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>705004</value></field></record><record table="semantic_dates" id="824" relation="works.semantic_composition_completed = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>824</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>18</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>705013</value></field></record><record table="works" id="BTC721" relation="previous-work"><field name="work_id" type="int(11)"><value>721</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC721</value></field><field name="catno_numeric" type="int(11)"><value>721</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/i_spied_john_mouldy_in_his_cellar</value></field><field name="title" type="varchar(200)"><value>I SPIED JOHN MOULDY IN HIS CELLAR</value></field><field name="subtitle" type="varchar(200)"><value>For soprano 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>ca. Jun 1931</value></field><field name="semantic_composition_completed" type="int(11)"><value>819</value></field><field name="text_set" type="varchar(200)"><value>Walter de la Mare (1873-1956)</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>ca. Jun 1931</value></field></record><record table="works" id="BTC723" relation="next-work"><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></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><record table="works" id="BTC722.1" relation="subsidiary-works"><field name="work_id" type="int(11)"><value>726</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC722.1</value></field><field name="catno_numeric" type="int(11)"><value>722</value></field><field name="catno_subsidiary" type="int(11)"><value>1</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/three_small_songs_2</value></field><field name="keywords" type="varchar(200)"><value>3</value></field><field name="title" type="varchar(200)"><value>Three small songs [orchestral version]</value></field><field name="subtitle" type="varchar(200)"><value>For soprano and orchestra</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="sub_genre" type="varchar(100)"><value>With orchestra</value></field><field name="composition_commenced" type="varchar(50)"><value>19 Jun 1931</value></field><field name="semantic_composition_commenced" type="int(11)"><value>825</value></field><field name="composition_completed" type="varchar(50)"><value>24 Jun 1931</value></field><field name="semantic_composition_completed" type="int(11)"><value>826</value></field><field name="instrumentation" type="varchar(1000)"><value>Orchestra:
1. Fl, ob, 2 cl in A, 2 bn - 3 hn in F - str
2. 2 fl, ca, bn - 3 hn in F - str.
3. Picc, fl, 2 ob, 2 cl in B flat, 2 bn - 3 hn in F - timp, perc (trgl) - str
</value></field><field name="notes" type="text"><value><p>Arrangement of the original work for voice and piano (see 'Related works').</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>19 - 24 Jun 1931</value></field></record></record></btc>