lol inner joins are slow. learned that the fun way.