Got quite a way, until hitting wall on inner join and composite criteria
Got criteria version of one method working
made headway with criteria queries; still stuck on joining subselect