switched the chaining logic to avoid joins which can take a long time.  this is now using more sub-select queries which is much faster.  also now supporting shortcuts for reverse lookups and pipes