From 4a799e1af4aa5deaa6b4196e402da864a2baeb37 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Fri, 18 Feb 2005 15:33:29 +0000 Subject: [PATCH] Update the wiki parser and the EM2 SQL to match the new feet rating data. --- parse/parse-wiki-songlist.pl | 7 +- sql/em2-songlist.sql | 952 +++++++++++++++++------------------ 2 files changed, 481 insertions(+), 478 deletions(-) diff --git a/parse/parse-wiki-songlist.pl b/parse/parse-wiki-songlist.pl index 5a35d67..4303c2d 100644 --- a/parse/parse-wiki-songlist.pl +++ b/parse/parse-wiki-songlist.pl @@ -2,6 +2,9 @@ use strict; use warnings; +my $machine = shift; +die "Missing machine (first argument on the command line)" if (!defined($machine)); + # Parses songlist from the DDRNO wiki print "begin;\n"; @@ -45,8 +48,8 @@ while (<>) { ['double', 'standard', $ds], ['double', 'difficult', $dd], ['double', 'expert', $de]) { - printf "INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='%s'),'%s','%s',%u);\n", - $songname, $t->[0], $t->[1], $t->[2]; + printf "INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='%s'),(SELECT machine FROM machines WHERE machinename='%s'),'%s','%s',%u);\n", + $songname, $machine, $t->[0], $t->[1], $t->[2]; } } diff --git a/sql/em2-songlist.sql b/sql/em2-songlist.sql index 473841c..a5bacd8 100644 --- a/sql/em2-songlist.sql +++ b/sql/em2-songlist.sql @@ -1,546 +1,546 @@ begin; INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('I Want You to Want Me','Solid Harmonie',104,104); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),'single','expert',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),'double','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),'double','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='I Want You to Want Me'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Aaron\'s Party (Come Get It)','Aaron Carter',117,117); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),'double','standard',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),'double','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),'double','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Aaron\'s Party (Come Get It)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('www.blonde girl (MOMO Mix)','Jenny Rom',170,170); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),'single','standard',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),'single','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),'double','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='www.blonde girl (MOMO Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('That was Then, This is Now','Hi-Five',103,103); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),'single','expert',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),'double','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='That was Then, This is Now'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('The Vibe is Right','Ruby Turner',116,116); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),'double','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),'double','expert',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Vibe is Right'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',5); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Caribbean Queen','Billy Ocean',115,115); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),'double','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),'double','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Caribbean Queen'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('5, 6, 7, 8','Steps',140,140); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','expert',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'double','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'double','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Cotton-Eye Joe','Rednex',132,132); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),'double','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Cotton-Eye Joe'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Stomp','Steps',130,130); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),'double','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Stomp'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('The Centre of the Heart (Stonebridge Club Mix)','Roxette',128,128); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Centre of the Heart (Stonebridge Club Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('The Reflex','Duran Duran',126,126); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='The Reflex'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Test My Best','E-ROTIC',147,147); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),'single','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Test My Best'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Love You Like A Fool','Jessica Folker',183,183); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love You Like A Fool'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Never Gonna Make (Factory Team Mix)','Morgana',136,136); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Gonna Make (Factory Team Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Nori Nori Nori','Judy Crystal',160,160); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Nori Nori Nori'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Don\'t Try to Stop It','Roman Holiday',192,192); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Don\'t Try to Stop It'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Never Ending Story','DJ-AC-DC',140,140); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Ending Story'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Living In America','Rose & John',169,169); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Living In America'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('So Deep (Perfect Sphere Mix)','Silvertear',140,140); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='So Deep (Perfect Sphere Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Remember You','NM feat. Julie',55,105); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),'single','standard',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),'single','difficult',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),'single','expert',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),'double','standard',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),'double','difficult',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),'double','expert',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Remember You'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',5); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Secret Rendez-vous','Divas',98,98); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Secret Rendez-vous'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Spin the Disc','good-cool',130,130); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Spin the Disc'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Higher','NM feat. Sunny',132,132); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),'single','expert',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Higher'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Let the Beat Hit \'em!','Stone Bros.',110,110); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let the Beat Hit \'em!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Look to the Sky','System SF feat. Anna',140,140); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Look to the Sky'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Rain of Sorrow','NM feat. Ebony Fay',140,140); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Rain of Sorrow'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Can\'t Stop Fallin\' in Love','Naoki feat. Paula Terry',155,155); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),'double','difficult',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('D2R','Naoki',160,160); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='D2R'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Destiny','Naoki feat. Paula Terry',155,155); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Destiny'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Never Let You Down','good-cool feat. JP Miles',125,125); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Never Let You Down'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Memories','Naoki feat. Paula Terry',155,155); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),'double','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Memories'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('My Summer Love','Mitsu-O feat. Geila',100,100); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='My Summer Love'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Groove 2001','Sho-T feat. Brenda',140,140); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Groove 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Vanity Angel','Fixx',140,140); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Vanity Angel'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('B4U','Naoki',155,155); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('B4U (B4 Za Beat Mix)','Naoki',170,170); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='B4U (B4 Za Beat Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Ecstasy','d-Complex',0,150); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Ecstasy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('era (nostalmix)','TaQ',90,180); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='era (nostalmix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Hysteria 2001','NM',190,190); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hysteria 2001'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Burnin\' the Floor','Naoki',155,155); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Burnin\' the Floor'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Candy','Luv UNLIMITED',192,192); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Candy'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Crash!','mr. Brian & The Final Band',200,200); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Crash!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('DXY!','TaQ',148,148); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='DXY!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Exotic Ethnic','RevenG',190,190); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Exotic Ethnic'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Tsugaru','RevenG vs DE-SIRE',94,165); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Tsugaru'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Afronova Primeval','8 bit',200,200); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova Primeval'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Can\'t Stop Fallin\' in Love (SPEED MIX)','Naoki feat. Paula Terry',170,170); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Can\'t Stop Fallin\' in Love (SPEED MIX)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Electro Tuned (the SubS Mix)','TaQ',116,125); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Electro Tuned (the SubS Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Hypnotic Crisis','Blue Destroyers',135,135); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Hypnotic Crisis'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Healing Vision (Angelic Mix)','2MB',49,196); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Healing Vision (Angelic Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Trip Machine Climax','DE-SIRE',180,180); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine Climax'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Max 300','Omega',300,300); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),'single','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),'single','difficult',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),'single','expert',10); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),'double','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),'double','difficult',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),'double','expert',10); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',10); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Max 300'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',10); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('20th November','N.M.R feat. DJ Naguaro',130,130); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='20th November'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Keep On Movin\'','N.M.R',132,132); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),'single','expert',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Keep On Movin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Let Them Move','N.M.R',115,115); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Let Them Move'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Silent Hill','Thomas Howard',125,125); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),'double','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Silent Hill'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',7); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Jam Jam Reggae (AM Swing Mix)','Rice. C feat. Jam master 73',90,90); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),'single','standard',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),'double','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Jam Jam Reggae (AM Swing Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Make A Jam!','U1',124,124); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),'single','standard',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),'single','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),'double','difficult',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Make A Jam!'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('La Senorita','Captain T',182,182); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),'single','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),'single','expert',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),'double','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='La Senorita'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Luv to Me (AMD Mix)','DJ Kazu feat. Tiger YAMATO',154,154); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Luv to Me (AMD Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Love This Feelin\'','Chang Ma',95,190); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),'single','beginner',1); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),'single','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),'double','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Love This Feelin\''),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Dynamite Rave','Naoki',150,150); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dynamite Rave'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('End of the Century','No. 9',171,171); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),'single','standard',4); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),'double','difficult',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='End of the Century'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Dead End','N&S',190,190); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),'double','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),'double','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Dead End'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',8); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Paranoia KCET (Clean Mix)','2MB',180,180); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Paranoia KCET (Clean Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Afronova','RevenG',200,200); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),'single','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),'double','standard',5); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),'double','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Afronova'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('Trip Machine (Luv Mix)','2MB',160,160); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),'single','beginner',2); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),'single','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),'single','expert',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),'double','standard',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),'double','difficult',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',2); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='Trip Machine (Luv Mix)'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('PARANOiA Rebirth','190\'',190,190); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),'single','beginner',3); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),'single','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),'single','difficult',7); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),'single','expert',9); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),'double','standard',6); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),'double','difficult',8); -INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),'double','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='PARANOiA Rebirth'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',9); commit; -- 2.39.2