Try the update table join and group days by the screenshot's timestamp instead to try again to speed up the big SELECT statement on the SiteDetail query