SELECT COUNT(*)
FROM USERS US
JOIN MESSAGES M ON US.USERID = M.USERID
JOIN MESSAGEURIS MU ON M.MESSAGEID = MU.MESSAGEID
JOIN URIS UR ON MU.URIID = UR.URIID
WHERE USERNAME = 'amp88';
COUNT(*)
10639
(1 row, 0 ms)