@shackbarth 
Can you double check this change?  

You made this change here:
https://github.com/xtuple/xtuple/commit/863e216f029a84d5d940cc3f88b51dfdad4cdfaf#diff-9677c888e71950eb1b8724fd787c8278R97
But there was no jt0.  This adds it as `sidejoin` so it doesn't conflict if clause.joins is set, because if it is, jt0 will already be taken.

This problem exists when param.keySearch isn't set.  I don't know if it will also exists if it is set. in this section:
https://github.com/xtuple/xtuple/blob/acb1b1f14f56b7d21cf29c0bea260d6520aa1b29/enyo-client/database/source/xm/javascript/item_site.sql#L55-L73