Rainwave SQL / Find and delete duplicate song ratings

rw_del_dup_rating.sql

delete from
  r4_song_ratings
where
  ctid in (
    select
      min(ctid)
    from
      r4_song_ratings
    where
      user_id = %s and
      song_id = %s
  );

rw_find_dup_ratings.sql

select
  user_id,
  username,
  song_id,
  count(song_id)
from
  r4_song_ratings
    join
  phpbb_users using (user_id)
group by
  user_id,
  username,
  song_id
having
  count(song_id) > 1;