<btc retrieved="Tue Nov 13 00:39:25 2012" parent-table="works" parent-id="BTC56"><record table="works" id="BTC56"><field name="work_id" type="int(11)"><value>56</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC56</value></field><field name="catno_numeric" type="int(11)"><value>56</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor</value></field><field name="title" type="varchar(200)"><value>Rondo in C sharp minor</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>ca. 1923</value></field><field name="semantic_composition_completed" type="int(11)"><value>57</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>1923</value></field><field name="composition_period" type="varchar(25)"><value>ca. 1923</value></field><record table="incipits" id="46" relation="works.work_id = incipits.work_id"><field name="incipit_id" type="int(11)"><value>46</value></field><field name="work_id" type="int(11)"><value>56</value></field><record table="incipit_resources" id="67" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>67</value></field><field name="incipit_id" type="int(11)"><value>46</value></field><field name="incipit_type" type="varchar(10)"><value>notation</value></field><field name="file_name" type="varchar(100)"><value>56_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="68" relation="incipits.incipit_id = incipit_resources.incipit_id"><field name="incipit_resource_id" type="int(11)"><value>68</value></field><field name="incipit_id" type="int(11)"><value>46</value></field><field name="incipit_type" type="varchar(10)"><value>audio</value></field><field name="file_name" type="varchar(100)"><value>56-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>Lucy Walker (piano)</p></value></field></record></record><record table="external_records" id="206" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>206</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>56</value></field><field name="display_order" type="int(11)"><value>0</value></field><field name="external_id" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor</value></field><field name="as_link" type="tinyint(4)"><value>0</value></field><field name="description" type="text"><value><p>Rondo in C sharp minor</p></value></field><field name="cache_id" type="int(11)"><value>206</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="206" relation="external_records.cache_id = DS_ms_sources.cache_id"><field name="Title" type="varchar(200)"><value>Rondo in C sharp minor</value></field><field name="Subtitle" type="varchar(200)"><value>For piano</value></field><field name="RefNo" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor</value></field><field name="Date" type="varchar(50)"><value>circa 1923</value></field><field name="Extent" type="varchar(50)"><value>1 item</value></field><field name="cache_id" type="int"><value>206</value></field><field name="external_record_id" type="int"><value>206</value></field><field name="record_id" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor</value></field></record></record><record table="external_records" id="207" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>207</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>56</value></field><field name="display_order" type="int(11)"><value>1</value></field><field name="external_id" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor/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>207</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="207" 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/rondo_in_c_sharp_minor/1</value></field><field name="Date" type="varchar(50)"><value>circa 1923</value></field><field name="Extent" type="varchar(50)"><value>1 item</value></field><field name="cache_id" type="int"><value>207</value></field><field name="external_record_id" type="int"><value>207</value></field><field name="record_id" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor/1</value></field></record></record><record table="external_records" id="208" relation="works.work_id = external_records.work_id"><field name="record_id" type="int(11)"><value>208</value></field><field name="datasource_id" type="int(11)"><value>1</value></field><field name="work_id" type="int(11)"><value>56</value></field><field name="display_order" type="int(11)"><value>2</value></field><field name="external_id" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor/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>208</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="208" 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/rondo_in_c_sharp_minor/1/1</value></field><field name="Date" type="varchar(50)"><value>circa 1923</value></field><field name="Description" type="text"><value><p>Draft with title marked 'alegro'.</p></value></field><field name="Extent" type="varchar(50)"><value>1 page of 12 page manuscript [10v-11r]</value></field><field name="PhysicalDescription" type="text"><value><p>Pencil; 23.8 x 29.9 cm. Shares a volume with other sources. See Related Records.</p></value></field><field name="cache_id" type="int"><value>208</value></field><field name="external_record_id" type="int"><value>208</value></field><field name="record_id" type="varchar(100)"><value>BBM/rondo_in_c_sharp_minor/1/1</value></field></record></record><record table="semantic_dates" id="57" relation="works.semantic_composition_completed = semantic_dates.semantic_date_id"><field name="semantic_date_id" type="int(11)"><value>57</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>1923</value></field><field name="approx" type="tinyint(4)"><value>1</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>701895</value></field></record><record table="works" id="BTC55" relation="previous-work"><field name="work_id" type="int(11)"><value>55</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC55</value></field><field name="catno_numeric" type="int(11)"><value>55</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/praise_be_to_god</value></field><field name="title" type="varchar(200)"><value>Praise be to God</value></field><field name="subtitle" type="varchar(200)"><value>For four voices, strings and piano or organ</value></field><field name="is_complete" type="tinyint(4)"><value>0</value></field><field name="genre" type="varchar(100)"><value>Choral </value></field><field name="category" type="varchar(200)"><value>unfinished</value></field><field name="composition_completed" type="varchar(50)"><value>ca. 1923</value></field><field name="semantic_composition_completed" type="int(11)"><value>56</value></field><field name="instrumentation" type="varchar(1000)"><value>SATB - 2 vn, va, vc - pf (or org)</value></field><field name="text_set" type="varchar(200)"><value>From Isaiah 5:1-5:3 and Luke 2:1</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>1923</value></field><field name="composition_period" type="varchar(25)"><value>ca. 1923</value></field></record><record table="works" id="BTC57" relation="next-work"><field name="work_id" type="int(11)"><value>57</value></field><field name="catalogue_no" type="varchar(20)"><value>BTC57</value></field><field name="catno_numeric" type="int(11)"><value>57</value></field><field name="bbm_number" type="varchar(100)"><value>BBM/untitled_piece_in_a_major_3</value></field><field name="title" type="varchar(200)"><value>Untitled piece in A major</value></field><field name="subtitle" type="varchar(200)"><value>For violin and piano</value></field><field name="is_complete" type="tinyint(4)"><value>0</value></field><field name="genre" type="varchar(100)"><value>Solo instrumental</value></field><field name="category" type="varchar(200)"><value>unfinished</value></field><field name="composition_completed" type="varchar(50)"><value>ca. 1923</value></field><field name="semantic_composition_completed" type="int(11)"><value>58</value></field><field name="notes" type="text"><value><p>Arrangement of <a href="http://www.brittenproject.org/works/work?id=53">Concerto for 1st violin, 2nd violin, violincello and double bass</a>.</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>1923</value></field><field name="composition_period" type="varchar(25)"><value>ca. 1923</value></field></record></record></btc>