Another day, another case of "I think I'm just going to do this in application code because I'm sick of dealing with SQL JOINs"