the prestigious triple join

finally, the span of tables has been sped through the use of a join
that will enhance our json capabilities! or so i've heard