CREATE DATABASE  IF NOT EXISTS `bdAsm` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `bdAsm`;
-- MySQL dump 10.13  Distrib 5.6.24, for Win64 (x86_64)
--
-- Host: localhost    Database: bd_asm
-- ------------------------------------------------------
-- Server version	5.6.26-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `t_categorie`
--

DROP TABLE IF EXISTS `t_categorie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_categorie` (
  `PK_Categorie` int(11) NOT NULL,
  `Categorie` varchar(45) NOT NULL,
  `FK_Categorie_Superieure` int(11) DEFAULT NULL,
  PRIMARY KEY (`PK_Categorie`),
  KEY `fk_T_Categorie_T_Categorie1_idx` (`FK_Categorie_Superieure`),
  CONSTRAINT `fk_T_Categorie_T_Categorie1` FOREIGN KEY (`FK_Categorie_Superieure`) REFERENCES `t_categorie` (`PK_Categorie`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_categorie`
--

LOCK TABLES `t_categorie` WRITE;
/*!40000 ALTER TABLE `t_categorie` DISABLE KEYS */;
INSERT INTO `t_categorie` VALUES (1,'Excellence',NULL),(2,'1ère catégorie',1),(3,'2ème catégorie',2),(4,'3ème catégorie',3),(5,'4ème catégorie',4);
/*!40000 ALTER TABLE `t_categorie` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_client`
--

DROP TABLE IF EXISTS `t_client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_client` (
  `PK_Client` int(11) NOT NULL,
  `Nom` varchar(45) DEFAULT NULL,
  `Prenom` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`PK_Client`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_client`
--

LOCK TABLES `t_client` WRITE;
/*!40000 ALTER TABLE `t_client` DISABLE KEYS */;
INSERT INTO `t_client` VALUES (1,'ALBERT','Kevin'),(2,'ALBERT','Louis'),(3,'BARRE','Corinne'),(4,'BARRE','Isabelle'),(5,'BARTHELEMY','Jeannine'),(6,'BARTHELEMY','Claude'),(7,'BLANCHARD','Didier'),(8,'BLANCHARD','Pascal'),(9,'BLANCHARD','Franck'),(10,'BOURGEOIS','Daniel'),(11,'BOURGEOIS','Claude'),(12,'BRETON','Camille'),(13,'BRETON','Paul'),(14,'CHARLES','Christian'),(15,'CHARLES','Camille'),(16,'CHEVALIER','Isabelle'),(17,'CHEVALIER','Jacqueline'),(18,'DA SILVA','Louis'),(19,'DA SILVA','Franck'),(20,'DELAUNAY','Vincent'),(21,'DELAUNAY','Paul'),(22,'DESCHAMPS','Pascal'),(23,'DESCHAMPS','Virginie'),(24,'FAURE','Jacqueline'),(25,'FAURE','Jacques'),(26,'FONTAINE','Romain'),(27,'FONTAINE','Franck'),(28,'FONTAINE','Patricia'),(29,'GAILLARD','Patricia'),(30,'GAILLARD','Corinne'),(31,'GARNIER','Claude'),(32,'GARNIER','Bruno'),(33,'GAUTIER','Bruno'),(34,'GAUTIER','Romain'),(35,'GILLET','Jacques'),(36,'GILLET','Christian'),(37,'GIRAUD','Virginie'),(38,'GIROUX','Marie'),(39,'GIROUX','Thierry'),(40,'HENRY','Roger'),(41,'HENRY','Christiane'),(42,'HUET','Thierry'),(43,'HUET','Roger'),(44,'JACQUES','Jacqueline'),(45,'JACQUES','Vincent'),(46,'MARECHAL','Paul'),(47,'MARECHAL','Kevin'),(48,'OLLIVIER','Franck'),(49,'OLLIVIER','Pascal'),(50,'PASCAL','Christian'),(51,'PASCAL','Jeannine'),(52,'PELLETIER','Paul'),(53,'PELLETIER','Daniel'),(54,'REGNIER','Gérard'),(55,'REGNIER','Michel'),(56,'RODRIGUEZ','Michel'),(57,'RODRIGUEZ','Jacqueline'),(58,'ROUSSEAU','Claude'),(59,'ROUSSEAU','Didier'),(60,'THOMAS','Christiane'),(61,'THOMAS','Gérard');
/*!40000 ALTER TABLE `t_client` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_commande`
--

DROP TABLE IF EXISTS `t_commande`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_commande` (
  `PK_Commande` int(11) NOT NULL,
  `Date` date DEFAULT NULL,
  `FK_Client` int(11) NOT NULL,
  PRIMARY KEY (`PK_Commande`),
  KEY `fk_T_Commande_t_client1_idx` (`FK_Client`),
  CONSTRAINT `fk_T_Commande_t_client1` FOREIGN KEY (`FK_Client`) REFERENCES `t_client` (`PK_Client`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_commande`
--

LOCK TABLES `t_commande` WRITE;
/*!40000 ALTER TABLE `t_commande` DISABLE KEYS */;
INSERT INTO `t_commande` VALUES (1,'2012-06-22',2),(2,'2015-01-31',57),(3,'2014-04-08',33),(4,'2014-09-05',37),(5,'2015-06-26',24),(6,'2012-01-12',37),(7,'2011-12-21',60),(8,'2012-09-15',8),(9,'2011-06-16',36),(10,'2015-08-23',33),(11,'2015-05-20',42),(12,'2012-11-28',38),(13,'2014-03-14',33),(14,'2013-11-10',58),(15,'2011-10-27',15),(16,'2010-12-26',13),(17,'2013-02-22',36),(18,'2015-04-18',32),(19,'2015-09-23',34),(20,'2010-02-17',57),(21,'2010-01-01',35),(22,'2011-12-27',18),(23,'2012-01-06',57),(24,'2013-01-03',58),(25,'2014-03-30',6),(26,'2011-11-25',58),(27,'2014-10-08',35),(28,'2013-11-05',45),(29,'2014-01-31',36),(30,'2014-06-23',28),(31,'2011-02-11',57),(32,'2012-12-01',31),(33,'2013-07-09',56),(34,'2013-11-04',11),(35,'2010-07-09',2),(36,'2015-10-28',5),(37,'2012-05-09',39),(38,'2013-09-15',46),(39,'2013-03-25',46),(40,'2012-12-05',26),(41,'2015-07-23',54),(42,'2010-01-31',18),(43,'2011-10-06',32),(44,'2014-01-01',34),(45,'2010-05-29',48),(46,'2015-11-11',48),(47,'2012-09-21',43),(48,'2011-12-08',4),(49,'2013-06-07',10),(50,'2015-04-26',32),(51,'2013-03-24',47),(52,'2010-10-12',40),(53,'2010-01-10',34),(54,'2012-07-17',21),(55,'2010-01-06',38),(56,'2015-03-24',1),(57,'2011-12-06',3),(58,'2014-03-23',15),(59,'2011-01-03',34),(60,'2011-02-05',61),(61,'2010-06-02',22),(62,'2010-02-08',7),(63,'2013-08-21',47),(64,'2012-09-09',13),(65,'2013-02-21',53),(66,'2011-12-20',23),(67,'2011-12-16',5),(68,'2010-08-18',60),(69,'2014-01-17',53),(70,'2010-01-27',41),(71,'2011-06-17',54),(72,'2012-10-18',46),(73,'2014-06-08',28),(74,'2015-12-10',22),(75,'2013-11-22',23),(76,'2013-12-18',20),(77,'2012-10-14',9),(78,'2010-11-25',2),(79,'2012-09-08',22),(80,'2015-03-02',46),(81,'2015-07-30',27),(82,'2015-05-22',23),(83,'2014-02-18',4),(84,'2011-10-20',57),(85,'2010-04-15',11),(86,'2012-04-19',46),(87,'2013-06-03',10),(88,'2010-05-21',40),(89,'2014-04-20',29),(90,'2010-08-05',17),(91,'2015-05-26',53),(92,'2014-03-14',39),(93,'2014-06-01',50),(94,'2011-11-11',52),(95,'2010-06-20',23),(96,'2013-09-20',19),(97,'2015-12-12',39),(98,'2014-08-13',24),(99,'2015-04-30',10),(100,'2012-02-13',53),(101,'2014-03-31',56),(102,'2012-12-26',19),(103,'2014-03-31',11),(104,'2015-05-01',27);
/*!40000 ALTER TABLE `t_commande` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_compositeur`
--

DROP TABLE IF EXISTS `t_compositeur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_compositeur` (
  `PK_Compositeur` int(11) NOT NULL,
  `Nom` varchar(45) NOT NULL,
  `Prenom` varchar(45) NOT NULL,
  PRIMARY KEY (`PK_Compositeur`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_compositeur`
--

LOCK TABLES `t_compositeur` WRITE;
/*!40000 ALTER TABLE `t_compositeur` DISABLE KEYS */;
INSERT INTO `t_compositeur` VALUES (1,'Aagard-Nilsen','Torstein'),(2,'Aeby','Jacques'),(3,'Agnello','Federico'),(4,'Alarcon','Luis Serrano'),(5,'Alves','Afonso'),(6,'Ameller','André'),(7,'Amirov','Fikret'),(8,'Andriessen','Jurriaan'),(9,'Andriessen','Louis'),(10,'Apon','Saskia'),(11,'Appermont','Bert'),(12,'Arend','Arie den'),(13,'Arnold','Malcolm'),(14,'Arpagaus','Hans-Peter'),(15,'Arrigoni','Franco'),(16,'Asanger','Thomas'),(17,'Ashpole','Alfred'),(18,'Badings','Henk'),(19,'Baker','Leigh'),(20,'Balay','Eduard'),(21,'Balissat','Jean'),(22,'Ball','Eric'),(23,'Ball','Michael'),(24,'Barberán','Teo Aparicio'),(25,'Barker','Warren'),(26,'Barnes','James'),(27,'Barry','Darrol'),(28,'Bartok','Bela'),(29,'Beekum','Jan van'),(30,'Behrman','Tracy O.'),(31,'Beltrami','Edson'),(32,'Bennett','Robert Russell'),(33,'Benz','Albert'),(34,'Bernstein','Leonard'),(35,'Besançon','Thierry'),(36,'Bilik','Jerry'),(37,'Blaser','Hans-Peter'),(38,'Bliss','Arthur'),(39,'Blum','Robert'),(40,'Boedijn','Gerard'),(41,'Boekel','Meindert'),(42,'Boëllmann','Léon'),(43,'Boïeldieu','François-Adrien'),(44,'Bolli','Rolf'),(45,'Booker','Jr.'),(46,'Borodin','Alexander'),(47,'Bösendorfer','Alfred'),(48,'Bosveld','Jan'),(49,'Bourgeois','Derek'),(50,'Boysen','jr.'),(51,'Brakstad','John'),(52,'Bräm','Thüring'),(53,'Brazda','Dalibor'),(54,'Brevik','Tom'),(55,'Brossé','Dirk'),(56,'Brotons','Salvato'),(57,'Broughton','Bruce'),(58,'Bulla','Stephen'),(59,'Bürki','Mario'),(60,'Busslinger','Eugen'),(61,'Butterworth','Arthur'),(62,'Calvert','Morley'),(63,'Camphouse','Mark'),(64,'Carr','John'),(65,'Carter','Charles'),(66,'Casanova','Gion Andrea'),(67,'Cattin','François'),(68,'Cavadini','Claudio'),(69,'Cesarini','Franco'),(70,'Ceunen','Filip'),(71,'Chance','John Barnes'),(72,'Chisham','Daniel'),(73,'Cichy','Roger'),(74,'Clarke','Nigel'),(75,'Cleemput','Werner van'),(76,'Compello','Joseph'),(77,'Condon','Leslie'),(78,'Copland','Aaron'),(79,'Crausaz','Etienne'),(80,'Cruft','Adrian'),(81,'Cundell','Edric'),(82,'Curchod','Bertrand'),(83,'Curnow','James'),(84,'Daehn','Larry'),(85,'Daetwyler','Jean'),(86,'Dalby','Martin'),(87,'Damiani','Pietro'),(88,'Dance','Colin G'),(89,'Davoren','Tom'),(90,'De Groot','Hugo'),(91,'de Haan','Jacob'),(92,'de Haan','Jan'),(93,'De Meij','Johan'),(94,'De Nardis','Camille'),(95,'De Roeck','Gustav'),(96,'Debs','Erick'),(97,'Defoort','Rita'),(98,'Del Borgo','Elliot A.'),(99,'Delden','Lex van'),(100,'Delft','Marc van'),(101,'Della Fonte','Lorenzo'),(102,'Dello Joio','Norman'),(103,'Denzil','Stephens'),(104,'Poelmann',' Alex'),(105,'Derongé','Roger'),(106,'Deseure','Karel'),(107,'D\'Hayer','Fr. C.'),(108,'Diener','Theodor'),(109,'Dijck','Karel van'),(110,'Dobson','Simon'),(111,'Domenjoz','Vivian'),(112,'Dondeyne','Désiré'),(113,'Doss','Thomas'),(114,'Downie','Kenneth'),(115,'Dubrovay','László'),(116,'Duijck','Guy'),(117,'Duncan','Andrew'),(118,'Earl','Christian'),(119,'Eastmond','David'),(120,'Eckert','Thomas'),(121,'Egli','Hanspeter'),(122,'Elgar','Edward'),(123,'Elledge','Chuck'),(124,'Ellerby','Martin'),(125,'Ender','Roger'),(126,'Erickson','Frank'),(127,'Ermatinger','Emil'),(128,'Evenepoel','Johan'),(129,'Fasolis','Silvano'),(130,'Fassbänder','Peter'),(131,'Favre','Pascal'),(132,'Fernie','Alan'),(133,'Fernie','Alan (arr.)'),(134,'Ferran','Ferrer'),(135,'Finn','Robert'),(136,'Fletcher','Percy E.'),(137,'Follmann','Georges'),(138,'Ford','Ralph'),(139,'Ford','Trevor J.'),(140,'Fort','Francisco Zacarés'),(141,'Franck','César'),(142,'Fransen','Willy'),(143,'Fraser','Bruce'),(144,'Frid','Geza'),(145,'Friedemann','Carl'),(146,'Fuhrer','Cedric'),(147,'Fujita','Gemba'),(148,'Fülling','Eugen'),(149,'Gäble','Kurt'),(150,'Gaia','Massimo'),(151,'Gates','Dorothy'),(152,'Gay','Bertrand'),(153,'Geisler','Michael'),(154,'Gendre','Pascal'),(155,'George','Thom Ritter'),(156,'Gershwin','George'),(157,'Giannini','Vittorio'),(158,'Gilby','Mary-Ann'),(159,'Gillingham','David R.'),(160,'Gillis','Don'),(161,'Giovannini','Caesar'),(162,'Gobbo','Raymond'),(163,'Goffin','Dean'),(164,'Golland','John'),(165,'Goorhuis','Rob'),(166,'Gorb','Adam'),(167,'Gotkovsky','Ida'),(168,'Götz','Markus'),(169,'Gould','Morton'),(170,'Gourlay','James'),(171,'Graham','Peter'),(172,'Grainger','Percy'),(173,'Grantham','Richard'),(174,'Gregson','Edward'),(175,'Grieg','Edvard'),(176,'Grieg','Irena'),(177,'Grundman','Clare'),(178,'Haantjes','Menno'),(179,'Haas','Otto'),(180,'Häberling','Albert'),(181,'Hadermann','Jan'),(182,'Haemhouts','Ben'),(183,'Hamers','Maurice'),(184,'Hanmer','Ronald'),(185,'Hanson','Howard'),(186,'Harbison','William G.'),(187,'Harper','Philip'),(188,'Hartmann','Jean-Pierre'),(189,'Harvey','Jack'),(190,'Häusler','Daniel'),(191,'Hautvast','Willy'),(192,'Hayoz','Benedikt'),(193,'Heath','Reginald'),(194,'Heaton','Wilfred'),(195,'Hefti','Philip'),(196,'Heisinger','Brent'),(197,'Henking','Christian'),(198,'Henshall','Dalwyn'),(199,'Heri','Urs'),(200,'Hesheng','Wang'),(201,'Hesketh','Kenneth'),(202,'Hespe','George'),(203,'Hess','Nigel'),(204,'Hidas','Frigyes'),(205,'Hilber','Johann Baptist'),(206,'Hindemith','Paul'),(207,'Hirose','Hayato'),(208,'Hodel','Stephan'),(209,'Hokoyama','Wataru'),(210,'Holst','Gustav'),(211,'Horber','Werner'),(212,'Horovitz','Joseph'),(213,'Hosay','James L.'),(214,'Houben','Kevin'),(215,'Howells','Herbert'),(216,'Huber','Paul'),(217,'Huckeby','Ed'),(218,'Huggens','Ted'),(219,'Husa','Karel'),(220,'Iannaccone','Anthony'),(221,'Ireland','John'),(222,'Ishihara','Tadaoki'),(223,'Ito','Yasuhide'),(224,'Jabovski','Tony'),(225,'Jackman','Andrew'),(226,'Jacob','Gordon'),(227,'Jadin','Luois Emmanuel'),(228,'Jaeggi','Stephan'),(229,'Jager','Robert'),(230,'Janssen','Harrie'),(231,'Jeanbourquin','Marc'),(232,'Jenkins','Cyrill'),(233,'Jenkins','Darren W.'),(234,'Jenny','Albert'),(235,'Jiskra','Josef'),(236,'Johnson','Stuart'),(237,'Johnstone','Wesley'),(238,'Jonak','Zdenek'),(239,'Jones','Dean'),(240,'Joseph','Walter'),(241,'Kalinnikov','Vasily'),(242,'Kee','Cor'),(243,'Keighley','Thomas'),(244,'Kelly','Brian'),(245,'Kernen','Roland'),(246,'Kerwin','Simon'),(247,'Khachaturian','Aram'),(248,'Kläntschi','Kevin'),(249,'Kleeb','Sales'),(250,'Klohs','Matt'),(251,'Kofler','Armin'),(252,'Kolly','Jean-Claude'),(253,'Konagaya','Soichi'),(254,'König','Herbert'),(255,'Königshofer','Franz'),(256,'Kopetz','Barry E.'),(257,'Kozhevnikov','Boris'),(258,'Kraas','Thiemo'),(259,'Kratz','Anton E.'),(260,'Krauer','Nicolas'),(261,'Krieger','Johann'),(262,'Künzli','Fabian'),(263,'Kurmann','Edy'),(264,'Kuwahara','Hiroaki'),(265,'La Plante','Pierre'),(266,'Lalo','Eduard'),(267,'Lancen','Serge'),(268,'Langford','Gordon'),(269,'Lankester','Coby'),(270,'Larsen','Jacob Vilhelm'),(271,'Legrady','Thomas'),(272,'Lehnherr','Rudolf'),(273,'Leidzen','Eric'),(274,'Lendvay','Kamillo'),(275,'Liechti','Walter'),(276,'Linckus','Florian'),(277,'Liszt','Franz'),(278,'Llano',''),(279,'Lloyd','George'),(280,'Lorriman','Howard'),(281,'Lovatt-Cooper','Paul'),(282,'Luessi','Peter'),(283,'Lukas','Zdenek'),(284,'Mackereth','Andrew R.'),(285,'Mackey','John'),(286,'MacRay','Robert'),(287,'Maddeford','Lee'),(288,'Mariotti','Giuliano'),(289,'Marlatt','David'),(290,'Marquis','Olivier'),(291,'Marti','Patrik'),(292,'Mashima','Toshio'),(293,'Maslanka','David'),(294,'McBeth','Francis W.'),(295,'McBride','Cory J.'),(296,'McCabe','John'),(297,'Meechan','Peter'),(298,'Meier','Jost'),(299,'Melillo','Stephen'),(300,'Mendelssohn','Felix'),(301,'Mersson','Boris'),(302,'Mertens','Hardy'),(303,'Michel','Jean-François'),(304,'Michiels','Charles'),(305,'Milhaud','Darius'),(306,'Mills','Nic'),(307,'Moeckel','Hans'),(308,'Moerman','Wilco'),(309,'Mogensen','Michael A.'),(310,'Moren','Bertrand'),(311,'Moret','Oscar'),(312,'Mortimer','John Glenesk'),(313,'Muoth','Alwin'),(314,'Mussorgsky','Modest'),(315,'Navarro González','Óscar'),(316,'Neeck','Larry'),(317,'Nelhybel','Vaclav'),(318,'Nelson','Ron'),(319,'Neuböck','Fritz'),(320,'Neurohr','Ludovic'),(321,'Newsome','Roy'),(322,'Newton','Rodney'),(323,'Nicolai','Otto'),(324,'Niehaus','Lennie'),(325,'Nieuwenhuis','Stan'),(326,'Nogueroles','Eduardo'),(327,'Norbury','Kevin'),(328,'Nussbaumer','Dany'),(329,'Nussbaumer','Marco'),(330,'Offenbach','Jacques'),(331,'O\'Reilly','John'),(332,'Osgood','Donald'),(333,'Osterling','Eric'),(334,'Pallhuber','Hermann'),(335,'Penders','Jef'),(336,'Perkin','Helen'),(337,'Persichetti','Vincent'),(338,'Pirola','Carlo'),(339,'Pizzini','Carlo Alberto'),(340,'Platts','Kenneth'),(341,'Ponsford','Steven'),(342,'Praetorius','Michael'),(343,'Price','R. Maldwyn'),(344,'Pusceddu','Lorenzo'),(345,'Pütz','Marco'),(346,'Ránky','György'),(347,'Redhead','Robert'),(348,'Reed','Alfred'),(349,'Reed','H. Owen'),(350,'Rehfeld','Kurt'),(351,'Reineke','Steven'),(352,'Reinhardt','Rudolf'),(353,'Reissiger','C. Gottlob'),(354,'Renggli','Manuel'),(355,'Renggli','Rudolf'),(356,'Respighi','Ottorino'),(357,'Richards','Goff'),(358,'Richardson','Norman'),(359,'Rimmer','Drake'),(360,'Rimmer','William'),(361,'Rimski-Korsakov','Nicolai'),(362,'Rodenmacher','Luc'),(363,'Roels','Stijn'),(364,'Roemers','Kris'),(365,'Roger','Roger'),(366,'Roh','Julien'),(367,'Rossini','Gioacchino'),(368,'Rudin','Rolf'),(369,'Rüedi','Thomas'),(370,'Running','Arne'),(371,'Rütti','Carl'),(372,'Sagnol','Pierre-Etienne'),(373,'Sakai','Itaru'),(374,'Salnikov','Georgi'),(375,'Scheffer','Pi'),(376,'Schmidhäusler','Pierre'),(377,'Schmitt','Théo'),(378,'Schneider','Manfred'),(379,'Schoenberg','Arnold'),(380,'Schoenenberger','Heinz'),(381,'Schoonenbeek','Kees'),(382,'Schostakowitsch','Dimitrij'),(383,'Schulé','Bernard'),(384,'Schulte','Andreas Ludwig'),(385,'Schwarz','Otto M.'),(386,'Segers','Jan'),(387,'Shaffer','David'),(388,'Sharman','Paul'),(389,'Sheldon','Robert'),(390,'Shimizu','Daisuke'),(391,'Sialm','Giusep'),(392,'Siebert','Edrich'),(393,'Simpson','Robert'),(394,'Smith','Claude T.'),(395,'Smith','Rob'),(396,'Smith','Robert W.'),(397,'Somadossi','Marco'),(398,'Sparke','Philip'),(399,'Spurgin','Anthony'),(400,'Stalmeier','Piet'),(401,'Stanek','Pavel'),(402,'Steadman-Allen','Ray'),(403,'Steinbeck','Heinrich'),(404,'Strategier','Hermann'),(405,'Street','Allan'),(406,'Suñer-Oriola','José'),(407,'Susato','Tilman'),(408,'Swearingen','James'),(409,'Swiggers','Eric'),(410,'Tabete','Tomohiro'),(411,'Tailleferre','Germaine'),(412,'Tailor','Norman'),(413,'Taruya','Masanori'),(414,'Tarver','James L.'),(415,'Ticheli','Frank'),(416,'Toebosch','Louis'),(417,'Tooley','Matthew M.'),(418,'Trachsel','Thomas'),(419,'Traditional',''),(420,'Travis','Timothy'),(421,'Tschaikowsky','Pjotr Iljitsch'),(422,'Tull','Fisher'),(423,'Urfer','Frank'),(424,'Van Baelen','Frank'),(425,'Van der Roost','Jan'),(426,'van der Velde','Rieks'),(427,'van Lijnschooten','Henk'),(428,'van Tuinen','Feike'),(429,'Vancura','Adolf'),(430,'Vargas','Leon'),(431,'Vaughan Williams','Ralph'),(432,'Vavrinecz','Béla'),(433,'Vean','William'),(434,'Veit','Gottfried'),(435,'Vinter','Gilbert'),(436,'Vlak','Kees'),(437,'Vliex','Leon'),(438,'Voegelin','Fritz'),(439,'von Suppé','Franz'),(440,'Waart','Jan van der'),(441,'Wada','Naoya'),(442,'Waespi','Oliver'),(443,'Wagner','Philipp'),(444,'Wagner','Richard'),(445,'Wahlich','Marcel'),(446,'Waignein','André'),(447,'Wallimann','Emil'),(448,'Walters','Harold L.'),(449,'Ward','Robert'),(450,'Webber','Andrew Lloyd'),(451,'Weber','Kurt'),(452,'Whear','Paul W.'),(453,'Widmer','Ernst'),(454,'Wiggins','Bram'),(455,'Wilby','Philip'),(456,'Williams','Clifton'),(457,'Wiltgen','Roland'),(458,'Wimmer','Alois'),(459,'Wittrock','Carl'),(460,'Wong','Kah Chun'),(461,'Wood','Gareth'),(462,'Wood','Samuel B.'),(463,'Woodhouse','Charles'),(464,'Woolfenden','Guy'),(465,'Wright','Denis'),(466,'Wright','Frank'),(467,'Wright','Kenneth'),(468,'Wyckhuys','Dominique'),(469,'Yagisawa','Satoshi'),(470,'Yeo','Benjamin'),(471,'Yoder','Paul'),(472,'Yorke','Peter'),(473,'Zeh','Michael'),(474,'Zihlmann','Hans'),(475,'Zurwerra','Eduard'),(476,'Schyns','José'),(477,'Singerling','Jan W.'),(478,'Annema','Dirk'),(479,'Baumgartner','J.'),(480,'Bourgeois','John R.'),(481,'Brand','Geoffrey'),(482,'Broer','Jac'),(483,'Buitenhuis','Gert'),(484,'Cafarella','Antonio'),(485,'Cecil','Leonard'),(486,'Cober','Jan'),(487,'Courtain','A.'),(488,'Cushing','Charles'),(489,'De Wolf','Karel'),(490,'Delhaye','Robert'),(491,'Diedman','Marten'),(492,'Dietziker','Thomas'),(493,'Dutoit','Charles'),(494,'Egner','Hermann'),(495,'Farr','Ray'),(496,'Fennell','Frederick'),(497,'Fischer','André'),(498,'Godfrey',''),(499,'Hindsley','Mark H.'),(500,'Hume','Rob J.'),(501,'Hunsberger','D.'),(502,'Jansen','Erik'),(503,'Kimura','Yoshihiro'),(504,'Konrad','Robert'),(505,'Kurmann','Tony'),(506,'Lange','Lars J.'),(507,'McBride','M. Scott'),(508,'Mellema','Cor'),(509,'Mol','Gosling'),(510,'Molenaar','Jan'),(511,'Moreau','Georges'),(512,'Müller','J.H.'),(513,'Odom','Lawerence'),(514,'Oosterman','Danny'),(515,'Paynter','John P.'),(516,'Peeters','Marcel'),(517,'Robinson','Wayne'),(518,'Sayre','Charles'),(519,'Somers','Erik'),(520,'Stauffer','D.W.'),(521,'Stoffels','Jo'),(522,'Sydney','Herbert'),(523,'Takahashi','Tohru'),(524,'van Gils','Mari'),(525,'van Kammen',''),(526,'van Lijnschooten','Henk'),(527,'Well','David'),(528,'Wilkinson','K.'),(529,'Willi','Daniel'),(530,'Winterbottom','Frank'),(531,'Woodfield','Ray'),(532,'Yperen','Rocus van'),(533,'Zurmühle','Otto');
/*!40000 ALTER TABLE `t_compositeur` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_detailcommande`
--

DROP TABLE IF EXISTS `t_detailcommande`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_detailcommande` (
  `FK_Piece` int(11) NOT NULL,
  `FK_Commande` int(11) NOT NULL,
  `Quantite` int(11) DEFAULT NULL,
  PRIMARY KEY (`FK_Piece`,`FK_Commande`),
  KEY `fk_t_piece_has_T_Commande_T_Commande1_idx` (`FK_Commande`),
  KEY `fk_t_piece_has_T_Commande_t_piece1_idx` (`FK_Piece`),
  CONSTRAINT `fk_t_piece_has_T_Commande_T_Commande1` FOREIGN KEY (`FK_Commande`) REFERENCES `t_commande` (`PK_Commande`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_t_piece_has_T_Commande_t_piece1` FOREIGN KEY (`FK_Piece`) REFERENCES `t_piece` (`PK_Piece`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_detailcommande`
--

LOCK TABLES `t_detailcommande` WRITE;
/*!40000 ALTER TABLE `t_detailcommande` DISABLE KEYS */;
INSERT INTO `t_detailcommande` VALUES (2,27,3),(2,40,2),(6,20,4),(7,81,5),(10,33,4),(13,92,4),(15,72,5),(16,7,1),(16,44,3),(16,56,1),(16,78,4),(17,11,4),(19,52,1),(21,79,4),(21,97,2),(22,11,3),(22,46,2),(26,12,3),(28,49,1),(29,91,1),(33,76,1),(36,82,5),(39,7,5),(39,13,5),(40,48,2),(43,9,5),(43,69,1),(43,83,3),(45,73,5),(46,68,5),(49,67,3),(49,71,3),(50,22,2),(50,40,2),(55,90,2),(56,76,5),(58,22,5),(58,83,3),(61,18,3),(61,69,2),(63,22,3),(64,45,3),(65,45,5),(66,32,5),(66,51,2),(67,41,5),(69,16,4),(73,10,3),(74,49,5),(74,100,1),(76,67,3),(77,37,4),(77,72,5),(77,73,1),(78,89,5),(79,77,4),(82,22,2),(82,38,2),(83,27,5),(84,85,1),(86,25,3),(89,10,2),(89,59,4),(90,84,4),(91,23,4),(93,72,2),(94,82,4),(100,24,5),(105,43,4),(106,100,2),(108,62,4),(110,50,4),(110,101,5),(111,51,2),(112,66,1),(114,43,3),(114,90,5),(116,22,2),(117,24,1),(120,71,3),(121,1,1),(122,24,1),(122,37,5),(125,56,1),(125,68,5),(125,75,5),(126,55,3),(127,74,5),(130,16,3),(131,2,5),(132,12,2),(133,18,4),(133,26,1),(133,43,2),(133,63,5),(133,86,1),(134,84,4),(134,100,4),(134,102,3),(136,6,2),(136,85,4),(136,95,4),(139,11,4),(139,54,5),(140,1,4),(141,4,1),(141,27,1),(144,3,5),(144,35,1),(145,15,5),(146,56,5),(147,72,5),(149,28,5),(150,65,5),(152,101,2),(153,2,3),(153,67,1),(154,24,4),(154,91,4),(154,92,5),(156,21,2),(156,63,1),(157,7,5),(163,6,1),(163,35,3),(163,61,1),(164,7,2),(165,43,2),(165,63,5),(168,7,4),(170,53,2),(172,22,5),(173,83,3),(175,27,5),(175,65,1),(176,45,3),(179,32,3),(179,43,2),(179,45,2),(179,92,1),(180,93,3),(188,29,5),(190,48,4),(190,75,2),(191,83,2),(193,57,3),(196,81,2),(197,33,5),(198,60,4),(198,71,3),(198,90,1),(203,10,1),(203,40,5),(204,100,4),(206,83,3),(209,32,1),(212,84,1),(213,88,4),(218,56,2),(219,28,3),(220,55,5),(221,25,1),(221,78,1),(222,68,4),(226,21,1),(227,42,1),(228,63,4),(230,9,3),(231,61,2),(232,19,4),(233,51,4),(233,102,4),(237,65,3),(238,71,3),(240,22,4),(240,86,5),(241,15,3),(242,39,2),(242,80,1),(245,3,4),(246,34,4),(246,48,5),(248,71,1),(249,103,1),(250,25,1),(251,40,1),(251,89,2),(251,100,2),(252,66,5),(253,50,1),(257,54,4),(257,104,1),(258,48,1),(259,57,1),(260,78,2),(262,42,3),(263,93,1),(265,43,2),(265,92,3),(270,8,5),(271,97,1),(272,26,4),(272,97,2),(273,79,2),(274,12,1),(278,88,4),(281,58,3),(285,75,2),(286,90,3),(287,20,5),(288,37,1),(289,54,1),(290,39,3),(295,38,2),(297,15,5),(298,93,4),(299,10,5),(299,55,2),(300,87,4),(302,18,5),(303,8,2),(303,40,4),(304,99,3),(306,35,2),(307,57,3),(308,95,1),(310,6,5),(310,20,2),(310,55,2),(310,59,3),(310,83,2),(310,90,2),(311,97,1),(312,96,3),(312,104,4),(313,8,5),(315,19,2),(316,99,5),(319,34,2),(320,85,1),(322,76,5),(323,85,1),(324,97,2),(325,66,3),(326,39,5),(326,87,2),(327,2,3),(327,46,5),(327,65,3),(327,75,5),(327,78,1),(328,103,4),(329,67,3),(330,74,5),(331,7,4),(334,37,3),(334,67,3),(335,56,3),(337,86,1),(337,93,2),(339,51,5),(341,94,5),(344,93,1),(345,8,2),(345,9,1),(347,19,2),(352,2,4),(352,29,3),(352,47,2),(352,82,1),(353,91,3),(355,98,1),(355,104,1),(357,32,4),(361,67,1),(364,86,3),(365,24,2),(365,87,5),(366,19,2),(367,80,2),(368,67,4),(370,21,4),(374,13,2),(374,94,4),(375,100,4),(380,19,4),(383,41,3),(386,63,4),(388,63,2),(395,51,4),(395,67,4),(395,97,3),(398,23,5),(400,60,2),(402,43,4),(402,50,2),(402,89,2),(403,93,5),(404,69,4),(405,54,5),(407,25,2),(407,102,4),(408,85,1),(411,56,3),(412,100,1),(413,6,2),(413,8,5),(413,21,5),(415,76,4),(416,80,5),(417,100,2),(418,42,2),(420,88,3),(421,69,4),(421,71,3),(422,91,1),(424,66,3),(425,65,2),(425,73,3),(426,36,1),(427,97,3),(429,71,5),(430,99,1),(435,37,3),(435,45,1),(436,20,3),(438,7,1),(441,50,2),(444,68,3),(445,23,1),(448,29,1),(449,62,1),(451,2,2),(452,47,1),(454,48,2),(454,94,2),(454,95,5),(454,103,3),(455,5,4),(455,88,2),(456,96,4),(457,90,2),(460,48,2),(463,28,1),(463,69,2),(468,61,4),(468,76,5),(469,26,5),(469,44,1),(471,13,2),(471,46,3),(472,89,4),(472,90,4),(472,101,3),(476,44,2),(476,103,1),(477,40,1),(482,33,2),(483,22,4),(484,53,5),(484,89,3),(485,32,2),(485,61,4),(486,72,2),(487,15,1),(487,31,2),(488,96,5),(489,51,4),(490,31,3),(495,86,1),(495,99,5),(496,49,2),(496,89,1),(497,64,5),(498,10,5),(498,79,4),(500,28,1),(502,8,5),(502,12,3),(504,5,2),(504,76,4),(505,27,2),(507,77,4),(510,3,2),(510,100,5),(511,17,1),(511,42,1),(516,41,3),(517,22,5),(517,94,1),(518,25,3),(518,40,3),(523,32,5),(527,43,3),(527,81,3),(532,64,1),(533,40,5),(533,59,2),(536,25,4),(537,7,3),(538,43,1),(539,12,5),(540,31,2),(540,62,5),(540,99,4),(541,14,2),(541,67,3),(541,77,5),(541,101,5),(542,13,4),(542,63,2),(542,67,2),(545,37,3),(546,50,2),(547,63,4),(547,72,1),(548,96,4),(549,48,4),(550,66,3),(550,77,1),(551,51,2),(551,57,5),(552,96,4),(554,85,2),(558,27,3),(559,59,2),(559,72,2),(559,90,2),(561,92,5),(561,94,1),(562,68,3),(563,75,4),(564,72,3),(566,3,5),(566,98,4),(568,12,2),(568,95,5),(569,92,4),(569,101,3),(570,67,5),(570,84,3),(573,23,4),(574,40,4),(574,89,3),(574,99,3),(575,38,3),(575,39,3),(577,16,3),(577,88,1),(579,95,1),(580,37,2),(580,64,5),(580,67,3),(581,38,1),(582,56,5),(583,8,3),(583,75,1),(584,5,3),(590,19,2),(590,89,3),(591,62,4),(591,65,5),(592,98,2),(593,54,2),(594,30,4),(594,102,3),(595,31,4),(597,26,1),(599,72,3),(600,25,2),(601,28,2),(601,31,2),(601,74,2),(604,36,4),(604,59,4),(605,13,2),(606,43,5),(607,40,5),(608,42,2),(609,56,3),(611,15,2),(612,68,2),(615,68,4),(615,102,3),(617,30,1),(617,99,4),(618,3,4),(620,34,3),(622,12,1),(627,79,5),(629,38,5),(629,72,4),(630,26,2),(631,44,1),(632,22,5),(632,82,3),(633,52,5),(633,93,2),(634,26,3),(637,64,4),(638,64,5),(639,83,4),(642,32,1),(645,47,5),(646,45,2),(650,78,4),(651,68,3),(653,100,3),(655,1,1),(657,46,5),(659,79,5),(661,12,2),(663,89,1),(666,27,4),(666,34,2),(670,5,2),(671,79,3),(672,45,3),(673,25,4),(673,52,3),(674,34,1),(675,59,5),(677,96,4),(681,77,2),(683,25,5),(684,62,2),(685,28,4),(685,94,2),(686,35,4),(686,59,5),(687,53,3),(687,64,1),(687,104,4),(689,100,4),(692,22,5),(693,49,1),(695,61,4),(697,28,5),(699,7,5),(699,96,4),(702,100,3),(703,11,4),(703,102,3),(704,49,3),(705,28,5),(705,58,1),(710,84,1),(711,52,5),(712,17,2),(712,58,2),(712,67,3),(714,93,1),(715,29,2),(715,88,3),(717,59,3),(717,100,2),(720,59,5),(722,37,3),(723,4,1),(723,75,5),(724,26,5),(725,51,5),(725,69,3),(726,68,4),(726,70,2),(728,55,4),(731,41,4),(731,102,2),(741,7,1),(741,104,4),(742,91,1),(743,25,2),(743,31,3),(744,88,3),(745,76,3),(745,92,4),(746,47,3),(748,34,1),(749,35,4),(749,62,5),(750,17,5),(755,31,4),(757,33,1),(758,1,2),(758,30,5),(758,85,5),(759,20,4),(760,88,1),(761,31,5),(762,33,3),(764,36,3),(766,20,1),(767,12,4),(767,80,3),(769,91,5),(771,12,2),(773,9,5),(774,18,4),(774,39,4),(775,57,4),(776,24,2),(777,77,5),(779,15,5),(783,95,3),(784,2,5),(784,47,1),(785,22,5),(785,45,4),(786,100,2),(787,14,1),(787,23,5),(787,76,4),(789,41,3),(792,26,1),(793,12,4),(795,67,1),(795,97,2),(796,61,5),(797,6,4),(799,54,5),(801,18,1),(802,92,1),(804,7,2),(805,81,1),(807,76,4),(808,10,4),(808,61,1),(809,84,4),(810,4,3),(811,59,2),(813,22,4),(813,38,5),(814,35,5),(814,72,4),(815,88,2),(815,99,3),(817,104,5),(820,93,2),(821,19,1),(821,29,3),(822,89,2),(823,87,4),(825,86,4),(826,86,5),(827,56,2),(827,64,5),(829,57,3),(830,38,1),(830,41,4),(832,33,2),(832,84,4),(833,9,4),(834,82,3),(834,87,3),(835,21,2),(836,60,3),(837,24,2),(838,87,4),(839,12,3),(839,34,5),(839,81,1),(840,63,5),(841,65,3),(844,20,5),(844,54,4),(846,18,1),(846,68,4),(848,17,1),(849,4,5),(851,60,2),(852,21,1),(852,48,1),(853,15,1),(855,8,3),(855,30,2),(861,5,4),(861,50,2),(863,72,3),(863,104,3),(865,50,2),(865,77,1),(869,50,3),(874,33,1),(874,72,3),(875,23,3),(875,74,5),(876,83,2),(878,45,2),(880,85,1),(881,37,3),(881,73,1),(883,20,2),(884,34,5),(884,76,4),(885,10,1),(886,5,2),(886,85,4),(888,99,3),(892,39,4),(892,95,1),(893,58,3),(893,60,5),(895,49,3),(895,67,3),(896,95,1),(901,16,1),(901,60,1),(901,76,3),(902,9,4),(903,44,5),(903,67,4),(904,6,1),(905,99,4),(907,69,3),(908,13,1),(910,17,1),(911,72,4),(911,85,2),(913,50,3),(917,40,3),(919,53,4),(921,39,3),(921,44,4),(922,41,1),(926,60,3),(928,79,2),(932,64,5),(932,90,3),(934,8,2),(935,23,2),(936,51,2),(937,14,4),(937,50,3),(939,69,1),(946,2,3),(946,73,3),(952,51,1),(953,89,4),(955,68,3),(955,84,2),(955,99,3),(956,27,2),(956,62,5),(956,93,1),(958,64,1),(959,52,1),(961,20,3),(961,30,2),(962,31,4),(963,32,1),(964,52,1),(964,95,4),(965,1,5),(965,81,2),(968,83,4),(968,102,5),(969,34,1),(969,79,3),(971,66,2),(972,18,5),(975,19,1),(977,22,1),(977,49,3),(977,81,3),(979,63,5),(979,104,3),(980,93,1),(983,46,3),(986,61,1),(988,71,3),(988,72,1),(990,103,2),(991,67,1),(991,74,5),(991,77,3),(994,79,1),(995,49,5),(996,97,3),(996,103,4),(997,12,1),(999,27,3),(999,31,5),(1000,28,2),(1000,73,5),(1000,98,2),(1002,100,4),(1003,6,1),(1005,28,2),(1006,99,3),(1007,13,4),(1009,62,4),(1009,70,5),(1009,88,1),(1010,1,2),(1010,102,1),(1012,97,2),(1013,11,3),(1014,99,5),(1015,69,4),(1019,51,5),(1019,52,5),(1020,50,3),(1021,22,4),(1022,48,5),(1023,52,2),(1024,79,3),(1025,44,4),(1032,6,3),(1033,44,4),(1033,93,1),(1033,101,2),(1034,87,5),(1036,87,4),(1037,88,2),(1038,91,4),(1040,42,3),(1041,62,1),(1042,21,2),(1042,23,4),(1042,95,1),(1043,62,4),(1044,43,4),(1044,93,4),(1044,101,5),(1045,12,2),(1045,93,3),(1046,49,1),(1049,23,1),(1050,70,4),(1051,18,1),(1054,38,5),(1055,50,4),(1056,56,5),(1056,59,1),(1057,9,1),(1057,47,5),(1058,48,5),(1059,80,3),(1060,19,4),(1061,60,2),(1062,40,4),(1062,104,4),(1063,62,4),(1064,37,5),(1065,15,1),(1065,36,2),(1065,41,2),(1065,55,3),(1065,68,5),(1072,14,3),(1073,46,4),(1074,99,3),(1078,94,3),(1081,1,1),(1081,76,2),(1083,39,5),(1086,85,2),(1087,3,4),(1087,22,5),(1088,14,2),(1088,92,5),(1090,22,2),(1090,37,5),(1091,100,3),(1096,89,5),(1098,82,1),(1098,101,3),(1098,102,3),(1100,36,2),(1101,91,4),(1102,11,4),(1108,92,1),(1110,20,2),(1110,98,2),(1111,25,4),(1111,32,3),(1111,73,2),(1114,7,4),(1115,22,2),(1116,25,4),(1116,97,3),(1117,8,5),(1124,99,3),(1128,76,4),(1129,5,4),(1131,74,1),(1134,10,5),(1136,62,2),(1138,24,4),(1138,43,2),(1139,75,1),(1140,28,4),(1142,83,3),(1144,8,5),(1145,20,3),(1147,24,3),(1147,34,4),(1147,56,1),(1147,61,2),(1148,38,3),(1150,32,2),(1150,69,3),(1150,73,5),(1150,101,3),(1151,21,4),(1152,90,5),(1153,77,2),(1153,83,3),(1154,66,3),(1154,97,4),(1155,99,4),(1156,55,2),(1157,45,1),(1157,93,4),(1159,76,4),(1160,91,1),(1163,62,5),(1164,48,4),(1164,68,3),(1165,34,5),(1165,49,2),(1165,96,1),(1166,13,2),(1168,7,1),(1168,42,3),(1168,69,3),(1170,11,5),(1170,70,4),(1173,13,2),(1173,67,1),(1174,57,2),(1176,70,5),(1177,102,5),(1178,55,1),(1181,87,1),(1182,87,3),(1182,88,3),(1183,76,1),(1187,96,2),(1188,8,5),(1188,83,2),(1188,99,2),(1189,9,5),(1190,60,2),(1191,92,1),(1192,63,5),(1194,29,1),(1194,45,2),(1194,69,2),(1194,76,5),(1194,81,2),(1194,101,5),(1205,69,2),(1205,80,5),(1207,30,2),(1209,40,1),(1213,34,4),(1214,17,3),(1214,25,4),(1214,39,2),(1214,79,1),(1216,20,1),(1219,40,5),(1219,97,1),(1219,100,4),(1224,68,4),(1225,22,2),(1225,74,1),(1228,67,1),(1228,89,2),(1230,66,5),(1231,49,2),(1231,56,2),(1232,85,1),(1233,11,2),(1233,14,5),(1237,24,4),(1238,15,2),(1242,3,5),(1245,24,3),(1245,38,1),(1246,100,3),(1247,13,3),(1247,27,1),(1247,50,3),(1248,84,3),(1249,59,3),(1249,86,3),(1249,90,1),(1251,61,5),(1252,9,2),(1253,33,2),(1253,89,1),(1254,13,1),(1256,38,4),(1257,30,5),(1257,57,3),(1257,78,3),(1261,86,1),(1262,27,4),(1262,53,5),(1262,79,2),(1263,54,4),(1267,48,1),(1269,12,1),(1270,6,4),(1271,90,5),(1273,4,5),(1273,20,2),(1273,31,1),(1274,50,2),(1274,99,5),(1277,12,5),(1277,37,5),(1278,80,4),(1279,79,3),(1279,89,4),(1280,99,3),(1281,32,1),(1284,74,3),(1285,62,1),(1286,74,1),(1286,97,2),(1286,103,2),(1287,22,2),(1287,76,3),(1288,52,1),(1288,67,1),(1288,81,3),(1290,17,3),(1290,96,3),(1291,47,5),(1291,99,2),(1292,50,1),(1292,74,3),(1293,69,1),(1294,28,5),(1296,43,3),(1298,26,2),(1299,1,4),(1299,70,3),(1301,58,2),(1301,76,1),(1301,100,5),(1302,75,2),(1305,68,5),(1306,26,1),(1306,63,5),(1306,91,3),(1307,92,5),(1308,11,2),(1308,55,3),(1311,65,1),(1313,97,3),(1314,55,2),(1315,4,1),(1315,33,4),(1317,26,3),(1317,34,4),(1318,5,4),(1319,42,4),(1320,89,5),(1320,101,4),(1321,5,2),(1322,36,5),(1324,69,1),(1325,8,3),(1327,14,4),(1327,21,2),(1327,47,3),(1327,85,1),(1329,17,3),(1330,66,2),(1330,81,4),(1331,86,2),(1334,4,4),(1335,96,2),(1338,76,4),(1339,83,4),(1342,86,2),(1343,50,1),(1347,92,4),(1348,56,3),(1350,52,4),(1351,8,5),(1356,39,2),(1360,29,3),(1363,40,2),(1366,29,2),(1366,55,3),(1367,87,1),(1370,22,4),(1371,81,5),(1373,3,5),(1373,77,2),(1374,65,3),(1377,98,2),(1378,82,3),(1382,52,3),(1383,35,3),(1384,11,4),(1384,49,4),(1386,38,1),(1386,70,4),(1386,72,3),(1389,3,3),(1389,67,1),(1391,2,5),(1393,62,3),(1394,8,2),(1395,70,1),(1397,24,4),(1397,65,5),(1397,67,5),(1399,100,2),(1400,13,1),(1401,71,2),(1401,76,1),(1404,64,5),(1405,62,4),(1405,81,4),(1406,68,1),(1407,19,1),(1408,79,3),(1409,81,4),(1411,8,3),(1411,23,4),(1412,21,3),(1413,66,2),(1413,81,3),(1414,14,2),(1414,96,5),(1415,10,4),(1417,34,1),(1417,41,3),(1417,103,3),(1419,88,3),(1419,95,1),(1420,64,3),(1420,79,4),(1421,8,2),(1422,49,2),(1423,7,1),(1423,16,4),(1424,10,1),(1426,22,3),(1426,48,2),(1426,64,1),(1427,63,2),(1428,23,4),(1428,57,2),(1429,92,2),(1431,75,5),(1433,41,4),(1433,83,4),(1437,22,5),(1438,1,1),(1438,53,1),(1440,16,1),(1440,33,5),(1441,64,3),(1442,9,3),(1442,32,5),(1443,68,4),(1444,93,3),(1445,99,3),(1446,42,4),(1447,77,3),(1448,104,3),(1449,35,3),(1450,31,4),(1451,39,5),(1453,77,4),(1454,48,5),(1456,8,5),(1456,27,1),(1456,65,4),(1458,69,2),(1460,95,4),(1461,14,4),(1461,54,5),(1461,73,1),(1461,78,1),(1462,69,3),(1462,93,3),(1463,99,3),(1464,62,4),(1465,53,4),(1465,79,4),(1465,82,4),(1466,16,3),(1467,41,3),(1472,29,2),(1472,99,1),(1474,4,3),(1475,74,1),(1476,82,1),(1476,94,2),(1477,53,2),(1478,77,3),(1479,71,4),(1480,79,2),(1481,35,4),(1482,79,3),(1486,74,1),(1487,23,2),(1491,14,1),(1491,17,4),(1491,33,4),(1492,44,3),(1492,89,2),(1494,64,3),(1494,90,1),(1495,2,1),(1495,26,4),(1495,95,1),(1496,19,3),(1497,5,3),(1500,22,5),(1502,19,3),(1502,65,5),(1502,70,3),(1503,50,5),(1504,24,1),(1504,94,2),(1507,54,1),(1509,89,2),(1510,60,4),(1511,3,1),(1512,88,4),(1512,101,4),(1513,102,5),(1514,62,5),(1515,38,4),(1516,42,1),(1517,15,1),(1517,39,3),(1517,46,1),(1517,72,4),(1520,77,3),(1520,84,4),(1521,27,5),(1524,99,1),(1529,17,2),(1530,2,1),(1530,65,1),(1531,77,4),(1532,22,3),(1533,82,5),(1534,18,2),(1534,48,1),(1535,82,5),(1536,57,1),(1537,13,1),(1539,8,5),(1540,29,1),(1543,100,3),(1548,30,5),(1553,55,2),(1553,102,3),(1556,20,1),(1557,23,1),(1557,26,1),(1557,69,1),(1558,93,4),(1560,52,5),(1561,24,3),(1562,54,1),(1563,101,2),(1564,84,5),(1565,80,1),(1567,27,4),(1569,77,1),(1573,19,2),(1574,70,3),(1576,12,5),(1579,80,1),(1581,6,4),(1584,56,2),(1584,62,2),(1584,87,1),(1586,104,4),(1588,41,3),(1594,60,5),(1595,49,5),(1598,3,3),(1598,77,5),(1599,2,5),(1600,29,2),(1602,81,2),(1603,42,4),(1605,41,3),(1606,94,3),(1607,29,1),(1609,36,4),(1609,89,5),(1613,5,2),(1613,19,2),(1613,92,5),(1614,81,2),(1617,96,4),(1618,24,2),(1619,9,1),(1620,37,3),(1621,85,5),(1624,18,2),(1624,20,3),(1624,40,5),(1625,46,2),(1626,40,3),(1627,36,3),(1628,98,5),(1630,57,4),(1631,27,3),(1635,27,1),(1636,10,3),(1636,42,3),(1636,93,3),(1637,54,1),(1639,55,2),(1641,4,4),(1641,10,1),(1642,20,2),(1646,44,3),(1646,98,5),(1646,104,5),(1647,11,3),(1649,12,2),(1649,71,5),(1651,78,4),(1651,98,2),(1653,89,1),(1654,79,5),(1660,89,3),(1663,55,5),(1664,41,3),(1664,101,2),(1669,6,4),(1670,17,2),(1670,39,2),(1670,72,2),(1670,79,3),(1671,19,1),(1673,45,3),(1673,46,2),(1674,38,5),(1674,52,5),(1675,55,4),(1677,6,5),(1678,32,4),(1678,56,4),(1680,48,2),(1680,62,1),(1681,69,5),(1681,93,2),(1683,70,5),(1686,71,3),(1686,98,1),(1687,12,3),(1687,67,4),(1687,82,5),(1689,49,4),(1690,48,1),(1691,21,3),(1693,49,1),(1693,53,1),(1693,102,1),(1694,20,5),(1694,69,4),(1697,84,4),(1699,74,4),(1703,2,4);
/*!40000 ALTER TABLE `t_detailcommande` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_edition`
--

DROP TABLE IF EXISTS `t_edition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_edition` (
  `PK_Edition` int(11) NOT NULL,
  `Abreviation` varchar(4) NOT NULL,
  `Edition` varchar(45) NOT NULL,
  PRIMARY KEY (`PK_Edition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_edition`
--

LOCK TABLES `t_edition` WRITE;
/*!40000 ALTER TABLE `t_edition` DISABLE KEYS */;
INSERT INTO `t_edition` VALUES (1,'Run','Musikverlag RUNDEL GmbH'),(2,'Ad','Adler, Bad Aussee'),(3,'Adv','Advance'),(4,'AirG','AirG-Music Editions, Auvernier'),(5,'Alb','Albadoc, Valencia, E'),(6,'Ams','Amstel Music, Amsterdam'),(7,'And','Andrieu Frères, Paris'),(8,'Ang','Anglo Music Press, Wembley GB'),(9,'Arc','ARCON MUSIC, Azmoos'),(10,'Ari','Ariel Music, Oxfordshire, GB'),(11,'Ass','Associated Music Publishers, USA'),(12,'Bar','Barnhouse Co., Oskaloosa, Iowa'),(13,'Bat','Baton, Eindhoven, NL'),(14,'Bau','Bauer, Karlsruhe'),(15,'Bel','Belwin Mills, Melville, NY'),(16,'BeM','Beriato Music, Duffel, Belgium'),(17,'Ber','Bernel Music, Cullowhee, USA'),(18,'Bes','Besson, London'),(19,'BH','Boosey & Hawkes, London'),(20,'Bil','Billaudot, Paris'),(21,'Bio','Biollay Robert, Lausanne'),(22,'Bir','Birch Island Music Press, Oskaloosa'),(23,'BM','Bronsheim Muziek, Brunssum'),(24,'BMC','Band Music Centre, Enschede NL'),(25,'BMP','Brazilian Music Publications, USA'),(26,'BoB','Bote & Bock, Berlin'),(27,'Bog','Boggio Remo (OBRASSO, Wiedlisbach)'),(28,'Bos','Bosse Edition, Regensburg'),(29,'Bou','Bourne Co., New York, NY'),(30,'BP','Band Press VOF, Belgium'),(31,'Büt','Bütler, Inh. A. Joller, Balsthal'),(32,'Buy','Buyst, Brüssel'),(33,'CA','C. Alan Publications, Greensboro NC'),(34,'cad','carpe diem, Tauberbischofsheim'),(35,'Cha','Chandons Music, Cleveland'),(36,'Che','Chersford Music Publ., Oskaloosa'),(37,'CHM','CH-Musica, 4147 Aesch'),(38,'Chp','Chappell, Paris'),(39,'CLM','Columbia Lady Music'),(40,'Col','Colombo Franco, Chicago'),(41,'Com','Comes, Bad Reichenhall'),(42,'Cra','Cranz August, Brüssel'),(43,'Cur','Curnow Music, Wilmore, USA'),(44,'Dae','Daehn, New Glarus, Wisconsin'),(45,'Dan','Danzeisen Peter, Lenzburg'),(46,'DC','da capo music, oberarth'),(47,'DeH','De Haske, Hagendorn'),(48,'DeL','De Leymbergh'),(49,'DeW','Delaw Water, Gap, PA'),(50,'dif','difem, Neuchâtel'),(51,'Dit','Ditson Oliver Company, USA'),(52,'Dor','Dorabet Music Company, USA'),(53,'E4Y','Edition4You S.à.r.l., Siviriez'),(54,'EGO','Egon Publ., England'),(55,'ENP','Eight Note Publications'),(56,'Elk','Elkan-Vogel, USA'),(57,'Elw','Elwe, Rudolfstetten'),(58,'EMR','Editions Marc Reift, Crans-Montana'),(59,'Fa','Faber Music'),(60,'Fel','Feldmann & Co., London'),(61,'FFN','Fortissimo Forlag, Norway'),(62,'Fis','Fisher Carl, New York, NY'),(63,'Flo','edition flor, Erlensee/Germany'),(64,'For','Fortuna Music Publ., Nottingham'),(65,'Fox','Sam Fox Publ., New York, NY'),(66,'Fra','Frank Boston, MA'),(67,'Gai','Gaia Massimo, Giubiasco'),(68,'Gal','Galaxy Music Corp., New York, NY'),(69,'GBM','Green Bay Publishing, Auckland'),(70,'GMB','G. & M. Brand, England'),(71,'Gen','General Words and Musica, USA'),(72,'Gob','Gobelin, Drachten, Holland'),(73,'Gra','Gramercy Music, Chesire'),(74,'Gre','Greber Music'),(75,'Gro','Grosch Philipp, München'),(76,'Haf','Hafabra Music, B'),(77,'Hal','Halter Wilhelm, Karlsruhe'),(78,'Han','Wilh. Han sen. London'),(79,'Has','Hallamshire Music'),(80,'Hay','Hayoz Benedikt'),(81,'HE','Highland, Etling'),(82,'Hel','Helbling & Co., Volketswil'),(83,'Hen','Henrees Music, London'),(84,'Hin','Hinrichsen, London'),(85,'HLP','Hal Leonard Publ.'),(86,'HM','Heri Musikverlag, Deitingen'),(87,'Hug','Hug & Co., Zürich'),(88,'IM','IBERMUSICA'),(89,'Int','INTER-Music, Monthey'),(90,'Jen','Jenson Publ. INC, New Berlin, USA'),(91,'JIV','JIVE Music Service BV, Sittard, NL'),(92,'JM','Just Music'),(93,'JOS','JOSEPH Musikverlag GmbH, Buckten'),(94,'Joy','Joy Paul, Lausanne'),(95,'Ki','Kirklees Music, West Yorkshire'),(96,'Kjo','Kjos Neil, San Diego'),(97,'Kun','Kunitachi Gaki, Japan'),(98,'LC','Les Comballes'),(99,'LCM','Le Chant du Monde'),(100,'Led','Leduc Alphonse, Paris'),(101,'Lee','Leeds, New York, NY'),(102,'Lim','Limmus Verlag, Dietikon'),(103,'LM','Louis Martinus; Fouron/Voeren, Belgium'),(104,'LME','Lucerne Music Edition, Luzern'),(105,'Lo','Lomond Music, Kingskettle, Schottland'),(106,'Lud','Ludwig Music, Cleveland'),(107,'M','Neuer Münchner Verlag'),(108,'Mae','Maecenas Music, Kenley, Surrey CR2'),(109,'Man','Manhattan Beach Music'),(110,'MAp','Musica Appassionata, Aarschot'),(111,'Mar','Marks, New York, NY'),(112,'Mat','Martin R., Macon'),(113,'MCA','MCA Music, New York, NY'),(114,'MCM','Miracle Creek Music'),(115,'MCS','MCS-edition, Vöcklabruck, A'),(116,'Mer','Merion Music'),(117,'mf','Musikverlag Frank, Zuchwil'),(118,'MH','Mythen Hollanda'),(119,'Mig','Milgra, Wädenswil'),(120,'Mil','Mills, New York, NY'),(121,'Mol','Molenaar, Wormerveer'),(122,'MoM','Molto Music Flaktveit, Norwegen'),(123,'Mpa','Mitropa, Hagendorn'),(124,'MPG','Musikpreis Grenchen'),(125,'MuCS','Music-Centre Sion'),(126,'MT','Music-Trans, Küsnacht ZH'),(127,'Mus','Edition Musica, Budapest'),(128,'Myt','Mythen-Verlag, Schwyz'),(129,'Nov','Novello Bram Gray, Sevenoaks, GB'),(130,'NS','Nordic Sounds Ltd., Stavanger, Norway'),(131,'NWM','New World Music'),(132,'Obr','OBRASSO, Wiedlisbach'),(133,'Oer','Oertel Louis, Hannover'),(134,'Ong','Ongaku No Tomo Sha, Tokyo'),(135,'Or','Orchestrola'),(136,'Ox','Oxford University Press'),(137,'Pat','Patterson, London'),(138,'Pax','Paxton, Sevenoaks, GB'),(139,'Pie','Pedmont Music Company'),(140,'PiM','Piles Musica'),(141,'PLC','PLC Music'),(142,'PM','Power Music, Wengi b. Büren'),(143,'Pol','Polyphonic, London'),(144,'PrM','Pro Music, Villeneuve'),(145,'Prs','Presser, Bryn Mawr, PA'),(146,'PVM','Prima Vista Musik'),(147,'Rei','Editions Marc Reift, Crans-Montana'),(148,'Rhy','Rhythmus Verlag, c/o Misura Verlag, Luzern'),(149,'Ric','Richardson, Gloucester'),(150,'Ros','Rosehill Music Publ., London'),(151,'Rub','Rubank, Miami, FL'),(152,'Rud','Rudo-Musikverlag, Günsberg'),(153,'Ruh','Ruh Emil, Adliswil'),(154,'Sa','Salvationist P & S'),(155,'SaUs','Salvation Army USA'),(156,'Sal','Salabert'),(157,'Sch','Scherzando, Brüssel'),(158,'Sco','Scomegna, La Loggia, Italia'),(159,'Ser','G. Schirmer, New York, NY'),(160,'SHe','Musikverlag Scherbacher, Hechingen DL'),(161,'Shw','Shawnee Press, Water Cap, DE'),(162,'Si','Sialm, Therwil'),(163,'Sik','Sikorski, Hamburg'),(164,'Smi','Smith Robert, Watford, GB'),(165,'Sor','Schorer Andreas, Emstal, D'),(166,'Sou','Southern Music Comp., San Antonio'),(167,'SStt','Schott, Mainz'),(168,'Str','Stril Music, NO'),(169,'Stu','Studio Music, London'),(170,'Sum','Summy-Birchard, Evanston, Illinois'),(171,'SV','Selbstverlag des Komponisten'),(172,'Sz','Schulz Fritz, Freiburg i.Br.'),(173,'TB','E. Thomi-Berg, Gräfelfingen'),(174,'Tem','Templeton Publishing Co.'),(175,'Tes','Tessiner Verlag, Zürich'),(176,'Thö','Thöni, Erlenbach i.S.'),(177,'THT','The Hindsley Transcriptions, Homewood'),(178,'Tie','Tierolff, Rosendahl'),(179,'ToB','TOPP BRASS, Aarau'),(180,'Toi','Tonika as, Musikforlag, Oslo'),(181,'Ton','Tondo, Balsthal'),(182,'Top','Topo, Zürich'),(183,'Tra','Ed. musicales transatlantiques, Paris'),(184,'Vid','Vidale, Milano'),(185,'Vla','Vlaamse Brassband, Linkebeek'),(186,'VT','Vanderbeek & Timrie'),(187,'Vw','Volkwein, Pittsburgh, PA'),(188,'WaB','Warner Bros.'),(189,'Wae','Waespi Oliver'),(190,'WAM','William Allen Music'),(191,'wb','Woodbrass Music SA, Le Mouret'),(192,'Wei','Weinberger Josef, London'),(193,'wic','Wicky, Milano'),(194,'Win','Wingert-Jones Music Inc., Kansas City'),(195,'WME','Wind Music Edition, Bern'),(196,'WN','Warner / Chappell, Norway'),(197,'WR','Wright & Round, Gloucester');
/*!40000 ALTER TABLE `t_edition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_formation`
--

DROP TABLE IF EXISTS `t_formation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_formation` (
  `PK_Formation` int(11) NOT NULL,
  `Formation` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`PK_Formation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_formation`
--

LOCK TABLES `t_formation` WRITE;
/*!40000 ALTER TABLE `t_formation` DISABLE KEYS */;
INSERT INTO `t_formation` VALUES (1,'Brass Band'),(2,'Harmonie'),(3,'Fanfare Mixte');
/*!40000 ALTER TABLE `t_formation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_piece`
--

DROP TABLE IF EXISTS `t_piece`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_piece` (
  `PK_Piece` int(11) NOT NULL,
  `Duree` time DEFAULT NULL,
  `AnneeClassement` int(11) DEFAULT NULL,
  `Titre` varchar(255) NOT NULL,
  `FK_Compositeur` int(11) NOT NULL,
  `FK_Arrangeur` int(11) DEFAULT NULL,
  `FK_Categorie` int(11) NOT NULL,
  `FK_Edition` int(11) DEFAULT NULL,
  `Prix` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`PK_Piece`),
  KEY `fk_T_Piece_T_Compositeur_idx` (`FK_Compositeur`),
  KEY `fk_T_Piece_T_Compositeur1_idx` (`FK_Arrangeur`),
  KEY `fk_T_Piece_T_Categorie1_idx` (`FK_Categorie`),
  KEY `fk_T_Piece_T_Edition1_idx` (`FK_Edition`),
  CONSTRAINT `fk_T_Piece_T_Categorie1` FOREIGN KEY (`FK_Categorie`) REFERENCES `t_categorie` (`PK_Categorie`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_T_Piece_T_Compositeur` FOREIGN KEY (`FK_Compositeur`) REFERENCES `t_compositeur` (`PK_Compositeur`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_T_Piece_T_Compositeur1` FOREIGN KEY (`FK_Arrangeur`) REFERENCES `t_compositeur` (`PK_Compositeur`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_T_Piece_T_Edition1` FOREIGN KEY (`FK_Edition`) REFERENCES `t_edition` (`PK_Edition`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_piece`
--

LOCK TABLES `t_piece` WRITE;
/*!40000 ALTER TABLE `t_piece` DISABLE KEYS */;
INSERT INTO `t_piece` VALUES (1,NULL,NULL,'Preludio Alfetto',21,NULL,4,94,111.90),(2,'00:12:15',NULL,'Songes d\'Automne',21,NULL,2,50,94.00),(3,'00:05:30',2013,'Petite ouverture romantique',21,NULL,5,148,76.50),(4,'00:08:00',NULL,'Bergfahrt',33,NULL,5,148,114.50),(5,'00:07:15',NULL,'Burleske',33,NULL,3,148,126.10),(6,'00:12:15',NULL,'Die schwarze Spinne',33,NULL,2,148,77.40),(7,'00:08:00',NULL,'Fantasia ticinese',33,NULL,3,148,60.10),(8,'00:07:00',NULL,'Heimkehr',33,NULL,4,148,105.50),(9,'00:10:00',NULL,'Herbstimpressionen',33,NULL,2,148,126.50),(10,'00:07:00',NULL,'Marionettenspiel',33,NULL,4,148,133.20),(11,NULL,NULL,'Masques - Masken',33,NULL,4,94,146.10),(12,'00:08:30',NULL,'Nidwalden 1798',33,NULL,4,148,109.90),(13,'00:08:00',NULL,'Romooser Sonntag, Suite',33,NULL,4,148,69.40),(14,NULL,NULL,'Suite Vaudoise',33,NULL,5,94,76.70),(15,'00:08:00',NULL,'Toccata',33,NULL,2,148,140.10),(16,'00:09:30',NULL,'Suite Ancienne (1)',69,NULL,4,50,69.50),(17,'00:07:15',NULL,'Hanseatic Suite',91,NULL,5,47,136.50),(18,NULL,NULL,'Rhapsodie',130,504,5,54,139.90),(19,'00:06:15',NULL,'Capriccio',131,NULL,5,153,110.40),(20,'00:06:30',NULL,'Deux portraits',131,NULL,4,50,57.70),(21,'00:09:00',NULL,'Dies aeterna',131,NULL,3,153,79.10),(22,'00:07:00',NULL,'Dipthema',131,NULL,3,94,101.80),(23,'00:09:00',NULL,'Jambo',131,NULL,2,50,134.30),(24,NULL,NULL,'Jeux de Quartes',131,NULL,3,94,133.00),(25,'00:09:00',NULL,'Petite Suite Française',165,NULL,4,47,145.40),(26,'00:06:00',NULL,'Emmentaler Morgen',179,NULL,5,148,106.20),(27,'00:09:00',NULL,'Feiertag, Suite',179,NULL,4,148,125.40),(28,'00:06:00',NULL,'Festliche Miniaturen',179,NULL,5,148,128.70),(29,'00:06:00',NULL,'Momenti ticinesi',179,NULL,5,148,103.10),(30,'00:08:40',1997,'Erasmus Tales',181,NULL,5,47,57.00),(31,'00:06:30',1996,'Fun for Young People',188,NULL,5,50,111.40),(32,NULL,NULL,'Overture on an Early Swiss Folk Song',199,NULL,4,132,132.50),(33,NULL,1996,'Schweizer Lieder',199,NULL,5,54,127.60),(34,'00:05:00',NULL,'Istorgias da buna notg',211,NULL,5,171,68.30),(35,NULL,NULL,'Interludium',216,NULL,3,54,142.80),(36,'00:06:00',NULL,'Suite variable',224,NULL,5,47,108.80),(37,'00:06:30',NULL,'Capriccio für Blasmusik',240,NULL,5,93,53.60),(38,'00:07:30',NULL,'Un soupçon de Paganini',252,NULL,3,50,81.70),(39,'00:08:30',NULL,'Festliche Musik für Bläser',263,NULL,3,148,118.20),(40,NULL,NULL,'London Scherzo',268,NULL,3,128,100.90),(41,NULL,NULL,'Little Episode for Winds',282,NULL,5,46,126.00),(42,'00:06:30',NULL,'Trois moments gruériens, Suite',311,NULL,4,54,142.10),(43,'00:07:30',NULL,'Fantasie für Blasorchester',355,NULL,3,119,90.00),(44,'00:10:00',NULL,'King Arthur, Suite',381,NULL,5,47,74.50),(45,NULL,NULL,'Sonatina',381,NULL,5,47,75.70),(46,NULL,NULL,'Pictura, Ouverture',391,NULL,3,128,135.60),(47,'00:05:30',NULL,'Four Old Dances',425,NULL,5,47,101.80),(48,'00:08:00',NULL,'Triptych',442,NULL,5,121,106.10),(49,NULL,NULL,'Bündner Suite',451,NULL,4,9,125.20),(50,NULL,NULL,'Notturno romantico',451,NULL,5,9,69.70),(51,'00:10:45',NULL,'Meggen (1)',33,475,3,148,118.20),(52,'00:09:00',NULL,'Der Dämon',216,NULL,2,153,84.30),(53,'00:09:30',NULL,'Les Gursks',21,NULL,2,54,110.90),(54,NULL,NULL,'Devon Fantasy (1)',22,NULL,4,121,109.40),(55,'00:09:32',NULL,'Indian Summer (1)',22,NULL,5,121,111.70),(56,'00:08:03',NULL,'The Young in Heart, Suite (1)',22,NULL,4,121,128.70),(57,NULL,NULL,'Krontjong, Rhapsodie for Band',29,NULL,5,121,82.60),(58,'00:11:00',2006,'Berner Rhapsodie',33,NULL,2,148,123.30),(59,'00:09:00',NULL,'Sinfonische Evolutionen',39,NULL,2,153,64.20),(60,NULL,NULL,'Ciaccona antiqua',40,NULL,5,121,144.10),(61,NULL,NULL,'Fantasie pastorale',40,NULL,5,121,64.10),(62,'00:05:15',NULL,'Michiel Adriaenszoon, Overture',40,NULL,5,121,87.40),(63,NULL,NULL,'Partita piccola',40,NULL,5,121,142.30),(64,NULL,NULL,'Petite Sérénade facile',40,NULL,5,121,87.30),(65,NULL,NULL,'Promenades, Suite',40,NULL,5,121,141.50),(66,NULL,NULL,'Week-End, Overture',40,NULL,5,121,52.50),(67,'00:08:00',NULL,'Major Davel',85,NULL,2,120,144.50),(68,NULL,NULL,'Suite symetrique',91,NULL,4,47,110.10),(69,'00:07:00',NULL,'Miniatures for Band',97,NULL,4,7,64.80),(70,NULL,NULL,'Suite antiqua',109,NULL,5,121,105.20),(71,NULL,NULL,'Im Sommerset, Suite',189,NULL,5,121,132.50),(72,NULL,NULL,'Scenes from the Countryside',189,NULL,5,121,132.60),(73,NULL,NULL,'Short Pieces',189,NULL,5,121,110.50),(74,NULL,NULL,'Three little Pictures',189,NULL,5,121,60.40),(75,NULL,NULL,'Evolution, Overture',191,NULL,4,121,50.10),(76,'00:05:22',NULL,'Sinfonia italiana',191,NULL,5,121,72.60),(77,NULL,NULL,'Kleine Festmusik',216,NULL,4,120,148.00),(78,NULL,NULL,'Johann Krieger Suite',261,12,5,121,66.40),(79,NULL,NULL,'Capricieux, launische Skizze',282,NULL,5,46,140.50),(80,NULL,NULL,'Feierliches Bläserstück',282,NULL,5,46,68.40),(81,NULL,NULL,'Danza Paesana (Ländlicher Tanz)',307,NULL,4,120,116.90),(82,NULL,NULL,'Fanfaren-Intrade',307,NULL,5,153,110.90),(83,NULL,NULL,'Herbstruf',307,NULL,4,120,120.60),(84,NULL,NULL,'Canzone',323,479,5,153,119.30),(85,NULL,NULL,'Koninklijke Muziek 1612, Suite',342,526,5,121,141.00),(86,NULL,NULL,'Ouverture zu einem Festspiel',352,NULL,5,54,64.10),(87,'00:07:00',NULL,'Retsina 2000',391,NULL,3,162,143.50),(88,NULL,NULL,'Renaissance Suite',407,494,5,153,67.40),(89,NULL,NULL,'Kleine Suite over Volksliederen',427,NULL,5,121,99.40),(90,NULL,NULL,'Le premier jeu',427,NULL,5,121,69.90),(91,'00:06:30',NULL,'Little Studies on a Folk Song from the Hague',427,NULL,4,121,106.70),(92,'00:06:30',NULL,'Three Folk Sketches, Suite',427,NULL,5,121,102.30),(93,NULL,NULL,'Festouverture for Band',440,NULL,4,121,100.90),(94,'00:08:45',NULL,'Berner Suite',451,NULL,5,153,73.60),(95,'00:07:00',NULL,'Heitere Ouverture',33,NULL,4,148,60.90),(96,NULL,NULL,'Klingende Fahrt, Ouverture',33,NULL,4,153,63.70),(97,'00:07:00',NULL,'Parsenn, Ouverture',33,NULL,4,148,113.60),(98,'00:06:30',NULL,'Preludio alla Scherzo',33,NULL,4,153,128.80),(99,'00:11:00',NULL,'Schweizerlieder-Fantasie',33,NULL,3,148,55.20),(100,'00:13:00',NULL,'Sinfonischer Satz',33,NULL,2,148,81.20),(101,NULL,NULL,'Zitadelle, Ouverture',33,NULL,4,153,147.40),(102,'00:06:20',NULL,'Karl der Kühne',85,NULL,3,119,130.90),(103,NULL,NULL,'Imbriacus-Suite',127,NULL,3,54,67.90),(104,NULL,NULL,'Toccata (1)',127,NULL,5,54,75.10),(105,NULL,NULL,'Evolution',180,NULL,4,54,68.00),(106,NULL,NULL,'Preludio in B',180,NULL,5,75,64.90),(107,'00:06:00',NULL,'Vorspiel für einen vaterländischen Feiertag',205,533,5,153,99.40),(108,NULL,NULL,'Ballade für Blasorchester',216,NULL,4,119,149.30),(109,NULL,NULL,'Capriccio (1)',216,NULL,4,119,108.00),(110,'00:07:15',NULL,'Choral, Variationen und Fuge (1)',216,NULL,5,153,111.10),(111,'00:06:45',NULL,'Der fröhliche Musikant',216,NULL,4,148,63.40),(112,NULL,NULL,'Fantasia eroica',216,NULL,4,153,139.70),(113,'00:05:32',NULL,'Festlicher Bläserchor',216,NULL,5,153,98.60),(114,NULL,NULL,'Impromptu (2)',216,NULL,4,54,145.30),(115,NULL,NULL,'Intrada und Fuge',216,NULL,4,153,82.50),(116,NULL,NULL,'Jubelhymnus',216,NULL,3,153,69.80),(117,'00:06:45',NULL,'Kirmes',216,NULL,4,148,59.70),(118,NULL,NULL,'Meditation',216,NULL,3,153,68.10),(119,NULL,NULL,'Notturno',216,NULL,4,119,118.80),(120,NULL,NULL,'Ouverture pastorale',216,NULL,4,119,93.90),(121,'00:07:00',NULL,'Postludium',216,NULL,3,153,133.30),(122,NULL,NULL,'Praeludium in modo classico',216,NULL,4,119,108.50),(123,NULL,NULL,'Prolog',216,NULL,3,75,79.00),(124,NULL,NULL,'Romantische Konzertouverture',216,NULL,2,119,88.10),(125,NULL,NULL,'Rondo',216,NULL,3,119,62.70),(126,NULL,NULL,'Sarabande',216,NULL,5,119,73.00),(127,NULL,NULL,'Scherzo capriccioso',216,NULL,3,153,51.60),(128,NULL,NULL,'Serenade in vier Sätzen',216,NULL,4,119,104.70),(129,NULL,NULL,'Sinfonisches Adagio',216,NULL,2,119,131.00),(130,NULL,NULL,'Suite in Es',216,NULL,3,119,56.70),(131,'00:05:30',2013,'Arlecchino, Capriccio',216,NULL,5,119,105.10),(132,NULL,NULL,'Bergruf, Vorspiel',228,NULL,4,47,70.20),(133,NULL,NULL,'Canzonetta',228,NULL,5,47,76.20),(134,NULL,NULL,'Die Fahnenburg, Präludium',228,NULL,4,119,149.80),(135,'00:13:30',NULL,'Engiadina, Tondichtung',228,NULL,2,47,141.50),(136,'00:09:45',NULL,'Festliche Ouverture',228,NULL,2,47,86.40),(137,NULL,NULL,'Im Frühjahr, sinfonische Skizze',228,NULL,3,47,116.20),(138,NULL,NULL,'Jubel-Ouverture',228,NULL,3,153,61.80),(139,NULL,NULL,'Kleine Ouverture im klassischen Stil',228,NULL,4,47,133.30),(140,NULL,NULL,'Ode an die Musik',228,NULL,5,47,54.90),(141,'00:10:15',NULL,'Ouverture in Es-Dur',228,NULL,2,47,106.40),(142,'00:10:15',NULL,'Romantische Ouverture in B-Dur',228,NULL,2,132,54.70),(143,NULL,NULL,'Serenade in As-Dur',228,NULL,5,27,109.10),(144,NULL,NULL,'Söldnertanz',228,NULL,4,47,143.20),(145,'00:10:40',NULL,'Suite für Blasmusik',234,33,3,148,131.00),(146,NULL,NULL,'Rotary Convention, Suite',234,533,3,153,82.20),(147,NULL,NULL,'Suite in 3 Sätzen für Blasorchester',254,NULL,5,82,59.40),(148,NULL,NULL,'Arethusa',255,NULL,2,153,146.10),(149,NULL,NULL,'Canzone Jubilate',255,NULL,4,82,137.70),(150,NULL,NULL,'Der Tyrann von Syrakus, Ouverture',255,NULL,3,153,77.80),(151,NULL,NULL,'Die Heimatlosen, Ouverture',255,NULL,3,54,93.10),(152,NULL,NULL,'Die versunkene Stadt, sinfonische Musik',255,NULL,2,119,66.30),(153,NULL,NULL,'Lorenzo de Medici, sinfonisches Gemälde',255,NULL,3,54,89.90),(154,NULL,NULL,'Marco Polo, Ouverture',255,NULL,4,153,97.10),(155,NULL,NULL,'Musica Helvetica',255,NULL,5,153,77.20),(156,NULL,NULL,'Perikles, Ouverture',255,NULL,2,47,116.10),(157,NULL,NULL,'Relief',255,NULL,3,54,144.20),(158,NULL,NULL,'Rondo amoroso',255,NULL,3,82,87.70),(159,NULL,2011,'Sinfonia für Blasmusik',255,NULL,3,153,118.40),(160,NULL,2011,'Sinfonia, der Schmied der Götter',255,NULL,3,153,123.10),(161,NULL,NULL,'Intrade',259,NULL,5,82,67.50),(162,NULL,NULL,'Cape Kennedy',267,NULL,2,38,129.90),(163,NULL,NULL,'Die Reiter von Saignelégier, Ouverture',307,NULL,4,153,141.80),(164,NULL,NULL,'Jurahöhen',307,NULL,4,153,74.40),(165,NULL,NULL,'Landschaften-Suite',307,NULL,4,153,132.00),(166,NULL,NULL,'Zingaresca, Rhapsodie',403,NULL,3,77,111.70),(167,NULL,NULL,'Canyon Passage, Overture (1)',414,533,5,153,76.70),(168,NULL,NULL,'Euphonia',429,NULL,5,82,128.20),(169,NULL,NULL,'Alpenhymne',451,NULL,5,27,102.10),(170,NULL,NULL,'Atlantis, Ouverture',451,NULL,2,58,148.10),(171,NULL,NULL,'Canzone mattutina',451,NULL,5,47,90.30),(172,'00:05:30',NULL,'Hymnische Bläsermusik',451,NULL,5,153,104.90),(173,NULL,NULL,'Konzert-Suite',451,NULL,4,9,130.10),(174,NULL,NULL,'Legende',451,NULL,5,54,105.20),(175,NULL,NULL,'Majestät der Berge, Ouverture',471,533,4,153,94.20),(176,NULL,NULL,'Im Aargau sind zwei Liebi, Suite (1)',474,NULL,2,47,118.80),(177,'00:08:50',1997,'Circius',1,NULL,2,168,92.50),(178,'00:11:30',2005,'The Lonesome Knight',10,NULL,4,72,132.00),(179,'00:10:33',NULL,'Fantasy for Brass Band op. 114',13,NULL,2,83,64.00),(180,'00:08:30',NULL,'Little Suite No. 2',13,NULL,3,83,62.80),(181,'00:06:54',1998,'Little Suite op. 80',13,NULL,3,137,142.40),(182,'00:10:00',1996,'Four Cornish Dances, Op. 91',13,495,2,19,60.70),(183,NULL,NULL,'Suite ancienne',17,NULL,5,164,148.00),(184,'00:11:00',2007,'Roman Triptych',19,NULL,3,95,147.60),(185,'00:13:27',NULL,'2nd Sinfonietta for Band',21,NULL,2,89,107.70),(186,'00:12:12',NULL,'Le chant de l\'alpe',21,NULL,1,169,131.10),(187,'00:12:15',2001,'Saisons',21,NULL,2,54,52.50),(188,NULL,NULL,'1st Rhapsody on Negro Spirituals',22,NULL,3,19,97.10),(189,'00:08:45',NULL,'2nd Rhapsody on Negro Spirituals',22,NULL,3,18,96.40),(190,NULL,NULL,'A Holiday Suite',22,NULL,4,18,77.00),(191,'00:10:12',NULL,'A Kensington Concerto',22,NULL,1,19,105.60),(192,NULL,NULL,'Akhnaton, Légende',22,NULL,2,164,93.70),(193,NULL,NULL,'American Sketches',22,NULL,4,19,61.90),(194,'00:08:47',NULL,'Call of the Sea',22,NULL,2,18,137.20),(195,NULL,NULL,'Contest Day',22,NULL,4,164,124.30),(196,NULL,NULL,'Cornish-Festival-Overture',22,NULL,2,197,149.10),(197,NULL,NULL,'Devon Fantasy',22,NULL,4,164,85.60),(198,NULL,NULL,'Divertimento',22,NULL,5,164,147.10),(199,NULL,NULL,'Everybody\'s Child, Divertissement',22,NULL,4,138,53.50),(200,'00:14:45',NULL,'Festival Music, Symphonic Suite',22,NULL,1,164,133.20),(201,NULL,NULL,'Fowey River Suite',22,NULL,4,138,106.20),(202,'00:11:15',NULL,'High Peak, Rhapsody for Brass Band',22,NULL,2,19,131.80),(203,NULL,NULL,'Homeward, Overture',22,NULL,4,19,115.60),(204,NULL,NULL,'Impromptu',22,NULL,4,19,88.60),(205,'00:09:32',NULL,'Indian Summer',22,NULL,5,164,132.30),(206,'00:11:15',NULL,'Journey into Freedom, Rhapsody',22,NULL,2,19,133.00),(207,'00:11:00',NULL,'Main Street',22,NULL,3,164,123.70),(208,'00:08:46',NULL,'Morning Rhapsody',22,NULL,2,164,111.30),(209,NULL,NULL,'Oasis, Suite',22,NULL,4,138,73.00),(210,'00:07:40',NULL,'Petite Suite de Ballet',22,NULL,4,164,57.70),(211,'00:12:45',NULL,'Resurgam, Tone Poem',22,NULL,2,164,110.10),(212,NULL,NULL,'Rhapsody on American Gospel Songs',22,NULL,2,64,76.30),(213,NULL,NULL,'Scottish Festival Overture',22,NULL,3,19,66.70),(214,'00:11:58',NULL,'Sinfonietta «The Wayfarer»',22,NULL,1,19,80.70),(215,'00:11:00',2000,'Song of Courage',22,NULL,2,154,125.40),(216,'00:12:00',NULL,'Songs of the Morning, Suite',22,NULL,2,154,131.00),(217,NULL,NULL,'Sunset Rhapsody',22,NULL,4,164,132.50),(218,NULL,NULL,'Swiss Festival Overture',22,NULL,4,197,129.30),(219,NULL,NULL,'Thanksgiving, Tone Poem',22,NULL,4,164,103.50),(220,NULL,NULL,'The Ancient Temple, Fantasia',22,NULL,4,197,120.40),(221,'00:08:15',1996,'The Kingdom Triumphant',22,NULL,4,154,66.40),(222,NULL,NULL,'The Princess and the Poet',22,NULL,4,164,61.30),(223,'00:08:03',NULL,'The Young in Heart, Suite',22,NULL,4,19,98.60),(224,NULL,NULL,'Tournament for Brass',22,NULL,2,164,54.50),(225,'00:10:42',NULL,'Undaunted, Concert Overture',22,NULL,2,164,126.80),(226,NULL,NULL,'Youth Salutes a Master',22,NULL,4,164,135.60),(227,'00:10:00',2001,'An English Suite',23,NULL,4,169,51.50),(228,'00:08:31',2007,'A Cambrian Suite',23,NULL,3,129,133.90),(229,'00:15:00',2011,'Whitsun Wakes',23,NULL,1,129,144.30),(230,'00:10:00',1995,'A Salford Sinfonietta',27,NULL,2,95,80.10),(231,'00:12:17',NULL,'A Swiss Excursion',27,NULL,2,95,84.80),(232,'00:10:37',NULL,'Cassation',27,NULL,3,169,88.20),(233,'00:10:15',1997,'Divertimento for Brass',27,NULL,3,169,130.40),(234,NULL,2005,'Pro Tempore',27,NULL,4,146,145.30),(235,'00:09:30',2000,'Schattdorf Impressions',27,NULL,3,117,108.30),(236,'00:11:11',2006,'A Nordic Trilogy',27,NULL,3,132,63.10),(237,NULL,2007,'Toccata, Elegy & Scherzo for Brass Band',27,NULL,2,132,83.80),(238,NULL,2007,'Squares',27,NULL,4,132,119.60),(239,'00:11:00',2008,'Dracula',27,NULL,3,132,112.00),(240,NULL,2009,'The Mysterious Bridge',27,NULL,4,132,135.00),(241,NULL,2010,'Rise of the Phoenix',27,NULL,3,95,69.20),(242,'00:11:00',2010,'Ghosts, Goblins, Witches & Wizards',27,NULL,3,132,113.00),(243,'00:09:00',NULL,'Rondo für Brass Band',33,NULL,2,21,148.30),(244,'00:09:15',NULL,'Variationen über ein altes Schweizerlied',33,NULL,3,128,82.90),(245,'00:11:00',NULL,'Toccata, Air and Dance (1)',37,531,2,148,82.90),(246,'00:09:08',NULL,'Kenilworth, Suite',38,NULL,2,164,67.00),(247,NULL,NULL,'Scherzo capricioso',41,NULL,3,121,125.80),(248,NULL,NULL,'Suite Gothique',42,22,2,138,103.60),(249,'00:12:00',2005,'Delta Energy',48,NULL,3,72,131.60),(250,'00:11:07',NULL,'A Barchester Suite',49,NULL,3,164,113.30),(251,'00:11:00',2000,'Blitz',49,NULL,1,164,75.80),(252,'00:20:00',2005,'Concerto Grosso',49,NULL,1,164,125.40),(253,'00:12:15',NULL,'Diversions for Brass Band',49,NULL,1,164,106.10),(254,'00:13:22',NULL,'The Forest of Dean',49,NULL,1,164,76.80),(255,'00:13:00',2011,'Lac Léman',49,NULL,1,76,101.10),(256,'00:10:30',2005,'Nordic Moods',54,NULL,4,72,84.80),(257,'00:12:05',NULL,'California Legend',57,NULL,2,150,145.40),(258,'00:09:00',NULL,'Chorale and Toccata',58,NULL,3,47,116.80),(259,'00:12:00',NULL,'Cityscapes',58,NULL,3,150,88.40),(260,'00:09:44',2003,'Images for Brass',58,NULL,3,43,115.30),(261,'00:05:45',NULL,'Suite for Brass',58,NULL,3,47,129.90),(262,NULL,2008,'Flight (1)',59,NULL,4,117,132.20),(263,NULL,2009,'Fight of Liberty',59,NULL,2,117,68.50),(264,'00:18:00',2009,'Hannibal',59,NULL,1,117,59.90),(265,NULL,2009,'Napoléon',59,NULL,3,117,69.90),(266,NULL,2009,'The Cliffs of Moher (1)',59,NULL,3,117,66.90),(267,'00:09:27',2010,'Pompeji (1)',59,NULL,4,117,67.70),(268,NULL,2010,'Cap Hoorn',59,NULL,2,117,108.50),(269,'00:06:00',2012,'Swiss Mountain Village (Urchigs Terbil) (1)',59,NULL,5,117,138.00),(270,'00:08:15',2013,'Jambo Africa (1)',59,NULL,4,117,135.90),(271,'00:09:00',2013,'Terra Pacem (1)',59,NULL,3,117,72.30),(272,'00:11:30',2013,'Der Magnetberg (1)',59,NULL,3,117,69.60),(273,'00:09:30',2015,'La legénde de Sainte Odile',59,NULL,3,117,121.80),(274,'00:08:45',2015,'The States of Water',59,NULL,4,117,129.20),(275,'00:08:15',2015,'Heaven\'s Glory',59,NULL,3,117,128.10),(276,'00:10:30',2015,'Flow!',59,NULL,4,117,83.00),(277,NULL,NULL,'Caliban, Scherzo Malèvolo',61,NULL,2,164,57.20),(278,'00:11:50',2003,'Passacaglia for Brass',61,NULL,2,41,61.50),(279,'00:10:35',NULL,'Introduction, Elegy and Caprice',62,NULL,3,164,135.20),(280,NULL,NULL,'Four Little Maids, Suite',64,NULL,4,164,106.80),(281,'00:10:30',2015,'Antruras',66,NULL,4,104,85.70),(282,'00:08:45',NULL,'Brass Dynamics',69,NULL,2,123,52.50),(283,'00:18:00',2011,'Bulgarian Dances (Part II)',69,NULL,1,NULL,141.90),(284,'00:16:15',2015,'Earthrise',74,NULL,1,169,127.30),(285,NULL,2007,'Song of the Eternal',77,NULL,3,154,54.40),(286,'00:07:50',2010,'The Call of the Righteous (1)',77,NULL,4,154,144.50),(287,'00:11:00',2001,'Color\'s Impressions',79,NULL,2,191,64.80),(288,'00:10:30',2005,'Islands',79,NULL,2,191,89.20),(289,'00:08:40',2010,'Sinfonietta No. 1 for Brass Band',79,NULL,2,191,59.20),(290,'00:11:00',2013,'Deliverance (1)',79,NULL,3,16,126.10),(291,'00:08:00',2015,'Escapades',79,NULL,5,117,145.50),(292,'00:12:00',NULL,'Blackfriars',81,NULL,2,19,89.20),(293,'00:05:50',NULL,'Appalachian Mountain Folk Song Suite',83,NULL,4,150,119.00),(294,'00:12:45',1996,'Brass Metamorphosis',83,NULL,1,47,130.10),(295,'00:06:39',NULL,'Brass Miniatures',83,NULL,3,47,146.30),(296,'00:12:27',NULL,'Legend in Brass',83,NULL,4,47,101.90),(297,'00:09:00',2000,'Masquerade for Brass',83,NULL,2,43,78.10),(298,NULL,NULL,'River City Suite',83,NULL,2,150,87.40),(299,'00:11:30',NULL,'Trittico',83,NULL,2,150,98.30),(300,'00:10:00',1999,'Music for a Brass Band',86,NULL,3,19,76.00),(301,NULL,2010,'Portrait: The Exe Estuary',88,NULL,3,117,62.40),(302,'00:11:00',2014,'Vivat!',89,NULL,2,169,100.90),(303,'00:08:00',2005,'The Saint and the City',91,NULL,4,47,79.30),(304,'00:08:15',2005,'Diogenes',91,NULL,3,47,114.50),(305,'00:08:00',2013,'The Heart of Lithuania (1)',91,NULL,4,47,59.40),(306,'00:12:00',2015,'Arkansas',91,NULL,4,47,133.20),(307,'00:11:45',NULL,'Variations on a Chord',92,NULL,3,47,106.80),(308,NULL,2010,'Cityscapes (1)',92,NULL,4,47,129.50),(309,'00:12:00',2011,'Prevision (1)',92,NULL,3,47,142.30),(310,'00:17:00',2013,'Earthquake',92,NULL,1,47,74.50),(311,'00:10:15',2013,'Musica Helvetica (1)',92,NULL,3,47,64.60),(312,'00:13:00',2013,'Hispaniola (1)',92,NULL,3,47,88.60),(313,'00:11:00',2013,'Flashback (1)',92,NULL,3,47,87.20),(314,'00:12:30',2013,'Alhambra',92,NULL,1,47,102.90),(315,'00:16:47',2006,'Extreme Make-over',93,NULL,1,6,56.50),(316,'00:16:20',2013,'Sinfonietta No. 1',93,NULL,2,6,101.00),(317,NULL,NULL,'Lindum Suite',103,NULL,4,129,70.00),(318,NULL,2007,'Milford Sound',105,NULL,4,30,131.60),(319,'00:12:30',2005,'Lydian Pictures',110,NULL,4,95,101.30),(320,'00:14:00',2013,'Lyonesse',110,NULL,2,59,105.30),(321,'00:10:40',2013,'Toccata e Fantasia',113,NULL,2,123,115.50),(322,'00:16:30',2013,'Spiriti',113,NULL,1,123,121.30),(323,'00:08:40',NULL,'Music from Kantara',114,NULL,4,54,131.80),(324,'00:12:09',2003,'St. Austell Suite',114,NULL,3,94,66.40),(325,'00:12:43',2006,'Music for the Common Man',114,NULL,2,54,70.10),(326,'00:13:30',2014,'Purcell Variations',114,NULL,3,54,120.40),(327,'00:12:51',2007,'A Hebridean Suite',117,NULL,2,88,71.60),(328,'00:19:10',NULL,'The Severn Suite op. 87',122,NULL,2,164,78.30),(329,'00:14:19',1995,'Vistas',124,NULL,2,89,111.60),(330,'00:13:53',2005,'Chivalry',124,NULL,1,169,146.10),(331,'00:15:33',2008,'Elgar Variations',124,NULL,1,169,148.80),(332,'00:16:07',2010,'Tristan Encounters',124,NULL,1,169,119.20),(333,'00:12:30',2013,'Natalis',124,NULL,2,108,107.20),(334,NULL,2010,'\'Prins\', Equus Laboris Brabanticus',128,NULL,4,30,121.00),(335,'00:09:29',2014,'Overture Halle 2000',128,NULL,4,30,113.00),(336,NULL,1985,'La Fée Arie',129,NULL,5,31,96.70),(337,'00:08:25',NULL,'Fantasy for Brass Band',131,NULL,3,54,103.80),(338,'00:14:00',2001,'Wounded Knee',131,NULL,1,47,138.30),(339,'00:14:22',2005,'A Royal Mile Suite',132,NULL,4,95,71.40),(340,'00:07:00',2005,'Airs and Dances',132,NULL,3,132,142.50),(341,NULL,1998,'American Variations',132,NULL,3,17,135.70),(342,'00:06:40',2004,'Festival Overture',132,NULL,4,132,123.40),(343,'00:06:18',1999,'Glasgow Overture',132,NULL,4,132,105.30),(344,NULL,2005,'Horwood Reflections',132,NULL,5,150,113.60),(345,'00:09:30',2001,'Landscape and Journey',132,NULL,3,132,146.30),(346,'00:06:10',NULL,'Prelude to a Festival',132,NULL,4,132,53.90),(347,'00:08:00',2000,'St. Andrew\'s Variations',132,NULL,5,95,93.00),(348,'00:12:00',2006,'Gothic Dances',132,NULL,2,132,64.20),(349,'00:10:50',2008,'Anglian Dances',132,NULL,4,95,52.20),(350,NULL,2009,'A Scots Miscellany',132,NULL,3,132,80.10),(351,'00:06:07',2010,'Scottish Rhapsody',132,NULL,4,35,133.50),(352,'00:12:00',2011,'Fellside Music',132,NULL,4,132,54.50),(353,'00:06:00',2014,'Black Dark and Golden Light',132,NULL,4,132,87.40),(354,NULL,2014,'Paristicherie',132,NULL,4,132,72.60),(355,'00:06:57',NULL,'Music from the 16th Century',133,NULL,5,132,78.40),(356,'00:10:30',NULL,'Labour and Love',136,NULL,3,164,92.90),(357,'00:15:00',2013,'An Epic Symphony',136,NULL,2,164,92.90),(358,NULL,1998,'Pioneer',143,NULL,3,105,144.80),(359,NULL,2007,'Imperium',143,NULL,3,105,55.40),(360,'00:11:00',2007,'Suite Celebration',143,NULL,3,72,92.10),(361,'00:10:30',2015,'Festivali',143,NULL,3,117,64.10),(362,'00:08:00',NULL,'Slawische Rhapsodie Nr. 1 (1)',145,465,2,19,52.80),(363,NULL,2015,'At Africa\'s Edge',146,NULL,3,NULL,118.40),(364,NULL,2010,'Ravenhill Suite',151,NULL,3,155,131.10),(365,'00:11:45',NULL,'Suite pour Brass Band',152,NULL,2,98,69.90),(366,'00:08:28',2003,'Evolutions',154,NULL,2,191,140.60),(367,'00:09:20',2008,'Pyramids',154,NULL,3,191,65.20),(368,'00:05:40',2010,'Divertimento (5)',154,NULL,4,191,69.30),(369,'00:09:30',NULL,'Rhapsody in Brass',163,NULL,2,164,128.40),(370,'00:16:15',1995,'Concerto for Band',164,NULL,2,95,79.50),(371,NULL,NULL,'Deva, Suite',164,NULL,3,121,52.90),(372,'00:09:57',NULL,'Fanfare Diversions',164,NULL,4,79,51.20),(373,NULL,NULL,'Prelude, Song & Dance',164,NULL,4,95,110.80),(374,'00:14:30',2002,'A Tribute to Henk Badings',165,NULL,1,72,58.70),(375,'00:14:30',2002,'Burlesque',165,NULL,1,72,61.50),(376,'00:10:15',2010,'The Legend of the Cloak',165,NULL,4,72,63.70),(377,NULL,2010,'Mato Grosso',170,NULL,2,144,138.80),(378,'00:10:57',1995,'Blazon',171,NULL,2,154,64.20),(379,'00:09:50',1999,'Dancing in the Park',171,NULL,3,73,112.00),(380,'00:08:45',NULL,'Dimensions, Symphonic Study for Brass Band',171,NULL,3,19,130.10),(381,'00:08:45',2005,'Northern Landscapes',171,NULL,3,73,50.10),(382,'00:12:10',NULL,'Prisms',171,NULL,2,19,117.60),(383,'00:09:15',2001,'Renaissance',171,NULL,2,154,132.20),(384,'00:08:00',1998,'Shine as the Light',171,NULL,2,155,101.70),(385,'00:10:40',2003,'The Dawning',171,NULL,2,155,59.60),(386,'00:13:45',NULL,'The Essence of Time',171,NULL,1,150,114.70),(387,'00:10:25',2000,'The Haslemere Suite',171,NULL,4,73,52.70),(388,'00:15:16',2006,'Montage',171,NULL,1,150,76.40),(389,'00:13:35',2008,'Journey to the Centre of the Earth',171,NULL,1,73,89.30),(390,'00:15:00',2013,'On the Shoulders of Giants',171,NULL,1,73,135.70),(391,'00:09:00',2013,'The Red Machine',171,NULL,3,73,69.70),(392,'00:10:00',2015,'Voyage to Worlds Unknown',171,NULL,2,73,88.80),(393,'00:10:00',2015,'The Journal of Phileas Fogg',171,NULL,4,73,118.60),(394,'00:16:00',2015,'The Triumph of Time',171,NULL,1,73,52.20),(395,'00:11:20',2008,'Hostile Skies',173,NULL,2,97,56.50),(396,'00:13:15',2013,'Angel of the North',173,NULL,3,97,140.60),(397,'00:11:45',NULL,'Connotations for Brass Band',174,NULL,2,19,51.00),(398,'00:13:00',1996,'Dances and Arias',174,NULL,1,164,115.20),(399,'00:12:40',NULL,'Essay for Brass Band',174,NULL,2,164,89.70),(400,'00:10:29',NULL,'Occasion',174,NULL,2,129,138.80),(401,'00:18:15',NULL,'Of Men and Mountains',174,NULL,1,129,145.80),(402,'00:10:58',NULL,'Partita',174,NULL,4,164,75.40),(403,'00:05:43',2005,'Patterns',174,NULL,3,164,116.00),(404,'00:11:46',NULL,'The Pacemakers, Concert Overture',174,NULL,3,164,80.40),(405,'00:12:00',NULL,'The Plantagenets, a Symphonic Study',174,NULL,1,164,117.30),(406,'00:12:00',NULL,'Variations on Laudate Dominum (1)',174,NULL,3,154,133.70),(407,'00:09:15',NULL,'Voices of Youth, Suite (1)',174,NULL,4,164,142.30),(408,'00:16:00',2009,'Rococo Variations',174,NULL,1,169,117.60),(409,'00:05:36',2004,'Spring',175,240,5,93,53.70),(410,'00:14:56',2006,'Lux Aeterna',176,NULL,1,191,60.80),(411,NULL,2005,'My Day - Mein Tag',179,NULL,4,117,79.90),(412,'00:13:49',2009,'Die Alpen',183,NULL,1,132,88.60),(413,NULL,NULL,'Episodes for Brass',184,NULL,5,164,95.80),(414,'00:10:44',NULL,'Mexican Festa, Suite',184,NULL,4,169,101.90),(415,NULL,NULL,'The four Corners of the World',184,NULL,4,169,98.90),(416,'00:14:45',2002,'Sword, Jewel and Mirror',187,NULL,2,169,63.00),(417,NULL,2010,'Kingdom of Dragons',187,NULL,3,78,149.50),(418,'00:11:00',2012,'Olympus',187,NULL,3,78,79.30),(419,'00:09:17',2005,'Fantasy for a Jubilee',188,NULL,4,NULL,146.70),(420,NULL,NULL,'Romantic Rhapsody',191,NULL,3,121,52.40),(421,'00:09:30',2015,'Canzona in Echo',192,NULL,3,191,56.20),(422,NULL,NULL,'London River',193,NULL,4,197,54.20),(423,NULL,NULL,'Shakespearean-Rhapsody',193,NULL,4,164,132.40),(424,NULL,NULL,'The Winter\'s Tale',193,NULL,4,197,76.90),(425,'00:13:55',NULL,'Contest Music',194,NULL,1,19,108.30),(426,NULL,NULL,'Variations and Fugue for Brass Band',198,NULL,2,19,124.20),(427,NULL,NULL,'Fantasy on a Swiss Folk Song',199,NULL,3,132,95.30),(428,'00:08:00',2005,'Rhythmicals (1)',199,NULL,3,86,117.30),(429,NULL,NULL,'The three Musketeers',202,NULL,2,164,131.80),(430,NULL,2010,'Argos',208,NULL,4,104,101.20),(431,'00:09:30',2010,'Piccadilly',208,NULL,2,104,114.90),(432,'00:11:00',2015,'Vertex Montis',208,NULL,2,104,102.20),(433,'00:15:30',2015,'A Lenda do Curupira',208,NULL,2,104,60.70),(434,'00:13:30',NULL,'A Moorside Suite',210,NULL,2,164,67.40),(435,'00:11:15',NULL,'Second Suite in F Major',210,522,2,19,89.20),(436,'00:10:45',NULL,'Ballet for Band',212,NULL,1,164,67.10),(437,'00:11:30',2008,'Lake of the Moon',214,NULL,3,157,59.00),(438,'00:11:20',2013,'Cry of the Falcon (1)',214,NULL,4,157,76.40),(439,'00:10:40',2014,'Thyellene',214,NULL,2,157,123.90),(440,'00:13:08',NULL,'Pageantry, Suite',215,NULL,2,164,142.50),(441,'00:12:30',NULL,'Three Figures, Tryptich',215,NULL,2,192,124.70),(442,'00:06:30',2011,'Caprice for Brass Band',216,NULL,3,164,148.10),(443,'00:09:30',NULL,'Symphonic Music',216,NULL,2,164,143.80),(444,'00:17:09',NULL,'A Downland Suite',221,NULL,2,164,143.60),(445,'00:11:45',NULL,'Comedy, Overture',221,NULL,2,164,138.30),(446,'00:13:00',NULL,'Broadland Day',225,NULL,2,19,97.20),(447,'00:10:23',NULL,'A Swedish Rhapsody',226,NULL,3,129,51.60),(448,NULL,NULL,'A Victorian Rhapsody',226,NULL,3,129,112.00),(449,NULL,NULL,'Ballad for Band',226,NULL,4,169,86.60),(450,NULL,NULL,'Pride of Youth, Overture',226,NULL,2,19,72.90),(451,'00:12:03',NULL,'Suite in B flat',226,NULL,3,164,115.10),(452,NULL,NULL,'Symphonic Study',226,NULL,2,19,70.00),(453,NULL,2004,'Im Frühjahr, sinfonische Skizze (1)',228,492,3,47,107.80),(454,'00:10:15',NULL,'Romantische Ouverture',228,528,2,132,101.70),(455,'00:07:40',2013,'Dublin Pictures (1)',231,NULL,4,123,133.60),(456,'00:09:17',2013,'Red Mountain',231,NULL,2,123,61.20),(457,'00:08:37',NULL,'Coriolanus, Tondichtung',232,NULL,3,164,97.40),(458,NULL,NULL,'Kaleidoscope',236,NULL,5,164,96.20),(459,NULL,NULL,'City by the Sea, Suite',237,NULL,5,19,85.50),(460,NULL,2005,'Glorifico Aeternum',239,NULL,3,92,75.00),(461,'00:12:45',2013,'Lord of All',239,NULL,2,117,108.00),(462,'00:09:30',2013,'Night before Battle',239,NULL,5,97,116.70),(463,'00:08:00',2014,'Freefall',239,NULL,4,117,85.00),(464,'00:12:30',2015,'Vista',239,NULL,2,117,105.30),(465,'00:10:40',2015,'An English Pastorale',239,NULL,4,97,69.90),(466,'00:11:29',2007,'Lorenzo',243,NULL,4,164,121.00),(467,'00:11:52',NULL,'Divertimento (3)',244,NULL,3,129,144.50),(468,NULL,NULL,'Ouverture «Provence»',244,NULL,3,129,52.20),(469,'00:12:10',2005,'Galdhopiggen',246,NULL,3,117,113.60),(470,'00:08:45',2013,'Uorsin',248,NULL,4,117,126.70),(471,'00:16:00',1998,'Via Vitae',249,NULL,3,153,106.60),(472,'00:07:30',2013,'Schmelzende Riesen (1)',251,NULL,5,117,59.30),(473,'00:10:15',2015,'Argovia (1)',251,NULL,3,117,74.90),(474,'00:08:00',2010,'Thèmes et Variations',252,NULL,3,191,80.50),(475,NULL,2015,'Caverns',262,NULL,3,NULL,117.70),(476,'00:08:15',NULL,'Pasticcio for Brass Band',263,NULL,2,119,147.80),(477,'00:06:22',NULL,'Fantasy on British Sea Songs',268,NULL,3,35,87.40),(478,NULL,NULL,'Three Haworth Impressions',268,NULL,3,35,95.80),(479,'00:12:00',2015,'The Saga of Tyrfing',270,NULL,3,18,137.90),(480,'00:12:07',NULL,'Sinfonietta (1)',273,NULL,2,164,120.10),(481,'00:11:28',NULL,'Diversions on a Bass Theme (1)',279,NULL,1,164,94.90),(482,'00:13:00',NULL,'English Heritage',279,NULL,1,164,50.20),(483,'00:14:45',NULL,'Royal Parks',279,NULL,2,19,128.30),(484,'00:10:00',2014,'Cry of the Mountain',280,NULL,2,132,101.20),(485,'00:07:30',2013,'The Legend of Hans Roth',280,NULL,4,132,85.60),(486,'00:11:30',2014,'Age of Innocence',280,NULL,1,132,140.70),(487,'00:12:30',2007,'The Dark Side of the Moon',281,NULL,3,146,141.60),(488,'00:16:02',2009,'Within Blue Empires',281,NULL,1,146,104.70),(489,NULL,2010,'Vitae Aeternum',281,NULL,2,146,124.60),(490,'00:09:30',2012,'Fire in the Blood',281,NULL,3,141,76.00),(491,'00:13:00',2014,'Equilibrium',281,NULL,2,146,121.30),(492,'00:13:30',2015,'Orion',281,NULL,2,141,124.10),(493,'00:13:45',2015,'Breath of Souls',281,NULL,1,141,86.60),(494,'00:08:00',2010,'High Flyers',284,NULL,4,72,75.30),(495,'00:09:00',2010,'Millenium Flourishes',284,NULL,3,154,80.00),(496,'00:16:30',2001,'Cloudcatchers Fells',296,NULL,1,129,63.90),(497,'00:11:30',2000,'Salamander',296,NULL,1,164,54.70),(498,'00:12:00',2005,'Celebration',303,NULL,3,191,94.00),(499,'00:08:00',2000,'Métamorphoses',303,NULL,2,191,81.40),(500,'00:08:15',2000,'Sonatine',303,NULL,4,191,136.00),(501,'00:09:30',2008,'Légende orientale',303,NULL,2,191,114.60),(502,'00:07:30',2008,'Prelude et Danse',303,NULL,4,191,64.70),(503,'00:10:00',2014,'Zoom',303,NULL,2,53,85.10),(504,'00:21:00',2013,'Symphonic Suite (1)',306,NULL,2,117,60.70),(505,'00:09:15',2001,'Alpine Variations',310,NULL,3,47,119.80),(506,'00:06:20',2000,'Anniversary Music',310,NULL,4,144,55.10),(507,'00:15:40',2001,'Dreams',310,NULL,1,171,118.70),(508,NULL,2000,'Mountain Views',310,NULL,3,132,146.10),(509,'00:07:22',2005,'Music for Cinema',310,NULL,4,123,131.60),(510,NULL,2005,'Sanetch',310,NULL,4,123,95.60),(511,'00:12:23',1999,'The Band\'s Man Challenger',310,NULL,2,47,72.70),(512,NULL,2007,'Ancient Monuments',310,NULL,3,123,122.40),(513,'00:15:00',2008,'Contrasts ',310,NULL,1,54,81.80),(514,'00:07:33',2013,'Clouds',310,NULL,4,54,147.60),(515,'00:15:00',2013,'Inland Rivers',310,NULL,2,54,142.40),(516,'00:13:00',2014,'The Son of the Sun',310,NULL,2,54,57.80),(517,'00:10:20',2015,'Feeling Young',310,NULL,3,123,92.10),(518,NULL,2015,'...as a Glow',320,NULL,2,95,116.70),(519,'00:15:00',2015,'Arabesque 1',320,NULL,1,95,57.10),(520,NULL,1999,'A Dunwich Sinfonietta',321,NULL,4,132,113.10),(521,NULL,NULL,'A Louis Chappuis Suite',321,NULL,4,132,72.70),(522,'00:09:52',NULL,'A Suite for Switzerland',321,NULL,4,143,59.10),(523,NULL,NULL,'Confoederatio Helvetica',321,NULL,2,132,110.30),(524,NULL,NULL,'Sound of Brass',321,NULL,4,121,69.80),(525,'00:11:00',2010,'Four Cities Symphony',322,NULL,4,146,120.90),(526,'00:13:00',2015,'A King\'s Lie',325,NULL,2,30,84.40),(527,'00:09:00',2015,'Rhapsody on a Theme by Purcell ',327,NULL,2,154,99.70),(528,'00:12:30',2015,'Odyssey',327,NULL,1,154,75.00),(529,'00:07:55',2009,'Saphira',328,NULL,4,117,94.30),(530,'00:10:00',NULL,'Rhapsody on British Sea Shanties',332,NULL,3,138,149.40),(531,'00:16:30',2014,'Titan\'s Progress',334,NULL,1,59,129.80),(532,'00:12:52',NULL,'Carnival, Suite',336,NULL,2,164,104.50),(533,NULL,NULL,'Little Suite for Brass Band',340,NULL,4,164,119.40),(534,NULL,NULL,'Overture Strand on the Green',340,NULL,4,164,107.30),(535,NULL,2010,'Turris Fortissima',341,NULL,3,154,124.10),(536,'00:12:00',2013,'Cristo Redentor',341,NULL,3,154,129.00),(537,NULL,2014,'The Day of the Lord',341,NULL,2,154,100.90),(538,'00:10:15',2015,'Life Ablaze',341,NULL,3,117,149.10),(539,'00:12:51',NULL,'Owain Glyndwr, Heroic Rhapsody',343,NULL,2,164,98.00),(540,'00:11:45',1996,'Corpus Christi',347,NULL,2,171,100.00),(541,'00:13:31',2004,'Isaiah 40',347,NULL,1,154,101.60),(542,'00:08:18',1999,'Quintessence',347,NULL,2,154,78.60),(543,'00:11:00',2015,'Strawabar',354,NULL,3,104,58.50),(544,'00:08:50',NULL,'A Saddleworth Festival Overture',357,NULL,3,169,73.80),(545,'00:10:47',1999,'Bel-Air',357,NULL,3,132,78.70),(546,NULL,2004,'Cherchebi',357,NULL,3,132,51.40),(547,NULL,2011,'Continental Caprice',357,NULL,3,169,54.20),(548,'00:12:20',NULL,'Cross Patonce',357,NULL,1,169,139.90),(549,'00:11:10',2005,'Newstead',357,NULL,3,132,107.90),(550,'00:11:15',NULL,'Oceans',357,NULL,2,169,54.30),(551,'00:12:00',1997,'Three Saints',357,NULL,2,132,55.10),(552,'00:10:50',2005,'Voyage of Discovery',357,NULL,1,132,122.00),(553,NULL,NULL,'The White Company',358,NULL,2,19,146.60),(554,NULL,NULL,'Spirit of Progress, Symphonic Poem',359,NULL,4,149,105.80),(555,'00:11:00',2008,'Quo vadis?',359,NULL,3,197,88.10),(556,NULL,NULL,'Rule Britannia, Overture',360,508,4,197,113.40),(557,'00:11:45',2013,'Bellum et Pax',363,NULL,2,47,50.80),(558,'00:08:00',2013,'Pinocchio',366,NULL,3,117,138.60),(559,'00:16:45',2013,'Merlin the Wizard',366,NULL,3,117,70.90),(560,'00:07:30',2013,'From the Depths',366,NULL,3,117,126.60),(561,'00:14:28',2001,'Montreux Wind Dances',371,NULL,1,54,142.50),(562,'00:10:40',2005,'Antigone, fille d\'Oedipe',372,NULL,3,191,149.00),(563,'00:09:15',2008,'Promiseland',372,NULL,2,191,74.80),(564,'00:12:00',2014,'Sculptures',372,NULL,2,191,90.30),(565,'00:14:00',2009,'Metropolitan Suite ',376,NULL,2,191,77.00),(566,NULL,2014,'Colosseo',376,NULL,4,191,52.60),(567,NULL,2015,'La Fantaisie Lémanique',377,NULL,3,NULL,134.10),(568,'00:09:30',2015,'Call of the New Sun',377,NULL,4,171,69.60),(569,NULL,NULL,'Urbs Salve Regia, Suite',383,NULL,4,128,115.20),(570,'00:07:00',2005,'A Western Suite',384,527,4,72,86.40),(571,NULL,2012,'Purpose',388,NULL,3,154,78.80),(572,NULL,2013,'Exultate Deo',388,NULL,3,154,105.10),(573,'00:10:00',2015,'Inclusion',388,NULL,3,154,105.20),(574,NULL,NULL,'The Rising Generation',392,NULL,5,19,101.40),(575,'00:10:00',NULL,'Energy',393,NULL,1,19,87.70),(576,'00:11:30',NULL,'Volcano, Symphonic Study',393,NULL,1,150,97.10),(577,'00:12:45',NULL,'A Celtic Suite',398,NULL,2,169,144.30),(578,'00:12:39',NULL,'A London Overture',398,NULL,2,169,107.70),(579,'00:10:15',NULL,'A Malvern Suite',398,NULL,2,169,70.30),(580,'00:14:45',2005,'Cambridge Variations',398,NULL,1,169,129.00),(581,'00:11:30',1996,'Endeavour',398,NULL,2,169,130.00),(582,'00:13:00',1996,'Harmony Music',398,NULL,1,169,127.00),(583,NULL,2005,'Hymn of the Highlands',398,NULL,2,8,99.40),(584,'00:14:15',2000,'Partita (2)',398,NULL,1,169,64.60),(585,'00:14:40',2005,'The four noble Truths',398,NULL,3,8,83.10),(586,'00:08:42',NULL,'The Prizewinners, Concert Overture',398,NULL,2,164,126.00),(587,'00:11:45',NULL,'Tryptich for Brass Band',398,NULL,2,169,122.60),(588,'00:14:00',2001,'Variations on an Enigma',398,NULL,1,169,100.20),(589,'00:17:05',2007,'Between the Moon and Mexico',398,NULL,1,169,58.80),(590,'00:05:37',2007,'The Pioneers',398,NULL,4,8,137.30),(591,'00:15:09',2008,'Tallis Variations',398,NULL,1,169,53.90),(592,NULL,2008,'The Saga of Haakon the Good',398,NULL,2,8,139.70),(593,'00:14:00',2008,'Music for Battle Creek',398,NULL,1,8,118.30),(594,'00:14:30',2010,'Dances and Alleluias',398,NULL,1,8,87.00),(595,'00:16:00',2010,'Music of the Spheres',398,NULL,1,8,110.90),(596,'00:09:40',2012,'Saint-Saëns Variations',398,NULL,4,8,137.60),(597,'00:13:20',2013,'Three Extraordinary Journeys (1)',398,NULL,3,8,64.40),(598,'00:11:30',2015,'Evolution (1)',398,NULL,3,8,146.10),(599,'00:19:00',2015,'A Tale As Yet Untold',398,NULL,1,8,91.60),(600,NULL,NULL,'A Wealdon Rhapsody',399,NULL,5,169,113.30),(601,'00:10:54',NULL,'Stantonbury Festival',402,NULL,4,150,68.70),(602,'00:13:40',NULL,'The Beacons',402,NULL,1,150,114.60),(603,'00:10:30',2000,'The Journeymen',402,NULL,4,150,80.20),(604,'00:12:40',2014,'Daystar',402,NULL,3,154,99.60),(605,NULL,NULL,'Embassy, Suite',405,NULL,2,19,106.60),(606,NULL,2010,'Music for the Medieval Court',417,NULL,4,117,94.50),(607,'00:11:17',2005,'A Sinfonic Requiem',418,NULL,2,171,101.70),(608,'00:19:54',2009,'Reflection of Colours',418,NULL,1,132,50.70),(609,'00:07:00',1999,'Fantaisie héroïque',423,NULL,3,50,121.00),(610,'00:15:38',NULL,'Excalibur',425,NULL,1,185,132.70),(611,'00:15:00',NULL,'Stonehenge',425,NULL,1,47,88.00),(612,'00:12:20',2013,'Parnassus',425,NULL,4,47,93.40),(613,'00:15:00',2013,'Albion',425,NULL,1,47,63.90),(614,'00:09:00',2004,'Cambridgeshire Impressions',426,NULL,4,72,58.80),(615,'00:10:25',2007,'Crusade',426,NULL,3,97,81.50),(616,'00:08:15',2013,'Bellum Belgicum',426,NULL,4,97,102.70),(617,'00:08:28',2014,'Arcen Variations',428,NULL,4,23,63.20),(618,'00:11:51',NULL,'Variations for Brass Band',431,NULL,2,19,116.00),(619,'00:15:00',NULL,'English Folk Songs, Suite',431,466,4,19,142.10),(620,'00:11:15',NULL,'Entertainments',435,NULL,2,164,64.80),(621,'00:11:02',NULL,'James Cook, Circumnavigator',435,NULL,2,143,101.10),(622,'00:09:24',NULL,'John O\'Gaunt, Concert Overture',435,NULL,2,164,133.30),(623,'00:12:19',NULL,'Salute to Youth, Suite',435,NULL,2,192,75.10),(624,'00:09:00',NULL,'Simon Called Peter',435,NULL,3,143,113.00),(625,'00:11:17',NULL,'Spektrum',435,NULL,2,143,104.20),(626,'00:12:08',NULL,'Symphony of Marches',435,NULL,2,192,92.70),(627,'00:12:42',NULL,'Triumphant Rhapsody',435,NULL,2,192,58.80),(628,'00:14:33',NULL,'Variations on a Ninth',435,NULL,2,192,51.20),(629,'00:10:00',1999,'Vizcaya',435,NULL,3,143,102.50),(630,'00:09:20',2000,'Inventions for Brass Band and Percussion',437,NULL,4,23,118.80),(631,'00:14:00',NULL,'L\'Enlèvement',438,NULL,2,119,113.50),(632,NULL,NULL,'Paseo Burlesco',438,NULL,2,119,99.90),(633,'00:12:00',1996,'Sarajevo',438,NULL,1,132,75.80),(634,'00:08:30',2005,'Come together',442,NULL,3,171,96.00),(635,'00:12:20',2005,'Visions',442,NULL,2,171,92.50),(636,NULL,2006,'Legenda rumantscha',442,NULL,3,104,117.90),(637,'00:11:30',2014,'The Graces of Love',442,NULL,3,16,74.60),(638,'00:13:00',2014,'The Raid',442,NULL,2,16,75.90),(639,'00:11:45',2015,'Traversada',442,NULL,2,104,98.60),(640,'00:19:45',2001,'Dove Descending',455,NULL,1,169,127.00),(641,'00:16:07',2005,'Leonardo',455,NULL,1,150,85.90),(642,'00:15:20',2000,'Lowry Sketchbook',455,NULL,1,108,147.40),(643,'00:16:45',2005,'Paganini Variations',455,NULL,1,129,79.70),(644,'00:11:48',2005,'Partita for Band (1)',455,NULL,2,150,138.00),(645,NULL,2005,'The Seasons',455,NULL,4,150,93.30),(646,NULL,2007,'A Little Light Music',455,NULL,2,95,105.80),(647,NULL,2009,'Psalms and Alleluias',455,NULL,2,95,142.10),(648,'00:11:31',1999,'In Other Words',457,NULL,2,132,106.30),(649,'00:08:15',2006,'Antarctica',459,NULL,4,72,94.40),(650,'00:11:00',2010,'La Viuda Negra',459,NULL,4,72,145.00),(651,NULL,NULL,'Coliseum',461,NULL,4,164,67.20),(652,'00:12:45',NULL,'Culloden Moor',461,NULL,2,164,142.50),(653,'00:14:02',NULL,'Five Blooms in a Welsh Garden',461,NULL,2,108,79.80),(654,'00:12:30',2005,'Salome',461,NULL,1,108,142.30),(655,NULL,NULL,'This Happy Island (Caribean Rhapsody)',461,NULL,2,164,132.70),(656,'00:10:30',2014,'Helvetia',461,NULL,2,146,74.40),(657,NULL,NULL,'The Yorkshire Ridings',462,NULL,3,18,136.40),(658,NULL,NULL,'A Rural Suite',463,22,5,19,59.10),(659,NULL,NULL,'Music for Brass',465,NULL,2,164,87.20),(660,NULL,NULL,'Overture for an Epic Occasion',465,NULL,3,164,87.10),(661,NULL,NULL,'Sirius, Variationen',465,NULL,3,19,127.80),(662,NULL,NULL,'The Sea (Thalassa)',465,NULL,2,19,123.50),(663,NULL,NULL,'Treshold',466,NULL,4,19,82.80),(664,NULL,NULL,'Pride of Race, Suite',467,NULL,3,164,102.60),(665,'00:05:31',NULL,'The Explorers, Overture',472,508,4,138,90.70),(666,'00:08:50',2006,'Trois fresques chromatiques',79,NULL,4,191,59.00),(667,'00:11:30',NULL,'Contrasten, Ostinato-Fantasia',92,NULL,3,47,64.10),(668,NULL,2010,'Silva Carbonaria',105,NULL,4,30,141.20),(669,'00:13:30',2015,'In Flanders Fields',105,NULL,3,30,133.10),(670,'00:07:00',2005,'Introduction, Romance & Dances',131,NULL,4,47,69.40),(671,'00:06:45',2001,'Babylon, soirée . . .',195,NULL,5,191,148.10),(672,NULL,1996,'Offside',197,NULL,3,19,141.00),(673,'00:12:00',2011,'Lothar',303,NULL,2,53,131.80),(674,'00:11:20',2011,'Odin, King of Asgard',310,NULL,3,54,112.00),(675,'00:08:30',1996,'Tantallon',312,NULL,2,50,74.20),(676,NULL,2011,'To teh Summits',372,NULL,4,191,86.30),(677,'00:08:30',2011,'To the Summits',372,NULL,4,191,66.90),(678,'00:08:17',NULL,'Summer Fantasy',381,NULL,5,47,63.90),(679,'00:07:45',2010,'Like a Child (1)',384,NULL,4,72,74.50),(680,'00:10:30',2010,'Land of Legends (1)',384,NULL,4,72,136.60),(681,'00:06:30',2010,'Voyage with the VOC (1)',433,NULL,4,72,149.40),(682,NULL,2006,'Fanfare and Funk',442,NULL,3,16,68.50),(683,NULL,NULL,'Im Aargau sind zwei Liebi, Suite',474,179,2,47,133.70),(684,'00:07:00',1996,'Panta Rhei',475,NULL,4,132,95.00),(685,'00:07:00',1995,'A North Norwegian Fantasy',1,NULL,4,47,98.20),(686,NULL,NULL,'Music for the Bandstand',8,NULL,4,121,64.10),(687,'00:06:00',1992,'Ragischs (Racines)',14,NULL,4,54,132.90),(688,'00:10:00',2006,'Le pêcheur et sa femme',21,NULL,5,54,145.90),(689,NULL,NULL,'Der Kalif von Bagdad, Ouverture',43,509,4,121,128.60),(690,'00:10:00',NULL,'Firestorm',58,NULL,2,47,64.10),(691,'00:07:00',1997,'A Sunrise Impression',92,NULL,5,47,149.80),(692,'00:10:00',NULL,'Inspiration',92,NULL,3,47,137.70),(693,NULL,2006,'The Crusades',96,NULL,4,54,122.00),(694,NULL,2010,'Accolades',105,NULL,4,30,51.70),(695,NULL,NULL,'Preludio, Lied und kleine Parade',121,NULL,5,74,61.00),(696,NULL,2010,'Contest Suite',128,NULL,3,30,132.80),(697,'00:08:10',NULL,'La Légende de Kuno, Poème symphonique',131,NULL,2,89,88.30),(698,'00:09:00',2010,'Columbus',165,NULL,4,72,102.80),(699,'00:08:00',2010,'Easter Suite',178,NULL,5,72,124.10),(700,'00:09:04',NULL,'Der Torero und die Zigeunerin',179,NULL,3,50,83.70),(701,'00:07:30',2006,'Bilder aus Luzern',179,NULL,5,148,139.50),(702,'00:08:00',NULL,'Three Times a Tune',181,NULL,5,47,124.80),(703,'00:06:10',1999,'Alternative Suite',188,NULL,5,50,146.10),(704,'00:07:10',1999,'For Broyarde',188,NULL,4,50,57.60),(705,NULL,NULL,'Contrasts in Brass',236,NULL,5,121,106.00),(706,'00:05:45',2003,'Lagrima',252,NULL,5,50,126.20),(707,'00:06:30',2011,'Gozbert',329,NULL,5,153,133.20),(708,'00:06:45',1997,'Festival Sounds',380,NULL,4,179,62.90),(709,NULL,2005,'Thailand Impressions',381,NULL,5,47,61.40),(710,'00:11:15',NULL,'Flashes for Band',386,NULL,5,157,109.30),(711,'00:11:36',2005,'Kaleidoscope (1)',398,NULL,2,8,121.80),(712,NULL,2010,'Fantasy on an English Folksong',418,NULL,4,171,63.80),(713,'00:06:30',2005,'Admiral Spirit',420,NULL,5,72,98.50),(714,NULL,NULL,'Fête nordique',423,NULL,4,50,98.00),(715,'00:07:00',1995,'Suite slave',423,NULL,4,50,122.80),(716,'00:08:30',NULL,'Slavia',425,NULL,3,47,85.10),(717,'00:06:50',2000,'Eine kleine Dorfmusik',443,NULL,5,37,94.00),(718,'00:08:00',2005,'Lord Tullamore',459,NULL,3,72,109.40),(719,'00:08:00',2010,'The Road to the West',459,NULL,4,72,122.00),(720,'00:14:08',1999,'Gli Elementi',21,NULL,1,54,82.70),(721,'00:04:59',1997,'Le Bal des Champignons',35,NULL,5,50,91.80),(722,NULL,NULL,'Concerto for Youth',37,NULL,3,171,97.20),(723,NULL,NULL,'Bellikoner Festouverture - Festival of Bellikon',39,NULL,4,128,119.00),(724,'00:09:00',2010,'Mazedonia',59,NULL,3,117,147.90),(725,'00:09:40',1995,'The Haunter of the Dark',69,NULL,2,123,147.60),(726,'00:07:00',2001,'Canticles',83,NULL,4,NULL,91.80),(727,'00:09:20',1998,'Prelude and Celebration',83,NULL,3,43,148.20),(728,'00:08:10',2003,'Dakota',91,NULL,5,47,53.10),(729,'00:08:00',2005,'Pacific Dreams',91,NULL,4,47,114.70),(730,'00:13:15',1996,'Harmony Festival',92,NULL,2,47,112.70),(731,NULL,2010,'From Source to Sea',105,NULL,3,30,144.90),(732,'00:06:55',NULL,'Ouverture Jubiloso',126,NULL,3,15,139.80),(733,'00:06:10',1999,'Prelude to a Festival (1)',132,NULL,4,132,121.20),(734,'00:06:00',2005,'Rhapsodia',135,NULL,4,16,145.90),(735,NULL,NULL,'Nordisk Rhapsody',139,NULL,4,180,64.70),(736,NULL,NULL,'Divertimento classico',180,NULL,3,54,71.50),(737,'00:07:05',1997,'Suite de Ballet',188,NULL,3,50,102.70),(738,NULL,1999,'Argovia',199,NULL,4,132,113.50),(739,'00:06:00',NULL,'Capriccietto',199,NULL,4,132,134.40),(740,NULL,1999,'Concert Suite op. 60',199,NULL,4,132,126.30),(741,NULL,NULL,'Burlesca',216,NULL,3,153,144.60),(742,NULL,NULL,'Intermezzo',216,NULL,4,54,143.70),(743,NULL,NULL,'Pilatus, symphonische Musik',216,NULL,2,119,63.80),(744,'00:05:10',2014,'Polaris',231,NULL,5,191,108.60),(745,NULL,2012,'Besuch im Linzgau',235,NULL,4,142,58.50),(746,'00:07:10',1997,'Anna Göldin',252,NULL,4,50,90.80),(747,NULL,2006,'Spirit of Lihn',275,NULL,4,142,63.80),(748,'00:07:35',2005,'Inonorata',287,NULL,4,50,95.80),(749,'00:07:45',2005,'Antarès',290,NULL,3,50,63.00),(750,'00:07:20',2005,'Conquistador',312,NULL,3,54,58.80),(751,'00:09:35',1999,'A Swiss Folk Fantasy',357,NULL,3,132,82.40),(752,NULL,2007,'Intervals',362,NULL,3,132,58.70),(753,NULL,2010,'Der Haslibacher',369,NULL,5,117,91.80),(754,'00:09:45',NULL,'A Swiss Festival Overture',398,NULL,2,169,115.60),(755,'00:14:55',2000,'Diversions',398,NULL,2,169,68.60),(756,'00:07:15',NULL,'Jubilee Overture',398,NULL,3,169,116.40),(757,'00:11:45',NULL,'Music for a Festival',398,NULL,2,169,53.00),(758,'00:12:30',1995,'The Land of the Long White Cloud - «Aotearoa»',398,NULL,1,164,50.50),(759,'00:14:30',NULL,'The Year of the Dragon',398,NULL,1,169,130.10),(760,'00:13:30',2006,'Between the two Rivers',398,NULL,2,8,148.80),(761,NULL,2010,'Passacaglia Op. 111',418,NULL,3,171,114.90),(762,'00:07:04',2005,'Festive Impressions',442,NULL,3,16,127.50),(763,NULL,2003,'Kein schöner Land',442,NULL,4,153,115.40),(764,'00:10:25',NULL,'Tombstone-Arizona, Concert Overture',461,NULL,2,164,69.60),(765,NULL,NULL,'Impromptu (1)',22,478,4,47,102.00),(766,'00:08:47',NULL,'Call of the Sea (1)',22,NULL,2,121,138.30),(767,'00:12:45',NULL,'Resurgam, Tone Poem (1)',22,482,2,121,96.50),(768,NULL,NULL,'Sunset Rhapsody (1)',22,NULL,4,121,92.60),(769,'00:11:00',NULL,'Main Street (1)',22,509,3,121,144.00),(770,'00:09:08',NULL,'Kenilworth, Suite (1)',38,NULL,2,121,133.20),(771,'00:12:00',NULL,'Blackfriars (1)',81,466,2,121,126.50),(772,'00:09:00',2015,'Kraftwerk (1)',91,NULL,2,47,99.90),(773,NULL,NULL,'Partita op. 96',99,NULL,2,121,51.10),(774,'00:07:30',2013,'Légendes lacustres',162,NULL,5,4,66.70),(775,'00:09:30',NULL,'Rhapsody in Brass (1)',163,NULL,2,121,84.20),(776,'00:13:30',2002,'The Innocent Condemned',165,NULL,2,72,77.10),(777,'00:11:30',2010,'The Robber Knight (1)',165,NULL,4,72,139.90),(778,'00:07:00',2010,'The Battle of Varlar',165,NULL,5,72,120.00),(779,'00:09:15',NULL,'Voices of Youth, Suite',174,478,4,47,120.90),(780,'00:10:58',NULL,'Partita (1)',174,491,4,47,103.10),(781,'00:11:40',2005,'Variations on Laudate Dominum',174,514,3,72,52.70),(782,'00:11:46',NULL,'The Pacemakers, Concert Overture (1)',174,386,3,47,105.50),(783,'00:09:45',2015,'Illusion d\'Optique',178,NULL,3,72,147.50),(784,'00:12:03',NULL,'Suite in B flat (1)',226,NULL,3,121,76.70),(785,'00:08:37',NULL,'Coriolanus, Tondichtung (1)',232,NULL,3,121,96.40),(786,'00:08:00',NULL,'A Circus Suite (1)',236,489,4,47,76.80),(787,'00:11:28',1996,'Diversions on a Bass Theme',279,502,1,121,143.50),(788,'00:12:30',NULL,'The Land of the Long White Cloud «Aotearoa»',398,521,1,47,50.90),(789,NULL,NULL,'Mouvements symphoniques',404,NULL,3,178,94.60),(790,'00:13:00',NULL,'Triptiek voor Fanfare',416,NULL,2,121,130.60),(791,'00:09:00',2010,'Cambridgeshire Impressions (1)',426,NULL,4,72,56.50),(792,NULL,NULL,'Jeu de Cuivre',427,NULL,2,121,72.10),(793,NULL,NULL,'The Yorkshire Ridings (1)',462,NULL,3,121,103.50),(794,NULL,NULL,'The Sea (Thalassa) (1)',465,NULL,2,121,105.50),(795,NULL,NULL,'Pride of Race, Suite (1)',467,NULL,3,121,115.30),(796,NULL,NULL,'Suite antique',12,NULL,5,121,74.00),(797,'00:08:30',NULL,'Little Suite No. 2 (1)',13,477,3,121,126.80),(798,'00:06:52',2012,'Freedom of the Seas',16,NULL,4,178,61.60),(799,NULL,NULL,'Au pays lorrain',20,NULL,4,112,109.00),(800,'00:08:45',NULL,'2nd Rhapsody on Negro Spirituals (1)',22,NULL,3,121,69.40),(801,NULL,NULL,'A Holiday Suite (1)',22,NULL,4,121,137.00),(802,NULL,NULL,'Divertimento (1)',22,NULL,5,121,117.80),(803,NULL,NULL,'Everybody\'s Child, Divertissement (1)',22,NULL,4,121,80.30),(804,'00:07:40',NULL,'Petite Suite de Ballet (1)',22,NULL,3,121,105.90),(805,NULL,NULL,'The Princess and the Poet (1)',22,NULL,4,121,56.90),(806,NULL,NULL,'1st Rhapsody on Negro Spirituals (1)',22,525,3,121,103.10),(807,NULL,NULL,'Capriccio sinfonico',39,NULL,2,82,143.80),(808,'00:11:00',NULL,'Pastoral Suite',40,NULL,2,121,81.50),(809,NULL,NULL,'Ballade',41,NULL,4,121,72.30),(810,NULL,NULL,'Grand Canon du Verdon, Ouverture',41,NULL,4,121,85.20),(811,NULL,NULL,'Danze',75,NULL,2,157,110.50),(812,'00:08:15',NULL,'Capriccio barbaro',85,NULL,2,54,107.80),(813,NULL,NULL,'Konzert-Rhapsodie',85,NULL,2,121,58.70),(814,'00:08:12',NULL,'Tanz ohne Tänzerin',85,NULL,2,54,135.90),(815,NULL,NULL,'Hollandse Rhapsodie',90,532,4,121,133.80),(816,'00:13:40',1997,'Overture to a New Age',92,NULL,2,47,52.70),(817,NULL,NULL,'Epaminondas, dramatische Ouvertüre',95,NULL,2,157,137.70),(818,'00:05:45',NULL,'Little Suite for Winds',97,NULL,5,7,60.60),(819,NULL,NULL,'Het daget in den Osten',107,NULL,2,121,84.10),(820,NULL,NULL,'Partita capricciosa',109,NULL,3,121,103.50),(821,'00:07:42',NULL,'A Junior Suite',128,NULL,5,47,126.30),(822,NULL,2010,'Mother\'s Wing',128,NULL,4,30,61.50),(823,NULL,NULL,'Scherzo fantastique',137,NULL,2,157,122.90),(824,NULL,NULL,'Four Contrasts for Wind',139,NULL,4,121,112.00),(825,'00:09:00',NULL,'In Harmony',139,NULL,3,121,138.30),(826,'00:08:00',NULL,'Slawische Rhapsodie Nr. 1',145,490,2,121,105.70),(827,NULL,NULL,'Kleine Blasorchestersuite',148,NULL,4,121,114.70),(828,'00:05:54',NULL,'Ukrainische Bauerntänze',158,NULL,5,121,94.70),(829,'00:09:30',2010,'Don Quichote de la Mancha',165,NULL,4,72,77.60),(830,'00:08:45',NULL,'Dimensions, Symphonic Study',171,386,3,47,58.60),(831,NULL,NULL,'Four Dances',181,NULL,5,157,148.00),(832,'00:08:15',NULL,'Petite Suite Pittoresque',191,NULL,4,121,104.50),(833,'00:06:45',NULL,'Thème varié',191,NULL,5,121,124.40),(834,'00:11:00',NULL,'Sinfonia classica',218,NULL,4,121,99.30),(835,'00:17:09',NULL,'A Downland Suite (1)',221,508,2,121,61.50),(836,'00:12:19',NULL,'Savanna, Movement for Wind Orchestra N° 2',222,NULL,1,97,68.80),(837,NULL,NULL,'Drie Speelstukken',242,NULL,5,121,116.10),(838,NULL,NULL,'Hugenottensuite',242,NULL,4,121,77.60),(839,NULL,NULL,'Suite op Oud-Hollandse Motieven',242,NULL,5,121,56.20),(840,'00:08:00',NULL,'Jewish Folksong Suite',245,NULL,4,47,53.50),(841,NULL,NULL,'Ambassadorenfest, Suite',255,NULL,2,157,70.70),(842,NULL,NULL,'Das Orakel zu Delphi',255,NULL,2,47,132.40),(843,NULL,NULL,'Gyges und sein Ring',255,NULL,2,47,90.70),(844,'00:10:20',NULL,'Festival Rhapsodie',267,NULL,3,121,74.60),(845,'00:09:16',NULL,'Versailles',267,NULL,5,121,60.80),(846,'00:11:10',NULL,'Mediterranean Suite',271,NULL,3,121,103.60),(847,NULL,NULL,'Prima partita al modo del barocco',335,NULL,3,121,56.40),(848,NULL,NULL,'Rule Britannia, Overture (1)',360,NULL,4,121,99.70),(849,NULL,NULL,'Highroad Impressions, Suite',375,NULL,3,121,82.30),(850,NULL,NULL,'Lords of the Seas',375,NULL,3,121,135.30),(851,'00:08:00',2003,'Oldunum',380,NULL,2,34,102.50),(852,'00:10:15',NULL,'Bal masqué',381,NULL,4,47,125.30),(853,'00:07:00',2010,'A Western Suite (1)',384,NULL,4,72,79.30),(854,'00:10:30',NULL,'Suite',386,NULL,2,123,66.20),(855,NULL,2010,'Fragments for Band',386,NULL,4,178,135.60),(856,NULL,NULL,'Kleine Suite für Blasorchester',400,NULL,4,121,94.20),(857,NULL,NULL,'Danserye 1551, Suite',407,526,5,121,85.60),(858,'00:09:00',NULL,'Rikudim',425,NULL,3,47,79.40),(859,'00:13:30',NULL,'St. Martin\'s Suite',425,NULL,2,47,74.40),(860,'00:07:15',NULL,'Suite provençale (1)',425,NULL,4,47,81.30),(861,NULL,NULL,'De Geuzen in de Bomlerwaard, Overture',427,NULL,4,121,85.40),(862,NULL,NULL,'Drie Oud-Hollandse Taferelen',427,NULL,4,121,125.90),(863,'00:11:10',NULL,'Interruptions',427,NULL,2,121,109.50),(864,'00:06:15',NULL,'Petite Ouverture Dansante',427,NULL,4,121,63.40),(865,'00:06:15',NULL,'Rhapsodie Française',427,NULL,4,121,109.80),(866,NULL,NULL,'Variations on a French Folksong',427,NULL,5,121,84.60),(867,'00:08:30',NULL,'Vier Impressies',427,NULL,4,121,130.00),(868,'00:10:30',NULL,'Folk-Song-Suite (1)',431,NULL,3,121,119.10),(869,'00:10:10',NULL,'A Farmers Holiday',436,NULL,3,121,121.40),(870,'00:06:45',NULL,'Brabant Fantasy',436,NULL,4,121,137.60),(871,'00:10:40',NULL,'Quatre jours à Paris',436,NULL,3,121,142.00),(872,'00:07:45',NULL,'Quattro Variazioni Musicali con Tema Popolare',436,NULL,3,121,119.20),(873,'00:08:00',NULL,'M\'Ami, Ouverture',440,NULL,4,121,129.00),(874,NULL,NULL,'Schottische Suite',440,NULL,4,121,66.90),(875,'00:12:00',1997,'Brugge',446,NULL,4,157,144.60),(876,'00:14:45',NULL,'Dunamis',446,NULL,2,47,88.60),(877,'00:06:15',NULL,'Festival Suite',446,NULL,5,157,102.30),(878,NULL,1995,'Mandel',446,NULL,4,157,112.00),(879,NULL,NULL,'Music for Band',446,NULL,3,7,146.70),(880,'00:08:15',2010,'Antarctica (1)',459,NULL,4,72,136.20),(881,NULL,NULL,'Overture for an Epic Occasion (1)',465,NULL,3,121,143.70),(882,NULL,NULL,'Sirius, Variationen (1)',465,NULL,3,121,122.30),(883,'00:05:31',NULL,'The Explorers, Overture (1)',472,NULL,4,121,147.40),(884,'00:12:30',2013,'Elements of Nature',334,NULL,2,16,53.90),(885,'00:26:00',2010,'Feste Romane',356,503,1,47,86.30),(886,'00:07:00',NULL,'Triptyque',2,NULL,3,148,136.30),(887,'00:15:30',2013,'Moyses',3,NULL,2,158,87.20),(888,'00:25:00',2010,'Marco Polo',4,NULL,1,140,58.60),(889,'00:18:00',2011,'Duende',4,NULL,1,140,137.30),(890,'00:11:48',2012,'Mais Alto e mais Longe',5,NULL,3,121,110.50),(891,'00:13:00',NULL,'Fantaisie pour petit orchestre d\'harmonie',6,NULL,2,121,66.40),(892,'00:08:45',2005,'Azerbaijan Capriccio',7,476,2,76,53.60),(893,'00:11:52',2005,'Symphonic Dances',7,476,2,76,134.90),(894,'00:11:14',NULL,'Dynamic Overture',8,NULL,2,121,107.30),(895,'00:11:42',NULL,'Overture for an Imaginary Play',8,NULL,3,121,135.10),(896,'00:19:30',NULL,'Sinfonia «Il Fiume»',8,NULL,1,121,76.90),(897,'00:11:48',NULL,'Symphonieen der Nederlanden',9,NULL,2,121,53.20),(898,'00:07:35',2005,'Gulliver\'s Travels',11,NULL,4,16,72.10),(899,'00:10:49',2005,'Jericho',11,NULL,3,16,80.90),(900,'00:10:00',2005,'Noah\'s Ark',11,NULL,2,16,56.70),(901,'00:15:23',2005,'Saga Candida',11,NULL,2,16,139.70),(902,'00:08:16',2005,'Ivanhoe',11,NULL,3,16,100.20),(903,'00:17:10',2005,'Egmont',11,NULL,1,16,110.90),(904,'00:07:04',2010,'Robinson Crusoe',11,NULL,3,16,109.20),(905,'00:13:10',2010,'Microtopia',11,NULL,2,16,64.40),(906,'00:27:47',2010,'Symphony No. 1: \"Gilgamesh\"',11,NULL,1,16,78.00),(907,'00:13:35',2013,'The Adventures of Baron Munchhausen',11,NULL,2,16,68.20),(908,'00:15:44',2013,'Saga Maligna',11,NULL,2,16,105.50),(909,'00:14:30',2013,'Rubicon',11,NULL,2,16,117.70),(910,'00:11:37',2014,'Isles of the Blessed',11,NULL,3,16,67.20),(911,'00:13:30',2005,'The Legend of Ali Baba',11,424,2,16,150.00),(912,'00:06:48',1998,'Prelude, Siciliano and Rondo for Symphonic Band',13,515,3,62,101.30),(913,'00:08:03',2003,'Peterloo Overture',13,518,2,85,144.50),(914,'00:07:10',2004,'Piccola Suite Klezmer',15,NULL,3,193,140.30),(915,'00:06:50',2013,'Blue Hole',16,NULL,4,153,88.80),(916,'00:16:30',NULL,'Conflicts and Confluences',18,NULL,1,121,66.30),(917,'00:12:30',1995,'Epiphany',18,NULL,1,121,77.20),(918,'00:10:00',NULL,'Figures sonores',18,NULL,1,121,122.60),(919,'00:14:00',NULL,'Golden Age',18,NULL,2,121,75.00),(920,'00:16:00',1995,'Lieshout en zijn Molens',18,NULL,1,121,145.90),(921,'00:12:00',NULL,'Transitions',18,NULL,1,161,148.90),(922,'00:10:30',NULL,'Le premier jour',21,NULL,2,54,107.40),(923,NULL,1997,'Ouverture pour Orchestre d\'Harmonie',21,NULL,2,50,68.90),(924,'00:24:00',1996,'Sinfonie für Blasorchester',21,NULL,1,54,124.60),(925,'00:12:45',2011,'Resurgam, Tone Poem (2)',22,481,2,70,145.10),(926,'00:21:00',2005,'Asgard',24,NULL,1,5,74.00),(927,'00:28:28',2010,'States of Mind',24,NULL,1,156,95.20),(928,'00:07:45',NULL,'By the River\'s Bend',25,NULL,3,12,126.20),(929,NULL,NULL,'Fanfare Variations',25,NULL,4,36,98.20),(930,'00:07:00',NULL,'Ouverture à la Russe',25,NULL,3,12,74.00),(931,'00:07:45',1997,'Alvamar',26,NULL,3,15,77.20),(932,'00:07:15',NULL,'Appalachian Overture',26,NULL,3,194,78.40),(933,'00:08:30',2002,'Dream Journey',26,NULL,2,166,62.10),(934,'00:15:00',1995,'Fantasy Variations',26,NULL,1,166,135.50),(935,'00:11:31',2005,'Impressions of Japan',26,NULL,2,166,90.50),(936,'00:09:40',1999,'Legend',26,NULL,2,166,90.80),(937,'00:09:45',NULL,'Symphonic Overture',26,NULL,2,166,147.60),(938,'00:11:30',2008,'Danza Sinfonica',26,NULL,1,166,95.30),(939,'00:38:14',2009,'Third Symphony',26,NULL,1,166,128.30),(940,'00:21:30',2010,'Fourth Symphony (1)',26,NULL,1,166,104.30),(941,'00:07:30',2010,'Eagle Bend',26,NULL,3,166,127.60),(942,'00:09:00',2015,'Beautiful Oregon',26,NULL,2,166,66.00),(943,'00:32:00',2015,'Symphonic Requiem',26,NULL,2,166,148.00),(944,'00:10:00',NULL,'Petite Suite',28,488,3,19,71.10),(945,'00:05:41',2007,'As if on Wings',30,NULL,4,12,145.90),(946,'00:22:05',2006,'Concert for Winds',31,NULL,1,25,147.00),(947,'00:15:25',NULL,'Suite of old American Dances',32,NULL,1,38,72.80),(948,'00:14:07',NULL,'Symphonic Songs for Band',32,NULL,2,38,142.70),(949,'00:10:30',NULL,'Der Landvogt von Greifensee',33,NULL,3,128,122.20),(950,'00:08:02',NULL,'Jubiläumsmusik',33,NULL,4,123,123.70),(951,'00:10:45',NULL,'Meggen',33,NULL,3,148,86.50),(952,'00:09:30',NULL,'Symphonischer Samba',33,NULL,2,148,100.60),(953,'00:09:30',NULL,'Transformationen',33,NULL,2,121,91.90),(954,'00:12:15',1995,'Die schwarze Spinne (1)',33,505,2,148,66.30),(955,'00:14:30',NULL,'Divertimento (2)',34,177,1,19,101.30),(956,'00:15:00',1995,'Symphony for Band',36,NULL,1,90,68.30),(957,'00:11:00',NULL,'Toccata, Air and Dance',37,NULL,2,148,98.40),(958,'00:08:00',1996,'Topas',37,NULL,3,123,145.40),(959,'00:09:45',NULL,'Ouverture über Schweizer Volkslieder',39,NULL,2,128,72.10),(960,NULL,NULL,'Spirit of Life',41,NULL,2,121,133.80),(961,'00:14:30',NULL,'Suite romantique',41,NULL,3,121,146.60),(962,'00:08:00',2010,'Der Reiter vom Bodensee',44,NULL,4,171,112.10),(963,'00:09:30',2003,'River Valley Suite',45,NULL,2,166,67.60),(964,'00:15:00',2011,'Polovetsian Dances',46,499,1,177,58.00),(965,'00:15:00',2011,'Polovstian Dances',46,476,1,103,72.50),(966,'00:06:44',2003,'Kleine Ungarische Rhapsodie',47,NULL,4,153,82.50),(967,'00:08:30',2010,'Le Nozze Veneziane',47,NULL,4,153,73.80),(968,'00:07:00',2010,'Scandinavia (1)',47,NULL,4,153,78.30),(969,'00:05:10',2013,'Norway Impressions',47,NULL,5,153,113.40),(970,'00:07:50',2013,'Mazury Rhapsody',47,NULL,4,153,54.80),(971,'00:09:00',2010,'Achnaton',48,NULL,3,72,146.30),(972,'00:11:00',2010,'Heaven & Earth',48,NULL,2,72,56.40),(973,'00:12:30',2010,'The Golden City',48,NULL,2,72,145.60),(974,'00:10:00',2005,'2001 - A Wind Odyssey',49,NULL,1,76,110.70),(975,'00:10:48',NULL,'Bridges over the River Cam',49,NULL,2,164,145.50),(976,'00:09:36',2005,'White Dragon',49,NULL,2,76,121.10),(977,'00:11:00',2005,'Wind Blitz',49,NULL,1,76,111.20),(978,'00:08:00',1998,'Urban Scenes',50,NULL,4,96,81.10),(979,'00:08:45',2005,'Variations for Band',51,NULL,3,196,103.50),(980,'00:12:00',2001,'Prospero',52,NULL,2,153,110.40),(981,NULL,1996,'Incaro',53,NULL,4,153,101.60),(982,'00:10:30',1996,'Suite Méditerranée',53,NULL,2,102,140.90),(983,'00:08:30',NULL,'Troika-Suite',53,NULL,4,102,67.50),(984,'00:13:45',NULL,'El Golpe Fatal',55,NULL,1,47,76.70),(985,'00:15:30',NULL,'Oscar for Amnesty',55,NULL,1,47,106.40),(986,'00:25:00',2015,'Simfonia Num. 6 «concisa»',56,NULL,1,NULL,69.80),(987,'00:12:00',2008,'Symphonette',58,NULL,2,43,126.90),(988,'00:14:40',2005,'1405: Der Brand von Bern',59,NULL,1,65,142.70),(989,'00:14:00',2005,'Szenen aus: Max und Moritz',59,NULL,2,117,141.40),(990,'00:09:27',2006,'Pompeji',59,NULL,4,117,148.60),(991,NULL,2008,'Flight',59,NULL,4,117,134.20),(992,NULL,2009,'Heidi und Peter',59,NULL,2,117,56.60),(993,NULL,2009,'Napoléon (1)',59,NULL,3,117,93.10),(994,NULL,2009,'The Cliffs of Moher',59,NULL,3,117,144.60),(995,NULL,2009,'Sacri Monti',59,NULL,2,117,91.50),(996,NULL,2009,'Von Rast und Hektik',59,NULL,2,117,97.70),(997,'00:06:00',2011,'Swiss Mountain Village (Urchigs Terbil)',59,NULL,5,117,133.80),(998,'00:10:30',2011,'Der Magnetberg',59,NULL,3,117,55.60),(999,'00:08:00',2011,'Indian Fire',59,NULL,4,117,83.10),(1000,'00:09:30',2013,'La légende de Sainte Odile',59,NULL,3,117,88.20),(1001,'00:08:15',2013,'Jambo Africa',59,NULL,4,117,78.40),(1002,'00:09:00',2013,'Terra Pacem',59,NULL,3,117,93.30),(1003,'00:08:00',2013,'Scottisch Sketches',59,NULL,4,117,138.00),(1004,'00:23:30',2013,'Hannibal (1)',59,NULL,1,117,137.50),(1005,'00:10:30',2015,'Perceval',59,NULL,3,117,104.00),(1006,'00:10:15',2015,'Les diamants de Septmoncel',59,NULL,3,117,88.70),(1007,'00:08:45',2015,'The States of Water (1)',59,NULL,4,117,90.30),(1008,'00:08:15',2015,'Heaven\'s Glory (1)',59,NULL,3,116,133.10),(1009,'00:07:45',2015,'Fantaisie Jurassienne',60,NULL,3,195,121.40),(1010,'00:14:00',1999,'Whatsoever Things',63,NULL,2,166,102.60),(1011,'00:11:30',2012,'A Movement for Rosa',63,NULL,2,183,98.50),(1012,NULL,NULL,'Rhapsodic Episode',65,NULL,4,12,120.50),(1013,'00:10:00',2000,'L\'homme qui prend',67,NULL,3,50,100.30),(1014,'00:08:15',NULL,'Concerto ticinese',68,NULL,3,171,60.60),(1015,'00:08:45',NULL,'Dynamic Overture (1)',69,NULL,2,123,109.90),(1016,'00:09:01',2005,'Greek Folk Song Suite',69,NULL,4,123,104.20),(1017,'00:08:01',1995,'Harlequin',69,NULL,2,123,69.20),(1018,'00:08:00',2000,'Le Cortège du Roi Renaud',69,NULL,2,47,108.70),(1019,'00:14:00',NULL,'Mexican Pictures',69,NULL,1,123,52.50),(1020,'00:19:45',NULL,'Mosaici Bizantini',69,NULL,1,123,149.80),(1021,'00:09:30',NULL,'Pastorale de Provence',69,NULL,4,123,87.50),(1022,'00:22:30',2005,'Poema Alpestre',69,NULL,1,123,129.70),(1023,'00:09:15',NULL,'Ukrainian Rhapsody',69,NULL,3,123,101.90),(1024,'00:08:00',2000,'Variations on a French Folk Song',69,NULL,3,123,129.60),(1025,NULL,2005,'Cossack Folk Dances',69,NULL,4,123,122.70),(1026,NULL,2005,'Huckleberry Finn Suite',69,NULL,2,123,90.10),(1027,'00:18:00',2006,'Blue Horizons',69,NULL,1,123,74.00),(1028,'00:10:47',2006,'Bulgarian Dances',69,NULL,2,123,78.00),(1029,'00:15:22',2008,'Tom Sawyer Suite',69,NULL,2,123,131.70),(1030,'00:09:45',2013,'Images of a City',69,NULL,3,123,142.30),(1031,'00:12:11',2013,'Pompeii',70,NULL,4,16,74.90),(1032,'00:08:23',NULL,'Incantation and Dance',71,NULL,2,19,90.20),(1033,'00:07:15',NULL,'Variations on a Korean Folk Song',71,NULL,3,19,88.10),(1034,'00:06:40',2005,'From Heartland to Heaven',72,NULL,5,12,133.10),(1035,'00:10:51',2003,'Divertimento for Winds and Percussion',73,NULL,2,44,121.20),(1036,'00:07:00',2014,'Gypsy Dance',76,NULL,4,62,54.20),(1037,'00:07:50',2005,'The Call of the Righteous',77,495,4,72,112.10),(1038,'00:12:30',NULL,'El Salon Mexico',78,499,1,19,102.80),(1039,'00:11:00',2013,'Deliverance',79,NULL,2,16,133.40),(1040,NULL,2014,'Sinfonietta Nr. 2',79,NULL,3,191,71.40),(1041,'00:08:00',2015,'Escapades (1)',79,NULL,5,117,146.10),(1042,'00:10:30',NULL,'Oxford Suite',80,NULL,2,121,79.10),(1043,'00:08:00',2005,'Deux Faces',82,NULL,4,171,93.60),(1044,'00:08:40',1997,'North West Passage',83,NULL,2,43,107.30),(1045,'00:08:15',NULL,'Partita for Band',83,NULL,3,90,92.20),(1046,'00:12:30',1997,'Praetorius Variations',83,NULL,1,43,139.30),(1047,'00:06:15',NULL,'Sovereign Variants',83,NULL,5,90,124.90),(1048,'00:09:30',NULL,'Where never Lark or Eagle flew',83,NULL,2,85,80.90),(1049,NULL,2003,'British Isles Suite',84,NULL,5,44,147.90),(1050,'00:12:00',NULL,'Suworow',85,312,2,54,109.40),(1051,'00:12:30',NULL,'Meditazione',87,NULL,2,121,77.90),(1052,'00:10:30',NULL,'Pastorale symphonique',91,NULL,2,47,66.60),(1053,'00:08:00',2005,'The Saint and the City (1)',91,NULL,4,47,90.00),(1054,'00:08:00',2003,'Virginia',91,NULL,3,47,136.20),(1055,'00:09:00',2005,'Contrasto Grosso',91,NULL,5,47,118.30),(1056,'00:07:10',2007,'Festa Paesana',91,NULL,4,47,130.30),(1057,'00:09:00',2010,'Kraftwerk',91,NULL,3,47,90.20),(1058,'00:09:00',2010,'The Heart of Lithuania',91,NULL,3,47,53.50),(1059,'00:12:30',2010,'Elegy 1',91,NULL,2,47,70.90),(1060,'00:09:45',2010,'Jubilate! (Waldkircha in Musica)',91,NULL,3,47,94.80),(1061,'00:10:30',2010,'Legend of a Mountain',91,NULL,3,47,73.30),(1062,'00:08:00',2013,'Ministry of Winds',91,NULL,4,47,54.70),(1063,'00:07:00',2014,'Odilia',91,NULL,4,47,55.40),(1064,'00:14:00',1999,'Banja Luka',92,NULL,2,47,121.70),(1065,'00:09:30',1999,'Music for a Solemnity',92,NULL,3,47,61.50),(1066,'00:12:00',2005,'Prevision',92,NULL,3,47,140.30),(1067,'00:13:15',2009,'Hispaniola',92,NULL,2,47,117.30),(1068,'00:18:00',2013,'Earthquake (1)',92,NULL,1,47,107.40),(1069,'00:14:30',2013,'Liberty',92,NULL,2,47,111.90),(1070,'00:10:15',2013,'Musica Helvetica (2)',92,NULL,3,47,77.30),(1071,'00:11:00',2013,'Flashback',92,NULL,2,47,70.00),(1072,'00:09:00',2014,'A Discovery Fantasy',92,NULL,4,47,64.70),(1073,'00:09:00',NULL,'Aquarium',93,NULL,3,6,136.30),(1074,'00:12:00',2001,'La Quintessenza',93,NULL,2,6,120.50),(1075,'00:11:40',NULL,'Loch Ness',93,NULL,2,6,71.10),(1076,'00:33:00',2001,'The Big Apple',93,NULL,1,6,111.40),(1077,'00:17:00',2005,'The Wind in the Willows',93,NULL,2,6,120.50),(1078,'00:09:30',2008,'Madurodam',93,NULL,3,6,137.40),(1079,'00:09:08',2009,'Klezmers Classics',93,NULL,3,6,86.40),(1080,'00:16:00',2012,'At Kitty O\'Shea\'s',93,NULL,2,6,83.80),(1081,'00:08:00',2013,'Songs from the Catskills',93,NULL,4,6,129.00),(1082,'00:11:00',2015,'Spring (1)',93,NULL,3,6,127.70),(1083,'00:16:20',2015,'Sinfonietta No. 1 (1)',93,NULL,2,6,102.40),(1084,'00:10:45',2015,'Downtown Divertimento',93,NULL,3,6,125.20),(1085,'00:12:04',NULL,'The Universal Judgement, Symphonic Poem',94,484,2,62,62.50),(1086,'00:13:45',NULL,'Do not go gentle into that good night',98,NULL,2,161,89.50),(1087,NULL,NULL,'Jubiloso Overture',98,NULL,2,161,65.30),(1088,NULL,NULL,'Overture for Winds',98,NULL,2,49,52.90),(1089,'00:09:00',2003,'Slavonic Dances',98,NULL,3,43,136.40),(1090,NULL,NULL,'Symphonic Legend',98,NULL,4,15,113.70),(1091,NULL,NULL,'Tryptich II',98,NULL,3,15,86.80),(1092,'00:09:15',NULL,'Amazonian Dances',100,NULL,2,23,71.20),(1093,'00:08:00',2010,'Movenze di festa',101,NULL,3,171,102.50),(1094,'00:12:32',NULL,'Fantasies on a Theme by Haydn',102,NULL,1,111,144.90),(1095,'00:15:00',NULL,'Songs of Abelard',102,NULL,1,111,63.50),(1096,'00:12:15',2009,'Nahr-Al-Alwaan',104,NULL,2,121,148.80),(1097,'00:08:35',2012,'Friends of Freedom',106,NULL,4,16,105.60),(1098,NULL,NULL,'Musik für Blasorchester',108,NULL,2,87,92.50),(1099,'00:09:20',2000,'Horizons',111,NULL,4,144,129.40),(1100,'00:08:00',2011,'Quingenti',111,NULL,4,50,72.60),(1101,'00:11:30',NULL,'Nuances',112,NULL,2,121,139.30),(1102,'00:09:20',2003,'Alpina Saga',113,NULL,3,123,68.30),(1103,'00:20:03',1997,'Atlantis',113,NULL,1,115,92.10),(1104,'00:12:00',2001,'Aurora',113,NULL,2,115,145.70),(1105,'00:08:00',1997,'Genesis',113,NULL,3,115,60.80),(1106,NULL,2005,'Orientales',113,NULL,3,123,122.40),(1107,'00:09:15',1997,'Austrian Overture',113,NULL,2,115,138.50),(1108,'00:18:30',2005,'Sidus',113,NULL,1,123,56.30),(1109,'00:08:08',2007,'Green Hills Fantasy',113,NULL,4,123,107.00),(1110,'00:09:45',2008,'Of Castles and Legends',113,NULL,4,123,148.30),(1111,'00:37:00',2009,'Zeppelin Symphony',113,NULL,1,123,129.40),(1112,'00:11:34',2011,'Messengers of Light',113,NULL,2,123,56.50),(1113,'00:10:30',2013,'Colossus',113,NULL,2,123,64.20),(1114,'00:12:40',2013,'Monastery Tales',113,NULL,3,123,146.60),(1115,'00:13:00',2013,'The Colors of Tali',113,NULL,1,123,121.60),(1116,'00:10:00',2014,'Pathétique',113,NULL,2,123,97.30),(1117,'00:18:00',2005,'Ballet Suite No. 1',115,NULL,2,24,146.60),(1118,NULL,NULL,'Genoveva',116,NULL,3,121,124.80),(1119,'00:06:45',2005,'High Country Celebration',118,NULL,4,12,60.50),(1120,'00:07:30',2007,'As Spirits Take Flight',118,NULL,4,12,56.40),(1121,'00:07:30',2008,'Beyond the Breaking Tides',118,NULL,4,12,135.50),(1122,'00:07:30',2007,'Kanata Spring',119,NULL,4,12,51.90),(1123,'00:14:20',NULL,'Konzert für grosses Blasorchester',120,NULL,1,54,129.90),(1124,'00:10:00',1998,'...from these ashes...',123,NULL,3,96,94.00),(1125,'00:14:30',2000,'Paris Sketches',124,NULL,1,108,65.10),(1126,'00:10:00',2014,'Sagrada Familia',125,NULL,3,54,143.90),(1127,'00:07:30',2006,'Toccata for a New Age',126,NULL,4,5,107.30),(1128,NULL,2011,'Dedikationen',127,NULL,3,54,66.70),(1129,'00:13:30',NULL,'Toissa, episodische Tondichtung',127,NULL,2,182,117.70),(1130,'00:09:30',NULL,'1291, Mythes et réalité',131,NULL,2,50,109.30),(1131,'00:08:35',1999,'El Camino de Santiago',131,NULL,2,112,108.70),(1132,'00:07:30',2005,'The Trip of the Mystery Ship',131,NULL,3,112,77.00),(1133,NULL,2004,'Scottish Dances',132,NULL,4,132,81.60),(1134,'00:07:09',2007,'A Glasgow Overture',132,NULL,4,132,142.30),(1135,'00:06:40',2004,'Festival Overture (1)',132,531,4,132,146.50),(1136,'00:38:00',2005,'La Passio de Crist',134,NULL,1,88,100.30),(1137,'00:18:53',2007,'Luces y Sombras',134,NULL,2,88,112.50),(1138,'00:13:37',2008,'Magallanes',134,NULL,2,88,133.80),(1139,'00:22:47',2009,'El Rugir del Kimbo',134,NULL,1,88,55.80),(1140,'00:19:24',2009,'Ceremonial',134,NULL,1,88,108.00),(1141,'00:16:20',2012,'Salomon',134,NULL,1,88,99.30),(1142,'00:21:40',2013,'Echo de la Montagne',134,NULL,1,88,50.90),(1143,'00:13:30',2015,'Abraham',134,NULL,2,88,57.80),(1144,'00:27:00',2015,'Pinocchio (1)',134,NULL,1,88,71.80),(1145,'00:07:30',2007,'Medusa',135,NULL,3,16,57.50),(1146,NULL,2009,'Royal Canadian Sketches',138,NULL,3,15,102.20),(1147,NULL,NULL,'Concert Suite for Symphonic Band',139,NULL,3,121,112.80),(1148,'00:07:30',NULL,'English Rhapsody for Band',139,NULL,3,121,82.80),(1149,'00:07:30',2011,'The Winds of Taiwan',139,NULL,4,76,130.50),(1150,'00:13:00',2000,'Iocundum',140,NULL,1,23,58.10),(1151,'00:13:22',NULL,'La chasseur maudit, Poème symphonique',141,520,1,187,84.50),(1152,'00:08:20',2005,'Ratafia',142,NULL,4,16,115.90),(1153,'00:12:00',2013,'Winterstorm',143,NULL,1,117,118.80),(1154,'00:10:00',NULL,'Rhapsody for Band',144,NULL,2,121,110.30),(1155,'00:09:30',2000,'Lamentation of Archangel Michael',147,NULL,2,134,107.10),(1156,'00:08:30',2001,'Emotionen',149,NULL,3,153,142.70),(1157,'00:06:45',2001,'Euregio',149,NULL,4,153,54.90),(1158,'00:07:38',NULL,'Schwabenland',149,NULL,4,165,72.60),(1159,'00:06:20',2013,'Freiheit',149,NULL,4,153,107.70),(1160,'00:07:30',2013,'Lichtblicke',149,NULL,4,153,130.80),(1161,'00:08:30',2005,'Carvina',150,NULL,3,67,94.20),(1162,'00:12:30',1996,'Latin Symphonette',150,NULL,2,121,80.80),(1163,'00:07:57',NULL,'Leggenda',150,NULL,3,67,126.80),(1164,'00:10:00',1998,'Significant Moments',150,NULL,2,67,70.20),(1165,'00:11:30',2004,'Symphonette No. 2',150,NULL,1,67,78.30),(1166,'00:13:00',2001,'Variazioni Slave',150,NULL,1,67,97.60),(1167,'00:06:53',2013,'Hindenburg',153,NULL,4,121,78.30),(1168,'00:06:53',2013,'The Mystery of Atlantis',153,NULL,4,121,95.50),(1169,NULL,2014,'Le conto dè Grevire',154,NULL,2,191,74.10),(1170,NULL,2010,'First Suite in F',155,365,2,166,66.60),(1171,'00:16:00',2011,'An American in Paris (2)',156,69,1,123,76.00),(1172,'00:16:00',NULL,'An American in Paris',156,112,1,109,79.20),(1173,'00:16:00',NULL,'An American in Paris (1)',156,524,1,121,127.10),(1174,'00:22:56',NULL,'Symphony N° 3 for Band',157,NULL,1,15,120.70),(1175,'00:07:45',NULL,'Little Swedish Suite',158,NULL,4,121,118.80),(1176,'00:11:31',2005,'Internal Combustion',159,NULL,1,33,83.60),(1177,'00:10:25',2012,'Tulsa',160,NULL,2,120,68.90),(1178,NULL,NULL,'Chorale and Capriccio',161,517,3,52,82.00),(1179,'00:20:00',NULL,'Atmospheres',164,NULL,1,121,146.90),(1180,'00:10:00',2002,'Chansons Bachiques',165,NULL,4,72,135.30),(1181,'00:07:00',2002,'Die Schlacht bei Varlar',165,NULL,5,72,73.80),(1182,'00:12:00',2010,'Excelsior',165,NULL,2,72,147.70),(1183,'00:15:00',2002,'Les Marteaux de la Marine',165,NULL,1,72,59.80),(1184,'00:11:30',2002,'The Robber Knight',165,NULL,4,72,92.20),(1185,'00:09:30',2010,'Colditz Castle',165,NULL,3,72,71.30),(1186,'00:14:30',2010,'La Terre',165,NULL,1,72,130.00),(1187,'00:11:00',2010,'The Pulse of Life',165,NULL,2,72,69.40),(1188,'00:12:00',2013,'Guggisberg Fantasie',165,NULL,1,121,133.50),(1189,'00:13:30',2014,'The Innocent Condemned (1)',165,NULL,2,72,51.20),(1190,'00:18:00',2015,'Variations on a Pentatonic Theme',165,NULL,1,72,144.10),(1191,'00:15:00',2001,'Yiddish Dances',166,NULL,1,108,113.70),(1192,'00:21:58',NULL,'Brillante Symphonie',167,NULL,1,121,146.90),(1193,'00:26:40',NULL,'Concerto pour grand Orchestre d\'harmonie',167,NULL,1,121,74.30),(1194,'00:13:30',NULL,'Poème du Feu',167,NULL,1,121,116.40),(1195,'00:27:15',NULL,'Symphonie de Printemps (alle 4 Sätze)',167,NULL,1,121,94.20),(1196,'00:07:10',2010,'Chicago Festival',168,NULL,4,153,95.80),(1197,'00:07:00',2010,'Adventure!',168,NULL,4,153,91.30),(1198,'00:10:50',2013,'Silva Nigra',168,NULL,3,153,56.50),(1199,'00:08:00',2013,'Irish Castle',168,NULL,4,153,148.10),(1200,'00:12:36',NULL,'Jericho (1)',169,NULL,1,120,132.50),(1201,'00:08:00',2015,'Shine as the Light (1)',171,NULL,2,73,120.90),(1202,'00:14:30',NULL,'Lincolnshire Posy',172,496,1,168,73.10),(1203,'00:15:00',2007,'The Sword and the Crown',174,NULL,1,169,54.00),(1204,'00:17:00',2015,'The Kings go Forth',174,NULL,1,169,66.90),(1205,'00:10:00',2005,'The Morning After',176,NULL,1,117,137.70),(1206,NULL,NULL,'A Scottish Rhapsody',177,NULL,4,19,57.10),(1207,NULL,NULL,'A Welsh Rhapsody',177,NULL,4,19,141.80),(1208,'00:07:00',2000,'American Folk Rhapsody No. 3',177,NULL,4,19,76.20),(1209,NULL,NULL,'An Irish Rhapsody',177,NULL,3,19,128.20),(1210,'00:09:15',NULL,'Hebrides Suite',177,NULL,4,19,74.70),(1211,'00:11:00',NULL,'The Blue and the Gray, Civil War Suite',177,NULL,3,19,56.30),(1212,'00:09:00',2007,'Little English Suite',177,NULL,4,19,77.20),(1213,NULL,NULL,'Burleske (1)',180,NULL,3,54,137.10),(1214,NULL,NULL,'Capriola, Fantasia',180,NULL,3,82,143.50),(1215,NULL,NULL,'Movimenti',180,NULL,2,128,141.20),(1216,NULL,NULL,'Uster-Suite',180,NULL,3,121,55.10),(1217,'00:12:00',NULL,'Choral Flexions',181,NULL,2,47,99.20),(1218,'00:17:45',2013,'Refraction',181,NULL,1,47,92.90),(1219,'00:09:30',2005,'Pacis Valley',182,NULL,4,16,92.00),(1220,'00:23:00',2010,'Chakra',183,NULL,1,171,144.20),(1221,NULL,NULL,'Dies Natalis for Band',185,NULL,2,62,68.10),(1222,'00:15:00',NULL,'Laude, Choral, Variations and Metamorphoses',185,NULL,1,62,75.10),(1223,'00:06:00',2006,'Engelberg Variations',186,NULL,4,5,51.70),(1224,'00:06:40',2009,'Pictogrammes',188,NULL,4,50,67.80),(1225,'00:17:00',NULL,'Mythen, Sinfonie Nr. 1',190,NULL,2,171,145.50),(1226,NULL,NULL,'Suite Fantasque for Band',191,NULL,3,121,57.60),(1227,NULL,2005,'Deep Blue',192,NULL,3,171,148.90),(1228,'00:07:00',2010,'Schwarzsee / Lac Noir',192,NULL,4,191,92.30),(1229,NULL,1998,'A Jubilant Prelude',195,NULL,4,123,108.70),(1230,NULL,NULL,'Merry Theatre Music',195,NULL,3,171,86.80),(1231,'00:08:30',1997,'Rhinestone',195,NULL,3,171,113.50),(1232,NULL,NULL,'Essay for Band',196,NULL,3,161,79.50),(1233,'00:07:20',1999,'Concert Suite op. 57',199,NULL,4,132,88.10),(1234,'00:10:00',2000,'Of Moods and Mysteries',199,NULL,2,132,138.40),(1235,'00:08:00',NULL,'Rhythmicals',199,NULL,2,132,66.90),(1236,'00:08:45',1999,'Taalabaya',199,NULL,2,132,90.10),(1237,'00:09:00',2006,'Pintako',199,NULL,3,86,69.00),(1238,NULL,2009,'Yi Hai',200,NULL,2,81,101.60),(1239,'00:16:00',2015,'Danceries ',201,NULL,2,59,127.10),(1240,'00:15:30',2005,'East Coast Pictures',203,NULL,1,59,139.20),(1241,'00:15:00',2005,'Circus Suite',204,NULL,2,24,60.40),(1242,'00:08:15',2005,'Festive Music',204,NULL,3,96,59.90),(1243,'00:25:10',2005,'Save the Sea',204,NULL,1,24,73.20),(1244,'00:08:14',2001,'Sprightly Tunes',204,NULL,2,24,133.30),(1245,'00:18:00',2005,'The Undanced Ballet',204,NULL,1,24,131.00),(1246,'00:16:52',NULL,'Symphony in B flat for Concert Band',206,NULL,1,168,86.40),(1247,'00:12:00',2012,'Tower of Babel',207,NULL,1,47,130.80),(1248,'00:09:30',2014,'Commitment to Courage',207,NULL,4,47,91.40),(1249,'00:13:00',2010,'Spiritual Planet',209,NULL,1,171,120.40),(1250,'00:11:30',NULL,'Songs of the West, Ouverture',210,83,2,90,95.30),(1251,'00:10:15',NULL,'First Suite in Es',210,NULL,2,19,77.80),(1252,'00:14:00',NULL,'Hammersmith, Prelude and Scherzo',210,NULL,1,19,133.40),(1253,'00:10:30',NULL,'Second Suite in F',210,NULL,2,19,135.90),(1254,'00:13:30',NULL,'A Moorside Suite (1)',210,226,2,19,53.80),(1255,'00:13:30',NULL,'A Moorside Suite (2)',210,465,2,90,112.10),(1256,'00:19:00',NULL,'Bacchus on Blue Ridge',212,NULL,1,121,87.40),(1257,'00:11:40',NULL,'Fête Galante',212,NULL,2,164,75.30),(1258,'00:12:37',NULL,'Dance Suite',212,NULL,1,121,78.70),(1259,'00:08:10',2001,'Persis',213,NULL,2,43,122.80),(1260,NULL,2009,'Call of the Clans',214,NULL,3,157,54.30),(1261,'00:11:20',2013,'Cry of the Falcon',214,NULL,4,157,80.80),(1262,'00:12:20',2014,'Atropos',214,NULL,3,157,60.10),(1263,'00:10:00',2014,'Dogon',214,NULL,4,157,137.60),(1264,'00:10:00',2015,'Arcana',214,NULL,3,157,79.30),(1265,'00:11:30',2015,'Lake of the Moon (1)',214,NULL,2,157,99.10),(1266,'00:07:15',NULL,'Choral, Variationen und Fuge',216,485,5,153,116.80),(1267,'00:09:00',NULL,'The Demon',216,485,2,153,143.70),(1268,NULL,NULL,'Bergruf',216,NULL,2,23,92.40),(1269,'00:10:00',NULL,'Evocazioni',216,NULL,1,121,137.80),(1270,NULL,NULL,'Fantasie in C',216,NULL,3,54,104.20),(1271,'00:14:15',NULL,'Fantasie über eine Appenzeller Volksweise',216,NULL,3,153,124.30),(1272,'00:10:00',NULL,'Invocatio',216,NULL,2,54,99.00),(1273,'00:15:00',NULL,'Vision, symphonische Musik',216,NULL,1,153,143.30),(1274,'00:05:15',NULL,'Acclamations',217,NULL,5,12,141.40),(1275,'00:05:35',2005,'Stone Mountain Fantasy',217,NULL,5,12,94.60),(1276,'00:05:38',2006,'Ascentium',217,NULL,5,12,85.80),(1277,NULL,2008,'Eye of the Falcon',217,NULL,4,12,60.80),(1278,'00:06:29',2011,'Mind Sets',217,NULL,4,12,123.70),(1279,'00:11:30',NULL,'Al Fresco',219,NULL,1,11,64.50),(1280,'00:18:30',2015,'Music for Prague 1968',219,NULL,1,66,93.70),(1281,NULL,NULL,'Plymouth Trilogy',220,NULL,3,106,76.90),(1282,'00:10:00',1996,'A Maritime Overture',221,358,2,164,99.20),(1283,'00:11:45',NULL,'Comedy, Overture (1)',221,402,2,164,52.90),(1284,'00:20:00',1995,'Gloriosa',223,NULL,1,134,134.40),(1285,'00:08:15',NULL,'Celebration Overture',226,NULL,4,19,149.10),(1286,'00:15:30',1996,'Symphony ad 78',226,NULL,2,164,81.40),(1287,'00:15:00',NULL,'Tribute to Canterbury',226,NULL,3,19,97.40),(1288,'00:16:22',NULL,'William Byrd Suite',226,NULL,2,19,113.80),(1289,'00:12:30',2008,'Concerto for Band (1)',226,NULL,2,19,79.70),(1290,'00:10:15',NULL,'Ouverture pour Orchestre Militaire',227,510,3,121,149.10),(1291,NULL,2004,'Im Frühjahr, sinfonische Skizze (2)',228,492,3,47,130.30),(1292,NULL,2005,'Die geheimnisvolle Maske',228,263,2,132,111.80),(1293,'00:15:40',1998,'Ouverture in F \"Ungarn 1956\"',228,228,2,47,109.20),(1294,NULL,2005,'Karnevals Rückzug',228,531,2,132,84.90),(1295,'00:09:05',NULL,'A Cockney Rhapsody',229,NULL,2,39,112.80),(1296,'00:13:39',2005,'Diamond Variations',229,NULL,2,15,69.30),(1297,'00:08:13',NULL,'Third Suite',229,NULL,2,39,103.30),(1298,'00:11:45',2000,'Variations on a Theme of Robert Schumann',229,NULL,2,12,80.40),(1299,'00:10:45',2010,'Two Symphonic Interludes',230,NULL,2,72,146.00),(1300,'00:22:00',2010,'Voyage au Centre de la Terre',230,NULL,1,72,98.50),(1301,'00:08:00',2009,'The Legend of Hermes',231,NULL,2,123,146.30),(1302,'00:07:40',2013,'Dublin Pictures',231,NULL,4,123,75.90),(1303,'00:06:09',2006,'A Festive Celebration',233,NULL,4,5,113.20),(1304,'00:10:40',NULL,'Suite für Blasmusik (1)',234,505,3,148,80.30),(1305,'00:08:00',NULL,'A Circus Suite',236,NULL,4,164,130.60),(1306,'00:06:00',NULL,'Scenes from a Royal Tapestry',236,NULL,5,164,83.00),(1307,NULL,NULL,'Sinfonietta',236,NULL,2,164,149.20),(1308,'00:06:00',NULL,'Wessex Dances',236,NULL,4,164,63.70),(1309,'00:15:27',NULL,'Kammer-Symphonie',238,NULL,2,121,94.40),(1310,'00:38:57',2005,'Symphony No. 1',241,486,1,16,106.50),(1311,'00:07:40',2005,'Budapest Impressions',245,NULL,4,47,51.20),(1312,'00:19:07',2005,'Spartacus Suite',247,511,2,99,101.00),(1313,'00:09:30',2005,'The Valencian Widow',247,519,2,13,91.70),(1314,'00:08:45',2013,'Uorsin (1)',248,NULL,4,117,145.60),(1315,'00:08:00',2001,'La Chapelle des Marches',249,NULL,4,117,105.80),(1316,'00:10:15',2007,'Champion of the Seas',250,NULL,3,97,134.30),(1317,'00:07:30',2012,'Schmelzende Riesen',251,NULL,4,117,98.20),(1318,'00:08:30',2013,'White Field',251,NULL,3,117,57.00),(1319,'00:08:00',2013,'Alm',251,NULL,4,117,55.80),(1320,'00:05:15',2013,'Südkultur',251,NULL,5,117,78.50),(1321,'00:08:40',2013,'Jenseits des Lichts',251,NULL,3,117,67.80),(1322,'00:14:00',2013,'Suite Nostalgique',251,NULL,3,117,64.90),(1323,'00:07:00',2013,'Folksong Reloaded',251,NULL,5,117,61.50),(1324,'00:07:30',2015,'Avia',251,NULL,3,117,121.40),(1325,'00:11:00',2015,'Etosha',251,NULL,3,117,84.80),(1326,'00:11:21',2000,'Symphonic Variations',252,NULL,2,54,54.40),(1327,'00:07:45',NULL,'Japanese Tune',253,NULL,3,121,100.30),(1328,NULL,NULL,'Des Meeres und der Liebe Wellen',255,505,2,124,136.10),(1329,NULL,2004,'Gyges und sein Ring (1)',255,505,2,171,59.20),(1330,NULL,NULL,'Theseus, sinfonische Musik',255,NULL,2,82,120.40),(1331,NULL,NULL,'Das Orakel zu Delphi (1)',255,531,2,47,67.00),(1332,'00:06:30',NULL,'Knightbridge Chronicles',256,NULL,4,12,140.00),(1333,NULL,NULL,'Spartanburg, Ouvertüre',256,NULL,4,96,76.30),(1334,'00:14:30',2001,'Symphony No. 3 \"Slavyanskaya\"',257,480,2,194,88.50),(1335,'00:09:00',2010,'Imagasy',258,NULL,3,153,93.90),(1336,'00:08:00',2013,'Fiskinatura',258,NULL,4,153,130.60),(1337,'00:15:00',2012,'Im Reich der Fabelwesen',260,NULL,2,126,98.70),(1338,'00:08:30',NULL,'Three Fragments for Band',264,NULL,2,157,141.30),(1339,'00:09:00',2005,'In the Forest of the King',265,NULL,4,153,85.70),(1340,'00:12:00',NULL,'Le Roi d\'Ys',266,400,1,121,143.50),(1341,'00:13:10',NULL,'Aunis et Saintonge en Fête',267,NULL,3,121,59.30),(1342,'00:17:40',NULL,'Le Mont Saint Michel',267,NULL,2,121,99.20),(1343,'00:09:30',NULL,'Mini-Symphonie',267,NULL,2,121,149.00),(1344,NULL,NULL,'Petite Sérénade',267,NULL,4,121,118.00),(1345,'00:07:00',NULL,'Rhapsodie sur des thèmes bretons',267,NULL,4,121,90.50),(1346,'00:10:00',NULL,'Rapsodie Symphonique',267,NULL,1,121,126.30),(1347,'00:09:30',NULL,'Scandinavia',267,NULL,3,121,64.20),(1348,'00:16:00',NULL,'Symphonie de Paris',267,NULL,2,121,147.20),(1349,'00:14:45',NULL,'Symphonie Ibérique',267,NULL,2,121,126.60),(1350,'00:09:30',NULL,'Les Papillons',269,93,2,121,116.30),(1351,'00:10:45',NULL,'Ballet Dreams',269,516,2,121,92.50),(1352,'00:09:00',1995,'Prelude and Toccata',272,NULL,2,148,85.20),(1353,'00:09:00',NULL,'Festspiel-Ouvertüre',274,NULL,2,127,86.30),(1354,'00:08:40',2013,'Arctica aeterna',276,506,4,88,67.30),(1355,'00:14:56',NULL,'Les Préludes, sinfonische Dichtung',277,493,1,19,133.00),(1356,'00:07:00',2013,'Alcazar',278,NULL,4,153,136.50),(1357,'00:10:45',NULL,'The Forest of Arden',279,NULL,2,164,118.00),(1358,'00:07:30',2014,'The Legend of Hans Roth (1)',280,NULL,3,132,100.60),(1359,'00:18:00',2010,'Sinfonia Brevis',283,NULL,1,153,94.50),(1360,'00:30:00',2015,'Wine-Dark Sea',285,NULL,1,133,62.00),(1361,'00:10:45',NULL,'An All American Suite for Symphonic Band',286,NULL,4,121,115.60),(1362,'00:06:40',2015,'Viaggio in Umbria',288,NULL,4,23,93.50),(1363,'00:08:20',2012,'Solar Storm',289,NULL,3,55,85.90),(1364,'00:08:00',2009,'Sommerland',291,NULL,2,136,102.30),(1365,'00:19:52',2010,'Les trois notes du Japon',292,NULL,1,30,56.20),(1366,'00:27:00',2010,'Symphony No. 4',293,NULL,1,62,82.00),(1367,'00:16:00',2013,'Give Us This Day',293,NULL,1,62,143.70),(1368,NULL,NULL,'Chant and Jubilo',294,NULL,4,166,120.40),(1369,NULL,2003,'Estampie',294,NULL,4,166,108.80),(1370,'00:07:15',NULL,'Masque',294,NULL,3,166,136.50),(1371,'00:14:20',2000,'Of Sailors and Whales',294,NULL,2,166,144.20),(1372,'00:06:00',2005,'Agua\'s Whelm',295,NULL,4,12,122.80),(1373,'00:16:00',2014,'Fragile Oasis',297,NULL,1,142,85.70),(1374,NULL,2005,'Freiämtersturm',298,NULL,2,171,112.30),(1375,'00:11:00',2005,'Erich!',299,NULL,1,24,124.10),(1376,'00:10:33',2005,'Stormworks',299,NULL,2,24,122.20),(1377,'00:09:45',NULL,'Ouverture für Harmoniemusik',300,533,2,121,143.40),(1378,'00:08:00',NULL,'Windspiele - Ballade des vents',301,NULL,2,153,97.90),(1379,'00:10:00',NULL,'Der silberne Hammer (Le marteau d\'argent)',301,NULL,1,172,88.80),(1380,'00:24:02',2005,'Variazioni Sinfoniche su \"Non potho reposare\"',302,NULL,1,76,130.00),(1381,'00:15:20',1999,'Xenia Sarda',302,NULL,2,91,84.10),(1382,'00:20:00',2010,'Winanga-Li',302,NULL,1,76,132.60),(1383,'00:07:30',2008,'Prelude et Danse (1)',303,NULL,4,191,134.20),(1384,'00:06:30',2010,'Fantaisie Slave / Slavische Fantasie',303,NULL,3,191,113.20),(1385,'00:07:30',2014,'Samain',303,NULL,4,191,64.50),(1386,'00:14:00',2005,'Three Famous Cathedrals',304,NULL,3,178,143.60),(1387,'00:14:00',NULL,'Suite Provençale',305,69,1,47,66.60),(1388,'00:15:00',NULL,'Suite Française',305,NULL,2,101,60.10),(1389,'00:21:00',2013,'Symponic Suite',306,NULL,1,117,90.00),(1390,'00:15:00',2013,'Journey through the Skies',306,NULL,1,117,110.30),(1391,'00:21:00',2013,'Symphonic Suite (2)',306,NULL,1,117,53.10),(1392,'00:10:00',1999,'Bilder aus Asymmetrien',307,485,3,153,70.30),(1393,'00:09:10',2013,'The Quest for Victory',308,NULL,3,72,106.30),(1394,'00:10:30',2010,'Aerial Fantasy',309,NULL,2,134,117.80),(1395,'00:09:24',2003,'Prelude, Sarabande & Finale',312,NULL,2,54,61.40),(1396,NULL,NULL,'Burlesca Grischuna',313,NULL,5,54,137.30),(1397,'00:30:00',1999,'Pictures at an Exhibition',314,499,1,171,111.40),(1398,'00:30:00',2001,'Bilder einer Ausstellung',314,523,1,47,82.50),(1399,NULL,2010,'El Arca de Noé',315,NULL,2,146,121.90),(1400,'00:12:00',2015,'Trips',315,NULL,2,146,59.90),(1401,'00:40:00',2015,'El Olimpo de los Dioses',315,NULL,1,NULL,135.40),(1402,'00:06:50',2005,'The Glacier Express',316,NULL,4,153,73.10),(1403,NULL,2008,'Return of the Crusaders',316,NULL,4,12,134.30),(1404,'00:10:12',NULL,'Trittico for Symphonic Band',317,NULL,1,15,95.00),(1405,'00:12:00',2001,'Courtly Airs and Dances',318,NULL,3,106,107.90),(1406,'00:10:00',1995,'Passacaglia',318,NULL,1,106,118.90),(1407,'00:10:00',2005,'Sonoran Desert Holiday',318,NULL,2,106,128.80),(1408,'00:09:55',2010,'The Giant\'s Mermaid',319,NULL,3,178,50.10),(1409,NULL,NULL,'Colors and Configurations',324,NULL,4,12,69.10),(1410,'00:17:30',2015,'Les âges du Soleil',326,NULL,1,171,74.30),(1411,'00:07:55',2009,'Saphira (1)',328,NULL,4,117,141.50),(1412,NULL,2005,'Capricorn Suite',329,NULL,4,153,126.50),(1413,'00:07:15',2012,'San Gottardo',329,NULL,4,153,137.20),(1414,'00:09:40',2014,'Die schwarzen Brüder',329,NULL,4,153,96.20),(1415,'00:08:30',2015,'Goori - Fantasy',329,NULL,3,153,133.90),(1416,NULL,2015,'Redwood Overture',329,NULL,4,153,94.50),(1417,'00:09:00',NULL,'La belle Hélène, Ouverture',330,513,2,96,119.80),(1418,'00:06:00',2006,'A Yorkshire Fantasy',331,NULL,4,5,146.10),(1419,NULL,NULL,'Scandinavian Fantasy',333,NULL,4,29,124.20),(1420,'00:17:45',NULL,'Nobra',335,NULL,1,121,109.30),(1421,'00:11:00',NULL,'Divertimento (4)',337,NULL,2,51,113.70),(1422,'00:08:45',NULL,'Pageant',337,NULL,3,62,108.40),(1423,'00:09:00',NULL,'Psalm for Band',337,NULL,2,54,130.90),(1424,'00:15:30',NULL,'Symphony for Band (1)',337,NULL,1,54,127.80),(1425,'00:10:30',1999,'Made in Italy',338,NULL,4,184,86.90),(1426,NULL,2005,'al Piemonte',339,483,2,118,87.90),(1427,'00:08:55',2005,'Sid Addir Babai',344,NULL,4,158,148.80),(1428,NULL,2008,'Prochytas',344,NULL,4,158,141.20),(1429,'00:08:00',2012,'Terre del Vino',344,NULL,4,158,50.70),(1430,'00:22:00',2002,'Sinfonietta for Band',345,NULL,1,23,132.10),(1431,'00:16:00',2002,'The Legend of Aquarius',345,NULL,2,23,118.70),(1432,'00:08:00',2013,'Arrows of Lightning',345,NULL,4,47,137.10),(1433,'00:12:40',2014,'Die Judenbuche',345,NULL,3,23,65.50),(1434,'00:15:12',2015,'Derivations',345,NULL,1,23,106.40),(1435,'00:12:30',2005,'The Magic Potion',346,NULL,2,24,132.60),(1436,'00:09:03',NULL,'A little Concert Suite',348,NULL,4,139,87.60),(1437,'00:07:30',NULL,'A Northern Legend',348,NULL,3,22,112.80),(1438,'00:07:45',NULL,'A Springtime Celebration',348,NULL,3,22,81.30),(1439,'00:10:30',NULL,'Armenian Dances (Part 1)',348,NULL,2,65,130.00),(1440,'00:19:30',NULL,'Armenian Dances (Part 2)',348,NULL,1,12,114.30),(1441,'00:09:30',NULL,'El Camino Real',348,NULL,2,85,59.20),(1442,'00:08:45',NULL,'Festive Overture',348,NULL,2,66,146.50),(1443,'00:15:30',1999,'First Suite for Band',348,NULL,2,12,97.80),(1444,'00:18:00',NULL,'Fourth Symphony',348,NULL,1,121,149.00),(1445,'00:07:45',NULL,'Golden Jubilee',348,NULL,3,111,93.70),(1446,'00:12:45',NULL,'Hymn Variants',348,NULL,3,22,132.40),(1447,'00:05:50',2001,'Millenium III',348,NULL,3,22,137.30),(1448,'00:06:30',NULL,'Prelude and Capriccio',348,NULL,3,111,128.90),(1449,'00:08:00',NULL,'Punchinello',348,NULL,2,22,54.30),(1450,'00:12:00',NULL,'Russian Christmas Music',348,NULL,2,65,88.30),(1451,'00:09:15',NULL,'The Hounds of Spring',348,NULL,2,15,124.50),(1452,'00:13:30',2013,'Second Suite for Band',348,NULL,2,85,61.70),(1453,'00:13:45',2015,'Sixth Suite for Band',348,NULL,3,85,84.90),(1454,'00:23:00',NULL,'La Fiesta Mexicana',349,NULL,1,15,108.10),(1455,'00:11:20',NULL,'Ländliche Musik für Blasorchester',350,NULL,4,82,148.00),(1456,'00:11:20',2005,'Die Hexe und die Heilige',351,NULL,3,153,138.60),(1457,'00:08:28',2003,'Fate of the Gods',351,NULL,3,12,76.60),(1458,'00:07:20',2000,'Into the Raging River',351,NULL,3,12,96.10),(1459,'00:10:18',2003,'Pilatus: Mountain of Dragons',351,NULL,3,12,140.60),(1460,'00:04:49',2005,'River of Life',351,NULL,4,12,62.30),(1461,'00:32:00',2007,'Symphony No. 1, New Day Rising',351,NULL,1,12,60.60),(1462,NULL,2008,'Towards a new Horizon',351,NULL,4,12,52.90),(1463,'00:08:30',NULL,'Die Felsenmühle, Ouvertüre',353,497,2,123,133.70),(1464,'00:26:00',2015,'Belkis, Regina di Saba',356,503,1,47,146.30),(1465,'00:10:47',2004,'Bel-Air (1)',357,531,3,132,73.60),(1466,'00:15:58',NULL,'Russische Ostern, Ouverture',361,487,1,121,70.60),(1467,'00:15:40',NULL,'Capriccio español',361,499,1,3,123.80),(1468,'00:15:40',NULL,'Capriccio español (1)',361,530,1,19,61.30),(1469,'00:10:00',2014,'The Essence of Youth',363,NULL,2,47,66.90),(1470,'00:10:07',2014,'Aureus',363,NULL,2,47,137.50),(1471,'00:19:00',2014,'Theseus\' Journey',364,NULL,1,121,58.70),(1472,NULL,NULL,'Ronde et Danse',365,NULL,4,121,126.50),(1473,'00:16:45',2013,'Merlin the Wizard (1)',366,NULL,3,117,56.10),(1474,'00:11:59',NULL,'Wilhelm Tell, Ouverture',367,273,1,19,91.70),(1475,'00:09:00',1999,'Firmament',368,NULL,4,63,97.20),(1476,NULL,NULL,'Chorale and Capriccio (1)',370,NULL,2,49,74.30),(1477,'00:14:30',2006,'Ground',371,NULL,1,54,59.70),(1478,'00:14:00',2008,'Memorial',372,NULL,2,191,144.30),(1479,'00:10:30',2010,'Ajna',372,NULL,2,191,87.00),(1480,'00:09:00',2000,'Omisoka',373,NULL,3,47,146.60),(1481,'00:09:00',NULL,'Children\'s Suite',374,NULL,3,121,60.60),(1482,'00:06:15',2001,'City Impressions',378,NULL,4,153,137.60),(1483,'00:11:15',NULL,'Theme and Variations op. 43a',379,NULL,1,158,115.80),(1484,NULL,2005,'The Mask of the Night',380,NULL,2,117,94.40),(1485,'00:07:30',2015,'Green Granit',380,NULL,4,117,147.50),(1486,'00:09:52',NULL,'Fantasia super l\'Homme Armé',381,NULL,4,47,67.10),(1487,'00:20:00',2004,'Jazz Suite No. 2',382,93,2,163,140.40),(1488,'00:10:30',2005,'Land of Legends',384,NULL,4,72,87.80),(1489,'00:07:45',2008,'Like a Child',384,NULL,4,72,66.90),(1490,'00:12:28',2005,'Nostradamus',385,NULL,3,123,90.40),(1491,'00:10:45',2005,'The Count of Monte Cristo',385,NULL,2,123,119.30),(1492,'00:11:16',2005,'Man in the Ice',385,NULL,2,123,134.90),(1493,'00:12:30',2007,'Mont Blanc',385,NULL,2,123,62.20),(1494,NULL,2009,'Bonaparte',385,NULL,2,123,139.90),(1495,'00:11:00',2009,'Dragon Fight',385,NULL,3,123,123.70),(1496,'00:10:30',2010,'Around the World in 80 Days',385,NULL,3,123,104.00),(1497,'00:10:00',2011,'Terra Vulcania',385,NULL,3,123,109.00),(1498,'00:14:00',2011,'Mantua',385,NULL,2,123,129.80),(1499,'00:09:00',2014,'Nuclear Power',385,NULL,3,123,139.40),(1500,NULL,NULL,'Arabesque',387,NULL,3,22,103.70),(1501,NULL,NULL,'Fanfare & Festival Celebration',387,NULL,4,12,109.90),(1502,NULL,NULL,'Miami Valley Anthology',387,NULL,4,22,116.10),(1503,NULL,NULL,'Pageant of Light',387,NULL,4,12,96.90),(1504,'00:06:15',1999,'The Last To Defend',387,NULL,5,12,54.10),(1505,NULL,NULL,'The Seventh Day',387,NULL,5,12,82.90),(1506,NULL,NULL,'A Bayside Portrait',389,NULL,4,12,136.60),(1507,'00:06:41',NULL,'A Symphonic Narrative',389,NULL,4,12,69.60),(1508,'00:06:30',1999,'Appalachian Legacy',389,NULL,4,12,96.80),(1509,'00:07:30',1999,'Century Point',389,NULL,3,12,117.80),(1510,'00:06:00',NULL,'Corsairs Landing',389,NULL,4,12,131.60),(1511,'00:07:36',NULL,'Danse Celestiale',389,NULL,3,12,119.20),(1512,'00:05:05',NULL,'Fall River Overture',389,NULL,4,12,88.20),(1513,'00:07:00',NULL,'Images',389,NULL,4,12,129.20),(1514,'00:07:00',NULL,'Lost Colony',389,NULL,3,12,139.60),(1515,'00:07:15',NULL,'Ocean Ridge Rhapsody',389,NULL,4,12,117.00),(1516,NULL,NULL,'Southwest Saga',389,NULL,4,22,122.30),(1517,'00:06:15',NULL,'West Highlands Sojourn',389,NULL,4,22,64.10),(1518,'00:07:40',2006,'Welsh Ayres and Dances',389,NULL,4,5,103.70),(1519,'00:05:55',2006,'A Longford Legend',389,NULL,4,5,139.20),(1520,'00:08:35',2006,'Moravian Folk Rhapsody',389,NULL,3,5,109.60),(1521,NULL,2010,'The Spirit of St.Louis',390,NULL,3,156,104.20),(1522,NULL,NULL,'Quo vadis',391,NULL,2,162,86.10),(1523,'00:11:45',1995,'Symphony No. 1 for Band',394,NULL,2,90,129.00),(1524,'00:10:17',NULL,'Festival Variations',394,NULL,1,194,59.40),(1525,NULL,NULL,'Jubilo, A Concert Overture',394,NULL,3,194,127.70),(1526,'00:07:30',NULL,'Overture on an Early American Folk Hymn',394,NULL,3,194,65.50),(1527,'00:06:00',2007,'Panther Fire',395,NULL,4,166,62.10),(1528,'00:23:00',2012,'Symphony No. 3 \"Don Quixote\"',396,NULL,2,22,137.50),(1529,'00:05:45',2006,'Aqva',397,NULL,4,158,100.50),(1530,'00:06:15',2005,'A Huntingdon Celebration',398,NULL,4,8,75.40),(1531,NULL,2005,'Four Norfolk Dances',398,NULL,3,8,107.60),(1532,'00:08:30',2000,'Hanover Festival',398,NULL,2,8,127.80),(1533,NULL,2005,'Invictus',398,NULL,2,8,135.60),(1534,'00:10:00',2000,'Music for Arosa',398,NULL,2,169,122.00),(1535,'00:09:19',2005,'Postcard from Singapore',398,NULL,4,8,116.80),(1536,'00:10:01',2005,'Shalom!',398,NULL,4,8,93.60),(1537,'00:10:30',2001,'Sinfonietta No 3',398,NULL,2,8,67.60),(1538,'00:11:00',NULL,'Theatre Music',398,NULL,2,169,148.50),(1539,'00:08:45',2002,'To a New Dawn',398,NULL,3,8,133.80),(1540,'00:31:20',2007,'Earth, Water, Sun, Wind',398,NULL,1,8,112.40),(1541,'00:14:30',2013,'Three Extraordinary Journeys',398,NULL,3,8,115.00),(1542,NULL,2007,'Songs of the East Coast Fishermen',398,NULL,3,8,90.90),(1543,NULL,2007,'The Camelot Chronicles',398,NULL,3,8,50.30),(1544,NULL,2007,'Valerius Variations',398,NULL,3,8,128.20),(1545,'00:14:40',2009,'The four noble Truths (1)',398,NULL,3,8,126.50),(1546,NULL,2009,'Portrait of a City',398,NULL,2,47,99.60),(1547,'00:19:28',2009,'Dance Movements',398,NULL,1,169,76.70),(1548,NULL,2009,'Hymn of the Highlands (1)',398,NULL,2,8,137.30),(1549,NULL,2009,'The Saga of Haakon the Good (1)',398,NULL,2,8,85.20),(1550,'00:07:00',2011,'Towards the Western Horizon',398,NULL,4,8,57.20),(1551,'00:05:37',2012,'The Pioneers (1)',398,NULL,4,8,89.30),(1552,'00:18:35',2013,'Sinfonietta No. 4',398,NULL,2,8,148.70),(1553,'00:18:30',2014,'Sinfonietta No 2',398,NULL,2,169,61.80),(1554,'00:08:40',NULL,'Three Symphonic Sketches',400,NULL,2,121,98.20),(1555,'00:08:15',NULL,'Adagio e Presto con Fuoco',401,NULL,2,153,55.30),(1556,'00:08:20',2001,'Czech Folk Dance Suite',401,NULL,3,153,67.50),(1557,'00:11:30',NULL,'Die grosse Seefahrt',401,NULL,2,153,128.90),(1558,'00:12:30',2010,'Songs from the East End',401,NULL,3,153,119.20),(1559,NULL,NULL,'A Cambridge Tryptich, Suite',402,NULL,2,164,77.50),(1560,'00:30:00',2015,'El Jardines de las Hesperides',406,NULL,1,NULL,68.00),(1561,'00:04:00',NULL,'Ashton Overture',408,NULL,5,12,52.70),(1562,'00:06:30',NULL,'Blue Ridge Saga',408,NULL,5,12,74.10),(1563,'00:06:00',1999,'Centuria',408,NULL,5,12,104.90),(1564,'00:04:31',NULL,'Denbridge Way',408,NULL,4,12,65.80),(1565,'00:06:00',NULL,'In All its Glory',408,NULL,4,12,63.00),(1566,'00:05:30',2005,'In Times of Triumph',408,NULL,4,12,90.40),(1567,'00:06:14',2003,'Into the Joy of Spring',408,NULL,3,12,143.70),(1568,'00:06:15',NULL,'Invicta, Overture for Band',408,NULL,4,12,149.40),(1569,'00:06:15',NULL,'Majestia',408,NULL,4,12,107.20),(1570,'00:06:25',2005,'Make a Joyful Noise',408,NULL,4,12,106.50),(1571,'00:07:15',NULL,'Seagate Overture',408,NULL,3,12,125.90),(1572,'00:07:30',NULL,'The Light Eternal',408,NULL,4,12,149.30),(1573,'00:03:40',NULL,'Triumphant Spirit',408,NULL,5,22,140.40),(1574,'00:07:12',2008,'Where the River flows',408,NULL,4,22,135.50),(1575,'00:06:00',2011,'A Scottish Portrait',408,NULL,5,12,80.90),(1576,'00:05:20',2013,'In the Winter of 1730',408,NULL,5,22,107.60),(1577,'00:05:40',2013,'Eiger',408,NULL,5,12,109.30),(1578,'00:10:15',2013,'The Legend of Amaterasu',409,NULL,2,121,106.60),(1579,'00:08:30',2005,'Suite on Celtic Folk Songs',410,NULL,3,30,54.60),(1580,'00:16:00',NULL,'Suite-Divertimento',411,112,1,121,94.40),(1581,'00:08:00',2005,'Sahara',412,NULL,3,54,112.40),(1582,'00:15:15',2005,'The Mysteries Of Egypt',412,NULL,3,54,85.70),(1583,'00:08:00',2015,'Magellan\'s Voyage to Unknown Continent',413,NULL,3,NULL,137.20),(1584,NULL,NULL,'Canyon Passage, Overture',414,NULL,5,15,105.60),(1585,'00:10:00',2005,'Blue Shades',415,NULL,2,109,75.30),(1586,'00:10:28',2004,'Cajun Folk Songs II',415,NULL,3,109,145.10),(1587,'00:09:45',2000,'Vesuvius',415,NULL,2,109,124.10),(1588,'00:15:00',2014,'Angels in the Architecture',415,NULL,2,109,140.70),(1589,'00:12:35',2005,'Introduction, Theme and Variations on a popular Song',416,NULL,2,178,74.20),(1590,NULL,2005,'Waar in het Bronzgroen Eikenhout',416,NULL,2,178,86.80),(1591,'00:12:37',2005,'Der Berg',418,NULL,3,171,96.00),(1592,'00:06:45',2001,'Petit mouvement symphonique',418,NULL,5,195,97.70),(1593,NULL,2010,'Magic Child',418,NULL,3,171,102.20),(1594,'00:16:00',2011,'A Heroic Symphony',418,NULL,2,171,113.70),(1595,'00:31:00',2014,'Symphony No. 2',418,NULL,1,171,87.90),(1596,'00:45:00',2015,'Symphony No. 4 (1)',418,NULL,1,171,101.20),(1597,'00:07:35',2014,'An Irish Folk Song Suite',419,500,5,132,132.40),(1598,'00:05:50',2014,'A Northumbrian Folk Song Suite',419,500,5,132,144.20),(1599,'00:15:01',NULL,'Capriccio Italien',421,530,1,19,97.60),(1600,NULL,NULL,'Credo',422,NULL,2,19,116.10),(1601,'00:11:45',1996,'Saga of the Clouds',422,NULL,1,166,57.50),(1602,'00:11:29',NULL,'Sketches on a Tudor Psalm',422,NULL,1,19,130.70),(1603,'00:12:45',2005,'Empedocles Suite',424,NULL,2,16,76.20),(1604,'00:06:00',1997,'NEMU-SUSATO',425,NULL,4,47,63.90),(1605,'00:10:51',NULL,'Olympica',425,NULL,1,47,96.90),(1606,'00:18:30',2000,'Poème Montagnard',425,NULL,1,47,63.10),(1607,'00:12:30',1999,'Puszta',425,NULL,3,47,149.30),(1608,'00:13:45',NULL,'Spartacus, Symphonic Tone Poem',425,NULL,1,47,147.60),(1609,'00:08:00',2000,'Spirit of Independence',425,NULL,2,47,110.00),(1610,'00:08:00',2007,'Dublin Dances',425,NULL,4,47,106.20),(1611,'00:25:00',2009,'Sinfonietta (2)',425,NULL,1,47,78.30),(1612,'00:11:00',2013,'Tirol Terra Fortis',425,NULL,2,47,119.40),(1613,'00:09:00',NULL,'Four Characters',427,NULL,3,121,133.30),(1614,'00:06:45',NULL,'Music makes Friends',427,NULL,5,121,138.90),(1615,'00:12:00',NULL,'Nederlandse Suite',427,NULL,4,121,119.30),(1616,'00:08:00',NULL,'Overture for Fun',427,NULL,3,121,149.40),(1617,'00:07:45',NULL,'Rhapsody from Scotland',427,NULL,4,121,57.80),(1618,'00:06:00',NULL,'Rhapsody from the Low Countries',427,NULL,4,121,84.80),(1619,'00:11:30',NULL,'Rhapsody Gelre',427,NULL,3,121,125.20),(1620,'00:07:30',2005,'Suite de Salon',427,NULL,5,121,93.30),(1621,'00:09:15',NULL,'Suite on Greek Love Songs',427,NULL,3,121,107.40),(1622,'00:06:30',NULL,'United Youth',427,NULL,4,121,118.50),(1623,NULL,NULL,'Vastenavondmuziek',427,NULL,4,121,117.50),(1624,'00:08:28',2014,'Arcen Variations (1)',428,NULL,4,23,95.50),(1625,'00:12:15',2001,'Magic Oliver',430,NULL,2,132,135.60),(1626,'00:11:51',2011,'Variations for Brass Band (1)',431,501,2,NULL,131.90),(1627,'00:10:30',NULL,'Folk-Song-Suite',431,NULL,3,19,101.20),(1628,NULL,NULL,'Fokostanz (Beiltanz)',432,NULL,2,14,76.00),(1629,'00:06:30',2013,'Voyage with the VOC',433,NULL,4,72,112.00),(1630,NULL,NULL,'Die vier Temperamente',434,NULL,4,41,112.40),(1631,NULL,2009,'French Rhapsody',434,NULL,4,81,134.60),(1632,NULL,2009,'Burleske (2)',434,NULL,4,183,130.30),(1633,'00:11:02',NULL,'James Cook, Circumnavigator (1)',435,NULL,2,169,124.80),(1634,NULL,NULL,'New Lamps for Old, Suite',435,NULL,2,19,94.10),(1635,'00:07:30',2001,'Israel Shalom',436,NULL,4,153,88.60),(1636,'00:09:20',2001,'Kilkenny Rhapsody',436,NULL,4,153,121.50),(1637,'00:07:00',NULL,'Les Vignobles, Suite',436,NULL,5,121,85.50),(1638,'00:07:00',NULL,'Liberation',436,NULL,4,121,138.70),(1639,'00:08:20',2005,'Mount Everest',436,NULL,4,153,57.90),(1640,'00:06:45',2000,'Telemark Fantasy',436,NULL,5,121,125.00),(1641,'00:09:15',NULL,'The new Village',436,NULL,4,153,93.80),(1642,'00:08:30',2010,'La Cittadella',436,NULL,5,47,107.30),(1643,'00:05:30',2013,'Slovakian Dances',436,NULL,5,121,76.60),(1644,'00:08:30',2014,'Village on the River',437,NULL,3,23,79.50),(1645,NULL,1996,'Prélude Symphonique',438,NULL,2,195,63.20),(1646,'00:10:15',2000,'Poet and Peasant',439,523,2,47,62.30),(1647,'00:06:48',2013,'Toward the Brigth Future',441,NULL,4,16,120.90),(1648,'00:17:00',2005,'2nd Sinfonietta',442,NULL,2,16,77.90),(1649,'00:08:30',2001,'Hebridean Rhapsody',442,NULL,3,153,64.10),(1650,'00:16:00',2001,'Skies',442,NULL,1,121,99.50),(1651,'00:16:54',2005,'Symphonic Variations (1)',442,NULL,1,171,59.90),(1652,NULL,2007,'Legenda rumantscha (1)',442,NULL,3,104,141.10),(1653,'00:10:43',2008,'Berglicht',442,NULL,1,16,72.40),(1654,'00:09:01',2009,'Caledonia',442,NULL,3,16,73.10),(1655,'00:16:00',2011,'Divertimento (6)',442,NULL,1,16,110.10),(1656,'00:40:00',2015,'Out of Earth',442,NULL,1,158,74.20),(1657,'00:10:18',NULL,'Der fliegende Holländer, Ouverture (1)',444,498,1,38,76.20),(1658,'00:10:18',NULL,'Der fliegende Holländer, Ouverture',444,499,1,3,108.30),(1659,'00:10:45',NULL,'Rienzi, Ouverture (1)',444,499,1,3,135.00),(1660,'00:13:20',2001,'Tannhäuser Ouverture',444,499,1,171,131.20),(1661,'00:10:45',NULL,'Rienzi, Ouverture',444,512,1,135,120.40),(1662,'00:11:20',2005,'Historias españolas',445,NULL,1,176,101.80),(1663,'00:08:00',2005,'Slovanska Pohadka',445,NULL,2,176,113.00),(1664,'00:12:30',NULL,'Alternances',446,NULL,2,123,100.00),(1665,'00:13:45',1999,'Diagram',446,NULL,2,157,105.20),(1666,'00:09:00',NULL,'Golden River',446,NULL,5,123,147.20),(1667,'00:08:48',NULL,'North Sea Overture',446,NULL,2,7,139.70),(1668,'00:06:31',2005,'Ouverture Festive',446,NULL,5,157,102.80),(1669,'00:07:15',NULL,'Petite Suite Européenne',446,NULL,5,123,120.00),(1670,NULL,NULL,'Proclamation for Winds',446,NULL,4,178,140.60),(1671,'00:10:00',1997,'Reminiscencia Gitana',446,NULL,2,157,133.20),(1672,'00:08:10',2005,'Three Folk Characters',446,NULL,4,178,111.50),(1673,NULL,2007,'A Medieval Suite',446,NULL,5,157,136.90),(1674,'00:07:30',2013,'Song and Dance',446,NULL,5,157,148.10),(1675,'00:06:40',2014,'Concertino für Blasorchester',447,NULL,4,37,60.90),(1676,NULL,NULL,'Three Scenes',448,NULL,5,151,125.40),(1677,NULL,NULL,'Prairie Overture',449,NULL,2,68,93.50),(1678,'00:14:30',2015,'The Phantom of the Opera',450,93,4,121,57.30),(1679,NULL,NULL,'Antietam, Symphonic Overture',452,NULL,2,106,138.00),(1680,NULL,NULL,'Czech Suite',452,NULL,4,106,149.10),(1681,NULL,NULL,'Wycliffe Variations for Symphonic Band',452,NULL,2,106,100.00),(1682,'00:09:00',2004,'O Homem Armado',453,529,3,37,126.90),(1683,NULL,NULL,'Big Sky Country, Suite',454,NULL,2,78,87.60),(1684,'00:17:30',2014,'Paganini Variations (1)',455,507,1,169,117.30),(1685,'00:13:30',NULL,'Symphonic Suite',456,NULL,2,170,65.70),(1686,NULL,NULL,'Variation Overture',456,NULL,4,106,118.00),(1687,'00:06:30',2013,'Austrian Mountains Fantasy',458,NULL,4,112,141.70),(1688,'00:08:30',2013,'Austrian Dances',458,NULL,3,112,67.10),(1689,'00:13:30',2005,'The Legend of Flathead Lake',459,NULL,2,72,78.90),(1690,'00:10:30',2005,'Tignale',459,NULL,3,72,50.00),(1691,'00:08:45',2015,'Aarwangen (Crossroads)',459,NULL,4,72,80.40),(1692,'00:09:19',2014,'The Bells of Big Ben',460,NULL,3,178,72.30),(1693,'00:13:00',1997,'Gallimaufry',464,NULL,2,10,83.90),(1694,'00:10:00',1996,'Illyrian Dances',464,NULL,2,10,70.20),(1695,'00:05:45',2013,'Hills Sweeping down to the Sea',468,NULL,5,178,103.40),(1696,'00:10:30',2012,'Machu Picchu - City in the Sky',469,NULL,2,30,87.30),(1697,'00:09:30',2013,'Moses and Ramses',469,NULL,3,47,123.60),(1698,'00:19:00',2015,'Zenith of the Maya',469,NULL,2,30,108.80),(1699,NULL,2008,'Legend of the ancient Hero',470,NULL,4,12,57.30),(1700,'00:08:08',2013,'Flight (2)',470,NULL,3,16,145.10),(1701,'00:08:30',2013,'A Galactic Suite',473,NULL,5,153,92.70),(1702,NULL,NULL,'Memories',474,NULL,2,153,98.60),(1703,NULL,NULL,'Tanzimpressionen',474,NULL,2,171,145.10);
/*!40000 ALTER TABLE `t_piece` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tr_piece_formation`
--

DROP TABLE IF EXISTS `tr_piece_formation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tr_piece_formation` (
  `FK_Piece` int(11) NOT NULL,
  `FK_Formation` int(11) NOT NULL,
  PRIMARY KEY (`FK_Piece`,`FK_Formation`),
  KEY `fk_T_Piece_has_T_Formation_T_Formation1_idx` (`FK_Formation`),
  KEY `fk_T_Piece_has_T_Formation_T_Piece1_idx` (`FK_Piece`),
  CONSTRAINT `fk_T_Piece_has_T_Formation_T_Formation1` FOREIGN KEY (`FK_Formation`) REFERENCES `t_formation` (`PK_Formation`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_T_Piece_has_T_Formation_T_Piece1` FOREIGN KEY (`FK_Piece`) REFERENCES `t_piece` (`PK_Piece`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tr_piece_formation`
--

LOCK TABLES `tr_piece_formation` WRITE;
/*!40000 ALTER TABLE `tr_piece_formation` DISABLE KEYS */;
INSERT INTO `tr_piece_formation` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(177,1),(178,1),(179,1),(180,1),(181,1),(182,1),(183,1),(184,1),(185,1),(186,1),(187,1),(188,1),(189,1),(190,1),(191,1),(192,1),(193,1),(194,1),(195,1),(196,1),(197,1),(198,1),(199,1),(200,1),(201,1),(202,1),(203,1),(204,1),(205,1),(206,1),(207,1),(208,1),(209,1),(210,1),(211,1),(212,1),(213,1),(214,1),(215,1),(216,1),(217,1),(218,1),(219,1),(220,1),(221,1),(222,1),(223,1),(224,1),(225,1),(226,1),(227,1),(228,1),(229,1),(230,1),(231,1),(232,1),(233,1),(234,1),(235,1),(236,1),(237,1),(238,1),(239,1),(240,1),(241,1),(242,1),(243,1),(244,1),(245,1),(246,1),(247,1),(248,1),(249,1),(250,1),(251,1),(252,1),(253,1),(254,1),(255,1),(256,1),(257,1),(258,1),(259,1),(260,1),(261,1),(262,1),(263,1),(264,1),(265,1),(266,1),(267,1),(268,1),(269,1),(270,1),(271,1),(272,1),(273,1),(274,1),(275,1),(276,1),(277,1),(278,1),(279,1),(280,1),(281,1),(282,1),(283,1),(284,1),(285,1),(286,1),(287,1),(288,1),(289,1),(290,1),(291,1),(292,1),(293,1),(294,1),(295,1),(296,1),(297,1),(298,1),(299,1),(300,1),(301,1),(302,1),(303,1),(304,1),(305,1),(306,1),(307,1),(308,1),(309,1),(310,1),(311,1),(312,1),(313,1),(314,1),(315,1),(316,1),(317,1),(318,1),(319,1),(320,1),(321,1),(322,1),(323,1),(324,1),(325,1),(326,1),(327,1),(328,1),(329,1),(330,1),(331,1),(332,1),(333,1),(334,1),(335,1),(336,1),(337,1),(338,1),(339,1),(340,1),(341,1),(342,1),(343,1),(344,1),(345,1),(346,1),(347,1),(348,1),(349,1),(350,1),(351,1),(352,1),(353,1),(354,1),(355,1),(356,1),(357,1),(358,1),(359,1),(360,1),(361,1),(362,1),(363,1),(364,1),(365,1),(366,1),(367,1),(368,1),(369,1),(370,1),(371,1),(372,1),(373,1),(374,1),(375,1),(376,1),(377,1),(378,1),(379,1),(380,1),(381,1),(382,1),(383,1),(384,1),(385,1),(386,1),(387,1),(388,1),(389,1),(390,1),(391,1),(392,1),(393,1),(394,1),(395,1),(396,1),(397,1),(398,1),(399,1),(400,1),(401,1),(402,1),(403,1),(404,1),(405,1),(406,1),(407,1),(408,1),(409,1),(410,1),(411,1),(412,1),(413,1),(414,1),(415,1),(416,1),(417,1),(418,1),(419,1),(420,1),(421,1),(422,1),(423,1),(424,1),(425,1),(426,1),(427,1),(428,1),(429,1),(430,1),(431,1),(432,1),(433,1),(434,1),(435,1),(436,1),(437,1),(438,1),(439,1),(440,1),(441,1),(442,1),(443,1),(444,1),(445,1),(446,1),(447,1),(448,1),(449,1),(450,1),(451,1),(452,1),(453,1),(454,1),(455,1),(456,1),(457,1),(458,1),(459,1),(460,1),(461,1),(462,1),(463,1),(464,1),(465,1),(466,1),(467,1),(468,1),(469,1),(470,1),(471,1),(472,1),(473,1),(474,1),(475,1),(476,1),(477,1),(478,1),(479,1),(480,1),(481,1),(482,1),(483,1),(484,1),(485,1),(486,1),(487,1),(488,1),(489,1),(490,1),(491,1),(492,1),(493,1),(494,1),(495,1),(496,1),(497,1),(498,1),(499,1),(500,1),(501,1),(502,1),(503,1),(504,1),(505,1),(506,1),(507,1),(508,1),(509,1),(510,1),(511,1),(512,1),(513,1),(514,1),(515,1),(516,1),(517,1),(518,1),(519,1),(520,1),(521,1),(522,1),(523,1),(524,1),(525,1),(526,1),(527,1),(528,1),(529,1),(530,1),(531,1),(532,1),(533,1),(534,1),(535,1),(536,1),(537,1),(538,1),(539,1),(540,1),(541,1),(542,1),(543,1),(544,1),(545,1),(546,1),(547,1),(548,1),(549,1),(550,1),(551,1),(552,1),(553,1),(554,1),(555,1),(556,1),(557,1),(558,1),(559,1),(560,1),(561,1),(562,1),(563,1),(564,1),(565,1),(566,1),(567,1),(568,1),(569,1),(570,1),(571,1),(572,1),(573,1),(574,1),(575,1),(576,1),(577,1),(578,1),(579,1),(580,1),(581,1),(582,1),(583,1),(584,1),(585,1),(586,1),(587,1),(588,1),(589,1),(590,1),(591,1),(592,1),(593,1),(594,1),(595,1),(596,1),(597,1),(598,1),(599,1),(600,1),(601,1),(602,1),(603,1),(604,1),(605,1),(606,1),(607,1),(608,1),(609,1),(610,1),(611,1),(612,1),(613,1),(614,1),(615,1),(616,1),(617,1),(618,1),(619,1),(620,1),(621,1),(622,1),(623,1),(624,1),(625,1),(626,1),(627,1),(628,1),(629,1),(630,1),(631,1),(632,1),(633,1),(634,1),(635,1),(636,1),(637,1),(638,1),(639,1),(640,1),(641,1),(642,1),(643,1),(644,1),(645,1),(646,1),(647,1),(648,1),(649,1),(650,1),(651,1),(652,1),(653,1),(654,1),(655,1),(656,1),(657,1),(658,1),(659,1),(660,1),(661,1),(662,1),(663,1),(664,1),(665,1),(666,1),(667,1),(668,1),(669,1),(670,1),(671,1),(672,1),(673,1),(674,1),(675,1),(676,1),(677,1),(678,1),(679,1),(680,1),(681,1),(682,1),(683,1),(684,1),(685,1),(686,1),(687,1),(688,1),(689,1),(690,1),(691,1),(692,1),(693,1),(694,1),(695,1),(696,1),(697,1),(698,1),(699,1),(700,1),(701,1),(702,1),(703,1),(704,1),(705,1),(706,1),(707,1),(708,1),(709,1),(710,1),(711,1),(712,1),(713,1),(714,1),(715,1),(716,1),(717,1),(718,1),(719,1),(720,1),(721,1),(722,1),(723,1),(724,1),(725,1),(726,1),(727,1),(728,1),(729,1),(730,1),(731,1),(732,1),(733,1),(734,1),(735,1),(736,1),(737,1),(738,1),(739,1),(740,1),(741,1),(742,1),(743,1),(744,1),(745,1),(746,1),(747,1),(748,1),(749,1),(750,1),(751,1),(752,1),(753,1),(754,1),(755,1),(756,1),(757,1),(758,1),(759,1),(760,1),(761,1),(762,1),(763,1),(764,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(19,2),(20,2),(21,2),(22,2),(23,2),(24,2),(25,2),(26,2),(27,2),(28,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(35,2),(36,2),(37,2),(38,2),(39,2),(40,2),(41,2),(42,2),(43,2),(44,2),(45,2),(46,2),(47,2),(48,2),(49,2),(50,2),(53,2),(54,2),(55,2),(56,2),(57,2),(58,2),(59,2),(60,2),(61,2),(62,2),(63,2),(64,2),(65,2),(66,2),(67,2),(68,2),(69,2),(70,2),(71,2),(72,2),(73,2),(74,2),(75,2),(76,2),(77,2),(78,2),(79,2),(80,2),(81,2),(82,2),(83,2),(84,2),(85,2),(86,2),(87,2),(88,2),(89,2),(90,2),(91,2),(92,2),(93,2),(94,2),(95,2),(96,2),(97,2),(98,2),(99,2),(100,2),(101,2),(102,2),(103,2),(104,2),(105,2),(106,2),(107,2),(108,2),(109,2),(110,2),(111,2),(112,2),(113,2),(114,2),(115,2),(116,2),(117,2),(118,2),(119,2),(120,2),(121,2),(122,2),(123,2),(124,2),(125,2),(126,2),(127,2),(128,2),(129,2),(130,2),(131,2),(132,2),(133,2),(134,2),(135,2),(136,2),(137,2),(138,2),(139,2),(140,2),(141,2),(142,2),(143,2),(144,2),(145,2),(146,2),(147,2),(148,2),(149,2),(150,2),(151,2),(152,2),(153,2),(154,2),(155,2),(156,2),(157,2),(158,2),(159,2),(160,2),(161,2),(162,2),(163,2),(164,2),(165,2),(166,2),(167,2),(168,2),(169,2),(170,2),(171,2),(172,2),(173,2),(174,2),(175,2),(176,2),(685,2),(686,2),(687,2),(688,2),(689,2),(690,2),(691,2),(692,2),(693,2),(694,2),(695,2),(696,2),(697,2),(698,2),(699,2),(700,2),(701,2),(702,2),(703,2),(704,2),(705,2),(706,2),(707,2),(708,2),(709,2),(710,2),(711,2),(712,2),(713,2),(714,2),(715,2),(716,2),(717,2),(718,2),(719,2),(720,2),(721,2),(722,2),(723,2),(724,2),(725,2),(726,2),(727,2),(728,2),(729,2),(730,2),(731,2),(732,2),(733,2),(734,2),(735,2),(736,2),(737,2),(738,2),(739,2),(740,2),(741,2),(742,2),(743,2),(744,2),(745,2),(746,2),(747,2),(748,2),(749,2),(750,2),(751,2),(752,2),(753,2),(754,2),(755,2),(756,2),(757,2),(758,2),(759,2),(760,2),(761,2),(762,2),(763,2),(764,2),(796,2),(797,2),(798,2),(799,2),(800,2),(801,2),(802,2),(803,2),(804,2),(805,2),(806,2),(807,2),(808,2),(809,2),(810,2),(811,2),(812,2),(813,2),(814,2),(815,2),(816,2),(817,2),(818,2),(819,2),(820,2),(821,2),(822,2),(823,2),(824,2),(825,2),(826,2),(827,2),(828,2),(829,2),(830,2),(831,2),(832,2),(833,2),(834,2),(835,2),(836,2),(837,2),(838,2),(839,2),(840,2),(841,2),(842,2),(843,2),(844,2),(845,2),(846,2),(847,2),(848,2),(849,2),(850,2),(851,2),(852,2),(853,2),(854,2),(855,2),(856,2),(857,2),(858,2),(859,2),(860,2),(861,2),(862,2),(863,2),(864,2),(865,2),(866,2),(867,2),(868,2),(869,2),(870,2),(871,2),(872,2),(873,2),(874,2),(875,2),(876,2),(877,2),(878,2),(879,2),(880,2),(881,2),(882,2),(883,2),(884,2),(885,2),(886,2),(887,2),(888,2),(889,2),(890,2),(891,2),(892,2),(893,2),(894,2),(895,2),(896,2),(897,2),(898,2),(899,2),(900,2),(901,2),(902,2),(903,2),(904,2),(905,2),(906,2),(907,2),(908,2),(909,2),(910,2),(911,2),(912,2),(913,2),(914,2),(915,2),(916,2),(917,2),(918,2),(919,2),(920,2),(921,2),(922,2),(923,2),(924,2),(925,2),(926,2),(927,2),(928,2),(929,2),(930,2),(931,2),(932,2),(933,2),(934,2),(935,2),(936,2),(937,2),(938,2),(939,2),(940,2),(941,2),(942,2),(943,2),(944,2),(945,2),(946,2),(947,2),(948,2),(949,2),(950,2),(951,2),(952,2),(953,2),(954,2),(955,2),(956,2),(957,2),(958,2),(959,2),(960,2),(961,2),(962,2),(963,2),(964,2),(965,2),(966,2),(967,2),(968,2),(969,2),(970,2),(971,2),(972,2),(973,2),(974,2),(975,2),(976,2),(977,2),(978,2),(979,2),(980,2),(981,2),(982,2),(983,2),(984,2),(985,2),(986,2),(987,2),(988,2),(989,2),(990,2),(991,2),(992,2),(993,2),(994,2),(995,2),(996,2),(997,2),(998,2),(999,2),(1000,2),(1001,2),(1002,2),(1003,2),(1004,2),(1005,2),(1006,2),(1007,2),(1008,2),(1009,2),(1010,2),(1011,2),(1012,2),(1013,2),(1014,2),(1015,2),(1016,2),(1017,2),(1018,2),(1019,2),(1020,2),(1021,2),(1022,2),(1023,2),(1024,2),(1025,2),(1026,2),(1027,2),(1028,2),(1029,2),(1030,2),(1031,2),(1032,2),(1033,2),(1034,2),(1035,2),(1036,2),(1037,2),(1038,2),(1039,2),(1040,2),(1041,2),(1042,2),(1043,2),(1044,2),(1045,2),(1046,2),(1047,2),(1048,2),(1049,2),(1050,2),(1051,2),(1052,2),(1053,2),(1054,2),(1055,2),(1056,2),(1057,2),(1058,2),(1059,2),(1060,2),(1061,2),(1062,2),(1063,2),(1064,2),(1065,2),(1066,2),(1067,2),(1068,2),(1069,2),(1070,2),(1071,2),(1072,2),(1073,2),(1074,2),(1075,2),(1076,2),(1077,2),(1078,2),(1079,2),(1080,2),(1081,2),(1082,2),(1083,2),(1084,2),(1085,2),(1086,2),(1087,2),(1088,2),(1089,2),(1090,2),(1091,2),(1092,2),(1093,2),(1094,2),(1095,2),(1096,2),(1097,2),(1098,2),(1099,2),(1100,2),(1101,2),(1102,2),(1103,2),(1104,2),(1105,2),(1106,2),(1107,2),(1108,2),(1109,2),(1110,2),(1111,2),(1112,2),(1113,2),(1114,2),(1115,2),(1116,2),(1117,2),(1118,2),(1119,2),(1120,2),(1121,2),(1122,2),(1123,2),(1124,2),(1125,2),(1126,2),(1127,2),(1128,2),(1129,2),(1130,2),(1131,2),(1132,2),(1133,2),(1134,2),(1135,2),(1136,2),(1137,2),(1138,2),(1139,2),(1140,2),(1141,2),(1142,2),(1143,2),(1144,2),(1145,2),(1146,2),(1147,2),(1148,2),(1149,2),(1150,2),(1151,2),(1152,2),(1153,2),(1154,2),(1155,2),(1156,2),(1157,2),(1158,2),(1159,2),(1160,2),(1161,2),(1162,2),(1163,2),(1164,2),(1165,2),(1166,2),(1167,2),(1168,2),(1169,2),(1170,2),(1171,2),(1172,2),(1173,2),(1174,2),(1175,2),(1176,2),(1177,2),(1178,2),(1179,2),(1180,2),(1181,2),(1182,2),(1183,2),(1184,2),(1185,2),(1186,2),(1187,2),(1188,2),(1189,2),(1190,2),(1191,2),(1192,2),(1193,2),(1194,2),(1195,2),(1196,2),(1197,2),(1198,2),(1199,2),(1200,2),(1201,2),(1202,2),(1203,2),(1204,2),(1205,2),(1206,2),(1207,2),(1208,2),(1209,2),(1210,2),(1211,2),(1212,2),(1213,2),(1214,2),(1215,2),(1216,2),(1217,2),(1218,2),(1219,2),(1220,2),(1221,2),(1222,2),(1223,2),(1224,2),(1225,2),(1226,2),(1227,2),(1228,2),(1229,2),(1230,2),(1231,2),(1232,2),(1233,2),(1234,2),(1235,2),(1236,2),(1237,2),(1238,2),(1239,2),(1240,2),(1241,2),(1242,2),(1243,2),(1244,2),(1245,2),(1246,2),(1247,2),(1248,2),(1249,2),(1250,2),(1251,2),(1252,2),(1253,2),(1254,2),(1255,2),(1256,2),(1257,2),(1258,2),(1259,2),(1260,2),(1261,2),(1262,2),(1263,2),(1264,2),(1265,2),(1266,2),(1267,2),(1268,2),(1269,2),(1270,2),(1271,2),(1272,2),(1273,2),(1274,2),(1275,2),(1276,2),(1277,2),(1278,2),(1279,2),(1280,2),(1281,2),(1282,2),(1283,2),(1284,2),(1285,2),(1286,2),(1287,2),(1288,2),(1289,2),(1290,2),(1291,2),(1292,2),(1293,2),(1294,2),(1295,2),(1296,2),(1297,2),(1298,2),(1299,2),(1300,2),(1301,2),(1302,2),(1303,2),(1304,2),(1305,2),(1306,2),(1307,2),(1308,2),(1309,2),(1310,2),(1311,2),(1312,2),(1313,2),(1314,2),(1315,2),(1316,2),(1317,2),(1318,2),(1319,2),(1320,2),(1321,2),(1322,2),(1323,2),(1324,2),(1325,2),(1326,2),(1327,2),(1328,2),(1329,2),(1330,2),(1331,2),(1332,2),(1333,2),(1334,2),(1335,2),(1336,2),(1337,2),(1338,2),(1339,2),(1340,2),(1341,2),(1342,2),(1343,2),(1344,2),(1345,2),(1346,2),(1347,2),(1348,2),(1349,2),(1350,2),(1351,2),(1352,2),(1353,2),(1354,2),(1355,2),(1356,2),(1357,2),(1358,2),(1359,2),(1360,2),(1361,2),(1362,2),(1363,2),(1364,2),(1365,2),(1366,2),(1367,2),(1368,2),(1369,2),(1370,2),(1371,2),(1372,2),(1373,2),(1374,2),(1375,2),(1376,2),(1377,2),(1378,2),(1379,2),(1380,2),(1381,2),(1382,2),(1383,2),(1384,2),(1385,2),(1386,2),(1387,2),(1388,2),(1389,2),(1390,2),(1391,2),(1392,2),(1393,2),(1394,2),(1395,2),(1396,2),(1397,2),(1398,2),(1399,2),(1400,2),(1401,2),(1402,2),(1403,2),(1404,2),(1405,2),(1406,2),(1407,2),(1408,2),(1409,2),(1410,2),(1411,2),(1412,2),(1413,2),(1414,2),(1415,2),(1416,2),(1417,2),(1418,2),(1419,2),(1420,2),(1421,2),(1422,2),(1423,2),(1424,2),(1425,2),(1426,2),(1427,2),(1428,2),(1429,2),(1430,2),(1431,2),(1432,2),(1433,2),(1434,2),(1435,2),(1436,2),(1437,2),(1438,2),(1439,2),(1440,2),(1441,2),(1442,2),(1443,2),(1444,2),(1445,2),(1446,2),(1447,2),(1448,2),(1449,2),(1450,2),(1451,2),(1452,2),(1453,2),(1454,2),(1455,2),(1456,2),(1457,2),(1458,2),(1459,2),(1460,2),(1461,2),(1462,2),(1463,2),(1464,2),(1465,2),(1466,2),(1467,2),(1468,2),(1469,2),(1470,2),(1471,2),(1472,2),(1473,2),(1474,2),(1475,2),(1476,2),(1477,2),(1478,2),(1479,2),(1480,2),(1481,2),(1482,2),(1483,2),(1484,2),(1485,2),(1486,2),(1487,2),(1488,2),(1489,2),(1490,2),(1491,2),(1492,2),(1493,2),(1494,2),(1495,2),(1496,2),(1497,2),(1498,2),(1499,2),(1500,2),(1501,2),(1502,2),(1503,2),(1504,2),(1505,2),(1506,2),(1507,2),(1508,2),(1509,2),(1510,2),(1511,2),(1512,2),(1513,2),(1514,2),(1515,2),(1516,2),(1517,2),(1518,2),(1519,2),(1520,2),(1521,2),(1522,2),(1523,2),(1524,2),(1525,2),(1526,2),(1527,2),(1528,2),(1529,2),(1530,2),(1531,2),(1532,2),(1533,2),(1534,2),(1535,2),(1536,2),(1537,2),(1538,2),(1539,2),(1540,2),(1541,2),(1542,2),(1543,2),(1544,2),(1545,2),(1546,2),(1547,2),(1548,2),(1549,2),(1550,2),(1551,2),(1552,2),(1553,2),(1554,2),(1555,2),(1556,2),(1557,2),(1558,2),(1559,2),(1560,2),(1561,2),(1562,2),(1563,2),(1564,2),(1565,2),(1566,2),(1567,2),(1568,2),(1569,2),(1570,2),(1571,2),(1572,2),(1573,2),(1574,2),(1575,2),(1576,2),(1577,2),(1578,2),(1579,2),(1580,2),(1581,2),(1582,2),(1583,2),(1584,2),(1585,2),(1586,2),(1587,2),(1588,2),(1589,2),(1590,2),(1591,2),(1592,2),(1593,2),(1594,2),(1595,2),(1596,2),(1597,2),(1598,2),(1599,2),(1600,2),(1601,2),(1602,2),(1603,2),(1604,2),(1605,2),(1606,2),(1607,2),(1608,2),(1609,2),(1610,2),(1611,2),(1612,2),(1613,2),(1614,2),(1615,2),(1616,2),(1617,2),(1618,2),(1619,2),(1620,2),(1621,2),(1622,2),(1623,2),(1624,2),(1625,2),(1626,2),(1627,2),(1628,2),(1629,2),(1630,2),(1631,2),(1632,2),(1633,2),(1634,2),(1635,2),(1636,2),(1637,2),(1638,2),(1639,2),(1640,2),(1641,2),(1642,2),(1643,2),(1644,2),(1645,2),(1646,2),(1647,2),(1648,2),(1649,2),(1650,2),(1651,2),(1652,2),(1653,2),(1654,2),(1655,2),(1656,2),(1657,2),(1658,2),(1659,2),(1660,2),(1661,2),(1662,2),(1663,2),(1664,2),(1665,2),(1666,2),(1667,2),(1668,2),(1669,2),(1670,2),(1671,2),(1672,2),(1673,2),(1674,2),(1675,2),(1676,2),(1677,2),(1678,2),(1679,2),(1680,2),(1681,2),(1682,2),(1683,2),(1684,2),(1685,2),(1686,2),(1687,2),(1688,2),(1689,2),(1690,2),(1691,2),(1692,2),(1693,2),(1694,2),(1695,2),(1696,2),(1697,2),(1698,2),(1699,2),(1700,2),(1701,2),(1702,2),(1703,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(7,3),(8,3),(9,3),(10,3),(11,3),(12,3),(13,3),(14,3),(15,3),(16,3),(17,3),(18,3),(19,3),(20,3),(21,3),(22,3),(23,3),(24,3),(25,3),(26,3),(27,3),(28,3),(29,3),(30,3),(31,3),(32,3),(33,3),(34,3),(35,3),(36,3),(37,3),(38,3),(39,3),(40,3),(41,3),(42,3),(43,3),(44,3),(45,3),(46,3),(47,3),(48,3),(49,3),(50,3),(51,3),(52,3),(53,3),(54,3),(55,3),(56,3),(57,3),(58,3),(59,3),(60,3),(61,3),(62,3),(63,3),(64,3),(65,3),(66,3),(67,3),(68,3),(69,3),(70,3),(71,3),(72,3),(73,3),(74,3),(75,3),(76,3),(77,3),(78,3),(79,3),(80,3),(81,3),(82,3),(83,3),(84,3),(85,3),(86,3),(87,3),(88,3),(89,3),(90,3),(91,3),(92,3),(93,3),(94,3),(666,3),(667,3),(668,3),(669,3),(670,3),(671,3),(672,3),(673,3),(674,3),(675,3),(676,3),(677,3),(678,3),(679,3),(680,3),(681,3),(682,3),(683,3),(684,3),(685,3),(686,3),(687,3),(688,3),(689,3),(690,3),(691,3),(692,3),(693,3),(694,3),(695,3),(696,3),(697,3),(698,3),(699,3),(700,3),(701,3),(702,3),(703,3),(704,3),(705,3),(706,3),(707,3),(708,3),(709,3),(710,3),(711,3),(712,3),(713,3),(714,3),(715,3),(716,3),(717,3),(718,3),(719,3),(765,3),(766,3),(767,3),(768,3),(769,3),(770,3),(771,3),(772,3),(773,3),(774,3),(775,3),(776,3),(777,3),(778,3),(779,3),(780,3),(781,3),(782,3),(783,3),(784,3),(785,3),(786,3),(787,3),(788,3),(789,3),(790,3),(791,3),(792,3),(793,3),(794,3),(795,3),(796,3),(797,3),(798,3),(799,3),(800,3),(801,3),(802,3),(803,3),(804,3),(805,3),(806,3),(807,3),(808,3),(809,3),(810,3),(811,3),(812,3),(813,3),(814,3),(815,3),(816,3),(817,3),(818,3),(819,3),(820,3),(821,3),(822,3),(823,3),(824,3),(825,3),(826,3),(827,3),(828,3),(829,3),(830,3),(831,3),(832,3),(833,3),(834,3),(835,3),(836,3),(837,3),(838,3),(839,3),(840,3),(841,3),(842,3),(843,3),(844,3),(845,3),(846,3),(847,3),(848,3),(849,3),(850,3),(851,3),(852,3),(853,3),(854,3),(855,3),(856,3),(857,3),(858,3),(859,3),(860,3),(861,3),(862,3),(863,3),(864,3),(865,3),(866,3),(867,3),(868,3),(869,3),(870,3),(871,3),(872,3),(873,3),(874,3),(875,3),(876,3),(877,3),(878,3),(879,3),(880,3),(881,3),(882,3),(883,3);
/*!40000 ALTER TABLE `tr_piece_formation` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-01-26 15:03:35
