Download information

To download the contact details with amount owed or paid click here.

To download the competitor details click here

To display classes select:            


Database changes: category, class, classes, competitor, contact, cost.

Dump entire database.

CREATE TABLE IF NOT EXISTS category (
id int(11) NOT NULL AUTO_INCREMENT,
category text,
secretary text,
Suggestion text NOT NULL,
day tinyint(4) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
INSERT INTO category (id, category, secretary, Suggestion, day) VALUES
(9, 'Piano Solo Classes', 'Piano', '', 1),
(10, 'Piano Duet', 'Piano', 'Please note: for Piano Duet, Trios and Ensembles, competitors can perform in more than one combination within any class.', 1),
(11, 'Piano Trio', 'Piano', 'Please note: for Piano Duet, Trios and Ensembles, competitors can perform in more than one combination within any class.', 1),
(12, 'Piano ensemble', 'Piano', 'Please note: for Piano Duet, Trios and Ensembles, competitors can perform in more than one combination within any class', 1),
(13, 'Family Duet/Ensemble', 'Other', '', 2),
(14, 'Adult Vocal Classes', 'Vocal', '', 2),
(15, 'Adult Vocal Duet Class', 'Vocal', '', 2),
(16, 'Vocal Ensemble Classes', 'Vocal', 'Note: the official accompanist will not be available for these classes.', 1),
(17, 'Strings Classes - Solo', 'Strings', '', 2),
(18, 'String Duets', 'Strings', 'Players may also enter the Junior Instrumental Recital Class or Instrumental Duets.', 2),
(19, 'Open Vocal or Instrumental Recital Class', 'Other', '£50 first prize, £25 second prize', 2),
(23, 'Piano Solo', 'Piano', 'Note: Graded pieces may be taken from any current Examination Board. Please provide a copy for the Adjudicator.', 2),
(24, 'Piano Sight-Reading', 'Piano', 'Note: Piano players may also wish to enter Classes 316, 322-331 or Recital Class 500', 2),
(25, 'Vocal Solo (Children)', 'Vocal', '', 1),
(26, 'Vocal Duet (Children)', 'Vocal', '', 1),
(27, 'Choir Classes (Children)', 'Vocal', 'Choirs are required to present a programme of between 10-15 minutes duration comprising \r\n3 to 5 pieces chosen to show variety and skill. Songs may be accompanied or unaccompanied.\r\nNote: the official accompanist will not be available for these classes.', 1),
(29, 'Keyboard Class', 'Piano', '', 2),
(30, 'Recorder Solo Classes', 'Other', '', 1),
(31, 'Recorder Duet Class', 'Other', '', 1),
(32, 'Recorder Ensemble Classes', 'Other', '', 1),
(33, 'Classical Guitar Classes', 'Strings', '', 2),
(34, 'Ukulele Classes', 'Strings', '', 1),
(35, 'Ukulele Duet Classes', 'Strings', '', 1),
(36, 'Younger Adult Vocal Classes', 'Vocal', '', 1),
(37, 'Brass Solos', 'Other', '', 2),
(38, 'Brass Ensembles', 'Other', 'Please note: for duets, trios and ensembles, competitors can perform in more than one combination within any class.', 2),
(39, 'Junior Instrumental Recital Class', 'Other', '', 2),
(40, 'Woodwind and Recorder Solo', 'Other', 'Woodwind players may wish to enter Classes 316, 322-331 or Recital Class 500', 2),
(41, 'Instrumental Duets Classes', 'Other', '', 2),
(42, 'Instrumental Ensemble Classes', 'Other', '', 2),
(43, 'Own Composition Classes', 'Other', 'Note: Adjudication of performance only', 2),
(44, 'Speech and Drama - Set Verse Solo Classes', 'Drama', 'In Classes 401-405 Poems are taken from The Works (chosen by Paul Cookson), MacMillan Children\'s Books ISBN 0-330-48104-5, The Puffin Book of 20th Century Children\'s Verse, Puffin Books.', 2),
(45, 'Speech and Drama - Own Choice Poems.', 'Drama', '', 2),
(46, 'Shared Poems', 'Drama', '', 2),
(47, 'Religious Readings', 'Drama', '', 2),
(49, 'Duologues', 'Drama', '', 2),
(50, 'Shakespeare', 'Drama', '', 2),
(51, 'Sight Reading', 'Drama', '', 2),
(52, 'Prose Reading and Public Speaking', 'Drama', '', 2),
(53, 'Solo Drama', 'Drama', '', 2),
(54, 'Mime', 'Drama', '', 2),
(55, 'Spontaneous Narration', 'Drama', 'Note: The Adjudicator will give the same object to each Competitor in turn. After half a minute they are to tell a story concerning it.', 2),
(56, 'Adult Class', 'Drama', '', 2),
(57, 'The Junior Speech and Drama Prize', 'Drama', 'Junior Speech And Drama has a £20 first prize', 2),
(58, 'The Buxton Poem Class', 'Drama', '', 2),
(59, 'Piano Solo – set piece', 'Piano', '', 2);

CREATE TABLE IF NOT EXISTS class (
id int(11) NOT NULL AUTO_INCREMENT,
competitorid int(11) NOT NULL,
classno text NOT NULL,
classtitle text NOT NULL,
classage text NOT NULL,
ownchoice text NOT NULL,
composer text NOT NULL,
oar tinyint(1) NOT NULL,
duration text NOT NULL,
fee decimal(5,2) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
INSERT INTO class (id, competitorid, classno, classtitle, classage, ownchoice, composer, oar, duration, fee) VALUES
(3, 3, '205', 'Violin or Viola Solo - Advanced Own Choice', 'Open', 'Adoration', 'Borowski', 1, '', '9.50'),
(5, 5, '203', 'Violin or Viola Solo - Grades 3 & 4 standard - Own Choice', 'Open', 'The Deserted Garden', 'Florence B. Price', 1, '2mins', '9.50'),
(6, 6, '216', 'Brass or woodwind solo (including recorder) - grade 1 & grade 2 standard - own choice', 'Open', '', '', 1, '2 mins', '12.50'),
(7, 7, '105', 'Classical Song including Light opera and G&S - own choice', '12', 'Clock-a-clay', 'Richard Rodney Bennet', 1, '2mins 3 secs', '8.00'),
(8, 7, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Matchmaker from Fiddler on the Roof', 'Sheldon Harnick / Jerry Bock', 1, '2mins 18 secs', '8.00'),
(9, 7, '113', 'Unaccompanied Folk Song - Own Choice', '12', 'An Eriskay Love Lilt', 'Marjory Kennedy-Fraser / Kenneth MacLeod', 0, '1min 51 secs', '8.00'),
(10, 8, '104', 'Classical Song including Light opera and G&S - own choice', '10', 'The Crocodile', 'Peter Jenkyns', 1, '1min 56 secs', '8.00'),
(11, 8, '108', 'Popular Song including Film and Musicals - own choice', '10', 'The Second Star to the Right from Peter Pan', 'Cahn & Fain', 1, '1min 24 secs', '8.00'),
(12, 9, '118', 'vocal duet - any voices - own choice', '12', 'The Table and the Chair', 'Edward Lear / Victor Hely Hutchinson. Arr by J Michael Diack', 1, '2mins 21secs', '11.25'),
(13, 10, '216', 'Brass or woodwind solo (including recorder) - grade 1 & grade 2 standard - own choice', 'Open', 'A Thousand Years', 'David Hodges and Christina Perri', 0, '1.40', '12.50'),
(14, 11, '218', 'Brass or woodwind solo (including recorder) - grade 5 & grade 6 standard - own choice', 'Open', 'Hackensack', 'Thelonious Monk', 1, '1.50', '12.50'),
(15, 12, '122', 'Piano solo grade 3 and 4 standard - own choice', 'Open', 'Experience', 'Einaudi', 0, '2 mins', '12.50'),
(16, 13, '124', 'Piano Solo Advanced - Own Choice', 'Open', 'Fly me to the moon', 'Howard', 0, '3 mins', '12.50'),
(17, 14, '121', 'Piano solo grade 1 and 2 standard - own choice', 'Open', 'The Swinging Sioux', 'Gillock', 0, '1 min', '12.50'),
(18, 14, 'NC5', 'Non-Competitive Piano Solo Own Choice', '8', 'The Fountain', 'Lasco', 0, '1 min', '7.50'),
(19, 15, '123', 'Piano solo grade 5 and 6 standard - own choice', 'Open', 'Allegro', 'Cimarosa', 0, '2 mins', '12.50'),
(20, 16, '122', 'Piano solo grade 3 and 4 standard - own choice', 'Open', 'The Entertainer', 'Joplin arr.Onac', 0, '2 mins', '12.50'),
(21, 17, '124', 'Piano Solo Advanced - Own Choice', 'Open', 'Allegro moderato- 1st movt from sonata in B minor', 'Haydn', 0, '4 mins', '12.50'),
(22, 18, '121', 'Piano solo grade 1 and 2 standard - own choice', 'Open', 'Strawberry Flip', 'Wedgwood', 0, '1 min', '12.50'),
(23, 19, '127', 'Piano Duet Own Choice', 'Open', 'Danse Macabre', 'Saint Seans', 0, '2 mins', '15.00'),
(24, 20, '125', 'Piano Duet Own Choice', '10', 'Courante', 'Wells', 0, '1 min', '11.25'),
(25, 21, '130', 'Piano 3 or more players ', 'Open', 'Jamaican Farewell', 'Trad. arr. Cornick', 0, '3 mins', '15.00'),
(26, 22, '129', 'Piano 3 or more players ', '14', 'Down by the riverside', 'Spiritual arr. Miller', 0, '2 mins', '15.00'),
(27, 23, '130', 'Piano 3 or more players ', 'Open', 'Mango Walk', 'Trad. arr. Cornick', 0, '2 mins', '15.00'),
(28, 24, '105', 'Classical Song including Light opera and G&S - own choice', '12', 'Schneeglockchen', 'Schumann', 1, '2:00', '8.00'),
(29, 24, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Whistle down the wind', 'Lloyd Webber', 1, '2:30', '8.00'),
(30, 25, '122', 'Piano solo grade 3 and 4 standard - own choice', 'Open', 'The Entertainer', 'Scott Joplin', 0, '1.40', '12.50'),
(31, 25, '105', 'Classical Song including Light opera and G&S - own choice', '12', 'Dream Song', 'Victor Hely-Hutchinson', 1, '2.00', '8.00'),
(32, 25, '109', 'Popular Song including Film and Musicals - own choice', '12', 'A spoonful of sugar', 'Sherman Brothers', 1, '2.24', '8.00'),
(33, 25, '113', 'Unaccompanied Folk Song - Own Choice', '12', 'Wild Mountain Thyme', 'Traditional', 0, '2.08', '8.00'),
(34, 26, '119', 'vocal duet - any voices - own choice', '15', 'The Cuckoo Clock', 'Andy Beck', 1, '3.17', '11.25'),
(35, 27, '113', 'Unaccompanied Folk Song - Own Choice', '12', 'Ye Banks and Braes O\' Bonnie Doon', 'Robert Burns', 0, '1min 40', '8.00'),
(36, 27, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Once Upon a December', 'Flaherty', 1, '2min 45', '8.00'),
(37, 27, '105', 'Classical Song including Light opera and G&S - own choice', '12', 'Marienwurmchen', 'Schumann', 1, '1min 35', '8.00'),
(38, 28, '203', 'Violin or Viola Solo - Grades 3 & 4 standard - Own Choice', 'Open', 'The Legend of Ashitaka', 'Joe Hisaishi', 1, '2.5 mins', '7.50'),
(39, 28, 'NC9', 'Violin, Viola, Cello, Double Bass, harp solo - Own Choice ', '8', 'Witches Dance', 'Nicolò Paganini', 1, '1 mins', '7.50'),
(40, 29, '104', 'Classical Song including Light opera and G&S - own choice', '10', 'A Little Lovely Dream', 'Amit Anand', 1, '', '8.00'),
(41, 29, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Truly Scrumptious', 'Richard M Sherman and Robert B Sherman - from Chitty Chitty Bang Bang', 1, '', '8.00'),
(42, 29, '112', 'Unaccompanied Folk Song - Own Choice', '10', 'Anna Marie', 'Trad aar. Sarah Dacey', 1, '', '8.00'),
(43, 30, '205', 'Violin or Viola Solo - Advanced Own Choice. ', 'Open', 'Passacaglia on an old English Tune', 'Rebecca Clarke', 1, '5 min', '9.50'),
(44, 31, '104', 'Classical Song including Light opera and G&S - own choice', '10', 'Callers', 'Arthur Benjamin', 1, '', '8.00'),
(45, 31, '108', 'Popular Song including Film and Musicals - own choice', '10', 'My favourite things', 'Rodgers and Hammerstein', 1, '', '8.00'),
(46, 31, '112', 'Unaccompanied Folk Song - Own Choice', '10', 'All through the night ', '', 0, '', '8.00'),
(47, 32, 'NC5', 'Non-Competitive Piano Solo Own Choice', '8', 'Tom Toms', 'Not given', 0, '35secs', '7.50'),
(48, 33, '300', 'Two or more related performers, children and/or adults, any combination of instrument/vocal. Extra marks given for widest age difference!', 'Open', 'His Eye is on the Sparrow', 'Charles H Gabriel', 0, '2min', '18.75'),
(49, 34, '216', 'Brass or woodwind solo (including recorder) - grade 1 & grade 2 standard - own choice', 'Open', 'Spooked', 'Helen Jane Long\r\n', 0, '60 seconds', '12.50'),
(50, 35, '104', 'Classical Song including Light opera and G&S - own choice', '10', 'The Crocodile', 'Peter Jenkyns', 1, '', '8.00'),
(51, 35, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Edelweiss', 'Rogers and Hammerstein', 1, '', '8.00'),
(52, 35, '112', 'Unaccompanied Folk Song - Own Choice', '10', 'The Keel Row', '', 1, '', '8.00'),
(53, 36, '202', 'Violin or Viola Solo - Grades 1 & 2 standard - Own Choice', 'Open', 'Fandango', 'Huws Jones', 1, '1', '7.50'),
(54, 37, '203', 'Violin or Viola Solo - Grades 3 & 4 standard - Own Choice', 'Open', 'Puppet Show', 'Trott', 1, '2', '8.00'),
(55, 38, '203', 'Violin or Viola Solo - Grades 3 & 4 standard - Own Choice', 'Open', 'Reigen', 'Baklanova', 0, '1.30', '8.00'),
(56, 39, '203', 'Violin or Viola Solo - Grades 3 & 4 standard - Own Choice', 'Open', 'Allegro Op12', 'Kuchler', 0, '3', '8.00'),
(57, 40, '203', 'Violin or Viola Solo - Grades 3 & 4 standard - Own Choice', 'Open', 'Quizás ,quizás, quizâs', 'Arr Huws Jones', 0, '2', '8.00'),
(58, 41, '205', 'Violin or Viola Solo - Advanced Own Choice. ', 'Open', 'Romance', 'Jean Sibelius ', 0, '4', '9.50'),
(59, 42, '227', 'Opera, light opera, Operetta solo - own choice ', 'Open', 'Non Piu Andrai - Le Nozze di Figaro', 'Mozart', 1, '3:45', '12.50'),
(60, 42, '500', 'Competitors should perform a varied programme for a maximum of 15 minutes. See Rule 3. ', 'Open', 'Se Vuol Ballare - Le Nozze di Figaro\r\nDie Lotosblume\r\nAm I Alone/If You\'re Anxious for to Shine', 'Mozart\r\nSchumann\r\nGilbert & Sullivan', 1, '14:00', '31.25'),
(61, 43, '500', 'Competitors should perform a varied programme for a maximum of 15 minutes. See Rule 3. ', 'Open', '1) Sonata in E major for violin and piano (movements I and II)\r\n2) Berceuse, Op.16 for violin and piano.\r\n3) Czardas for violin and piano.', '1) Handel \r\n2) Gabriel Fauré \r\n3) Monti ', 0, '', '31.25'),
(62, 44, '104', 'Classical Song including Light opera and G&S - own choice', '10', 'Grandfather Clock', 'Alec Rowley', 1, '4', '8.00'),
(63, 44, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Wouldn\'t It Be Loverly', 'From My Fair Lady', 1, '4', '8.00'),
(64, 44, '112', 'Unaccompanied Folk Song - Own Choice', '10', 'My Bonnie Lies Over The Ocean', 'Traditional', 1, '4', '8.00'),
(65, 45, 'NC1', 'Vocal Solo Own Choice (non-competitive). ', '10', 'Castle on a Cloud', 'Alain Boublil and Claude-Michel Schönberg', 0, '', '8.00'),
(66, 45, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Naughty', 'Tim Minchin', 0, '', '8.00'),
(67, 46, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Where Is Love', 'Bartt', 0, '2 mins', '8.00'),
(68, 47, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Zip A Dee Doo Dah', 'Wrubel', 0, '1min', '8.00'),
(69, 48, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Getting To Know You', 'Rodgers', 0, '2mins', '8.00'),
(70, 49, '108', 'Popular Song including Film and Musicals - own choice', '10', 'Part Of Your World', 'Menken', 0, '2 mins', '8.00'),
(71, 50, 'NC1', 'Vocal Solo Own Choice (non-competitive). ', '10', 'Zip A Dee Doo Dah', 'Wrubel', 0, '1min', '8.00'),
(72, 51, 'NC1', 'Vocal Solo Own Choice (non-competitive). ', '10', 'Elephants', 'bARRATT', 0, '1MIN', '8.00'),
(73, 52, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Part Of Your World', 'Menken', 0, '2mins', '8.00'),
(74, 53, '109', 'Popular Song including Film and Musicals - own choice', '12', 'If I Only Had A Brain', 'Arlen', 0, '2mins', '8.00'),
(75, 54, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Lavender Blue', 'Daniel', 0, '2min', '8.00'),
(76, 54, '105', 'Classical Song including Light opera and G&S - own choice', '12', 'Twinkle Twinkle', 'Westcott', 0, '2mins', '8.00'),
(77, 55, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Castle On A Cloud', 'Schonberg', 0, '2mins', '8.00'),
(78, 56, '104', 'Classical Song including Light opera and G&S - own choice', '10', 'Camptown Races', 'Foster', 0, '1min', '8.00'),
(79, 57, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Singing In The Rain', 'Brown', 0, '1min', '8.00'),
(80, 58, '110', 'Popular Song including Film and Musicals - own choice', '15', 'Shall We Dance', 'Rodgers', 0, '2mins', '9.50'),
(81, 58, '114', 'Unaccompanied Folk Song - Own Choice', '15', 'Pit Boys', 'Trad', 0, '3mins', '9.50'),
(82, 59, '110', 'Popular Song including Film and Musicals - own choice', '15', 'If my Friends Could see me now', 'Coleman', 0, '3mins', '9.50'),
(83, 60, '110', 'Popular Song including Film and Musicals - own choice', '15', 'Broadway Baby', 'Sondheim', 0, '3mins', '9.50'),
(84, 61, '109', 'Popular Song including Film and Musicals - own choice', '12', 'Over the Rainbow', 'Arlen', 0, '3mins', '8.00'),
(85, 61, '113', 'Unaccompanied Folk Song - Own Choice', '12', 'Great Silkie', 'Trad', 0, '2mins', '8.00'),
(86, 62, '110', 'Popular Song including Film and Musicals - own choice', '15', 'Beauty and the Beast', 'Menken', 0, '3mins', '9.50'),
(87, 62, '106', 'Classical Song including Light opera and G&S - own choice', '15', 'Path To The Moon', '', 0, '3mins', '9.50'),
(88, 62, '114', 'Unaccompanied Folk Song - Own Choice', '15', 'Mow Me Down My Meadow', 'Trad', 0, '2mins', '9.50'),
(89, 63, '119', 'vocal duet - any voices - own choice', '15', 'Love Grows Here', 'Besig', 0, '3mins', '11.25'),
(90, 64, '118', 'vocal duet - any voices - own choice', '12', 'Swing Low', 'Trad', 0, '1min', '11.25'),
(91, 65, '117', 'vocal duet - any voices - own choice', '10', 'SI SI SI', 'Trad', 0, '2mins', '11.25'),
(92, 66, '119', 'vocal duet - any voices - own choice', '15', 'Kookaburra', 'Snyder', 0, '2mins', '11.25'),
(93, 67, '117', 'vocal duet - any voices - own choice', '10', 'If Your Happy and You Know It', 'Trad', 0, '1min', '11.25'),
(94, 67, '131', 'Youth Choir - more than 10 voices Own Choice programme not exceeding 10 minutes.', '12', 'Zum Gali Gali - Trad Arr Gilpin\r\nKumbaya - Trad Arr E.Hopkins\r\nJoshua Fought The Battle OF jERICHO - Des Jardins', '', 0, '10mins', '31.25'),
(95, 68, 'NC5', 'Non-Competitive Piano Solo Own Choice', '8', 'Old Mc Donald', 'Howard kasschau', 0, '', '7.50'),
(96, 69, 'NC5', 'Non-Competitive Piano Solo Own Choice', '8', 'The Haunted Castle', 'Waterman/Harewood', 0, '', '7.50'),
(97, 70, 'NC5', 'Non-Competitive Piano Solo Own Choice', '8', 'The Muffin Man', 'Waterman/Harewood', 0, '', '7.50'),
(98, 70, '121', 'Piano solo grade 1 and 2 standard - own choice', 'Open', 'Walk In The Park', 'G.Fox', 0, '', '12.50'),
(99, 70, '121', 'Piano solo grade 1 and 2 standard - own choice', 'Open', 'Stealth Mode', 'M.Bober', 0, '', '12.50'),
(100, 70, '126', 'Piano Duet Own Choice', '14', 'Mango Walk', 'B. Kirkby-Mason', 0, '', '11.25'),
(101, 71, '106', 'Classical Song including Light opera and G&S - own choice', '15', 'Caro bio Ben', 'Giuseppe Giordani', 0, '', '9.50'),
(102, 71, '110', 'Popular Song including Film and Musicals - own choice', '15', 'The Sound of Music', 'Richard Rodgers', 0, '', '9.50'),
(103, 71, '114', 'Unaccompanied Folk Song - Own Choice', '15', 'O Waly, Waly', 'Benjamin Britten', 0, '', '9.50'),
(104, 72, '107', 'Classical Song including Light opera and G&S - own choice', '18', 'Das Veilchen', 'Mozart', 0, '', '10.00'),
(105, 72, '111', 'Popular Song including Film and Musicals - own choice', '18', 'On My Own (Les Miserables)', 'Claude-Michel Schönberg/Herbert Kretzmer', 0, '', '10.00');

CREATE TABLE IF NOT EXISTS classes (
id int(11) NOT NULL AUTO_INCREMENT,
CATid int(11) DEFAULT NULL,
catcode text,
Title text,
Choice text,
maxage int(11) DEFAULT NULL,
costid int(11),
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;
INSERT INTO classes (id, CATid, catcode, Title, Choice, maxage, costid) VALUES
(1, 36, '101', 'vocal ensemble - 3 to 10 voices - own choice programme not exceeding 10 minutes', '', 20, 9),
(2, 16, '102', 'vocal ensemble - 3 to 10 voices - own choice programme not exceeding 10 minutes', '', 99, 13),
(3, 27, '103', 'Youth Choir - more than 10 voices Own Choice programme not exceeding 10 minutes.', '', 18, 17),
(4, 25, 'NC1', 'Vocal Solo Own Choice (non-competitive). ', '', 10, 2),
(5, 25, 'NC2', 'Vocal Solo Own Choice (non-competitive). ', '', 12, 2),
(6, 25, 'NC3', 'Vocal Solo Own Choice (non-competitive). ', '', 15, 3),
(7, 25, 'NC4', 'Vocal Solo Own Choice (non-competitive). ', '', 18, 4),
(8, 25, '104', 'Classical Song including Light opera and G&S - own choice', '', 10, 2),
(9, 25, '105', 'Classical Song including Light opera and G&S - own choice', '', 12, 2),
(10, 25, '106', 'Classical Song including Light opera and G&S - own choice', '', 15, 3),
(11, 25, '107', 'Classical Song including Light opera and G&S - own choice', '', 18, 4),
(12, 25, '108', 'Popular Song including Film and Musicals - own choice', '', 10, 2),
(13, 25, '109', 'Popular Song including Film and Musicals - own choice', '', 12, 2),
(14, 25, '110', 'Popular Song including Film and Musicals - own choice', '', 15, 3),
(15, 25, '111', 'Popular Song including Film and Musicals - own choice', '', 18, 4),
(16, 25, '112', 'Unaccompanied Folk Song - Own Choice', '', 10, 2),
(17, 25, '113', 'Unaccompanied Folk Song - Own Choice', '', 12, 2),
(18, 25, '114', 'Unaccompanied Folk Song - Own Choice', '', 15, 3),
(19, 25, '115', 'Unaccompanied Folk Song - Own Choice', '', 18, 4),
(20, 25, '116', 'Vocal solo for boys with changing voice - own choice', '', 99, 11),
(21, 26, '117', 'vocal duet - any voices - own choice', '', 10, 5),
(22, 26, '118', 'vocal duet - any voices - own choice', '', 12, 5),
(23, 26, '119', 'vocal duet - any voices - own choice', '', 15, 5),
(24, 26, '120', 'vocal duet - any voices - own choice', '', 18, 5),
(25, 9, 'NC5', 'Non-Competitive Piano Solo Own Choice', '', 8, 1),
(26, 9, 'NC6', 'Non-Competitive Piano Solo Own Choice', '', 12, 2),
(27, 9, 'NC7', 'Non-Competitive Piano Solo Own Choice', '', 16, 3),
(28, 9, 'NC8', 'Non-Competitive Piano Solo Own Choice', '', 99, 11),
(29, 9, '121', 'Piano solo grade 1 and 2 standard - own choice', '', 99, 11),
(30, 9, '122', 'Piano solo grade 3 and 4 standard - own choice', '', 99, 11),
(31, 9, '123', 'Piano solo grade 5 and 6 standard - own choice', '', 99, 11),
(32, 9, '124', 'Piano Solo Advanced - Own Choice', '', 99, 11),
(33, 10, '125', 'Piano Duet Own Choice', '', 10, 5),
(34, 10, '126', 'Piano Duet Own Choice', '', 14, 5),
(35, 10, '127', 'Piano Duet Own Choice', '', 99, 12),
(36, 11, '128', 'Piano 3 or more players ', '', 10, 6),
(37, 11, '129', 'Piano 3 or more players ', '', 14, 6),
(38, 11, '130', 'Piano 3 or more players ', '', 99, 12),
(39, 17, 'NC9', 'Violin, Viola, Cello, Double Bass, harp solo - Own Choice ', '', 8, 1),
(40, 17, 'NC10', 'Violin, Viola, Cello, Double Bass, harp solo - Own Choice ', '', 12, 2),
(41, 17, 'NC11', 'Violin, Viola, Cello, Double Bass harp solo -Own Choice ', '', 16, 3),
(42, 17, 'NC12', 'Violin, Viola, Cello, Double Bass, harp solo - Own Choice ', '', 98, 11),
(43, 17, '201', 'Violin, Viola, Cello, Double Bass, Harp solo. Preparatory Own Choice (for players who have not taken Grade 1 examination by the closing date of the Festival). ', '', 98, 11),
(44, 17, '202', 'Violin or Viola Solo - Grades 1 & 2 standard - Own Choice', '', 98, 11),
(45, 17, '203', 'Violin or Viola Solo - Grades 3 & 4 standard - Own Choice', '', 98, 11),
(46, 17, '204', 'Violin or Viola Solo - Grades 5 & 6 standard - Own Choice', '', 98, 11),
(47, 17, '205', 'Violin or Viola Solo - Advanced Own Choice. ', '', 98, 11),
(48, 17, '206', 'Cello, Harp or Double Bass Solo - Grade 1 & 2 standard - Own Choice', '', 98, 11),
(49, 17, '207', 'Cello, Harp or Double Bass Solo - Grade 3 & 4 standard - Own Choice', '', 98, 11),
(50, 17, '208', 'Cello, Harp or Double Bass Solo - Grade 5 & 6 standard - Own Choice ', '', 98, 11),
(51, 17, '209', 'Cello, Harp or Double Bass Solo - Advanced - Own Choice ', '', 98, 11),
(52, 17, '210', 'Violin, Viola, Cello, Double Bass, Harp Duet - Own Choice - no accompaniment. ', '', 10, 2),
(53, 17, '211', 'Violin, Viola, Cello, Double Bass, Harp Duet - Own Choice - no accompaniment. ', '', 14, 3),
(54, 17, '212', 'Violin, Viola, Cello, Double Bass, Harp Duet - Own Choice - no accompaniment. ', '', 98, 11),
(55, 33, 'NC13', 'Guitar (acoustic) or Ukulele solo -own choice', '', 99, 11),
(56, 33, '213', 'Guitar (acoustic) or Ukulele solo -own choice', '', 10, 2),
(57, 33, '214', 'Guitar (acoustic) or Ukulele solo -own choice', '', 14, 3),
(58, 33, '215', 'Guitar (acoustic) or Ukulele solo -own choice', '', 99, 11),
(59, 37, 'NC14', 'Brass or woodwind solo (including recorder) - own choice', '', 99, 11),
(60, 37, '216', 'Brass or woodwind solo (including recorder) - grade 1 & grade 2 standard - own choice', '', 99, 11),
(61, 37, '217', 'Brass or woodwind solo (including recorder) - grade 3 & grade 4 standard - own choice', '', 99, 11),
(62, 37, '218', 'Brass or woodwind solo (including recorder) - grade 5 & grade 6 standard - own choice', '', 99, 11),
(63, 37, '219', 'Brass or woodwind solo (including recorder) - advanced - own choice', '', 99, 11),
(64, 38, '220', 'Brass/woodwind/recorder duet or trio - own choice', '', 10, 2),
(65, 38, '221', 'Brass/woodwind/recorder duet or trio - own choice', '', 99, 11),
(66, 38, '222', 'Brass/woodwind/recorder ensemble - more than 3 players - own choice max 10 mins (unaccompanied)', '', 10, 8),
(67, 38, '223', 'Brass/woodwind/recorder ensemble - more than 3 players - own choice max 10 mins (unaccompanied)', '', 99, 13),
(68, 42, '224', 'Instrumental Ensemble up to 8 players. Any combination of instruments. Own Choice (time limit 10 minutes). ', '', 18, 9),
(69, 42, '225', 'Instrumental Ensemble over 8 players. Any combination of instruments. Own Choice (time limit 10 minutes). ', '', 18, 9),
(70, 14, 'NC15', 'Vocal solo - own choice ', '', 99, 11),
(71, 14, '226', 'Unaccompanied Folk Song - Own Choice', '', 99, 11),
(72, 14, '227', 'Opera, light opera, Operetta solo - own choice ', '', 99, 11),
(73, 14, '228', 'Solo song (inc Lieder, British composer, etc.) own choice', '', 99, 11),
(74, 14, '229', 'Novice solo ', '', 99, 11),
(75, 15, '230', 'vocal duet - any voices - own choice', '', 99, 12),
(76, 13, '300', 'Two or more related performers, children and/or adults, any combination of instrument/vocal. Extra marks given for widest age difference!', '', 99, 19),
(77, 57, '400', 'For the more experienced singer/player. The competitor should introduce and perform a varied programme for a maximum of 15 minutes. See Rule 3. ', '', 18, 10),
(78, 19, '500', 'Competitors should perform a varied programme for a maximum of 15 minutes. See Rule 3. ', '', 99, 15),
(79, 45, 'NC16', 'Verse Speaking from Memory. Own Choice. ', '', 12, 2),
(80, 45, 'NC17', 'Verse Speaking from Memory. Own Choice. ', '', 16, 3),
(81, 45, '301', 'Verse Speaking from Memory. Own Choice. ', '', 10, 2),
(82, 45, '302', 'Verse Speaking from Memory. Own Choice. ', '', 12, 2),
(83, 45, '303', 'Verse Speaking from Memory. Own Choice. ', '', 16, 3),
(84, 46, '304', 'Shared Poem from Memory. Own Choice. For 2 or 3 Performers. ', '', 10, 5),
(85, 46, '305', 'Shared Poem from Memory. Own Choice. For 2 or 3 Performers. ', '', 16, 5),
(86, 46, '306', 'Duologue from Memory. Own Choice (time limit 5 minutes). ', '', 10, 5),
(87, 46, '307', 'Duologue from Memory. Own Choice (time limit 5 minutes). ', '', 16, 5),
(88, 52, 'NC18', 'Prose Reading Own Choice (time limit 3 minutes). ', '', 10, 2),
(89, 52, 'NC19', 'Prose Reading Own Choice (time limit 3 minutes). ', '', 16, 3),
(90, 52, '308', 'Prose Reading Own Choice (time limit 3 minutes). ', '', 10, 2),
(91, 52, '309', 'Prose Reading Own Choice (time limit 3 minutes). ', '', 12, 2),
(92, 52, '310', 'Prose Reading Own Choice (time limit 3 minutes). ', '', 16, 3),
(93, 53, '311', 'Solo drama from memory. Any play other than Shakespeare', '', 10, 2),
(94, 53, '312', 'Solo drama from memory. Any play other than Shakespeare', '', 12, 2),
(95, 53, '313', 'Solo drama from memory. Any play other than Shakespeare', '', 16, 3),
(96, 50, '314', 'Shakespeare. Own Choice From Memory of any work by Shakespeare (time limit 5 minutes).', '', 12, 2),
(97, 50, '315', 'Shakespeare. Own Choice From Memory of any work by Shakespeare (time limit 5 minutes).', '', 16, 3),
(98, 54, '316', 'Mime - Own Choice (time limit 3 minutes). ', '', 10, 2),
(99, 54, '317', 'Mime - Own Choice (time limit 3 minutes). ', '', 12, 2),
(100, 54, '318', 'Mime - Own Choice (time limit 3 minutes). ', '', 16, 3),
(101, 52, '319', 'Public Speaking from Memory. A prepared talk of approximately 3 minutes on any aspect of the Competitor\'s work or interest ', '', 18, 4),
(102, 57, '600', 'A 10-minute recital of 3 Own Choice pieces to show 3 different aspects of Speech and Drama. See rule 3, At least one choice must be From Memory. Choices may include: Verse Speaking from Memory, Religious Reading from the Authorised Bible, Prose Reading, Shakespeare from Memory, Solo Drama from Memory, Sonnet from Memory or Public Speaking. ', '', 18, 4),
(103, 27, '131', 'Youth Choir - more than 10 voices Own Choice programme not exceeding 10 minutes.', '', 12, 17);

CREATE TABLE IF NOT EXISTS competitor (
id int(11) NOT NULL AUTO_INCREMENT,
contactid int(11) NOT NULL,
compname text NOT NULL,
age int(11),
specialneeds text NOT NULL,
extra text NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
INSERT INTO competitor (id, contactid, compname, age, specialneeds, extra) VALUES(3, 3, 'Saffron Charlesworth', 14, '', ''),
(5, 5, 'Hannah Moore', 15, '', ''),
(6, 6, 'Constance O\'Connell', 10, '', ''),
(7, 7, 'Matilda Fish', 12, '', ''),
(8, 7, 'Penelope Fish', 8, '', ''),
(9, 7, 'Matilda Fish and Olivia Edwards', 12, '', ''),
(10, 9, 'Mimi Elliott', 9, '', ''),
(11, 9, 'Elizabeth Elliott', 11, '', ''),
(12, 10, 'Charlotte Simpson', 14, '', ''),
(13, 10, 'Lan Hall', 16, '', ''),
(14, 10, 'Minnie Barker', 6, '', ''),
(15, 10, 'Toni Akeroyd', 13, '', ''),
(16, 10, 'Juno Mettam', 13, '', ''),
(17, 10, 'Marlene Mettam', 15, '', ''),
(18, 10, 'Vesey Manners', 10, '', ''),
(19, 10, 'Marlene Mettam and Emelia Percival', 15, '', ''),
(20, 10, 'Keira Sansam and Minnie Barker', 10, '', ''),
(21, 10, 'Marlene, Juno and Rezi Mettam', 15, '', ''),
(22, 10, 'Eliza Jackson, Isla Cox and Juno Mettam', 14, '', ''),
(23, 10, 'Emelia Percival, Marlene Mettam, Isla Cox, Juno Mettam, Eliza Jackson', 15, '', ''),
(24, 11, 'Estella Payne', 12, '', ''),
(25, 12, 'Hope Burch', 11, '', ''),
(26, 12, 'Zoe and Hope Burch', 13, '', 'Duet - aged 13 and 11'),
(27, 13, 'Olivia Edwards', 12, '', ''),
(28, 14, 'Yong - Xi Lucius Xu', 8, '', ''),
(29, 15, 'Isla Turnbull', 8, '', ''),
(30, 16, 'Barny Buston', 16, '', ''),
(31, 17, 'Maisie McIntyre', 10, '', ''),
(32, 18, 'Clara Burch', 7, '', ''),
(33, 18, 'Zoe and Hope Burch', 13, '', '2 sisters (13 and 11) performing together'),
(34, 19, 'Emma Ball', 9, '', ''),
(35, 20, 'Martha Short', 9, '', ''),
(36, 21, 'Alexandria Boardman', 7, '', ''),
(37, 21, 'Alexander Hopkins', 10, '', ''),
(38, 21, 'Elizabeth Boardman', 11, '', ''),
(39, 21, 'Angelo Palmer', 12, '', ''),
(40, 21, 'Harris Zhu', 12, '', ''),
(41, 21, 'Adeline An', 15, '', ''),
(42, 22, 'Karl Morewood', 17, '', ''),
(43, 23, 'Benjamin Giliker', 14, '', ''),
(44, 24, 'Harriet Longden', 10, '', ''),
(45, 25, 'Dolly Williamson', 8, '', ''),
(46, 26, 'Jude Everett', 10, '', ''),
(47, 26, 'Talia Brett', 9, '', ''),
(48, 26, 'Constance O\'Connell', 10, '', ''),
(49, 26, 'Minnie Barker', 6, '', ''),
(50, 26, 'Sophie Maunsell', 8, '', ''),
(51, 26, 'Amelia Torpey', 8, '', ''),
(52, 26, 'Amelie Beatson', 11, '', ''),
(53, 26, 'Lena Fredrick', 11, '', ''),
(54, 26, 'Leo Hamlett', 11, '', ''),
(55, 26, 'Eva Ayre', 11, '', ''),
(56, 26, 'Keira Sansam', 9, '', ''),
(57, 26, 'Elliott Sansam', 11, '', ''),
(58, 26, 'Anna Daniel', 12, '', ''),
(59, 26, 'Beatrice O\'Connell', 14, '', ''),
(60, 26, 'Sophie Wilcox', 14, '', ''),
(61, 26, 'Olivia Taylor Shaw', 12, '', ''),
(62, 26, 'Phoebe Blowen', 13, '', ''),
(63, 26, 'Sophie Wilcox and Beatrice O\'Connell', 14, '', ''),
(64, 26, 'Amelie Beatson and Leo Hamlett', 11, '', ''),
(65, 26, 'Constance O\'Connell and Jude Everett', 10, '', ''),
(66, 26, 'Anna Daniel and Olivia Taylor', 13, '', ''),
(67, 26, 'Minnie and Lulu Barker', 6, '', ''),
(68, 27, 'Una Stephenson', 8, '', ''),
(69, 27, 'Sophie Maunsall', 8, '', ''),
(70, 27, 'Charlotte Crease', 8, '', ''),
(71, 28, 'Isabel Hodges', 14, '', ''),
(72, 29, 'Amica Kuroda', 17, '', '');

CREATE TABLE IF NOT EXISTS contact (
id int(11) NOT NULL AUTO_INCREMENT,
name text NOT NULL,
address text NOT NULL,
email text NOT NULL,
phone text NOT NULL,
password int(11) NOT NULL,
sum_due decimal(5,2) NOT NULL,
Added date NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
INSERT INTO contact (id, name, address, email, phone, password, sum_due, Added) VALUES
(3, 'Sally Charlesworth', '1 Taxal View\r\nFernilee\r\nWhaley Bridge', 'info@charlesworthaccountants.co.uk', '+447449747988', 56895, '9.50', '2024-02-04'),
(5, 'Catriona Moore', '2 Todbrook Close\r\nWhaley Bridge', 'catrionarmoore@gmail.com', '+447972627472', 97486, '9.50', '2024-02-06'),
(6, 'Caroline O\'Connell', 'May Cottage\r\nThe Nook\r\nEyam\r\nHope Valley \r\nS32 5AB', 'readcaroline@aol.com', '07739348222', 82278, '12.50', '2024-02-12'),
(7, 'Kirsty Fish', 'Craigmore\r\nCalver Road\r\nBaslow\r\nDE45 1RR', 'kirstyfish@hotmail.com', '07760266752', 96796, '51.25', '2024-02-15'),
(8, 'Oona Gilbertson', 'Eyam CE Primary School\r\nChurch Street\r\nEyam S32 5QH', 'ogilbertson@eyam.derbyshire.sch.uk', '01433630840', 95846, '50.00', '2024-02-21'),
(9, 'Louise Elliott', '192 Station Road\r\nBrimington\r\nChesterfield\r\nDerbyshire\r\nS43 1LT', 'louise100elliott@hotmail.com', '07513362655', 35983, '25.00', '2024-02-21'),
(10, 'Amanda Kornas', '4 Old Hall Close\r\nDarley Dale\r\nDerbyshire\r\nDE4 2TX', 'amanda.kornas@btinternet.com', '07927 622335', 58252, '166.25', '2024-02-22'),
(11, 'Caroline Payne', 'The Homestead \r\nWormhill\r\nBuxton\r\nSk17 8SL', 'carolinemarypayne@gmail.com', '07773818430', 43409, '16.00', '2024-02-24'),
(12, 'Patrick Burch', 'Roods Farm, Foolow, Eyam, S32 5QR', 'patrick.burch@doctors.org.uk', '07989308741', 64800, '47.75', '2024-02-26'),
(13, 'Rebecca Edwards', '14 Gorse Ridge Drive\r\nBaslow\r\nDerbyshire\r\nDE45 1SL', 'cedwards8@sky.com', '07950 744254', 10331, '24.00', '2024-02-26'),
(14, 'Mei-Huei Lee', '40 Dane Close\r\nAlsager\r\nST7 2HZ', 'f9355420@gmail.com', '07878092095', 41097, '15.00', '2024-02-27'),
(15, 'Danielle Turnbull', '6, Church view drive, Baslow. DE451RA', 'danniturnbull84@gmail.com', '07467035756', 90414, '24.00', '2024-02-28'),
(16, 'Anne Buston', '16 Lismore Road\r\nBuxton\r\nSK17 9AZ', 'anniebuston@hotmail.com', '01298 212468', 52841, '9.50', '2024-02-28'),
(17, 'Maisie McIntyre', 'Woodside \r\nOver Lane \r\nBaslow \r\nDE45 1RT', 'caroline.mcintyre@outlook.com', '07525289486', 98054, '24.00', '2024-02-29'),
(18, 'Sophie Burch', 'Roods Farm, Foolow, Eyam, S32 5QR', 'sophie.burch@doctors.org.uk', '07989308741', 60465, '26.25', '2024-02-29'),
(19, 'Tracy Ball', '70 Chesterfield Road\r\nTibshelf \r\nAlfreton \r\nDerbyshire \r\nDE55 5NL', 'Tracy@chesterfield.plus.com', '07540 706106', 52976, '12.50', '2024-02-29'),
(20, 'Kathryn Smith', 'Ridgeway,\r\nCliff Lane,\r\nCalver,\r\nS32 3WD', 'katysmith73@yahoo.co.uk', '07778334039', 90462, '24.00', '2024-02-29'),
(21, 'Jason Curteis', 'Combs Head Farm\r\nCombs', 'jasoncurteis@yahoo.com', '07983997253', 18783, '49.00', '2024-02-29'),
(22, 'Georgina Morewood', 'Primrose Cottage\r\n4 Buxton Road\r\nBakewell\r\nDerbyshire\r\nDE45 1DA', 'georgina.morewood@gmail.com', '07979662655', 61292, '43.75', '2024-03-01'),
(23, 'Peter Giliker', '20 Sycamore Close\r\nBuxton\r\nSK176FB', 'pgiliker@btopenworld.com', '07887843754', 80561, '9.50', '2024-03-01'),
(24, 'Georgina Abdy (mother)', 'White Lodge\r\nCalver Road\r\nBaslow DE45 1RR', 'georgina@worldwideglobemaster.com', '07775 898814', 28615, '24.00', '2024-03-01'),
(25, 'Emily Williamson', 'Kingscroft Farm\r\nMiddleton by Youlgreave \r\nBakewell\r\nDE45 1LS', 'emily.williamson@ymail.com', '07516265918', 33464, '16.00', '2024-03-01'),
(26, 'Emma Hopkins', '2 New Cottages \r\nSaint Johns Rd\r\nTideswell\r\nSK17 8NE', 'emmahopkins@hotmail.com', '07814732726', 46879, '274.00', '2024-03-01'),
(27, 'Emma Hopkins', '2 New Cottages \r\nSaint Johns Rd\r\nTideswell', 'emmahopkins@hotmail.com', '07814732726', 11919, '64.62', '2024-03-03'),
(28, 'Rhonda Hodges', '', 'rhonda_hodges@hotmail.co.uk', '07817717333', 92205, '28.50', '2024-03-03'),
(29, 'Emiko Kuroda', '26 St. Nicholas Place,\r\nMilford Street,\r\nDerby\r\nDE1 3GD', 'emiko.kuroda@yahoo.com', '07704653268', 97669, '20.00', '2024-03-20');

CREATE TABLE IF NOT EXISTS cost (
ID int(11) NOT NULL AUTO_INCREMENT,
type text,
class text,
cost decimal(5,2),
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
INSERT INTO cost (ID, type, class, cost) VALUES
(1, 'Child', 'Solo – up to 8 years old', 7.50),
(2, 'Child', 'Solo – 9, 10. 11 and 12 years old', 8.00),
(3, 'Child', 'Solo – 13, 14, 15 and 16 years old', 9.50),
(4, 'Child', 'Solo – 17 and 18 years old', 10.00),
(5, 'Child', 'Duet / duologue (per pair)', 11.25),
(6, 'Child', 'Trio /quartet (per group)', 15.00),
(7, 'Child', 'Piano sight reading', 6.25),
(8, 'Child', 'Ensemble – 15 years and under', 18.75),
(9, 'Child', 'Ensemble – over 15 yrs', 11.25),
(10, 'Recital', 'Recital Classes Nos 308, 316, 451', 18.75),
(11, 'Adult', 'Solo', 12.50),
(12, 'Adult', 'Duet (per duet)', 15.00),
(13, 'Adult', 'Ensemble – up to 8 performers', 31.25),
(14, 'Adult', 'Ensemble – over 8 performers', 31.25),
(15, 'Adult', 'Recital Class (500)', 31.25),
(16, 'Choirs', 'Schools', 31.25),
(17, 'Choirs', 'Youth', 31.25),
(18, 'Choirs', 'Adult', 37.50),
(19, 'Family', 'Family Class', 18.75);