possible fix for v large element sets with lots of duplicated db join elements, fullname subquery was producing max join error