begin; INSERT INTO songs (title,artist,minbpm,maxbpm) VALUES ('I Want You to Want Me','Solid Harmonie',104,104); 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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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;