root@db1176.eqiad.wmnet[mediabackups]> START TRANSACTION; select count(*), status_name, backup_status_name FROM files JOIN wikis ON wikis.id = files.wiki JOIN backup_status ON backup_status.id = files.backup_status JOIN file_status ON files.status = file_status.id WHERE wiki=392 GROUP BY status, backup_status; select count(*), TIMESTAMPDIFF(MINUTE, '2021-09-03 07:30:00', max(backup_time)) as time, count(*)/ TIMESTAMPDIFF(SECOND, '2021-09-03 07:30:00', max(backup_time)) as speed from backups where wiki=392 and backup_time >= '2021-09-03 07:30:00'; select count(*), sum(size) from files where wiki=392 and backup_status=3; COMMIT;