SELECT
  SongID,
  si.StationID,
  si.name,
  ss.rank,
  si.badgetype
FROM
  masterdb.stationsongs ss
  left join masterdb.stationinfo si on si.StationID = ss.StationID
where
  ss.CTType = 'CT_RADIO'
  and si.CTType = 'CT_RADIO'
  and ss.SongID in(1, 2, 3, 4, 5, 6, 7, 8)
order by
  si.StationID desc