From 11f035632ab8799f9afe45ee0931ff8e4d977364 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Wed, 10 Oct 2012 15:50:49 -0400 Subject: [PATCH] Munge concerto to include # signs in series facets Search for "Piano concerto in C major, op. 39" or "Beethoven: concertos and overtures" and you'll get facets with # signs to assist with fixing LP # 856811. Signed-off-by: Dan Scott Signed-off-by: Bill Erickson --- Open-ILS/tests/datasets/concerto.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/tests/datasets/concerto.sql b/Open-ILS/tests/datasets/concerto.sql index 61ed5501f7..c0242fbc21 100644 --- a/Open-ILS/tests/datasets/concerto.sql +++ b/Open-ILS/tests/datasets/concerto.sql @@ -17,7 +17,7 @@ INSERT INTO marcxml_import (marc) VALUES ('01343nam a2200181 a 450003-000190020020209140320.0000523s2000 mau 000 eng dML 60 R7848 2000Rosen, Charles,1927-Critical entertainments :music old and new /Charles RosenCambridge, MA :Harvard University Press,2000328 pPerformance and musicology / The aesthetics of stage fright -- The discipline of philology: oliver strunk -- The eighteenth century / Keyboard music of bach and handel -- The rediscovering of haydn -- Describing mozart -- Beaumarchais: inventor of morden opera - Radical, conventional mozart -- Beethoven''s career -- Brahms/ Brahms: influence, plagiarism, and inspiration -- Brahms the subversive -- Brahms: classicism and the inspiration of Awkardness -- Musical studies: contrasting views / The benefits of authenticity -- Dictionaries: the old harvard -- Dictionaries: the new grove''s -- The new musicology -- The crisis of the modern / Schoenberg: the possibilities of disquiet -- The performance of contemporary music: carter''s double concerto -- The irrelevance of serious musicMusicHistory and criticisma337673Sirsi_Auto337673'), ('00805njm a2200241 a 450003-000215620000621095430.0000621s1997 enkuuu eng d5221Khachaturian, Aram,1903-1978Piano concerto in D flat (1936) ; Sonatina (1959) ; Toccata (1932)London :ASV,19971 sound disc :digital, stereoCOMPACT DISC(S)Alberto Portugheis, piano ; London Symphony Orchestra ; Loris Tjeknavorian, conductorConcertos (Piano)Piano musicPortguheis, AlbertoTjeknavorian, LorisLondon Symphony Orchestraa337899Sirsi_Auto337899'), ('02724njm a2200529 a 450003-000289520020514155446.0000919s2000 oncuuu eng d5237Composition student recital, April 6, 2000, Huntington University / composition students of Daniel BédardSudbury, Ont. :Huntington University,20001 sound disc :digital, stereoCOMPACT DISC(S)Student composers'' concertSelections recorded live at the Social Centre, Huntington University, Sudbury, Ontario, on April 6, 2000.Off the top of my head / Joyce Van Eyk -- Monophonic for solo French horn / Bryan Lautenbach (Laura Heino, horn) -- Katabasis / Mitch Ross -- Working man''s concerto : for guitar and track / Andy Burns (Andy Burns, guitar) -- Woven flute voices / Joyce Van Eyk (Shannon Coyle, soprano ; Nancy Thurson, flute) -- Three impromptus / Chris Dixon [Dickson] (Desmond Maley, piano) -- Are you speaking? / Bryan Lautenbach -- 4600 : for fiddle and track / Sylvie Julien (Don Reed, violin) -- Wandering jazz night / Joyce Van Eyk (Sarah Toop, clarinet) -- Examine how they change : for sax and track / Mitch Ross (Mike McArthur, sax) -- Oohs / Sylvie Julien -- Eluding perception : for trumpets (3) and track / Bryan Lautenbach (Catherine Burns, Stefan Laakso, Tracy Finucane, trumpets) -- Fascinating / Mitch RossSaxophone and electronic musicTrumpets (3) and electronic musicPiano musicViolin and electronic musicHorn musicClarinet with electronics.Songs (High voice) with fluteVan Eyk, Joyce.Woven flute voicesVan Eyk, Joyce.Off the top of my headLautenbach, Bryan.Monophonic,hornLautenbach, Bryan.Eluding perceptionLautenbach, Bryan.Are you speaking?Ross, Mitchell.Examine how they changeBurns, Andy.Working man''s concertoDickson, Christopher.Impromptus (3),pianoRoss, Mitchell.FascinatingRoss, Mitchell.KatabasisJulien, Sylvie.4600Heino, Laura.prf.Coyle, Shannon.prf.Thurston, Nancy.prf.Reed, Don.prf.Toop, Sarah,prf.McArthur, Michael.prf.Maley, Desmond,1954-prf.Burns, Catherine.prf.Laakso, Stefan.prf.Finucane, Tracy.prf.Bédard, Daniel,1957-a338600Sirsi_Auto338600'), -(E'00817njm a2200241 a 450003-000292820020521145858.0000922s1999 enkuuu eng d5238Busoni, Ferruccio,1866-1924Piano concerto in C major, op. 39London :Hyperion,1999\\1 sound disc :digital, stereoCOMPACT DISC(S)The Romantic Piano Concerto ;22Marc-André Hamelin, piano ; City of Birmingham Symphony Orchestra ; Mark Elder, conductorConcertos (Piano)Hamelin, Marc-André,1961-Elder, MarkCity of Birmingham Symphony Orchestraa338628Sirsi_Auto338628'), +(E'00817njm a2200241 a 450003-000292820020521145858.0000922s1999 enkuuu eng d5238Busoni, Ferruccio,1866-1924Piano concerto in C major, op. 39London :Hyperion,1999\\1 sound disc :digital, stereoCOMPACT DISC(S)The Romantic Piano Concerto ;# 22Marc-André Hamelin, piano ; City of Birmingham Symphony Orchestra ; Mark Elder, conductorConcertos (Piano)Hamelin, Marc-André,1961-Elder, MarkCity of Birmingham Symphony Orchestraa338628Sirsi_Auto338628'), ('01086njm a2200277 a 450003-000333420030124135156.0971014n nyuuuu eng 4523Brahms, Johannes,1833-1897.Concertos,violin, violoncello,op. 102,A minorDouble concerto in A minor, op. 102 ; Variations on a theme by Haydn, op. 56a ; Tragic overture, op. 81New York, NY :Columbia [Records].1 sound disc :33 1/3 rpm, mono.PHONO RECORDIsaac Stern, violin ; Leonard Rose, violoncello ; Philharmonic-Symphony of New York ; Bruno Walter, conductor.Concertos (Violin and violoncello)Stern, Isaac,1920-2001.Rose, Leonard,1918-1984Walter, Bruno,1876-1962New York PhilharmonicTragische OuvertüreVariationen über ein Thema von Haydn, op. 56aa339012Sirsi_Auto339012'), ('01088njm a2200301 a 450003-000345819971015135024.0971015s1996 sweuuu eng 4532Rouse, Christopher,1949-Concertos,trombone(1991)Trombone concerto (1991)Djursholm :Bis,19961 sound disc :digital, stereo.COMPACT DISC(S)American Trombone Concertos ;2Trombone concerto / Rouse -- Trombone concerto / Chávez -- Meditation / Thomas.Christian Lindberg, trombone ; BBC National Orchestra of Wales ; Grant Llewellyn, conductor.Chávez, Carlos,1899-1978Thomas, Augusta Read,1964-Lindberg, ChristianLlewellyn, GrantBBC National Orchestra of WalesMeditation,trombone, orchestraConcertos,trombone(1976-77)a339126Sirsi_Auto339126'), ('00990njm a2200277 a 450003-000360619991211181244.0971015s1966 enkuuu eng 4537Bartók, Béla,1881-1945.Concertos,violin,no. 2,(1938)Violin concerto no. 2 ; Six duos (from 44 Duos)London :Angel,19661 sound disc :33 1/3 rpm, stereo.PHONO RECORDYehudi Menuhin, violin ; Nell Gotkovsky, violin (for Duos only) ; New Philharmonia Orchestra ; Antal Dorati, conductor.Concertos (Violin)Violin music (Violins (2))Menuhin, Yehudi,1916-1999.Gotkovsky, NellDorati, Antal,1906-1988.New Philharmonia OrchestraDuos (44),violins (2). Selectionsa339264Sirsi_Auto339264'), @@ -33,7 +33,7 @@ INSERT INTO marcxml_import (marc) VALUES ('00751nam a2200229 a 450003-000439719981207192358.0970701s1974 enk u000 0 eng 75-3069240563127732MT130.C4W37 1974Warrack, John Hamilton,1928-Tchaikovsky symphonies and concertos /John Warrack.2nd ed.London :British Broadcasting Corporation,1974.64 p. :musicBBC music guides.Tchaikovsky, Peter Ilich, 1840-1893.Symphonies.Tchaikovsky, Peter Ilich, 1840-1893.Concertos.a340023Sirsi_Auto340023'), ('00622nam a2200205 a 450003-000439819991204193934.0970701s1948 nyu u000 0 eng 48-6816MT125.V4Veinus, Abraham.Victor book of concertos /by Abraham Veinus.New York, NY :Simon & Schuster,1948.xxv, 450 p. :music.Discogr.Orchestral musicDiscography.Orchestral musicAnalysis, appreciation.a340024Sirsi_Auto340024'), ('00800nam a2200229 a 450003-000440019981206131340.0970701s1950 enk u000 0 eng 50-14482MT130.M8H8 1950Hutchings, Arthur,1906-A companion to Mozart''s piano concertos /by Arthur Hutchings.2nd ed.London :Oxford University Press,1950.xiv, 211 p. :music"Thematic guide to Mozart''s concertos": pp. [xi]-xiv.Bibliogr.Mozart, Wolfgang Amadeus,1756-1791.Concertos,piano.Mozart, Wolfgang Amadeus, 1756-1791Thematic catalogs.a340026Sirsi_Auto340026'), -('00853nam a2200241 a 450003-000444719981111113740.0970701s1971 wau u000 0 eng 70-110118MT130.B43F6 1971Fiske, RogerBeethoven :concertos and overtures.Seattle, WA :University of Washington Press,1971.64 p. :musicBBC music guides. ;19."First published 1970 by the British Broadcasting Corporation."Beethoven, Ludwig van,1770-1827.Overtures.Beethoven, Ludwig van,1770-1827.Concertos.OverturesAnalysis, appreciation.ConcertosAnalysis, appreciation.a340073Sirsi_Auto340073'), +('00853nam a2200241 a 450003-000444719981111113740.0970701s1971 wau u000 0 eng 70-110118MT130.B43F6 1971Fiske, RogerBeethoven :concertos and overtures.Seattle, WA :University of Washington Press,1971.64 p. :musicBBC music guides. ;# 19."First published 1970 by the British Broadcasting Corporation."Beethoven, Ludwig van,1770-1827.Overtures.Beethoven, Ludwig van,1770-1827.Concertos.OverturesAnalysis, appreciation.ConcertosAnalysis, appreciation.a340073Sirsi_Auto340073'), ('00648nam a2200193 a 450003-000446520020430092042.0970701s1977 u000 0 eng uMT145.W4W4Webb, Douglas John,1935-1994.Serial techniques in John Weinzweig''s divertimentos and concertos (1945-1968) /Douglas J. Webb.[s.l. :s.n.],1977.180 p.Typescript (photocopy).Theses (Ph.D.) - Eastman School of Music.Weinzweig, John, 1913-2006.a340091Sirsi_Auto340091'), ('00888ncm a2200229 a 450003-000447520010920111220.0970701s1978 nyu 00 eng 77-157150486235998M1010.M95B6Mozart, Wolfgang Amadeus,1756-1791Piano concertos nos. 17-22 :in full score, with Mozart''s cadenzas for nos. 17-19, from the Breitkopf & Härtel complete works ed. /Wolfgang Amadeus Mozart.New York, NY :Dover,1978.1 score (370 p.)MUSIC SCORE/PARTITION MUSICALEConcertos (Piano)Scores.Concertos, piano. No. 17-22.a340101Sirsi_Auto340101'), ('02585ncm a2200541 a 450003-000449220010920113844.0970701s1969 nyu 00 eng 79-77393M1004.5.C663The concerto, 1800-1900 :a Norton music anthology /edited by Paul Henry Lang.1st ed.New York, NY :Norton,1969.xxvi, 1 score (869 p.)MUSIC SCORE/PARTITION MUSICALEViolin concerto and Piano concerto no. 5 / Beethoven -- Konzertstück / Weber -- Piano concerto no. 2 / Chopin -- Violin concerto no. 1 / Mendelssohn -- Piano concerto / Schumann -- Piano concerto no. 1 / Tchaikovsky -- Violin concerto and Piano concerto no. 2 / Brahms -- Violoncello concerto / Dvorak.Concertos (Piano)Scores.Concertos (Violin)Scores.Concertos (Violoncello)Scores.Piano with orchestraScores.Lang, Paul Henry,1901-1991.Beethoven, Ludwig van,1770-1827Weber, Carl Maria von,1786-1826Chopin, Frédéric,1810-1849Mendelssohn, Felix,1809-1847.Schumann, Robert,1810-1856Liszt, Franz,1811-1886Tchaikovsky, Peter Ilich,1840-1893Brahms, Johannes,1833-1897Dvorák, Antonín,1841-1904Concertos, violin, op. 61, D majorConcertos, piano, no. 5, op. 73, E flat major, "Emperor"Konzertstück, piano, F minorConcertos, piano, orchestra, no. 2, F minor, op. 21Concertos, violin, orchestra, op. 64, E minor.Concertos, piano, op. 54, A minorConcertos, piano, no. 1, E flat majorConcertos, piano, no. 1, op. 23, B flat minorConcertos, piano, no. 2, op. 83, B flat majorConcertos, violin, op. 77, D majorConcertos, violoncello, op. 104, B minora340118Sirsi_Auto340118'), -- 2.11.0