This is incorrect. The first 'join' should have been a left join. You're missing all of the statuses that don't have tags. Your results yielded 1,553 records. However, the statuses table has 3,012 records, so obviously some statuses are missing.