I believe I uncovered the query that was gumming up the works, and may have found a solution.