INSERT INTO tbl
SELECT td_client_id, td_global_id, MAX(time) as last_access FROM pageviews
GROUP BY 1,2