Someone
public sql v1 · immutable-- 1054: Unknown column 'hl.requestid' in 'on clause' SELECT s.id as track_id, s.title, s.duration, hl.date_played, hl.requestid AS request_id, r.user_name FROM samdb.historylist AS hl, samdb.songlist AS s LEFT JOIN subsonic_radio.request_points_used AS r ON r.request_id = hl.requestid WHERE hl.songid = s.id AND s.songtype = 'S' ORDER BY hl.date_played DESC LIMIT 1