This is incorrect. This will return the tag whose name has the highest ASCII value. Perhaps, you meant the tag_id, which would have been incorrect as well. MAX(tag_id) will return the tag_id with the highest numerical value, not the tag_id associated with the most statuses.