-INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','beginner',3);
-INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','standard',3);
-INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','difficult',5);
-INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'single','expert',6);
-INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'double','standard',3);
-INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'double','difficult',4);
-INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),'double','expert',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','beginner',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','difficult',5);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'single','expert',6);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','standard',3);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','difficult',4);
+INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='5, 6, 7, 8'),(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'),'double','expert',6);