`SELECT COUNT(n.notification_read) AS unread_count, COUNT(n.notification_id) AS total_count` and you'll get both?