added join queries for blank tickets
wtf