This is incorrect. The inner joins should be left joins because you were specifically asked to return all statuses even if they didn't have a tag. Your query would return statuses for which there is both a status and a tag. Also, you didn't need the name attribute.