SELECT * FROM tiet_user_settings INNER JOIN (SELECT userId, settingId, MAX(created) AS created FROM tiet_user_settings GROUP BY userId, settingId) USING (userId, settingId, created) WHERE userId = ?;