look on the row for a custom col
call function to enable child lookup inside same query
scope those to the table name as well
add in left join to check for children within the same query
join conditions and grouping on the results
the sub select seems to be much faster that join, use that