CREATE INDEX songratings_feetrating ON songratings ( feetrating );
);
CREATE INDEX songratings_feetrating ON songratings ( feetrating );
+CREATE VIEW max_single_feetrating AS SELECT machine,song,MAX(feetrating) AS feetrating FROM songratings WHERE playmode='single' GROUP BY machine,song;