move key WQL restrictions from WHERE/IN to JOIN

the two methods above make it easier to move fluidly between WHERE handling and JOIN handling.  In general, the thought was to move ALL of the subselects into JOIN clauses.  Not sure whether any exceptions remain.